从excel表中读取数据
#!/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.append(ws.cell(r,c).value)
dataSet.append(col)
print(dataSet)