Journal of Advanced Nursing · 2025 · 18 citations · 13 references
ComputingData ScienceClinical Data ManagementData AnalyticsHealthcare Quality ImprovementData AnalysisData CleaningData QualityMissing Data HandlingMissing Data ImputationOutlier HandlingData Quality CleaningEvidence-based Decision MakingHealthcare Data QualityMissing Data AnalysisOutlier CorrectionOutlier ImputationOutlier RemovalPatient Outcomes Measurement
AIMS: This paper discusses data errors and offers guidance on data cleaning techniques, with a particular focus on handling missing values and outliers in quantitative datasets. DESIGN AND METHODS: Methodological discussion. RESULTS: This paper provides an overview of various techniques for identifying and addressing data anomalies, which can arise from incomplete, noisy, and inconsistent data. These anomalies can significantly affect data quality, leading to biased model parameter estimates and evidence-based decisions. Data cleaning, particularly the appropriate handling of missing values and outliers, is essential to improving data quality before analysis. Data cleaning includes screening for anomalies, diagnosing errors, and applying appropriate corrective measures. CONCLUSION: Proper handling of missing values and the identification and correction of outliers are crucial aspects of data cleaning in ensuring data quality and the reliability of statistical analyses. Effective data cleaning enhances the validity and accuracy of research findings for evidence-based decision making that leads to optimal patient outcomes. IMPLICATIONS FOR THE PROFESSION: The quality of study results depends on how a dataset and its complexities are processed or handled before the analysis. Nursing researchers must use a framework to identify and address important data anomalies and produce reliable results. IMPACT: This paper describes data cleaning, often overlooked during the data mining process, as a crucial step before conducting data analysis. By addressing missing values and outliers, identifying and fixing data anomalies, and enhancing data quality prior to analysis, data cleaning techniques can produce precise research findings for evidence-based decision making. REPORTING METHOD: In this methodological paper, no new data were generated. PATIENT OR PUBLIC CONTRIBUTION: No patient or public contribution.
13
Missing data: Our view of the state of the art.
Joseph L. Schafer, J. A. Graham · Psychological Methods · 2002 · 10.9K citations
MissForest—non-parametric missing value imputation for mixed-type data
Daniel J. Stekhoven, Peter Bühlmann · Bioinformatics · 2011 · 6.1K citations · Full text
Fei Tony Liu, Kai Ming Ting, Zhi‐Hua Zhou · 2008 · 5.6K citations
Data Cleaning: Detecting, Diagnosing, and Editing Data Abnormalities
Jan Van den Broeck, Solveig A. Cunningham, R. Eeckels et al. · PLoS Medicine · 2005 · 447 citations · Full text