Reclassifying categorical values
In the previous chapter, we used the Data Audit node to investigate the data file. The most critical problem that was found was that children were included in the dataset; the Select node was used to fix this issue. However, the Data Audit node also revealed additional irregularities within the data. For example, the Education field had too many categories, several of which had very low counts. In addition, the Vet_benefits field, which is a categorical variable, was coded with numeric values, so adding labels made interpretation easier.
Also, the Household_summary field had a misspelled version of a category that was creating an additional unnecessary category. The birth country fields needed to be transformed, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access