| Type: | Package |
| Title: | Modify Dates to ISO Standard ("International Organization for Standardization") |
| Version: | 0.2.0 |
| URL: | https://github.com/andzoluk |
| Language: | en-US |
| Description: | Transfer any date type to ISO standard. Package recognizes dates in given data frame and transform to ISO format. Only one date format can be applied within one data frame column. |
| License: | MIT + file LICENSE |
| Encoding: | UTF-8 |
| Imports: | stringr, lubridate |
| Suggests: | testthat (≥ 3.0.0) |
| Config/testthat/edition: | 3 |
| RoxygenNote: | 7.2.3 |
| NeedsCompilation: | no |
| Packaged: | 2023-11-30 23:25:38 UTC; Andrzejewski |
| Author: | Lukasz Andrzejewski [aut, cre] |
| Maintainer: | Lukasz Andrzejewski <lukasz.coding@gmail.com> |
| Repository: | CRAN |
| Date/Publication: | 2023-12-01 10:10:05 UTC |
Get TRUE if date format is dmy
Description
Get TRUE if date format is dmy
Usage
choose_dmy_format(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, TRUE if most probable date format is DMY
Author(s)
Lukasz Andrzejewski
Get TRUE if date format is dym
Description
Get TRUE if date format is dym
Usage
choose_dym_format(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, TRUE if most probable date format is DYM
Author(s)
Lukasz Andrzejewski
Get TRUE if date format is mdy
Description
Get TRUE if date format is mdy
Usage
choose_mdy_format(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, TRUE if most probable date format is MDY
Author(s)
Lukasz Andrzejewski
Get TRUE if date format is myd
Description
Get TRUE if date format is myd
Usage
choose_myd_format(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, TRUE if most probable date format is MYD
Author(s)
Lukasz Andrzejewski
Get TRUE if date format is ydm
Description
Get TRUE if date format is ydm
Usage
choose_ydm_format(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, TRUE if most probable date format is YDM
Author(s)
Lukasz Andrzejewski
Get TRUE if date format is ymd
Description
Get TRUE if date format is ymd
Usage
choose_ymd_format(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, TRUE if most probable date format is YMD
Author(s)
Lukasz Andrzejewski
Function recognize date variables and modify them to ISO standard ("International Organization for Standardization")
Description
Function recognize date variables and modify them to ISO standard ("International Organization for Standardization")
Usage
dfiso(df)
Arguments
df |
data frame or variable/s, for example data.frame(date=c("12-Mar-2021","01-Jan-2023")) |
Value
dates formatted to ISO standard (yyyy-mm-dd)
Author(s)
Lukasz Andrzejewski
Examples
# data frame with different formatted dates
dfiso(data.frame(date1=c("13-02-2022","13/Feb/2022","13-Feb-2022")))
Find DMY dates only
Description
Find DMY dates only
Usage
find_dmy_date_format(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, TRUE if date format is DMY
Author(s)
Lukasz Andrzejewski
Find DYM dates only
Description
Find DYM dates only
Usage
find_dym_date_format(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, TRUE if date format is DYM
Author(s)
Lukasz Andrzejewski
Find MDY dates only
Description
Find MDY dates only
Usage
find_mdy_date_format(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, TRUE if date format is MDY
Author(s)
Lukasz Andrzejewski
Find MYD dates only
Description
Find MYD dates only
Usage
find_myd_date_format(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, TRUE if date format is MYD
Author(s)
Lukasz Andrzejewski
Return TRUE if data frame column or vector contains date
Description
Return TRUE if data frame column or vector contains date
Usage
find_only_dates(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, return TRUE if number of characters is higher than 5, contains digits and special characters or month names
Author(s)
Lukasz Andrzejewski
Find Unknown date, defined as UN or UNK
Description
Find Unknown date, defined as UN or UNK
Usage
find_unknow_date(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, TRUE if "un" character is found but not "jun"
Author(s)
Lukasz Andrzejewski
Find YDM dates only
Description
Find YDM dates only
Usage
find_ydm_date_format(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, TRUE if date format is YDM
Author(s)
Lukasz Andrzejewski
Find YMD dates only
Description
Find YMD dates only
Usage
find_ymd_date_format(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
logical vector, TRUE if date format is YMD
Author(s)
Lukasz Andrzejewski
Replace full month name by abbreviated month name
Description
Replace full month name by abbreviated month name
Usage
get_abbreviated_month_name(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
vector, if any full length month name, then replace by abbreviated month name
Author(s)
Lukasz Andrzejewski
Get vector with full name of months separated by vertical bar
Description
Get vector with full name of months separated by vertical bar
Usage
get_full_name_months_sep_by_vertical_bar()
Value
full names and abbreviations of months separated by vertical bar
Author(s)
Lukasz Andrzejewski
Score each of date format ymd, ydm, dmy, dym, mdy, myd and return only the highest score
Description
Score each of date format ymd, ydm, dmy, dym, mdy, myd and return only the highest score
Usage
get_max_score_within_data_formats(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
return score of most probable date format
Author(s)
Lukasz Andrzejewski
List month names: full names and abbreviated names in lower case
Description
List month names: full names and abbreviated names in lower case
Usage
get_months()
Value
full names and abbreviations of months
Author(s)
Lukasz Andrzejewski
List month names: full names in lower case
Description
List month names: full names in lower case
Usage
get_months_full_names()
Value
full names of months
Author(s)
Lukasz Andrzejewski
Get vector with full and abbreviated name of months separated by vertical bar
Description
Get vector with full and abbreviated name of months separated by vertical bar
Usage
get_months_sep_by_vertical_bar()
Value
full names and abbreviations of months separated by vertical bar
Author(s)
Lukasz Andrzejewski
Function to find number of symbols in date
Description
Function to find number of symbols in date
Usage
get_number_of_symbols_in_string(df_column, symbol = "T")
Arguments
df_column |
data frame date column or vector with dates |
symbol |
symbol that needs to be found, by default "T" |
Value
number of found symbols
Author(s)
Lukasz Andrzejewski
function return observations with up to 12 characters
Description
function return observations with up to 12 characters
Usage
get_up_to_12_char(df_column)
Arguments
df_column |
data frame column or vector to extract observarions up to 12 characters |
Value
return up to 12 characters
Author(s)
Lukasz Andrzejewski
Function return special characters and months separated by vertical bars
Description
Function return special characters and months separated by vertical bars
Usage
has_dash_or_slash_or_white_space_characters_or_months_separated_by_vertical_bar(
)
Value
special characters and months: "-|\/|\w+\s+|january|february|march|april|may|june|july|august|september|october|november|december|jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec"
Author(s)
Lukasz Andrzejewski
Function return special characters separated by vertical bars
Description
Function return special characters separated by vertical bars
Usage
has_dash_or_slash_or_white_space_characters_separated_by_vertical_bar(
special_characters = c("-", "\\/", "\\w+\\s+")
)
Arguments
special_characters |
by default dash, slash, white space characters |
Value
special characters: "-|\/|\w+\s+"
Author(s)
Lukasz Andrzejewski
Additional step for YMD date type
Description
Additional step for YMD date type
Usage
prepare_date(df_column)
Arguments
df_column |
data frame date column or vector with dates |
Value
output up to 12 characters, remove whitespace from start and end of string, keep characters from the left site of letter "T"
Author(s)
Lukasz Andrzejewski
Function remove symbols
Description
Function remove symbols
Usage
remove_no_date_characters(df_column, symbols = "[;:+]")
Arguments
df_column |
data frame column or vector from which symbols need to be removed |
symbols |
by default ; : + |
Value
by default delete semicolon, colon and plus sign from vector or data frame
Author(s)
Lukasz Andrzejewski
Get substring of date to eliminate unnecessary part
Description
Get substring of date to eliminate unnecessary part
Usage
remove_unnecessary_part_of_date(df_column, symbol = "T")
Arguments
df_column |
date column or vector with dates |
symbol |
symbol that needs to be found, by default "T" |
Value
substring of date from position 1 to position where last "symbol" is located
Author(s)
Lukasz Andrzejewski
transform date vector to date vector in ISO standard ("International Organization for Standardization")
Description
transform date vector to date vector in ISO standard ("International Organization for Standardization")
Usage
viso(df_column)
Arguments
df_column |
vector or string |
Value
dates formatted to ISO standard (yyyy-mm-dd)
Author(s)
Lukasz Andrzejewski
Examples
#day month year vector
viso(c("12Mar2022","21Feb2022"))
#day month year vector in different formats
viso(c("12Mar2022","21-02-2022"))
#month year day vector
viso(c("Mar-2022-12","Feb-2022-21"))