← 返回题库
中级

存货估测:理论值vs账面值残差分析

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

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

"____""____"偏高/偏低"____"合理"____""____"

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

    BASE_URL = "____"
    df = pd.read_csv(StringIO(open_url(____).read()))

    x = df['____'].values
    y = df['____'].values

    coeffs = np.polyfit(____)
    y_hat = np.polyval(____)

    df['____'] = y_hat.round(____)
    df['____'] = (____).round(____)
    df['____'] = (____).round(____)
    df['____'] = df['____'].apply(
        lambda r: '____' if r > ____ else (____))

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

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

示例

输入
solve()
期望输出
report_year  cumulative_3yr_stocking  book_cost      理论值     残差     残差率  评价 | 0         2016                   216.50        911   913.79  -2.79 -0.0031  合理 | 1         2017                   194.40       1093  1129.73 -36.73 -0.0325  合理 | 2         2018                   195.96       1154  1114.48  39.52  0.0355  合理
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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