如何修改聚合后的数据的index

>>> import pandas as pd
>>> data=pd.DataFrame({'name':['x','y','x','y','z'],'sex':['f','m','f','f','m'],'age':[25,26,45,67,30]})
>>> data
  name sex  age
0    x   f   25
1    y   m   26
2    x   f   45
3    y   f   67
4    z   m   30

此时我们可以看到‘name'为该dataframe的index 

>>> data.groupby(['name']).agg(age_sum = ('age','sum'),age_mean=('age','mean'))
      age_sum  age_mean
name                   
x          70      35.0
y          93      46.5
z          30      30.0

 在聚合计算后面加上一个reset_index()就可以了，是不是很easy。因为When we reset the index, the old index is added as a column, and a new sequential index is used 

>>> data.groupby(['name']).agg(age_sum = ('age','sum'),age_mean=('age','mean')).reset_index()
  name  age_sum  age_mean
0    x       70      35.0
1    y       93      46.5
2    z       30      30.0