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

18 votes206 views4 answers
Python remove duplicate numbers
Python
0 vote232 views1 answer
Battery status from whatsapp web
Python
0 vote245 views2 answers
Print current line number python
Python
7 votes223 views6 answers
Python hello world
Python
8 votes229 views1 answer
X = df.iloc[:, 1:]
Python
0 vote227 views1 answer
Set pytesseract cmd path
Python
0 vote254 views1 answer
A function for reviewing a list's order of magnitude in python
Python
1 vote219 views1 answer
Python line chart
Python
0 vote220 views1 answer
Phone no validate
Python
1 vote214 views1 answer
How to convert unicode to string python
Python