read.table and missing values
I'd like to share data files (tab delimited text files) that i read in via read.table with other applications. Missing data are empty fields (two tabs following each other) I couldn't find a way yet to 'convince' R to interprete this to be missing values. The read.table option na.strings="" or na.strings='' didn't work. using any special character in the data file for missings (like '#') and defining it for missing using na.strings="#" worked. So I was able to solve the problem doing a global replace. But I'd prefer to read in the data files as is and wonder whether there is a possibility to that in R. Data Import/Export Manual says that empty fields in numeric columns are regarded as missing values. But with my versions of R (Windows 1.2.3, Mac) it didn't work Documention, FAQ and the mailing archive didn't have any further hint. Thanks for any advice Peter
--------------------------------------------------------------------- Peter Breuer, http://www.psych.uni-goettingen.de/home/breuer Georg-Elias-Mueller-Inst. f. Psychologie, Gosslerstr. 14, 37073 Goettingen, Germany Tel: (+49)551-39-3588, Fax: (+49)551-39-3662 -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._