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 vote182 views1 answer
How to query json field django
Python
103 votes202 views6 answers
Rename column pandas
Python
0 vote191 views1 answer
Connect spark to postgres; connect spark to database
Python
0 vote206 views1 answer
Python string after character
Python
3 votes210 views3 answers
Python name of current file
Python
2 votes146 views1 answer
How to plus numbers in strings
Python
0 vote221 views1 answer
ERROR: character with byte sequence 0xd0 0x9f in encoding "UTF8" has no equivalent in encoding "LATIN1"
Python
0 vote181 views1 answer
Python when to use pandas series, numpy ndarrays or simply python dictionaries
Python
1 vote190 views1 answer
For i in a for j in a loop python
Python
0 vote194 views1 answer
Add download directory selenium python
Python