I Want Frequency Value with the Maximum Sample Using R

Question

I want the frequency with the maximum samples in df

df <- data.frame(Freq = c(1,2,3,4,5,6,7,8,9,10), Valu = c(10,5,11,7,13,15,9,6,12,12))


apply(df, 2, which.max)

.

What I want

I want it to print just the frequency of the maximum Valu which is 6

akrun · Accepted Answer · 2021-07-15T22:31:10.553

1

We could use which.max on the column 'Sample', get the index and extract ([), the corresponding 'Freq' value

with(df, Freq[which.max(Valu)])
#[1] 6

If the column names are changing, then use position index

df[[1]][which.max(df[[2]])]
[1] 6

Or may use order as well

df[[1]][order(-df[[2]])][1]
[1] 6

If we loop over the columns (*apply) with MARGIN = 2 and apply the function which.max, it returns the index of max for those columns separately

edited Jul 15 '21 at 22:31

answered Jul 15 '21 at 21:58

akrun

874,273
37
540
662

I just want a syntax that will use only the `data frame and not going back to the `sample` that generates it. – Daniel James Jul 15 '21 at 22:04
@DanielJames is this because the column names are different. Then, use `mydf[[1]][which.max(mydf[[2]])]` – akrun Jul 15 '21 at 22:06
@DanielJames I didn't understsand what you meant by `not going back`.. Can you describe a bit more – akrun Jul 15 '21 at 22:10
I have edited the formation of my data frame to make you understand my question beter – Daniel James Jul 15 '21 at 22:18
1

@DanielJames what is the issue with using `df[[1]][which.max(df[[2]])] [1] 6` – akrun Jul 15 '21 at 22:19
1

permit me to edit your syntax to reflect changes in my question for others to understand that your answer addresses my question. – Daniel James Jul 15 '21 at 22:25
@DanielJames you can go ahead and edit it. thanks – akrun Jul 15 '21 at 22:27
1

The `suggested edit queue is full`, please change `mydf` to `df` in your answer as I can no longer edit it – Daniel James Jul 15 '21 at 22:30
1

i updatd the post – akrun Jul 15 '21 at 22:31

I Want Frequency Value with the Maximum Sample Using R

1 Answers1