[Numpy-discussion] Numpy savetxt: change decimal separator

[Junda Zhu]

On Sep 24, 2009, at 3:07 AM, markus.proeller at ifm.com wrote:

> Hello everyone,
>
> I save data to a file with the following statement:
>
> np.savetxt(fileName, transpose((average_dist, std_deviation,  
> maximum_dist, sum_of_dist)), delimiter = ';', fmt='%6.10f')
>
> is there a possibility to change the decimal seperator from a point  
> to comma ?
> And another question I import this file to excel, is there also a  
> possiblity to create a headline for each column, that the file looks  
> like the following example:
>
> average; standard deviation; maximum distance; sum of distances
> 0,26565; 0,65565; 2,353535; 25, 5656


For the first task, I don't know if there is any direct way in numpy  
to change the decimal sep, but a little bit awkward trick as follows  
should work:


mem_file = StringIO.StringIO()
np.savetxt(mem_file, ... )
new_data_str = mem_file.getvalue().replace('.', ',')

output_file = open(fileName, 'w')
output_file.write(new_data_str)
output_file.close()

Or you can use regex to get better match for the decimal seperator.

Thanks,
Junda
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/numpy-discussion/attachments/20090924/ba01e33e/attachment.html>