How to select x value of max y in R

Question

I have a table with an x and y value as follows:;

cbm <- captialbikedata %>%
    group_by(hr) %>%
    summarize(users = sum(registered))

x	y
1	23
2	45

in this case how would I select 2? (I want to select the x value with the highest y value and then put it in a red file)

akrun · Accepted Answer · 2021-03-05T17:22:19.030

0

We can use slice_max

library(dplyr)
red <- cbm %>%
    ungroup %>%
    slice_max(y) %>%
    pull(x)

edited Mar 05 '21 at 17:22

answered Mar 05 '21 at 17:11

akrun

with this I get the result of both x and y (2 and 45 in my example) am I doing something wrong? – Christian Mar 05 '21 at 17:21
@Christian you want only `x`? – akrun Mar 05 '21 at 17:22
@Christian updated the post – akrun Mar 05 '21 at 17:22

1 Answers1