07.计算和与平均数

计算和与平均数，并补全最后新增的一列

 1 import pandas as pd
 2 
 3 students = pd.read_excel('Students.xlsx',index_col='ID')
 4 
 5 # print(students)
 6 
 7 temp = students[['Test_1','Test_2','Test_3']]
 8 row_sum = temp.sum(axis=1)  # axis=1按列汇总
 9 row_mean = temp.mean(axis=1)
10 # print(row_sum)
11 # print(row_mean)
12 
13 students['Total']=row_sum
14 students['Average']=row_mean
15 
16 col_mean=students[['Test_1','Test_2','Test_3','Total','Average']].mean()
17 col_mean['Name']='Summary'
18 students=students.append(col_mean,ignore_index=True)
19 print(students)

posted on 2019-02-21 17:57 Canvas2018 阅读(113) 评论(0) 收藏举报