[R] RSQLite NA on input

Seth Falcon sfalcon at fhcrc.org
Tue Jan 9 16:19:42 CET 2007

Hi Richard,

It would help if you provided a bit more on how you are going about
the import (along with your version of R and RSQLite).

R Gott <richard.gott at dur.ac.uk> writes:
> I haev some .csv data files with missing values - eg below
> 1,'F','C04','X100',20.93,'C','B',7,8,7.5,2421,2230,2230,2,1,85,43,85,46,48,60
> If I have a missing value - so file looks like ,85,46,,48, etc
> then RSQLite reads it as zero.  ,85,46,0,48, etc
> I need it read it as NA.
> Tried various combinations with no success, adn found nothing on help
> site.  Must be somehting very simple but . . . .
> Help much appreciated.

The most flexible approach would be to use read.table to read in your
csv file.  Then use dbWriteTable to put the resulting data.frame
object into the DB.

+ seth

More information about the R-help mailing list