python成绩

import pandas as pd
df = pd.read_excel('C:\Users\60963\Desktop\Python成绩登记统计.xlsx')
da = df.to_csv('C:\gg\Python_1.csv')
da = pd.read_csv('C:\gg\Python_1.csv',index_col=0)
da = da.replace('优秀','90')
da = da.replace('良好','80')
da = da.replace('合格','60')
da = da.replace('不合格','0')
da = da.fillna(0)
print(da)

  

posted @ 2020-05-27 11:21  youngTW  阅读(203)  评论(0)    收藏  举报