![](https://secure.gravatar.com/avatar/6f3cb304671ae5b6ea04dfe0e7948651.jpg?s=120&d=mm&r=g)
Hello, I encountered another difficulty converting my files from one format to the other. Below you may find a simplified example. When I try to load for instance row 1 on the input file the pylab.load or scipy.io.read_array complains that the index is out of range or that a sequence cannot be converted into a array. I assume that the problem are the cells without any data. The file I use was exported from Excel. There may be some of you who have had to deal with similar format conversion issues. Therefore I would be very happy someone could indicate me a method how to read such structured data efficiently into a array. Thanks in advance. Kind regards, Tim reduced example data: input file structure parameter1 parameter1 parameter2 parameter2 year month day hour1 hour2 hour1 hour2 2007 11 20 8 2 2007 11 21 9 3 4 4 2007 11 22 2 8 4 8 2007 11 23 3 3 6 51 2007 11 24 1 72 34 2007 11 25 7 9 34 24 2007 11 26 6 65 12 1 2007 11 27 7 0 19 2 2007 11 28 44 21 2 output file structure year month day hour parameter1 parameter2 2007 11 20 1 nodata 2 2007 11 20 2 8 nodata 2007 11 21 1 9 4 2007 11 21 2 3 4 2007 11 22 1 2 4 2007 11 22 2 8 8
participants (1)
-
Tim Michelsen