Excel用Python矩阵求解

import pandas as pd
import numpy as np
k1 = [] #储存所有f1
k2 = []
k3 = []
datas1 = pd.read_excel(r'C:\Users\26360\Desktop\A.xlsx') # 读取 excel 数据，引号里面是 excel 文件的位置
datas2 = pd.read_excel(r'C:\Users\26360\Desktop\B.xlsx')
for i in range(1,n):
    x1 = datas1.iloc[:, i] # A组数据第i+1列，i从1到n-1
    x2 = datas2.iloc[:, 0] # B组数据第一列
    A = np.array([x1]) # 转化为数组
    B = np.transpose(np.array([x2]))
    f1 = A.dot(B)
    k1.append(f1)

for i in range(1,n):
    x1 = datas1.iloc[:, i] 
    x2 = datas2.iloc[:, 1] 
    A = np.array([x1]) 
    B = np.transpose(np.array([x2]))
    f2 = A.dot(B)
    k2.append(f2)
    
for i in range(1,n):
    x1 = datas1.iloc[:, i] 
    x2 = datas2.iloc[:, 2]
    A = np.array([x1])
    B = np.transpose(np.array([x2]))
    f3 = A.dot(B)
    k3.append(f3)
print(k1)# 输出k1
print(k2)
print(k3)