prediction.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "from prophet import Prophet"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>From Date</th>\n",
       "      <th>To Date</th>\n",
       "      <th>Remote Station ID</th>\n",
       "      <th>Station</th>\n",
       "      <th>Full Fare</th>\n",
       "      <th>Senior Citizen / Disabled</th>\n",
       "      <th>7 Day ADA Farecard Access System Unlimited</th>\n",
       "      <th>30 Day ADA Farecard Access System Unlimited</th>\n",
       "      <th>Joint Rail Road Ticket</th>\n",
       "      <th>7 Day Unlimited</th>\n",
       "      <th>...</th>\n",
       "      <th>LIB Special Senior</th>\n",
       "      <th>Rail Road Unlimited No Trade</th>\n",
       "      <th>Transit Check Metrocard Annual Metrocard</th>\n",
       "      <th>Mail and Ride Easy Pay Express</th>\n",
       "      <th>Mail and Ride Unlimited</th>\n",
       "      <th>Path 2 Trip</th>\n",
       "      <th>Airtran Full Fare</th>\n",
       "      <th>Airtran 30 Day</th>\n",
       "      <th>Airtran 10 Trip</th>\n",
       "      <th>Airtran Monthly</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>08/06/2021</td>\n",
       "      <td>07/31/2021</td>\n",
       "      <td>R001</td>\n",
       "      <td>WHITEHALL STREET</td>\n",
       "      <td>27946</td>\n",
       "      <td>1824</td>\n",
       "      <td>242</td>\n",
       "      <td>376</td>\n",
       "      <td>8</td>\n",
       "      <td>11958</td>\n",
       "      <td>...</td>\n",
       "      <td>539</td>\n",
       "      <td>162</td>\n",
       "      <td>0</td>\n",
       "      <td>717</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>327</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>08/06/2021</td>\n",
       "      <td>07/31/2021</td>\n",
       "      <td>R003</td>\n",
       "      <td>CYPRESS HILLS</td>\n",
       "      <td>1323</td>\n",
       "      <td>134</td>\n",
       "      <td>3</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>817</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>70</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>08/06/2021</td>\n",
       "      <td>07/31/2021</td>\n",
       "      <td>R004</td>\n",
       "      <td>75TH STREET &amp; ELDERTS LANE</td>\n",
       "      <td>4241</td>\n",
       "      <td>321</td>\n",
       "      <td>15</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>2029</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>301</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>08/06/2021</td>\n",
       "      <td>07/31/2021</td>\n",
       "      <td>R005</td>\n",
       "      <td>85TH STREET &amp; FOREST PKWAY</td>\n",
       "      <td>4418</td>\n",
       "      <td>389</td>\n",
       "      <td>29</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>1999</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>08/06/2021</td>\n",
       "      <td>07/31/2021</td>\n",
       "      <td>R006</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>4193</td>\n",
       "      <td>315</td>\n",
       "      <td>27</td>\n",
       "      <td>55</td>\n",
       "      <td>0</td>\n",
       "      <td>2946</td>\n",
       "      <td>...</td>\n",
       "      <td>36</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>148</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    From Date     To Date Remote Station ID                     Station  \\\n",
       "0  08/06/2021  07/31/2021              R001            WHITEHALL STREET   \n",
       "1  08/06/2021  07/31/2021              R003               CYPRESS HILLS   \n",
       "2  08/06/2021  07/31/2021              R004  75TH STREET & ELDERTS LANE   \n",
       "3  08/06/2021  07/31/2021              R005  85TH STREET & FOREST PKWAY   \n",
       "4  08/06/2021  07/31/2021              R006         WOODHAVEN BOULEVARD   \n",
       "\n",
       "   Full Fare  Senior Citizen / Disabled  \\\n",
       "0      27946                       1824   \n",
       "1       1323                        134   \n",
       "2       4241                        321   \n",
       "3       4418                        389   \n",
       "4       4193                        315   \n",
       "\n",
       "   7 Day ADA Farecard Access System Unlimited  \\\n",
       "0                                         242   \n",
       "1                                           3   \n",
       "2                                          15   \n",
       "3                                          29   \n",
       "4                                          27   \n",
       "\n",
       "   30 Day ADA Farecard Access System Unlimited  Joint Rail Road Ticket  \\\n",
       "0                                          376                       8   \n",
       "1                                           13                       0   \n",
       "2                                           43                       0   \n",
       "3                                           30                       1   \n",
       "4                                           55                       0   \n",
       "\n",
       "   7 Day Unlimited  ...  LIB Special Senior  Rail Road Unlimited No Trade  \\\n",
       "0            11958  ...                 539                           162   \n",
       "1              817  ...                  12                            19   \n",
       "2             2029  ...                  14                            31   \n",
       "3             1999  ...                  13                            25   \n",
       "4             2946  ...                  36                            14   \n",
       "\n",
       "   Transit Check Metrocard Annual Metrocard  Mail and Ride Easy Pay Express  \\\n",
       "0                                         0                             717   \n",
       "1                                         0                              11   \n",
       "2                                         0                              28   \n",
       "3                                         0                              40   \n",
       "4                                         0                              25   \n",
       "\n",
       "   Mail and Ride Unlimited  Path 2 Trip  Airtran Full Fare  Airtran 30 Day  \\\n",
       "0                        0            0                  0             327   \n",
       "1                        0            0                  0              70   \n",
       "2                        0            0                  0             301   \n",
       "3                        0            0                  0             111   \n",
       "4                        0            0                  0             148   \n",
       "\n",
       "   Airtran 10 Trip  Airtran Monthly  \n",
       "0                0                0  \n",
       "1                0                0  \n",
       "2                0                0  \n",
       "3                0                0  \n",
       "4                0                0  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"Fare_Card_History_for_Metropolitan_Transportation_Authority__MTA___Beginning_2010.csv\")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 250874 entries, 0 to 250873\n",
      "Data columns (total 26 columns):\n",
      " #   Column                                       Non-Null Count   Dtype  \n",
      "---  ------                                       --------------   -----  \n",
      " 0   From Date                                    250874 non-null  object \n",
      " 1   To Date                                      250874 non-null  object \n",
      " 2   Remote Station ID                            250874 non-null  object \n",
      " 3   Station                                      250874 non-null  object \n",
      " 4   Full Fare                                    250874 non-null  int64  \n",
      " 5   Senior Citizen / Disabled                    250874 non-null  int64  \n",
      " 6   7 Day ADA Farecard Access System Unlimited   250874 non-null  int64  \n",
      " 7   30 Day ADA Farecard Access System Unlimited  250874 non-null  int64  \n",
      " 8   Joint Rail Road Ticket                       250874 non-null  int64  \n",
      " 9   7 Day Unlimited                              250874 non-null  int64  \n",
      " 10  30 Day Unlimited                             250874 non-null  int64  \n",
      " 11  14 Day Reduced Fare Media Unlimited          210076 non-null  float64\n",
      " 12  1 Day Unlimited                              210076 non-null  float64\n",
      " 13  14 Day Unlimited                             210076 non-null  float64\n",
      " 14  7 Day Express Bus Pass                       250874 non-null  int64  \n",
      " 15  Transit Check Metrocard                      250874 non-null  int64  \n",
      " 16  LIB Special Senior                           250874 non-null  int64  \n",
      " 17  Rail Road Unlimited No Trade                 250874 non-null  int64  \n",
      " 18  Transit Check Metrocard Annual Metrocard     250874 non-null  int64  \n",
      " 19  Mail and Ride Easy Pay Express               250874 non-null  int64  \n",
      " 20  Mail and Ride Unlimited                      250874 non-null  int64  \n",
      " 21  Path 2 Trip                                  250874 non-null  int64  \n",
      " 22  Airtran Full Fare                            250874 non-null  int64  \n",
      " 23  Airtran 30 Day                               250874 non-null  int64  \n",
      " 24  Airtran 10 Trip                              250874 non-null  int64  \n",
      " 25  Airtran Monthly                              250874 non-null  int64  \n",
      "dtypes: float64(3), int64(19), object(4)\n",
      "memory usage: 49.8+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>From Date</th>\n",
       "      <th>To Date</th>\n",
       "      <th>Remote Station ID</th>\n",
       "      <th>Station</th>\n",
       "      <th>Full Fare</th>\n",
       "      <th>Senior Citizen / Disabled</th>\n",
       "      <th>7 Day ADA Farecard Access System Unlimited</th>\n",
       "      <th>30 Day ADA Farecard Access System Unlimited</th>\n",
       "      <th>Joint Rail Road Ticket</th>\n",
       "      <th>7 Day Unlimited</th>\n",
       "      <th>...</th>\n",
       "      <th>LIB Special Senior</th>\n",
       "      <th>Rail Road Unlimited No Trade</th>\n",
       "      <th>Transit Check Metrocard Annual Metrocard</th>\n",
       "      <th>Mail and Ride Easy Pay Express</th>\n",
       "      <th>Mail and Ride Unlimited</th>\n",
       "      <th>Path 2 Trip</th>\n",
       "      <th>Airtran Full Fare</th>\n",
       "      <th>Airtran 30 Day</th>\n",
       "      <th>Airtran 10 Trip</th>\n",
       "      <th>Airtran Monthly</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>250873</th>\n",
       "      <td>2010-05-29</td>\n",
       "      <td>2010-06-04</td>\n",
       "      <td>R552</td>\n",
       "      <td>PA-PATH JOURNAL SQUARE</td>\n",
       "      <td>50892</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>144</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250556</th>\n",
       "      <td>2010-05-29</td>\n",
       "      <td>2010-06-04</td>\n",
       "      <td>R155</td>\n",
       "      <td>KINGSBRIDGE RD-196TH ST</td>\n",
       "      <td>15268</td>\n",
       "      <td>503</td>\n",
       "      <td>111</td>\n",
       "      <td>231</td>\n",
       "      <td>6</td>\n",
       "      <td>8071</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>1243</td>\n",
       "      <td>18</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250557</th>\n",
       "      <td>2010-05-29</td>\n",
       "      <td>2010-06-04</td>\n",
       "      <td>R156</td>\n",
       "      <td>BEDFORD PARK BLVD-203RD ST</td>\n",
       "      <td>11519</td>\n",
       "      <td>533</td>\n",
       "      <td>103</td>\n",
       "      <td>227</td>\n",
       "      <td>1</td>\n",
       "      <td>5400</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1278</td>\n",
       "      <td>16</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250558</th>\n",
       "      <td>2010-05-29</td>\n",
       "      <td>2010-06-04</td>\n",
       "      <td>R157</td>\n",
       "      <td>205TH ST-BAINBRIDGE AVE</td>\n",
       "      <td>15870</td>\n",
       "      <td>529</td>\n",
       "      <td>114</td>\n",
       "      <td>291</td>\n",
       "      <td>2</td>\n",
       "      <td>7867</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>1375</td>\n",
       "      <td>18</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250559</th>\n",
       "      <td>2010-05-29</td>\n",
       "      <td>2010-06-04</td>\n",
       "      <td>R158</td>\n",
       "      <td>UNION TURNPIKE-KEW GARDENS</td>\n",
       "      <td>43481</td>\n",
       "      <td>2523</td>\n",
       "      <td>281</td>\n",
       "      <td>1295</td>\n",
       "      <td>46</td>\n",
       "      <td>20319</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>157</td>\n",
       "      <td>4723</td>\n",
       "      <td>156</td>\n",
       "      <td>110</td>\n",
       "      <td>0</td>\n",
       "      <td>1356</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>2021-08-06</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>R329</td>\n",
       "      <td>MORRIS PARK-PAULDING AVENUE</td>\n",
       "      <td>3162</td>\n",
       "      <td>199</td>\n",
       "      <td>9</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>806</td>\n",
       "      <td>...</td>\n",
       "      <td>33</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>2021-08-06</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>R330</td>\n",
       "      <td>3RD AVENUE-14TH STREET</td>\n",
       "      <td>6467</td>\n",
       "      <td>395</td>\n",
       "      <td>36</td>\n",
       "      <td>95</td>\n",
       "      <td>2</td>\n",
       "      <td>2619</td>\n",
       "      <td>...</td>\n",
       "      <td>153</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "      <td>106</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>2021-08-06</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>R331</td>\n",
       "      <td>155TH STREET-ST NICHOLAS AV</td>\n",
       "      <td>2537</td>\n",
       "      <td>307</td>\n",
       "      <td>26</td>\n",
       "      <td>67</td>\n",
       "      <td>0</td>\n",
       "      <td>1605</td>\n",
       "      <td>...</td>\n",
       "      <td>32</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>2021-08-06</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>R319</td>\n",
       "      <td>63RD STREET-LEXINGTON AVE</td>\n",
       "      <td>18205</td>\n",
       "      <td>1993</td>\n",
       "      <td>124</td>\n",
       "      <td>234</td>\n",
       "      <td>1</td>\n",
       "      <td>6645</td>\n",
       "      <td>...</td>\n",
       "      <td>525</td>\n",
       "      <td>212</td>\n",
       "      <td>0</td>\n",
       "      <td>206</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>74</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-08-06</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>R001</td>\n",
       "      <td>WHITEHALL STREET</td>\n",
       "      <td>27946</td>\n",
       "      <td>1824</td>\n",
       "      <td>242</td>\n",
       "      <td>376</td>\n",
       "      <td>8</td>\n",
       "      <td>11958</td>\n",
       "      <td>...</td>\n",
       "      <td>539</td>\n",
       "      <td>162</td>\n",
       "      <td>0</td>\n",
       "      <td>717</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>327</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>250874 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        From Date    To Date Remote Station ID                      Station  \\\n",
       "250873 2010-05-29 2010-06-04              R552       PA-PATH JOURNAL SQUARE   \n",
       "250556 2010-05-29 2010-06-04              R155      KINGSBRIDGE RD-196TH ST   \n",
       "250557 2010-05-29 2010-06-04              R156   BEDFORD PARK BLVD-203RD ST   \n",
       "250558 2010-05-29 2010-06-04              R157      205TH ST-BAINBRIDGE AVE   \n",
       "250559 2010-05-29 2010-06-04              R158   UNION TURNPIKE-KEW GARDENS   \n",
       "...           ...        ...               ...                          ...   \n",
       "318    2021-08-06 2021-07-31              R329  MORRIS PARK-PAULDING AVENUE   \n",
       "319    2021-08-06 2021-07-31              R330       3RD AVENUE-14TH STREET   \n",
       "320    2021-08-06 2021-07-31              R331  155TH STREET-ST NICHOLAS AV   \n",
       "308    2021-08-06 2021-07-31              R319    63RD STREET-LEXINGTON AVE   \n",
       "0      2021-08-06 2021-07-31              R001             WHITEHALL STREET   \n",
       "\n",
       "        Full Fare  Senior Citizen / Disabled  \\\n",
       "250873      50892                          0   \n",
       "250556      15268                        503   \n",
       "250557      11519                        533   \n",
       "250558      15870                        529   \n",
       "250559      43481                       2523   \n",
       "...           ...                        ...   \n",
       "318          3162                        199   \n",
       "319          6467                        395   \n",
       "320          2537                        307   \n",
       "308         18205                       1993   \n",
       "0           27946                       1824   \n",
       "\n",
       "        7 Day ADA Farecard Access System Unlimited  \\\n",
       "250873                                           0   \n",
       "250556                                         111   \n",
       "250557                                         103   \n",
       "250558                                         114   \n",
       "250559                                         281   \n",
       "...                                            ...   \n",
       "318                                              9   \n",
       "319                                             36   \n",
       "320                                             26   \n",
       "308                                            124   \n",
       "0                                              242   \n",
       "\n",
       "        30 Day ADA Farecard Access System Unlimited  Joint Rail Road Ticket  \\\n",
       "250873                                            0                       3   \n",
       "250556                                          231                       6   \n",
       "250557                                          227                       1   \n",
       "250558                                          291                       2   \n",
       "250559                                         1295                      46   \n",
       "...                                             ...                     ...   \n",
       "318                                              32                       0   \n",
       "319                                              95                       2   \n",
       "320                                              67                       0   \n",
       "308                                             234                       1   \n",
       "0                                               376                       8   \n",
       "\n",
       "        7 Day Unlimited  ...  LIB Special Senior  \\\n",
       "250873                0  ...                   0   \n",
       "250556             8071  ...                   0   \n",
       "250557             5400  ...                   0   \n",
       "250558             7867  ...                   0   \n",
       "250559            20319  ...                   1   \n",
       "...                 ...  ...                 ...   \n",
       "318                 806  ...                  33   \n",
       "319                2619  ...                 153   \n",
       "320                1605  ...                  32   \n",
       "308                6645  ...                 525   \n",
       "0                 11958  ...                 539   \n",
       "\n",
       "        Rail Road Unlimited No Trade  \\\n",
       "250873                             0   \n",
       "250556                            15   \n",
       "250557                             4   \n",
       "250558                            17   \n",
       "250559                           157   \n",
       "...                              ...   \n",
       "318                               46   \n",
       "319                               65   \n",
       "320                               31   \n",
       "308                              212   \n",
       "0                                162   \n",
       "\n",
       "        Transit Check Metrocard Annual Metrocard  \\\n",
       "250873                                         0   \n",
       "250556                                      1243   \n",
       "250557                                      1278   \n",
       "250558                                      1375   \n",
       "250559                                      4723   \n",
       "...                                          ...   \n",
       "318                                            0   \n",
       "319                                            0   \n",
       "320                                            0   \n",
       "308                                            0   \n",
       "0                                              0   \n",
       "\n",
       "        Mail and Ride Easy Pay Express  Mail and Ride Unlimited  Path 2 Trip  \\\n",
       "250873                               0                        0            0   \n",
       "250556                              18                        7            0   \n",
       "250557                              16                        6            0   \n",
       "250558                              18                       31            0   \n",
       "250559                             156                      110            0   \n",
       "...                                ...                      ...          ...   \n",
       "318                                 14                        0            0   \n",
       "319                                106                        0            0   \n",
       "320                                 47                        0            0   \n",
       "308                                206                        0            0   \n",
       "0                                  717                        0            0   \n",
       "\n",
       "        Airtran Full Fare  Airtran 30 Day  Airtran 10 Trip  Airtran Monthly  \n",
       "250873                144               0                0                0  \n",
       "250556                 29               0                0                0  \n",
       "250557                 24               0                0                0  \n",
       "250558                 95               0                0                0  \n",
       "250559               1356               0                0                0  \n",
       "...                   ...             ...              ...              ...  \n",
       "318                     0              68                0                0  \n",
       "319                     0              35                0                2  \n",
       "320                     0              86                0                0  \n",
       "308                     0              74                0                0  \n",
       "0                       0             327                0                0  \n",
       "\n",
       "[250874 rows x 26 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['From Date'] = pd.to_datetime(df['From Date'], format='%m/%d/%Y')\n",
    "df['To Date'] = pd.to_datetime(df['To Date'], format='%m/%d/%Y')\n",
    "df.sort_values(by=[\"To Date\"], inplace = True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['PA-PATH JOURNAL SQUARE', 'KINGSBRIDGE RD-196TH ST',\n",
       "       'BEDFORD PARK BLVD-203RD ST', '205TH ST-BAINBRIDGE AVE',\n",
       "       'UNION TURNPIKE-KEW GARDENS', '116TH STREET-COLUMBIA',\n",
       "       'ASTOR PLACE-4 AVENUE', 'KINGSBRIDGE RD-JEROME AVE',\n",
       "       'ELDER AVE-WESTCHESTER AVE', '14TH STREET-6TH AVENUE',\n",
       "       '66TH STREET-BROADWAY', 'TOMPKINSVILLE', '79TH STREET-BROADWAY',\n",
       "       '86TH STREET-BROADWAY', '96TH STREET-BROADWAY',\n",
       "       '137TH STREET-BROADWAY', '14TH STREET-UNION SQUARE',\n",
       "       '7TH AVENUE-PARK PLACE', 'BRIGHTON BEACH-CONEY ISLAND',\n",
       "       '207TH STREET-BROADWAY', '181ST STREET-FT WASH AVE',\n",
       "       '8TH AVENUE-14TH STREET', '33RD STREET-PARK AVENUE',\n",
       "       '68TH STREET-HUNTER COLLEGE', '77TH STREET-LEXINGTON AVE',\n",
       "       '86TH STREET-LEXINGTON AVE', 'TREMONT AVE-179TH ST',\n",
       "       '103RD STREET-LEXINGTON AVE', 'UTICA AVE-STUYVESANT AVE',\n",
       "       'STILLWELL AVE-CONEY ISLAND', '175TH STREET/FT WASHINGTON',\n",
       "       'JAY ST-METROTECH', 'SUTPHIN BLVD-HILLSIDE AVE',\n",
       "       'BERGEN STREET-SMITH STREET', 'KINGS HIGHWAY-MCDONALD AVE',\n",
       "       '23RD STREET-PARK AVE SOUTH', '125TH STREET-LEXINGTON AVE',\n",
       "       'MOSHOLU PARKWAY-JEROME AVE', 'HUNTERS PT AVE-49TH AVE',\n",
       "       'NEWKIRK AVE-NOSTRAND AVE', 'SHEEPSHEAD BAY ROAD',\n",
       "       'MYRTLE AVE-GATES AVENUE', 'WEST 4TH ST-WASHINGTON SQ',\n",
       "       'CANAL STREET-LISPENARD ST', 'QUEENS PLAZA-JACKSON AVE',\n",
       "       '71ST AVE-CONTINENTAL AVE', 'ESSEX ST-DELANCEY ST',\n",
       "       '28TH STREET-PARK AVE SOUTH', '96TH STREET-LEXINGTON AVE',\n",
       "       '241TH ST-WHITE PLAINS RD', 'HUNTS PT AVE-SOUTHERN BLVD',\n",
       "       '61ST STREET-ROOSEVELT AVE', 'PARKSIDE AVE-OCEAN AVE',\n",
       "       'NEWKIRK AVE-EAST 16TH ST', 'AVENUE U-EAST 16TH STREET',\n",
       "       'ROCKAWAY PKWY-GLENWOOD RD', 'BROAD STREET & WALL STREET',\n",
       "       '110TH STREET-LEXINGTON AVE', 'BEDFORD PARK BLVD-JEROME AV',\n",
       "       'BAY RIDGE AVE-4TH AVENUE', '77TH STREET-4TH AVENUE',\n",
       "       '86TH STREET-4TH AVENUE', 'BAY RIDGE - 95TH STREET',\n",
       "       'HOYT ST-SCHERMERHORN ST', 'ELMHURST AVE-BROADWAY',\n",
       "       '67TH AVENUE-QUEENS BLVD', 'CARROLL ST-PRESIDENT ST',\n",
       "       '167TH STREET-RIVER AVENUE', '177TH STREET-PARKCHESTER',\n",
       "       '46TH ST-BLISS ST', 'CLARK STREET-HENRY STREET',\n",
       "       'HOYT STREET-HOYT STREET', 'GUN HILL ROAD-SEYMOUR',\n",
       "       'RECTOR STREET-CHURCH STREET', 'AVENUE J-EAST 16TH STREET',\n",
       "       'AVENUE M-EAST 16TH STREET', 'NECK ROAD-EAST 16TH STREET',\n",
       "       'UNION STREET-4TH AVENUE', '45TH STREET-4TH AVENUE',\n",
       "       '53RD STREET-4TH AVENUE', '50TH STREET-NEW UTRECHT AVE',\n",
       "       'BEDFORD AVE-NORTH 7TH ST', 'DEKALB AVE-WYCKOFF AVE',\n",
       "       '182ND STREET-183RD STREET', '59TH STREET-4TH AVENUE',\n",
       "       '116TH STREET-LEXINGTON AVE', 'KINGS HIGHWAY-EAST 16TH ST',\n",
       "       'STERLING ST-NOSTRAND AVE', 'CORTELYOU RD-EAST 16TH ST',\n",
       "       'DYCKMAN STREET-BROADWAY', '86TH ST-CENTRAL PARK WEST',\n",
       "       '81ST STREET-MUSEUM', '50TH STREET-8TH AVENUE',\n",
       "       'CHRISTOPHER ST-SHERIDAN SQ', '23RD STREET-7TH AVENUE',\n",
       "       '103RD STREET-BROADWAY', '110TH STREET-BROADWAY',\n",
       "       '157TH STREET-BROADWAY', 'BLEECKER ST-LAFAYETTE ST',\n",
       "       '161ST STREET-YANKEE STADIUM', 'PROSPECT PARK-EMPIRE BLVD',\n",
       "       '36TH STREET-4TH AVENUE', 'NOSTRAND AVE-FULTON ST',\n",
       "       'KINGSTON AVE-THROOP AVE', 'EUCLID AVE-PITKIN AVE',\n",
       "       'WOODHAVEN BLVD-QUEENS BLVD', '63RD DRIVE-REGO PARK',\n",
       "       '23RD STREET-6TH AVENUE', 'CHURCH AVE-MCDONALD AVE',\n",
       "       '149TH ST-GRAND CONCOURSE', '125TH STREET-LENOX AVENUE',\n",
       "       '135TH STREET-LENOX AVENUE', '103RD ST-ROOSEVELT AVE',\n",
       "       'BEVERLY RD-NOSTRAND AVE', 'STEINWAY ST-BROADWAY',\n",
       "       'KINGSTON AVE/EASTERN PKWY', '90TH STREET/ELMHURST AVENUE',\n",
       "       '34TH STREET & 7TH AVENUE', '42ND STREET/TIMES SQUARE',\n",
       "       '125TH STREET & BROADWAY', '168TH STREET & BROADWAY',\n",
       "       'DYCKMAN STREET', '207TH STREET', '215TH STREET', '225TH STREET',\n",
       "       '231ST STREET', 'BOWLING GREEN & BATTERY PL',\n",
       "       'BOWLING GREEN & BROADWAY', 'WALL STREET', 'BROOKLYN BRIDGE',\n",
       "       '42ND STREET & GRAND CENTRAL', '42ND STREET & 3RD AVENUE',\n",
       "       '51ST STREET & LEXINGTON AVE', '59TH STREET & LEXINGTON AVE',\n",
       "       'WOODLAWN ROAD', '149TH STREET & 3RD AVENUE',\n",
       "       'FIFTH AVENUE & 42ND STREET', 'MAIN STREET', 'CHAMBERS STREET',\n",
       "       'NEVINS STREET', 'PARK PLACE', 'WHITEHALL STREET',\n",
       "       'FULTON ST & BROADWAY NASSAU', 'CYPRESS HILLS',\n",
       "       '75TH STREET & ELDERTS LANE', '85TH STREET & FOREST PKWAY',\n",
       "       'WOODHAVEN BOULEVARD', '104TH STREET', '111TH STREET',\n",
       "       '121ST STREET', '42ND STREET & 8TH AVENUE',\n",
       "       '34TH STREET & 8TH AVENUE', 'FULTON STREET', 'FIFTH AVENUE',\n",
       "       'LEXINGTON AVENUE', 'ROOSEVELT AVE/JACKSON HTS',\n",
       "       '179TH STREET & HILLSIDE AVE', '47-50 STREETS/ROCKEFELLER',\n",
       "       '42ND STREET & 6TH AVENUE', '34TH STREET & 6TH AVENUE',\n",
       "       'SUTPHIN BOULEVARD', 'JAMAICA CENTER-PARSONS BLVD',\n",
       "       'FULTON & WILLIAM STREETS', 'FRANKLIN AVE/EASTERN PKWY',\n",
       "       'ATLANTIC AVENUE', 'GRAND ARMY PLAZA',\n",
       "       'JUNCTION BLVD-ROOSEVELT AVE', 'CHURCH AVENUE', 'DEKALB AVENUE',\n",
       "       'METROPOLITAN AVENUE', '145TH STREET', '125TH STREET',\n",
       "       'BROADWAY-EAST NEW YORK', '167TH ST-GRAND CONCOURSE',\n",
       "       '14TH STREET & 7TH AVENUE', 'CASTLE HILL AVENUE',\n",
       "       'WESTCHESTER SQUARE', 'BOROUGH HALL - COURT STREET',\n",
       "       'CHURCH AVENUE & NOSTRAND AV', 'FLATBUSH AVE & NOSTRAND AV',\n",
       "       '23RD STREET & 8TH AVENUE', 'FORDHAM RD/GRAND CONCOURSE',\n",
       "       'SEVENTH AVENUE & WEST 53RD', 'PARSONS BLVD & HILLSIDE AV',\n",
       "       '169TH STREET & HILLSIDE AVE', '50TH STREET & 7TH AVENUE',\n",
       "       '242ND STREET & BROADWAY', 'CANAL STREET',\n",
       "       'FORDHAM ROAD & JEROME AVE', 'MORRISON AVE & WESTCHESTER',\n",
       "       'QUEENSBORO PLAZA', '82ND STREET-JACKSON HEIGHTS', 'BERGEN STREET',\n",
       "       'DITMARS BLVD & 31ST STREET', '30TH AVENUE & 31ST STREET',\n",
       "       'EASTERN PARKWAY', 'NOSTRAND AVENUE', 'UTICA AVENUE',\n",
       "       'SUTTER AVENUE', 'SARATOGA AVENUE', 'ROCKWAY AVENUE',\n",
       "       'JUNIUS STREET', 'PENNSYLVANIA AVENUE', 'VAN SICLEN AVENUE',\n",
       "       'NEW LOTS AVENUE', 'ST GEORGE TERMINAL',\n",
       "       'FIFTH AVENUE & 60TH STREET', '57TH STREET & 7TH AVENUE',\n",
       "       '49TH STREET & 7TH AVENUE', '28TH STREET & BROADWAY',\n",
       "       '23RD STREET & 5TH AVENUE', '59TH STREET/COLUMBUS CIRCLE',\n",
       "       '8TH STREET & BROADWAY', 'PRINCE STREET & BROADWAY', 'CITY HALL',\n",
       "       'CORTLANDT STREET', '39TH AVENUE & 31ST STREET',\n",
       "       '36TH AVENUE & 31ST STREET', 'BROADWAY & 31ST STREET',\n",
       "       'ASTORIA BLVD & 31ST STREET', 'GREENPOINT AVE', 'PA-PATH GROVE ST',\n",
       "       '15TH ST-PROSPECT PARK WEST', 'FORT HAMILTON PARKWAY-62ND',\n",
       "       '18TH AVENUE-62ND STREET', '20TH AVENUE-62ND STREET',\n",
       "       'BAY PARKWAY-66TH STREET', 'KINGS HIGHWAY-WEST 7TH ST',\n",
       "       'AVENUE U-WEST 7TH STREET', '86TH STREET-AVENUE V',\n",
       "       'NEW UTRECHT AVENUE-62ND ST', '25TH AVENUE-86TH STREET',\n",
       "       'BAY 50TH STREET-STILLWELL', 'CENTRAL AVE-MYRTLE AVE',\n",
       "       'SENECA AVENUE-PALMETTO ST', 'FOREST AVENUE-PUTNAM AVENUE',\n",
       "       'FRESH POND ROAD-68TH AVENUE', 'JACKSON AVENUE-WESTCHESTER',\n",
       "       'PROSPECT AVENUE-WESTCHESTER', 'INTERVALE 163RD STREET',\n",
       "       'SIMPSON ST-WESTCHESTER AVE', 'FREEMAN ST-SOUTHERN BLVD',\n",
       "       'PARK PLACE-FRANKLIN AVENUE', 'BOTANIC GARDEN-FRANKLIN AVE',\n",
       "       'KNICKERBOCKER AVE-MYRTLE AV', 'HOWARD BEACH-159TH AVE',\n",
       "       'BROAD CHANNEL-NOEL ROAD', 'HOLLAND-BEACH 90TH STREET',\n",
       "       '8TH AVENUE-62ND STREET', 'PLAYLAND-BEACH 98TH STREET',\n",
       "       'BRONX PARK EAST', 'EAST TREMONT AVENUE-178 ST',\n",
       "       'ALLERTON AV-WHITE PLAINS RD', 'BURKE AVE-WHITE PLAINS ROAD',\n",
       "       'GUNHILL RD-WHITE PLAINS RD', '219TH ST-WHITE PLAINS ROAD',\n",
       "       '225TH ST-WHITE PLAINS ROAD', '233RD ST-WHITE PLAINS ROAD',\n",
       "       '9TH AVENUE-39TH STREET', 'FORT HAMILTON PKWY-45TH ST',\n",
       "       '71ST STREET-NEW UTRECHT AVE', '79TH STREET-17TH AVENUE',\n",
       "       '18TH AVENUE-86TH STREET', '20TH AVENUE-86TH STREET',\n",
       "       'BAY PARKWAY-86TH STREET', 'NEW LOTS AV-VAN SINDEREN AV',\n",
       "       'EAST 105TH ST-FARRAGUT ROAD', 'FLUSHING AVE-BROADWAY',\n",
       "       'MYRTLE AVENUE-BROADWAY', 'KOSCIUSKO STREET-BROADWAY',\n",
       "       'GATES AVENUE-BROADWAY', 'HALSEY STREET-BROADWAY',\n",
       "       'GRANT AVNUE-PITKIN AVENUE', 'HUDSON STREET-78TH STREET',\n",
       "       'BOYD STREET-88TH STREET', 'ROCKAWAY BLVD-LIBERTY AVE',\n",
       "       '174TH STREET-SOUTHERN BLVD', 'EAST 180TH ST-MORRIS PARK',\n",
       "       'PELHAM PKWY-WHITE PLAINS RD', 'SEASIDE BEACH-105TH STREET',\n",
       "       'DITMAS AVE-MCDONALD AVE', 'LONGWOOD AVE-SOUTHERN BLVD',\n",
       "       'WINTHROP ST-NOSTRAND AVE', '72ND STREET & BROADWAY',\n",
       "       'PROSPECT AVE-4TH AVE', '25TH STREET-4TH AVENUE',\n",
       "       'HOYT STREET-FULTON STREET', 'ORCHARD BEACH',\n",
       "       'MARCY AVENUE-BROADWAY', 'BROADWAY LAFAYETTE-BLEECKER',\n",
       "       'CANAL STREET-BROADWAY', 'CANAL ST-LAFAYETTE ST EAST',\n",
       "       'AIRTRAIN @ HOWARD BEACH', 'AIRTRAIN JAMAICA CENTER 1',\n",
       "       'PA-PATH WORLD TRADE CNTR', 'PA-PATH THIRTY THIRD ST',\n",
       "       'PA-PATH TWENTY THIRD ST', 'PA-PATH EXCHANGE PLACE',\n",
       "       'PA-PATH HARRISON', 'PA-PATH 14TH STREET',\n",
       "       'PA-PATH PAVONIA/NEWPORT', 'PA-PATH 9TH STREET',\n",
       "       'PA-PATH CHRISTOPHER ST', 'PA-PATH NEWARK', 'PA-PATH HOBOKEN',\n",
       "       'EAST 149TH ST-SOUTHERN BLVD', 'ROCKAWAY PARK-BEACH 116TH',\n",
       "       'EAST 143RD ST-SOUTHERN BLVD', 'BROOK AVENUE-138TH STREET',\n",
       "       'AVENUE I-MCDONALD AVENUE', 'MCDONALD AVE-22ND AVE',\n",
       "       'AVENUE N-MCDONALD AVENUE', 'AVENUE P-MCDONALD AVENUE',\n",
       "       'AVENUE U-MCDONALD AVENUE', 'NEPTUNE AVE-MCDONALD AVENUE',\n",
       "       'MIDDLETOWN ROAD-WESTCHESTER', 'BUHRE AVE-WESTCHESTER AVE',\n",
       "       'PELHAM BAY PARK-BRUCKNER BL', 'PELHAM PKWY-ESPLANADE',\n",
       "       'DYRE AVENUE-LIGHT STREET', 'CHAUNCEY STREET-ROCKAWAY AV',\n",
       "       'ALABAMA AVENUE-FULTON ST', 'VAN SICLEN AVENUE-FULTON ST',\n",
       "       'CLEVELAND STREET-FULTON ST', 'NORWOOD AVENUE-FULTON ST',\n",
       "       'CRESCENT STREET-FULTON ST', 'RALPH AVENUE-FULTON STREET',\n",
       "       'ROCKAWAY AVE-HOPKINSON AVE', 'LIBERTY AVE-PENNSYLVANIA AV',\n",
       "       'VAN SICLEN AVE-PITKIN AVE', 'SHEPERD AVE-PITKIN AVE',\n",
       "       '170TH STREET-GRAND CONC.', '238TH ST-WHITE PLAINS ROAD',\n",
       "       '138TH STREET-3RD AVE', 'CYPRESS AVENUE-138TH STREET',\n",
       "       '21ST STREET-JACKSON AVENUE', 'GRAND ST-CHRISTIE ST',\n",
       "       'BEACH 25TH STREET-WAVECREST', '23RD STREET-ELY AVENUE',\n",
       "       '28TH STREET-7TH AVENUE', '145TH STREET-BROADWAY',\n",
       "       '191ST STREET-ST NICHOLAS AV', '183RD STREET-JEROME AVENUE',\n",
       "       'JACKSON AVENUE-VERNON BLVD', 'PRESIDENT ST-NOSTRAND AVE',\n",
       "       'JEFFERSON STREET-WYCKOFF AV', '190TH STREET-OVERLOOK TERR',\n",
       "       '72ND STREET-CENTRAL PK WEST', 'SPRING STREET-6TH AVENUE',\n",
       "       'LAFAYETTE AVENUE-FULTON ST', 'CLINTON AVENUE-FULTON ST',\n",
       "       'MOTT AVENUE-BEACH 22ND ST', 'MYRTLE AVENUE-MARCY AVENUE',\n",
       "       'CLASSON AVENUE-LAFAYETTE AV', '7TH AVENUE-9TH STREET',\n",
       "       'FT HAMILTON PKY-GREENWOOD', 'HOUSTON STREET-VARICK ST',\n",
       "       '33RD STREET-QUEENS BLVD', 'BAYCHESTER AVE-TILLOTSON',\n",
       "       '34TH STREET - PENN STATION', 'MORGAN AVENUE-HARRISON PL',\n",
       "       'WILSON AVENUE-MOFFAT STREET', 'SMITH STREET-9TH STREET',\n",
       "       '163RD ST & AMSTERDAM AVE', 'BEDFORD AVENUE-NOSTRAND AVE',\n",
       "       '46TH STREET-BROADWAY', '18TH AVE-MCDONALD AVE',\n",
       "       '170TH STREET-JEROME AVENUE', 'BURNSIDE AVE-JEROME AVE',\n",
       "       'ST LAWRENCE AVE-WEST AVE', 'PROSPECT AVENUE-4TH AVENUE',\n",
       "       '55TH ST-NEW UTRECHT AVE', '1ST AVENUE-14TH STREET',\n",
       "       'GRAHAM AVE-METROPOLITAN AVE', 'GRAND ST-BUSHWICK AVE',\n",
       "       '96TH ST-CENTRAL PARK WEST', 'HIGH ST-CADMAN PLAZA WEST',\n",
       "       '174TH-175TH ST-GRAND CONCOU', 'GRAND AVE-QUEENS BOULEVARD',\n",
       "       'VAN WYCK BLVD-MAIN STREET', 'NASSAU AVE-MANHATTAN AVE',\n",
       "       'EAST BROADWAY-MADISON ST', '4TH AVENUE-9TH STREET',\n",
       "       'ROOSEVELT ISLAND', '181ST STREET-ST NICHOLAS AV',\n",
       "       '40TH STREET-LOWERY STREET', 'BEVERLEY ROAD -EAST 15TH ST',\n",
       "       'AVENUE H-EAST 16TH STREET', 'OCEAN PKWAY-BRIGHTON BCH AV',\n",
       "       'MONTROSE AVENUE', 'HALSEY STREET-WYCKOFF AVE',\n",
       "       'METROPOLITAN AVE-LORIMER ST', 'FRANKLIN AVENUE-FULTON ST',\n",
       "       'AVENUE X-MCDONALD AVENUE', 'BROADWAY - UNION AVENUE',\n",
       "       '135TH STREET-ST NICHOLAS AV', '116TH STREET-8TH AVENUE',\n",
       "       '110TH STREET-8TH AVENUE', 'GASTON AVENUE-BEACH 67TH ST',\n",
       "       'STRAITON AVE-BEACH 60TH ST', 'FRANK AVENUE-BEACH 44TH ST',\n",
       "       'EDGEMERE-BEACH 36TH STREET', '36TH STREET-NORTHERN BLVD',\n",
       "       '65TH STREET-BROADWAY', '75TH AVENUE-QUEENS BLVD',\n",
       "       'VAN WYCK BLVD-METROPOLITAN', 'FRANKLIN STREET-WEST BWAY',\n",
       "       '145TH STREET-LENOX AVENUE', '148TH STREET-LENOX AVENUE',\n",
       "       '45TH ROAD-COURT HOUSE SQ', '69TH STREET-ROOSEVELT AVE',\n",
       "       'ATLANTIC AV-VAN SINDEREN AV', 'SUTTER AVE-VAN SINDEREN AVE',\n",
       "       'LIVONIA AVE-VAN SINDEREN AV', 'HEWES STREET-BROADWAY',\n",
       "       'LORIMER STREET-BROADWAY', '104TH STREET-LIBERTY AVENUE',\n",
       "       '109TH STREET-LIBERTY AVENUE', 'LEFFERTS BLVD-LIBERTY AVE',\n",
       "       'NORTHERN BLVD-BROADWAY', '155TH STREET-ST NICHOLAS AV',\n",
       "       '3RD AVENUE-14TH STREET', 'NORTH CONDUIT AVE-COHANCEY',\n",
       "       'WILLETS PT BLVD-ROOSEVELT', 'MORRIS PARK-PAULDING AVENUE',\n",
       "       'YORK STREET-JAY STREET', '57TH STREET-6TH AVENUE',\n",
       "       '21ST STREET-QUEENSBRIDGE', 'RECTOR STREET-GREENWICH ST',\n",
       "       '238TH STREET-BROADWAY', '138TH ST-GRAND CONCOURSE',\n",
       "       'MT EDEN AVENUE-JEROME AVE', '176TH STREET-JEROME AVENUE',\n",
       "       '111TH STREET-ROOSEVELT AVE', 'BOWERY STREET-DELANCEY ST',\n",
       "       'WEST 6TH STREET-SURF AVENUE', 'BUSHWICK AVENUE-ABERDEEN ST',\n",
       "       '2ND AVENUE-HOUSTON STREET', '155TH STREET-8TH AVENUE',\n",
       "       '103RD ST-CENTRAL PARK WEST', '52ND STREET-ROOSEVELT AVE',\n",
       "       'ZEREGA AVE-WESTCHESTER AVE', '116TH STREET-LENOX AVENUE',\n",
       "       'SPRING STREET-LAFAYETTE ST', '111TH STREET-LENOX AVENUE',\n",
       "       'CANAL STREET-VARICK STREET', '63RD STREET-LEXINGTON AVE',\n",
       "       'FULTON STREET-LAFAYETTE AV', 'LAFAYETTE AV-WASHINGTON AV',\n",
       "       'FLUSHING AVENUE-MARCY AVE', '18TH STREET-7TH AVENUE',\n",
       "       'WHITLOCK AVE-WESTCHESTER AV', 'SOUTH FERRY',\n",
       "       'RI TRAMWAY (ROOSEVELT)', 'RI TRAMWAY (MANHATTAN)',\n",
       "       'AQUEDUCT RACE TRACK', 'BROADWAY NASSAU STREET',\n",
       "       '241ST ST-WHITE PLAINS RD', 'ROCKAWAY AVENUE',\n",
       "       'KOSCIUSZKO STREET-BROADWAY', 'GRANT AVENUE-PITKIN AVENUE',\n",
       "       'SHEPHERD AVE-PITKIN AVE', 'METROCARD VAN 1', 'COURT SQ',\n",
       "       'COURT SQ-23 ST', 'NEWKIRK PLAZA', 'MTABC - COLLEGE POINT DEPOT',\n",
       "       'BARCLAYS CENTER', 'HEMPSTEAD-LIB CUST SERVICE', 'LGA AIRPORT CTB',\n",
       "       '34TH STREET - HUDSON YARDS', '96TH STREET - 2 AVENUE',\n",
       "       '72ND STREET - 2 AVENUE', '86TH STREET - 2 AVENUE',\n",
       "       'SBS-BX12 @ LIVINGSTON PLAZA', 'SBS-M34 @ LIVINGSTON PLAZA',\n",
       "       'SBS-BX41 @ LIVINGSTON PLAZA', 'SBS-B44 @ LIVINGSTON PLAZA',\n",
       "       'SBS-M60 @ LIVINGSTON PLAZA', 'SBS-M86 @ LIVINGSTON PLAZA',\n",
       "       'MTABC - EASTCHESTER 2', 'SBS-B46 @ LIVINGSTON PLAZA',\n",
       "       'SBS-Q44 @ LIVINGSTON PLAZA', 'SBS-M23 @ LIVINGSTON PLAZA',\n",
       "       'SBS-M15 @ LIVINGSTON PLAZA', 'MTABC - COLLEGE POINT DEPOT2*',\n",
       "       'WESTCHESTER CMF YONKERS DEPOT', 'GRAND AVENUE DEPOT',\n",
       "       'GUNHILL DEPOT', 'YUKON DEPOT', 'CASTLETON DEPOT',\n",
       "       'QUEENS VILLAGE DEPOT', 'CASEY STENGEL DEPOT', 'JAMAICA DEPOT',\n",
       "       'FRESH POND DEPOT', 'EAST NEW YORK DEPOT', 'JACKIE GLEASON DEPOT',\n",
       "       'FLATBUSH DEPOT', 'ULMER PARK DEPOT', 'KINGSBRIDGE DEPOT',\n",
       "       'WESTCHESTER VALHALLA DEPOT', 'JACKIE GLEASON DEPOT(2)',\n",
       "       'MANHATTANVILLE DEPOT', 'CHARLESTON DEPOT', 'WEST FARMS DEPOT',\n",
       "       'MICHAEL J. QUILL DEPOT', 'TUSKEGEE AIRMEN DEPOT',\n",
       "       'MTABC - LA GUARDIA DEPOT', 'MTABC - JFK DEPOT',\n",
       "       'MTABC - FAR ROCKAWAY DEPOT', 'MTABC - SPRING CREEK DEPOT',\n",
       "       'MTABC - BAISLEY DEPOT', 'MTABC - EASTCHESTER DEPOT',\n",
       "       'MITCHELL FIELD BUS DEPOT', 'ROCKVILLE CENTER BUS DEPOT',\n",
       "       'MOTHER CLARA HALE DEPOT', 'METRO NORTH HUDSON RAIL DEPOT',\n",
       "       'SBS-M79 @ LIVINGSTON PLAZA', 'SBS-BX6 @ LIVINGSTON PLAZA',\n",
       "       'UNUSED', 'SBS-Q52/53 @ LIVINGSTON PLAZA',\n",
       "       'CORTLANDT ST-WORLD TRADE CT', 'WTC-CORTLANDT ST',\n",
       "       'SBS-B82 @ LIVINGSTON PLAZA', 'SBS-M14 @ LIVINGSTON PLAZA'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "station_names = df[\"Station\"].unique()\n",
    "station_names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "remote_station_ids = df[\"Remote Station ID\"].unique()\n",
    "remote_station_ids.sort()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "cards = [\n",
    "\n",
    "    \"Senior Citizen / Disabled\",\n",
    "    \"1 Day Unlimited\",\n",
    "    \"7 Day Unlimited\",\n",
    "    \"14 Day Unlimited\",\n",
    "    \"30 Day Unlimited\"\n",
    "]\n",
    "\n",
    "# You can access the items in the 'cards' list like this:\n",
    "# For example, to print the first card:\n",
    "# print(cards[0])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "for remote_station_id in remote_station_ids:\n",
    "    data = df[df[\"Remote Station ID\"]==remote_station_id]\n",
    "\n",
    "    data.plot(x='To Date', y=cards, figsize = (20, 20))\n",
    "    station = data.loc[data['Remote Station ID'] == remote_station_id, 'Station'].values[0]\n",
    "\n",
    "    print()\n",
    "    # Set the x-axis label\n",
    "    plt.xlabel('Date')\n",
    "\n",
    "    # Set the y-axis label\n",
    "    plt.ylabel('Count')\n",
    "\n",
    "    # Set the title of the plot\n",
    "    plt.title(f'{station} (ID: {remote_station_id})')\n",
    "\n",
    "    plt.savefig(f\"plots/{remote_station_id}\")\n",
    "    # Display the plot\n",
    "    plt.show()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# important_station_ids = [\"R012\",\"R027\", \"R032\", \"R034\", \"R044\", \"R087\", \"R159\"]\n",
    "important_station_ids = [\"R012\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "prediction_headings = [\"Date\"]\n",
    "for card in cards:\n",
    "    prediction_headings.append(card)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "23:08:08 - cmdstanpy - INFO - Chain [1] start processing\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "               ds     y\n",
      "250422 2010-06-04  6239\n",
      "249960 2010-06-11  6844\n",
      "249496 2010-06-18  6895\n",
      "249032 2010-06-25  6192\n",
      "248567 2010-07-02  6357\n",
      "...           ...   ...\n",
      "1885   2020-11-27  2095\n",
      "1416   2021-07-02  4357\n",
      "947    2021-07-03  4105\n",
      "479    2021-07-17  4638\n",
      "10     2021-07-31  4696\n",
      "\n",
      "[530 rows x 2 columns]\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "23:08:09 - cmdstanpy - INFO - Chain [1] done processing\n",
      "23:08:09 - cmdstanpy - ERROR - Chain [1] error: terminated by signal 6 Unknown error: -6\n",
      "Optimization terminated abnormally. Falling back to Newton.\n",
      "23:08:09 - cmdstanpy - INFO - Chain [1] start processing\n",
      "23:08:09 - cmdstanpy - INFO - Chain [1] done processing\n",
      "23:08:09 - cmdstanpy - ERROR - Chain [1] error: terminated by signal 6 Unknown error: -6\n"
     ]
    },
    {
     "ename": "RuntimeError",
     "evalue": "Error during optimization! Command '/Users/mohsinchougale/opt/anaconda3/lib/python3.9/site-packages/prophet/stan_model/prophet_model.bin random seed=9305 data file=/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/tmprmbsj35i/t53sdzk0.json init=/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/tmprmbsj35i/f0tzs8im.json output file=/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/tmprmbsj35i/prophet_modele8__r0td/prophet_model-20231007230809.csv method=optimize algorithm=newton iter=10000' failed: console log output:\n\ndyld[66445]: Library not loaded: '@rpath/libtbb.dylib'\n  Referenced from: '/Users/mohsinchougale/opt/anaconda3/lib/python3.9/site-packages/prophet/stan_model/prophet_model.bin'\n  Reason: tried: '/private/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/pip-install-yah6sjxz/prophet_2d5405b0e9b94d40b0602fb2101e906f/build/lib.macosx-11.1-arm64-cpython-39/prophet/stan_model/cmdstan-2.31.0/stan/lib/stan_math/lib/tbb/libtbb.dylib' (no such file), '/private/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/pip-install-yah6sjxz/prophet_2d5405b0e9b94d40b0602fb2101e906f/build/lib.macosx-11.1-arm64-cpython-39/prophet/stan_model/cmdstan-2.31.0/stan/lib/stan_math/lib/tbb/libtbb.dylib' (no such file), '/private/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/pip-install-yah6sjxz/prophet_2d5405b0e9b94d40b0602fb2101e906f/build/lib.macosx-11.1-arm64-cpython-39/prophet/stan_model/cmdstan-2.31.0/stan/lib/stan_math/lib/tbb/libtbb.dylib' (no such file), '/private/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/pip-install-yah6sjxz/prophet_2d5405b0e9b94d40b0602fb2101e906f/build/lib.macosx-11.1-arm64-cpython-39/prophet/stan_model/cmdstan-2.31.0/stan/lib/stan_math/lib/tbb/libtbb.dylib' (no such file), '/usr/local/lib/libtbb.dylib' (no such file), '/usr/lib/libtbb.dylib' (no such file)\n",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mRuntimeError\u001b[0m                              Traceback (most recent call last)",
      "File \u001b[0;32m~/opt/anaconda3/lib/python3.9/site-packages/prophet/models.py:90\u001b[0m, in \u001b[0;36mCmdStanPyBackend.fit\u001b[0;34m(self, stan_init, stan_data, **kwargs)\u001b[0m\n\u001b[1;32m     89\u001b[0m \u001b[39mtry\u001b[39;00m:\n\u001b[0;32m---> 90\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mstan_fit \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mmodel\u001b[39m.\u001b[39;49moptimize(\u001b[39m*\u001b[39;49m\u001b[39m*\u001b[39;49margs)\n\u001b[1;32m     91\u001b[0m \u001b[39mexcept\u001b[39;00m \u001b[39mRuntimeError\u001b[39;00m \u001b[39mas\u001b[39;00m e:\n\u001b[1;32m     92\u001b[0m     \u001b[39m# Fall back on Newton\u001b[39;00m\n",
      "File \u001b[0;32m~/opt/anaconda3/lib/python3.9/site-packages/cmdstanpy/model.py:696\u001b[0m, in \u001b[0;36mCmdStanModel.optimize\u001b[0;34m(self, data, seed, inits, output_dir, sig_figs, save_profile, algorithm, init_alpha, tol_obj, tol_rel_obj, tol_grad, tol_rel_grad, tol_param, history_size, iter, save_iterations, require_converged, show_console, refresh, time_fmt, timeout, jacobian)\u001b[0m\n\u001b[1;32m    695\u001b[0m     \u001b[39melse\u001b[39;00m:\n\u001b[0;32m--> 696\u001b[0m         \u001b[39mraise\u001b[39;00m \u001b[39mRuntimeError\u001b[39;00m(msg)\n\u001b[1;32m    697\u001b[0m mle \u001b[39m=\u001b[39m CmdStanMLE(runset)\n",
      "\u001b[0;31mRuntimeError\u001b[0m: Error during optimization! Command '/Users/mohsinchougale/opt/anaconda3/lib/python3.9/site-packages/prophet/stan_model/prophet_model.bin random seed=87136 data file=/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/tmprmbsj35i/93xz9wa1.json init=/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/tmprmbsj35i/8v81h7kr.json output file=/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/tmprmbsj35i/prophet_modelvddxt4yg/prophet_model-20231007230808.csv method=optimize algorithm=lbfgs iter=10000' failed: console log output:\n\ndyld[66442]: Library not loaded: '@rpath/libtbb.dylib'\n  Referenced from: '/Users/mohsinchougale/opt/anaconda3/lib/python3.9/site-packages/prophet/stan_model/prophet_model.bin'\n  Reason: tried: '/private/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/pip-install-yah6sjxz/prophet_2d5405b0e9b94d40b0602fb2101e906f/build/lib.macosx-11.1-arm64-cpython-39/prophet/stan_model/cmdstan-2.31.0/stan/lib/stan_math/lib/tbb/libtbb.dylib' (no such file), '/private/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/pip-install-yah6sjxz/prophet_2d5405b0e9b94d40b0602fb2101e906f/build/lib.macosx-11.1-arm64-cpython-39/prophet/stan_model/cmdstan-2.31.0/stan/lib/stan_math/lib/tbb/libtbb.dylib' (no such file), '/private/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/pip-install-yah6sjxz/prophet_2d5405b0e9b94d40b0602fb2101e906f/build/lib.macosx-11.1-arm64-cpython-39/prophet/stan_model/cmdstan-2.31.0/stan/lib/stan_math/lib/tbb/libtbb.dylib' (no such file), '/private/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/pip-install-yah6sjxz/prophet_2d5405b0e9b94d40b0602fb2101e906f/build/lib.macosx-11.1-arm64-cpython-39/prophet/stan_model/cmdstan-2.31.0/stan/lib/stan_math/lib/tbb/libtbb.dylib' (no such file), '/usr/local/lib/libtbb.dylib' (no such file), '/usr/lib/libtbb.dylib' (no such file)\n",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[0;31mRuntimeError\u001b[0m                              Traceback (most recent call last)",
      "\u001b[1;32m/Users/mohsinchougale/Desktop/Data/edav.ipynb Cell 11\u001b[0m line \u001b[0;36m<cell line: 1>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      <a href='vscode-notebook-cell:/Users/mohsinchougale/Desktop/Data/edav.ipynb#W6sZmlsZQ%3D%3D?line=8'>9</a>\u001b[0m train_data \u001b[39m=\u001b[39m train_data\u001b[39m.\u001b[39mrename(columns\u001b[39m=\u001b[39m{\u001b[39m\"\u001b[39m\u001b[39mTo Date\u001b[39m\u001b[39m\"\u001b[39m:\u001b[39m\"\u001b[39m\u001b[39mds\u001b[39m\u001b[39m\"\u001b[39m,card:\u001b[39m\"\u001b[39m\u001b[39my\u001b[39m\u001b[39m\"\u001b[39m})\n\u001b[1;32m     <a href='vscode-notebook-cell:/Users/mohsinchougale/Desktop/Data/edav.ipynb#W6sZmlsZQ%3D%3D?line=9'>10</a>\u001b[0m \u001b[39mprint\u001b[39m(train_data)\n\u001b[0;32m---> <a href='vscode-notebook-cell:/Users/mohsinchougale/Desktop/Data/edav.ipynb#W6sZmlsZQ%3D%3D?line=10'>11</a>\u001b[0m model\u001b[39m.\u001b[39;49mfit(train_data)\n\u001b[1;32m     <a href='vscode-notebook-cell:/Users/mohsinchougale/Desktop/Data/edav.ipynb#W6sZmlsZQ%3D%3D?line=12'>13</a>\u001b[0m future \u001b[39m=\u001b[39m model\u001b[39m.\u001b[39mmake_future_dataframe(periods \u001b[39m=\u001b[39m \u001b[39m365\u001b[39m)\n\u001b[1;32m     <a href='vscode-notebook-cell:/Users/mohsinchougale/Desktop/Data/edav.ipynb#W6sZmlsZQ%3D%3D?line=13'>14</a>\u001b[0m forecast \u001b[39m=\u001b[39m model\u001b[39m.\u001b[39mpredict(future)\n",
      "File \u001b[0;32m~/opt/anaconda3/lib/python3.9/site-packages/prophet/forecaster.py:1181\u001b[0m, in \u001b[0;36mProphet.fit\u001b[0;34m(self, df, **kwargs)\u001b[0m\n\u001b[1;32m   1179\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mparams \u001b[39m=\u001b[39m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mstan_backend\u001b[39m.\u001b[39msampling(stan_init, dat, \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mmcmc_samples, \u001b[39m*\u001b[39m\u001b[39m*\u001b[39mkwargs)\n\u001b[1;32m   1180\u001b[0m \u001b[39melse\u001b[39;00m:\n\u001b[0;32m-> 1181\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mparams \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mstan_backend\u001b[39m.\u001b[39;49mfit(stan_init, dat, \u001b[39m*\u001b[39;49m\u001b[39m*\u001b[39;49mkwargs)\n\u001b[1;32m   1183\u001b[0m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mstan_fit \u001b[39m=\u001b[39m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mstan_backend\u001b[39m.\u001b[39mstan_fit\n\u001b[1;32m   1184\u001b[0m \u001b[39m# If no changepoints were requested, replace delta with 0s\u001b[39;00m\n",
      "File \u001b[0;32m~/opt/anaconda3/lib/python3.9/site-packages/prophet/models.py:97\u001b[0m, in \u001b[0;36mCmdStanPyBackend.fit\u001b[0;34m(self, stan_init, stan_data, **kwargs)\u001b[0m\n\u001b[1;32m     95\u001b[0m     logger\u001b[39m.\u001b[39mwarning(\u001b[39m'\u001b[39m\u001b[39mOptimization terminated abnormally. Falling back to Newton.\u001b[39m\u001b[39m'\u001b[39m)\n\u001b[1;32m     96\u001b[0m     args[\u001b[39m'\u001b[39m\u001b[39malgorithm\u001b[39m\u001b[39m'\u001b[39m] \u001b[39m=\u001b[39m \u001b[39m'\u001b[39m\u001b[39mNewton\u001b[39m\u001b[39m'\u001b[39m\n\u001b[0;32m---> 97\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mstan_fit \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mmodel\u001b[39m.\u001b[39;49moptimize(\u001b[39m*\u001b[39;49m\u001b[39m*\u001b[39;49margs)\n\u001b[1;32m     98\u001b[0m params \u001b[39m=\u001b[39m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mstan_to_dict_numpy(\n\u001b[1;32m     99\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mstan_fit\u001b[39m.\u001b[39mcolumn_names, \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mstan_fit\u001b[39m.\u001b[39moptimized_params_np)\n\u001b[1;32m    100\u001b[0m \u001b[39mfor\u001b[39;00m par \u001b[39min\u001b[39;00m params:\n",
      "File \u001b[0;32m~/opt/anaconda3/lib/python3.9/site-packages/cmdstanpy/model.py:696\u001b[0m, in \u001b[0;36mCmdStanModel.optimize\u001b[0;34m(self, data, seed, inits, output_dir, sig_figs, save_profile, algorithm, init_alpha, tol_obj, tol_rel_obj, tol_grad, tol_rel_grad, tol_param, history_size, iter, save_iterations, require_converged, show_console, refresh, time_fmt, timeout, jacobian)\u001b[0m\n\u001b[1;32m    694\u001b[0m         get_logger()\u001b[39m.\u001b[39mwarning(msg)\n\u001b[1;32m    695\u001b[0m     \u001b[39melse\u001b[39;00m:\n\u001b[0;32m--> 696\u001b[0m         \u001b[39mraise\u001b[39;00m \u001b[39mRuntimeError\u001b[39;00m(msg)\n\u001b[1;32m    697\u001b[0m mle \u001b[39m=\u001b[39m CmdStanMLE(runset)\n\u001b[1;32m    698\u001b[0m \u001b[39mreturn\u001b[39;00m mle\n",
      "\u001b[0;31mRuntimeError\u001b[0m: Error during optimization! Command '/Users/mohsinchougale/opt/anaconda3/lib/python3.9/site-packages/prophet/stan_model/prophet_model.bin random seed=9305 data file=/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/tmprmbsj35i/t53sdzk0.json init=/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/tmprmbsj35i/f0tzs8im.json output file=/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/tmprmbsj35i/prophet_modele8__r0td/prophet_model-20231007230809.csv method=optimize algorithm=newton iter=10000' failed: console log output:\n\ndyld[66445]: Library not loaded: '@rpath/libtbb.dylib'\n  Referenced from: '/Users/mohsinchougale/opt/anaconda3/lib/python3.9/site-packages/prophet/stan_model/prophet_model.bin'\n  Reason: tried: '/private/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/pip-install-yah6sjxz/prophet_2d5405b0e9b94d40b0602fb2101e906f/build/lib.macosx-11.1-arm64-cpython-39/prophet/stan_model/cmdstan-2.31.0/stan/lib/stan_math/lib/tbb/libtbb.dylib' (no such file), '/private/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/pip-install-yah6sjxz/prophet_2d5405b0e9b94d40b0602fb2101e906f/build/lib.macosx-11.1-arm64-cpython-39/prophet/stan_model/cmdstan-2.31.0/stan/lib/stan_math/lib/tbb/libtbb.dylib' (no such file), '/private/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/pip-install-yah6sjxz/prophet_2d5405b0e9b94d40b0602fb2101e906f/build/lib.macosx-11.1-arm64-cpython-39/prophet/stan_model/cmdstan-2.31.0/stan/lib/stan_math/lib/tbb/libtbb.dylib' (no such file), '/private/var/folders/ng/bpyglg5d53sczcphbzldc6rh0000gn/T/pip-install-yah6sjxz/prophet_2d5405b0e9b94d40b0602fb2101e906f/build/lib.macosx-11.1-arm64-cpython-39/prophet/stan_model/cmdstan-2.31.0/stan/lib/stan_math/lib/tbb/libtbb.dylib' (no such file), '/usr/local/lib/libtbb.dylib' (no such file), '/usr/lib/libtbb.dylib' (no such file)\n"
     ]
    }
   ],
   "source": [
    "for important_station_id in important_station_ids:\n",
    "    data = df[df[\"Remote Station ID\"]==important_station_id]\n",
    "    # print(data[[\"To Date\", card]])\n",
    "    station = data.loc[data['Remote Station ID'] == important_station_id, 'Station'].values[0]\n",
    "    predictions = pd.DataFrame(columns = prediction_headings)\n",
    "    for card in cards:\n",
    "        model = Prophet().add_country_holidays(country_name='US')\n",
    "        train_data = data[[\"To Date\", card]]\n",
    "        train_data = train_data.rename(columns={\"To Date\":\"ds\",card:\"y\"})\n",
    "        print(train_data)\n",
    "        model.fit(train_data)\n",
    "\n",
    "        future = model.make_future_dataframe(periods = 365)\n",
    "        forecast = model.predict(future)\n",
    "        predictions[\"Date\"] = forecast[\"ds\"]\n",
    "        predictions[card] = forecast[\"yhat\"]\n",
    "\n",
    "\n",
    "    predictions.plot(x='Date', y=cards, figsize = (20, 20))\n",
    "    \n",
    "\n",
    "\n",
    "    # Set the x-axis label\n",
    "    plt.xlabel('Date')\n",
    "\n",
    "    # Set the y-axis label\n",
    "    plt.ylabel('Count')\n",
    "\n",
    "    # Set the title of the plot\n",
    "    plt.title(f'{station} (ID: {important_station_id})')\n",
    "\n",
    "    plt.savefig(f\"predictions/{important_station_id}\")\n",
    "    # Display the plot\n",
    "    plt.show()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}