← 返回题库
中级

利润表分析:季度数据与年度数据一致性检验

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

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

# 题目描述
"____""____"不一致(需关注)"____""____"

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

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

    q_sum = q_df[['____', '____', '____']].sum()
    annual = a_df[a_df['____'] == ____].iloc[____]

    items = ['____', '____', '____']
    labels = ['____', '____', '____']
    rows = []
    for col, label in zip(____):
        q_val = q_sum[col]
        a_val = annual[col]
        diff = q_val - a_val
        rate = round(abs(____) / abs(____), ____) if a_val != ____ else None
        flag = '____' if rate and rate > ____ else '____'
        rows.append({'____': label, '____': round(____), '____': round(____),
                     '____': round(____), '____': rate, '____': flag})

    return pd.DataFrame(____).to_string()

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

示例

输入
solve()
期望输出
指标      季度合计      年度数据    差异值     差异率        结论 | 0   营业收入  10523.02  10523.02   0.00  0.0000        一致 | 1  归母净利润    431.43    344.26  87.17  0.2532  不一致(需关注) | 2  扣非净利润  -1522.40  -1522.40   0.00  0.0000        一致
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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