← 返回题库
中级

综合案例实战:低风险高成长公司筛选

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

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

"____""____"低风险高成长"____""____"

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

    BASE_URL = "____"
    sol = pd.read_csv(StringIO(open_url(____).read()))
    grw = pd.read_csv(StringIO(open_url(____).read()))
    inc = pd.read_csv(StringIO(open_url(____).read()))

    sol23 = sol[(____) & (____)][
        ['____', '____', '____', '____']].rename(____)
    grw23 = grw[(____) & (____)][
        ['____', '____']].rename(____)
    inc23 = inc[(____) & (____)][
        ['____', '____', '____']]

    df = sol23.merge(____).merge(____).dropna()
    df = df[df['____'] > ____]
    df['____'] = (____).round(____)

    mask = ((____) & (____) &
            (____) & (____))
    qualified = df[mask].copy()

    header = f"____"
    result = qualified.nlargest(____, '____')[
        ['____', '____', '____', '____', '____', '____']
    ].reset_index(____)
    return header + result.to_string()

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

示例

输入
solve()
期望输出
符合条件公司总数: 2家 |  | 前10家(按营收增长率降序): |     Stkcd ShortName     资产负债率      流动比率     营收增长率   净利润率 | 0     514       渝开发  0.404178  2.100919  1.042441  0.071 | 1  200019       深粮B  0.176037  1.749723  1.009317  0.056
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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