Farm Worker Task Agent

import pandas as pd
from datetime import datetime

def assign_tasks():
    tasks = pd.read_sql("SELECT * FROM pending_tasks ORDER BY priority DESC")
    workers = pd.read_sql("SELECT * FROM workers WHERE available = 1")
    assignments = []
    for _, task in tasks.iterrows():
        available = [w for w in workers.itertuples() if w.skill == task.skill_needed]
        if available:
            assignments.append({'task': task.name, 'worker': available[0].name, 'status': 'Assigned'})
    return pd.DataFrame(assignments)