统计学生得分情况

import pandas as pd
import os
import re
'''
任务目标是:统计学生实验报告的得分情况到excel表格中
'''

for banji in [203,204]:
    student=pd.read_excel(f"./备份_打分情况/student{banji}.xlsx")
    root_baogao=f"./备份_归档的实验报告/计科{banji}"
    for shiyan in [1,2,3,4,5]:
        # 获得实验目录
        root_shiyan=root_baogao+f"/实验{shiyan}"
        #遍历姓名,找到他在哪个文件夹下
        for name in student["姓名"]:
            for folder in ["优","良","中"]:
                root_folder=root_shiyan+f"/{folder}"
                folder_list=os.listdir(root_folder)
                # 如果名字出现在这个文件夹里面,就说明他的评级为这一级
                if name in str(folder_list):#我真聪明,将目录列表转化为字符串,这样就不用遍历列表查看是否有这个name了.
                    student.loc[student["姓名"]==name,f"实验{shiyan}"]=folder
    student.to_excel(f"./result_打分表/student{banji}.xlsx")
if __name__=="__main__":
    pass