Rounding errors in Pandas merge

Question

I noticed that Python rounded floating numbers after merging 2 dataframes and I was wondering if somebody knows how to disable this function. The original dataframe had value 0.0533903000132149 and after merging this value became 0.0533903. Last 11 digits were cut off, and this causes significant rounding errors in calculations.

Does somebody know how to merge 2 dataframes without changing the original values?

Hey, could you provide a [minimal reproducible example](https://stackoverflow.com/questions/20109391/how-to-make-good-reproducible-pandas-examples) of the behavior you're seeing? — Kyle Parsons, Aug 11 '21 at 18:22
This means: provide a dataset and code that, when ran, demonstrate the rounding error. — mozway, Aug 11 '21 at 18:32

score 0 · Answer 1 · answered Aug 11 '21 at 18:30

0

You could try casting your numerical columns into object datatypes (strings), before merging. In that way you will maintain all the values.

PS: Remember that float datatypes are not meant to be precise.

answered Aug 11 '21 at 18:30

GabrielP

777
4
8

Rounding errors in Pandas merge

1 Answers1