How to select the rows with maximum values in each group with dplyr? [duplicate]

by

Try this:

result <- df %>% 
             group_by(A, B) %>%
             filter(value == max(value)) %>%
             arrange(A,B,C)

Seems to work:

identical(
  as.data.frame(result),
  ddply(df, .(A, B), function(x) x[which.max(x$value),])
)
#[1] TRUE

As pointed out in the comments, slice may be preferred here as per @RoyalITS’ answer below if you strictly only want 1 row per group. This answer will return multiple rows if there are multiple with an identical maximum value.

More Related Contents:

  1. Why does summarize or mutate not work with group_by when I load `plyr` after `dplyr`?
  2. How to create a lag variable within each group?
  3. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  4. Unique rows, considering two columns, in R, without order
  5. Applying a function to every row of a table using dplyr?
  6. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  7. dplyr: “Error in n(): function should not be called directly”
  8. Aggregate a dataframe on a given column and display another column
  9. Count number of rows by group using dplyr
  10. How to strsplit different number of strings in certain column by do function
  11. Change value of variable with dplyr
  12. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  13. Filter data frame by character column name (in dplyr)
  14. How to number/label data-table by group-number from group_by?
  15. Remove duplicated rows using dplyr
  16. dplyr: inner_join with a partial string match
  17. sample rows of subgroups from dataframe with dplyr
  18. Assigning Dates to Fiscal Year
  19. filter function in dplyr errors: object ‘name’ not found
  20. Create a ranking variable with dplyr?
  21. How to pass dynamic column names in dplyr into custom function?
  22. R – Group by variable and then assign a unique ID [duplicate]
  23. R sum a variable by two groups [duplicate]
  24. Join two data frames in R based on closest timestamp
  25. data.table row-wise sum, mean, min, max like dplyr?
  26. Update/Replace Values in Dataframe with Tidyverse Join
  27. ddply for sum by group in R
  28. Run a custom function on a data frame in R, by group
  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