data.table “key indices” or “group counter”

by

Update: From v1.8.3, you can simply use the inbuilt special .GRP:

DT[ , i := .GRP, by = key(DT)]

See history for older answers.

More Related Contents:

  1. How to create a lag variable within each group?
  2. data.table objects assigned with := from within function not printed
  3. How to efficiently calculate distance between pair of coordinates using data.table :=
  4. Sample random rows within each group in a data.table
  5. Faster way to read fixed-width files
  6. Select subset of columns in data.table R [duplicate]
  7. Melt using patterns when variable names contain string information – avoid coercion to numeric
  8. Error: package or namespace load failed for ggplot2 and for data.table
  9. How to perform join over date ranges using data.table?
  10. Split text string in a data.table columns
  11. R: data.table cross-join not working
  12. Why is allow.cartesian required at times when when joining data.tables with duplicate keys?
  13. Update subset of data.table based on join
  14. Dynamically build call for lookup multiple columns
  15. Add a row by reference at the end of a data.table object
  16. knitr gets tricked by data.table `:=` assignment
  17. Add multiple columns to R data.table in one function call?
  18. Subsetting data.table using variables with same name as column
  19. data.table equivalent of tidyr::complete()
  20. data.table merge based on date ranges
  21. Reason behind speed of fread in data.table package in R
  22. best way to transpose data.table
  23. data.table row-wise sum, mean, min, max like dplyr?
  24. Select NA in a data.table in R
  25. How to select R data.table rows based on substring match (a la SQL like)
  26. Any way to force fread() of data.table not to stop on empty lines?
  27. R data table: update join
  28. Split a string column into several dummy variables
  29. Is there a _fast_ way to run a rolling regression inside data.table?
  30. R fast single item lookup from list vs data.table vs hash

Leave a Comment