Analysis of Clinical and Animal Laboratory Medical Charts using Excel and R
Abstract
The standard of care for medical data documentation in the ICU involves the recording of hourly vitals. These vitals are used for a quick summary of patient status and for visualizing trends as part of routine medical care. In a similar way, large animal research models of critical care use hourly vitals recordings to track subject state and treatment response. In addition to the hourly vitals, time points of interest to research may be recorded as frequently as every five minutes. These recordings are entered into a series of Excel spreadsheets for convenience of data entry and editing as well as easy generation of trend graphs. For each animal, a single Excel workbook contains sheets for hourly vitals, lab values, and demographics as well as study-specific devices, procedures, and results. In the analysis phase, it is necessary to pull each subject's data from the series of workbooks into a single coherent dataset from which time points can be correlated and groups can be compared both graphically and numerically. This document gives a procedure for assembling the Excel data into a single dataset for analysis using R.
Document Details
- Document Type
- Technical Report
- Publication Date
- Jun 19, 2019
- Accession Number
- AD1075653
Entities
People
- William L. Baker
Organizations
- United States Army Institute of Surgical Research