[R] rowsum
    xtracto 
    b2017700 at lhsdv.com
       
    Wed Oct 20 11:42:35 CEST 2010
    
    
  
Hello,
I am trying to achieve something which I *think* is possible using rowsum,
but a little help should be useful:
Consider the following dataframe DF0: 
A	B	C
89	1	140
89	06	20
89	29	137
89	52	13
89	57	10
89	97	23
89	1	37
89	1	12
89	1	3
52	1	11
52	1	31
52	1	16
52	1	6
52	1	10
52	1	13
52	1	10
52	1	25
52	1	2
52	59	38
52	97	75
57	1	14
57	1	13
57	1	14
57	114	12
57	1	23
57	06	26
I need create a new dataframe containing the sums of all the rows where B =
1 for the different values of A, keeping the rows with other B values the
same. That is, for this data sample, the result I expect is something like
this (the order of the rows does not matter):
A	B	C
89	1	192    #From adding up: [140 + 37 + 12 + 3]
89	06	20
89	29	137
89	52	13
89	57	10
89	97	23
52	1	124    # From adding up: [11 + 31 + 16 + 6 + 10 + 13 + 10 + 25 + 2]
52	59	38
52	97	75
57	1	64     #From adding up: [14 +13 +14 +23]
57	114	12
57	06	26
Now, I now it should be possible to first separate the data in two sets,
where 
DF1 <- DF0[DF0$B != 1,] 
DF2 <- DF0[DF0$B == 1,] 
Then I should apply sumrow to DF2 with some "group" vector, but I do not
know where to go from here. 
Can anyone help? 
Thanks in advance!
-- 
View this message in context: http://r.789695.n4.nabble.com/rowsum-tp3003551p3003551.html
Sent from the R help mailing list archive at Nabble.com.
    
    
More information about the R-help
mailing list