Hello, How do I import data from Excel onto R? I am using S-Plus Envstat module. I need to use some of the data that already exist in the Envstat and put it into R to make graphs, find basic informations like mean, median, standard deviation, etc. I have been reading the help links, but I don't see anything in reference to this. Please help me! -Maher Lina
There is information in the R Data Import/Export manual: http://cran.r-project.org/doc/manuals/R-data.pdf -roger lina1 at umbc.edu wrote:> Hello, > > How do I import data from Excel onto R? I am using S-Plus Envstat module. > I need to use some of the data that already exist in the Envstat and put > it into R to make graphs, find basic informations like mean, median, > standard deviation, etc. I have been reading the help links, but I don't > see anything in reference to this. > > Please help me! > > -Maher Lina > > ______________________________________________ > 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 >
lina1 at umbc.edu wrote:> Hello, > > How do I import data from Excel onto R? I am using S-Plus Envstat module. > I need to use some of the data that already exist in the Envstat and put > it into R to make graphs, find basic informations like mean, median, > standard deviation, etc. I have been reading the help links, but I don't > see anything in reference to this. > > Please help me!See the R Data Import/Export Manual. Uwe Ligges> -Maher Lina > > ______________________________________________ > 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
?read.table -----Original Message----- From: r-help-bounces at stat.math.ethz.ch [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of lina1 at umbc.edu Sent: Tuesday, September 21, 2004 11:41 AM To: R-help at stat.math.ethz.ch Subject: [R] S-PLUS and R Hello, How do I import data from Excel onto R? I am using S-Plus Envstat module. I need to use some of the data that already exist in the Envstat and put it into R to make graphs, find basic informations like mean, median, standard deviation, etc. I have been reading the help links, but I don't see anything in reference to this. Please help me! -Maher Lina ______________________________________________ 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
Save the excel file as a .csv file.
The read about help(read.csv)
Regards
Wayne
-----Original Message-----
From: lina1@umbc.edu [mailto:lina1@umbc.edu]
Sent: 21 September 2004 16:41
To: R-help@stat.math.ethz.ch
Subject: [R] S-PLUS and R
Hello,
How do I import data from Excel onto R? I am using S-Plus Envstat module.
I need to use some of the data that already exist in the Envstat and put
it into R to make graphs, find basic informations like mean, median,
standard deviation, etc. I have been reading the help links, but I don't
see anything in reference to this.
Please help me!
-Maher Lina
______________________________________________
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
KSS Ltd
Seventh Floor St James's Buildings 79 Oxford Street Manchester M1 6SS
England
Company Registration Number 2800886
Tel: +44 (0) 161 228 0040 Fax: +44 (0) 161 236 6305
mailto:kssg@kssg.com http://www.kssg.com
The information in this Internet email is confidential and m...{{dropped}}
Hi,
a shortcut to import data from an Excel sheet is:
In Excel
1) select cells including data
2) press CTRL+C (copy in clipboard)
open a window starting R
In R
type read.delim("clipboard",header=TRUE)
if the are headers in excel data
or read.delim("clipboard",header=FALSE)
if there are not headers
See:
http://www.sciviews.org/_rgui/projects/RDcom.html
to use R in Excel.
Best
Vito
You wrote:
Hello,
How do I import data from Excel onto R? I am using
S-Plus Envstat module.
I need to use some of the data that already exist in
the Envstat and put
it into R to make graphs, find basic informations like
mean, median,
standard deviation, etc. I have been reading the help
links, but I don't
see anything in reference to this.
Please help me!
-Maher Lina
====Diventare costruttori di soluzioni
Visitate il portale http://www.modugno.it/
e in particolare la sezione su Palese
http://www.modugno.it/archivio/cat_palese.shtml
___________________________________
http://it.seriea.fantasysports.yahoo.com/