hello, I've got a problem and would like to know how do I remove "nan" and "inf" from a column?
A alex New member Oct 28, 2021 #1 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 Oct 28, 2021 #2 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: 853
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