[R-SIG-Mac] pasting from the clipboard

[peter dalgaard]

read.table(text=my_str,....) saves you the dangling open connection.

-pd

> On 8 Oct 2018, at 02:43 , Tom Hopper <tomhopper using gmail.com> wrote:
> 
> Another approach that should work cross-platform is to paste the data into
> a string, then read the string using read.table():
> 
> my_str <- "<paste data here>"
> my_df <- read.table(textConnection(object = my_str),
>                            header = TRUE,
>                            sep = "",
>                            stringsAsFactors = FALSE)
> 
> The pasted data should have line breaks so each row is on its own line in
> your script, and you'll want to adjust the parameters header and sep to
> suit your data.
> 
> An example of suitable data would be:
> 
> my_str <- "T_/K Density_g/mL D2O
> 273 0.999841 1.10469
> 274 0.999900 NA
> 275 0.999941 NA"
> 
> Regards,
> 
> Tom
> 
> On Wed, Oct 3, 2018 at 10:10 AM Marc Schwartz via R-SIG-Mac <
> r-sig-mac using r-project.org> wrote:
> 
>> 
>>> On Oct 3, 2018, at 9:22 AM, Robert Baer <rbaer using atsu.edu> wrote:
>>> 
>>> My memory is that  on the Mac
>>> 
>>> dat = read.table(file = pipe("pbpaste"), header = TRUE)      # should
>> allow me to paste a dataframe copied from a spreadsheet into R.
>>> 
>>> When I try that in RStudio 1.1.456 with R 3.5.1 on OSX 10.13.1
>>> 
>>> I get the message:
>>> 
>>>  incomplete line found by readTableHeader on 'pbpaste'
>>> 
>>> Could anyone explain this message to me,  and more importantly, tell me
>> the proper way to paste a dataframe copied to the clipboard from Excel on
>> the Mac?
>>> 
>>> 
>> 
>> 
>> Hi,
>> 
>> The default cell (field) delimiter with Excel is the TAB character, so you
>> want to use something like:
>> 
>>  read.table(pipe("pbpaste"), sep = "\t", header = TRUE)
>> 
>> Note that you will likely get a warning along the lines of what you got
>> above, which I believe is due to Excel not having an EOL for the final row
>> in the clipboard.
>> 
>> Regards,
>> 
>> Marc Schwartz
>> 
>> 
>> 
>> 
>>        [[alternative HTML version deleted]]
>> 
>> _______________________________________________
>> R-SIG-Mac mailing list
>> R-SIG-Mac using r-project.org
>> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
>> 
> 
> 	[[alternative HTML version deleted]]
> 
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac

-- 
Peter Dalgaard, Professor,
Center for Statistics, Copenhagen Business School
Solbjerg Plads 3, 2000 Frederiksberg, Denmark
Phone: (+45)38153501
Office: A 4.23
Email: pd.mes using cbs.dk  Priv: PDalgd using gmail.com