Why does the `describe` function display floats using scientific notation?

Question

Data in a .csv file looks like this:

But when I am using function describe it shows me numbers in scientific notation?

How can I format them within describe function?

Would pd.set_option('float_format',lambda x: "%.6f" % x) work? github.com/pandas-dev/pandas/issues/6842 — niraj
– niraj, Commented Mar 15, 2018 at 0:56
Thanks. Could you post an answer so I'll accept it? Thank you — Serdia
– Serdia, Commented Mar 15, 2018 at 18:14

niraj · Accepted Answer · 2018-03-15 18:22:36Z

2

You can try following as mentioned in similar issue:

pd.set_option('float_format',lambda x: "%.6f" % x)

From the document:

display.float_format : callable
    The callable should accept a floating point number and return
    a string with the desired format of the number. This is used
    in some places like SeriesFormatter.
    See formats.format.EngFormatter for an example.
    [default: None] [currently: None]

answered Mar 15, 2018 at 18:22

niraj

18.2k4 gold badges36 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why does the `describe` function display floats using scientific notation?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related