#coding=utf-8 import os import pandas as pd import copy
defGetAllFileNamesInDirectory(mulu): all_files = [] for root, _, files in os.walk(mulu): for file in files: all_files.append(file) return all_files list_path = GetAllFileNamesInDirectory("D:\\Desktop\\幼儿园大班作业") #作业存放的路径
path = 'D:\\Desktop\\名单.xlsx'#班级人员名单表格的路径 frame = pd.read_excel(path) listClassOwners=frame.values.tolist() peopleWhoDonHandInTheirHomework = listClassOwners personHandingInHomework = [] print(path+"里面一共有"+str(len(listClassOwners))+"位同学") for allfile in list_path: for num_name in listClassOwners: for num in num_name: if allfile.find(num)!=-1 : ls=[] ls.append(num) personHandingInHomework.append(num) if ls in peopleWhoDonHandInTheirHomework: peopleWhoDonHandInTheirHomework.remove(ls) else: pass break print("一共有"+str(len(personHandingInHomework))+"位同学交作业") print("交作业的人有:"+str(personHandingInHomework)+"") print("一共有"+str(len(peopleWhoDonHandInTheirHomework))+"位同学没有交作业") print("没有交作业的人有:"+str(peopleWhoDonHandInTheirHomework))