R dataframe: how to slice data based column value of distinct values in another column

Question

I am wondering how would I select unique values in one column based on the maximum value in another column for each original distinct value.

Original data frame:

Expected data frame:

Thanks!

score 1 · Accepted Answer · answered Jun 07 '19 at 18:38

1

Just do a a group by max

aggregate(b ~ a, df1, max)

If we have multiple columns in the dataset

library(dplyr)
df1 %>%
   group_by(a) %>%
   slice(which.max(b))

answered Jun 07 '19 at 18:38

akrun

1 Answers1