python generate a sorting number within group code example
Example: pandas sort values group by
df.groupby(['job']).apply(lambda x: (x.groupby('source')
.sum()
.sort_values('count', ascending=False))
.head(3))