Hello, How to use R to read data from Excel file? and How to use R to do histogram? Thanks, Aimin
1. Have you considered exporting to a txt or csv file and then using read.table? 2. Have you considered "hist"? 3. For other questions, I suggest you explore "www.r-project.org" -> search -> "R site search" before emailing this list. hope this helps. spencer graves Aimin Yan wrote:> Hello, > How to use R to read data from Excel file? > and How to use R to do histogram? > > Thanks, > > Aimin > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help
Andrew C. Ward
2003-Aug-15 02:04 UTC
[R] Reading Excel files and making histograms (was: no subject)
Dear Aimin, Your question about Excel comes up rather often on the list and answers can be found in the archives in the "R Data Import/Export" PDF file installed with R. In short, you can read CSV files through read.csv or you can get read directly from Excel spreadsheets through the excellent RODBC package. Documentation suitable for R beginners is installed by default (look for the PDF file "An Introduction to R") and there is much additional material available on the CRAN website. Also, try ?histogram for more detailed information. Regards, Andrew C. Ward CAPE Centre Department of Chemical Engineering The University of Queensland Brisbane Qld 4072 Australia andreww at cheque.uq.edu.au Quoting Aimin Yan <aiminy at iastate.edu>:> Hello, > How to use R to read data from Excel file? > and How to use R to do histogram? > > Thanks, > > Aimin > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help >