Hi, I’m using python’s pandas library for data manipulation in one of my workflows. Since, the data is messy, there are a lot of manipulations involved and also there are a lot of missing values as well. Pandas treats NaN as a missing value while KNIME doens’t do so. So, now my aggregations are not working fine on KNIME and there are a lot of manipulations involved that can’t be achieved by just using native KNIME nodes. Is there any way by which I can replace the NaNs with missing values? Tried to search through all the topics on the forum but those are not really helping me. Also, the version I’m using is 4.3.

Converting NaNs to missing values

mlauber71 January 31, 2021, 1:44pm 4

Another way could be to employ a Java Snippet

3 Likes