小学排课表生成器：Python代码实现自动排课

以下是使用Pandas库编写的Python代码，用于生成排课表并将其输出为Excel文件：\n\npython\nimport pandas as pd\n\n# 创建老师、年级和课程的列表\nteachers = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K']\ngrades = ['Grade1', 'Grade2', 'Grade3', 'Grade4', 'Grade5', 'Grade6']\ncourses = ['Chinese', 'Math', 'English', 'PE', 'Science', 'Art']\n\n# 创建空的排课表\ntimetable = pd.DataFrame(columns=['Teacher', 'Grade', 'Course', 'Day', 'Period'])\n\n# 遍历老师、年级和课程列表，生成排课表\nfor teacher in teachers:\n for grade in grades:\n for course in courses:\n # 如果是语数英课程，则排在1-3节课之间\n if course in ['Chinese', 'Math', 'English']:\n periods = [1, 2, 3]\n # 如果是体育课程，则不排在1-3节课之间\n elif course == 'PE':\n periods = [4, 5, 6, 7]\n # 其他课程排在任意时间段\n else:\n periods = [1, 2, 3, 4, 5, 6, 7]\n \n # 遍历每天和时间段，将课程安排到排课表中\n for day in range(1, 6):\n for period in periods:\n # 检查同一课程是否连续上\n if len(timetable[(timetable['Teacher'] == teacher) & (timetable['Course'] == course)]) > 0:\n last_period = timetable[(timetable['Teacher'] == teacher) & (timetable['Course'] == course)]['Period'].values[-1]\n if abs(last_period - period) == 1:\n continue\n \n # 检查同一课程是否每天出现3次\n if len(timetable[(timetable['Teacher'] == teacher) & (timetable['Course'] == course) & (timetable['Day'] == day)]) >= 3:\n continue\n \n # 将课程安排添加到排课表中\n timetable = timetable.append({'Teacher': teacher, 'Grade': grade, 'Course': course, 'Day': day, 'Period': period}, ignore_index=True)\n\n# 将排课表输出为Excel文件\ntimetable.to_excel('timetable.xlsx', index=False)\n\n\n上述代码根据所提供的要求，生成了一个排课表，其中包含了每个老师在每个年级上每门课程的安排。最后，将排课表输出为名为timetable.xlsx的Excel文件。