Python Forum
pandas dataframe into csv .... exponent issue
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
pandas dataframe into csv .... exponent issue
#1
Hi Team,

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
Reply


Messages In This Thread
pandas dataframe into csv .... exponent issue - by mg24 - Jan-20-2023, 06:20 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  I'm looking for the syntax of a complex exponent, like: 2 ** (n - m) CHANCEMAN 2 581 Dec-29-2023, 01:53 PM
Last Post: Yoriz
  Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition sanky1990 0 767 Dec-04-2023, 09:48 PM
Last Post: sanky1990
  Question on pandas.dataframe merging two colums shomikc 4 873 Jun-29-2023, 11:30 AM
Last Post: snippsat
  Pandas AttributeError: 'DataFrame' object has no attribute 'concat' Sameer33 5 5,800 Feb-17-2023, 06:01 PM
Last Post: Sameer33
  help how to get size of pandas dataframe into MB\GB mg24 1 2,441 Jan-28-2023, 01:23 PM
Last Post: snippsat
  How to assign a value to pandas dataframe column rows based on a condition klllmmm 0 870 Sep-08-2022, 06:32 AM
Last Post: klllmmm
  How to retrieve records in a DataFrame (Python/Pandas) that contains leading or trail mmunozjr 3 1,787 Sep-05-2022, 11:56 AM
Last Post: Pedroski55
  "Vlookup" in pandas dataframe doug2019 3 1,908 May-09-2022, 01:35 PM
Last Post: snippsat
  Increase the speed of a python loop over a pandas dataframe mcva 0 1,340 Jan-21-2022, 06:24 PM
Last Post: mcva
  for loop in dataframe in pandas Paulman 7 2,789 Dec-02-2021, 12:15 AM
Last Post: bowlofred

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020