read.table(text=my_str,....) saves you the dangling open connection.
-pd
> On 8 Oct 2018, at 02:43 , Tom Hopper <tomhop...@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@r-project.org> wrote:
>
>>
>>> On Oct 3, 2018, at 9:22 AM, Robert Baer <rb...@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@r-project.org
>> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
>>
>
> [[alternative HTML version deleted]]
>
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac@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....@cbs.dk Priv: pda...@gmail.com
_______________________________________________
R-SIG-Mac mailing list
R-SIG-Mac@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
