Description Usage Arguments Details Value Examples
read_data takes a directory and file name and reads in all matching
csv files and binds them together into a data frame
1 |
data.dir |
A character string with the name of the directory containing the data files |
file.name |
A character string with name of data file or pattern to match |
edw |
A boolean indicating if the data came from EDW; set to FALSE for |
archive |
A boolean indicating if the data was extracted as a csv archive. If TRUE, will recursively search folders for csv files and will skip the first line for column headers |
This function takes a directory and file name and reads in all matching csv
files and binds them together into a data frame using read_csv from
readr. The resulting data frame has a class of edwr, and can
then be passed to one of the edwr-related class types for variable renaming
and type setting (example: as.labs).
The following table lists the edwr-related class which corresponds to each EDW Standard Project Queries.
| edwr Class Name | --- | EDW Query Name |
| blood | Blood Products | |
| charges | Charges - [All, Department Prompt] | |
| demographics | Demographics | |
| diagnosis | Diagnosis Codes (ICD-9/10-CM) - All | |
| drg | DRG Codes - All | |
| encounters | Encounters - by Person ID | |
| events | Clinical Events - Prompt | |
| icu_assess | ICU Assessments (CAM-ICU, GCS, RASS) | |
| id | Identifiers - by FIN | |
| Identifiers - by MRN | ||
| Identifiers - by PowerInsight Encounter Id | ||
| labs | Labs - ABG | |
| Labs - CBC | ||
| Labs - Chemistry | ||
| Labs - Coags | ||
| Labs - HIT | ||
| Labs - LFTs | ||
| Labs - Pregnancy | ||
| Labs - Renal | ||
| Urine Drug Screen | ||
| Vomiting Output | ||
| locations | Location History | |
| measures | Measures (Height and Weight) | |
| meds_cont | Medications - Inpatient Continuous - [All, Prompt] | |
| meds_freq | Medications - Inpatient Intermittent with Frequency - [All, Prompt] | |
| meds_home | Medications - Home and Discharge - [All, Prompt] | |
| meds_sched | Medications - Inpatient Intermittent - [All, Prompt] | |
| mpp | MPP's Ordered - [All, Order Prompt] | |
| mrn | Identifiers - Person by MRN | |
| order_by | Orders - Prompt | |
| order_detail | Orders - from Clinical Event Id - Prompt | |
| patients | Patients - by CDM charge - HealthQuest - [Location Prompt, System] | |
| Patients - by ICD-9/10-CM Diagnosis Code | ||
| Patients - by Medication | ||
| Patients - by Unit Admission | ||
| problems | Problem List | |
| procedures | Procedure Codes (ICD-9-CM/ICD-10-PCS) - All | |
| radiology | Radiology Reports | |
| services | Service History | |
| surgeries | Surgeries | |
| uop | Urine output | |
| vent_settings | Ventilator Data - Settings | |
| vent_times | Ventilator Data - Start and Stop | |
| visits | Visit Data | |
| vitals | Vitals | |
| warfarin | Warfarin Information | |
A data frame of class tbl_edwr
1 2 3 4 5 6 7 8 9 10 | x <- read_data(
data.dir = paste0(system.file(package = "edwr", "extdata")),
file.name = "demographics.csv"
)
str(x)
class(x)
y <- as.demographics(x)
class(y)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.