如何为浮点数设置至少3位数字格式并转换DataFrame数据？

Great question! When you want to display your pandas DataFrame with numbers formatted to at least 3 digits (like your examples: 1070 for integers, 0.073 for floats), you’ve got a couple of solid options depending on whether you just need to show the formatted table or modify the underlying data. Here’s how to tackle both scenarios:

Method 1: Use df.style.format() for targeted display formatting #

This is the best approach if you only want to format how the table looks (without changing the actual data types stored in your DataFrame). Pandas' Styler API is built specifically for creating clean, formatted tables for visualization.

Case 1: Format floats to 3 decimal places, keep integers as full digits

If your values column has a mix of integers and floats, use a custom function to handle each type appropriately:

def format_number(x):
    if isinstance(x, int):
        # Display integers as their full value (automatically >=3 digits if the number is 100+)
        return f"{x:d}"
    elif isinstance(x, float):
        # Format floats to exactly 3 decimal places
        return f"{x:.3f}"

# Apply the formatter to your target column
styled_table = df.style.format({"values": format_number})

# Show the styled table (works in Jupyter/IPython notebooks)
display(styled_table)

Case 2: Ensure small integers show at least 3 digits (e.g., 5 → 005)

If you need integers with fewer than 3 digits to be padded with leading zeros to hit the 3-digit minimum, adjust the integer formatting line:

def format_number(x):
    if isinstance(x, int):
        # Pad integers to 3 digits with leading zeros
        return f"{x:03d}"
    elif isinstance(x, float):
        return f"{x:.3f}"

styled_table = df.style.format({"values": format_number})
display(styled_table)

Method 2: Set global float formatting (for all float columns) #

If you want every float column in your DataFrame to display with 3 decimal places by default, set a pandas display option:

import pandas as pd

# Apply global float formatting
pd.options.display.float_format = "{:.3f}".format

# Now printing the DataFrame will show floats like 0.073 instead of raw decimal values
print(df)

Note: This only changes how the data is displayed, not the actual values stored in the DataFrame.

Method 3: Convert data to formatted strings (if you need stored values to be formatted) #

If you actually need the values column to be stored as formatted strings (rather than just displayed that way), use apply() with your formatting logic:

# For basic formatting (integers as-is, floats to 3 decimals)
df['values'] = df['values'].apply(lambda x: f"{x:.3f}" if isinstance(x, float) else f"{x:d}")

# For padded integers
df['values'] = df['values'].apply(lambda x: f"{x:03d}" if isinstance(x, int) else f"{x:.3f}")

Keep in mind: Converting numbers to strings makes them unsuitable for numerical calculations, so only use this if you specifically need string values.

Example Output #

Suppose your original DataFrame looks like this:

Using Method 1 (Case 1), the displayed table would be:

Using Case 2 of Method 1, it would become:

That should cover your formatting needs! Let me know if you need further tweaks.

内容的提问来源于stack exchange，提问作者Han Zhengzu