1.1基于python csv庫：

#3.讀取csv至字典x,y
import csv
# 讀取csv至字典
csvFile = open(r'G:\訓(xùn)練小樣本.csv', "r")
reader = csv.reader(csvFile)
#print(reader)
# 建立空字典
result = {}
i=0
for item in reader:
 if reader.line_num==1:
 continue
 result[i]=item
 i=i+1
# 建立空字典 
j=0
xx={}
yy={}
for i in list(range(29)):
 xx[j]=result[i][1:-1]
 yy[j]=result[i][-1]
 # print(x[j])
 # print(y[j])
 j=j+1
csvFile.close()
##3.1字典轉(zhuǎn)換成list
X=[]
Y=[]
for i in xx.values():
 X.append(i)
for j in xx.values():
 X.append(j) 

改進(jìn)的CSV讀取，直接從CSV文件讀取到 list：

#加載數(shù)據(jù) 
def loadCSV(filename): 
 dataSet=[] 
 with open(filename,'r') as file: 
 csvReader=csv.reader(file) 
 for line in csvReader: 
 dataSet.append(line) 
 return dataSet

讀取的方式，是一行一行讀取。

1.2 pandas讀取：

import pandas as pd
test_df = pd.read_excel(r'G:\test_linearRegression.xlsx')