训练 材料 代理

import pandas as pd

def recommend_training(staff_id):
    gaps = pd.read_sql("SELECT * FROM skill_gaps WHERE staff_id = ?", staff_id)
    modules = pd.read_sql("SELECT * FROM training_modules")
    recommendations = []
    for _, gap in gaps.iterrows():
        match = modules[modules['skill'].str.contains(gap['skill'], case=False)]
        if not match.empty:
            recommendations.append(match.iloc[0].to_dict())
    return recommendations