Format output of pandas describe() method

pandas_describe_formatted.md

Pandas .describe() formatted

Format numbers output from the pandas df.describe() method. For instance, instead of outputting scientific notation, we can have numbers with thousands separators and a desired number of decimals.

When using .describe with an entire dataframe, use .apply and a lambda function to apply the formatting to every number.

• 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))

When using .describe with a single column or a series, use the .map method instead:

df['Column'].describe().map('{:,.0f}'.format)

For reference, see:

• https://stackoverflow.com/a/47207283
• https://mkaz.blog/code/python-string-format-cookbook/
• https://docs.python.org/3/library/string.html#formatstrings