Sum up all previous values in column

Question

I feel like this questions should have been answered before, but I fail to find the answer. I want to do a very simple operation in R with a data frame: For each row in ascending order, I want to sum up all the values above (i.e. make a total up to this observation). However, using lag(), I fail to do this. Any suggestions?

Have a look at `cumsum()` – Andrew Gustar Oct 06 '20 at 19:40 — Andrew Gustar, Oct 06 '20 at 19:40

score 0 · Accepted Answer · answered Oct 06 '20 at 19:48

0

As Andrew Gustar mentions, e.g.,

cars <- mtcars
cumcyl <- cumsum(cars$cyl)
cars <- cbind(cars, cumcyl)

answered Oct 06 '20 at 19:48

SteveM

2,226
3
12
16

3

or just `cars$cumcyl <- cumsum(cars$cyl)`, no need for the intermediate variable. – r2evans Oct 06 '20 at 20:05

Sum up all previous values in column

1 Answers1