昨天看的书,太困了,没写
继续kNN算法,numpy函数库的几个方法
1. random.rand(4,3)随机生成一个4*3的矩阵
2. mat(random.rand(4,3))生成的是一个矩阵
3. a=mat(random.rand(4,3)), a.I 为矩阵A的逆矩阵
4. 直接生成一个矩阵 A = matrix([ [1,2,3],[4,3,5],[5,7,3] ])
5.python读文件操作 fr = open() line = fr.readlines()
6.line.strip()去掉头部尾部的'\t' '\n' '\r' ' ' lstrip 和 rstrip分别是前头和后头
7.line.spliit
#这是一个读写文件的算法,正好手里有个问卷调查的数据,因为是网络问卷,数据比较杂乱无章,想到是否可以用python提取有用数据放到excel表格里
</pre><pre name="code" class="python"><span style="font-family: 'Courier New'; background-color: rgb(255, 255, 255);">zeros是numpy的函数,创建一个矩阵 </span>
# -*- coding: utf-8 -*-
import xlrd
import xlwt
def read_write():
data = xlrd.open_workbook('data.xls')
table = data.sheets()[0]
nrows = table.nrows
ncols = table.ncols
charm = [['help' for col in range(ncols-12)] for row in range(nrows)]
lineList = []
for i in range(nrows):
lineList = table.row_values(i)
charm[i] = lineList[13:48]
workbook = xlwt.Workbook()
s2 = workbook.add_sheet('s1')
i = j = 0
print '------- nice--- reading is OK -- '
for row in charm:
j=0
for col in row:
if j == 3:
if col == 1.0:
col = u'男'
else:
col = u'女'
s2.write(i,j, col)
j += 1
i += 1
workbook.save('ff23.xls')
read_write()