dtQuarter

Purpose

Extracts the quarter from a date/time variable (1-4).

Format

qtrs = dtQuarter(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 quarters from. Default = first column.

Returns:

qtrs (Tx1 vector) – The numeric quarter (1-4) of the dates in the column specified by columns.

Examples

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

// Get quarters for date column
qtrs = dtQuarter(data, "Date");

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

// Print corresponding quarters
"Quarters:";
head(qtrs);
tail(qtrs);

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

 Quarters:
         1
         1
         1
         1
         1

         4
         4
         4
         4
         4

See also

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