ermutuxia 赞了您的评论

2020-09-09 19:21

s1223452840 回复您的文章《用python拟合出每个客户的线性方程，主要想看斜率》

2020-09-09 18:32

s1223452840 回复您的文章《用python拟合出每个客户的线性方程，主要想看斜率》

import numpy as np

import matplotlib.pyplot as plt

import pandas as pd

plt.rcParams['font.family'] = ['sans-serif']

plt.rcParams['font.sans-serif'] = ['SimHei']

# 读取数据

data_1 = pd.read_excel("直线.xlsx",index_col = "序号")

data_1

#创建一个拟合直线的函数

def linear_regression(x, y):

N = len(x)

sumx = sum(x)

sumy = sum(y)

sumx2 = sum(x ** 2)

sumxy = sum(x * y)

A = np.mat([[N, sumx], [sumx, sumx2]])

b = np.array([sumy, sumxy])

return np.linalg.solve(A, b)

slope = []

for i in range(288):

slope.append(list(linear_regression(data_1.iloc[i],b))[0])

slope

2020-09-09 18:18

ermutuxia 回复您的文章《用python拟合出每个客户的线性方程，主要想看斜率》

2020-09-09 18:10