float64 with pandas to_csv

by

As mentioned in the comments, it is a general floating point problem.

However you can use the float_format key word of to_csv to hide it:

df.to_csv('pandasfile.csv', float_format="%.3f")

or, if you don’t want 0.0001 to be rounded to zero:

df.to_csv('pandasfile.csv', float_format="%g")

will give you:

Bob,0.085
Alice,0.005

in your output file.

For an explanation of %g, see Format Specification Mini-Language.

More Related Contents:

  1. Replacing values represented by 'UN' with NaN
  2. Convert pandas dataframe to NumPy array
  3. Strings in a DataFrame, but dtype is object
  4. What does axis in pandas mean?
  5. FutureWarning: elementwise comparison failed; returning scalar, but in the future will perform elementwise comparison
  6. pandas select from Dataframe using startswith
  7. How to map numeric data into categories / bins in Pandas dataframe
  8. What’s the fastest way in Python to calculate cosine similarity given sparse matrix data?
  9. Restart cumsum and get index if cumsum more than value
  10. Pandas: Subtracting two date columns and the result being an integer
  11. Convert timedelta64[ns] column to seconds in Python Pandas DataFrame
  12. Select multiple ranges of columns in Pandas DataFrame
  13. ‘DataFrame’ object has no attribute ‘sort’
  14. Pandas pd.Series.isin performance with set versus array
  15. Improve Row Append Performance On Pandas DataFrames
  16. Difference between data type ‘datetime64[ns]’ and ‘
  17. Missing data, insert rows in Pandas and fill with NAN
  18. python pandas flatten a dataframe to a list
  19. Precision lost while using read_csv in pandas
  20. Get week start date (Monday) from a date column in Python (pandas)?
  21. What is dtype(‘O’), in pandas?
  22. pandas distinction between str and object types
  23. NumPy version of “Exponential weighted moving average”, equivalent to pandas.ewm().mean()
  24. Python Pandas – Missing required dependencies [‘numpy’] 1
  25. Pandas: Difference between largest and smallest value within group
  26. How to resample a dataframe with different functions applied to each column?
  27. Resample time series in pandas to a weekly interval
  28. Convert a column of timestamps into periods in pandas
  29. What is the Big O Complexity of Reversing the Order of Columns in Pandas DataFrame?
  30. How to use numpy to get the cumulative count by unique values in linear time?

Leave a Comment