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

8 votes147 views1 answer
Count the duplicates in a list in python
Python
1 vote148 views1 answer
Small factorial codechef solution
Python
0 vote154 views1 answer
Datetime time set seconds
Python
0 vote150 views1 answer
Write dict to json file with special characters
Python
13 votes145 views2 answers
Python remove directory not empty
Python
1 vote152 views1 answer
How to provide default value when assign i ngvariables python
Python
0 vote137 views1 answer
Pandas merge sort columns
Python
1 vote165 views1 answer
Convert pandas dataframe to django queryset
Python Django
1 vote224 views3 answers
Inheritance in python 3 example
Python
0 vote171 views1 answer
Mongoengine find
Python