dtMonth

Purpose

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

Format

months = dtMonth(X[, column])

Parameters:

• X (TxK dataframe) – Data with metadata.

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

Returns:

months (Tx1 vector) – The numeric month (1-12) of the dates in the column specified by column.

Examples

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

// Get months for date column
months = dtMonth(data, "Date");

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

// Print corresponding months
"Months:"
head(months);
tail(months);

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

   Months:
         1
         1
         1
         1
         1

        12
        12
        12
        12
        12

See also

Functions dtDayofWeek(), dtDayofMonth(), dtDayofYear(), dtQuarter(), dtYear()