Converting object to float loses too much precision - pandas

Viewed 5698

I'm trying to plot a DataFrame using pandas but it's not working (see this similar thread for details). I think part of the problem might be that my DataFrame seems to be made of objects:

>>> df.dtypes
Field          object
Moment         object
Temperature    object

However, if I were to convert all the values to type float, I lose a lot of precision. All the values in column Moment are of the form -132.2036E-06 and converting to float with df1 = df.astype(float) changes it to -0.000132.

Anyone know how I can preserve the precision?

1 Answers
Related