Sample random rows within each group in a data.table

by

Maybe something like this?

> DT[,.SD[sample(.N, min(3,.N))],by = a]
   a   b
1: 1 744
2: 1 497
3: 1 167
4: 2 888
5: 2 950
6: 2 343

(Thanks to Josh for the correction, below.)

More Related Contents:

  1. Naming columns in a data table in R
  2. How to create a lag variable within each group?
  3. data.table objects assigned with := from within function not printed
  4. .EACHI in data.table?
  5. Use a value from the previous row in an R data.table calculation
  6. How to efficiently calculate distance between pair of coordinates using data.table :=
  7. data.table “key indices” or “group counter”
  8. Faster way to read fixed-width files
  9. Select subset of columns in data.table R [duplicate]
  10. Melt using patterns when variable names contain string information – avoid coercion to numeric
  11. Error: package or namespace load failed for ggplot2 and for data.table
  12. How to perform join over date ranges using data.table?
  13. Split text string in a data.table columns
  14. R: data.table cross-join not working
  15. Why is allow.cartesian required at times when when joining data.tables with duplicate keys?
  16. Update subset of data.table based on join
  17. Dynamically build call for lookup multiple columns
  18. Add a row by reference at the end of a data.table object
  19. How to speed up subset by groups
  20. knitr gets tricked by data.table `:=` assignment
  21. Add multiple columns to R data.table in one function call?
  22. Subsetting data.table using variables with same name as column
  23. Extract a column from a data.table as a vector, by position
  24. data.table equivalent of tidyr::complete()
  25. data.table merge based on date ranges
  26. Reason behind speed of fread in data.table package in R
  27. best way to transpose data.table
  28. data.table row-wise sum, mean, min, max like dplyr?
  29. Select NA in a data.table in R
  30. Index unique values in data.table

Leave a Comment