python中数据的保存

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 as np
# python list that is needed to be save in the 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'

结果:

<type 'list'>
<type 'numpy.ndarray'>
Finish saving csv file

 1 import numpy as np
 2 # 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 print type(data_list)
 5 # convert list to array
 6 data_array = np.array(data_list)
 7 print type(data_array)
 8 # saving...
 9 np.savetxt('data.csv',data_array,delimiter=',')
10 print 'Finish saving csv file'

结果

<type 'list'>
<type 'numpy.ndarray'>
Finish saving csv file


 



posted @ 2016-03-21 00:33  纸鸢spring  阅读(11180)  评论(0编辑  收藏  举报