Comment
Author: Admin | 2025-04-28
: 9.958 Mean :77.88 Mean :6.993 3rd Qu.: 46.00 3rd Qu.:258.8 3rd Qu.:11.500 3rd Qu.:85.00 3rd Qu.:8.000 Max. :168.00 Max. :334.0 Max. :20.700 Max. :97.00 Max. :9.000 NA's :7 Day Min. : 1.0 1st Qu.: 8.0 Median :16.0 Mean :15.8 3rd Qu.:23.0 Max. :31.0 Performing the same operation in another column.RNew_df$Solar.R = ifelse(is.na(New_df$Solar.R), median(New_df$Solar.R, na.rm = TRUE), New_df$Solar.R)Now can clearly see that we don’t have any unclean data using summary methods.ROutput: Ozone Solar.R Wind Temp Month Min. : 1.00 Min. : 7.0 Min. : 1.700 Min. :56.00 Min. :5.000 1st Qu.: 21.00 1st Qu.:120.0 1st Qu.: 7.400 1st Qu.:72.00 1st Qu.:6.000 Median : 31.50 Median :205.0 Median : 9.700 Median :79.00 Median :7.000 Mean : 39.56 Mean :186.8 Mean : 9.958 Mean :77.88 Mean :6.993 3rd Qu.: 46.00 3rd Qu.:256.0 3rd Qu.:11.500 3rd Qu.:85.00 3rd Qu.:8.000 Max. :168.00 Max. :334.0 Max. :20.700 Max. :97.00 Max. :9.000 Day Min. : 1.0 1st Qu.: 8.0 Median :16.0 Mean :15.8 3rd Qu.:23.0 Max. :31.0 We can clearly see that we don’t have any missing data inside data frame.ROutput: Ozone Solar.R Wind Temp Month Day1 41.0 190 7.4 67 5 12 36.0 118 8.0 72 5 23 12.0 149 12.6 74 5 34 18.0 313 11.5 62 5 45 31.5 205 14.3 56 5 56 28.0 205 14.9 66 5 6Now our boxplot outliers also show no errors.RBoxplot of Airquality Data setDepending on the nature of the dataset and the cleaning requirements, many techniques and functions may be employed to clean the data. Before moving on to further in-depth research, exploratory data analysis and rigorous study of the data are essential in spotting and resolving data quality issues.
Add Comment