Write a program in Python to convert a given dataframe to a LaTex document

Assume, you have a dataframe and the result for converted to latex as,

\begin{tabular}{lrr} \toprule {} &   Id &  Age \ \midrule 0 &    1 &    12 \ 1 &    2 &    13 \ 2 &    3 &    14 \ 3 &    4 &    15 \ 4 &    5 &    16 \ \bottomrule \end{tabular}

Solution

To solve this, we will follow the steps given below −

• Define a dataframe

• Apply to_latex() function to the dataframe and set index and multirow values as True. It is defined below,

df.to_latex(index = True, multirow = True)

Example

Let’s check the following code to get a better understanding −

import pandas as pd df = pd.DataFrame({'Id': [1,2,3,4,5],                      'Age': [12,13,14,15,16]}) print(df.to_latex(index = True, multirow = True))

Output

\begin{tabular}{lrr} \toprule {} &   Id &  Age \ \midrule 0 &    1 &    12 \ 1 &    2 &    13 \ 2 &    3 &    14 \ 3 &    4 &    15 \ 4 &    5 &    16 \ \bottomrule \end{tabular}