How to Format Pandas DataFrames with Floats: A Guide to Using Format Strings

Using Format Strings to Display Pandas DataFrames with Floats

Displaying Pandas DataFrames with precision and formatting can be a common task. While print() and IPython display() provide a convenient way to view data, it can pose challenges when presenting floats in a specific format.

To address this issue, pandas offers an elegant solution using format strings. This approach allows you to customize the way floats are displayed without modifying the underlying data.

Solution Using Float Formatting Option

If all floats in the DataFrame require the same format, you can modify the Pandas display options:

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

This will print the DataFrame with all floats formatted as currency values with two decimal places.

Pre-Modifying DataFrame for Specific Float Formatting

However, if only certain floats need to be formatted differently, pre-modifying the DataFrame is necessary. This involves converting those floats to strings in the desired format:

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)

This method will display the DataFrame with the 'foo' column as a float and the 'cost' column formatted as currency values with two decimal places.

The above is the detailed content of How to Format Pandas DataFrames with Floats: A Guide to Using Format Strings. For more information, please follow other related articles on the PHP Chinese website!