[R] read.table and missing values

Peter Breuer pbreuer at uni-goettingen.de
Tue Jun 19 16:08:20 CEST 2001


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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list