Search code examples
pythonpandasdataframecsvexport-to-csv

How to make csv appear as numbers instead of E(python)

The csv created using dataframe.to_csv() contains 1.6135E+14 instead of 161349731180627. In the dataframe, it was confirmed that 161349731180627 is displayed correctly. How do I get 161349734480627 in csv properly? (in python)

Solution

  • While using df.to_csv(), add the argument float_format='{:f}'.format