← 返回题库
中级

实现区域维度周报聚合

未完成
中级参考 代码结构已给出,请填写 ____ 处
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    ds_csv = open_url(____).read()
    imp_csv = open_url(____).read()
    scr_csv = open_url(____).read()
    daily_stats = pd.read_csv(StringIO(____))
    impressions = pd.read_csv(StringIO(____))
    screens = pd.read_csv(StringIO(____))
    merged_imps = impressions.merge(____)
    print(____)
    for region, grp in merged_imps.groupby(____):
        total_imps = len(____)
        print("____"+str(____)+"____"+str(____))
    total_cost_by_model = daily_stats.groupby(____)['____'].sum().round(____)
    print(____)
    for model, cost in total_cost_by_model.items():
        print("____"+model+"____"+str(____)+"____")
    print("____"+str(round(daily_stats['____'].sum(),____))+"____")

示例

输入
solve()
期望输出
Weekly report by region:
  天河: impressions=779
  朝阳: impressions=785
  江汉: impressions=764
  浦东: impressions=1234
  海淀: impressions=576
Total cost by billing model:
  CPD: 15120.0 CNY
  CPM: 19.35 CNY
  CPT: 106500.0 CNY
Grand total cost: 121639.35 CNY
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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