[R] Doubt

Mark Myatt mark at myatt.demon.co.uk
Mon Nov 19 16:02:31 CET 2001


You write:

>i am folloing the thread.... thankx for the info thus far. most of the people 
>who pop into my office for a "quick question" end up leaving their excel data 
>sheets with me which i then import  into R(usually via S+, but i am on the 
>only member in the dept with a windows copy of s+!).
>my question is how to deal with missing data. can you leave the cells blank 
>in excel and use the import as you have suggested below or do you have to do 
>a find replace or something equivalent...? i.e. does R import 8,,8 as 8 mdata 

Yes, it works fine. Prof Ripley writes:

        It's easier to use read.csv, on the same help page, or consult
        the Data Import/Export Manual.

And he is right ... it has the appropriate defaults for the sep, dec
and header parameters set so you don't have to bother with that.


Mark Myatt

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