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 vote125 views1 answer
Python ask for real values until negative value diplay highest and lowest
Python
15 votes166 views2 answers
How to add beautifulsoup to python
Python
0 vote167 views1 answer
Code runner runs python 2
Python
37 votes279 views6 answers
Drop columns with nan pandas
Python
0 vote171 views1 answer
Catch error in mongo query python
Python
0 vote210 views1 answer
Create django model field based on another field
Python Django
0 vote178 views1 answer
Inpunt and output
Python
29 votes175 views5 answers
Python date and time
Python
0 vote210 views1 answer
Sum values in django models and insert value in model field
Python Django
0 vote175 views1 answer
How to change a particular text inside a list of dictionary
Python