#/usr/bin/env python
#coding:utf-8

import pandas as pd

writer = pd.ExcelWriter('/Users/yyc/Downloads/score.xlsx')
data1 = pd.read_excel('/Users/yyc/Downloads/score.xlsx', sheet_name='old', encoding='utf-8')

# 保存sheetname=old
data1.to_excel(writer, sheet_name='old', index=False)

#增加列的求平均数和总数和
temp = data1[['Chinese', 'Math', 'English']]
data1['Avg'] = temp.sum(axis=1)
data1['Sum'] = temp.mean(axis=1)

#增加行的平均数
col_mean = data1[['Chinese', 'Math', 'English', 'Avg', 'Sum']].mean()
col_mean['Name'] = 'Summary'
data1 = data1.append(col_mean, ignore_index=True)

# 保存sheetname=new
data2 = pd.DataFrame(data1)
data2.to_excel(writer, sheet_name='new', index=False)

#保存并关闭文件
writer.save()
writer.close()