Industrial Control Dashboard Agent

import pandas as pd
import numpy as np

def dashboard_snapshot(plant_id):
    tags = pd.read_sql("SELECT * FROM plc_tags WHERE plant_id = ?", plant_id)
    snapshot = {}
    for _, tag in tags.iterrows():
        values = pd.read_sql("SELECT value FROM tag_history WHERE tag_id = ? ORDER BY ts DESC LIMIT 10", tag['id'])
        mean = values['value'].mean()
        std = values['value'].std()
        latest = values['value'].iloc[0]
        snapshot[tag['name']] = {'current': latest, 'target': tag['setpoint'], 'status': 'Normal' if abs(latest - tag['setpoint']) < 2*std else 'Warning' if abs(latest - tag['setpoint']) < 3*std else 'Critical'}
    return snapshot