This dataset contains calendar-related information used for time-based analysis in the Contonso dataset. It includes various representations of date-related attributes, such as year, quarter, month, and day, along with indicators for working days. It is useful for time-series analysis and aggregating data by different time periods.
calendarA data frame with 17 columns:
Date The actual date for the record.
double Unique identifier for the date (often in YYYYMMDD format).
double The year part of the date.
character The year and quarter (e.g., "2025 Q1").
double The numerical representation of the quarter (e.g., 1, 2, 3, 4).
character The quarter of the year (e.g., "Q1", "Q2").
character The year and month (e.g., "2025-03").
character A shortened version of year and month (e.g., "2025 Mar").
double The numerical representation of the year-month (e.g., 202503 for March 2025).
character The month name (e.g., "March").
character The abbreviated month name (e.g., "Mar").
double The numerical representation of the month (e.g., 3 for March).
character The full name of the day of the week (e.g., "Monday").
character The abbreviated day of the week (e.g., "Mon").
double The numerical representation of the day of the week (e.g., 1 for Monday).
double Indicator of whether the date is a working day (1 for working day, 0 for non-working day).
double A numerical indicator for working day (e.g., 1 for working day, 0 for non-working day).