Find value corresponding to maximum in other column [duplicate]

by

Using dplyr:

# install.packages(dplyr)
library(dplyr)

df %>% 
    filter(x == max(y)) %>% # filter the data.frame to keep row where x is maximum
    select(x) # select column y

Alternatively to return a vector

df %>% 
    filter(x == max(y)) %>% 
    pull(x) # pull the variable y

using base R:

df[df$x == max(df$y), "x"]

More Related Contents:

  1. Selecting data frame rows based on partial string match in a column
  2. Is there an R function for finding the index of an element in a vector?
  3. Conditional merge/replacement in R
  4. Delete rows containing specific strings in R
  5. Finding running maximum by group
  6. How to find the highest value of a column in a data frame in R?
  7. How to get the maximum value by group
  8. How to extract the row with min or max values?
  9. Is there a vectorized parallel max() and min()?
  10. How can I take pairwise parallel maximum or minimum between two vectors?
  11. min for each row in a data frame
  12. Finding the maximum value for each row among 3 columns in R
  13. MATCH function in r [duplicate]
  14. Add a new column to a dataframe using matching values of another dataframe [duplicate]
  15. Identify records in data frame A not contained in data frame B [closed]
  16. Relative frequencies / proportions with dplyr
  17. Split a large dataframe into a list of data frames based on common value in column
  18. Save a plot in an object
  19. YAML current date in rmarkdown
  20. Create new variables with mutate_at while keeping the original ones
  21. R: use magrittr pipe operator in self written package
  22. How to stack error bars in a stacked bar plot using geom_errorbar?
  23. ggplot2: connecting points in polar coordinates with a straight line 2
  24. Split delimited single value character vector
  25. R split numeric vector at position
  26. Creating a Plot Window of a Particular Size
  27. Reordering factor gives different results, depending on which packages are loaded
  28. Join two data frames in R based on closest timestamp
  29. R optimization with equality and inequality constraints
  30. R – ggplot line color (using geom_line) doesn’t change

Leave a Comment