[R] RES: How to read an excel data into R?

From: Paulo Brando <pmbrando_at_ipam.org.br>
Date: Thu 23 Jun 2005 - 22:50:58 EST


Hi ling, save your file as 'csv'.

I always use the following script:

NAME <- read.table("C:LOCATION/FILE NAME.csv", header = TRUE, sep = ",", na.string=".")



Paulo M. Brando
Instituto de Pesquisa Ambiental da Amazonia (IPAM) Santarem, PA, Brasil.
Av. Rui Barbosa, 136.
Fone: + 55 93 522 55 38
www.ipam.org.br
E-mail: pmbrando@ipam.org.br

-----Mensagem original-----
De: r-help-bounces@stat.math.ethz.ch
[mailto:r-help-bounces@stat.math.ethz.ch] Em nome de Ling Jin Enviada em: Wednesday, June 22, 2005 4:47 PM Para: r-help@stat.math.ethz.ch
Assunto: [R] How to read an excel data into R?

Hi all,

Does anybody know the easiest way to import excel data into R? I copied and pasted the excel data into a txt file, and tried read.table, but R reported that

Error in read.table("data_support.txt", sep = " ", header = T) :

         more columns than column names

Thanks!

Ling



R-help@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

R-help@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 Received on Thu Jun 23 22:54:11 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:32:58 EST