Cumulative sum rows in data.frame

Asked Aug 27 '18 at 11:03

Active Aug 27 '18 at 11:21

Viewed 699 times

I have a data.frame like

df    
    l a b c
1  Hi 1 2 3
2 Med 3 1 -3
3  LO 2 -1 0

And I would like to calculate its cumulative sum by row , that is, I want the result to be:

df    
    l a b c
1  Hi 1 3 6
2 Med 3 4 1
3  LO 2 1 1

Thanks!

edited Aug 27 '18 at 11:09

asked Aug 27 '18 at 11:03

VetalDem

1

I need a cumulative amount of rows in df – VetalDem Aug 27 '18 at 11:15
This should help `t(apply(df[,-1],1,function(x)cumsum(x)))` – A. Suliman Aug 27 '18 at 11:17
@Tim Biegeleisen, OP ask to operate a function over rows not over variable group. – A. Suliman Aug 27 '18 at 11:19
@A.Suliman The OP _changed_ its question. At the time I marked, it was appropriate. Even now, it may be a dupe of another question. – Tim Biegeleisen Aug 27 '18 at 11:22
@TimBiegeleisen maybe is a duplicate, just connected to the correct duplicated question. – A. Suliman Aug 27 '18 at 11:26
@A.Suliman, As a result, no col = l – VetalDem Aug 27 '18 at 11:43
You can do `df[,2:ncol(df)] <- t(apply(df[,-1],1,function(x)cumsum(x)))` – A. Suliman Aug 27 '18 at 11:55
@A.Suliman, Thank you – VetalDem Aug 27 '18 at 11:57

0 Answers0