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
Group by to a collect datafame
Python
1 vote243 views1 answer
Division euclidienne python
Python
0 vote253 views1 answer
Relation api profile does not exist django
Python
0 vote265 views1 answer
Python capitalize first letter of string without changing the rest
Python
0 vote236 views1 answer
Python - match two df on a variable with different name
Python
0 vote248 views1 answer
Modbusfc03 python
Python
0 vote272 views1 answer
RuntimeError: cuda runtime error (711) : peer mapping resources exhausted at /pytorch/aten/src/THC/THCGeneral.cpp:139
Python
1 vote238 views1 answer
Hotel room allocation tool in python
Python
27 votes256 views6 answers
Remove column from dataframe
Python
0 vote283 views5 answers
Pdf to excel python
Python