Precision lost while using read_csv in pandas

by

It is only display problem, see docs:

#temporaly set display precision
with pd.option_context('display.precision', 10):
    print df

     0          1   2      3   4             5            6             7   \
0  895  2015-4-23  19  10000  LA  0.4677978806  0.477346934  0.4089938425   

             8             9            10            11  12  
0  0.8224291972  0.8652525793  0.682994286  0.5139162227 NaN

EDIT: (Thank you Mark Dickinson):

Pandas uses a dedicated decimal-to-binary converter that sacrifices perfect accuracy for the sake of speed. Passing float_precision='round_trip' to read_csv fixes this. See the documentation for more.

More Related Contents:

  1. selecting across multiple columns with python pandas?
  2. Using numpy.genfromtxt to read a csv file with strings containing commas
  3. pandas.read_csv from string or package data
  4. Load CSV to Pandas MultiIndex DataFrame
  5. mean from pandas and numpy differ
  6. Bin values based on ranges with pandas [duplicate]
  7. Converting between datetime, Timestamp and datetime64
  8. Fast Haversine Approximation (Python/Pandas)
  9. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  10. Python out of memory on large CSV file (numpy)
  11. Conditionally fill column values based on another columns value in pandas
  12. Calculate weighted average using a pandas/dataframe
  13. Comparing previous row values in Pandas DataFrame
  14. Ambiguity in Pandas Dataframe / Numpy Array “axis” definition
  15. How to keep leading zeros in a column when reading CSV with Pandas?
  16. Problem in combining bar plot and line plot (python)
  17. How to read a column of csv as dtype list using pandas?
  18. PIP Install Numpy throws an error “ascii codec can’t decode byte 0xe2”
  19. vectorize conditional assignment in pandas dataframe
  20. Pandas: How to create a datetime object from Week and Year?
  21. python pandas read_csv delimiter in column data
  22. Binning a column with pandas
  23. Read csv from Google Cloud storage to pandas dataframe
  24. Convert numpy type to python
  25. plotting a histogram on a Log scale with Matplotlib
  26. module ‘pandas’ has no attribute ‘read_csv
  27. Conditional row read of csv in pandas
  28. Split Python sequence (time series/array) into subsequences with overlap
  29. Add density curve on the histogram
  30. start index at 1 for Pandas DataFrame

Leave a Comment