[R] read.table, NA assignment, and sep

Juliet Hannah juliet.hannah at gmail.com
Thu Jul 3 16:40:28 CEST 2008


I place the following data in a file

id 	 rs835 	 rs169 	 rs174
1001 	 CC 	 GG 	 CC
10032 	 CC 	 GG 	 CC
10066 	 CC 	 NA 	 CC

If I read it in as
tempDat <- read.table("tempDat.txt",na.strings="NA",header=TRUE)

I get the following.

     id rs835 rs169 rs174
1  1001    CC    GG    CC
2 10032    CC    GG    CC
3 10066    CC  <NA>    CC

NA has been assigned a missing value.

If I add the separator

tempDat <- read.table("tempDat.txt",na.strings="NA",sep="\t",header=TRUE)
tempDat
     id rs835 rs169 rs174
1  1001   CC    GG     CC
2 10032   CC    GG     CC
3 10066   CC    NA     CC

NA does not get assigned a missing value.

Could you help me understand the logic of this. Thanks!



More information about the R-help mailing list