[R] read.table and missing values

About this list Date view Thread view Subject view Author view

From: Peter Breuer (pbreuer@uni-goettingen.de)
Date: Wed 20 Jun 2001 - 00:08:20 EST 

Message-Id: <a05010402b754f3fe9d60@[134.76.136.128]>

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@stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

About this list Date view Thread view Subject view Author view

This archive was generated by hypermail 2b30 : Fri 22 Jun 2001 - 18:58:45 EST