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, given the low counts on most of the categories. We use the Reclassify node to fix all these problems.
The Reclassify node allows you to reclassify or recode the data values for categorical fields. For example, let's say that customers reported satisfaction...
