[R-SIG-Mac] import data

Simon Urbanek simon.urbanek at r-project.org
Fri Jun 13 17:30:46 CEST 2008


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/
>>> emiliano.guevara at unibo.it
>>> emiguevara at gmail.com
>>>
>>> _______________________________________________
>>> R-SIG-Mac mailing list
>>> R-SIG-Mac at stat.math.ethz.ch
>>> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
>>
>> _______________________________________________
>> R-SIG-Mac mailing list
>> R-SIG-Mac at stat.math.ethz.ch
>> 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/
>
>



More information about the R-SIG-Mac mailing list