Question: Types of Data Problems Duplicate Data - when the data in all columns is identical for two or more rows Inconsistent values ( in one
Types of Data Problems
Duplicate Data when the data in all columns is identical for two or more rows
Inconsistent values in one columndue to spelling, spaces, punctuation, abbreviation
Blank cells missing data that should be there
Numbers that aren't numbers
Multiple Values per cell
Outliers & Incorrect Values
Inconsistent Related values when the data in one or more column is inconsistent with the data
in another column for the same row between columns
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
