search for: pbpaste

Hi! Is it possible to easily cut & paste data from an Excel spreadsheet to an R edit( ) grid or to variable? It seems that R cannot handle the cell delimiters Excel hands over. Regards, Werner

...at doesn't work on Windows, so I don't have > > any useful observations for that OS. > > > > You might say this is a weird example or use case. The actual usage > where I > > discovered this is the way folks read/write the clipboard on macOS using > > pbcopy/pbpaste (and, in very similar ways, on linux using xsel or xclip). > > This is mentioned in the "Clipboard" section of the connections help > topic. > > > > In 4.3.2 on macOS, I can successfully roundtrip with the clipboard: > > > >> pb_write <- pipe("p...

...same results on linux. This particular example with cat doesn't work on Windows, so I don't have any useful observations for that OS. You might say this is a weird example or use case. The actual usage where I discovered this is the way folks read/write the clipboard on macOS using pbcopy/pbpaste (and, in very similar ways, on linux using xsel or xclip). This is mentioned in the "Clipboard" section of the connections help topic. In 4.3.2 on macOS, I can successfully roundtrip with the clipboard: > pb_write <- pipe("pbcopy") > writeChar("hello clipboard!&q...

Hi, I have a student trying to run R on an Apple (OS 10.3.9). She tried to cut-and-paste the data via the code: data<-read.table(pipe("pbpaste")) But she keeps getting the error message: 'error in pipe("pbpaste"): pipe connections are not available on this system' I do not know much about using an Apple. Has anyone run into this before? Does anyone have any ideas for how to fix the problem? Thanks! Alex -- **...

...ogy.mcmaster.ca/bennett/psy710/lectures/maxwell_chp12.pdf I am trying to convert my own similar course to R for my students for next fall. I have been successful at analyzing a segment of the data as a 2-way repeated measures design. Here is my code: > your.data=read.table(pipe("pbpaste"),header=T) > your.data partic A1B1 A1B2 A1B3 A1B4 A2B1 A2B2 A2B3 A2B4 A3B1 A3B2 A3B3 A3B4 1 p1 1 1 2 3 1 2 4 7 1 3 7 10 2 p2 2 2 3 3 2 2 5 6 2 4 6 9 3 p3 1 2 2 3 2 3 2 6 1 4...

...other gives a solution that echoes the clipboard, but that's exactly the same as just ctrl-p. As I am asked this question at least once a week in my very small home institution, I'm sure many people want to know. If you could post somewhere that for most Macs you can read.table(pipe("pbpaste")) will work for almost all applications, that would be very helpful. Thank you, Christian Anderson [[alternative HTML version deleted]]

Hi I'm a mac user. I have problems loading data from mac excel in R. I'm using these script: >library(utils) >data2 <- read.table(file("clipboard"), header =T, sep ="\t") ____but this is the message that I have from R_____ Error in open.connection(file, "r") : cannot open the connection In addition: Warning message: In open.connection(file,

...ntaining a second csv-coded table. My problem is to parse that second-order csv-table. As the read.csv command requires a link to a file, I couldn't get it to read the data from a variable. I also tried to copy the content of the variable into the clipboard to use the read.csv(pipe("pbpaste"))- function, but didn't come to a solution ... Any suggestions? Thanks! Felix

My friend sent an Excel file: http://msemac.redwoods.edu/~darnold/temp/cyu01_iqscores.xls http://msemac.redwoods.edu/~darnold/temp/cyu01_iqscores.xls I opened it in Excel, saved is as cyu01_iqscores.csv, then imported it into R with: iqscores=read.csv('cyu01_iqscores.csv',header=TRUE) The result was: > head(iqscores) IQ.Scores X 1 145 NA 2 101 NA 3 123 NA 4

...GUI (R Commander/RKward) > Message-ID: <9CA34005-9076-439F-AEC2-1931E1472103 at gmail.com> > Content-Type: text/plain; charset=windows-1252 > > something like this will get you going, assuming your data are in a dataframe called ?qual? > > # qual <- read.table(pipe("pbpaste"), header=T, sep='\t') > boxplot(formula=Time~Distance+Season, data=qual) > > > Followup question from me: > > i can?t see why > boxplot(formula=Time, data=qual) > > should return the error "can?t find Time? ??Time~" and ?~Time" don?t help >...

Dear R users, I am trying to get data from the clipboard into R on MacOSX. I tried the following, but got an error message: read.delim("clipboard") Error in file(file, "r") : unable to open connection In addition: Warning message: unable to contact X11 display Obviously, I'm not running R using X11. I'm wondering, can I import data from the clipboard on MacosX?

First, I compliment you all for such a useful project as R. Suggestion: If read.table() could take input from a character string, then one could write raw= " x y z 1 2 3 4 5 6 " df = read.table(raw,head=TRUE) Of course, one can cat() to write raw into a temporary file, and read.table() from that file. However, direct reading might be a good option? Hope this is

Hi I have data in the following format Cort Day Animal 23 0 1 27 3 1 24 0 2 27 1 2 34 2 2 30 3 2 24 4 2 20 0 3 24 1 3 28 2 3 34 4 3 etc. It is measured across time(day) however no every individual is measured the same number of times. All I want to do is plot the Raw data and then run a line connecting the

Hi Test made in: R in windows Vista OS, R version 2.8.1 From FAQ: http://cran.r-project.org/doc/FAQ/R-FAQ.html#How-do-I-convert-factors-to-numeric_003f "It may happen that when reading numeric data into R (usually, when reading in a file), they come in as factors. If |f| is such a factor object, you can use as.numeric(as.character(f)) to get the numbers back." 1: Why it may happen?

Dear all, I have a txt file of the following format that describes the relationships between a network of a certain number of nodes. {4, 2, 3} {3, 4, 1} {4, 2, 1} {2, 1, 3} {2, 3} {} {2, 5, 1} {3, 5, 4} {3, 4} {2, 5, 3} For example the first line {4, 2, 3} implies that there is a connection between Node 1 and Node 4, a connection between Node 1 and Node 2 and a connection between Node 1 and

Hi everyone: I need to count the number of banks of each firm in my data. The firm is identified by the fiscal number. The banks of each firm appears like this: Firm Banks 500600700 Citybank 500600700 CGD 500600700 BES 500600800 Citybank 500600800 Bank1 500600900 CGD I want to obtain the following dataframe: Firm

Dear all, I have a file which I've converted from NetCDF (.nc) to text (.txt) using ncdump in Unix (as I had problems using the ncdf package to do this). The first few rows (as copied and pasted from the Unix console) of the file appear as follows: _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _, _,

I have been trying to import a csv file to r. but I get the same message everytime. the message is Error in file(file, "rt") : cannot open the connection In addition: Warning message: In file(file, "rt") : cannot open file 'Users:/sezginozcan/Downloads/beer.data.csv': No such file or directory I use mac. I tried this command also

Hi, I am a consultant in Quality Management. I am exploring the use of R with any GUI - R commander/Rkward for doing analytical work. Have installed R, R Commander and Rkward. I hope to learn by doing various exercises that I use for teaching analytical techniques to my clients. I would be posting the data on this mailing list, and the rkward mailing list wherever I get stuck. First such

Hi all, Does anybody know the easiest way to import excel data into R? I copied and pasted the excel data into a txt file, and tried read.table, but R reported that Error in read.table("data_support.txt", sep = " ", header = T) : more columns than column names Thanks! Ling