Python: How to print whole numbers as integers in Pandas LaTeX conversion

Posted On February 5, 2023

When converting a Pandas DataFrame to LaTeX using the to_latex method, by default, all numbers in the DataFrame are printed with a fixed number of decimal places. If you want to print whole numbers as integers, you can modify the format of the cells before converting to LaTeX.

Here’s an example of how you can print whole numbers as integers in a Pandas DataFrame:

import pandas as pd

# Create a sample DataFrame
df = pd.DataFrame({
    "A": [1, 2, 3, 4],
    "B": [5.0, 6.0, 7.0, 8.0]
})

# Convert columns containing whole numbers to integers
df[df.columns[df.dtypes == int]] = df[df.columns[df.dtypes == int]].astype(int)

# Print the DataFrame as LaTeX
print(df.to_latex(index=False))

In this example, we first create a sample DataFrame with two columns A and B. We then use the dtypes property of the DataFrame to identify the columns containing whole numbers and convert them to integers using the astype method. Finally, we print the DataFrame as LaTeX using the to_latex method, with the index parameter set to False to exclude the row index from the output.

This will print the DataFrame as a LaTeX table with whole numbers in the A column formatted as integers.