#求平均值
df['avg']=df[['ASRREA01','ASRREA02','ASRREA03','ASRREA04','ASRREA05',
'ASRLIT01','ASRLIT02','ASRLIT03','ASRLIT04','ASRLIT05',
'ASRINF01','ASRINF02','ASRINF03','ASRINF04','ASRINF05',
'ASRIIE01','ASRIIE02','ASRIIE03','ASRIIE04','ASRIIE05',
'ASRRSI01','ASRRSI02','ASRRSI03','ASRRSI04','ASRRSI05']].mean(axis=1)
dfavgclass=df[['IDSTUD','IDCLASS','avg']]
dfavgclass.head()
#把学号和成绩搞出来，然后输出保存成csv
outputpath1='dfavgclass.csv'
dfavgclass.to_csv(outputpath1,sep=',',index=False,header=True)
#index=True表示保留索引
#header=True表示保留列名
标签：index,df,dfavgclass,header,求列,avg,True,pandas,平均分 From： https://www.cnblogs.com/bojiandkake/p/17121382.html