5.3.3 Data Cleaning and Transformation
Data Analytics
Data cleaning and transformation are important steps to prepare data for analysis. Raw data often has errors, missing values, or may be in the wrong format. To ensure accurate results in analysis, it is important to fix these issues before moving forward.
5.3.3.1 Data Cleaning
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 |