← 返回题库
初级

解析广告素材元数据JSON

未完成
初级参考 完整示例代码供参考，建议自己理解后重新输入 
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    crv_csv = open_url("https://data.zuihe.com/dbd/ms-adlift/state_02/creatives.csv").read()
    creatives = pd.read_csv(StringIO(crv_csv))
    print("Creative metadata (first 5):")
    for _, row in creatives.head(5).iterrows():
        print("  "+row['creative_id']+" ["+row['file_type']+"] dur="+str(row['duration_sec'])+"s size="+str(round(row['file_size_mb'],1))+"MB res="+row['resolution']+" status="+row['review_status'])
    print("By type: "+str(dict(creatives.groupby('file_type').size())))
    print("By status: "+str(dict(creatives.groupby('review_status').size())))

示例

输入
solve()
期望输出
Creative metadata (first 5):
  CRV-0001 [MP4] dur=5s size=51.4MB res=1280x720 status=approved
  CRV-0002 [MP4] dur=25s size=49.5MB res=1280x720 status=approved
  CRV-0003 [MP4] dur=18s size=17.4MB res=1280x720 status=approved
  CRV-0004 [JPG] dur=0s size=5.1MB res=1920x1080 status=rejected
  CRV-0005 [JPG] dur=0s size=1.1MB res=720x1280 status=approved
By type: {'JPG': np.int64(33), 'MP4': np.int64(44), 'PNG': np.int64(43)}
By status: {'approved': np.int64(66), 'pending': np.int64(23), 'rejected': np.int64(31)}
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册