Jtdylktuy

I’m using RMarkdown with the reticulate package and often have the requirement to print pandas DataFrame objects using R packages such as Kable. Unfortunately, the conversion appears to work intermittently when Knitting the document. Again, sometimes it works, sometimes it doesn’t.

Here's a reproducible example of RMarkdown:

output: html_document



```{r setup, include=FALSE}

knitr::opts_chunk$set(echo = TRUE)

```



```{python}

import pandas as pd

df = pd.DataFrame({'a':4, 'b':5, 'c':9}, index=[0])

print(df)

```



```{r}

library(reticulate)

df2 <- reticulate::py$df

print(df2)

print(reticulate::py$df)

```

Actual Behavior:

import pandas as pd

df = pd.DataFrame({'a':4, 'b':5, 'c':9}, index=[0])

print(df)

##    a  b  c

## 0  4  5  9

library(reticulate)

df2 <- reticulate::py$df

print(df2)

##                                   a                                 b

## 1 <environment: 0x000000001d8d9fa0> <environment: 0x000000001d9cd630>

##                                   c

## 1 <environment: 0x000000001dac0d30>

print(reticulate::py$df)

##                                   a                                 b

## 1 <environment: 0x000000001dde8a58> <environment: 0x000000001dedac08>

##                                   c

## 1 <environment: 0x000000001e0119e0>

Expected Behavior:
The Pandas DataFrame object should be converted to an R DataFrame object and printed as follows:

##    a  b  c

## 0  4  5  9

Would appreciate any guidance on this issue as the actual behavior I cited above doesn't occur all the time.

Here's the session information:

## R version 3.5.2 (2018-12-20)

## Platform: x86_64-w64-mingw32/x64 (64-bit)

## Running under: Windows 10 x64 (build 17134)

## 

## Matrix products: default

## 

## locale:

## [1] LC_COLLATE=English_United States.1252 

## [2] LC_CTYPE=English_United States.1252   

## [3] LC_MONETARY=English_United States.1252

## [4] LC_NUMERIC=C                          

## [5] LC_TIME=English_United States.1252    

## 

## attached base packages:

## [1] stats     graphics  grDevices utils     datasets  methods   base     

## 

## other attached packages:

## [1] reticulate_1.10.0.9004

## 

## loaded via a namespace (and not attached):

##  [1] Rcpp_1.0.0      lattice_0.20-38 digest_0.6.16   rprojroot_1.3-2

##  [5] grid_3.5.2      jsonlite_1.6    backports_1.1.2 magrittr_1.5   

##  [9] evaluate_0.11   stringi_1.1.7   Matrix_1.2-15   rmarkdown_1.10 

## [13] tools_3.5.2     stringr_1.3.1   yaml_2.2.0      compiler_3.5.2 

## [17] htmltools_0.3.6 knitr_1.20