中级
实现批量传感器数据导出为宽表格式
未完成
中级参考
代码结构已给出,请填写 ____ 处
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
👑
升级 VIP
解锁全部题目,畅通无阻地学习
- ✓ 解锁全部训练包所有题目
- ✓ 查看完整参考代码和提示
- ✓ 浏览器内直接运行 Python 代码
- ✓ 自动批改 + 进度追踪
30天
¥18
1年
¥99
2年
¥158
3年
¥199