generate sequence within group in R [duplicate]

by

Use ave with seq_along:

> mydf$C <- with(mydf, ave(A, A, B, FUN = seq_along))
> mydf
  A B C
1 1 1 1
2 1 2 1
3 1 2 2
4 1 3 1
5 1 3 2
6 1 3 3
7 1 4 1
8 1 4 2

If your data are already ordered (as they are in this case), you can also use sequence with rle (mydf$C <- sequence(rle(do.call(paste, mydf))$lengths)), but you don’t have that limitation with ave.

If you’re a data.table fan, you can make use of .N as follows:

library(data.table)
DT <- data.table(mydf)
DT[, C := sequence(.N), by = c("A", "B")]
DT
#    A B C
# 1: 1 1 1
# 2: 1 2 1
# 3: 1 2 2
# 4: 1 3 1
# 5: 1 3 2
# 6: 1 3 3
# 7: 1 4 1
# 8: 1 4 2

More Related Contents:

  1. Fixing the order of facets in ggplot
  2. Create grouping variable for consecutive sequences and split vector
  3. Create counter within consecutive runs of values
  4. Create a group number for each consecutive sequence
  5. rep() with each equals a vector
  6. Create integer sequences defined by ‘from’ and ‘to’ vectors
  7. Generate an incrementally increasing sequence like 112123123412345
  8. Insert blanks into a vector for, e.g., minor tick labels in R
  9. Create counter of consecutive runs of a certain value
  10. Creating a unique sequence of dates
  11. Deleting every n-th row in a dataframe
  12. Create a Vector of All Days Between Two Dates
  13. Combine two data frames by rows (rbind) when they have different sets of columns
  14. How to merge 2 vectors alternating indexes?
  15. How to put labels over geom_bar in R with ggplot2
  16. Wrap long axis labels via labeller=label_wrap in ggplot2
  17. What ways are there to edit a function in R?
  18. Keeping trailing zeros
  19. Passing command line arguments to R CMD BATCH
  20. How to change order of boxplots when using ggplot2?
  21. listing contents of an R data file without loading
  22. How do you determine the namespace of a function?
  23. R: Plotting a 3D surface from x, y, z
  24. How to fill with different colors between two lines? (originally: fill geom_polygon with different colors above and below y = 0 (or any other value)?)
  25. ggplot geom_point() with colors based on specific, discrete values
  26. For the same code, labels (q1, median) appear on one computer but don’t appear on another computer
  27. GGplot custom scale transformation with custom ticks
  28. Undefined columns selected when subsetting data frame
  29. Generate all possible permutations (or n-tuples)
  30. devtools::install_github() – Ignore SSL cert verification failure

Leave a Comment