Pandas Printing

library(reticulate)
use_virtualenv("r-reticulate", required = TRUE)
py_install(c("pandas", "IPython", "tabulate"))

## Using virtual environment "C:/Users/chris/Documents/.virtualenvs/r-reticulate" ...

## + "C:/Users/chris/Documents/.virtualenvs/r-reticulate/Scripts/python.exe" -m pip install --upgrade --no-user "pandas" "IPython" "tabulate"

Default render

df

##        size  weight
## cat     1.0     3.0
## dog     1.5     5.0
## koala   1.0     2.5

Try HTML

Some quote are still there preventing correct printing

df.to_html()

## '<table border="1" class="dataframe">\n  <thead>\n    <tr style="text-align: right;">\n      <th></th>\n      <th>size</th>\n      <th>weight</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>cat</th>\n      <td>1.0</td>\n      <td>3.0</td>\n    </tr>\n    <tr>\n      <th>dog</th>\n      <td>1.5</td>\n      <td>5.0</td>\n    </tr>\n    <tr>\n      <th>koala</th>\n      <td>1.0</td>\n      <td>2.5</td>\n    </tr>\n  </tbody>\n</table>'

df.to_html()

’

	size	weight
cat	1.0	3.0
dog	1.5	5.0
koala	1.0	2.5

’

So it requires some special processing

df_html = df.to_html()

cat(py$df_html)

	size	weight
cat	1.0	3.0
dog	1.5	5.0
koala	1.0	2.5

Using IPython Display helps

from IPython.display import HTML
HTML(df.to_html())

	size	weight
cat	1.0	3.0
dog	1.5	5.0
koala	1.0	2.5

Improve stylings using Bootstrap class

df_html = df.to_html(classes = ["table", "table_condensed"])

cat(py$df_html)

	size	weight
cat	1.0	3.0
dog	1.5	5.0
koala	1.0	2.5

HTML(df.to_html(classes = ["table", "table_condensed"]))

	size	weight
cat	1.0	3.0
dog	1.5	5.0
koala	1.0	2.5

Try Markdown

Still quoting, so it requires some special printing

df.to_markdown()

## '|       |   size |   weight |\n|:------|-------:|---------:|\n| cat   |    1   |      3   |\n| dog   |    1.5 |      5   |\n| koala |    1   |      2.5 |'

df.to_markdown()

‘| | size | weight ||:——|——-:|———:|| cat | 1 | 3 || dog | 1.5 | 5 || koala | 1 | 2.5 |’

df_markdown = df.to_markdown()

cat(py$df_markdown)

	size	weight
cat	1	3
dog	1.5	5
koala	1	2.5

Using IPython Display helps

from IPython.display import Markdown
Markdown(df.to_markdown())

	size	weight
cat	1	3
dog	1.5	5
koala	1	2.5