python中数据的保存

小咪咪 2021-07-16 14:25 439阅读 0赞

**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

![736761-20160321002932193-453116729.jpg][]

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

![736761-20160321003045678-1782010905.jpg][]

[savetxt]: http://docs.scipy.org/doc/numpy-1.10.0/reference/generated/numpy.savetxt.html#numpy.savetxt
[736761-20160321002932193-453116729.jpg]: /images/20210716/ac5d9fe730934d82bc4846cc051bb2c3.png
[736761-20160321003045678-1782010905.jpg]: /images/20210716/c41757118b1a421c8c03c64a3512ac4f.png