Question

An analyst is profiling a customer dataset and notices the 'State' column contains values such as 'CA', 'Calif.', 'California', and 'ca'. When they attempt to group total sales by state, the same state is split across multiple groups, inflating the count of distinct states. What data preparation task should the analyst perform to resolve this issue?

Accepted Answer

Standardize the categorical values by mapping all variants to a single canonical form

Answer

Impute the missing state values using the most frequent state

Answer

Remove all rows containing state values as outliers

Answer

Apply min-max normalization to the State column to scale the values