Abstract:Although randomized controlled trials (RCTs) are the gold standard for establishing the efficacy and safety of a medical treatment, real-world evidence (RWE) generated from real-world data has been vital in postapproval monitoring and is being promoted for the regulatory process of experimental therapies. An emerging source of real-world data is electronic health records (EHRs), which contain detailed information on patient care in both structured (eg, diagnosis codes) and unstructured (eg, clinical notes and images) forms. Despite the granularity of the data available in EHRs, the critical variables required to reliably assess the relationship between a treatment and clinical outcome are challenging to extract. To address this fundamental challenge and accelerate the reliable use of EHRs for RWE, we introduce an integrated data curation and modeling pipeline consisting of 4 modules that leverage recent advances in natural language processing, computational phenotyping, and causal modeling techniques with noisy data. Module 1 consists of techniques for data harmonization. We use natural language processing to recognize clinical variables from RCT design documents and map the extracted variables to EHR features with description matching and knowledge networks. Module 2 then develops techniques for cohort construction using advanced phenotyping algorithms to both identify patients with diseases of interest and define the treatment arms. Module 3 introduces methods for variable curation, including a list of existing tools to extract baseline variables from different sources (eg, codified, free text, and medical imaging) and end points of various types (eg, death, binary, temporal, and numerical). Finally, module 4 presents validation and robust modeling methods, and we propose a strategy to create gold-standard labels for EHR variables of interest to validate data curation quality and perform subsequent causal modeling for RWE. In addition to the workflow proposed in our pipeline, we also develop a reporting guideline for RWE that covers the necessary information to facilitate transparent reporting and reproducibility of results. Moreover, our pipeline is highly data driven, enhancing study data with a rich variety of publicly available information and knowledge sources. We also showcase our pipeline and provide guidance on the deployment of relevant tools by revisiting the emulation of the Clinical Outcomes of Surgical Therapy Study Group Trial on laparoscopy-assisted colectomy versus open colectomy in patients with early-stage colon cancer. We also draw on existing literature on EHR emulation of RCTs together with our own studies with the Mass General Brigham EHR.

A Data Pipeline for Enhancing Quality of MAUDE-Based Studies

Developing a Generative AI-Powered Chatbot for Analyzing MAUDE Database

An automated data analysis pipeline for GC-TOF-MS metabonomics studies.

A Multidatabase ExTRaction PipEline (METRE) for Facile Cross Validation in Critical Care Research

Scalable quality control on processing of large diffusion-weighted and structural magnetic resonance imaging datasets

MetaDB a Data Processing Workflow in Untargeted MS-Based Metabolomics Experiments

Unveiling Originated Stages of Medication Errors: An Automated Pipeline Approach

A Survey of Pipeline Tools for Data Engineering

Generate Analysis-Ready Data for Real-world Evidence: Tutorial for Harnessing Electronic Health Records With Advanced Informatic Technologies

Optimizing Data Extraction: Harnessing RAG and LLMs for German Medical Documents

Data Flow Construction and Quality Evaluation of Electronic Source Data in Clinical Trials: Pilot Study Based on Hospital Electronic Medical Records in China

A Method of Electronic Health Data Quality Assessment: Enabling Data Provenance.

An Entity Extraction Pipeline for Medical Text Records Using Large Language Models: Analytical Study

MEDDAP: Medical Dataset Enhancement via Diversified Augmentation Pipeline

Electronic data quality control strategy in clinical research

Development and Validation of ML-DQA -- a Machine Learning Data Quality Assurance Framework for Healthcare

Design and application of unplanned extubation quality index management system based on direct data acquisition

Common data models to streamline metabolomics processing and annotation, and implementation in a Python pipeline

OpenDeID Pipeline for Unstructured Electronic Health Record Text Notes Based on Rules and Transformers: Deidentification Algorithm Development and Validation Study

Synergizing Data Imputation and Electronic Health Records for Advancing Prostate Cancer Research: Challenges, and Practical Applications