[R] Doubt

Peter Dalgaard BSA p.dalgaard at biostat.ku.dk
Mon Nov 19 13:00:50 CET 2001


Mark Myatt <mark at myatt.demon.co.uk> writes:

> aolinto at bignet.com.br writes:
> >> As to call files of another softwares(as, Excel, minitab)  
> >>  to be manipulated inside of R-plus?
> >> Respectfully
> >> Regiane
> >
> >Dear Regiane
> >
> >The easiest way I found to transfer data from Excel to 
> >data.frames in R was to use copy and paste function.
> 
> I find that comma separated files come in OK and Excel writes these from
> File -> Save and File -> Save As...
> 
> Remember to use sep = "," and header = TRUE as in:
> 
>         my.df <- read.table(myfile.csv, sep = ",", header = TRUE)

or read.csv()

Notice that in several non-English locales CSV files come out with
sep=";",dec="," - which is what read.csv2() is for.

-- 
   O__  ---- Peter Dalgaard             Blegdamsvej 3  
  c/ /'_ --- Dept. of Biostatistics     2200 Cph. N   
 (*) \(*) -- University of Copenhagen   Denmark      Ph: (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)             FAX: (+45) 35327907
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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