← 返回题库
中级

闻嗅复核:多指标异常差异率综合判断

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

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[____]
    fy = df[df['____'] == '____'].iloc[____]

    h2_rev = fy['____'] - h1['____']
    h2_cost = fy['____'] - h1['____']
    h2_sell = fy['____'] - h1['____']
    h2_op = fy['____'] - h1['____']
    h2_net = fy['____'] - h1['____']

    h1_gm = (____) / h1['____']
    h2_gm = (____) / h2_rev

    rows = []
    items = [
        (____),
        (____),
        (____),
        (____),
        (____),
        (____),
    ]
    for name, v1, v2 in items:
        rate = round((____) / abs(____), ____)
        flag = '____' if abs(____) > ____ else '____'
        rows.append({'____': name, '____': round(____), '____': round(____),
                     '____': rate, '____': flag})

    return pd.DataFrame(____).to_string()

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

示例

输入
solve()
期望输出
指标           H1值           H2值     差异率  关注级别 | 0  营业收入  1.204000e+08  2.163000e+08  0.7965  重点关注 | 1  营业成本  1.000000e+08  1.620000e+08  0.6200  重点关注 | 2   毛利率  1.694000e-01  2.510000e-01  0.4816  重点关注 | 3  销售费用  8.200000e+05  8.000000e+05 -0.0244    正常 | 4  营业利润  1.286000e+07  4.975000e+07  2.8686  重点关注 | 5   净利润  9.390000e+06  3.760500e+07  3.0048  重点关注
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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