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

4 votes233 views1 answer
Download python 2.7 for windows 10
Python
0 vote212 views1 answer
Hello kitt
Python
9 votes197 views2 answers
How to make a resizable python tkinter window have a limit
Python
2 votes214 views2 answers
Virtualenv specify python version
Python
0 vote261 views1 answer
Python youtube downloader github
Python
7 votes218 views1 answer
Emoji In Python
Python
3 votes214 views2 answers
Scikit learn lda
Python
0 vote159 views1 answer
Python3 delete file
Python
3 votes199 views1 answer
Python run a system command
Python
0 vote212 views1 answer
Python beacon
Python