# -*- coding: utf8 -*-
import pandas as pd
ales_df = pd.read_excel("G:/anaconda/a2.xlsx", names=("姓名", "科目", "成绩", "评级", "工资"))
a = pd.DataFrame(ales_df.ix[:])
a1 = a.groupby(["评级", "姓名", "科目"])["成绩", "工资"].mean()
a2 = a1.reset_index() # 将a1结果转换为数据框
print(a1)
# a2.to_excel("F:/anaconda/work/a2345.xlsx", index=False)