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

1 vote256 views1 answer
Dire Bonjour en python
Python
1 vote253 views1 answer
Simulate webcam and microphone selenium
Python
0 vote247 views1 answer
Python keyboard hold key
Python
7 votes261 views2 answers
Pandas read_csv ignore unnamed columns
Python
-1 vote259 views2 answers
Django forms error customize
Python
1 vote268 views1 answer
Python - How To Ways to Remove xa0 From a String
Python
33 votes276 views5 answers
Python exit program
Python
10 votes245 views1 answer
Convert numpy to torch
Python
0 vote265 views1 answer
Standardise columns python
Python
1 vote250 views1 answer
Raw input example python
Python