求和，求平均，统计导引

最新推荐文章于 2024-09-15 22:31:42 发布

weixin_30361753

最新推荐文章于 2024-09-15 22:31:42 发布

阅读量57

点赞数

文章标签： python

原文链接：http://www.cnblogs.com/inserence/p/11061327.html

版权

import pandas as pd
students = pd.read_excel('D:/Temp/Students.xlsx',index_col='ID')
temp = students[['Test_1','Test_2','Test_3']]
row_sum = temp.sum(axis=1)
row_mean = temp.mean(axis=1)
students['Total'] = row_sum
students['Average'] = row_mean

col_mean=students[['Test_1','Test_2','Test_3','Total','Average']].mean()  #python没有Aver  只有mean
col_mean['Name']='Sumary'
students = students.append(col_mean,ignore_index = True)  #忽略索引

print(students)

转载于:https://www.cnblogs.com/inserence/p/11061327.html