← 返回题库
中级

对比电动车、折叠车与普通车的骑行数据

未完成
中级参考 代码结构已给出，请填写 ____ 处 
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    trips=pd.read_csv(StringIO(open_url(____).read()))
    bikes=pd.read_csv(StringIO(open_url(____).read()))
    merged=trips.merge(____)
    stats=merged.groupby(____).agg(count=(____),avg_dur=(____),avg_dist=(____),avg_fee=(____)).round(____)
    print(____)
    for btype,row in stats.iterrows():
        print(____)

示例

输入
solve()
期望输出
Trip stats by bike type:
  ebike: count=100 avg_dur=47.06min avg_dist=9.4km avg_fee=2.87
  folding: count=26 avg_dur=45.65min avg_dist=9.11km avg_fee=3.05
  regular: count=174 avg_dur=48.06min avg_dist=9.64km avg_fee=3.06
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册