Icon

Tutorial-M_​MissingValues_​with_​Constants

<p>This tutorial is part of a series of tutorials on the topic of data preparation (Tutorial_G – Tutorial_O). These tutorials are included in the book, <em>Handbook of Statistical Analysis, AI, and ML Applications (Elsevier Publishers, 2025). </em>These tutorials will guide you to build KNIME workflows to perform common data preparation tasks. You can adapt these workflows easily to load and process your own datasets.</p><p>---</p><p>The publisher has graciously permitted these tutorials to be included on the KNIME Community Hub and has provided the 30% discount code <em>MATH30</em> to purchase the book from https://shop.elsevier.com/books/handbook-of-statistical-analysis/nisbet/978-0-443-15845-2.</p>

This tutorial is part of a series of tutorials on the topic of data preparation (Tutorial_G – Tutorial_O). These tutorials are included in the book, Handbook of Statistical Analysis, AI, and ML Applications (Elsevier Publishers, 2025). These tutorials will guide you to build KNIME workflows to perform common data preparation tasks. You can adapt these workflows easily to load and process your own datasets.

---

The publisher has graciously permitted these tutorials to be included on the KNIME Community Hub and has provided the 30% discount code MATH30 to purchase the book from https://shop.elsevier.com/books/handbook-of-statistical-analysis/nisbet/978-0-443-15845-2.

Tutorial M - Filling Missing Values with Constants


Filling missing values with a suitable data value for a variable is an operation called data imputation. The task of deciding which value to use to fill in blanks in a record should follow rules or a set of rules defined based on assumptions about the pattern of the data. There is a drawback in this operation though: data added to the pattern might not reflect the underlying pattern of the complete data.

Handling missing data inappropriately can lead to biased conclusions and consequently to wrong business decisions. Determining the type of missing data, (1) Missing Completely at Random (MCAR), (2) Missing at Random (MAR), and (3) Missing Not at Random (MNAR), will help to choose which imputation technique to use


Review Tutorial_M for more detailed instructions.

Load the file created in Tutorial_L from the Data/ directory:

Tutorial-L_Outlier-Removal.csv

Fill the missing values with suitable constants

Nodes

  • No nodes found

Extensions

  • No modules found

Links