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 vote137 views1 answer
Check if string equals string in list python
Python
2 votes133 views1 answer
Flask if statement
Python
20 votes135 views5 answers
List directory in python
Python
0 vote124 views1 answer
Rapids - convert nerworkx to cugraph
Python
1 vote133 views1 answer
Issue TypeError: can’t multiply sequence by non-int of type str
Python
-1 vote146 views2 answers
Python diagonal sum
Python
10 votes191 views2 answers
Sum of a column in pandas
Python
12 votes137 views6 answers
Print string and variable python
Python
1 vote146 views1 answer
Frequency
Python
0 vote133 views1 answer
String pattern matching pandas
Python