← 返回题库
中级

利润表分析:Q4季度利润异常识别

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

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

    total_net = df['____'].sum()
    total_ded = df['____'].sum()

    df['____'] = (____).round(____)
    df['____'] = (____).round(____)

    def is_abnormal(____):
        if (____):
            return '____'
        return '____'

    df['____'] = df.apply(____)

    result = df[['____', '____', '____', '____', '____', '____']]
    return result.to_string()

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

示例

输入
solve()
期望输出
quarter  net_profit  deducted_profit   净利润占比  扣非净利润占比  是否异常扭亏 | 0      Q1     -299.65          -331.89 -0.6946   0.2180      正常 | 1      Q2     -498.22          -509.01 -1.1548   0.3343      正常 | 2      Q3     -614.02          -619.38 -1.4232   0.4068      正常 | 3      Q4     1843.32           -62.12  4.2726   0.0408  ⚠ 异常扭亏
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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