format number columns pandas code example

Example 1: formatting columns a dataframe python

import pandas as pd
df = pd.DataFrame([123.4567, 234.5678, 345.6789, 456.7890],
                  index=['foo','bar','baz','quux'],
                  columns=['cost'])
df['foo'] = df['cost']
df['cost'] = df['cost'].map('${:,.2f}'.format)
print(df)

Example 2: pandas dataframe print decimal places

pd.set_option('precision', 4)
print(df.to_latex(index=False))