[R] A question in R

Yves Magliulo ym at climpact.com
Tue Oct 12 18:14:13 CEST 2004


hi,

check R-data import/export document at this link

cran.r-project.org/doc/manuals/R-data.pdf

let me give you an advice for further questions : it's easiest to find
answer to your question searching directly with google
 
-- 
------
Yves Magliulo <ym at climpact.com>
R&D Engineer, CLIMPACT

Tel.   : +33 (0) 1 44 27 34 31
Fax.   : +33 (0) 1 44 27 49 96 
Universite Pierre et Marie Curie
Boite 101 - Tour 45 - 5eme etage - Couloir 45/46
4 place Jussieu, 75252 Paris CEDEX 05, France
Le mar 12/10/2004 à 17:56, Kevin Bartz a écrit :
> Yayira har wrote:
> > I started to learn the R language, but I didn't suceed to use an external file.
> >  
> > Let say that I have an excel file called "test1.xls" in the directory 
> > "C:/program files/R/rw2000/external_files" that looks like that:
> >  
> > name  mark
> >   yair      80
> >  yosi      70  ...
> >  
> > In the appropriate directory I wrote this:
> >  
> > x<-read.delim("test1.xls")
> >  
> > or this:
> >  
> > x<-read.csv("test1.xls")
> >  
> > but I got:
> >  
> > [1] X......
> > <0 rows> (or 0-length row.names)
> >  
> > way cannot I read the file? what is the appropriate command for reading an excel file?
> > 
> > I looked at the site of R-project but I didn't find a suitable comand.
> > 
> > __________________________________________________
> > 
> > 
> > 
> > 	[[alternative HTML version deleted]]
> > 
> > ______________________________________________
> > R-help at stat.math.ethz.ch mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
> > 
> 
> Hi Yayiya,
> 
> R looks less than fondly on Excel files. The easiest solution for you 
> will be to export your Excel file to a tab-delimited text format (Save 
> -> (.txt) Tab-delimited Text), and then use read.delim as you did. Does 
> that make sense?
> 
> Kevin
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html




More information about the R-help mailing list