Generating Tables with Julia

[gdietl]

With quarto, it is possible to generate tables with R or Python. Is there also a way to generate tables with Julia? I've tried using PrettyTables.jl and producing an output in markdown format. However, the output is not correctly interpreted by Quarto, even note wenn setting "output: asis".

[gdietl]

I found a solution. It does not work with PrettyTables.jl but with Tables.jl and MarkdownTables.jl. It follows a code example:

```{julia}
#| label: tbl-example
#| tbl-cap: Example
#| echo: false
using Markdown,Tables,MarkdownTables
data = ["A" 60; "B" 40; "C" 50];
# Some calculations (not important for this example)
result = [data; "Total" sum(data[1:end,2])];
markdown_table(Tables.table(result))

[gdietl]

Note that this solution only works when quarto is using Jupyter. If there are R-chunks in the document and quarto executes Julia via R, the table is not generated.

[cderv]

I think this is because JuliaCall R package does not handle the default output of markdown_table which is a Mime type outputing DisplayAs.Raw.Showable object.

JuliaCall is the package called by knitr when Julia chunk are used, and knitr handles the output based on the method defined by this tool.

You can make the above works with knitr by outputing a Markdown table as string and using output: asis

---
title: "Tables"
format: html
keep-md: true
engine: knitr
---

```{julia}
#| label: tbl-example
#| tbl-cap: Example
#| output: asis
using Markdown,Tables,MarkdownTables
data = ["A" 60; "B" 40; "C" 50];
# Some calculations (not important for this example)
result = [data; "Total" sum(data[1:end,2])];
print(markdown_table(Tables.table(result), String))
```

Jupyter or IJulia probably handles the DisplayAs.Raw.Showable type directly and we get a Jupyter output that can be handled by Quarto

Hope it helps understand.

[gdietl]

Unfortunately, your code is not giving me the right output. As is, it still uses Jupyter and procudes the following output:

If I define knitr as the engine by using the following code

---
title: "Tables"
format: html
keep-md: true
engine: knitr
---

```{julia}
#| label: tbl-example
#| tbl-cap: Example
#| output: asis
using Markdown,Tables,MarkdownTables
data = ["A" 60; "B" 40; "C" 50];
# Some calculations (not important for this example)
result = [data; "Total" sum(data[1:end,2])];
markdown_table(Tables.table(result), String)
```

it is using JuliaCall vom knitr and I'll get the output:

The markdown string is correct in this case but it is still not interpreted correctly. Do I miss something?

Besides, when producing a pdf document via xelatex, I'll get the error

compilation failed- missing packages (automatic installed disabled)
Undefined control sequence.
<argument> ...1 \textbar {} Column2 \textbar {}\n 
                                                  \textbar ---------\textbar...
l.214 \textbar{} 150 \textbar{}\n''}

[cderv]

Sorry I missed a line in the YAML header while copy pasting and cleaning my example. You need to add engine: knitr as you have tried in YAML if the julia chunk is the only one and no other R chunk is inside the qmd document. Otherwise Jupyter will be used.

And I mixed up my copy paste - with the String format, an explicit print() will be needed for the \n to be printed correctly.

I edited the example above. Sorry for that.

[gdietl]

Now, it is working. Thanks for your helpful solution! I've marked the above comment from you as the answer.

[gdietl]

Thanks for your solution. I did not know that you can directly import CSV files into quarto. This might be the perfect solution in cases where Julia is executed via R.

[gdietl]

I've tried using your code but, unfortunately, it is not working. The table-chunk is not recognized. I'm running quarto version 1.2.280. Do I have to install a new version?

[cderv]

@DelmerBratzOd2 curious how this table chunk is working ? Is this from a specific extension ?

Thanks