Extract row corresponding to minimum value of a variable by group

by

Slightly more elegant:

library(data.table)
DT[ , .SD[which.min(Employees)], by = State]

   State Company Employees
1:    AK       D        24
2:    RI       E        19

Slighly less elegant than using .SD, but a bit faster (for data with many groups):

DT[DT[ , .I[which.min(Employees)], by = State]$V1]

Also, just replace the expression which.min(Employees) with Employees == min(Employees), if your data set has multiple identical min values and you’d like to subset all of them.

See also Subset rows corresponding to max value by group using data.table.

More Related Contents:

  1. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  2. Summarizing multiple columns with dplyr? [duplicate]
  3. Group by multiple columns and sum other multiple columns
  4. How to create a lag variable within each group?
  5. data.table vs dplyr: can one do something well the other can’t or does poorly?
  6. Is there a dplyr equivalent to data.table::rleid?
  7. Getting the top values by group
  8. dplyr mutate/replace several columns on a subset of rows
  9. Finding Overlaps between interval sets / Efficient Overlap Joins
  10. dplyr on data.table, am I really using data.table?
  11. Merge rows in a dataframe where the rows are disjoint and contain NAs
  12. How to speed up subset by groups
  13. R sum a variable by two groups [duplicate]
  14. Canonical tidyverse method to update some values of a vector from a look-up table
  15. data.table row-wise sum, mean, min, max like dplyr?
  16. grouped operations that result in length not equal to 1 or length of group in dplyr
  17. Run a custom function on a data frame in R, by group
  18. How to use data.table within functions and loops?
  19. Collapse / concatenate / aggregate a column to a single comma separated string within each group
  20. Group by multiple columns in dplyr, using string vector input
  21. Select groups which have at least one of a certain value
  22. Why is using update on a lm inside a grouped data.table losing its model data?
  23. ‘Embedded nul in string’ error when importing csv with fread
  24. Delete columns/rows with more than x% missing
  25. R fuzzy string match to return specific column based on matched string
  26. Subsetting data.table by 2nd column only of a 2 column key, using binary search not vector scan
  27. dplyr: lead() and lag() wrong when used with group_by()
  28. Reorder rows using custom order
  29. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  30. Using data.table i and j arguments in functions

Leave a Comment