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 vote259 views1 answer
Lenet 5 keras
Python
0 vote267 views1 answer
Coger elementos de un string python expresiones regulares
Python
1 vote271 views1 answer
Timedelta to float
Python
0 vote292 views1 answer
Django create username and password from csv
Python
0 vote266 views1 answer
Link_to class
Python
1 vote286 views1 answer
Save video cv2
Python
3 votes279 views3 answers
Remove x label matplotlib
Python
0 vote283 views1 answer
Try and exception
Python
0 vote259 views2 answers
How to skip error python
Python
0 vote306 views1 answer
Sendgrid django smtp
Python Django