I am plotting the data in those csv files and the forst 4 columns in the
files have the same title but the 5th has the name based on the date and
time so it would be unique in each of the files. As I have about 600 files
to batch process, adjusting my script manually is not an option.
The way I have it for one test file is:
r = mlab.csv2rec('test.csv')
#i know that the column name for the 5th column is 'htsgw_12191800'
#so to read the data in the 5th column i just use:
z = r.htsgw_12191800
What i need is to be able to get that data by specifying the column number
as that stays the same in all files.
I'll look at numpy but I hope there is a simpler way.
Thanks,
Anton
Patrick Marsh-2 wrote:
>
> I'm not sure what you are needing it for, but I would suggest looking
> into numpy's loadtxt function. You can use this to load the csv data
> into numpy arrays and pass the resulting arrays arround.
>
> -Patrick
>
>
>
>
>
>
> On Sat, Jan 3, 2009 at 11:21 AM, antonv <vasilescu_an...@yahoo.com> wrote:
>>
>> Hi all,
>>
>> I have a lot of csv files to process, all of them with the same number of
>> columns. The only issue is that each file has a unique column name for
>> the
>> fourth column.
>>
>> All the csv2rec examples I found are using the r.column_name format to
>> access the data in that column which is of no use for me because of the
>> unique names. Is there a way to access that data using the column number?
>> I
>> bet this should be something simple but I cannot figure it out...
>>
>> Thanks in advance,
>> Anton
>> --
>> View this message in context:
>> http://www.nabble.com/csv2rec-column-names-tp21267055p21267055.html
>> Sent from the matplotlib - users mailing list archive at Nabble.com.
>>
>>
>> ------------------------------------------------------------------------------
>> _______________________________________________
>> Matplotlib-users mailing list
>> Matplotlib-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/matplotlib-users
>>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Matplotlib-users mailing list
> Matplotlib-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/matplotlib-users
>
>
--
View this message in context:
http://www.nabble.com/csv2rec-column-names-tp21267055p21267232.html
Sent from the matplotlib - users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
_______________________________________________
Matplotlib-users mailing list
Matplotlib-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/matplotlib-users
