← 返回题库
中级

实现屏幕维度日报聚合

未完成
中级参考 代码结构已给出,请填写 ____ 处
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    pl_csv = open_url(____).read()
    imp_csv = open_url(____).read()
    playback = pd.read_csv(StringIO(____))
    impressions = pd.read_csv(StringIO(____))
    BASE_TS = ____
    def gen_daily_report(____):
        day_start = BASE_TS + date_offset * ____
        day_end = day_start + ____
        day_plays = playback[(____)&(____)]
        day_imps = impressions[(____)&(____)]
        by_screen = day_plays.groupby(____).agg(play_count=(____),complete_count=(____)).reset_index()
        by_screen = by_screen.merge(day_imps.groupby(____).size().reset_index(____), on='____', how='____')
        by_screen['____'] = by_screen['____'].fillna(____).astype(____)
        by_screen['____'] = (____).round(____)
        return by_screen
    report = gen_daily_report(____)
    print(____)
    print("____"+str(len(____)))
    for _, row in report.head(____).iterrows():
        print("____"+row['____']+"____"+str(____)+"____"+str(____)+"____"+str(____)+"____"+str(____))

示例

输入
solve()
期望输出
Screen daily report (day 1):
  Total screens with plays: 59
  SCR-0003: plays=8 complete=8(100.0%) imps=8
  SCR-0005: plays=8 complete=8(100.0%) imps=8
  SCR-0006: plays=8 complete=8(100.0%) imps=8
  SCR-0008: plays=16 complete=16(100.0%) imps=16
  SCR-0011: plays=8 complete=6(75.0%) imps=6
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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