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

9 votes112 views3 answers
Save model pickle
Python
93 votes98 views6 answers
Creating virtual environment python
Python
0 vote119 views1 answer
Matplotlib dateformatter x axis
Python
7 votes94 views2 answers
Dataframe slice by list of values
Python
0 vote132 views1 answer
Change python 3.5 to 3.6 ubuntu
Python
4 votes147 views2 answers
Generate random prime number python
Python
39 votes106 views5 answers
Csv to python
Python
1 vote101 views1 answer
Message box on closing window event in tkinter
Python
0 vote95 views1 answer
Wert in array suchen python
Python
0 vote151 views1 answer
Django connect to a db on heroku
Python Django