Re: [R] Loading Data to R
On Microsoft Windows systems, it may be more convenient to install and use the "XLSReadWRite" packge. For non-windows systems, the gdata package provides this function, but requires perl to be present. -Greg (Maintainer of gdata) On Feb 9, 2008, at 1:09PM , Henrique Dallazuanna wrote: > You need library(gdata) before > > On 08/02/2008, Wensui Liu <[EMAIL PROTECTED]> wrote: >> # 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 <[EMAIL PROTECTED]> >> 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@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 : [EMAIL PROTECTED] >> Blog : statcompute.spaces.live.com >> >> __ >> R-help@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. >> > > > -- > Henrique Dallazuanna > Curitiba-Paraná-Brasil > 25° 25' 40" S 49° 16' 22" O > > __ > R-help@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. __ R-help@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.
Re: [R] Loading Data to R
You need library(gdata) before On 08/02/2008, Wensui Liu <[EMAIL PROTECTED]> wrote: > # 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 <[EMAIL PROTECTED]> 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@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 : [EMAIL PROTECTED] > Blog : statcompute.spaces.live.com > > __ > R-help@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. > -- Henrique Dallazuanna Curitiba-Paraná-Brasil 25° 25' 40" S 49° 16' 22" O __ R-help@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.
Re: [R] Loading Data to R
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 <[EMAIL PROTECTED]> 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@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. > __ R-help@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.
Re: [R] Loading Data to R
# 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 <[EMAIL PROTECTED]> 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@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 : [EMAIL PROTECTED] Blog : statcompute.spaces.live.com __ R-help@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.
Re: [R] Loading Data to R
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@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 <[EMAIL PROTECTED]>UNIL DGM __ R-help@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.