求每行每列的平均值和总和

#需求：求分数的平均值和总和
#1、导入包
import pandas as pd
s = pd.read_excel(r"D:\pythonProject\Pandas玩转Excel-"
                  r"源代码\代码\019\Students.xlsx",index_col="ID")
#2、择需要计算的列
temp = s[["Test_1","Test_2","Test_3"]]

#3、新建一列，axis选按行计算平均值
s["和"] = temp.sum(axis=1)
s["平均值"] = temp.mean(axis=1)
#4、按列计算和的平均值
col_mean =s[[ "Name" ,"Test_1",  "Test_2",  "Test_3","和","平均值"]].mean()
col_mean['Name'] = "平均值"
s = s.append(col_mean,ignore_index=True)
print(s)