按事件类型过滤设备事件

def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd, json
    events_csv = open_url("https://data.zuihe.com/dbd/ms-iot/state_05/device_events.csv").read()
    events = pd.read_csv(StringIO(events_csv))
    print("Event type distribution:")
    for etype, grp in events.groupby('event_type'):
        print("  " + etype + ": " + str(len(grp)))
    alarm_events = events[events['event_type']=='AlarmTriggered']
    print("AlarmTriggered (" + str(len(alarm_events)) + "):")
    for _, ev in alarm_events.iterrows():
        payload = json.loads(ev['payload'])
        print("  " + ev['device_id'] + " v" + str(ev['version']) + ": " + str(payload.get('metric')) + "=" + str(payload.get('value')) + " threshold=" + str(payload.get('threshold')))