按设备类型筛选设备列表

def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    devs_csv = open_url("https://data.zuihe.com/dbd/ms-iot/state_00/devices.csv").read()
    devs = pd.read_csv(StringIO(devs_csv))
    def filter_devices(df, device_type=None, status=None):
        result = df.copy()
        if device_type: result = result[result['device_type']==device_type]
        if status: result = result[result['status']==status]
        return result[['device_id','device_name','device_type','status']]
    for dt in ['temperature','vibration','pressure']:
        filtered = filter_devices(devs, device_type=dt)
        print(f"{dt}: {list(filtered['device_id'])}")
    online = filter_devices(devs, status='online')
    print(f"online: {len(online)}台")