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

Institutions

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
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

clickR: Semi-automatic pre-processing of messy data with change tracking for integral dataset cleaning

David Hervás, David de la Fuente
1 citations
SoftwareX
Data Quality and Management
0.49
article

clickR: Semi-automatic pre-processing of messy data with change tracking for integral dataset cleaning

David Hervás, David de la Fuente
article en
1 citations

Abstract

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.

SoftwareXVol. 27
Universitat Politècnica de València (ES)
Industry, innovation and infrastructure
Openalex Percentile: Top 32%
Data Quality and Management
0.49
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.