Cumulative count of each value [duplicate]

by

The ave function computes a function by group.

> id <- c(1,2,3,2,2,1,2,3)
> data.frame(id,count=ave(id==id, id, FUN=cumsum))
  id count
1  1     1
2  2     1
3  3     1
4  2     2
5  2     3
6  1     2
7  2     4
8  3     2

I use id==id to create a vector of all TRUE values, which get converted to numeric when passed to cumsum. You could replace id==id with rep(1,length(id)).

More Related Contents:

  1. Count number of rows per group and add result to original data frame
  2. Counting the number of elements with the values of x in a vector
  3. Add count of unique / distinct values by group to the original data
  4. Include levels of zero count in result of table()
  5. Count number of occurences for each unique value
  6. Create counter within consecutive runs of values
  7. How can I count runs in a sequence?
  8. How to calculate cumulative sum? [duplicate]
  9. Count non-NA values by group [duplicate]
  10. Count number of rows by group using dplyr
  11. R cumulative sum by condition with reset
  12. How to count the frequency of a string for each row in R
  13. Extend contigency table with proportions (percentages)
  14. Find the n most common values in a vector [duplicate]
  15. Find the most frequent value by row
  16. Tidyr how to spread into count of occurrence [duplicate]
  17. Calculate cumulative average (mean)
  18. Count number of columns by a condition (>) for each row
  19. Count unique values for every column
  20. How can I count the number of NAs per group?
  21. Extracting the last n characters from a string in R
  22. How to convert integer number into binary vector?
  23. How can I add hatches, stripes or another pattern or texture to a barplot in ggplot?
  24. longest common substring in R finding non-contiguous matches between the two strings
  25. Apply a function to every row of a matrix or a data frame
  26. Convert four digit year values to class Date
  27. Increase resolution of color scale for values close to zero
  28. Merging rows with the same ID variable [duplicate]
  29. Remove plot axis values
  30. How to extract substring between patterns “_” and “.” in R [duplicate]

Leave a Comment