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

33 votes114 views6 answers
Pip install matplotlib.pyplot
Python
10 votes113 views3 answers
Get reactions from message discord.py
Python
0 vote103 views1 answer
Torch.utils.data.random_split(dataset, lengths)
Python
0 vote103 views1 answer
Start and end index in python
Python
0 vote92 views1 answer
Django populate database in view
Python
0 vote107 views1 answer
How to check if a list raises IndexError but wihing a if statement python
Python
0 vote112 views1 answer
Draw figure larger than plot
Python
5 votes101 views1 answer
Timer 1hr
Python
0 vote105 views1 answer
StringIndexer pyspark
Python
25 votes113 views4 answers
Pandas count the number of unique values in a column
Python