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 vote375 views1 answer
Zoom in geopandas polot
Python
0 vote333 views1 answer
Json post python with headers
Python
0 vote343 views1 answer
Pe039
Python
1 vote346 views1 answer
Get href scrapy xpath
Python
4 votes379 views2 answers
Python read array line by line
Python
7 votes323 views2 answers
Append record in csv
Python
0 vote329 views1 answer
Matrix of matrices python grepper
Python
0 vote336 views1 answer
C# dictionary values to array
Python
1 vote334 views1 answer
Url in form action django
Python
0 vote354 views1 answer
Km/h to mph python
Python