← 返回题库
中级

现金流分析：CSMAR数据OCF与净利润背离筛查

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

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

    cf = cf[(____) & (____)]
    inc = inc[(____) & (____)]

    merged = cf[['____', '____', '____', '____', '____']].merge(____)

    merged = merged.dropna(____)
    merged = merged[merged['____'] != ____]
    merged['____'] = (____).round(____)

    abnormal = merged[merged['____'] < ____].sort_values(____).head(____)
    result = abnormal[['____', '____', '____', '____', '____']].reset_index(____)
    return result.to_string()

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

示例

输入
solve()
期望输出
Stkcd ShortName          净利润     OCF经营活动净额      现金含量 | 0     803      山高环能  -2198380.40  7.703460e+08 -350.4153 | 1  603890      春秋电子  -1845713.25  5.250041e+08 -284.4451 | 2    2200     ST 交投  -3763233.22  2.727405e+08  -72.4750 | 3  600827      百联股份 -56716009.77  3.622694e+09  -63.8743 | 4  900923      百联B股 -56716009.77  3.622694e+09  -63.8743 | 5     965      天保基建  28499283.12 -1.244352e+09  -43.6626 | 6  605358       立昂微 -26624405.19  1.026797e+09  -38.5660 | 7  600619      海立股份 -73979182.86  1.072005e+09  -14.4906 | 8  900946      天雁B股   2851978.36 -3.860535e+07  -13.5363 | 9  300673      佩蒂股份 -15968313.19  1.783898e+08  -11.1715
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册