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 vote115 views1 answer
Ascii value of pi symbol in python
Python
0 vote124 views2 answers
Get the first item from an iterable that matches a condition
Python
0 vote117 views1 answer
Random string generate python of 2.7
Python
0 vote130 views1 answer
Rolling std dev of a pandas series
Python
3 votes121 views2 answers
Indentation in python
Python
6 votes128 views1 answer
Select closest number in array python
Python
0 vote124 views1 answer
Linking bootstrap in flask
Python
0 vote126 views1 answer
Python datetime remove timezone
Python
0 vote156 views1 answer
Add row in db django
Python Django
0 vote125 views1 answer
Index and reversing a sub list in python list
Python