[R] MS Excel Data
Bert Gunter
gunter.berton at gene.com
Fri Nov 30 01:37:49 CET 2007
Better yet! Thanks Gabor.
-- Bert
-----Original Message-----
From: Gabor Grothendieck [mailto:ggrothendieck at gmail.com]
Sent: Thursday, November 29, 2007 12:10 PM
To: Bert Gunter
Cc: r-help at r-project.org
Subject: Re: [R] MS Excel Data
On Nov 29, 2007 3:01 PM, Bert Gunter <gunter.berton at gene.com> wrote:
> This has been discussed on this list many times before. Google on "Import
> Excel R". Note also that there are potential problems (loss of digits) due
> to Excel "idiosyncracies" depending on what you do.
> http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html provides
> some details.
>
> Finally, I have found that for rectangular data sets with no missing
fields
> in Excel (tables), cutting and read.tabling **the data only ** is a
> simple(but probably not without risk) way to do it:
>
> (after cutting the data only in Excel to the clipboard) in R:
>
> newdat <- read.table("clipboard", head=FALSE, row.names=NULL)
>
> The columns can then be named via names(newdat) <- ...
>
> I omit column headers because in most of the Excel data I get the column
> names have spaces and other non-alphanumeric characters which R cannot
> easily digest. One could separately scan() just the vector of column
headers
> and use regular expressions to extract the names. But for small tables, I
> find it easier just to create the names manually.
You can include headers with spaces in the copy with:
DF <- read.delim("clipboard")
More information about the R-help
mailing list