[R] Stacking several vectors from the list

Arsenio Starodoumov arseni.starodoumov at uci.edu
Wed Jun 30 01:11:40 CEST 2010


Monday, June 28, 2010, 4:40:11 PM, you wrote:

> On Mon, Jun 28, 2010 at 7:30 PM,  <astarodo at uci.edu> wrote:
>> Hi everybody,
>>
>> I'm working on the very
>> messy data, I have tried to clean it up in SAS and
>> SAS/IML but there is not enough info on how to handle certain things
>> in SAS so I have turned to R. The thing itself should be rather
>> simple, so i was wondering if someone could help me out.
>>
>> The original .csv has ([1] 7138 6338 ) dimensions with funds with the corresponding dates and observations for each date for around 10 years and 4000+ funds, meaning in COL5 has the next fund's name and so on.
>>
>> COL1                  COL2               COL3           COL4
>> HBNNF US Equity Date            EQY_SH_OUT      PX_VOLUME
>>                        #NAME?         #N/A N/A   135000
>>                        7/7/2008        #N/A N/A          105000
>>                        7/17/2008       #N/A N/A          590000
>>                        7/22/2008       #N/A N/A          40000
>>
>>
>> so in R this .csv is somehow read as list (using typeof) and not as dataframe, and a lot of stuff like regexpr searches in the

> The typeof of a data.frame is "list" so you do have a data frame --
> not a list.  Perhaps the problem is that you do not want factor
> columns but want character columns instead.  Use read.csv(..., as.is =
> TRUE)

Thanks!! This " as.is" trick solved the list issue and the whole
indexing problem. Now the table is a true dataframe searchable and
indexable. I'm still reading on those differences between in "list"
and "dataframe" types.

Arsenio



More information about the R-help mailing list