Jan-20-2023, 06:20 PM
Hi Team,
I am trying to write pandas Dataframe into csv,
wrong values getting printed into csv. exponent issue.
-5.00E-06
0
0
-5.00E-06 <------ how to fix this issue
-1.859603
-55.788084
I am trying to write pandas Dataframe into csv,
wrong values getting printed into csv. exponent issue.
-5.00E-06
import pandas as pd Net_Income = [0.00000,-0.000005,-1.859603,-55.788084] df = pd.Series(Net_Income) df.to_csv(r'E:\data\output.csv',mode='w',sep='|',index=False)output
0
0
-5.00E-06 <------ how to fix this issue
-1.859603
-55.788084