← 返回题库
中级

将三种格式统一为标准格式

未完成
中级参考 代码结构已给出,请填写 ____ 处
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd, json
    devs_csv = open_url(____).read()
    devs = pd.read_csv(StringIO(____))
    def normalize(____):
        p = json.loads(____)
        rows = []
        if fmt == '____':
            for r in p.get(____):
                rows.append({'____':device_id,'____':p['____'],'____':r['____'],'____':r['____'],'____':r.get(____)})
        elif fmt == '____':
            mapping = {'____':(____),'____':(____),'____':(____),'____':(____)}
            for k,(____) in mapping.items():
                if k in p: rows.append(____)
        return rows
    tests = [
        (____),
        (____),
    ]
    all_rows = []
    for did,fmt,payload in tests:
        rows = normalize(____)
        all_rows.extend(____)
    print("____" + str(len(____)))
    for row in all_rows:
        print("____" + row['____'] + "____" + row['____'] + "____" + str(____) + row['____'])

示例

输入
solve()
期望输出
Normalized rows: 3
  RPI-001 cpu_temp=52.3degC
  ARD-001 temperature=25.4degC
  ARD-001 humidity=60.2%
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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