dtDayofMonth#

Purpose#

Extracts the day of the month component from a date/time variable as a decimal number (1-31).

Format#

dom = dtDayofMonth(X[, column])#
Parameters:
  • X (TxK dataframe) – Data with metadata.

  • column (Scalar or string) – Optional, name or index of the date variable in X to get days of the months from.

Returns:

dom (Tx1 vector) – The day of the month of the dates in the column specified by column.

Examples#

// Load data
fname = getGAUSSHome("examples/yellowstone.csv");
data = loadd(fname);

// Get day of the month for date column
dom = dtDayofMonth(data, "Date");

// Print first and last five dates
head(data[., "Date"]);
tail(data[., "Date"]);

// Print corresponding months
"Day of Month:"
head(dom);
tail(dom);

The code above prints the following table:

        Date
  2016/01/01
  2015/01/01
  2014/01/01
  2013/01/01
  2012/01/01

        Date
  1990/12/01
  1989/12/01
  1988/12/01
  1987/12/01
  1986/12/01

Day of Month:

           1
           1
           1
           1
           1

           1
           1
           1
           1
           1