← 返回题库
中级

存货估测：生物资产周转率与周期分析

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

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()))
    df = df.sort_values(____).reset_index(____)

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

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

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

示例

输入
solve()
期望输出
year  book_cost  stocking_amount  catch_amount   投入产出比   存货变动率  投放量增长率 | 0  2012       1777             43.7         46.80  1.0709     NaN     NaN | 1  2013       1755            160.4         77.30  0.4819 -0.0124  2.6705 | 2  2014       1411            279.6         62.00  0.2217 -0.1960  0.7431 | 3  2015        917            203.5         77.20  0.3794 -0.3501 -0.2722 | 4  2016        911            149.0         55.20  0.3705 -0.0065 -0.2678 | 5  2017       1093            121.9         75.40  0.6185  0.1998 -0.1819 | 6  2018       1154            166.0         65.36  0.3937  0.0558  0.3618
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册