clickR: Semi-automatic pre-processing of messy data with change tracking for integral dataset cleaning
In this contribution, we present clickR , an R package intended for data cleaning following a semi-automatic and supervised procedure. Few packages and commercial software with cleaning capacities are available. In all cases, their functionalities just cover part of the overall data pre-processing and do not follow an integral approach to cleaning up the data. In contrast, clickR brings together all functions needed for correcting the main structural, variable-assignment and typographical errors found in databases and allows researchers to have a strict control on the suggested changes. This is possible because the package creates a data frame that keeps track of all the implemented data modifications. To prove its capacity for detecting and fixing errors, we clean a messy database that exhibits multiple types of errors within date, numeric and factor variables.
Authors
- David Hervás (ORCID: https://orcid.org/0000-0003-0635-4961)
- David de la Fuente (ORCID: https://orcid.org/0000-0001-7591-2600)
Institutions
- Universitat Politècnica de València (ES)
Publication Details
- Journal
- SoftwareX
- Published
- 2024-08-26
- DOI
- https://doi.org/10.1016/j.softx.2024.101865
- Citations
- 1
- Primary Topic
- Data Quality and Management
- Type
- article
- Field-Weighted Citation Impact
- 0.49