验证设备上报必填字段

def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd, json
    payloads_csv = open_url("https://data.zuihe.com/dbd/ms-iot/state_01/raw_payloads.csv").read()
    payloads = pd.read_csv(StringIO(payloads_csv))
    REQUIRED = ['device_id', 'timestamp', 'readings']
    def validate_required(payload_str):
        try:
            payload = json.loads(payload_str)
        except: return False, ['invalid_json']
        missing = [f for f in REQUIRED if f not in payload]
        return len(missing)==0, missing
    for _, row in payloads.iterrows():
        ok, missing = validate_required(row['payload'])
        label = 'OK' if ok else f'MISSING:{missing}'
        print(f"id={row['id']} dev={row['device_id']}: {label}")