import_excel_data: Imports patient data from excel file.

In agapiospanos/DDI: DDI criteria evaluation for potential interactions between drugs

Description

Imports patient data from excel file.

Usage

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

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.
excel_col_pid	(Character) the column name that specifies the patient id in the excel you provided for the data.

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/DDI documentation built on March 11, 2021, 3:37 a.m.