Explanation

Data Cleaning means correcting or removing inaccurate, incomplete, duplicated, or inconsistent data so that it can be used reliably for analysis.

Common data problems:

• Duplicate records
• Extra spaces
• Inconsistent spelling
• Blank cells
• Incorrect data types
• Incorrect capitalization
• Unwanted characters

Example

Problems include:

• Duplicate Amit record
• SIRSA vs Sirsa
• Extra spaces around Priya

Practice

Identify all data-quality problems in the table.