Groupby and sort python

Pandas sort values group by

df.groupby(['job']).apply(lambda x: (x.groupby('source')
                                      .sum()
                                      .sort_values('count', ascending=False))
                                     .head(3))

Source: stackoverflow.com

Groupby and sort python

In[34]: df.sort_values(['job','count'],ascending=False).groupby('job').head(3)

Out[35]: 
   count     job source
4      7   sales      E
2      6   sales      C
1      4   sales      B
5      5  market      A
8      4  market      D
6      3  market      B

-1

Source: stackoverflow.com

Similar codes

0 vote133 views1 answer
Download python libraries offline
Python
-1 vote587 views1 answer
Python os file path
Python
0 vote131 views1 answer
Print choicefield data from database in django
Python
0 vote139 views1 answer
ValueError: query data dimension must match training data dimension
Python
15 votes103 views2 answers
Python copy image to clipboard
Python
0 vote150 views1 answer
Flask python use specified port
Python
1 vote139 views1 answer
Python sort list of strings numerically
Python
0 vote139 views1 answer
Python openpyxl cell width
Python
0 vote131 views1 answer
Filter Top 5 Python
Python
15 votes133 views3 answers
Send image discord.py
Python