Menu Close

How to Format or Suppress Scientific Notation from Python Pandas Aggregation Results?

Sometimes, we want to format or suppress scientific notation from Python Pandas aggregation results, we call set_option to change how numbers are formatted.

In this article, we’ll look at how to format or suppress scientific notation from Python Pandas aggregation results, we call set_option to change how numbers are formatted.

How to Format or Suppress Scientific Notation from Python Pandas Aggregation Results?

To format or suppress scientific notation from Python Pandas aggregation results, we call set_option to change how numbers are formatted.

For instance, we write

pd.set_option('display.float_format', lambda x: '%.3f' % x)

to set the 'display.float_format' option by calling set_option with 'display.float_format' and a lambda function to return the number x formatted our way with a format string.

Conclusion

To format or suppress scientific notation from Python Pandas aggregation results, we call set_option to change how numbers are formatted.

Posted in Python, Python Answers