Control & Instrumentation Monitoring Agent

import pandas as pd, json
from datetime import datetime

scada = pd.read_csv('scada_export.csv')
alarms = scada[scada['type'] == 'ALARM']

summary = {
    "total_tags": len(scada['tag'].unique()),
    "active_alarms": len(alarms[alarms['status'] == 'active']),
    "oee": {
        "availability": 0.92,
        "performance": 0.88,
        "quality": 0.97,
        "overall": 0.92 * 0.88 * 0.97
    },
    "top_alarm_sources": alarms['source'].value_counts().head(5).to_dict()
}
print(json.dumps(summary, indent=2))