azuremachine-learningazure-machine-learning-serviceml-studio

How to deal with missing values in Azure Machine Learning Studio

Looks like I have 672 mission values, according to statistics. There are NULL value in QuotedPremium column.

enter image description here

I implemented Clean Missing Data module where it should substitute missing values with 0, but for some reason I'm still seeing NULL values as QuotedPremium, but...it says that missing values are = 0

enter image description here

enter image description here

Here you see it tells me that missing values = 0, but there are still NULLs

enter image description here

So what really happened after I ran Clean Missing Data module? Why it ran succesfully but there are still NULL values, even though it tells that number of missing values are 0.

Solution

  • NULL is indeed a value; entries containing NULLs are not missing, hence they are neither cleaned with the 'Clean Missing Data' operator nor reported as missing.