Objective: Identify and resolve common data-quality problems before using data for AI and data analysis.
Preparation guidance: Check data quality for missing, duplicate, invalid, inconsistent, and unusual values; decide how to handle missing data; clean and standardize formats and categories; investigate outliers before removing them; select only relevant features; then transform and validate the final dataset.
InspectCleanHandle Missing DataSelect FeaturesTransformValidateAnalyze
Step 1: Inspect the Dataset
A government department collected the following service-request data for future AI analysis. Review the table and identify the problems.