Quarto not rendering pandas format in word

[lcrmorin]

Bug description

I have this use case where I need to produce word report (Ms Word is still a standard in businesses).

However Quarto doesn't render pandas format properly.

Typically, rendering:

---
title: "Hello, Quarto"
format: docx
---

## Markdown

Markdown is an easy to read and write text format:

## Code Cell

Here is a Python code cell:

```{python}
import os, pandas as pd
os.cpu_count()

pd.DataFrame({'a':[1,2,3],'b':[2,4,5]}).style.background_gradient('Blues')
```

will not work (screen capture of the word document):

However in html it works properly, displaying blue colours for the table.

It is probably my biggest use case for quarto. It would be nice to have a work around.

Regards,

Steps to reproduce

No response

Actual behavior

No response

Expected behavior

No response

Your environment

No response

Quarto check output

Output from the quarto check command:

Quarto 1.6.40
[✓] Checking environment information...
      Quarto cache location: /Users/lucasmorin/Library/Caches/quarto
[✓] Checking versions of quarto binary dependencies...
      Pandoc version 3.4.0: OK
      Dart Sass version 1.70.0: OK
      Deno version 1.46.3: OK
      Typst version 0.11.0: OK
[✓] Checking versions of quarto dependencies......OK
[✓] Checking Quarto installation......OK
      Version: 1.6.40
      Path: /Applications/quarto/bin

[✓] Checking tools....................OK
      TinyTeX: (not installed)
      Chromium: (not installed)

[✓] Checking LaTeX....................OK
      Using: Installation From Path
      Path: /Library/TeX/texbin
      Version: 2024

[✓] Checking basic markdown render....OK

[✓] Checking Python 3 installation....OK
      Version: 3.12.2
      Path: /Users/lucasmorin/.pyenv/versions/3.12.2/bin/python3
      Jupyter: (None)

      Jupyter is not available in this Python installation.
      Install with python3 -m pip install jupyter

[✓] Checking R installation...........(None)

      Unable to locate an installed version of R.
      Install R from https://cloud.r-project.org/

[mcanouil]

Could you properly format your post using code blocks for code and terminal outputs? Thanks.
If your code contains code blocks, you need to enclose it using more backticks, i.e., usually four ````.
See https://quarto.org/bug-reports.html#formatting-make-githubs-markdown-work-for-us.

[lcrmorin]

Could you properly format your post using code blocks for code and terminal outputs? Thanks. If your code contains code blocks, you need to enclose it using more backticks, i.e., usually four ````. See https://quarto.org/bug-reports.html#formatting-make-githubs-markdown-work-for-us.

It is done. Sorry I didn't notice the back quote interferences.

[mcanouil]

The issue is not Pandas

As you can see with keep-md: true, Pandas only outputs HTML (as most tables libraries).
Quarto has an HTML table processing to turn this HTML table back into the Pandoc AST representation but I don't think it can handle styling (or even that Pandoc can write OpenXML with styling).

Here an example using great_tables

Input	Output
--- title: "Hello, Quarto" format: docx --- ```{python} import pandas as pd from great_tables import GT ( GT(pd.DataFrame({'a':[1,2,3],'b':[2,4,5]})) .tab_options(table_background_color="lightblue") ) ```

[mcanouil]

Now, I realise that this is a duplicate of:

• HTML Table parsed by quarto are not styles in docx #10139