Number format

[william888]

Hi,

I have 2 columns (colA & colB) which is float type.

When I apply the following python code, the 2 columns shows exactly the same value.
Example: colA = 3940.82 vs colB = 3940.82

test = df.groupby('mycol').sum()

However, when I am trying to apply the following code, the above example show up.

test['colA']!=test['colB']

From what I understand, it is floating point error which the exact value might be colA is 3940.82347834 although it shows 3940.82.

I am using the following rounding to solve the issue but is it actually correct? or is there a correct solution to it?

round(test['colA'],2)!=round(test['colB'],2)