我遇到了一个问题，熊猫试图制作一个表格来显示文件中的统计数据

Question

import pandas

link = 'https://raw.githubusercontent.com/dvanderelst-python-class/python-class/spring2021/assignment_data/young_people_survey.csv'
data = pandas.read_csv(link,index_col=0)

grp = data.groupby(['Gender','Smoking','Healthy eating'])
mns = grp.mean()
 
mns = grp.mean()
std = grp.std()

mns_reset_indices = mns.reset_index()

result = data.groupby(data, ['Gender','Smoking','Healthy eating'])

table = result.pivot(index='Gender', columns='Smoking', values='Healthy Eating')
print(table)

我需要创建一个显示如下内容的表：

https://i.stack.imgur.com/d8IOs.png

我一直收到这样的错误：Error description

Answer 1

我想这应该是：

df.groupby(['Gender', 'Smoking']).agg(np.mean)

​

​

使用pivot_table

table = pd.pivot_table(df, index=['Gender', 'Smoking'], columns=None, values=['Healthy eating'],
           aggfunc={'Healthy eating':[np.std, np.mean]},fill_value=0)

表：

​

​