How to add a cumulative column to an R dataframe using dplyr?

by

Like this?

df <- data.frame(id = rep(1:3, each = 5),
                 hour = rep(1:5, 3),
                 value = sample(1:15))

mutate(group_by(df,id), csum=cumsum(value))

Or if you use the dplyr‘s piping operator:

df %>% group_by(id) %>% mutate(csum = cumsum(value))

Result in both cases:

Source: local data frame [15 x 4]
Groups: id

   id hour value csum
1   1    1     4      4
2   1    2    14     18
3   1    3     8     26
4   1    4     2     28
5   1    5     3     31
6   2    1    10     10
7   2    2     7     17
8   2    3     5     22
9   2    4    12     34
10  2    5     9     43
11  3    1     6      6
12  3    2    15     21
13  3    3     1     22
14  3    4    13     35
15  3    5    11     46

More Related Contents:

  1. R spreading multiple columns with tidyr [duplicate]
  2. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  3. dplyr filter with condition on multiple columns
  4. Get last row of each group in R [duplicate]
  5. R – add column that counts sequentially within groups but repeats for duplicates
  6. Change value of variable with dplyr
  7. dplyr – filter by group size
  8. Merge rows in a dataframe where the rows are disjoint and contain NAs
  9. Calculate group mean while excluding current observation using dplyr
  10. mutate_each / summarise_each in dplyr: how do I select certain columns and give new names to mutated columns?
  11. finding close match from data frame 1 in data fame 2
  12. dplyr change many data types
  13. Join two data frames in R based on closest timestamp
  14. How to dplyr rename a column, by column index?
  15. How to add only missing Dates in Dataframe
  16. Override column types when importing data using readr::read_csv() when there are many columns
  17. Adding column if it does not exist
  18. How does one access the piped data.frame in dplyr::funs?
  19. Filter multiple values on a string column in dplyr
  20. Sample random rows in dataframe
  21. Subset / filter rows in a data frame based on a condition in a column
  22. Replacing character values with NA in a data frame
  23. Coerce multiple columns to factors at once
  24. Delete rows that exist in another data frame? [duplicate]
  25. How to delete rows where all the columns are zero
  26. Convert a dataframe to a vector (by rows)
  27. How to deal with nonstandard column names (white space, punctuation, starts with numbers)
  28. Transposing a dataframe maintaining the first column as heading
  29. Filter data frame rows based on values in vector
  30. Replace empty values with value from other column in a dataframe

Leave a Comment