• python多元回归于调用excel文件


    import xlrd
    from numpy.linalg import inv
    import numpy as np
    
    data = xlrd.open_workbook(u'C:\Users\xd/Desktop\作业\新建文件夹\线性代数\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 for i in x1])
    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)
    from sklearn.linear_model import LinearRegression
    model = LinearRegression()
    model.fit(X, y1)
    print model.coef_
    model.fit(X, y2)
    print model.coef_
    ##############小的实例========================
    x = [[1,1,1], [1,1,2], [1,2,1]]
    y = [[6], [9], [8]]
    
    model = LinearRegression()
    model.fit(x, y)
  • 相关阅读:
    语法树,短语,直接短语,句柄
    理解文法和语法
    了解编译原理
    实习日记7.20
    实习日记7.19
    实习日记7.18
    实习日记7.15
    实习日记7.13-7.14
    实习日记7.12
    实习日记7.11
  • 原文地址:https://www.cnblogs.com/Kermit-Li/p/6792645.html
Copyright © 2020-2023  润新知