← 返回题库
中级

实现素材下发优先级排序

未完成
中级参考 代码结构已给出,请填写 ____ 处
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    crv_csv = open_url(____).read()
    creatives = pd.read_csv(StringIO(____))
    approved = creatives[creatives['____']=='____'].copy()
    NET_FACTOR = {'____':____,'____':____,'____':____,'____':____}
    def priority(____):
        size_score = ____ / (float(____) + ____)
        net_f = NET_FACTOR.get(____)
        urg_b = ____ if urgent else ____
        return round(____)
    approved = approved.copy()
    approved['____'] = approved.apply(lambda r: priority(____), axis=____)
    sorted_q = approved.sort_values(____)
    print(____)
    for _, row in sorted_q.head(____).iterrows():
        print("____"+row['____']+"____"+row['____']+"____"+str(round(____))+"____"+str(____))

示例

输入
solve()
期望输出
Download queue (top 8, net=good):
  CRV-0040 [JPG] size=0.2MB priority=0.6667
  CRV-0058 [JPG] size=0.2MB priority=0.6504
  CRV-0027 [PNG] size=0.3MB priority=0.6015
  CRV-0075 [PNG] size=0.3MB priority=0.6015
  CRV-0057 [PNG] size=0.4MB priority=0.5674
  CRV-0117 [PNG] size=0.5MB priority=0.5442
  CRV-0012 [JPG] size=0.5MB priority=0.5405
  CRV-0064 [PNG] size=0.5MB priority=0.5229
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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