Round scientific value of a dataframe

Question

I would like to gain space while saving my datas, I don't mind the loss of information. The data have many different of order of magnitude, So I cannot round using the normal rounding function. I can't seem to find a post that help me to round my dataset using scientific numbers

12345678 => round with 3 decimals => 1.234E7

Any help is appreciated :)

Does this answer your question: https://stackoverflow.com/questions/21137150/format-suppress-scientific-notation-from-python-pandas-aggregation-results — Anwarvic, May 26 '20 at 15:15
@Anwarvic I would like to "save" the dataframe with this setup, not only display it, so it doesn't really answer my question — th0mash, May 27 '20 at 08:33

Stef · Accepted Answer · 2020-05-27T16:33:03.487

1

You can use to_csv with a float_format='%.3E' to ouput your (floating point) data rounded to 3 places in scientific notation to a csv file. See the format specification for other formatting options.

Minimal example:

pd.DataFrame([12345678]).astype(float).to_csv(float_format='%.3E')
#',0\r\n0,1.235E+07\r\n'

There's no easy way to have E7 instead of E+07, see also this SO question.

edited May 27 '20 at 16:33

answered May 27 '20 at 16:19

Stef

28,728
2
24
52

It's perfect! Thank you! – th0mash May 27 '20 at 17:37

Round scientific value of a dataframe

1 Answers1