← 返回题库
中级

闻嗅复核:综合异常关注清单生成

未完成
中级参考 代码结构已给出,请填写 ____ 处
"____""____""____"

metadata = {
    "____": "____",
    "____": "____",
    "____": "____",
    "____": "____",
    "____": ["____"],
    "____": ["____", "____", "____"],
    "____": ____
}

# 题目描述
"____""____"重点关注清单"____"⚠ 重点关注"____"√ 正常"____""____"

def solve():
    import pandas as pd
    from pyodide.http import open_url
    from io import StringIO

    BASE_URL = "____"
    df = pd.read_csv(StringIO(open_url(____).read()))

    h1 = df[df['____'] == '____'].iloc[____]
    fy18 = df[df['____'] == '____'].iloc[____]
    fy17 = df[df['____'] == '____'].iloc[____]

    h2_rev = fy18['____'] - h1['____']
    h2_cost = fy18['____'] - h1['____']
    h2_sell = fy18['____'] - h1['____']
    h2_admin = fy18['____'] - h1['____']
    h2_op = fy18['____'] - h1['____']

    monthly_h2 = h2_rev / ____
    monthly_17 = fy17['____'] / ____

    gm_h2 = (____) / h2_rev
    gm_17 = (____) / fy17['____']
    sell_h2 = h2_sell / h2_rev
    sell_17 = fy17['____'] / fy17['____']
    admin_h2 = h2_admin / h2_rev
    admin_17 = fy17['____'] / fy17['____']
    op_h2 = h2_op / h2_rev
    op_17 = fy17['____'] / fy17['____']

    checks = [
        (____),
        (____),
        (____),
        (____),
        (____),
    ]

    rows = []
    for name, base, actual in checks:
        dev = round((____) / abs(____), ____)
        conclusion = '____' if abs(____) > ____ else '____'
        rows.append({'____': name, '____': round(____),
                     '____': round(____), '____': dev, '____': conclusion})

    return pd.DataFrame(____).to_string()

if __name__ == "____":
    print(solve())

示例

输入
solve()
期望输出
检查项目     基准值(2017)       实际值(H2)     偏差率      结论 | 0   月均收入  2.005717e+07  3.605000e+07  0.7974  ⚠ 重点关注 | 1    毛利率  1.524000e-01  2.510000e-01  0.6470  ⚠ 重点关注 | 2  销售费用率  6.600000e-03  3.700000e-03 -0.4436  ⚠ 重点关注 | 3  管理费用率  3.740000e-02  2.770000e-02 -0.2582  ⚠ 重点关注 | 4  营业利润率  9.180000e-02  2.300000e-01  1.5065  ⚠ 重点关注
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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