Hi experts!
Im running a code that generate three differents Numpy arrays (L1, L2 and L3) for every for-cycle (there is N cycles), so I get 3N arrays.
I wanna save these NP arrays in a MS excel file (.xls or other).
My questions are:
1) How can i generate this excel file? 2) How can I read the Excel file generated in a script?
Waiting for your answers.
Thanks a lot!
I'd recommend using CSV files, since they're the simplest and can be opened with Excel.
To save the array (see the documentation for more options, such as the precision of values to be stored):
numpy.savetxt('out.csv', L1, delimiter=',')
(For saving multiple arrays in the same file, it depends on how you want to do it. You can do numpy.vstack for stacking them of top of one another, for example.)
To read back the array:
numpy.loadtxt('out.csv', delimiter=',')
Hi.
Thanks for the help!
Three more questions:
1) If i have a array H=[[1,2,3,4,5],[9,8,7,6,5]],when i save it like csv format, it is sabed like two rows. How can i do for save it like two columns?
2) If i have two arrays: L1=[1,2,3,4,5] and L2=[9,8,7,6,5]. How can i do for save that two arrays like two columns in one only .csv file?
3) How can i insert a title inside the .cvs file (like a comment) and a column name in each column?
Thanks again.
Waiting for yor answers.
For #1, do a transpose on the array using numpy.tranpose.
For #2, I recommend building a new array with L1 and L2 as columns and then saving it.
Asked: 2013-07-09 12:20:37 +0100
Seen: 2,125 times
Last updated: Aug 01 '13
Copyright Sage, 2010. Some rights reserved under creative commons license. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
