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))