← 返回题库
中级

综合案例实战:制造业高杠杆低周转筛查

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

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()))
    op = pd.read_csv(StringIO(open_url(____).read()))

    sol23 = sol[(____) & (____)].copy()
    sol23 = sol23[sol23['____'].str.contains(____)]
    sol23 = sol23[['____', '____', '____']].rename(____)

    op23 = op[(____) & (____)].copy()
    op23 = op23[op23['____'].str.contains(____)]
    op23 = op23[['____', '____', '____']].rename(____)

    df = sol23.merge(____).dropna()
    mask = (____) & (____) & (____)
    df = df[mask].copy()
    df['____'] = '____'

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

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

示例

输入
solve()
期望输出
符合条件公司数量: 0家 |  | 前10家(按资产负债率降序): | Empty DataFrame | Columns: [Stkcd, ShortName, 资产负债率, 总资产周转率, 存货周转率, 风险等级] | Index: []
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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