5.3.3.1 Data Cleaning
Data Analytics
Data cleaning means correcting or removing any problems in the data. These problems can include incorrect entries, missing values, or duplicate data. If these errors are not fixed, the results of the analysis will be misleading.
Example: Imagine a school collecting data on student grades. Some students may have entered their names incorrectly, or a few grades may be missing from the records. In this case, data cleaning would involve correcting any wrong names and finding the missing grades to complete the dataset. Figure 5.2, illustrates the data cleaning process for student grades in a school. It shows examples of common issues such as incorrect names, missing grades, and duplicate entries.
| Name | Grade | Class | Section |
|---|---|---|---|
Ali | 85 | 10 | A |
Alie | 90 |