← 返回题库
初级

检测未知设备ID上报

未完成
初级参考 完整示例代码供参考，建议自己理解后重新输入 
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()
    devs_csv = open_url("https://data.zuihe.com/dbd/ms-iot/state_01/devices.csv").read()
    payloads = pd.read_csv(StringIO(payloads_csv))
    devs = pd.read_csv(StringIO(devs_csv))
    valid_ids = set(devs['device_id'])
    unknown = payloads[payloads['error_type']=='unknown_device']
    all_dids = payloads['device_id'].unique()
    for did in all_dids:
        ok = did in valid_ids
        flag = 'valid' if ok else 'UNKNOWN'
        print(f"{did}: {flag}")
    print(f"未知设备上报: {len(unknown)}条")

示例

输入
solve()
期望输出
DEV001: valid
DEV003: valid
DEV004: valid
DEV099: UNKNOWN
DEV002: valid
DEV005: valid
DEV007: valid
DEV008: valid
DEV009: valid
未知设备上报: 1条
Python 代码 🔒 登录后使用
🔒

登录后即可练习

注册免费账号，在浏览器中直接运行 Python 代码

登录 免费注册