Question: s Locate values in a single column that are not null but represent missing, incorrect, or inconsistent data. For example: Zeros in a column where
s Locate values in a single column that are not null but represent missing, incorrect, or inconsistent data. For example: Zeros in a column where a numeric value should be present NA, Not Applicable, or other similar values Values that fall outside the normal range of values for the column Choose one of the following actions to perform on this one column: Change the values so that they are correctly labeled and recognized by SQL as NULL values Modify the values to more accurately represent the data (such as replacing values with the column's mean, standardizing capitalization, etc) Remove the data containing these values
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
