小技巧:取DataFrame的一部分来做分析
temp = student[['tset1', 'test2', 'test3']]
求和
求平均值
row_sum = students[['Test_1', 'Test_2', 'Test_3']].sum(axis=1)
row_mean = students[['Test_1', 'Test_2', 'Test_3']].mean(axis=1)
students['Total'] = row_sum
students['Average'] = row_mean
纵向求平均值
col_mean = students[['Test_1', 'Test_2', 'Test_3', 'Total', 'Average']].mean()
col_mean['Name'] = 'Summary'
students = students.append(col_mean, ignore_index=True)
一定要加上ignore_index=True,避免顺序乱