← 返回题库
中级

利润表分析:上下半年毛利率差异显著性检验

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

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

    h2_rev = fy18['____'] - h1['____']
    h2_cost = fy18['____'] - h1['____']

    gm_17 = round((____) / fy17['____'], ____)
    gm_h1 = round((____) / h1['____'], ____)
    gm_h2 = round((____) / h2_rev, ____)

    diff_h2h1 = round((____) * ____, ____)
    diff_h2fy = round((____) * ____, ____)

    abs_diff = abs(____)
    if abs_diff > ____:
        rating = '____'
    elif abs_diff > ____:
        rating = '____'
    else:
        rating = '____'

    lines = [
        f"____",
        f"____",
        f"____",
        f"____",
        f"____",
        f"____",
    ]
    return '____'.join(____)

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

示例

输入
solve()
期望输出
2017FY毛利率: 0.1524 | 2018H1毛利率: 0.1694 | 2018H2毛利率: 0.251 | H2与H1差异(pp): 8.16 | H2与2017FY差异(pp): 9.86 | 风险评级: 高风险
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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