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 vote157 views1 answer
Python generalised eigenvalue problem
Python
1 vote118 views1 answer
Keep the user logged in even though user changes password django
Python
0 vote117 views1 answer
Join all words in a list python with space between
Python
91 votes123 views6 answers
How to create a virtual environment in python
Python
0 vote121 views1 answer
Install easygui
Python
0 vote113 views1 answer
Algebraic pyramid python
Python
-1 vote279 views4 answers
Flask documentation
Python Flask
0 vote111 views1 answer
Swap case hackerrank solution
Python
0 vote113 views1 answer
Promote a row in panda dataframe to header
Python
0 vote105 views1 answer
How does tkinter iconify() function work in python
Python