Missing Value node is not removing missing values, What is the fix?
Hello guys, hope you’re all well.
I have a data set, where per the description of the dataset, the “?” key is an indiciation of a missing value.
This is where I got my dataset from: https://archive.ics.uci.edu/ml/machine-learning-databases/breast-cancer-wisconsin/breast-cancer-wisconsin.data
And this is a description of the data set:
The way I’m trying to remove the missing values is as follow:
I use the file reader to read the URL I add the Missing Value Node, I configure it as follow:
Number (integer) : Replace with Mean
Missing String: Remove Row
This is how the workflow looks like:
However, when I view the table, I still find rows having missing values:
I’m assuming that knime is not viewing the ? as missing values, but what is the solution then?
Thank you!