← 返回题库
中级

利润表分析:多费用项目配比背离综合分析

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

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()))

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

    rev_growth = (____) / fy17['____']

    expense_items = [
        (____),
        (____),
        (____),
    ]

    rows = []
    for name, col in expense_items:
        v17 = fy17[col]
        v18 = fy18[col]
        growth = (____) / v17
        deviation = round(____)
        if deviation < -____:
            assessment = '____'
        elif deviation < -____:
            assessment = '____'
        elif deviation > ____:
            assessment = '____'
        else:
            assessment = '____'
        rows.append({
            '____': name,
            '____': v17,
            '____': v18,
            '____': round(____),
            '____': deviation,
            '____': assessment
        })

    return pd.DataFrame(____).to_string()

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

示例

输入
solve()
期望输出
费用项目   2017FY    2018FY     增长率     背离值        配比评估 | 0  销售费用  1600000   1620000  0.0125 -0.3864  严重低配(高度可疑) | 1  管理费用  9000000  10550000  0.1722 -0.2267  严重低配(高度可疑) | 2  财务费用  2800000   3200000  0.1429 -0.2561  严重低配(高度可疑)
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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