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

10 votes197 views3 answers
Package in python
Python
1 vote237 views1 answer
How to import subprocess in python
Python
4 votes219 views1 answer
Pygame.rect parameters
Python
5 votes203 views5 answers
Docstring in python
Python
0 vote204 views3 answers
Draw circle opencv
Python
1 vote200 views1 answer
Pandas write to csv without first line
Python
0 vote202 views1 answer
Python for loop in range 01 02
Python
9 votes278 views6 answers
Pattern in python
Python
0 vote205 views1 answer
Linking bootstrap in flask
Python
30 votes234 views3 answers
Python newline character
Python