Precision lost while using read_csv in pandas Precision lost while using read_csv in pandas numpy numpy

Precision lost while using read_csv in pandas


It is only display problem, see docs:

#temporaly set display precisionwith 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.