Abstract:Research with structured Electronic Health Records (EHRs) is expanding as data becomes more accessible; analytic methods advance; and the scientific validity of such studies is increasingly accepted. However, data science methodology to enable the rapid searching/extraction, cleaning and analysis of these large, often complex, datasets is less well developed. In addition, commonly used software is inadequate, resulting in bottlenecks in research workflows and in obstacles to increased transparency and reproducibility of the research. Preparing a research-ready dataset from EHRs is a complex and time consuming task requiring substantial data science skills, even for simple designs. In addition, certain aspects of the workflow are computationally intensive, for example extraction of longitudinal data and matching controls to a large cohort, which may take days or even weeks to run using standard software. The rEHR package simplifies and accelerates the process of extracting ready-for-analysis datasets from EHR databases. It has a simple import function to a database backend that greatly accelerates data access times. A set of generic query functions allow users to extract data efficiently without needing detailed knowledge of SQL queries. Longitudinal data extractions can also be made in a single command, making use of parallel processing. The package also contains functions for cutting data by time-varying covariates, matching controls to cases, unit conversion and construction of clinical code lists. There are also functions to synthesise dummy EHR. The package has been tested with one for the largest primary care EHRs, the Clinical Practice Research Datalink (CPRD), but allows for a common interface to other EHRs. This simplified and accelerated work flow for EHR data extraction results in simpler, cleaner scripts that are more easily debugged, shared and reproduced.

Reshaping and Aggregating Data: an Introduction to Reshape Package.

Data Management by Using R: Big Data Clinical Research Series

Hierarchical Cluster Analysis In Clinical Research With Heterogeneous Study Population: Highlighting Its Visualization With R

An R Package to Partition Observation Data Used for Model Development and Evaluation to Achieve Model Generalizability

EasyMergeR: an interactive Shiny application to manipulate multiple XLSX files of multiple sheets

Rainforest plots for the presentation of patient-subgroup analysis in clinical trials

Missing Data Exploration: Highlighting Graphical Presentation of Missing Pattern.

rEHR: An R package for manipulating and analysing Electronic Health Record data

Univariate Description and Bivariate Statistical Inference: the First Step Delving into Data

Missing Values in Big Data Research: Some Basic Skills

Big Data and Clinical Research: Perspective from a Clinician.

EHRs Data Harmonization Platform, an easy-to-use shiny app based on recodeflow for harmonizing and deriving clinical features

latrend: A Framework for Clustering Longitudinal Data

Subgroup identification in clinical trials: an overview of available methods and their implementations with R

A Data Analytics Framework for Aggregate Data Analysis

Statistical Applications in Genetics and Molecular Biology

Use ggbreak to Effectively Utilize Plotting Space to Deal With Large Datasets and Outliers

BASIC PRINCIPLES OF BIOMEDICAL DATA ANALYSIS IN R

Data transformation: a focus on the interpretation

Integrative analysis of individual-level data and high-dimensional summary statistics

When and how to split the follow-up time in the analysis of epidemiological or clinical studies with follow-ups