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

4 votes158 views1 answer
Print specific list item python
Python
25 votes158 views2 answers
Python convert py file to pyc
Python
0 vote158 views2 answers
Pdf to word
Python
0 vote161 views1 answer
How to resize image with pillow in django
Python
26 votes159 views2 answers
Import time in python
Python
1 vote170 views3 answers
Remove punctuation in dataframe column
Python
0 vote168 views1 answer
Rdflib check if graph is empty
Python
0 vote165 views1 answer
Python csv file tools
Python
0 vote163 views1 answer
Como calcular el rango en python
Python
17 votes148 views5 answers
Find all occurrences of an element in a list python
Python