I agree that the difference between Mac and others WRT clipboard is a
bit annoying. I'll see if I can fix that.
Thanks,
Simon
On Jun 13, 2008, at 11:16 AM, William Revelle wrote:
I agree with Simon that copy paste is the easiest way to go.
However, because I was unable to remember the
read.table(pipe("pbpaste")) command and wanted to give instructions
to students that were platform independent, I created a little
function (read.clipboard) that works on PCs or Macs . It is
available in the psych package:
"read.clipboard" <-
function(header=TRUE,...) {
MAC<-Sys.info()[1]=="Darwin" #are we on a Mac using the Darwin
system?
if (!MAC ) {if (header) read.clipboard<-
read.table(file("clipboard"),header=TRUE,...)
else read.clipboard<-read.table(file("clipboard"),...) }
else {
if (header) read.clipboard<-
read.table(pipe("pbpaste"),header=TRUE,...)
else read.clipboard<- read.table(pipe("pbpaste"),...)}
}
With the addition of a sep="," option, it can also read csv copied
files:
"read.clipboard.csv" <-
function(header=TRUE,sep=',',...) { #same as read.clipboard(sep=',')
MAC<-Sys.info()[1]=="Darwin" #are we on a Mac using the Darwin
system?
if (!MAC ) {if (header) read.clipboard<-
read.table(file("clipboard"),header=TRUE,sep,...)
else read.clipboard<-
read.table(file("clipboard"),sep,...) }
else {
if (header) read.clipboard<-
read.table(pipe("pbpaste"),header=TRUE,sep,...)
else read.clipboard<- read.table(pipe("pbpaste") ,sep,...)}
}
Bill
At 10:53 AM -0400 6/13/08, Simon Urbanek wrote:
On Jun 13, 2008, at 4:43 AM, Emiliano Guevara wrote:
Hi,
There's many ways to do it. I would suggest using comma separated
values as a "bridge" filetype.
I find copy/paste more convenient for most simple tables - simply
select the table in Numbers, press <Cmd><C> (Copy) and then read
the clipboard in R:
read.table(pipe("pbpaste"))
Cheers,
Simon
From Numbers, save your data as a .csv file (comma separated value).
Then, in R, import the data from the file using:
read.csv(file.csv)
That should be it,
Best wishes,
E.
On Jun 13, 2008, at 05:34 AM, Peng Jiang wrote:
Hi ,
I have some data in Numbers, which is a data managing software
for Mac OS. How can I import them to R ?
Or how can I import my data from R to Numbers ? Any interfaces
between R and Numbers or something ?
I am a newbie so if the question is toooooo simple, please take
it easy.
Thanks!
--------------------------
Peng Jiang
ç]‰Ù
Ph.D. Candidate
Antai College of Economics & Management
à¿ë×悺ˆä«óùäwâ@
Department of Mathematics
êîäwån
Shanghai Jiaotong University (Minhang Campus)
800 Dongchuan Road
200240 Shanghai
P. R. China
****************************************
Emiliano R. Guevara
Facoltà di Lingue e Lett. Straniere
Dipart. di Lingue e Lett. Straniere
Università di Bologna
Via Cartoleria 5 (40124) Bologna, Italia
http://morbo.lingue.unibo.it/
[EMAIL PROTECTED]
[EMAIL PROTECTED]
_______________________________________________
R-SIG-Mac mailing list
[email protected]
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
_______________________________________________
R-SIG-Mac mailing list
[email protected]
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
--
William Revelle http://personality-project.org/revelle.html
Professor http://personality-project.org/personality.html
Department of Psychology http://www.wcas.northwestern.edu/psych/
Northwestern University http://www.northwestern.edu/
Attend ISSID/ARP:2009 http://issid.org/issid.2009/
_______________________________________________
R-SIG-Mac mailing list
[email protected]
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
