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
#5
If I take you example code and write the csv to a console rather than to file...

Net_Income = [0.00000, -0.000005, -1.859603, -55.788084]

df = pd.Series(Net_Income)

print(df)
print()
x = df.to_csv(float_format="%.6f")
print(x)
... I see this:

Output:
df 0 0.000000 1 -0.000005 2 -1.859603 3 -55.788084 dtype: float64 csv ,0 0,0.000000 1,-0.000005 2,-1.859603 3,-55.788084
There should be no difference when writing to a file.
Sig:
>>> import this

The UNIX philosophy: "Do one thing, and do it well."

"The danger of computers becoming like humans is not as great as the danger of humans becoming like computers." :~ Konrad Zuse

"Everything should be made as simple as possible, but not simpler." :~ Albert Einstein
Reply


Messages In This Thread
RE: pandas dataframe into csv .... exponent issue - by rob101 - Jan-20-2023, 07:22 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 615 Dec-29-2023, 01:53 PM
Last Post: Yoriz
  Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition sanky1990 0 786 Dec-04-2023, 09:48 PM
Last Post: sanky1990
  Question on pandas.dataframe merging two colums shomikc 4 899 Jun-29-2023, 11:30 AM
Last Post: snippsat
  Pandas AttributeError: 'DataFrame' object has no attribute 'concat' Sameer33 5 5,923 Feb-17-2023, 06:01 PM
Last Post: Sameer33
  help how to get size of pandas dataframe into MB\GB mg24 1 2,501 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 882 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,825 Sep-05-2022, 11:56 AM
Last Post: Pedroski55
  "Vlookup" in pandas dataframe doug2019 3 1,974 May-09-2022, 01:35 PM
Last Post: snippsat
  Increase the speed of a python loop over a pandas dataframe mcva 0 1,354 Jan-21-2022, 06:24 PM
Last Post: mcva
  for loop in dataframe in pandas Paulman 7 2,822 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