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

16 votes398 views3 answers
How to change the column order in pandas dataframe
Python
1 vote339 views1 answer
Get string until character python
Python
1 vote354 views7 answers
Java to python
Python
-2 votes368 views1 answer
Django modelform datetime
Python
0 vote362 views1 answer
1024x768
Python
0 vote342 views1 answer
Python ip address is subnet of
Python
0 vote377 views1 answer
Csr_matric scipy lib
Python
3 votes355 views1 answer
Boto3 upload file to s3
Python
0 vote348 views1 answer
Ping all IP addresses in a network
Python
7 votes371 views2 answers
Add image to jupyter notebook in markdown
Python