Icon

Tutorial-J_​Data-Cleaning_​and_​Recoding

<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 J - Data Cleaning and Recoding


Data preparation is an important process that includes very often the cleaning and transformation of the raw data. These operations are needed to correct and filter bad data, reformat, or even filter out data that are too detailed, causing more noise in the model than anything else. With careful and comprehensive data preparation the data will speak for itself during its processing and analysis, highlighting better insights and, with no doubt, better outcomes from any modeling effort.

This tutorial demonstrates one example of how to recode the data so that errors that occurred during data extraction are addressed.

Review Tutorial_J for more detailed instructions.

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

Tutorial H_Integrated-file.csv

Convert any negative values in "ZIP" column to positive

Convert the ZIP column into String format

Attach leading zeroes, if any, that were dropped due to auto-typing when data was read in KNIME.

Write recoded data table to CSV file.

Nodes

  • No nodes found

Extensions

  • No modules found

Links