Date2CadLabel: Add Cadence to Data

In predsci/DICE: DICE: Dynamics of Interacting Community Epidemics

Description

Take the date/cadence output from a MySQL query and add appropriate 'year', 'month', 'week', or 'day' columns.

Usage

Date2CadLabel(query_result = NULL)

Arguments

query_result

A data frame resulting from a MySQL incidence query. A cadence column should be added after the query, but before calling this function.

Value

query_result The same dataframe, but with added 'year', 'month', 'week', or 'day' columns appropriate to the incidence cadence.

Examples

require(DICE)
myDB = OpenCon()
data_sources = dbReadTable(myDB, name="data_sources")
dbDisconnect(myDB)
query_result = get_disease_data()
query_result$date = as.Date(query_result$date)
# add auxilary columns to query_result
source_ind = match(query_result$source_key, data_sources$source_key)
query_result$cadence = data_sources$cadence[source_ind]
# add year, month, week, columns
query_result = Date2CadLabel(query_result=query_result)

predsci/DICE documentation built on Aug. 9, 2019, 9:41 a.m.