Hello R-help I am trying to copy and paste large column of data from windows Excel into R base speed sheet using: Data1<-edit(data.frame()) But I can only copy and paste one cell at a time which is time consuming. Also how can assign each column to a variable. [[alternative HTML version deleted]]
On Fri, May 13, 2011 at 7:02 AM, Asan Ramzan <asanramzan at yahoo.com> wrote:> Hello R-help > > I am trying to copy and paste large column of data from windows Excel into R > base speed sheet using: > > > Data1<-edit(data.frame()) > > But I can only copy and paste one cell at a time which is time consuming. > > Also how can assign each column to a variable.See this page: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows&s=excel -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com
-------------------------------------------------- From: "Asan Ramzan" <asanramzan at yahoo.com> Sent: Friday, May 13, 2011 6:02 AM To: <r-help at r-project.org> Subject: [R] Excel to R> Hello R-help > > I am trying to copy and paste large column of data from windows Excel into > R > base speed sheet using: > > > Data1<-edit(data.frame())At least on Windows (not sure about other OS's, you can paste data as follows: Data1 <- read.table(file = 'clipboard', header = TRUE) # assuming you have column labels> > But I can only copy and paste one cell at a time which is time consuming. > > Also how can assign each column to a variable. > [[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.At least on Windows (not sure about other OS's ------------------------------------------ Robert W. Baer, Ph.D. Professor of Physiology Kirksville College of Osteopathic Medicine A. T. Still University of Health Sciences 800 W. Jefferson St. Kirksville, MO 63501 660-626-2322 FAX 660-626-2965
An embedded message was scrubbed... From: "Filipe Leme Botelho" <filipe.botelho at vpar.com.br> Subject: RES: [R] Excel to R Date: Fri, 13 May 2011 14:18:13 -0300 Size: 3257 URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20110513/dabe8881/attachment.mht> -------------- next part -------------- "This message and its attachments may contain confidential and/or privileged information. If you are not the addressee, please, advise the sender immediately by replying to the e-mail and delete this message." "Este mensaje y sus anexos pueden contener informaci?n confidencial o privilegiada. Si ha recibido este e-mail por error por favor b?rrelo y env?e un mensaje al remitente." "Esta mensagem e seus anexos podem conter informa??o confidencial ou privilegiada. Caso n?o seja o destinat?rio, solicitamos a imediata notifica??o ao remetente e exclus?o da mensagem."