import_excel_data: Imports patient data from multiple sheets of excel file.

In agapiospanos/StartStopp: START and STOPP criteria evaluation for potentially inappropriate prescribing

Description

Imports patient data from multiple sheets of excel file.

Usage

import_excel_data(current_data, path, worksheet, var_col,
  ignore_na = FALSE, include_missing = FALSE)

Arguments

current_data	(List) the data that was imported by another call of import_excel_data so that this call will append the new data to the old ones.
path	(Character) the path that the excel file can be read from.
worksheet	(Character) the worksheet that the desired variable is stored in.
var_col	(Character) the column that stores the desired variable
ignore_na	(Boolean) (optional) (default: FALSE) a boolean variable that indicates whether to ignore any N/As found in excel (if set to TRUE) or to handle them as missing data (if set to FALSE).
include_missing	(Boolean) (optional) (default: FALSE) a boolean that indicated whether to include the missing values as NAs in the data to achieve one to one correspondance in the data if necessary.

Value

list of [[1]] patient data for the specified variable. [[2]] missing patient id and variable name as specified in excel that we used to import data.

Author(s)

Agapios Panos <[e-mail]>

agapiospanos/StartStopp documentation built on Jan. 5, 2021, 4:41 p.m.