import pandas as pd

创建一个包含老师、课程和班级信息的字典

timetable = { 'Teacher': ['Teacher1', 'Teacher2', 'Teacher3', 'Teacher4', 'Teacher5', 'Teacher6', 'Teacher7', 'Teacher8', 'Teacher9', 'Teacher10', 'Teacher11'], 'Course': ['Math', 'English', 'Science', 'Chinese', 'Art', 'Music', 'PE', 'History', 'Geography', 'Computer', 'Health'], 'Class': ['Class1', 'Class2', 'Class3', 'Class4', 'Class5', 'Class6', 'Class7', 'Class8', 'Class9', 'Class10', 'Class11'] }

创建一个空的DataFrame来存储课程表

df = pd.DataFrame()

遍历每个老师，为每个老师安排一天的课程

for teacher in timetable['Teacher']: # 为每个老师创建一天的课程表 teacher_schedule = pd.DataFrame({'Teacher': [teacher], '8:00-9:00': [''], '9:00-10:00': [''], '10:00-11:00': [''], '11:00-12:00': [''], '12:00-13:00': [''], '13:00-14:00': [''], '14:00-15:00': [''], '15:00-16:00': [''], '16:00-17:00': [''], '17:00-18:00': ['']}) # 将老师的课程表添加到整体课程表中 df = df.append(teacher_schedule, ignore_index=True)

为每个老师安排合适的课程和班级

for index, row in df.iterrows(): teacher = row['Teacher'] course = timetable['Course'][index % len(timetable['Course'])] classs = timetable['Class'][index % len(timetable['Class'])] df.at[index, '8:00-9:00'] = f'{course} - {classs}'

将课程表输出到Excel文件

df.to_excel('timetable.xlsx', index=False