1.将list中的数据写入到excel文件中
利用python包numpy(实现方式应该有许多种,这里只是记录成功实现的一种)中的savetxt
局限性:要保存的list可以为[1,2,3,4,5]这种形式,也可以是[[1,2,3,4,5],[6,7,8,9,10],[11,12,13,14,15]]这种形式,但如果是第二种情况(list中每个元素都为list)时,list中的每个list所含有元素个数要相同,这是因为该方法需要先将python的list数据转化为array类型
import numpy asnp
# python list thatis needed to be save inthe csv file
data_list= [1,2,3,4,5,6,7,8]
print type(data_list)
# convert list to array
data_array=np.array(data_list)
print type(data_array)
# saving...
np.savetxt('data.csv',data_array,delimiter=',')
print'Finish saving csv file'
结果:
Finish saving csv file
1 importnumpy as np2 #python list that is needed to be save in the csv file
3 data_list = [[1,2,3,4,5,6,7,8],[9,10,11,12,14,1,2,3],[4,3,2,1,3,6,7,8]]4 printtype(data_list)5 #convert list to array
6 data_array =np.array(data_list)7 printtype(data_array)8 #saving...
9 np.savetxt('data.csv',data_array,delimiter=',')10 print 'Finish saving csv file'
结果
Finish saving csv file