This is the most basic question ever...I haven't used R in a couple years since college so I forget and haven't been able to find what I'm looking for in any of the manuals. I just need to figure out how to load a dataset into the program from excel! Thanks! CL [[alternative HTML version deleted]]
# READ DATA FROM XLS FILE #
xls <- read.xls(file = "C:/projects/Rintro/Part01/export.xls",
sheet = 3,
type = "data.frame", from = 1, colNames = TRUE)
On Feb 8, 2008 3:49 PM, Christine Lynn <lynn.chrissy at gmail.com>
wrote:> This is the most basic question ever...I haven't used R in a couple
years
> since college so I forget and haven't been able to find what I'm
looking for
> in any of the manuals.
>
> I just need to figure out how to load a dataset into the program from
excel!
>
> Thanks!
>
> CL
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
--
==============================WenSui Liu
ChoicePoint Precision Marketing
Phone: 678-893-9457
Email : wensui.liu at choicepoint.com
Blog : statcompute.spaces.live.com
It is a good idea to start with RSiteSearch("Excel")
G.
On Fri, Feb 08, 2008 at 03:49:29PM -0500, Christine Lynn
wrote:> This is the most basic question ever...I haven't used R in a couple
years
> since college so I forget and haven't been able to find what I'm
looking for
> in any of the manuals.
>
> I just need to figure out how to load a dataset into the program from
excel!
>
> Thanks!
>
> CL
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
--
Csardi Gabor <csardi at rmki.kfki.hu> UNIL DGM
Have a look at the R Data Import/Export manual on the R website. My simple-minded approach is simply to save the data as a csv file and read it in using read.table or read.csv --- Christine Lynn <lynn.chrissy at gmail.com> wrote:> This is the most basic question ever...I haven't > used R in a couple years > since college so I forget and haven't been able to > find what I'm looking for > in any of the manuals. > > I just need to figure out how to load a dataset into > the program from excel! > > Thanks! > > CL > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, > reproducible code. >