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

17 votes258 views5 answers
Append element to list py
Python
2 votes304 views2 answers
Cv2 crop image
Python
0 vote236 views5 answers
C++ to python code converter
Python
5 votes234 views1 answer
Install pygaame using pip
Python
3 votes257 views1 answer
How to know all methods in a module in python
Python
4 votes238 views1 answer
How to import reverse
Python
3 votes220 views2 answers
How many columns have null values present in them? in pandas
Python
6 votes233 views5 answers
Django logout
Python Django
1 vote228 views2 answers
Urllib.error.URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:997)>
Python
0 vote234 views1 answer
Programmer tool
Python