What's the simplest Python way to render a CSV as markdown table?

[aborruso]

Hi,
I need to render a markdown table programmatically, starting from a CSV file.

It's not

```{python}
import pandas as pd

df = pd.read_csv("your_csv_file.csv")
df.to_markdown()
```

I would like to have 1) and not 2).

Thank you

[cscheid]

You need to tell IPython that the output is supposed to be interpreted as Markdown, instead of a string.

Try:

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

[aborruso]

I had solved also using

import pandas as pd
from tabulate import tabulate
import IPython.display as d


df = pd.read_csv("your_csv_file.csv")
md = tabulate(df, headers='keys', tablefmt='pipe',showindex=False)
d.Markdown(md)

[clabornd]

For me, using the knitr engine to write a pdf, this works:

Markdown(df.to_markdown())

this:
display(Markdown(df.to_markdown()))

outputs <IPython.core.display.Markdown object>