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:<jdnew...@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. haugb...@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@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. ______________________________________________ R-help@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.
