group by each column by descending pandas code example
Example 1: pandas sort values group by
df.groupby(['job']).apply(lambda x: (x.groupby('source')
.sum()
.sort_values('count', ascending=False))
.head(3))
Example 2: sort values within groups pandas dataframe
import pandas as pd
df = pd.DataFrame({'A':[1, 2, 3, 4, 5, 6],
'B':[0, 1, 2, 0, 1, 2]})
df.groupby('B').apply(lambda x: x.sort_values('A', ascending = True))