← 返回题库
中级

存货估测:多年历史数据回归参数估计

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

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

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

    coeffs = np.polyfit(____)
    b, a = round(____), round(____)

    y_hat = np.polyval(____)
    ss_res = np.sum((____) ** ____)
    ss_tot = np.sum((y - y.mean()) ** ____)
    r2 = round(____ - ss_res / ss_tot, ____)

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

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

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

示例

输入
solve()
期望输出
回归方程: Y = 1530.9459 + -1.5111X | R²: 0.0885 |  |    year  book_cost      预测值      残差 | 0  2012       1777  1464.91  312.09 | 1  2013       1755  1288.57  466.43 | 2  2014       1411  1108.44  302.56 | 3  2015        917  1223.44 -306.44 | 4  2016        911  1305.79 -394.79 | 5  2017       1093  1346.74 -253.74 | 6  2018       1154  1280.10 -126.10
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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