mongify_date: Format dates for importing to Go.Data

In WorldHealthOrganization/godataR: Connecting R with the Go.Data Application

Format dates for importing to Go.Data

Description

This function uses a date parser from the lubridate package to convert dates to the required format for importing dates into the Go.Data mongodb database, which is YYYY-MM-DDThh:mm:ss.000z where:

• Y = year

• M = month

• D = day

• h = hours

• m = minutes

• s = seconds

• Remaining characters are milliseconds with mongodb suffix (z)

Input dates must already have 2 digits for the day and month and either 2 or 4 digits for the year (names or abbreviations for months are not accepted), however the day, month and year can be in any order and with any separator.

The user can identify the format of the date column they wish to convert as one of:

• undefined (default) = tries ymd first, then dmy, then mdy

• dmy = date first, then month, then year e.g. 25-09-2022

• mdy = month first, then date, then year e.g. 09-25-2022

• ymd = year first, then month, then date (ISO standard) e.g. 2022-09-25

Identifying the order of the date elements will help to distinguish between, for example 08 May 2022 (08/05/2022) and 05 August 2022 (05/08/2022) or any other date combinations where the month and date are not easily to differentiate based on the size of the number. Note that only one date element order can be selected (i.e. all dates in the column to be converted must be in the same format).

Dates with and without a time-stamp are both accepted. Dates which do include a time stamp must include hours, minutes and seconds in the format HH:mm:ss

Usage

mongify_date(dates, dateformat = "undefined")

Arguments

dates	Vector of dates to convert
dateformat	Indicate format of dates to convert ("dmy", "mdy" or "ymd")

Value

Returns character vector of dates converted to Go.Data / mongodb format

Author(s)

Amy Mikhail, [e-mail]

Examples

# Create dummy dataframe with dates to convert:
mydf <- data.frame(id = c(1,2), mydates = c("08/01/2022", "08/31/2022"))

# Add a new column with the converted dates:
mydf$converted <- mongify_date(dates = mydf$mydates, dateformat = "mdy")

# View the result:
mydf

WorldHealthOrganization/godataR documentation built on May 21, 2023, 11:30 a.m.