Getting the top values by group

by

From dplyr 1.0.0, “slice_min() and slice_max() select the rows with the minimum or maximum values of a variable, taking over from the confusing top_n().“

d %>% group_by(grp) %>% slice_max(order_by = x, n = 5)
# # A tibble: 15 x 2
# # Groups:   grp [3]
#     x grp  
# <dbl> <fct>
#  1 0.994 1    
#  2 0.957 1    
#  3 0.955 1    
#  4 0.940 1    
#  5 0.900 1    
#  6 0.963 2    
#  7 0.902 2    
#  8 0.895 2    
#  9 0.858 2    
# 10 0.799 2    
# 11 0.985 3    
# 12 0.893 3    
# 13 0.886 3    
# 14 0.815 3    
# 15 0.812 3

Pre-dplyr 1.0.0 using top_n:

From ?top_n, about the wt argument:

The variable to use for ordering […] defaults to the last variable in the tbl”.

The last variable in your data set is “grp”, which is not the variable you wish to rank, and which is why your top_n attempt “returns the whole of d”. Thus, if you wish to rank by “x” in your data set, you need to specify wt = x.

d %>%
  group_by(grp) %>%
  top_n(n = 5, wt = x)

Data:

set.seed(123)
d <- data.frame(
  x = runif(90),
  grp = gl(3, 30))

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. Is there a dplyr equivalent to data.table::rleid?
  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. Canonical tidyverse method to update some values of a vector from a look-up table
  11. data.table row-wise sum, mean, min, max like dplyr?
  12. grouped operations that result in length not equal to 1 or length of group in dplyr
  13. How to use data.table within functions and loops?
  14. Summarizing multiple columns with dplyr? [duplicate]
  15. What is the purpose of setting a key in data.table?
  16. Filter data frame by character column name (in dplyr)
  17. How to number/label data-table by group-number from group_by?
  18. Remove duplicated rows using dplyr
  19. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  20. dplyr: inner_join with a partial string match
  21. Faster way to read fixed-width files
  22. Can dplyr summarise over several variables without listing each one? [duplicate]
  23. Error: package or namespace load failed for ggplot2 and for data.table
  24. Update subset of data.table based on join
  25. Change value of variable with dplyr
  26. sample rows of subgroups from dataframe with dplyr
  27. knitr gets tricked by data.table `:=` assignment
  28. Add multiple columns to R data.table in one function call?
  29. R – Group by variable and then assign a unique ID [duplicate]
  30. R sum a variable by two groups [duplicate]

Leave a Comment