[R] Using cumsum with 'group by' ?

TheRealJimShady james.david.smith at gmail.com
Thu Nov 22 18:08:37 CET 2012


Hi,

First post here. Grateful for any help you can give. I have data which looks
like this:

id    time    x
1   12:01    5
1   12:02   14
1   12:03   6
1   12:04   3
2   12:01   98
2   12:02   23
2   12:03   1
2   12:04   4
3   12:01   5
3   12:02   65
3   12:03   23
3   12:04   23

But I want to add a column which is the cumulative sum of X, but only by id.
I've used cumsum before, but not in this way. So the result should be
something like:

id       time      x        cumsum
1      12:01       5        5
1      12:02      14      19 
1      12:03      6         25
1      12:04      3         28
2      12:01      98       98  
2      12:02      23       121
2      12:03      1         122
2      12:04      4         126
3      12:01      5          5
3      12:02      65       70
3      12:03      23       93 
3      12:04      23       116

Any ideas please?




--
View this message in context: http://r.789695.n4.nabble.com/Using-cumsum-with-group-by-tp4650457.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list