[R] RSQLite NA on input
sfalcon at fhcrc.org
Tue Jan 9 16:19:42 CET 2007
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
> 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.
More information about the R-help