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
#11
You cannot format excel using a CSV file. You can save format information in an excel file (.xlsx). I doubt it is worth the trouble, and it is not applicable to your problem. This is an issue of what you see is not what you get. The data will be -0.000005 regardless of the width of the column. Only the display changes when you make the column too narrow to display all those digits. Make the column even narrower and you might see large numbers displayed as ####. The number is still there, only the display changes.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
Photo Converting Pandas DataFrame to a table of hourly blocks Abedin 1 603 Apr-24-2025, 01:05 PM
Last Post: snippsat
  Most efficient way to roll through a pandas dataframe? sawtooth500 2 1,193 Aug-28-2024, 10:08 AM
Last Post: Alice12
  docx file to pandas dataframe/excel iitip92 1 2,832 Jun-27-2024, 05:28 AM
Last Post: Pedroski55
  I'm looking for the syntax of a complex exponent, like: 2 ** (n - m) CHANCEMAN 2 1,458 Dec-29-2023, 01:53 PM
Last Post: Yoriz
  Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition sanky1990 0 1,415 Dec-04-2023, 09:48 PM
Last Post: sanky1990
  Question on pandas.dataframe merging two colums shomikc 4 2,014 Jun-29-2023, 11:30 AM
Last Post: snippsat
  Pandas AttributeError: 'DataFrame' object has no attribute 'concat' Sameer33 5 10,537 Feb-17-2023, 06:01 PM
Last Post: Sameer33
  help how to get size of pandas dataframe into MB\GB mg24 1 5,514 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 1,960 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 3,691 Sep-05-2022, 11:56 AM
Last Post: Pedroski55

Forum Jump:

User Panel Messages

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