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

2 votes116 views1 answer
Python string remove whitespace and newlines
Python
0 vote112 views1 answer
Install python on windows subsystem for linux
Python
0 vote122 views1 answer
Django connect to a db on heroku
Python
2 votes115 views1 answer
Np logical_or
Python
0 vote116 views1 answer
Antal riksdagsledamöter
Python
0 vote128 views1 answer
Remove all integers from list python
Python
0 vote123 views1 answer
Django queryset with multiple contain keyword
Python
0 vote105 views1 answer
Rest api error
Python
0 vote120 views1 answer
Check if there is a certain number difference with python
Python
0 vote101 views1 answer
Django sign up
Python