[R] row.names - problem with vers. 1.4.1

Liaw, Andy andy_liaw at merck.com
Fri Aug 23 14:57:17 CEST 2002


Your "problem" is not specific to 1.4.1, or even R.  read.table generates a
data frame, and data frame *must* have unique row names in all versions of R
and Splus (well, almost...).

If you don't need the row and column names, preprocess the file first.  If
you know the number of columns in the file, use scan() instead of
read.table.  It'll be much faster and memory efficient.  For example:

## strip out the first column
cmd <- paste("cut -d' ' -f2- ", path, "prices", date, ".txt", sep="")
prices <- matrix(scan(pipe(cmd), skip=1), byrow=TRUE, ncol=????)

HTH,
andy

> -----Original Message-----
> From: Herr.Alfred at gmx.net [mailto:Herr.Alfred at gmx.net]
> Sent: Friday, August 23, 2002 3:07 AM
> To: r-help at stat.math.ethz.ch
> Subject: [R] row.names - problem with vers. 1.4.1
> 
> 
> Hi,
> 
> need a little help:
> 
> I want to handle a file with a first column like this:
> ...
> 27.10.98	
> 28.10.98	
> 29.10.98	
> ...
> 
> In vers. 1.5.1 I can use a statement like:
> 
> # load daily
> prices
> prices<-as.matrix(read.table(paste(path,"prices",date,".txt",s
> ep=""),row.names=1,header=T)) 
> 
> In ves. 1.4.1 R generates an ERROR:
> Error in "row.names<-.data.frame"(*tmp*, value = row.names) : 
>         duplicate row.names are not allowed
> 
> For a reason too complex to explain I HAVE TO use 1.4.1! Can 
> anyone tell me
> how to solve this problem in 1.4.1?
> 
> TIA,
> Alfred.
> 
> -- 
> 
> 
> 
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.
> -.-.-.-.-.-.-.-.-
> r-help mailing list -- Read 
http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._.
_._


------------------------------------------------------------------------------
Notice:  This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (Whitehouse Station, New Jersey, USA) that may be confidential, proprietary copyrighted and/or legally privileged, and is intended solely for the use of the individual or entity named in this message.  If you are not the intended recipient, and have received this message in error, please immediately return this by e-mail and then delete it.

==============================================================================

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list