dplyr filter: Get rows with minimum of variable, but only the first if multiple minima

by

Update

With dplyr >= 0.3 you can use the slice function in combination with which.min, which would be my favorite approach for this task:

df %>% group_by(A) %>% slice(which.min(x))
#Source: local data frame [3 x 3]
#Groups: A
#
#  A x          y
#1 A 1  0.2979772
#2 B 2 -1.1265265
#3 C 5 -1.1952004

Original answer

For the sample data, it is also possible to use two filter after each other:

group_by(df, A) %>% 
  filter(x == min(x)) %>% 
  filter(1:n() == 1)

More Related Contents:

  1. Replace values greater than zero with 1 in r
  2. How does one access the piped data.frame in dplyr::funs?
  3. Extract row corresponding to minimum value of a variable by group
  4. How to select the rows with maximum values in each group with dplyr? [duplicate]
  5. Pass a string as variable name in dplyr::filter
  6. Filter multiple values on a string column in dplyr
  7. Select first and last row from grouped data
  8. Applying a function to every row of a table using dplyr?
  9. Concatenate strings by group with dplyr [duplicate]
  10. Reverse stacked bar order
  11. Can dplyr package be used for conditional mutating?
  12. What does %>% function mean in R?
  13. Fitting several regression models with dplyr
  14. dplyr: how to reference columns by column index rather than column name using mutate?
  15. Non-standard evaluation (NSE) in dplyr’s filter_ & pulling data from MySQL
  16. ignore NA in dplyr row sum
  17. Can I replace NAs when joining two data frames with dplyr?
  18. Merge rows in a dataframe where the rows are disjoint and contain NAs
  19. Reshape from long to wide and create columns with binary value
  20. dplyr broadcasting single value per group in mutate
  21. Can dplyr join on multiple columns or composite key?
  22. Create column with grouped values based on another column
  23. How to deal with nonstandard column names (white space, punctuation, starts with numbers)
  24. dplyr if_else() vs base R ifelse()
  25. Using column names as function arguments
  26. How to change the now deprecated dplyr::funs() which includes an ifelse argument?
  27. Apply a ggplot-function per group with dplyr and set title per group
  28. Mutate multiple variable to create multiple new variables
  29. dplyr summarize with subtotals
  30. Collapse all columns by an ID column [duplicate]

Leave a Comment