小学遗传排课算法：Python Pandas实现Excel表格输出

下面是使用Pandas库编写的排课代码：

import pandas as pd
import numpy as np

# 定义课程和老师
courses = ['语文', '数学', '英语', '体育']
teachers = ['A老师', 'B老师', 'C老师', 'D老师', 'E老师', 'F老师', 'G老师', 'H老师', 'I老师', 'J老师', 'K老师']

# 定义每个年级的班级数量
grades = ['一年级', '二年级', '三年级', '四年级', '五年级', '六年级']
class_nums = [1, 2, 1, 1, 1, 1]

# 创建排课表
schedule = pd.DataFrame(columns=['年级', '班级', '星期', '时间', '课程', '老师'])

# 遗传排课
def genetic_scheduling(schedule, courses, teachers, grades, class_nums):
    for i, grade in enumerate(grades):
        for j in range(class_nums[i]):
            for k in range(5):  # 一周5天
                for l in range(7):  # 一天7节课
                    # 随机选择一个老师和课程
                    teacher = np.random.choice(teachers)
                    course = np.random.choice(courses)
                    
                    # 检查课程是否已经排满
                    if schedule[(schedule['年级'] == grade) & (schedule['班级'] == j) & (schedule['课程'] == course)].shape[0] >= 3:
                        continue
                    
                    # 检查老师是否已经排满
                    if schedule[(schedule['年级'] == grade) & (schedule['班级'] == j) & (schedule['老师'] == teacher)].shape[0] >= 3:
                        continue
                    
                    # 检查课程和老师是否冲突
                    if schedule[(schedule['年级'] == grade) & (schedule['班级'] == j) & (schedule['星期'] == k) & (schedule['时间'] == l) & (schedule['课程'] == course)].shape[0] > 0:
                        continue
                    
                    if schedule[(schedule['年级'] == grade) & (schedule['班级'] == j) & (schedule['星期'] == k) & (schedule['时间'] == l) & (schedule['老师'] == teacher)].shape[0] > 0:
                        continue
                    
                    # 添加课程和老师到排课表
                    schedule = schedule.append({'年级': grade, '班级': j, '星期': k, '时间': l, '课程': course, '老师': teacher}, ignore_index=True)
    
    return schedule

# 调用遗传排课函数
schedule = genetic_scheduling(schedule, courses, teachers, grades, class_nums)

# 将排课表输出到Excel文件
schedule.to_excel('schedule.xlsx', index=False)

这段代码使用遗传排课的方式，随机选择老师和课程，并检查课程和老师是否已经排满，以及课程和老师是否冲突。最终将排课表输出到Excel文件中。请确保已经安装了Pandas库和Numpy库。