Python读取excel,csv数据到数组
numpy中的普通读取:
1 import numpy as np 2 #skiprows可以跳过前几行数据，np.loadtxt方法直接将数据读取到data数组中 3 data = np.loadtxt(open("路径.csv","rb"),delimiter=",",skiprows=0)
读取Excel:
1 from openpyxl import load_workbook 2 #读取路径 3 book = load_workbook(filename=r"路径.xlsx") 4 #读取名字为Sheet1的表 5 sheet = book.get_sheet_by_name("Sheet1") 6 #用于存储数据的数组 7 data= [] 8 row_num = 1 9 while row_num <= 100 : 10 #将表中第一列的1-100行数据写入data数组中 11 data.append(sheet.cell(row=row_num, column=1).value) 12 row_num = row_num + 1
