Experimental Evaluation of Automated and Manual Data Cleaning Systems: A Case Study Using Organizational Data
International Journal of Theoretical & Applied Computational Intelligence · 2026
DOI: 10.65278/ijtaci.2026.42 ↗Kurz gefasst
Fachartikel in der Zeitschrift International Journal of Theoretical & Applied Computational Intelligence, 2026. Verfasst von Nagwa Elmobark und 3 weiteren Autor:innen. Die Arbeit nennt 33 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
This paper presents a comprehensive comparison between computerized and manual data cleaning methods across different types of errors, including missing values, incorrect values, and inconsistent formats. The comparison covers efficiency along the three most important dimensions of data quality: completeness, accuracy, and consistency. Using a common Kaggle dataset of 50,000 employee records, we build a systematic evaluation framework with diagnostic measures and resource-utilization profiles. The experiments evaluate cleaning quantitatively on a given distribution of anomaly types: 30% missing values (15,000 records), 25% incorrect values (12,500 records), and 45% inconsistent formats (22,500 records). Automated cleaning significantly helps normalize mixed formats (92% success) and handle invalid values (88%). However, manual cleaning outperforms automatic methods on complex, context-dependent cases, with 95% accuracy in cases that require domain knowledge. The paper shows clear benefits for both approaches: automated cleansing excels in speed and cost on large datasets, while manual cleaning is useful in difficult cases that require domain knowledge. These findings add value to the literature by presenting empirical evidence of the effectiveness of both approaches and by providing firms with a structured, knowledge-based filter for choosing suitable cleaning solutions in line with their data, needs, and organizational structure.
Zitieren
APA
Elmobark, N., Abdzaid, A. Y., Alaa, F., & Saad, A. (2026). Experimental Evaluation of Automated and Manual Data Cleaning Systems: A Case Study Using Organizational Data. International Journal of Theoretical & Applied Computational Intelligence. https://doi.org/10.65278/ijtaci.2026.42
Vancouver
Elmobark N, Abdzaid AY, Alaa F, Saad A. Experimental Evaluation of Automated and Manual Data Cleaning Systems: A Case Study Using Organizational Data. International Journal of Theoretical & Applied Computational Intelligence. 2026. doi:10.65278/ijtaci.2026.42
BibTeX
@article{Elmobark2026,
author = {Elmobark, Nagwa and Abdzaid, Amenah Y and Alaa, Farqad and Saad, Aymen},
title = {Experimental Evaluation of Automated and Manual Data Cleaning Systems: A Case Study Using Organizational Data},
journal = {International Journal of Theoretical & Applied Computational Intelligence},
year = {2026},
doi = {10.65278/ijtaci.2026.42}
}
EUVIMED