{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Date Range and Period Frequency Key"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "<table border=\"1\" class=\"dataframe\">\n",
    "  <thead>\n",
    "    <tr style=\"text-align: right;\">\n",
    "      <th>Date Offset</th>\n",
    "      <th>Frequency String</th>\n",
    "      <th>Description</th>\n",
    "    </tr>\n",
    "  </thead>\n",
    "  <tbody>\n",
    "    <tr>\n",
    "      <td>DateOffset</td>\n",
    "      <td>None</td>\n",
    "      <td>Generic offset class, defaults to 1 calendar day</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>BDay or BusinessDay</td>\n",
    "      <td>'B'</td>\n",
    "      <td>business day (weekday)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>CDay or CustomBusinessDay</td>\n",
    "      <td>'C'</td>\n",
    "      <td>custom business day</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>Week</td>\n",
    "      <td>'W'</td>\n",
    "      <td>one week, optionally anchored on a day of the ...</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>WeekOfMonth</td>\n",
    "      <td>'WOM'</td>\n",
    "      <td>the x-th day of the y-th week of each month</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>LastWeekOfMonth</td>\n",
    "      <td>'LWOM'</td>\n",
    "      <td>the x-th day of the last week of each month</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>MonthEnd</td>\n",
    "      <td>'M'</td>\n",
    "      <td>calendar month end</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>MonthBegin</td>\n",
    "      <td>'MS'</td>\n",
    "      <td>calendar month begin</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>BMonthEnd or BusinessMonthEnd</td>\n",
    "      <td>'BM'</td>\n",
    "      <td>business month end</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>BMonthBegin or BusinessMonthBegin</td>\n",
    "      <td>'BMS'</td>\n",
    "      <td>business month begin</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>CBMonthEnd or CustomBusinessMonthEnd</td>\n",
    "      <td>'CBM'</td>\n",
    "      <td>custom business month end</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>CBMonthBegin or CustomBusinessMonthBegin</td>\n",
    "      <td>'CBMS'</td>\n",
    "      <td>custom business month begin</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>SemiMonthEnd</td>\n",
    "      <td>'SM'</td>\n",
    "      <td>15th (or other day_of_month) and calendar mont...</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>SemiMonthBegin</td>\n",
    "      <td>'SMS'</td>\n",
    "      <td>15th (or other day_of_month) and calendar mont...</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>QuarterEnd</td>\n",
    "      <td>'Q'</td>\n",
    "      <td>calendar quarter end</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>QuarterBegin</td>\n",
    "      <td>'QS'</td>\n",
    "      <td>calendar quarter begin</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>BQuarterEnd</td>\n",
    "      <td>'BQ</td>\n",
    "      <td>business quarter end</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>BQuarterBegin</td>\n",
    "      <td>'BQS'</td>\n",
    "      <td>business quarter begin</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>FY5253Quarter</td>\n",
    "      <td>'REQ'</td>\n",
    "      <td>retail (aka 52-53 week) quarter</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>YearEnd</td>\n",
    "      <td>'A'</td>\n",
    "      <td>calendar year end</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>YearBegin</td>\n",
    "      <td>'AS' or 'BYS'</td>\n",
    "      <td>calendar year begin</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>BYearEnd</td>\n",
    "      <td>'BA'</td>\n",
    "      <td>business year end</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>BYearBegin</td>\n",
    "      <td>'BAS'</td>\n",
    "      <td>business year begin</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>FY5253</td>\n",
    "      <td>'RE'</td>\n",
    "      <td>retail (aka 52-53 week) year</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>Easter</td>\n",
    "      <td>None</td>\n",
    "      <td>Easter holiday</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>BusinessHour</td>\n",
    "      <td>'BH'</td>\n",
    "      <td>business hour</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>CustomBusinessHour</td>\n",
    "      <td>'CBH'</td>\n",
    "      <td>custom business hour</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>Day</td>\n",
    "      <td>'D'</td>\n",
    "      <td>one absolute day</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>Hour</td>\n",
    "      <td>'H'</td>\n",
    "      <td>one hour</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>Minute</td>\n",
    "      <td>'T' or 'min'</td>\n",
    "      <td>one minute</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>Second</td>\n",
    "      <td>'S'</td>\n",
    "      <td>one second</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>Milli</td>\n",
    "      <td>'L' or 'ms'</td>\n",
    "      <td>one millisecond</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>Micro</td>\n",
    "      <td>'U' or 'us'</td>\n",
    "      <td>one microsecond</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>Nano</td>\n",
    "      <td>'N'</td>\n",
    "      <td>one nanosecond</td>\n",
    "    </tr>\n",
    "  </tbody>\n",
    "</table>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Anchored Offsets"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<table border=\"1\" class=\"dataframe\">\n",
    "  <thead>\n",
    "    <tr style=\"text-align: right;\">\n",
    "      <th>Alias</th>\n",
    "      <th>Description</th>\n",
    "    </tr>\n",
    "  </thead>\n",
    "  <tbody>\n",
    "    <tr>\n",
    "      <td>W-SUN</td>\n",
    "      <td>weekly frequency (Sundays). Same as ‘W’</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>W-MON</td>\n",
    "      <td>weekly frequency (Mondays)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>W-TUE</td>\n",
    "      <td>weekly frequency (Tuesdays)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>W-WED</td>\n",
    "      <td>weekly frequency (Wednesdays)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>W-THU</td>\n",
    "      <td>weekly frequency (Thursdays)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>W-FRI</td>\n",
    "      <td>weekly frequency (Fridays)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>W-SAT</td>\n",
    "      <td>weekly frequency (Saturdays)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)Q(S)-DEC</td>\n",
    "      <td>quarterly frequency, year ends in December. Sa...</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)Q(S)-JAN</td>\n",
    "      <td>quarterly frequency, year ends in January</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)Q(S)-FEB</td>\n",
    "      <td>quarterly frequency, year ends in February</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)Q(S)-MAR</td>\n",
    "      <td>quarterly frequency, year ends in March</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)Q(S)-APR</td>\n",
    "      <td>quarterly frequency, year ends in April</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)Q(S)-MAY</td>\n",
    "      <td>quarterly frequency, year ends in May</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)Q(S)-JUN</td>\n",
    "      <td>quarterly frequency, year ends in June</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)Q(S)-JUL</td>\n",
    "      <td>quarterly frequency, year ends in July</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)Q(S)-AUG</td>\n",
    "      <td>quarterly frequency, year ends in August</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)Q(S)-SEP</td>\n",
    "      <td>quarterly frequency, year ends in September</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)Q(S)-OCT</td>\n",
    "      <td>quarterly frequency, year ends in October</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)Q(S)-NOV</td>\n",
    "      <td>quarterly frequency, year ends in November</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)A(S)-DEC</td>\n",
    "      <td>annual frequency, anchored end of December. Sa...</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)A(S)-JAN</td>\n",
    "      <td>annual frequency, anchored end of January</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)A(S)-FEB</td>\n",
    "      <td>annual frequency, anchored end of February</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)A(S)-MAR</td>\n",
    "      <td>annual frequency, anchored end of March</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)A(S)-APR</td>\n",
    "      <td>annual frequency, anchored end of April</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)A(S)-MAY</td>\n",
    "      <td>annual frequency, anchored end of May</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)A(S)-JUN</td>\n",
    "      <td>annual frequency, anchored end of June</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)A(S)-JUL</td>\n",
    "      <td>annual frequency, anchored end of July</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)A(S)-AUG</td>\n",
    "      <td>annual frequency, anchored end of August</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)A(S)-SEP</td>\n",
    "      <td>annual frequency, anchored end of September</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)A(S)-OCT</td>\n",
    "      <td>annual frequency, anchored end of October</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <td>(B)A(S)-NOV</td>\n",
    "      <td>annual frequency, anchored end of November</td>\n",
    "    </tr>\n",
    "  </tbody>\n",
    "</table>"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
