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

1 vote303 views1 answer
Python for property in object
Python
0 vote292 views1 answer
Récupérer l'extension d'un fichier en python
Python
19 votes313 views2 answers
Python string cut first n characters
Python
8 votes325 views3 answers
How to delete nan values in python
Python
0 vote315 views1 answer
List square python
Python
0 vote328 views1 answer
Numpy get index of n largest values
Python
0 vote329 views1 answer
Hello kitt
Python
47 votes324 views6 answers
Python enumerate for loop
Python
1 vote311 views1 answer
Dataframe KeyError:
Python
1 vote370 views2 answers
Flask bootstrap
Python Flask