From the course: Introduction to Machine Learning with KNIME
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Clean data with the Missing Value node - KNIME Tutorial
From the course: Introduction to Machine Learning with KNIME
Clean data with the Missing Value node
- [Instructor] Moving on to a new task, the clean data task of the data preparation phase, starting with row filter, but then also talking about the Missing Values node. So we're on the missing data theme. I'm going to go ahead and remove the Row Sample node. We can keep the Equal Size Sampling for now, certainly. And I'm going to go ahead and type on row, and actually a number of things come up. Here we go. We've got row filter, but again, once more, we have a bunch of different choices. We're just going to go with a standard one. And one of the things that we can do with row filter, very easily, that keeps us on the data cleaning theme, is I can say that only missing values match, specifically on the age variable. I know that the age variable has more than 100 missing cases, and I can either include only missing. Let's take a look. I actually want to make quick note of this error because this will happen to you sometimes. If you view the table before you've executed, this is what…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Merging with the Joiner node2m 24s
-
(Locked)
Aggregating with the GroupBy node1m 37s
-
(Locked)
Creating new variables with Construct3m 24s
-
(Locked)
Select data with Column Filter2m 17s
-
(Locked)
Balancing data with Row Sampling node3m 18s
-
(Locked)
Clean data with the Missing Value node2m 46s
-
(Locked)
Format with Cell Splitter3m 37s
-
(Locked)
-
-
-