验证Arduino精简格式必填字段

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-devhub/state_01/raw_payloads.csv").read()
    payloads = pd.read_csv(StringIO(payloads_csv))
    def validate_compact(payload_str):
        try: p = json.loads(payload_str)
        except: return False, ['invalid_json']
        errors = []
        if 'id' not in p: errors.append('missing:id')
        if 'ts' not in p: errors.append('missing:ts')
        has_reading = any(k in p for k in ['t','h','p','l'])
        if not has_reading: errors.append('no_sensor_data')
        return len(errors)==0, errors
    arduino_payloads = payloads[payloads['format']=='compact_json']
    for _, row in arduino_payloads.iterrows():
        ok, errors = validate_compact(row['payload'])
        print("id=" + str(row['id']) + " " + row['device_id'] + ": " + ("OK" if ok else "FAIL " + str(errors)))