import pandas as pd
student = pd.read_excel("C:/Users/zuxia/Downloads/019/Students.xlsx",index_col='ID')
temp = student[['Test_1', 'Test_2', 'Test_3']]
row_sum = temp.sum(axis=1)
row_sum = temp.mean(axis=1)
#将数据添加到DataFrom中
student['Total'] = row_sum
student['Average'] = row_sum
col_mean = student[['Test_1', 'Test_2', 'Test_3','Total','Average']].mean()
col_mean['Name'] = 'Summary'
student.append(col_mean, ignore_index=True)
print(student)
pandas-求和-求平均-统计导引
最新推荐文章于 2024-05-06 14:07:24 发布