Get row which has max value in each group using python pandas

Question

I have a dataframe. It is group by 'ex' as below: enter image description here Now I want to get rows which have max value in each group

I think you need df_2.groupby("ex")["transaction_fee"].max() — foxel, Jun 06 '22 at 07:44
But I want to get the corresponding value in other columns of this max value — Quang Minh Vu, Jun 06 '22 at 07:49
Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — Community, Jun 06 '22 at 13:34

score 1 · Answer 1 · answered Jun 06 '22 at 08:16

so a quick google search and you will find out how to get relevant rows here: for your implementation:

df.groupby("ex")['transaction_fee'].max()

the other thing you should look for is how to get the corresponding indices for the original table. you could find something similar here:

for your implemtionation:

idxs = df.groupby("ex")['transaction_fee'].transform(max) == df['transaction_fee']
relevant_df = df[idxs]

cheers ✌

1 Answers1