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 vote180 views1 answer
Menubar pyqt
Python
0 vote244 views1 answer
Locate certs path for python
Python
0 vote192 views1 answer
Hms bagle
Python
8 votes186 views3 answers
Python gzip file
Python
0 vote192 views1 answer
Import APIview
Python
1 vote251 views1 answer
How to use query_params in get_object djangorestframework
Python Django
14 votes210 views1 answer
Export a dataframe to excel pandas
Python
3 votes181 views1 answer
Pygame unable to open file mp4
Python
0 vote184 views1 answer
Pandas string manipulation on column
Python
1 vote287 views1 answer
Count words python
Python