- #1
Zap
- 406
- 120
- TL;DR Summary
- 25.15 = 25.149999999999977??
I am parsing data from an excel sheet using pandas ExcelFile class and read_excel function. I noticed that when reading the file, there are floating point errors in the results. For example, a cell that contains 25.15 will be 25.149999999999977 in the pandas data frame.
The value 25.15 in Excel is not rounded. It is the result of adding 298.15 minus 273.
This link describes the problem, but there is not solution : https://github.com/pandas-dev/pandas/issues/21885
I'm surprised ExcelFile and read_excel has an error like this. It pretty much makes them unusable, in my opinion.
The value 25.15 in Excel is not rounded. It is the result of adding 298.15 minus 273.
This link describes the problem, but there is not solution : https://github.com/pandas-dev/pandas/issues/21885
I'm surprised ExcelFile and read_excel has an error like this. It pretty much makes them unusable, in my opinion.