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

1 vote314 views3 answers
Inheritance in python 3 example
Python
0 vote325 views1 answer
Numpy second derivative of array
Python
2 votes330 views1 answer
Open applications by python
Python
0 vote331 views1 answer
Python parser txt to excel
Python
3 votes334 views2 answers
Tensorflow
Python
0 vote301 views1 answer
Pip install pandas invalid syntax
Python
0 vote325 views1 answer
Adding bootstrap grid dynamically django
Python
1 vote403 views1 answer
No such table: django_session admin
Python Django
0 vote318 views3 answers
How to send data to scrapy pipeline to mongodb
Python
0 vote314 views1 answer
Break
Python