统计上报数据有效率

def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    payloads_csv = open_url("https://data.zuihe.com/dbd/ms-iot/state_01/raw_payloads.csv").read()
    payloads = pd.read_csv(StringIO(payloads_csv))
    total = len(payloads); valid = payloads['is_valid'].sum()
    print(f"总上报: {total}, 有效: {valid}, 无效: {total-valid}")
    print(f"有效率: {valid/total:.1%}")
    print("错误类型分布:")
    err_dist = payloads[payloads['is_valid']==0]['error_type'].value_counts()
    for etype, cnt in err_dist.items(): print(f"  {etype}: {cnt}")
    print("各设备有效率:")
    for did, grp in payloads.groupby('device_id'):
        rate = grp['is_valid'].mean()
        print(f"  {did}: {rate:.1%}")