错误写法:
df_set = [stats_V25A, stats_5B, stats_7B]
for df in df_set:
df.index = range(2014, 2021)
df = df.fillna(0) # 区别在这一行
df.loc[df.shape[0]] = [df[column].mean() for column in list(df.columns)]
df.rename(index={df.shape[0]-1: 'mean'}, inplace=True)
print(df)
break
print('-----------------------------\n', stats_V25A)
效果:
正确写法:
df_set = [stats_V25A, stats_5B, stats_7B]
for df in df_set:
df.index = range(2014, 2021)
df.fillna(0, inplace=True) # 区别在这一行
df.loc[df.shape[0]] = [df[column].mean() for column in list(df.columns)]
df.rename(index={df.shape[0]-1: 'mean'}, inplace=True)
print(df)
break
print('-----------------------------\n', stats_V25A)
效果: