[R] Questions

[Jeff Newmiller]

This is not the RStudio support forum. I use it, I like it, but you need to learn the difference between R and RStudio.

In this case, the fact that you are using RStudio is probably irrelevant. What is more relevant is that you are not on windows, though I can't be sure what OS you actually are using. Your error message refers to UNIX, you refer to Excel, so you could be on MacOSX or on windows with a pipe into a UNIX server. (If the latter, the RStudio support team may have a FAQ on this problem.) Please read the Posting Guide mentioned at the end of every message on this list.
I Googled this problem and found https://stat.ethz.ch/pipermail/r-help/2006-October/116363.html, which probably applies, but only you can tell for sure.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

haugb002 at umn.edu wrote:

>Hello,
>
>I am having difficulty putting a frequency table on my clipboard in R 
>studio. I do not know what the error message is. I was thinking it
>might 
>have to do with changing a setting on my clipboard but I do not know
>how to 
>do this. I will copy and paste the exact command and error message:
>
>write.table(dpx,"clipboard",sep="\t")
>Error in file(file, ifelse(append, "a", "w")) : 
>  'mode' for the clipboard must be 'r' on Unix
>
>I was able to create a frequency table as a "value" in my workspace. 
>However, I am trying to put it on my clipboard and then export it into 
>excel. I copied and pasted some of the commands below that I was
>getting 
>error messages for which may be helpful.
>
>Once I am able to get the frequency table to show up on my workbook I
>was 
>also wondering how to export it to excel and keep the same formatting 
>(spaces between the different frequency tables)?
>
>Thank you!
>
>Lana
>
>
>> getwd()
>[1] "/Users/JoshandLana"
>> dpx <- read.table(file.choose(), header = T, sep = "\t")
>> #edit(dpx)
>> View(dpx)
>> freqTable <- table(dpx$ActorID,dpx$EmotionFaceTask.RESP,dpx$Emotion)
>> write.table(dpx,"clipboard",sep="\t",col.names=NA)
>Error in file(file, ifelse(append, "a", "w")) : 
>  'mode' for the clipboard must be 'r' on Unix
>> write.table(dpx,"clipboard",sep="\t")
>Error in file(file, ifelse(append, "a", "w")) : 
>  'mode' for the clipboard must be 'r' on Unix
>> edit(dpx)
>Error in dataentry(datalist, modes) : 
>Editing of matrix and data.frame objects is not currently supported in 
>RStudio
>
>______________________________________________
>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.