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

2012-09-05 Thread David L Carlson
> To: r-help@r-project.org > Subject: 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 >

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

2012-09-05 Thread Gabor Grothendieck
On Wed, Sep 5, 2012 at 5:31 PM, David Reiner 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 using sql-like statemen

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

2012-09-05 Thread David Reiner
elp@r-project.org Subject: [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 r

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

2012-09-05 Thread David Reiner
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 nrow