← 返回题库
中级

实现批量传感器数据导出为宽表格式

未完成
中级参考 代码结构已给出,请填写 ____ 处
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    readings_csv = open_url(____).read()
    readings = pd.read_csv(StringIO(____))
    soil = readings[readings['____'].isin(____)]
    soil = soil.copy()
    soil['____'] = (____).astype(____)
    pivot = soil.pivot_table(____).reset_index()
    pivot.columns.name = None
    pivot = pivot.round(____)
    print(____)
    for _, row in pivot.head(____).iterrows():
        line = row['____']+"____"+str(int(____))+"____"
        for m in ['____','____','____']:
            if m in pivot.columns:
                line += "____"+m+"____"+str(row.get(____))
        print(____)

示例

输入
solve()
期望输出
Wide table (device_id x hour x metrics):
  SOIL-A01 h=485760: soil_moisture=76.01 soil_temp=25.2 soil_ec=2.46
  SOIL-A01 h=485761: soil_moisture=70.42 soil_temp=23.23 soil_ec=2.36
  SOIL-A01 h=485762: soil_moisture=78.84 soil_temp=23.08 soil_ec=2.46
  SOIL-A01 h=485763: soil_moisture=74.14 soil_temp=19.97 soil_ec=2.12
  SOIL-A01 h=485764: soil_moisture=68.03 soil_temp=20.71 soil_ec=2.39
  SOIL-A01 h=485765: soil_moisture=73.69 soil_temp=23.94 soil_ec=2.36
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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