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 vote277 views1 answer
Generate 50 characters long for django
Python Django
0 vote183 views1 answer
Own labels for ticks matplotlib
Python
0 vote214 views1 answer
Def identity_block(X, f, filters, training=True, initializer=random_uniform):
Python
29 votes176 views6 answers
List to string python
Python
0 vote187 views1 answer
Python click activator
Python
0 vote167 views1 answer
Python install pylab
Python
1 vote167 views1 answer
Read google sheet from web to pandas python
Python
24 votes176 views6 answers
Order dictionary by value python
Python
0 vote194 views1 answer
Pandas recognize type from strings
Python
1 vote162 views1 answer
Hide cmd in python
Python