On Jan 9, 2025, at 10:13 PM, Pedro Andres Aranda Gutierrez <paaguti@gmail.com> wrote:
> 
> Hi,
> 
> For org tables generated in Python, I use python-tabulate. Actually, I forked the original library to include the possibility of generating the latex attributes from Python too.
> 
> Something like:
> 
> --- cut here ---
> #+BEGIN_SRC python :results value raw :exports results
> import math
> import pandas as pd
> import tabulate
> 
> xvals = [math.pi * i / 5 for i in range(10)]
> df = pd.DataFrame({
>     'x': xvals,
>     'sin(x)' : [math.sin(xvals[i]) for i in range (10)],
>     'cos(x)' : [math.cos(xvals[i]) for i in range (10)]
> })
> 
> attrs=':environment longtable :align p{2cm}p{2cm}p{2cm} :placement [h] :center t'
> return tabulate.tabulate(
>     df,
>     headers=df.columns, tablefmt='orgtbl', floatfmt=".3f",
>     caption='Table exported from Python with extended tabulate',
>     label='labextend',
>     attr_latex=attrs,
>     showindex=False)
> #+END_SRC
> #+RESULTS:
> --- cut here ---
> 
> Take a look at https://github.com/paaguti/python-tabulate if it sounds interesting. 
> 
> CAVEAT: the author of python-tabulate wasn't very excited about this ;-)
> 
> Best, /PA

Thanks for the suggestion! I was creating the output in a rather similar way, using the pandas to_markdown() function, which calls tabulate to do the work. Using the orgtbl output option, it only prints one horizontal line under the header, so I created a simple wrapper function to add additional horizontal lines at top and bottom (and optionally between the last and penultimate lines, for when there’s a “Total” row):

-----

def add_hlines(table, total_row=False):
    """Add horizontal lines to markdown table."""
    table_markdown = table.to_markdown(index=False, tablefmt="orgtbl", floatfmt=",.2f")
    table_lines = table_markdown.split("\n")
    hline = table_lines[1]
    table_lines.insert(0, hline)
    if total_row:
        table_lines.insert(-1, hline)
    table_lines.append(hline)
    return "\n".join(table_lines)

-----