Group integer vector into consecutive runs

by

Here’s a brief answer using aggregate….

runs <- cumsum( c(0, diff(my.data$V2) > 1) )
aggregate(V2 ~ runs + V1, my.data, range)[,-1]


  V1 V2.1 V2.2
1  1    2    5
2  1    7   11
3  1   13   13
4  2    4    9
5  2   11   13
6  3    1    6
7  3  101  105

More Related Contents:

  1. How to sum a variable by group
  2. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  3. Collapse / concatenate / aggregate a column to a single comma separated string within each group
  4. Mean per group in a data.frame [duplicate]
  5. Count number of rows within each group
  6. Faster ways to calculate frequencies and cast from long to wide
  7. Count number of rows per group and add result to original data frame
  8. Apply several summary functions on several variables by group in one call
  9. Extract row corresponding to minimum value of a variable by group
  10. Summarizing multiple columns with dplyr? [duplicate]
  11. Extract the maximum value within each group in a dataframe [duplicate]
  12. Group by multiple columns and sum other multiple columns
  13. Select the first and last row by group in a data frame
  14. Select the top N values by group
  15. Apply function conditionally
  16. Summarizing by subgroup percentage in R
  17. Collapsing rows where some are all NA, others are disjoint with some NAs
  18. Aggregate a data frame based on unordered pairs of columns
  19. Aggregate and reshape from long to wide
  20. Get the means of sub groups of means in R
  21. Apply several summary functions (sum, mean, etc.) on several variables by group in one call
  22. Aggregate data in R
  23. aggregate() puts multiple output columns in a matrix instead
  24. R sum a variable by two groups [duplicate]
  25. data.frame Group By column [duplicate]
  26. R use ddply or aggregate
  27. Combining duplicated rows in R and adding new column containing IDs of duplicates
  28. Run a custom function on a data frame in R, by group
  29. Aggregate by week in R
  30. How can I count the number of NAs per group?

Leave a Comment