Pandas groupby sum and sort descending on that sum

Question

I have a groupby statement resulting the below result. How can sort the w column descending order within that grouping?

score 1 · Answer 1 · answered Aug 28 '22 at 15:42

1

You can use groupby.apply with the sort_values

df_sp.groupby(['season','home_team']).sum('w').apply(lambda x : x['w'].sort_values(ascending=False))

answered Aug 28 '22 at 15:42

score 0 · Accepted Answer · answered Aug 28 '22 at 14:50

Code -

grouped = df_sp.groupby(['season','home_team']).sum('w').reset_index()
g = grouped.sort_values('w', ascending=False)

pls share reproducible code so that others can test, above code is not tested.

2 Answers2