按照签到次数对学生报告进行分组

import os
import re
import pandas as pd
import shutil
# 读取签到表
student_203 = pd.read_excel("./备份_签到情况/student203.xlsx")
student_204 = pd.read_excel("./备份_签到情况/student204.xlsx")


# result建立好报告文件夹
def jianlibaogaowenjianjia(result_baogao="./result/实验报告"):
    os.makedirs(result_baogao, exist_ok=True)
    for i in [203, 204]:
        result_class = result_baogao + f"/计科{i}"
        os.makedirs(result_class, exist_ok=True)
        for j in [1, 2, 3, 4, 5]:
            result_shiyanj = result_class + f"/实验{j}"
            os.makedirs(result_shiyanj, exist_ok=True)
            for t in ["优", "良", "中"]:
                result_t = result_shiyanj + f"/{t}"
                os.makedirs(result_t, exist_ok=True)


jianlibaogaowenjianjia(result_baogao="./result/实验报告")

root_baogao = "./备份_实验报告/"
count=0
for i in [203, 204]:
    root_class = root_baogao + f"/计科{i}"
    for j in [1, 2, 3, 4, 5]:
        # 进入到一个实验里面
        root_shiyanj = root_class + f"/实验{j}"
        shiyan_list = os.listdir(root_shiyanj)
        # print(shiyan_list,end=" ")
        #遍历班级表姓名,遍历文件名,找到对应的文件名
        student= student_203 if i == 203 else student_204
        for name,qiandao in zip(student["姓名"],student["签到"]):
            for wenjian in shiyan_list:
                if name in wenjian:
                    #完成签到表姓名与报告文件姓名的匹配:
                    #然后就移动文件:
                    if qiandao==2 or qiandao==3:
                        grad="优"
                    elif qiandao==1:
                        grad="良"
                    elif qiandao==0:
                        grad="中"
                    else:
                        print("错误!没有签到情况",name,qiandao)
                        exit(0)
                    root_old=f"{root_shiyanj}/{wenjian}"
                    root_new=f"./result/实验报告/计科{i}/实验{j}/{grad}/{wenjian}"
                    # shutil.copyfile(root_old,root_new)
                    shutil.move(root_old,root_new)
                    count+=1
print("移动完毕,共移动文件数为:",count)
if __name__ == "__main__":
    # 程序出口
    student_203.to_excel("./result/打分情况/student203.xlsx")
    student_204.to_excel("./result/打分情况/student204.xlsx")