Saving a 2D List/Array to a text file with all formatting preserved

user_16132574 0
Viewed 37

I am trying to save array of lists to a text file and then read them back to a list with all the original formatting preserved. The output list 'content' should be exactly the same as the input list 'times'.

times = [('7:00 AM', 'F'), ('7:10 AM', 'F'), ('7:20 AM', 'F'), ('7:30 AM', 'F'), ('7:40 AM', 'F'), ('7:50 AM', 'F'), ('8:00 AM', 'F'), ('8:10 AM', 'F'), ('8:20 AM', 'F'), ('8:30 AM', 'F'), ('8:40 AM', 'F'), ('8:50 AM', 'F'), ('9:00 AM', 'F')]

#++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
array = np.array(times)
print("array",array)
np.savetxt("C:/Users/micha/source/repos/Times_Array.txt",array,fmt="%s")
content = np.genfromtxt('C:/Users/micha/source/repos/Times_Array.txt',delimiter=",",dtype=None,encoding = 'UTF-8')
print("\ndata.txt content:\n",content)
#+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 array [['7:00 AM' 'F']
 ['7:10 AM' 'F']
 ['7:20 AM' 'F']
 ['7:30 AM' 'F']
 ['7:40 AM' 'F']
 ['7:50 AM' 'F']
 ['8:00 AM' 'F']
 ['8:10 AM' 'F']
 ['8:20 AM' 'F']
 ['8:30 AM' 'F']
 ['8:40 AM' 'F']
 ['8:50 AM' 'F']
 ['9:00 AM' 'F']]

 data.txt content:
 ['7:00 AM F' '7:10 AM F' '7:20 AM F' '7:30 AM F' '7:40 AM F' '7:50 AM F'
 '8:00 AM F' '8:10 AM F' '8:20 AM F' '8:30 AM F' '8:40 AM F' '8:50 AM F'
 '9:00 AM F']

The output format in the list 'content' is not the same as the input list 'times'.. How do I get input to equal output with the same format?

numpy python
1 Answers

The list:

In [68]: times = [('7:00 AM', 'F'), ('7:10 AM', 'F'), ('7:20 AM', 'F'), ('7:30 AM', 'F'
    ...: ), ('7:40 AM', 'F'), ('7:50 AM', 'F'), ('8:00 AM', 'F'), ('8:10 AM', 'F'), ('8
    ...: :20 AM', 'F'), ('8:30 AM', 'F'), ('8:40 AM', 'F'), ('8:50 AM', 'F'), ('9:00 AM
    ...: ', 'F')]
    ...: 
In [69]: times
Out[69]: 
[('7:00 AM', 'F'),
 ('7:10 AM', 'F'),
 ('7:20 AM', 'F'),
 ('7:30 AM', 'F'),
 ('7:40 AM', 'F'),
 ('7:50 AM', 'F'),
 ('8:00 AM', 'F'),
 ('8:10 AM', 'F'),
 ('8:20 AM', 'F'),
 ('8:30 AM', 'F'),
 ('8:40 AM', 'F'),
 ('8:50 AM', 'F'),
 ('9:00 AM', 'F')]

The string dtype array from that list:

In [70]: arr = np.array(times)
In [71]: arr
Out[71]: 
array([['7:00 AM', 'F'],
       ['7:10 AM', 'F'],
       ['7:20 AM', 'F'],
       ['7:30 AM', 'F'],
       ['7:40 AM', 'F'],
       ['7:50 AM', 'F'],
       ['8:00 AM', 'F'],
       ['8:10 AM', 'F'],
       ['8:20 AM', 'F'],
       ['8:30 AM', 'F'],
       ['8:40 AM', 'F'],
       ['8:50 AM', 'F'],
       ['9:00 AM', 'F']], dtype='<U7')

writing the file:

In [72]: np.savetxt('test.txt', arr, fmt='%s', delimiter=',')
In [73]: cat test.txt
7:00 AM,F
7:10 AM,F
7:20 AM,F
7:30 AM,F
7:40 AM,F
7:50 AM,F
8:00 AM,F
8:10 AM,F
8:20 AM,F
8:30 AM,F
8:40 AM,F
8:50 AM,F
9:00 AM,F

Reloading the csv - same delimiter:

In [75]: data = np.genfromtxt('test.txt', delimiter=',', dtype='str')
In [76]: data
Out[76]: 
array([['7:00 AM', 'F'],
       ['7:10 AM', 'F'],
       ['7:20 AM', 'F'],
       ['7:30 AM', 'F'],
       ['7:40 AM', 'F'],
       ['7:50 AM', 'F'],
       ['8:00 AM', 'F'],
       ['8:10 AM', 'F'],
       ['8:20 AM', 'F'],
       ['8:30 AM', 'F'],
       ['8:40 AM', 'F'],
       ['8:50 AM', 'F'],
       ['9:00 AM', 'F']], dtype='<U7')
user_9019250
Related