Skip to content

Instantly share code, notes, and snippets.

@data-enhanced

data-enhanced/pandas_describe_formatted.md

Last active November 21, 2025 08:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save data-enhanced/0c48586f36e8cd27ffad8fe076d62c4e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save data-enhanced/0c48586f36e8cd27ffad8fe076d62c4e to your computer and use it in GitHub Desktop.
Download ZIP
Format output of pandas describe() method
Raw
pandas_describe_formatted.py
# Describe() formatted
# Format numbers without scientific notation and with thousands separators
# Uses a lambda function to apply the formatting to every number
# See https://stackoverflow.com/a/47207283
# See also https://mkaz.blog/code/python-string-format-cookbook/
# To change the number of decimals, change the number before the f
# To remove the thousands separator remove the comma
df.describe().apply(lambda s: s.apply('{:,.0f}'.format))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment