python打印每组前5名

Question

需要找到流行的名字，按性别分组

bnames_decade = bnames_decade.groupby(['sex','name'])['births'].sum().sort_values(ascending=False)

这表明

F    Emma        121375
     Sophia      117352
     Olivia      111691
M    Noah        110280
     Mason       105104
     Jacob       104722
F    Isabella    103947

。。。你知道吗

我想打印每个小组的前5名。 有人能推荐一个Python代码吗？你知道吗

我尝试的方法不起作用。你知道吗

bnames_top5 =bnames_decade.groupby('sex').head(5)

Answer 1

import pandas as pd
bnames_decade = pd.DataFrame([['F','Emma',121375],['F','Sophia',117352],['F','Olivia',111691],['M','Noah',110280],['M','Mason',105104],['F','Isabella',103947], ['F','Isabella2',103946],['F','Isabella3',103945],['F','Isabella4',103944],['M','Isabella5',103943],['M','Isabella6',103942],['M','Isabella7',103941],['M','Isabella8',103940]], columns=['sex','name','births'])
print(bnames_decade)

for key, group in bnames_decade.groupby(['sex']):
    print(group['name'].iloc[0:5])