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 vote319 views1 answer
Pyspark group by and average in dataframes
Python
0 vote346 views1 answer
Styling filter form django
Python
6 votes316 views6 answers
Python create list
Python
1 vote345 views5 answers
Generate a list with random length and with random numbers python
Python
0 vote291 views1 answer
Remove all na from series
Python
0 vote309 views1 answer
Explode function in python
Python
29 votes317 views1 answer
Sort a dataframe by a column valuepython
Python
1 vote319 views1 answer
Python anagram finder
Python
0 vote388 views1 answer
Make the program title a name python
Python
2 votes290 views1 answer
Python install gimp
Python