I am importing data from a simple Excel file created with LibreOffice Calc to pandas using the xlrd module. One of the cells contains 0.14, but pandas reads it as 0.14000000000001. Another has 0.584, which becomes 0.583999999996 for some reason.
My code is roughly:
>>> import pandas as pd
>>> xl = pd.ExcelFile("truc.xls")
>>> fr = xl.parse('s')
>>> fr["RISE"]["C_K"]
0.14000000000000001 #Should be 0.14
Do you know what is causing that?
