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 vote242 views1 answer
Django serializer get image list
Python Django
2 votes176 views1 answer
Register modal in django admin
Python
0 vote196 views1 answer
How to add existiong database in dango
Python
3 votes196 views2 answers
Different dataframe name with for loop
Python
1 vote226 views1 answer
How to create a save command in python
Python
7 votes277 views4 answers
Keras
Python
0 vote229 views1 answer
Drop-trailing-zeros-from-decimal python
Python
41 votes193 views6 answers
Replace nan with 0 pandas
Python
0 vote191 views1 answer
Message handler python telegram bot example
Python
0 vote332 views1 answer
: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend,
Python