根据订单基本信息预测金额 有代码如下：import pandas as pd from sklearn.model_selection impor
已帮助 人
根据订单基本信息预测金额，有代码如下：import pandas as pd from sklearn.model_selection import train_test_split from sklearn.linear_model import LinearRegression import sklearn.metrics as sm frame = pd.read_csv（"C:tempDaily_Demand_Forecasting_Orders.csv", sep=";") y = frame["Target （Total orders)"] X = frame X_train, X_test, y_train, y_test = train_test_split（X, y, test_size=0.2, random_state=7) regressor = LinearRegression（) regressor.fit（X_train, y_train) y_test_p
A．代码有逻辑错误，无法运行
B．代码有逻辑错误，但是可以运行，结果也正确
C．代码有逻辑错误，但是可以运行，结果并不正确
D．代码混淆了训练集合和测试集合，不能拿训练集合来预测训练集合
E．代码没有错误，结果也正确，较高的准确度来自于数据量较少，拟合程度较好
回答
共1条回复-
Select order_no,sum(qty*unit_price) tot_amt
from sale_item
group by order_no
having sum(qty*unit_price)>300
order by sum(qty*unit_price) desc