RE: [R] How to override coerion error in 'scan'

From: Kittler, Richard <richard.kittler_at_amd.com>
Date: Tue 26 Apr 2005 - 03:41:08 EST


Uwe,

Thanks. I did find something in the archives about using a custom colClass of 'num' with read.csv and using setAs to define a character -> num function. From the read.table code this appears to force 'scan' to read it as character and then convert it later using 'as'. I'm not sure if there is any advantage in this approach to just reading it using a colClass of 'character' and then converting it myself afterward (?)

--Rich

Richard Kittler
AMD TDG
408-749-4099

-----Original Message-----
From: Uwe Ligges [mailto:ligges@statistik.uni-dortmund.de] Sent: Saturday, April 23, 2005 6:50 AM
To: Kittler, Richard
Cc: r-help@stat.math.ethz.ch
Subject: Re: [R] How to override coerion error in 'scan'

Kittler, Richard wrote:

> I am using 'read.csv' in V2.0.1 to read in a CSV file with the
> colClasses option and am getting an error from 'scan' when it
> encounters a non-numeric value for a 'numeric' column, i.e.
>
> > ds <- read.csv(in_file, nrows=irow, row.names=NULL,
> colClasses=zclass,
> comment.char="")
> Error in scan(file = file, what = what, sep = sep, quote = quote,
> dec = dec, :
> "scan" expected a real, got "03/15/200523:56:03"
>
> Is there a way to override this and just have it convert those values
> to NA? The dataset is large so I would prefer not to have to import
> the columns as character and convert them to numeric afterward.

I think you have to read it in as character - or write your own C-level facility...

Uwe Ligges

>
> --Rich
>
> Richard Kittler
> AMD TDG
> 408-749-4099
>
> ______________________________________________
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Tue Apr 26 03:48:08 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:31:25 EST