How do i remove "nan" and "inf" from a column?

alex

New member
hello,

I've got a problem and would like to know how do I remove "nan" and "inf" from a column?
 

Support

Administrator
Staff member
Hi Alex,

use this expression inside the calculator to remplace nan and inf with "-1":
"isFinite(x)?x:-1"

see also the example in attachment.

Cheers
 

Attachments

  • remove_nan_inf.anatella
    1.4 KB · Views: 761
Top