[R] using sqldf's read.csv.sql to read a file with NA for missing

I'm trying to use sqdf's function read.csv.sql to read CSV files in which the missing values are represented by NA's. Plain old read.csv works fine on these files, but they are rather large and I'd like to filter using sql-like statements. However, even if I specify field.types correctly and

Re: [R] using sqldf's read.csv.sql to read a file with NA for missing

I see the attachment didn't go through. here is the text: 2012-07-01,15:50:00,NA,0,NA,0,NA 2012-07-01,15:51:00,NA,0,NA,0,NA 2012-07-01,15:52:00,NA,0,NA,0,NA 2012-07-01,15:53:00,NA,0,NA,0,NA 2012-07-01,15:54:00,NA,0,NA,0,NA 2012-07-01,15:55:00,NA,0,NA,0,NA 2012-07-01,15:56:00,NA,0,NA,0,NA

Re: [R] using sqldf's read.csv.sql to read a file with NA for missing

On Wed, Sep 5, 2012 at 5:31 PM, David Reiner david.rei...@xrtrading.com wrote: I'm trying to use sqdf's function read.csv.sql to read CSV files in which the missing values are represented by NA's. Plain old read.csv works fine on these files, but they are rather large and I'd like to filter

Re: [R] using sqldf's read.csv.sql to read a file with NA for missing

You will probably have to contact the maintainer of package sqldf (G. Grothendieck ggrothendi...@gmail.com) as it appears that the package does not support missing values. I tried stripping out the NAs so that the fields were empty, but the results are the same. Fields specified as numeric are