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

3 votes237 views6 answers
ImportError: Couldn't import Django. Are you sure it's installed and available on your PYTHONPATH environment variable? Did you forget to activate a virtual environment?
Python Django
12 votes204 views2 answers
Matplotlib legend out of plot
Python
0 vote220 views2 answers
How to print aligned dictionary python
Python
7 votes188 views2 answers
Ckeditor django
Python
11 votes214 views3 answers
Python pandas convert nan to 0
Python
2 votes202 views1 answer
Python regex numbers only
Python
1 vote208 views5 answers
How to install django in virtual environment in ubuntu
Python
0 vote192 views1 answer
How to change the jupyter navigator
Python
1 vote201 views2 answers
Convert timestamp to period pandas
Python
3 votes201 views3 answers
Decision tree
Python