You're right! I read more about recarrays and they were built specially for
being called by the column name, so I shouldn't have used csv2rec from the
start!
Thanks for the quick responses!
Anton
Patrick Marsh-2 wrote:
>
> In my limited opinion, numpy's loadtxt is the way to go. Loadtxt
> doesn't care about the headerYou can read in the arrays like this:
>
> # read in all 5 columns as text
> col1, col2, col3, col4, col5 = np.loadtxt(filename, dtype=dtype,
> unpack=True)
>
> or if you want to skip the column headings and read in just a specific
> data type of just the last column
>
> # read in only column 5, as a specific dtype, and exclude the column 5
> heading
> col5_no_header = np.loadtxt(filename, skiprows=1, usecols=(5),
> dtype=dtype, unpack=True)
>
>
> -Patrick
>
>
>
>
>
>
> On Sat, Jan 3, 2009 at 11:39 AM, antonv <vasilescu_an...@yahoo.com> wrote:
>>
>> 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
>>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> 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-tp21267055p21267490.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
