Why python returns scientific notation when calculate in the dataframe?

Question

when I do the calculations in the dataframe using Python, it returns the scientific notations results...Is there method making the results without scientific notations (just return the float)? Those highlighted number should be 0.

Thanks for the help.

I need the full float. But those highlighted numbers should be 0. I have no idea why Python returns those format... — Boomshakalaka
– Boomshakalaka, Commented Oct 19, 2018 at 16:03

n1tk · Accepted Answer · 2018-10-19 16:29:34Z

1

Option1: You can use one option: display.precision: pd.set_option('precision', 5)

Options and Settings

Option2: You can use float format:

pd.options.display.float_format = '${:,.5f}'.format

Option3: you can use the round:

DataFrame.round(decimals=0, *args, **kwargs) to can round close to the nearest number:

df.round(5) # for whole dataframe

pandas.DataFrame.round

edited Oct 19, 2018 at 16:29

answered Oct 19, 2018 at 16:09

n1tk

2,5502 gold badges25 silver badges36 bronze badges

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

2 Comments

n1tk Over a year ago

Yes, in all the cases keep the decimal to 5 and you can change the way your requirements. Mostly I use display.float_format and works all the time.

Boomshakalaka Over a year ago

Got it. Thanks!

Collectives™ on Stack Overflow

Why python returns scientific notation when calculate in the dataframe?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related