[R] MS Excel Data

Gabor Grothendieck ggrothendieck at gmail.com
Fri Nov 30 03:23:53 CET 2007


Or even:

clip <- function() read.delim("clipboard", header =
 is.na(suppressWarnings(as.numeric(scan("clipboard", "", 1)))))

On Nov 29, 2007 7:51 PM,  <apjaworski at mmm.com> wrote:
> Here is a very crude function I use quite often.  It tries to recognize
> whether you have headers or not by checking the very first character.  If
> it is numeric, it assumes that there are no headers. The suppressWarnings
> gets rid of a warning one gets when trying to coerce a character to
> numeric.   The main advantage of the function is that you do not have to
> type too much :-)
>
> clip <- function(){
>    if(is.na(suppressWarnings(as.numeric(scan("clipboard", what="",
> nmax=1)))))
>       read.delim("clipboard")
>    else
>       read.delim("clipboard", header=FALSE)
>
> Cheers,
>
> Andy
>
> __________________________________
> Andy Jaworski
> 518-1-01
> Process Laboratory
> 3M Corporate Research Laboratory
> -----
> E-mail: apjaworski at mmm.com
> Tel:  (651) 733-6092
> Fax:  (651) 736-3122
>
>
>
>             Bert Gunter
>             <gunter.berton at ge
>             ne.com>                                                    To
>             Sent by:                  "'Gabor Grothendieck'"
>             r-help-bounces at r-         <ggrothendieck at gmail.com>
>             project.org                                                cc
>                                       r-help at r-project.org
>                                                                   Subject
>             11/29/2007 06:39          Re: [R] MS Excel Data
>             PM
>
>
>
>
>
>
>
>
>
>
> 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")
>
>
> ______________________________________________
> 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.
>
>
>
>



More information about the R-help mailing list