A data preparation framework for cleaning electronic health records and assessing cleaning outcomes for secondary analysis.

Even though data preparation constitutes a large proportion of the total effort involved in electronic health record (EHR) based secondary analysis, guidelines for EHR data preparation are still insufficient to date. This study proposes a data preparation framework that can guide and validate the cleaning of EHRs for secondary analysis. The developed framework consists of three core themes-workflow, assessment and cleaning methods, and cleaning evaluation scheme. To illustrate the viability of the proposed framework, we applied it to a hip-fracture readmission scenario using the underlying data extracted from a large EHR database. The case study demonstrated the effectiveness of the proposed framework in organizing and standardizing phases and processes within an EHR data preparation workflow. Furthermore, the cleaning evaluation scheme was found to be effective in validating EHR cleaning methods, especially for those used to handle complex issues that usually appear in patient demographics, longitudinal attributes of EHRs, and the application of filtering and imputation cleaning methods. & COPY; 2022 Elsevier Ltd. All rights reserved.