小学排课系统：使用Python和Pandas库实现智能排课

{ "title": "小学排课系统：使用Python和Pandas库实现智能排课", "description": "本文介绍如何使用Python和Pandas库开发一个小学排课系统，实现根据年级、班级、课程和教师的约束条件自动生成排课表并导出为Excel文件。代码示例包含课程设置、排课逻辑和Excel导出，可供学习和参考。", "keywords": "小学排课, Python, Pandas, Excel, 自动排课, 排课系统", "content": "下面是使用pandas库编写的Python代码，用于排课并将结果输出为Excel文件：\n\npython\nimport pandas as pd\n\n\ndef generate_schedule():\n # 创建空的排课表\n schedule = pd.DataFrame(columns=['Grade', 'Class', 'Teacher', 'Subject', 'Period'])\n\n # 定义各年级的课程和课时量\n subjects = {\n '1st Grade': {'Math': 3, 'Chinese': 3, 'English': 3, 'PE': 2},\n '2nd Grade': {'Math': 3, 'Chinese': 3, 'English': 3, 'PE': 2},\n '3rd Grade': {'Math': 3, 'Chinese': 3, 'English': 3, 'PE': 2},\n '4th Grade': {'Math': 2, 'Chinese': 2, 'English': 2, 'PE': 2},\n '5th Grade': {'Math': 2, 'Chinese': 2, 'English': 2, 'PE': 2},\n '6th Grade': {'Math': 2, 'Chinese': 2, 'English': 2, 'PE': 2}\n }\n\n # 遍历每个年级和班级进行排课\n for grade in subjects.keys():\n if grade == '2nd Grade':\n classes = ['Class 1', 'Class 2']\n else:\n classes = ['Class']\n\n for class_name in classes:\n # 获取当前年级和班级的课程和课时量\n class_subjects = subjects[grade]\n\n # 遍历每个老师进行排课\n for i in range(11):\n teacher_name = f'Teacher {i+1}'\n teacher_subjects = class_subjects.copy()\n\n # 遍历每个课程进行排课\n for subject, period in teacher_subjects.items():\n # 检查课程是否已经排满\n if period <= 0:\n continue\n\n # 检查是否满足排课条件\n if subject in ['Math', 'Chinese', 'English'] and period >= 3:\n continue\n if subject == 'PE' and period >= 3:\n continue\n if schedule[(schedule['Grade'] == grade) & (schedule['Class'] == class_name) & (schedule['Teacher'] == teacher_name) & (schedule['Subject'] == subject)].shape[0] >= 3:\n continue\n if schedule[(schedule['Grade'] == grade) & (schedule['Class'] == class_name) & (schedule['Period'] == 1) & (schedule['Subject'] == subject)].shape[0] >= 1:\n continue\n\n # 更新排课表\n schedule = schedule.append({'Grade': grade, 'Class': class_name, 'Teacher': teacher_name, 'Subject': subject, 'Period': 0}, ignore_index=True)\n teacher_subjects[subject] -= 1\n\n # 更新老师的课时量\n class_subjects[subject] -= 1\n\n # 更新班级的课时量\n if class_name == 'Class':\n subjects[grade][subject] -= 1\n else:\n subjects[grade][subject] -= 2\n\n return schedule\n\n\ndef save_schedule_to_excel(schedule):\n writer = pd.ExcelWriter('schedule.xlsx')\n schedule.to_excel(writer, index=False)\n writer.save()\n\n\nif __name__ == '__main__':\n schedule = generate_schedule()\n save_schedule_to_excel(schedule)\n\n\n这段代码使用pandas库创建了一个空的排课表，并定义了各年级的课程和课时量。然后，通过遍历每个年级和班级，以及每个老师和课程，依次进行排课。\n\n在排课过程中，根据题目给出的条件进行判断和筛选，判断是否满足排课条件，并更新排课表、老师的课时量以及班级的课时量。\n\n最后，将排好的课表保存为Excel文件。