Python multivariate regression to call Excel file

Importxlrd fromNumpy.linalgImportINVImportNumPy as Npdata= Xlrd.open_workbook (U'c:\\users\\xd/desktop\\ job \ \ new folder \ \ Linear Algebra \\SpeedVideoDataforModeling.xlsx') Table=data.sheet_by_index (0) x1= Np.array (Table.col_values (17) [1:]) X2= Np.array (Table.col_values (18) [1:]) X3= Np.array (Table.col_values (19) [1:]) Y1= Np.array (Table.col_values (20) [1:]) Y2= Np.array (Table.col_values (21) [1:]) X0= Np.array ([1 forIinchX1]) X=Np.vstack ((x0,x1,x2,x3)). T########### #最小二乘法多元线性回归 #######################COEF1 =Np.dot (Np.dot (Inv (Np.dot (x.t,x)), x.t), y1. T) Coef2=Np.dot (Np.dot (Inv (Np.dot (x.t,x)), x.t), Y2. T) fromSklearn.linear_modelImportLinearregressionmodel=linearregression () model.fit (X, y1)Printmodel.coef_model.fit (X, y2)Printmodel.coef_############# #小的实例 ========================x = [[1,1,1], [1,1,2], [1,2,1]]y= [[6], [9], [8]]model=linearregression () model.fit (x, y)

Python multivariate regression to call Excel file