pandas多级分组如何排序

来源：互联网发布：javaweb项目源码编辑：程序博客网时间：2024/05/21 17:14

pandas有groupby分组函数和sort_values排序函数，但是如何对dataframe分组之后排序呢？

In [70]: df = pd.DataFrame(((random.randint(2012, 2016), random.choice(['tech', 'art', 'office']), '%dk-%dk'%(random.randint(2,10), random.randint(10, 20)), '') for _ in xrange(10000)), columns=['publish_time', 'classf', 'salary', 'title'])In [71]: df.head()Out[71]:   publish_time  classf  salary title0          2012     art  2k-19k1          2014  office  5k-17k2          2013  office  2k-10k3          2013     art  5k-14k4          2013     art  2k-14kIn [72]: df.groupby(['publish_time', 'classf', 'salary']).count()['title'].groupby(level=0, group_keys=False).nlargest(10)Out[72]:publish_time  classf  salary2012          art     7k-13k     18                      4k-13k     16              tech    3k-12k     14              art     6k-16k     13                      8k-15k     13              office  5k-18k     13              tech    4k-14k     13

阅读全文

0 0