Python:自动学分绩计算程序

 

#python3 学分绩自动计算程序 NCEPU-Qihongyu
#用excel把成绩乘上学分单独为一列，把【名字、课程学分、课程成绩、该课程最高分、课程成绩*课程学分】从excel中截取出来，存到01.txt里面。运行本程序，生成统计文件sta.csv

"""

https://blog.youkuaiyun.com/gusui7202/article/details/83239142

qhy。

"""



fi=open('01.txt','r',encoding='utf-8')
fo=open('sta.csv','w',encoding='utf-8')
words = fi.read().split('\n')
ls=[]
flagn=[]
flag=False
all_sore0={}#总成绩
all_sore1={}#总学分
jg={}
for word in words:
    word=word.split(',')
    all_sore0[word[0]]=all_sore0.get(word[0],0)+eval(word[4])
    all_sore1[word[0]]=all_sore1.get(word[0],0)+eval(word[1])
for k in all_sore0:
    for key in all_sore1:
        if k==key:
           jg[k]= all_sore0[k]/all_sore1[k]
for key in jg:
   fo.write("{},{}\n".format(key,jg[key]))
fi.close()
fo.close()