dtWeek

Purpose

Extracts the week component from a date/time variable as a decimal number (0-53). Monday is first day of the week.

Format

weeks = dtWeek(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 weeks from. Default = first column.
Returns:

weeks (Tx1 vector) – The week of the dates in the column specified by column.

Examples

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

// Get weeks for date column
weeks = dtWeek(data, "Date");

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

// Print corresponding weeks
"Weeks:"
head(weeks);
tail(weeks);

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

    Weeks:

         0
         0
         0
         0
         0

        48
        48
        48
        48
        48

Remarks

  • Days before the first Monday of the year will be returned as week 0.

See also

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