python转至某行_python 将一列数据转化成多行数据

import xlrd

import xlwt

import numpy as np

import sys

def write():

data = xlrd.open_workbook(‘data.xls‘)

file = xlwt.Workbook()

for si,sheet in enumerate(data.sheets()):

values = sheet.col_values(0)

if values:

print(values)

table = file.add_sheet(‘sheet‘+str(si+1))

d = ((ri,ci,c) for ri,r in enumerate(np.array(values).reshape(len(values)//7,7)) for ci,c in enumerate(r))

for msg in d:

m = list(msg)

table.write(m[0],m[1],m[2])

file.save(‘newdata.xls‘)

if __name__ == ‘__main__‘:

# write(sys.argv[1])

write()

转换如图：

将

数据 转换成

源码链接：http://pan.baidu.com/s/1i4SaWLn 密码：ywva

原文：http://www.cnblogs.com/fh-fendou/p/7770649.html