Is there a dplyr equivalent to data.table::rleid?

by

You can just do (when you have both data.table and dplyr loaded):

DT <- DT %>% mutate(rlid = rleid(grp))

this gives:

> DT
    grp value rlid
 1:   A     1    1
 2:   A     2    1
 3:   B     3    2
 4:   B     4    2
 5:   C     5    3
 6:   C     6    3
 7:   C     7    3
 8:   A     8    4
 9:   B     9    5
10:   B    10    5

When you don’t want to load data.table separately you can also use (as mentioned by @DavidArenburg in the comments):

DT <- DT %>% mutate(rlid = data.table::rleid(grp))

And as @RichardScriven said in his comment you can just copy/steal it:

myrleid <- data.table::rleid

More Related Contents:

  1. Extract row corresponding to minimum value of a variable by group
  2. How to create a lag variable within each group?
  3. data.table vs dplyr: can one do something well the other can’t or does poorly?
  4. Getting the top values by group
  5. dplyr mutate/replace several columns on a subset of rows
  6. Finding Overlaps between interval sets / Efficient Overlap Joins
  7. dplyr on data.table, am I really using data.table?
  8. Merge rows in a dataframe where the rows are disjoint and contain NAs
  9. How to speed up subset by groups
  10. Use rle to group by runs when using dplyr
  11. Canonical tidyverse method to update some values of a vector from a look-up table
  12. data.table row-wise sum, mean, min, max like dplyr?
  13. grouped operations that result in length not equal to 1 or length of group in dplyr
  14. How to use data.table within functions and loops?
  15. What is the purpose of setting a key in data.table?
  16. dplyr: “Error in n(): function should not be called directly”
  17. .EACHI in data.table?
  18. Use a value from the previous row in an R data.table calculation
  19. Melt using patterns when variable names contain string information – avoid coercion to numeric
  20. How to perform join over date ranges using data.table?
  21. Split text string in a data.table columns
  22. Assigning Dates to Fiscal Year
  23. filter function in dplyr errors: object ‘name’ not found
  24. How to pass dynamic column names in dplyr into custom function?
  25. data.table merge based on date ranges
  26. Reason behind speed of fread in data.table package in R
  27. Update/Replace Values in Dataframe with Tidyverse Join
  28. assigning by reference into loaded package datasets
  29. Dealing with spaces and “weird” characters in column names with dplyr::rename()
  30. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter

Leave a Comment