mark at myatt.demon.co.uk
Mon Nov 19 16:02:31 CET 2001
>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.
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