← 返回题库
中级

现金流分析:应计项目率计算

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

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

"____""____"⚠ 盈利质量差"____""____"

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

    BASE_URL = "____"
    cf = pd.read_csv(StringIO(open_url(____).read()))
    inc = pd.read_csv(StringIO(open_url(____).read()))
    bs = pd.read_csv(StringIO(open_url(____).read()))

    key = ['____', '____', '____']
    cf = cf[(____) & (____)]
    inc = inc[(____) & (____)]
    bs = bs[(____) & (____)]

    df = cf[key + ['____']].merge(____).merge(____)

    df = df.dropna(____)
    df = df[df['____'] > ____]
    df['____'] = ((____) / df['____']).round(____)
    df['____'] = df['____'].apply(____)

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

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

示例

输入
solve()
期望输出
Stkcd ShortName           净利润     OCF经营活动净额           总资产   应计项目率       评级 | 0      48      京基智农  1.757565e+09 -4.146539e+08  1.212795e+10  0.1791  ⚠ 盈利质量差 | 1     573      粤宏远A  6.151604e+07 -2.984165e+08  2.358736e+09  0.1526  ⚠ 盈利质量差 | 2  600396    *ST 金山  2.053071e+09  4.570005e+07  1.387835e+10  0.1446  ⚠ 盈利质量差 | 3  301308       江波龙 -8.372558e+08 -2.798400e+09  1.367985e+10  0.1434  ⚠ 盈利质量差 | 4  300317      珈伟新能  3.505364e+07 -3.683755e+08  2.932945e+09  0.1376  ⚠ 盈利质量差 | 5  688082      盛美上海  9.105220e+08 -4.269637e+08  9.753798e+09  0.1371  ⚠ 盈利质量差 | 6  688768      容知日新  6.269778e+07 -7.397707e+07  1.065239e+09  0.1283  ⚠ 盈利质量差 | 7  600740      山西焦化  1.268625e+09 -1.899894e+09  2.498581e+10  0.1268  ⚠ 盈利质量差 | 8  688630      芯碁微装  1.793058e+08 -1.294261e+08  2.480473e+09  0.1245  ⚠...
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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