#!/usr/nim/env python
# _*_ coding:utf-8 _*_
import xlrd
from numpy import *
file1 = 'D:\pycharm\workspace\data visualization\偏好.xlsx'
wb = xlrd.open_workbook(filename=file1)
ws = wb.sheet_by_name('Sheet1')
dataSet = []
for r in range(ws.nrows):
col = []
for c in range(ws.ncols):
col.ap_pend(ws.cell(r,c).value)
dataSet.ap_pend(col)
print(dataSet)
转自:https://blog.csdn.net/fangafangxiaoniu/article/details/80707548?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-4.nonecase&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-4.nonecase