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.

Related Contents:

  1. Convert pandas dataframe to NumPy array
  2. pandas create new column based on values from other columns / apply a function of multiple columns, row-wise
  3. What does axis in pandas mean?
  4. Split (explode) pandas dataframe string entry to separate rows
  5. How can I map True/False to 1/0 in a Pandas DataFrame?
  6. Counting unique values in a column in pandas dataframe like in Qlik?
  7. NumPy or Pandas: Keeping array type as integer while having a NaN value
  8. Binning a column with pandas
  9. What is the difference between NaN and None?
  10. Efficiently checking if arbitrary object is NaN in Python / numpy / pandas?
  11. Performance of Pandas apply vs np.vectorize to create new column from existing columns
  12. How to use sklearn fit_transform with pandas and return dataframe instead of numpy array?
  13. How to get value counts for multiple columns at once in Pandas DataFrame?
  14. Ambiguity in Pandas Dataframe / Numpy Array “axis” definition
  15. Pass percentiles to pandas agg function
  16. Coalesce values from 2 columns into a single column in a pandas dataframe
  17. How to one-hot-encode from a pandas column containing a list?
  18. Pandas: Subtracting two date columns and the result being an integer
  19. Get index of a row of a pandas dataframe as an integer
  20. Importing data from a MySQL database into a Pandas data frame including column names [duplicate]
  21. pandas select from Dataframe using startswith
  22. ValueError: numpy.dtype has the wrong size, try recompiling
  23. Python Pandas – Changing some column types to categories
  24. Pandas Split Dataframe into two Dataframes at a specific row
  25. What’s the fastest way in Python to calculate cosine similarity given sparse matrix data?
  26. How to convert list of model objects to pandas dataframe?
  27. ValueError: Unknown label type: ‘unknown’
  28. shuffling/permutating a DataFrame in pandas
  29. Find out the percentage of missing values in each column in the given dataset
  30. Suppressing scientific notation in pandas? [duplicate]
  31. Get the mean across multiple Pandas DataFrames
  32. Pandas Timedelta in Days
  33. Pandas in AWS lambda gives numpy error
  34. Cross-correlation (time-lag-correlation) with pandas?
  35. Creating Pandas Dataframe between two Numpy arrays, then draw scatter plot
  36. How to check if a variable is either a python list, numpy array or pandas series
  37. Finding count of distinct elements in DataFrame in each column
  38. Comparing previous row values in Pandas DataFrame
  39. Improve Row Append Performance On Pandas DataFrames
  40. Fast Haversine Approximation (Python/Pandas)
  41. Output different precision by column with pandas.DataFrame.to_csv()?
  42. Set values on the diagonal of pandas.DataFrame
  43. When to use pandas series, numpy ndarrays or simply python dictionaries?
  44. Scikit-Learn’s Pipeline: A sparse matrix was passed, but dense data is required
  45. Convert numpy type to python
  46. which is faster for load: pickle or hdf5 in python
  47. When to apply(pd.to_numeric) and when to astype(np.float64) in python?
  48. Calculate average of every x rows in a table and create new table
  49. pd.NA vs np.nan for pandas
  50. Python Numpy TypeError: ufunc ‘isfinite’ not supported for the input types

Leave a Comment