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 votes179 views2 answers
Plt dashed line
Python
0 vote165 views1 answer
Protocol buffers python
Python
3 votes175 views2 answers
Import file in parent directory python
Python
0 vote256 views1 answer
Django create ap
Python
0 vote170 views1 answer
Combine int and object columns into one
Python
0 vote184 views1 answer
Matplotlib get and chan values of tick labels
Python
0 vote181 views1 answer
FilePathField
Python
5 votes162 views10 answers
Online python to c converter
Python
-1 vote179 views1 answer
Python Couldn't find a tree builder with the features you requested: lxml. Do you need to install a parser library?
Python
6 votes181 views3 answers
Selenium.common.exceptions.WebDriverException: Message: 'chromedriver' executable needs to be in PATH. Please see https://sites.google.com/a/chromium.org/chromedriver/home
Python