Weather_Notebook_20180713.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>tripduration</th>\n",
       "      <th>starttime</th>\n",
       "      <th>stoptime</th>\n",
       "      <th>start station id</th>\n",
       "      <th>start station name</th>\n",
       "      <th>start station latitude</th>\n",
       "      <th>start station longitude</th>\n",
       "      <th>end station id</th>\n",
       "      <th>end station name</th>\n",
       "      <th>end station latitude</th>\n",
       "      <th>end station longitude</th>\n",
       "      <th>bikeid</th>\n",
       "      <th>name_localizedValue0</th>\n",
       "      <th>usertype</th>\n",
       "      <th>birth year</th>\n",
       "      <th>gender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>303</td>\n",
       "      <td>2018-05-01 00:00:11</td>\n",
       "      <td>2018-05-01 00:05:15</td>\n",
       "      <td>491</td>\n",
       "      <td>E 24 St &amp; Park Ave S</td>\n",
       "      <td>40.740964</td>\n",
       "      <td>-73.986022</td>\n",
       "      <td>2003</td>\n",
       "      <td>1 Ave &amp; E 18 St</td>\n",
       "      <td>40.733812</td>\n",
       "      <td>-73.980544</td>\n",
       "      <td>32191</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>700</td>\n",
       "      <td>2018-05-01 00:00:36</td>\n",
       "      <td>2018-05-01 00:12:16</td>\n",
       "      <td>507</td>\n",
       "      <td>E 25 St &amp; 2 Ave</td>\n",
       "      <td>40.739126</td>\n",
       "      <td>-73.979738</td>\n",
       "      <td>3458</td>\n",
       "      <td>W 55 St &amp; 6 Ave</td>\n",
       "      <td>40.763094</td>\n",
       "      <td>-73.978350</td>\n",
       "      <td>29357</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>443</td>\n",
       "      <td>2018-05-01 00:00:40</td>\n",
       "      <td>2018-05-01 00:08:04</td>\n",
       "      <td>3263</td>\n",
       "      <td>Cooper Square &amp; Astor Pl</td>\n",
       "      <td>40.729515</td>\n",
       "      <td>-73.990753</td>\n",
       "      <td>546</td>\n",
       "      <td>E 30 St &amp; Park Ave S</td>\n",
       "      <td>40.744449</td>\n",
       "      <td>-73.983035</td>\n",
       "      <td>27255</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>297</td>\n",
       "      <td>2018-05-01 00:00:43</td>\n",
       "      <td>2018-05-01 00:05:41</td>\n",
       "      <td>532</td>\n",
       "      <td>S 5 Pl &amp; S 5 St</td>\n",
       "      <td>40.710451</td>\n",
       "      <td>-73.960876</td>\n",
       "      <td>3096</td>\n",
       "      <td>Union Ave &amp; N 12 St</td>\n",
       "      <td>40.719240</td>\n",
       "      <td>-73.952420</td>\n",
       "      <td>16980</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>421</td>\n",
       "      <td>2018-05-01 00:01:01</td>\n",
       "      <td>2018-05-01 00:08:02</td>\n",
       "      <td>3493</td>\n",
       "      <td>E 118 St &amp; 3 Ave</td>\n",
       "      <td>40.799139</td>\n",
       "      <td>-73.938915</td>\n",
       "      <td>3351</td>\n",
       "      <td>E 102 St &amp; 1 Ave</td>\n",
       "      <td>40.786995</td>\n",
       "      <td>-73.941648</td>\n",
       "      <td>30645</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   tripduration            starttime             stoptime  start station id  \\\n",
       "0           303  2018-05-01 00:00:11  2018-05-01 00:05:15               491   \n",
       "1           700  2018-05-01 00:00:36  2018-05-01 00:12:16               507   \n",
       "2           443  2018-05-01 00:00:40  2018-05-01 00:08:04              3263   \n",
       "3           297  2018-05-01 00:00:43  2018-05-01 00:05:41               532   \n",
       "4           421  2018-05-01 00:01:01  2018-05-01 00:08:02              3493   \n",
       "\n",
       "         start station name  start station latitude  start station longitude  \\\n",
       "0      E 24 St & Park Ave S               40.740964               -73.986022   \n",
       "1           E 25 St & 2 Ave               40.739126               -73.979738   \n",
       "2  Cooper Square & Astor Pl               40.729515               -73.990753   \n",
       "3           S 5 Pl & S 5 St               40.710451               -73.960876   \n",
       "4          E 118 St & 3 Ave               40.799139               -73.938915   \n",
       "\n",
       "   end station id      end station name  end station latitude  \\\n",
       "0            2003       1 Ave & E 18 St             40.733812   \n",
       "1            3458       W 55 St & 6 Ave             40.763094   \n",
       "2             546  E 30 St & Park Ave S             40.744449   \n",
       "3            3096   Union Ave & N 12 St             40.719240   \n",
       "4            3351      E 102 St & 1 Ave             40.786995   \n",
       "\n",
       "   end station longitude  bikeid       name_localizedValue0    usertype  \\\n",
       "0             -73.980544   32191  $25 Off Annual Membership  Subscriber   \n",
       "1             -73.978350   29357          Annual Membership  Subscriber   \n",
       "2             -73.983035   27255          Annual Membership  Subscriber   \n",
       "3             -73.952420   16980          Annual Membership  Subscriber   \n",
       "4             -73.941648   30645          Annual Membership  Subscriber   \n",
       "\n",
       "   birth year  gender  \n",
       "0      1984.0       1  \n",
       "1      1996.0       1  \n",
       "2      1969.0       1  \n",
       "3      1985.0       1  \n",
       "4      1986.0       1  "
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_bike = pd.read_csv('201805-citibike-tripdata.csv')\n",
    "data_bike.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>tripduration</th>\n",
       "      <th>starttime</th>\n",
       "      <th>stoptime</th>\n",
       "      <th>start station id</th>\n",
       "      <th>start station name</th>\n",
       "      <th>start station latitude</th>\n",
       "      <th>start station longitude</th>\n",
       "      <th>end station id</th>\n",
       "      <th>end station name</th>\n",
       "      <th>end station latitude</th>\n",
       "      <th>end station longitude</th>\n",
       "      <th>bikeid</th>\n",
       "      <th>name_localizedValue0</th>\n",
       "      <th>usertype</th>\n",
       "      <th>birth year</th>\n",
       "      <th>gender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>303</td>\n",
       "      <td>2018-05-01 00:00:11</td>\n",
       "      <td>2018-05-01 00:05:15</td>\n",
       "      <td>491</td>\n",
       "      <td>E 24 St &amp; Park Ave S</td>\n",
       "      <td>40.740964</td>\n",
       "      <td>-73.986022</td>\n",
       "      <td>2003</td>\n",
       "      <td>1 Ave &amp; E 18 St</td>\n",
       "      <td>40.733812</td>\n",
       "      <td>-73.980544</td>\n",
       "      <td>32191</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>700</td>\n",
       "      <td>2018-05-01 00:00:36</td>\n",
       "      <td>2018-05-01 00:12:16</td>\n",
       "      <td>507</td>\n",
       "      <td>E 25 St &amp; 2 Ave</td>\n",
       "      <td>40.739126</td>\n",
       "      <td>-73.979738</td>\n",
       "      <td>3458</td>\n",
       "      <td>W 55 St &amp; 6 Ave</td>\n",
       "      <td>40.763094</td>\n",
       "      <td>-73.978350</td>\n",
       "      <td>29357</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>443</td>\n",
       "      <td>2018-05-01 00:00:40</td>\n",
       "      <td>2018-05-01 00:08:04</td>\n",
       "      <td>3263</td>\n",
       "      <td>Cooper Square &amp; Astor Pl</td>\n",
       "      <td>40.729515</td>\n",
       "      <td>-73.990753</td>\n",
       "      <td>546</td>\n",
       "      <td>E 30 St &amp; Park Ave S</td>\n",
       "      <td>40.744449</td>\n",
       "      <td>-73.983035</td>\n",
       "      <td>27255</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>297</td>\n",
       "      <td>2018-05-01 00:00:43</td>\n",
       "      <td>2018-05-01 00:05:41</td>\n",
       "      <td>532</td>\n",
       "      <td>S 5 Pl &amp; S 5 St</td>\n",
       "      <td>40.710451</td>\n",
       "      <td>-73.960876</td>\n",
       "      <td>3096</td>\n",
       "      <td>Union Ave &amp; N 12 St</td>\n",
       "      <td>40.719240</td>\n",
       "      <td>-73.952420</td>\n",
       "      <td>16980</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>421</td>\n",
       "      <td>2018-05-01 00:01:01</td>\n",
       "      <td>2018-05-01 00:08:02</td>\n",
       "      <td>3493</td>\n",
       "      <td>E 118 St &amp; 3 Ave</td>\n",
       "      <td>40.799139</td>\n",
       "      <td>-73.938915</td>\n",
       "      <td>3351</td>\n",
       "      <td>E 102 St &amp; 1 Ave</td>\n",
       "      <td>40.786995</td>\n",
       "      <td>-73.941648</td>\n",
       "      <td>30645</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>68905</td>\n",
       "      <td>2018-05-01 00:01:11</td>\n",
       "      <td>2018-05-01 19:09:36</td>\n",
       "      <td>237</td>\n",
       "      <td>E 11 St &amp; 2 Ave</td>\n",
       "      <td>40.730473</td>\n",
       "      <td>-73.986724</td>\n",
       "      <td>504</td>\n",
       "      <td>1 Ave &amp; E 16 St</td>\n",
       "      <td>40.732219</td>\n",
       "      <td>-73.981656</td>\n",
       "      <td>27440</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>197</td>\n",
       "      <td>2018-05-01 00:01:17</td>\n",
       "      <td>2018-05-01 00:04:35</td>\n",
       "      <td>437</td>\n",
       "      <td>Macon St &amp; Nostrand Ave</td>\n",
       "      <td>40.680983</td>\n",
       "      <td>-73.950048</td>\n",
       "      <td>3241</td>\n",
       "      <td>Monroe St &amp; Tompkins Ave</td>\n",
       "      <td>40.686203</td>\n",
       "      <td>-73.944694</td>\n",
       "      <td>31566</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>259</td>\n",
       "      <td>2018-05-01 00:01:31</td>\n",
       "      <td>2018-05-01 00:05:50</td>\n",
       "      <td>236</td>\n",
       "      <td>St Marks Pl &amp; 2 Ave</td>\n",
       "      <td>40.728419</td>\n",
       "      <td>-73.987140</td>\n",
       "      <td>312</td>\n",
       "      <td>Allen St &amp; Stanton St</td>\n",
       "      <td>40.722055</td>\n",
       "      <td>-73.989111</td>\n",
       "      <td>29872</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>359</td>\n",
       "      <td>2018-05-01 00:01:42</td>\n",
       "      <td>2018-05-01 00:07:42</td>\n",
       "      <td>3158</td>\n",
       "      <td>W 63 St &amp; Broadway</td>\n",
       "      <td>40.771639</td>\n",
       "      <td>-73.982614</td>\n",
       "      <td>495</td>\n",
       "      <td>W 47 St &amp; 10 Ave</td>\n",
       "      <td>40.762699</td>\n",
       "      <td>-73.993012</td>\n",
       "      <td>14824</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>460</td>\n",
       "      <td>2018-05-01 00:02:03</td>\n",
       "      <td>2018-05-01 00:09:43</td>\n",
       "      <td>285</td>\n",
       "      <td>Broadway &amp; E 14 St</td>\n",
       "      <td>40.734546</td>\n",
       "      <td>-73.990741</td>\n",
       "      <td>236</td>\n",
       "      <td>St Marks Pl &amp; 2 Ave</td>\n",
       "      <td>40.728419</td>\n",
       "      <td>-73.987140</td>\n",
       "      <td>17638</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>295</td>\n",
       "      <td>2018-05-01 00:02:04</td>\n",
       "      <td>2018-05-01 00:07:00</td>\n",
       "      <td>499</td>\n",
       "      <td>Broadway &amp; W 60 St</td>\n",
       "      <td>40.769155</td>\n",
       "      <td>-73.981918</td>\n",
       "      <td>3175</td>\n",
       "      <td>W 70 St &amp; Amsterdam Ave</td>\n",
       "      <td>40.777480</td>\n",
       "      <td>-73.982886</td>\n",
       "      <td>31475</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1958.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>204</td>\n",
       "      <td>2018-05-01 00:02:17</td>\n",
       "      <td>2018-05-01 00:05:42</td>\n",
       "      <td>3146</td>\n",
       "      <td>E 81 St &amp; 3 Ave</td>\n",
       "      <td>40.775730</td>\n",
       "      <td>-73.956753</td>\n",
       "      <td>3135</td>\n",
       "      <td>E 75 St &amp; 3 Ave</td>\n",
       "      <td>40.771129</td>\n",
       "      <td>-73.957723</td>\n",
       "      <td>14886</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>589</td>\n",
       "      <td>2018-05-01 00:02:22</td>\n",
       "      <td>2018-05-01 00:12:11</td>\n",
       "      <td>462</td>\n",
       "      <td>W 22 St &amp; 10 Ave</td>\n",
       "      <td>40.746920</td>\n",
       "      <td>-74.004519</td>\n",
       "      <td>450</td>\n",
       "      <td>W 49 St &amp; 8 Ave</td>\n",
       "      <td>40.762272</td>\n",
       "      <td>-73.987882</td>\n",
       "      <td>27251</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>90</td>\n",
       "      <td>2018-05-01 00:02:30</td>\n",
       "      <td>2018-05-01 00:04:00</td>\n",
       "      <td>3325</td>\n",
       "      <td>E 95 St &amp; 3 Ave</td>\n",
       "      <td>40.784903</td>\n",
       "      <td>-73.950503</td>\n",
       "      <td>3312</td>\n",
       "      <td>1 Ave &amp; E 94 St</td>\n",
       "      <td>40.781721</td>\n",
       "      <td>-73.945940</td>\n",
       "      <td>29077</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1596</td>\n",
       "      <td>2018-05-01 00:02:47</td>\n",
       "      <td>2018-05-01 00:29:24</td>\n",
       "      <td>439</td>\n",
       "      <td>E 4 St &amp; 2 Ave</td>\n",
       "      <td>40.726281</td>\n",
       "      <td>-73.989780</td>\n",
       "      <td>3074</td>\n",
       "      <td>Montrose Ave &amp; Bushwick Ave</td>\n",
       "      <td>40.707678</td>\n",
       "      <td>-73.940162</td>\n",
       "      <td>20843</td>\n",
       "      <td>Annual Membership from Citi Bike App</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>342</td>\n",
       "      <td>2018-05-01 00:02:52</td>\n",
       "      <td>2018-05-01 00:08:34</td>\n",
       "      <td>474</td>\n",
       "      <td>5 Ave &amp; E 29 St</td>\n",
       "      <td>40.745168</td>\n",
       "      <td>-73.986831</td>\n",
       "      <td>293</td>\n",
       "      <td>Lafayette St &amp; E 8 St</td>\n",
       "      <td>40.730207</td>\n",
       "      <td>-73.991026</td>\n",
       "      <td>30253</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>905</td>\n",
       "      <td>2018-05-01 00:03:20</td>\n",
       "      <td>2018-05-01 00:18:25</td>\n",
       "      <td>3081</td>\n",
       "      <td>Graham Ave &amp; Grand St</td>\n",
       "      <td>40.711863</td>\n",
       "      <td>-73.944024</td>\n",
       "      <td>3241</td>\n",
       "      <td>Monroe St &amp; Tompkins Ave</td>\n",
       "      <td>40.686203</td>\n",
       "      <td>-73.944694</td>\n",
       "      <td>30190</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>535</td>\n",
       "      <td>2018-05-01 00:03:28</td>\n",
       "      <td>2018-05-01 00:12:23</td>\n",
       "      <td>416</td>\n",
       "      <td>Cumberland St &amp; Lafayette Ave</td>\n",
       "      <td>40.687534</td>\n",
       "      <td>-73.972652</td>\n",
       "      <td>373</td>\n",
       "      <td>Willoughby Ave &amp; Walworth St</td>\n",
       "      <td>40.693317</td>\n",
       "      <td>-73.953820</td>\n",
       "      <td>29359</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>254</td>\n",
       "      <td>2018-05-01 00:03:30</td>\n",
       "      <td>2018-05-01 00:07:44</td>\n",
       "      <td>2002</td>\n",
       "      <td>Wythe Ave &amp; Metropolitan Ave</td>\n",
       "      <td>40.716887</td>\n",
       "      <td>-73.963198</td>\n",
       "      <td>3087</td>\n",
       "      <td>Metropolitan Ave &amp; Meeker Ave</td>\n",
       "      <td>40.714133</td>\n",
       "      <td>-73.952344</td>\n",
       "      <td>20523</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>352</td>\n",
       "      <td>2018-05-01 00:03:36</td>\n",
       "      <td>2018-05-01 00:09:29</td>\n",
       "      <td>403</td>\n",
       "      <td>E 2 St &amp; 2 Ave</td>\n",
       "      <td>40.725029</td>\n",
       "      <td>-73.990697</td>\n",
       "      <td>150</td>\n",
       "      <td>E 2 St &amp; Avenue C</td>\n",
       "      <td>40.720874</td>\n",
       "      <td>-73.980858</td>\n",
       "      <td>25750</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>686</td>\n",
       "      <td>2018-05-01 00:03:41</td>\n",
       "      <td>2018-05-01 00:15:07</td>\n",
       "      <td>468</td>\n",
       "      <td>Broadway &amp; W 56 St</td>\n",
       "      <td>40.765265</td>\n",
       "      <td>-73.981923</td>\n",
       "      <td>3658</td>\n",
       "      <td>W 18 St &amp; 9 Ave</td>\n",
       "      <td>40.743534</td>\n",
       "      <td>-74.003676</td>\n",
       "      <td>32316</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1982.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>297</td>\n",
       "      <td>2018-05-01 00:03:59</td>\n",
       "      <td>2018-05-01 00:08:57</td>\n",
       "      <td>498</td>\n",
       "      <td>Broadway &amp; W 32 St</td>\n",
       "      <td>40.748549</td>\n",
       "      <td>-73.988084</td>\n",
       "      <td>527</td>\n",
       "      <td>E 33 St &amp; 2 Ave</td>\n",
       "      <td>40.744023</td>\n",
       "      <td>-73.976056</td>\n",
       "      <td>28271</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1967.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>484</td>\n",
       "      <td>2018-05-01 00:04:27</td>\n",
       "      <td>2018-05-01 00:12:32</td>\n",
       "      <td>3419</td>\n",
       "      <td>Douglass St &amp; 4 Ave</td>\n",
       "      <td>40.679279</td>\n",
       "      <td>-73.981540</td>\n",
       "      <td>3304</td>\n",
       "      <td>6 Ave &amp; 9 St</td>\n",
       "      <td>40.668127</td>\n",
       "      <td>-73.983776</td>\n",
       "      <td>19678</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1978.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1287</td>\n",
       "      <td>2018-05-01 00:05:06</td>\n",
       "      <td>2018-05-01 00:26:33</td>\n",
       "      <td>3529</td>\n",
       "      <td>Lenox Ave &amp; W 130 St</td>\n",
       "      <td>40.810792</td>\n",
       "      <td>-73.943068</td>\n",
       "      <td>3529</td>\n",
       "      <td>Lenox Ave &amp; W 130 St</td>\n",
       "      <td>40.810792</td>\n",
       "      <td>-73.943068</td>\n",
       "      <td>33068</td>\n",
       "      <td>24 Hour</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1311</td>\n",
       "      <td>2018-05-01 00:05:18</td>\n",
       "      <td>2018-05-01 00:27:09</td>\n",
       "      <td>2003</td>\n",
       "      <td>1 Ave &amp; E 18 St</td>\n",
       "      <td>40.733812</td>\n",
       "      <td>-73.980544</td>\n",
       "      <td>3140</td>\n",
       "      <td>1 Ave &amp; E 78 St</td>\n",
       "      <td>40.771404</td>\n",
       "      <td>-73.953517</td>\n",
       "      <td>24888</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>657</td>\n",
       "      <td>2018-05-01 00:05:20</td>\n",
       "      <td>2018-05-01 00:16:18</td>\n",
       "      <td>3335</td>\n",
       "      <td>Union St &amp; 4 Ave</td>\n",
       "      <td>40.677274</td>\n",
       "      <td>-73.982820</td>\n",
       "      <td>3306</td>\n",
       "      <td>10 St &amp; 7 Ave</td>\n",
       "      <td>40.666208</td>\n",
       "      <td>-73.981999</td>\n",
       "      <td>31596</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1980.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>184</td>\n",
       "      <td>2018-05-01 00:05:20</td>\n",
       "      <td>2018-05-01 00:08:25</td>\n",
       "      <td>3316</td>\n",
       "      <td>W 104 St &amp; Amsterdam Ave</td>\n",
       "      <td>40.798994</td>\n",
       "      <td>-73.966217</td>\n",
       "      <td>3323</td>\n",
       "      <td>W 106 St &amp; Central Park West</td>\n",
       "      <td>40.798186</td>\n",
       "      <td>-73.960591</td>\n",
       "      <td>17098</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1371</td>\n",
       "      <td>2018-05-01 00:05:32</td>\n",
       "      <td>2018-05-01 00:28:24</td>\n",
       "      <td>128</td>\n",
       "      <td>MacDougal St &amp; Prince St</td>\n",
       "      <td>40.727103</td>\n",
       "      <td>-74.002971</td>\n",
       "      <td>481</td>\n",
       "      <td>S 3 St &amp; Bedford Ave</td>\n",
       "      <td>40.712605</td>\n",
       "      <td>-73.962644</td>\n",
       "      <td>30618</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>940</td>\n",
       "      <td>2018-05-01 00:05:45</td>\n",
       "      <td>2018-05-01 00:21:25</td>\n",
       "      <td>518</td>\n",
       "      <td>E 39 St &amp; 2 Ave</td>\n",
       "      <td>40.747804</td>\n",
       "      <td>-73.973442</td>\n",
       "      <td>394</td>\n",
       "      <td>E 9 St &amp; Avenue C</td>\n",
       "      <td>40.725213</td>\n",
       "      <td>-73.977688</td>\n",
       "      <td>25065</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>317</td>\n",
       "      <td>2018-05-01 00:05:48</td>\n",
       "      <td>2018-05-01 00:11:05</td>\n",
       "      <td>435</td>\n",
       "      <td>W 21 St &amp; 6 Ave</td>\n",
       "      <td>40.741740</td>\n",
       "      <td>-73.994156</td>\n",
       "      <td>285</td>\n",
       "      <td>Broadway &amp; E 14 St</td>\n",
       "      <td>40.734546</td>\n",
       "      <td>-73.990741</td>\n",
       "      <td>29778</td>\n",
       "      <td>Annual Membership from Citi Bike App</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824628</th>\n",
       "      <td>717</td>\n",
       "      <td>2018-05-31 23:58:27</td>\n",
       "      <td>2018-06-01 00:10:25</td>\n",
       "      <td>3306</td>\n",
       "      <td>10 St &amp; 7 Ave</td>\n",
       "      <td>40.666208</td>\n",
       "      <td>-73.981999</td>\n",
       "      <td>3418</td>\n",
       "      <td>Plaza St West &amp; Flatbush Ave</td>\n",
       "      <td>40.675021</td>\n",
       "      <td>-73.971115</td>\n",
       "      <td>18250</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824629</th>\n",
       "      <td>166</td>\n",
       "      <td>2018-05-31 23:58:28</td>\n",
       "      <td>2018-06-01 00:01:14</td>\n",
       "      <td>3671</td>\n",
       "      <td>E 81 St &amp; 2 Ave</td>\n",
       "      <td>40.774779</td>\n",
       "      <td>-73.954275</td>\n",
       "      <td>3147</td>\n",
       "      <td>E 85 St &amp; 3 Ave</td>\n",
       "      <td>40.778012</td>\n",
       "      <td>-73.954071</td>\n",
       "      <td>32485</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824630</th>\n",
       "      <td>1206</td>\n",
       "      <td>2018-05-31 23:58:37</td>\n",
       "      <td>2018-06-01 00:18:44</td>\n",
       "      <td>3125</td>\n",
       "      <td>45 Rd &amp; 11 St</td>\n",
       "      <td>40.747086</td>\n",
       "      <td>-73.949772</td>\n",
       "      <td>460</td>\n",
       "      <td>S 4 St &amp; Wythe Ave</td>\n",
       "      <td>40.712859</td>\n",
       "      <td>-73.965903</td>\n",
       "      <td>17035</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824631</th>\n",
       "      <td>1086</td>\n",
       "      <td>2018-05-31 23:58:47</td>\n",
       "      <td>2018-06-01 00:16:54</td>\n",
       "      <td>498</td>\n",
       "      <td>Broadway &amp; W 32 St</td>\n",
       "      <td>40.748549</td>\n",
       "      <td>-73.988084</td>\n",
       "      <td>3370</td>\n",
       "      <td>E 78 St &amp; 2 Ave</td>\n",
       "      <td>40.772797</td>\n",
       "      <td>-73.955778</td>\n",
       "      <td>14553</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824632</th>\n",
       "      <td>2218</td>\n",
       "      <td>2018-05-31 23:58:48</td>\n",
       "      <td>2018-06-01 00:35:46</td>\n",
       "      <td>3125</td>\n",
       "      <td>45 Rd &amp; 11 St</td>\n",
       "      <td>40.747086</td>\n",
       "      <td>-73.949772</td>\n",
       "      <td>401</td>\n",
       "      <td>Allen St &amp; Rivington St</td>\n",
       "      <td>40.720196</td>\n",
       "      <td>-73.989978</td>\n",
       "      <td>15768</td>\n",
       "      <td>Join Citi Bike for $14.95/month</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1978.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824633</th>\n",
       "      <td>993</td>\n",
       "      <td>2018-05-31 23:58:49</td>\n",
       "      <td>2018-06-01 00:15:23</td>\n",
       "      <td>435</td>\n",
       "      <td>W 21 St &amp; 6 Ave</td>\n",
       "      <td>40.741740</td>\n",
       "      <td>-73.994156</td>\n",
       "      <td>3459</td>\n",
       "      <td>E 53 St &amp; 3 Ave</td>\n",
       "      <td>40.757632</td>\n",
       "      <td>-73.969306</td>\n",
       "      <td>26453</td>\n",
       "      <td>3 Day</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824634</th>\n",
       "      <td>429</td>\n",
       "      <td>2018-05-31 23:58:56</td>\n",
       "      <td>2018-06-01 00:06:05</td>\n",
       "      <td>3467</td>\n",
       "      <td>W Broadway &amp; Spring Street</td>\n",
       "      <td>40.724947</td>\n",
       "      <td>-74.001659</td>\n",
       "      <td>296</td>\n",
       "      <td>Division St &amp; Bowery</td>\n",
       "      <td>40.714131</td>\n",
       "      <td>-73.997047</td>\n",
       "      <td>28850</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1945.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824635</th>\n",
       "      <td>1539</td>\n",
       "      <td>2018-05-31 23:59:00</td>\n",
       "      <td>2018-06-01 00:24:39</td>\n",
       "      <td>529</td>\n",
       "      <td>W 42 St &amp; 8 Ave</td>\n",
       "      <td>40.757570</td>\n",
       "      <td>-73.990985</td>\n",
       "      <td>363</td>\n",
       "      <td>West Thames St</td>\n",
       "      <td>40.708347</td>\n",
       "      <td>-74.017134</td>\n",
       "      <td>31384</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1989.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824636</th>\n",
       "      <td>219</td>\n",
       "      <td>2018-05-31 23:58:59</td>\n",
       "      <td>2018-06-01 00:02:39</td>\n",
       "      <td>353</td>\n",
       "      <td>S Portland Ave &amp; Hanson Pl</td>\n",
       "      <td>40.685396</td>\n",
       "      <td>-73.974315</td>\n",
       "      <td>3415</td>\n",
       "      <td>Prospect Pl &amp; 6 Ave</td>\n",
       "      <td>40.679331</td>\n",
       "      <td>-73.975195</td>\n",
       "      <td>14628</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824637</th>\n",
       "      <td>599</td>\n",
       "      <td>2018-05-31 23:59:05</td>\n",
       "      <td>2018-06-01 00:09:05</td>\n",
       "      <td>3260</td>\n",
       "      <td>Mercer St &amp; Bleecker St</td>\n",
       "      <td>40.727064</td>\n",
       "      <td>-73.996621</td>\n",
       "      <td>453</td>\n",
       "      <td>W 22 St &amp; 8 Ave</td>\n",
       "      <td>40.744751</td>\n",
       "      <td>-73.999154</td>\n",
       "      <td>30870</td>\n",
       "      <td>Annual Membership from Citi Bike App</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824638</th>\n",
       "      <td>3544</td>\n",
       "      <td>2018-05-31 23:59:05</td>\n",
       "      <td>2018-06-01 00:58:10</td>\n",
       "      <td>3589</td>\n",
       "      <td>Broadway &amp; 12 St</td>\n",
       "      <td>40.766800</td>\n",
       "      <td>-73.934777</td>\n",
       "      <td>3300</td>\n",
       "      <td>Prospect Park West &amp; 8 St</td>\n",
       "      <td>40.665147</td>\n",
       "      <td>-73.976376</td>\n",
       "      <td>30117</td>\n",
       "      <td>Single Ride</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824639</th>\n",
       "      <td>509</td>\n",
       "      <td>2018-05-31 23:59:09</td>\n",
       "      <td>2018-06-01 00:07:38</td>\n",
       "      <td>3100</td>\n",
       "      <td>Nassau Ave &amp; Newell St</td>\n",
       "      <td>40.724813</td>\n",
       "      <td>-73.947526</td>\n",
       "      <td>532</td>\n",
       "      <td>S 5 Pl &amp; S 5 St</td>\n",
       "      <td>40.710451</td>\n",
       "      <td>-73.960876</td>\n",
       "      <td>27214</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1982.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824640</th>\n",
       "      <td>421</td>\n",
       "      <td>2018-05-31 23:59:11</td>\n",
       "      <td>2018-06-01 00:06:12</td>\n",
       "      <td>505</td>\n",
       "      <td>6 Ave &amp; W 33 St</td>\n",
       "      <td>40.749013</td>\n",
       "      <td>-73.988484</td>\n",
       "      <td>448</td>\n",
       "      <td>W 37 St &amp; 10 Ave</td>\n",
       "      <td>40.756604</td>\n",
       "      <td>-73.997901</td>\n",
       "      <td>31054</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824641</th>\n",
       "      <td>2198</td>\n",
       "      <td>2018-05-31 23:59:09</td>\n",
       "      <td>2018-06-01 00:35:48</td>\n",
       "      <td>3125</td>\n",
       "      <td>45 Rd &amp; 11 St</td>\n",
       "      <td>40.747086</td>\n",
       "      <td>-73.949772</td>\n",
       "      <td>401</td>\n",
       "      <td>Allen St &amp; Rivington St</td>\n",
       "      <td>40.720196</td>\n",
       "      <td>-73.989978</td>\n",
       "      <td>21302</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824642</th>\n",
       "      <td>476</td>\n",
       "      <td>2018-05-31 23:59:13</td>\n",
       "      <td>2018-06-01 00:07:10</td>\n",
       "      <td>257</td>\n",
       "      <td>Lispenard St &amp; Broadway</td>\n",
       "      <td>40.719392</td>\n",
       "      <td>-74.002472</td>\n",
       "      <td>257</td>\n",
       "      <td>Lispenard St &amp; Broadway</td>\n",
       "      <td>40.719392</td>\n",
       "      <td>-74.002472</td>\n",
       "      <td>30140</td>\n",
       "      <td>Citi Bike Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1971.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824643</th>\n",
       "      <td>437</td>\n",
       "      <td>2018-05-31 23:59:13</td>\n",
       "      <td>2018-06-01 00:06:31</td>\n",
       "      <td>257</td>\n",
       "      <td>Lispenard St &amp; Broadway</td>\n",
       "      <td>40.719392</td>\n",
       "      <td>-74.002472</td>\n",
       "      <td>257</td>\n",
       "      <td>Lispenard St &amp; Broadway</td>\n",
       "      <td>40.719392</td>\n",
       "      <td>-74.002472</td>\n",
       "      <td>33033</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824644</th>\n",
       "      <td>821</td>\n",
       "      <td>2018-05-31 23:59:16</td>\n",
       "      <td>2018-06-01 00:12:57</td>\n",
       "      <td>458</td>\n",
       "      <td>11 Ave &amp; W 27 St</td>\n",
       "      <td>40.751396</td>\n",
       "      <td>-74.005226</td>\n",
       "      <td>3462</td>\n",
       "      <td>E 44 St &amp; 2 Ave</td>\n",
       "      <td>40.751184</td>\n",
       "      <td>-73.971387</td>\n",
       "      <td>32355</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824645</th>\n",
       "      <td>289</td>\n",
       "      <td>2018-05-31 23:59:21</td>\n",
       "      <td>2018-06-01 00:04:10</td>\n",
       "      <td>279</td>\n",
       "      <td>Peck Slip &amp; Front St</td>\n",
       "      <td>40.707873</td>\n",
       "      <td>-74.001670</td>\n",
       "      <td>296</td>\n",
       "      <td>Division St &amp; Bowery</td>\n",
       "      <td>40.714131</td>\n",
       "      <td>-73.997047</td>\n",
       "      <td>19816</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1983.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824646</th>\n",
       "      <td>269</td>\n",
       "      <td>2018-05-31 23:59:24</td>\n",
       "      <td>2018-06-01 00:03:53</td>\n",
       "      <td>492</td>\n",
       "      <td>W 33 St &amp; 7 Ave</td>\n",
       "      <td>40.750200</td>\n",
       "      <td>-73.990931</td>\n",
       "      <td>3258</td>\n",
       "      <td>W 27 St &amp; 10 Ave</td>\n",
       "      <td>40.750182</td>\n",
       "      <td>-74.002184</td>\n",
       "      <td>30033</td>\n",
       "      <td>Annual Membership from Citi Bike App</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824647</th>\n",
       "      <td>273</td>\n",
       "      <td>2018-05-31 23:59:27</td>\n",
       "      <td>2018-06-01 00:04:01</td>\n",
       "      <td>481</td>\n",
       "      <td>S 3 St &amp; Bedford Ave</td>\n",
       "      <td>40.712605</td>\n",
       "      <td>-73.962644</td>\n",
       "      <td>3016</td>\n",
       "      <td>Kent Ave &amp; N 7 St</td>\n",
       "      <td>40.720368</td>\n",
       "      <td>-73.961651</td>\n",
       "      <td>15662</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824648</th>\n",
       "      <td>1318</td>\n",
       "      <td>2018-05-31 23:59:31</td>\n",
       "      <td>2018-06-01 00:21:30</td>\n",
       "      <td>322</td>\n",
       "      <td>Clinton St &amp; Tillary St</td>\n",
       "      <td>40.696192</td>\n",
       "      <td>-73.991218</td>\n",
       "      <td>3396</td>\n",
       "      <td>Clinton St &amp; 4 Place</td>\n",
       "      <td>40.678356</td>\n",
       "      <td>-74.000145</td>\n",
       "      <td>33003</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1970.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824649</th>\n",
       "      <td>945</td>\n",
       "      <td>2018-05-31 23:59:31</td>\n",
       "      <td>2018-06-01 00:15:17</td>\n",
       "      <td>3128</td>\n",
       "      <td>21 St &amp; 43 Ave</td>\n",
       "      <td>40.750525</td>\n",
       "      <td>-73.945948</td>\n",
       "      <td>3459</td>\n",
       "      <td>E 53 St &amp; 3 Ave</td>\n",
       "      <td>40.757632</td>\n",
       "      <td>-73.969306</td>\n",
       "      <td>30876</td>\n",
       "      <td>Annual Membership - Save 15%</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824650</th>\n",
       "      <td>216</td>\n",
       "      <td>2018-05-31 23:59:38</td>\n",
       "      <td>2018-06-01 00:03:15</td>\n",
       "      <td>537</td>\n",
       "      <td>Lexington Ave &amp; E 24 St</td>\n",
       "      <td>40.740259</td>\n",
       "      <td>-73.984092</td>\n",
       "      <td>546</td>\n",
       "      <td>E 30 St &amp; Park Ave S</td>\n",
       "      <td>40.744449</td>\n",
       "      <td>-73.983035</td>\n",
       "      <td>31641</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824651</th>\n",
       "      <td>631</td>\n",
       "      <td>2018-05-31 23:59:41</td>\n",
       "      <td>2018-06-01 00:10:13</td>\n",
       "      <td>128</td>\n",
       "      <td>MacDougal St &amp; Prince St</td>\n",
       "      <td>40.727103</td>\n",
       "      <td>-74.002971</td>\n",
       "      <td>308</td>\n",
       "      <td>St James Pl &amp; Oliver St</td>\n",
       "      <td>40.713079</td>\n",
       "      <td>-73.998512</td>\n",
       "      <td>20826</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824652</th>\n",
       "      <td>986</td>\n",
       "      <td>2018-05-31 23:59:44</td>\n",
       "      <td>2018-06-01 00:16:11</td>\n",
       "      <td>3562</td>\n",
       "      <td>Classon Ave &amp; St Marks Ave</td>\n",
       "      <td>40.676520</td>\n",
       "      <td>-73.959608</td>\n",
       "      <td>3562</td>\n",
       "      <td>Classon Ave &amp; St Marks Ave</td>\n",
       "      <td>40.676520</td>\n",
       "      <td>-73.959608</td>\n",
       "      <td>32205</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824653</th>\n",
       "      <td>189</td>\n",
       "      <td>2018-05-31 23:59:44</td>\n",
       "      <td>2018-06-01 00:02:53</td>\n",
       "      <td>479</td>\n",
       "      <td>9 Ave &amp; W 45 St</td>\n",
       "      <td>40.760193</td>\n",
       "      <td>-73.991255</td>\n",
       "      <td>3635</td>\n",
       "      <td>W 36 St &amp; 9 Ave</td>\n",
       "      <td>40.754623</td>\n",
       "      <td>-73.995168</td>\n",
       "      <td>31327</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824654</th>\n",
       "      <td>483</td>\n",
       "      <td>2018-05-31 23:59:46</td>\n",
       "      <td>2018-06-01 00:07:49</td>\n",
       "      <td>3341</td>\n",
       "      <td>Central Park West &amp; W 102 St</td>\n",
       "      <td>40.795346</td>\n",
       "      <td>-73.961860</td>\n",
       "      <td>3400</td>\n",
       "      <td>E 110 St &amp; Madison Ave</td>\n",
       "      <td>40.796153</td>\n",
       "      <td>-73.947821</td>\n",
       "      <td>21000</td>\n",
       "      <td>Join Citi Bike for $14.95/month</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1967.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824655</th>\n",
       "      <td>465</td>\n",
       "      <td>2018-05-31 23:59:48</td>\n",
       "      <td>2018-06-01 00:07:34</td>\n",
       "      <td>3107</td>\n",
       "      <td>Bedford Ave &amp; Nassau Ave</td>\n",
       "      <td>40.723117</td>\n",
       "      <td>-73.952123</td>\n",
       "      <td>3076</td>\n",
       "      <td>Scholes St &amp; Manhattan Ave</td>\n",
       "      <td>40.708704</td>\n",
       "      <td>-73.944862</td>\n",
       "      <td>28285</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824656</th>\n",
       "      <td>497</td>\n",
       "      <td>2018-05-31 23:59:51</td>\n",
       "      <td>2018-06-01 00:08:09</td>\n",
       "      <td>483</td>\n",
       "      <td>E 12 St &amp; 3 Ave</td>\n",
       "      <td>40.732233</td>\n",
       "      <td>-73.988900</td>\n",
       "      <td>368</td>\n",
       "      <td>Carmine St &amp; 6 Ave</td>\n",
       "      <td>40.730386</td>\n",
       "      <td>-74.002150</td>\n",
       "      <td>19692</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1979.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824657</th>\n",
       "      <td>747</td>\n",
       "      <td>2018-05-31 23:59:59</td>\n",
       "      <td>2018-06-01 00:12:27</td>\n",
       "      <td>401</td>\n",
       "      <td>Allen St &amp; Rivington St</td>\n",
       "      <td>40.720196</td>\n",
       "      <td>-73.989978</td>\n",
       "      <td>360</td>\n",
       "      <td>William St &amp; Pine St</td>\n",
       "      <td>40.707179</td>\n",
       "      <td>-74.008873</td>\n",
       "      <td>17258</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1824651 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         tripduration            starttime             stoptime  \\\n",
       "0                 303  2018-05-01 00:00:11  2018-05-01 00:05:15   \n",
       "1                 700  2018-05-01 00:00:36  2018-05-01 00:12:16   \n",
       "2                 443  2018-05-01 00:00:40  2018-05-01 00:08:04   \n",
       "3                 297  2018-05-01 00:00:43  2018-05-01 00:05:41   \n",
       "4                 421  2018-05-01 00:01:01  2018-05-01 00:08:02   \n",
       "5               68905  2018-05-01 00:01:11  2018-05-01 19:09:36   \n",
       "6                 197  2018-05-01 00:01:17  2018-05-01 00:04:35   \n",
       "7                 259  2018-05-01 00:01:31  2018-05-01 00:05:50   \n",
       "8                 359  2018-05-01 00:01:42  2018-05-01 00:07:42   \n",
       "9                 460  2018-05-01 00:02:03  2018-05-01 00:09:43   \n",
       "10                295  2018-05-01 00:02:04  2018-05-01 00:07:00   \n",
       "11                204  2018-05-01 00:02:17  2018-05-01 00:05:42   \n",
       "12                589  2018-05-01 00:02:22  2018-05-01 00:12:11   \n",
       "13                 90  2018-05-01 00:02:30  2018-05-01 00:04:00   \n",
       "14               1596  2018-05-01 00:02:47  2018-05-01 00:29:24   \n",
       "15                342  2018-05-01 00:02:52  2018-05-01 00:08:34   \n",
       "16                905  2018-05-01 00:03:20  2018-05-01 00:18:25   \n",
       "17                535  2018-05-01 00:03:28  2018-05-01 00:12:23   \n",
       "18                254  2018-05-01 00:03:30  2018-05-01 00:07:44   \n",
       "19                352  2018-05-01 00:03:36  2018-05-01 00:09:29   \n",
       "20                686  2018-05-01 00:03:41  2018-05-01 00:15:07   \n",
       "21                297  2018-05-01 00:03:59  2018-05-01 00:08:57   \n",
       "22                484  2018-05-01 00:04:27  2018-05-01 00:12:32   \n",
       "23               1287  2018-05-01 00:05:06  2018-05-01 00:26:33   \n",
       "24               1311  2018-05-01 00:05:18  2018-05-01 00:27:09   \n",
       "25                657  2018-05-01 00:05:20  2018-05-01 00:16:18   \n",
       "26                184  2018-05-01 00:05:20  2018-05-01 00:08:25   \n",
       "27               1371  2018-05-01 00:05:32  2018-05-01 00:28:24   \n",
       "28                940  2018-05-01 00:05:45  2018-05-01 00:21:25   \n",
       "29                317  2018-05-01 00:05:48  2018-05-01 00:11:05   \n",
       "...               ...                  ...                  ...   \n",
       "1824628           717  2018-05-31 23:58:27  2018-06-01 00:10:25   \n",
       "1824629           166  2018-05-31 23:58:28  2018-06-01 00:01:14   \n",
       "1824630          1206  2018-05-31 23:58:37  2018-06-01 00:18:44   \n",
       "1824631          1086  2018-05-31 23:58:47  2018-06-01 00:16:54   \n",
       "1824632          2218  2018-05-31 23:58:48  2018-06-01 00:35:46   \n",
       "1824633           993  2018-05-31 23:58:49  2018-06-01 00:15:23   \n",
       "1824634           429  2018-05-31 23:58:56  2018-06-01 00:06:05   \n",
       "1824635          1539  2018-05-31 23:59:00  2018-06-01 00:24:39   \n",
       "1824636           219  2018-05-31 23:58:59  2018-06-01 00:02:39   \n",
       "1824637           599  2018-05-31 23:59:05  2018-06-01 00:09:05   \n",
       "1824638          3544  2018-05-31 23:59:05  2018-06-01 00:58:10   \n",
       "1824639           509  2018-05-31 23:59:09  2018-06-01 00:07:38   \n",
       "1824640           421  2018-05-31 23:59:11  2018-06-01 00:06:12   \n",
       "1824641          2198  2018-05-31 23:59:09  2018-06-01 00:35:48   \n",
       "1824642           476  2018-05-31 23:59:13  2018-06-01 00:07:10   \n",
       "1824643           437  2018-05-31 23:59:13  2018-06-01 00:06:31   \n",
       "1824644           821  2018-05-31 23:59:16  2018-06-01 00:12:57   \n",
       "1824645           289  2018-05-31 23:59:21  2018-06-01 00:04:10   \n",
       "1824646           269  2018-05-31 23:59:24  2018-06-01 00:03:53   \n",
       "1824647           273  2018-05-31 23:59:27  2018-06-01 00:04:01   \n",
       "1824648          1318  2018-05-31 23:59:31  2018-06-01 00:21:30   \n",
       "1824649           945  2018-05-31 23:59:31  2018-06-01 00:15:17   \n",
       "1824650           216  2018-05-31 23:59:38  2018-06-01 00:03:15   \n",
       "1824651           631  2018-05-31 23:59:41  2018-06-01 00:10:13   \n",
       "1824652           986  2018-05-31 23:59:44  2018-06-01 00:16:11   \n",
       "1824653           189  2018-05-31 23:59:44  2018-06-01 00:02:53   \n",
       "1824654           483  2018-05-31 23:59:46  2018-06-01 00:07:49   \n",
       "1824655           465  2018-05-31 23:59:48  2018-06-01 00:07:34   \n",
       "1824656           497  2018-05-31 23:59:51  2018-06-01 00:08:09   \n",
       "1824657           747  2018-05-31 23:59:59  2018-06-01 00:12:27   \n",
       "\n",
       "         start station id             start station name  \\\n",
       "0                     491           E 24 St & Park Ave S   \n",
       "1                     507                E 25 St & 2 Ave   \n",
       "2                    3263       Cooper Square & Astor Pl   \n",
       "3                     532                S 5 Pl & S 5 St   \n",
       "4                    3493               E 118 St & 3 Ave   \n",
       "5                     237                E 11 St & 2 Ave   \n",
       "6                     437        Macon St & Nostrand Ave   \n",
       "7                     236            St Marks Pl & 2 Ave   \n",
       "8                    3158             W 63 St & Broadway   \n",
       "9                     285             Broadway & E 14 St   \n",
       "10                    499             Broadway & W 60 St   \n",
       "11                   3146                E 81 St & 3 Ave   \n",
       "12                    462               W 22 St & 10 Ave   \n",
       "13                   3325                E 95 St & 3 Ave   \n",
       "14                    439                 E 4 St & 2 Ave   \n",
       "15                    474                5 Ave & E 29 St   \n",
       "16                   3081          Graham Ave & Grand St   \n",
       "17                    416  Cumberland St & Lafayette Ave   \n",
       "18                   2002   Wythe Ave & Metropolitan Ave   \n",
       "19                    403                 E 2 St & 2 Ave   \n",
       "20                    468             Broadway & W 56 St   \n",
       "21                    498             Broadway & W 32 St   \n",
       "22                   3419            Douglass St & 4 Ave   \n",
       "23                   3529           Lenox Ave & W 130 St   \n",
       "24                   2003                1 Ave & E 18 St   \n",
       "25                   3335               Union St & 4 Ave   \n",
       "26                   3316       W 104 St & Amsterdam Ave   \n",
       "27                    128       MacDougal St & Prince St   \n",
       "28                    518                E 39 St & 2 Ave   \n",
       "29                    435                W 21 St & 6 Ave   \n",
       "...                   ...                            ...   \n",
       "1824628              3306                  10 St & 7 Ave   \n",
       "1824629              3671                E 81 St & 2 Ave   \n",
       "1824630              3125                  45 Rd & 11 St   \n",
       "1824631               498             Broadway & W 32 St   \n",
       "1824632              3125                  45 Rd & 11 St   \n",
       "1824633               435                W 21 St & 6 Ave   \n",
       "1824634              3467     W Broadway & Spring Street   \n",
       "1824635               529                W 42 St & 8 Ave   \n",
       "1824636               353     S Portland Ave & Hanson Pl   \n",
       "1824637              3260        Mercer St & Bleecker St   \n",
       "1824638              3589               Broadway & 12 St   \n",
       "1824639              3100         Nassau Ave & Newell St   \n",
       "1824640               505                6 Ave & W 33 St   \n",
       "1824641              3125                  45 Rd & 11 St   \n",
       "1824642               257        Lispenard St & Broadway   \n",
       "1824643               257        Lispenard St & Broadway   \n",
       "1824644               458               11 Ave & W 27 St   \n",
       "1824645               279           Peck Slip & Front St   \n",
       "1824646               492                W 33 St & 7 Ave   \n",
       "1824647               481           S 3 St & Bedford Ave   \n",
       "1824648               322        Clinton St & Tillary St   \n",
       "1824649              3128                 21 St & 43 Ave   \n",
       "1824650               537        Lexington Ave & E 24 St   \n",
       "1824651               128       MacDougal St & Prince St   \n",
       "1824652              3562     Classon Ave & St Marks Ave   \n",
       "1824653               479                9 Ave & W 45 St   \n",
       "1824654              3341   Central Park West & W 102 St   \n",
       "1824655              3107       Bedford Ave & Nassau Ave   \n",
       "1824656               483                E 12 St & 3 Ave   \n",
       "1824657               401        Allen St & Rivington St   \n",
       "\n",
       "         start station latitude  start station longitude  end station id  \\\n",
       "0                     40.740964               -73.986022            2003   \n",
       "1                     40.739126               -73.979738            3458   \n",
       "2                     40.729515               -73.990753             546   \n",
       "3                     40.710451               -73.960876            3096   \n",
       "4                     40.799139               -73.938915            3351   \n",
       "5                     40.730473               -73.986724             504   \n",
       "6                     40.680983               -73.950048            3241   \n",
       "7                     40.728419               -73.987140             312   \n",
       "8                     40.771639               -73.982614             495   \n",
       "9                     40.734546               -73.990741             236   \n",
       "10                    40.769155               -73.981918            3175   \n",
       "11                    40.775730               -73.956753            3135   \n",
       "12                    40.746920               -74.004519             450   \n",
       "13                    40.784903               -73.950503            3312   \n",
       "14                    40.726281               -73.989780            3074   \n",
       "15                    40.745168               -73.986831             293   \n",
       "16                    40.711863               -73.944024            3241   \n",
       "17                    40.687534               -73.972652             373   \n",
       "18                    40.716887               -73.963198            3087   \n",
       "19                    40.725029               -73.990697             150   \n",
       "20                    40.765265               -73.981923            3658   \n",
       "21                    40.748549               -73.988084             527   \n",
       "22                    40.679279               -73.981540            3304   \n",
       "23                    40.810792               -73.943068            3529   \n",
       "24                    40.733812               -73.980544            3140   \n",
       "25                    40.677274               -73.982820            3306   \n",
       "26                    40.798994               -73.966217            3323   \n",
       "27                    40.727103               -74.002971             481   \n",
       "28                    40.747804               -73.973442             394   \n",
       "29                    40.741740               -73.994156             285   \n",
       "...                         ...                      ...             ...   \n",
       "1824628               40.666208               -73.981999            3418   \n",
       "1824629               40.774779               -73.954275            3147   \n",
       "1824630               40.747086               -73.949772             460   \n",
       "1824631               40.748549               -73.988084            3370   \n",
       "1824632               40.747086               -73.949772             401   \n",
       "1824633               40.741740               -73.994156            3459   \n",
       "1824634               40.724947               -74.001659             296   \n",
       "1824635               40.757570               -73.990985             363   \n",
       "1824636               40.685396               -73.974315            3415   \n",
       "1824637               40.727064               -73.996621             453   \n",
       "1824638               40.766800               -73.934777            3300   \n",
       "1824639               40.724813               -73.947526             532   \n",
       "1824640               40.749013               -73.988484             448   \n",
       "1824641               40.747086               -73.949772             401   \n",
       "1824642               40.719392               -74.002472             257   \n",
       "1824643               40.719392               -74.002472             257   \n",
       "1824644               40.751396               -74.005226            3462   \n",
       "1824645               40.707873               -74.001670             296   \n",
       "1824646               40.750200               -73.990931            3258   \n",
       "1824647               40.712605               -73.962644            3016   \n",
       "1824648               40.696192               -73.991218            3396   \n",
       "1824649               40.750525               -73.945948            3459   \n",
       "1824650               40.740259               -73.984092             546   \n",
       "1824651               40.727103               -74.002971             308   \n",
       "1824652               40.676520               -73.959608            3562   \n",
       "1824653               40.760193               -73.991255            3635   \n",
       "1824654               40.795346               -73.961860            3400   \n",
       "1824655               40.723117               -73.952123            3076   \n",
       "1824656               40.732233               -73.988900             368   \n",
       "1824657               40.720196               -73.989978             360   \n",
       "\n",
       "                      end station name  end station latitude  \\\n",
       "0                      1 Ave & E 18 St             40.733812   \n",
       "1                      W 55 St & 6 Ave             40.763094   \n",
       "2                 E 30 St & Park Ave S             40.744449   \n",
       "3                  Union Ave & N 12 St             40.719240   \n",
       "4                     E 102 St & 1 Ave             40.786995   \n",
       "5                      1 Ave & E 16 St             40.732219   \n",
       "6             Monroe St & Tompkins Ave             40.686203   \n",
       "7                Allen St & Stanton St             40.722055   \n",
       "8                     W 47 St & 10 Ave             40.762699   \n",
       "9                  St Marks Pl & 2 Ave             40.728419   \n",
       "10             W 70 St & Amsterdam Ave             40.777480   \n",
       "11                     E 75 St & 3 Ave             40.771129   \n",
       "12                     W 49 St & 8 Ave             40.762272   \n",
       "13                     1 Ave & E 94 St             40.781721   \n",
       "14         Montrose Ave & Bushwick Ave             40.707678   \n",
       "15               Lafayette St & E 8 St             40.730207   \n",
       "16            Monroe St & Tompkins Ave             40.686203   \n",
       "17        Willoughby Ave & Walworth St             40.693317   \n",
       "18       Metropolitan Ave & Meeker Ave             40.714133   \n",
       "19                   E 2 St & Avenue C             40.720874   \n",
       "20                     W 18 St & 9 Ave             40.743534   \n",
       "21                     E 33 St & 2 Ave             40.744023   \n",
       "22                        6 Ave & 9 St             40.668127   \n",
       "23                Lenox Ave & W 130 St             40.810792   \n",
       "24                     1 Ave & E 78 St             40.771404   \n",
       "25                       10 St & 7 Ave             40.666208   \n",
       "26        W 106 St & Central Park West             40.798186   \n",
       "27                S 3 St & Bedford Ave             40.712605   \n",
       "28                   E 9 St & Avenue C             40.725213   \n",
       "29                  Broadway & E 14 St             40.734546   \n",
       "...                                ...                   ...   \n",
       "1824628   Plaza St West & Flatbush Ave             40.675021   \n",
       "1824629                E 85 St & 3 Ave             40.778012   \n",
       "1824630             S 4 St & Wythe Ave             40.712859   \n",
       "1824631                E 78 St & 2 Ave             40.772797   \n",
       "1824632        Allen St & Rivington St             40.720196   \n",
       "1824633                E 53 St & 3 Ave             40.757632   \n",
       "1824634           Division St & Bowery             40.714131   \n",
       "1824635                 West Thames St             40.708347   \n",
       "1824636            Prospect Pl & 6 Ave             40.679331   \n",
       "1824637                W 22 St & 8 Ave             40.744751   \n",
       "1824638      Prospect Park West & 8 St             40.665147   \n",
       "1824639                S 5 Pl & S 5 St             40.710451   \n",
       "1824640               W 37 St & 10 Ave             40.756604   \n",
       "1824641        Allen St & Rivington St             40.720196   \n",
       "1824642        Lispenard St & Broadway             40.719392   \n",
       "1824643        Lispenard St & Broadway             40.719392   \n",
       "1824644                E 44 St & 2 Ave             40.751184   \n",
       "1824645           Division St & Bowery             40.714131   \n",
       "1824646               W 27 St & 10 Ave             40.750182   \n",
       "1824647              Kent Ave & N 7 St             40.720368   \n",
       "1824648           Clinton St & 4 Place             40.678356   \n",
       "1824649                E 53 St & 3 Ave             40.757632   \n",
       "1824650           E 30 St & Park Ave S             40.744449   \n",
       "1824651        St James Pl & Oliver St             40.713079   \n",
       "1824652     Classon Ave & St Marks Ave             40.676520   \n",
       "1824653                W 36 St & 9 Ave             40.754623   \n",
       "1824654         E 110 St & Madison Ave             40.796153   \n",
       "1824655     Scholes St & Manhattan Ave             40.708704   \n",
       "1824656             Carmine St & 6 Ave             40.730386   \n",
       "1824657           William St & Pine St             40.707179   \n",
       "\n",
       "         end station longitude  bikeid                  name_localizedValue0  \\\n",
       "0                   -73.980544   32191             $25 Off Annual Membership   \n",
       "1                   -73.978350   29357                     Annual Membership   \n",
       "2                   -73.983035   27255                     Annual Membership   \n",
       "3                   -73.952420   16980                     Annual Membership   \n",
       "4                   -73.941648   30645                     Annual Membership   \n",
       "5                   -73.981656   27440                     Annual Membership   \n",
       "6                   -73.944694   31566                     Annual Membership   \n",
       "7                   -73.989111   29872             $25 Off Annual Membership   \n",
       "8                   -73.993012   14824                     Annual Membership   \n",
       "9                   -73.987140   17638                     Annual Membership   \n",
       "10                  -73.982886   31475                     Annual Membership   \n",
       "11                  -73.957723   14886                     Annual Membership   \n",
       "12                  -73.987882   27251                     Annual Membership   \n",
       "13                  -73.945940   29077                     Annual Membership   \n",
       "14                  -73.940162   20843  Annual Membership from Citi Bike App   \n",
       "15                  -73.991026   30253                     Annual Membership   \n",
       "16                  -73.944694   30190                     Annual Membership   \n",
       "17                  -73.953820   29359                     Annual Membership   \n",
       "18                  -73.952344   20523                     Annual Membership   \n",
       "19                  -73.980858   25750                     Annual Membership   \n",
       "20                  -74.003676   32316                     Annual Membership   \n",
       "21                  -73.976056   28271                     Annual Membership   \n",
       "22                  -73.983776   19678                     Annual Membership   \n",
       "23                  -73.943068   33068                               24 Hour   \n",
       "24                  -73.953517   24888             $25 Off Annual Membership   \n",
       "25                  -73.981999   31596                     Annual Membership   \n",
       "26                  -73.960591   17098             $25 Off Annual Membership   \n",
       "27                  -73.962644   30618             $25 Off Annual Membership   \n",
       "28                  -73.977688   25065             $25 Off Annual Membership   \n",
       "29                  -73.990741   29778  Annual Membership from Citi Bike App   \n",
       "...                        ...     ...                                   ...   \n",
       "1824628             -73.971115   18250                     Annual Membership   \n",
       "1824629             -73.954071   32485                     Annual Membership   \n",
       "1824630             -73.965903   17035                     Annual Membership   \n",
       "1824631             -73.955778   14553                     Annual Membership   \n",
       "1824632             -73.989978   15768       Join Citi Bike for $14.95/month   \n",
       "1824633             -73.969306   26453                                 3 Day   \n",
       "1824634             -73.997047   28850                     Annual Membership   \n",
       "1824635             -74.017134   31384                     Annual Membership   \n",
       "1824636             -73.975195   14628                     Annual Membership   \n",
       "1824637             -73.999154   30870  Annual Membership from Citi Bike App   \n",
       "1824638             -73.976376   30117                           Single Ride   \n",
       "1824639             -73.960876   27214                     Annual Membership   \n",
       "1824640             -73.997901   31054             $25 Off Annual Membership   \n",
       "1824641             -73.989978   21302                     Annual Membership   \n",
       "1824642             -74.002472   30140           Citi Bike Annual Membership   \n",
       "1824643             -74.002472   33033                     Annual Membership   \n",
       "1824644             -73.971387   32355                     Annual Membership   \n",
       "1824645             -73.997047   19816                     Annual Membership   \n",
       "1824646             -74.002184   30033  Annual Membership from Citi Bike App   \n",
       "1824647             -73.961651   15662                     Annual Membership   \n",
       "1824648             -74.000145   33003                     Annual Membership   \n",
       "1824649             -73.969306   30876          Annual Membership - Save 15%   \n",
       "1824650             -73.983035   31641                     Annual Membership   \n",
       "1824651             -73.998512   20826                     Annual Membership   \n",
       "1824652             -73.959608   32205             $25 Off Annual Membership   \n",
       "1824653             -73.995168   31327                     Annual Membership   \n",
       "1824654             -73.947821   21000       Join Citi Bike for $14.95/month   \n",
       "1824655             -73.944862   28285                     Annual Membership   \n",
       "1824656             -74.002150   19692                     Annual Membership   \n",
       "1824657             -74.008873   17258                     Annual Membership   \n",
       "\n",
       "           usertype  birth year  gender  \n",
       "0        Subscriber      1984.0       1  \n",
       "1        Subscriber      1996.0       1  \n",
       "2        Subscriber      1969.0       1  \n",
       "3        Subscriber      1985.0       1  \n",
       "4        Subscriber      1986.0       1  \n",
       "5        Subscriber      1969.0       1  \n",
       "6        Subscriber      1988.0       1  \n",
       "7        Subscriber      1996.0       2  \n",
       "8        Subscriber      1981.0       2  \n",
       "9        Subscriber      1972.0       2  \n",
       "10       Subscriber      1958.0       1  \n",
       "11       Subscriber      1991.0       1  \n",
       "12       Subscriber      1981.0       1  \n",
       "13       Subscriber         NaN       0  \n",
       "14       Subscriber      1995.0       1  \n",
       "15       Subscriber      1991.0       1  \n",
       "16       Subscriber      1987.0       1  \n",
       "17       Subscriber      1975.0       1  \n",
       "18       Subscriber      1972.0       1  \n",
       "19       Subscriber      1995.0       1  \n",
       "20       Subscriber      1982.0       1  \n",
       "21       Subscriber      1967.0       1  \n",
       "22       Subscriber      1978.0       1  \n",
       "23         Customer         NaN       0  \n",
       "24       Subscriber      1972.0       2  \n",
       "25       Subscriber      1980.0       1  \n",
       "26       Subscriber      1993.0       1  \n",
       "27       Subscriber      1991.0       1  \n",
       "28       Subscriber      1991.0       1  \n",
       "29       Subscriber      1996.0       1  \n",
       "...             ...         ...     ...  \n",
       "1824628  Subscriber      2000.0       1  \n",
       "1824629  Subscriber      1991.0       1  \n",
       "1824630  Subscriber      1991.0       2  \n",
       "1824631  Subscriber      1994.0       1  \n",
       "1824632  Subscriber      1978.0       2  \n",
       "1824633    Customer         NaN       0  \n",
       "1824634  Subscriber      1945.0       1  \n",
       "1824635  Subscriber      1989.0       1  \n",
       "1824636  Subscriber      1987.0       1  \n",
       "1824637  Subscriber      1987.0       1  \n",
       "1824638    Customer      1986.0       1  \n",
       "1824639  Subscriber      1982.0       1  \n",
       "1824640  Subscriber      1985.0       2  \n",
       "1824641  Subscriber      1991.0       2  \n",
       "1824642  Subscriber      1971.0       2  \n",
       "1824643  Subscriber      1969.0       2  \n",
       "1824644  Subscriber      1994.0       1  \n",
       "1824645  Subscriber      1983.0       2  \n",
       "1824646  Subscriber      1992.0       1  \n",
       "1824647  Subscriber      1991.0       1  \n",
       "1824648  Subscriber      1970.0       1  \n",
       "1824649  Subscriber      1987.0       1  \n",
       "1824650  Subscriber      1981.0       1  \n",
       "1824651  Subscriber      1986.0       1  \n",
       "1824652  Subscriber      1993.0       1  \n",
       "1824653  Subscriber      1984.0       1  \n",
       "1824654  Subscriber      1967.0       2  \n",
       "1824655  Subscriber      1990.0       1  \n",
       "1824656  Subscriber      1979.0       1  \n",
       "1824657  Subscriber      1994.0       1  \n",
       "\n",
       "[1824651 rows x 16 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_bike.drop(data_bike.index[[1165053,1165074,1165078,1165097,1165106,1165108,1165128]])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date/Time</th>\n",
       "      <th>Air Temp (℉)</th>\n",
       "      <th>Dewpoint (℉)</th>\n",
       "      <th>Precip (inches)</th>\n",
       "      <th>RH (%)</th>\n",
       "      <th>Wind Spd (mph)</th>\n",
       "      <th>Wind Dir (degrees)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>05/01/2018 00:00 EDT</td>\n",
       "      <td>49</td>\n",
       "      <td>38</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66</td>\n",
       "      <td>3.5</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>05/01/2018 01:00 EDT</td>\n",
       "      <td>48</td>\n",
       "      <td>37</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66</td>\n",
       "      <td>4.6</td>\n",
       "      <td>270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>05/01/2018 02:00 EDT</td>\n",
       "      <td>50</td>\n",
       "      <td>36</td>\n",
       "      <td>0.0</td>\n",
       "      <td>58</td>\n",
       "      <td>3.5</td>\n",
       "      <td>260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>05/01/2018 03:00 EDT</td>\n",
       "      <td>49</td>\n",
       "      <td>36</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61</td>\n",
       "      <td>4.6</td>\n",
       "      <td>260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>05/01/2018 04:00 EDT</td>\n",
       "      <td>50</td>\n",
       "      <td>36</td>\n",
       "      <td>0.0</td>\n",
       "      <td>58</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Date/Time  Air Temp (℉) Dewpoint (℉)  Precip (inches)  RH (%)  \\\n",
       "0  05/01/2018 00:00 EDT            49           38              0.0      66   \n",
       "1  05/01/2018 01:00 EDT            48           37              0.0      66   \n",
       "2  05/01/2018 02:00 EDT            50           36              0.0      58   \n",
       "3  05/01/2018 03:00 EDT            49           36              0.0      61   \n",
       "4  05/01/2018 04:00 EDT            50           36              0.0      58   \n",
       "\n",
       "   Wind Spd (mph)  Wind Dir (degrees)  \n",
       "0             3.5                  -1  \n",
       "1             4.6                 270  \n",
       "2             3.5                 260  \n",
       "3             4.6                 260  \n",
       "4             0.0                   0  "
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_weather = pd.read_csv('NYC May 2018 Weather.csv')\n",
    "data_weather.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>tripduration</th>\n",
       "      <th>starttime</th>\n",
       "      <th>stoptime</th>\n",
       "      <th>start station id</th>\n",
       "      <th>start station name</th>\n",
       "      <th>start station latitude</th>\n",
       "      <th>start station longitude</th>\n",
       "      <th>end station id</th>\n",
       "      <th>end station name</th>\n",
       "      <th>end station latitude</th>\n",
       "      <th>end station longitude</th>\n",
       "      <th>bikeid</th>\n",
       "      <th>name_localizedValue0</th>\n",
       "      <th>usertype</th>\n",
       "      <th>birth year</th>\n",
       "      <th>gender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>303</td>\n",
       "      <td>2018-05-01 00:00:11</td>\n",
       "      <td>2018-05-01 00:05:15</td>\n",
       "      <td>491</td>\n",
       "      <td>E 24 St &amp; Park Ave S</td>\n",
       "      <td>40.740964</td>\n",
       "      <td>-73.986022</td>\n",
       "      <td>2003</td>\n",
       "      <td>1 Ave &amp; E 18 St</td>\n",
       "      <td>40.733812</td>\n",
       "      <td>-73.980544</td>\n",
       "      <td>32191</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>700</td>\n",
       "      <td>2018-05-01 00:00:36</td>\n",
       "      <td>2018-05-01 00:12:16</td>\n",
       "      <td>507</td>\n",
       "      <td>E 25 St &amp; 2 Ave</td>\n",
       "      <td>40.739126</td>\n",
       "      <td>-73.979738</td>\n",
       "      <td>3458</td>\n",
       "      <td>W 55 St &amp; 6 Ave</td>\n",
       "      <td>40.763094</td>\n",
       "      <td>-73.978350</td>\n",
       "      <td>29357</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>443</td>\n",
       "      <td>2018-05-01 00:00:40</td>\n",
       "      <td>2018-05-01 00:08:04</td>\n",
       "      <td>3263</td>\n",
       "      <td>Cooper Square &amp; Astor Pl</td>\n",
       "      <td>40.729515</td>\n",
       "      <td>-73.990753</td>\n",
       "      <td>546</td>\n",
       "      <td>E 30 St &amp; Park Ave S</td>\n",
       "      <td>40.744449</td>\n",
       "      <td>-73.983035</td>\n",
       "      <td>27255</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>297</td>\n",
       "      <td>2018-05-01 00:00:43</td>\n",
       "      <td>2018-05-01 00:05:41</td>\n",
       "      <td>532</td>\n",
       "      <td>S 5 Pl &amp; S 5 St</td>\n",
       "      <td>40.710451</td>\n",
       "      <td>-73.960876</td>\n",
       "      <td>3096</td>\n",
       "      <td>Union Ave &amp; N 12 St</td>\n",
       "      <td>40.719240</td>\n",
       "      <td>-73.952420</td>\n",
       "      <td>16980</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>421</td>\n",
       "      <td>2018-05-01 00:01:01</td>\n",
       "      <td>2018-05-01 00:08:02</td>\n",
       "      <td>3493</td>\n",
       "      <td>E 118 St &amp; 3 Ave</td>\n",
       "      <td>40.799139</td>\n",
       "      <td>-73.938915</td>\n",
       "      <td>3351</td>\n",
       "      <td>E 102 St &amp; 1 Ave</td>\n",
       "      <td>40.786995</td>\n",
       "      <td>-73.941648</td>\n",
       "      <td>30645</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>68905</td>\n",
       "      <td>2018-05-01 00:01:11</td>\n",
       "      <td>2018-05-01 19:09:36</td>\n",
       "      <td>237</td>\n",
       "      <td>E 11 St &amp; 2 Ave</td>\n",
       "      <td>40.730473</td>\n",
       "      <td>-73.986724</td>\n",
       "      <td>504</td>\n",
       "      <td>1 Ave &amp; E 16 St</td>\n",
       "      <td>40.732219</td>\n",
       "      <td>-73.981656</td>\n",
       "      <td>27440</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>197</td>\n",
       "      <td>2018-05-01 00:01:17</td>\n",
       "      <td>2018-05-01 00:04:35</td>\n",
       "      <td>437</td>\n",
       "      <td>Macon St &amp; Nostrand Ave</td>\n",
       "      <td>40.680983</td>\n",
       "      <td>-73.950048</td>\n",
       "      <td>3241</td>\n",
       "      <td>Monroe St &amp; Tompkins Ave</td>\n",
       "      <td>40.686203</td>\n",
       "      <td>-73.944694</td>\n",
       "      <td>31566</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>259</td>\n",
       "      <td>2018-05-01 00:01:31</td>\n",
       "      <td>2018-05-01 00:05:50</td>\n",
       "      <td>236</td>\n",
       "      <td>St Marks Pl &amp; 2 Ave</td>\n",
       "      <td>40.728419</td>\n",
       "      <td>-73.987140</td>\n",
       "      <td>312</td>\n",
       "      <td>Allen St &amp; Stanton St</td>\n",
       "      <td>40.722055</td>\n",
       "      <td>-73.989111</td>\n",
       "      <td>29872</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>359</td>\n",
       "      <td>2018-05-01 00:01:42</td>\n",
       "      <td>2018-05-01 00:07:42</td>\n",
       "      <td>3158</td>\n",
       "      <td>W 63 St &amp; Broadway</td>\n",
       "      <td>40.771639</td>\n",
       "      <td>-73.982614</td>\n",
       "      <td>495</td>\n",
       "      <td>W 47 St &amp; 10 Ave</td>\n",
       "      <td>40.762699</td>\n",
       "      <td>-73.993012</td>\n",
       "      <td>14824</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>460</td>\n",
       "      <td>2018-05-01 00:02:03</td>\n",
       "      <td>2018-05-01 00:09:43</td>\n",
       "      <td>285</td>\n",
       "      <td>Broadway &amp; E 14 St</td>\n",
       "      <td>40.734546</td>\n",
       "      <td>-73.990741</td>\n",
       "      <td>236</td>\n",
       "      <td>St Marks Pl &amp; 2 Ave</td>\n",
       "      <td>40.728419</td>\n",
       "      <td>-73.987140</td>\n",
       "      <td>17638</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>295</td>\n",
       "      <td>2018-05-01 00:02:04</td>\n",
       "      <td>2018-05-01 00:07:00</td>\n",
       "      <td>499</td>\n",
       "      <td>Broadway &amp; W 60 St</td>\n",
       "      <td>40.769155</td>\n",
       "      <td>-73.981918</td>\n",
       "      <td>3175</td>\n",
       "      <td>W 70 St &amp; Amsterdam Ave</td>\n",
       "      <td>40.777480</td>\n",
       "      <td>-73.982886</td>\n",
       "      <td>31475</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1958.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>204</td>\n",
       "      <td>2018-05-01 00:02:17</td>\n",
       "      <td>2018-05-01 00:05:42</td>\n",
       "      <td>3146</td>\n",
       "      <td>E 81 St &amp; 3 Ave</td>\n",
       "      <td>40.775730</td>\n",
       "      <td>-73.956753</td>\n",
       "      <td>3135</td>\n",
       "      <td>E 75 St &amp; 3 Ave</td>\n",
       "      <td>40.771129</td>\n",
       "      <td>-73.957723</td>\n",
       "      <td>14886</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>589</td>\n",
       "      <td>2018-05-01 00:02:22</td>\n",
       "      <td>2018-05-01 00:12:11</td>\n",
       "      <td>462</td>\n",
       "      <td>W 22 St &amp; 10 Ave</td>\n",
       "      <td>40.746920</td>\n",
       "      <td>-74.004519</td>\n",
       "      <td>450</td>\n",
       "      <td>W 49 St &amp; 8 Ave</td>\n",
       "      <td>40.762272</td>\n",
       "      <td>-73.987882</td>\n",
       "      <td>27251</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1596</td>\n",
       "      <td>2018-05-01 00:02:47</td>\n",
       "      <td>2018-05-01 00:29:24</td>\n",
       "      <td>439</td>\n",
       "      <td>E 4 St &amp; 2 Ave</td>\n",
       "      <td>40.726281</td>\n",
       "      <td>-73.989780</td>\n",
       "      <td>3074</td>\n",
       "      <td>Montrose Ave &amp; Bushwick Ave</td>\n",
       "      <td>40.707678</td>\n",
       "      <td>-73.940162</td>\n",
       "      <td>20843</td>\n",
       "      <td>Annual Membership from Citi Bike App</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>342</td>\n",
       "      <td>2018-05-01 00:02:52</td>\n",
       "      <td>2018-05-01 00:08:34</td>\n",
       "      <td>474</td>\n",
       "      <td>5 Ave &amp; E 29 St</td>\n",
       "      <td>40.745168</td>\n",
       "      <td>-73.986831</td>\n",
       "      <td>293</td>\n",
       "      <td>Lafayette St &amp; E 8 St</td>\n",
       "      <td>40.730207</td>\n",
       "      <td>-73.991026</td>\n",
       "      <td>30253</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>905</td>\n",
       "      <td>2018-05-01 00:03:20</td>\n",
       "      <td>2018-05-01 00:18:25</td>\n",
       "      <td>3081</td>\n",
       "      <td>Graham Ave &amp; Grand St</td>\n",
       "      <td>40.711863</td>\n",
       "      <td>-73.944024</td>\n",
       "      <td>3241</td>\n",
       "      <td>Monroe St &amp; Tompkins Ave</td>\n",
       "      <td>40.686203</td>\n",
       "      <td>-73.944694</td>\n",
       "      <td>30190</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>535</td>\n",
       "      <td>2018-05-01 00:03:28</td>\n",
       "      <td>2018-05-01 00:12:23</td>\n",
       "      <td>416</td>\n",
       "      <td>Cumberland St &amp; Lafayette Ave</td>\n",
       "      <td>40.687534</td>\n",
       "      <td>-73.972652</td>\n",
       "      <td>373</td>\n",
       "      <td>Willoughby Ave &amp; Walworth St</td>\n",
       "      <td>40.693317</td>\n",
       "      <td>-73.953820</td>\n",
       "      <td>29359</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>254</td>\n",
       "      <td>2018-05-01 00:03:30</td>\n",
       "      <td>2018-05-01 00:07:44</td>\n",
       "      <td>2002</td>\n",
       "      <td>Wythe Ave &amp; Metropolitan Ave</td>\n",
       "      <td>40.716887</td>\n",
       "      <td>-73.963198</td>\n",
       "      <td>3087</td>\n",
       "      <td>Metropolitan Ave &amp; Meeker Ave</td>\n",
       "      <td>40.714133</td>\n",
       "      <td>-73.952344</td>\n",
       "      <td>20523</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>352</td>\n",
       "      <td>2018-05-01 00:03:36</td>\n",
       "      <td>2018-05-01 00:09:29</td>\n",
       "      <td>403</td>\n",
       "      <td>E 2 St &amp; 2 Ave</td>\n",
       "      <td>40.725029</td>\n",
       "      <td>-73.990697</td>\n",
       "      <td>150</td>\n",
       "      <td>E 2 St &amp; Avenue C</td>\n",
       "      <td>40.720874</td>\n",
       "      <td>-73.980858</td>\n",
       "      <td>25750</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>686</td>\n",
       "      <td>2018-05-01 00:03:41</td>\n",
       "      <td>2018-05-01 00:15:07</td>\n",
       "      <td>468</td>\n",
       "      <td>Broadway &amp; W 56 St</td>\n",
       "      <td>40.765265</td>\n",
       "      <td>-73.981923</td>\n",
       "      <td>3658</td>\n",
       "      <td>W 18 St &amp; 9 Ave</td>\n",
       "      <td>40.743534</td>\n",
       "      <td>-74.003676</td>\n",
       "      <td>32316</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1982.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>297</td>\n",
       "      <td>2018-05-01 00:03:59</td>\n",
       "      <td>2018-05-01 00:08:57</td>\n",
       "      <td>498</td>\n",
       "      <td>Broadway &amp; W 32 St</td>\n",
       "      <td>40.748549</td>\n",
       "      <td>-73.988084</td>\n",
       "      <td>527</td>\n",
       "      <td>E 33 St &amp; 2 Ave</td>\n",
       "      <td>40.744023</td>\n",
       "      <td>-73.976056</td>\n",
       "      <td>28271</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1967.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>484</td>\n",
       "      <td>2018-05-01 00:04:27</td>\n",
       "      <td>2018-05-01 00:12:32</td>\n",
       "      <td>3419</td>\n",
       "      <td>Douglass St &amp; 4 Ave</td>\n",
       "      <td>40.679279</td>\n",
       "      <td>-73.981540</td>\n",
       "      <td>3304</td>\n",
       "      <td>6 Ave &amp; 9 St</td>\n",
       "      <td>40.668127</td>\n",
       "      <td>-73.983776</td>\n",
       "      <td>19678</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1978.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1311</td>\n",
       "      <td>2018-05-01 00:05:18</td>\n",
       "      <td>2018-05-01 00:27:09</td>\n",
       "      <td>2003</td>\n",
       "      <td>1 Ave &amp; E 18 St</td>\n",
       "      <td>40.733812</td>\n",
       "      <td>-73.980544</td>\n",
       "      <td>3140</td>\n",
       "      <td>1 Ave &amp; E 78 St</td>\n",
       "      <td>40.771404</td>\n",
       "      <td>-73.953517</td>\n",
       "      <td>24888</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>657</td>\n",
       "      <td>2018-05-01 00:05:20</td>\n",
       "      <td>2018-05-01 00:16:18</td>\n",
       "      <td>3335</td>\n",
       "      <td>Union St &amp; 4 Ave</td>\n",
       "      <td>40.677274</td>\n",
       "      <td>-73.982820</td>\n",
       "      <td>3306</td>\n",
       "      <td>10 St &amp; 7 Ave</td>\n",
       "      <td>40.666208</td>\n",
       "      <td>-73.981999</td>\n",
       "      <td>31596</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1980.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>184</td>\n",
       "      <td>2018-05-01 00:05:20</td>\n",
       "      <td>2018-05-01 00:08:25</td>\n",
       "      <td>3316</td>\n",
       "      <td>W 104 St &amp; Amsterdam Ave</td>\n",
       "      <td>40.798994</td>\n",
       "      <td>-73.966217</td>\n",
       "      <td>3323</td>\n",
       "      <td>W 106 St &amp; Central Park West</td>\n",
       "      <td>40.798186</td>\n",
       "      <td>-73.960591</td>\n",
       "      <td>17098</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1371</td>\n",
       "      <td>2018-05-01 00:05:32</td>\n",
       "      <td>2018-05-01 00:28:24</td>\n",
       "      <td>128</td>\n",
       "      <td>MacDougal St &amp; Prince St</td>\n",
       "      <td>40.727103</td>\n",
       "      <td>-74.002971</td>\n",
       "      <td>481</td>\n",
       "      <td>S 3 St &amp; Bedford Ave</td>\n",
       "      <td>40.712605</td>\n",
       "      <td>-73.962644</td>\n",
       "      <td>30618</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>940</td>\n",
       "      <td>2018-05-01 00:05:45</td>\n",
       "      <td>2018-05-01 00:21:25</td>\n",
       "      <td>518</td>\n",
       "      <td>E 39 St &amp; 2 Ave</td>\n",
       "      <td>40.747804</td>\n",
       "      <td>-73.973442</td>\n",
       "      <td>394</td>\n",
       "      <td>E 9 St &amp; Avenue C</td>\n",
       "      <td>40.725213</td>\n",
       "      <td>-73.977688</td>\n",
       "      <td>25065</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>317</td>\n",
       "      <td>2018-05-01 00:05:48</td>\n",
       "      <td>2018-05-01 00:11:05</td>\n",
       "      <td>435</td>\n",
       "      <td>W 21 St &amp; 6 Ave</td>\n",
       "      <td>40.741740</td>\n",
       "      <td>-73.994156</td>\n",
       "      <td>285</td>\n",
       "      <td>Broadway &amp; E 14 St</td>\n",
       "      <td>40.734546</td>\n",
       "      <td>-73.990741</td>\n",
       "      <td>29778</td>\n",
       "      <td>Annual Membership from Citi Bike App</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>726</td>\n",
       "      <td>2018-05-01 00:05:51</td>\n",
       "      <td>2018-05-01 00:17:58</td>\n",
       "      <td>477</td>\n",
       "      <td>W 41 St &amp; 8 Ave</td>\n",
       "      <td>40.756405</td>\n",
       "      <td>-73.990026</td>\n",
       "      <td>466</td>\n",
       "      <td>W 25 St &amp; 6 Ave</td>\n",
       "      <td>40.743954</td>\n",
       "      <td>-73.991449</td>\n",
       "      <td>16394</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>971</td>\n",
       "      <td>2018-05-01 00:06:59</td>\n",
       "      <td>2018-05-01 00:23:10</td>\n",
       "      <td>439</td>\n",
       "      <td>E 4 St &amp; 2 Ave</td>\n",
       "      <td>40.726281</td>\n",
       "      <td>-73.989780</td>\n",
       "      <td>435</td>\n",
       "      <td>W 21 St &amp; 6 Ave</td>\n",
       "      <td>40.741740</td>\n",
       "      <td>-73.994156</td>\n",
       "      <td>32796</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1980.0</td>\n",
       "      <td>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824627</th>\n",
       "      <td>117</td>\n",
       "      <td>2018-05-31 23:58:26</td>\n",
       "      <td>2018-06-01 00:00:23</td>\n",
       "      <td>336</td>\n",
       "      <td>Sullivan St &amp; Washington Sq</td>\n",
       "      <td>40.730477</td>\n",
       "      <td>-73.999061</td>\n",
       "      <td>3244</td>\n",
       "      <td>University Pl &amp; E 8 St</td>\n",
       "      <td>40.731437</td>\n",
       "      <td>-73.994903</td>\n",
       "      <td>27747</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824628</th>\n",
       "      <td>717</td>\n",
       "      <td>2018-05-31 23:58:27</td>\n",
       "      <td>2018-06-01 00:10:25</td>\n",
       "      <td>3306</td>\n",
       "      <td>10 St &amp; 7 Ave</td>\n",
       "      <td>40.666208</td>\n",
       "      <td>-73.981999</td>\n",
       "      <td>3418</td>\n",
       "      <td>Plaza St West &amp; Flatbush Ave</td>\n",
       "      <td>40.675021</td>\n",
       "      <td>-73.971115</td>\n",
       "      <td>18250</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824629</th>\n",
       "      <td>166</td>\n",
       "      <td>2018-05-31 23:58:28</td>\n",
       "      <td>2018-06-01 00:01:14</td>\n",
       "      <td>3671</td>\n",
       "      <td>E 81 St &amp; 2 Ave</td>\n",
       "      <td>40.774779</td>\n",
       "      <td>-73.954275</td>\n",
       "      <td>3147</td>\n",
       "      <td>E 85 St &amp; 3 Ave</td>\n",
       "      <td>40.778012</td>\n",
       "      <td>-73.954071</td>\n",
       "      <td>32485</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824630</th>\n",
       "      <td>1206</td>\n",
       "      <td>2018-05-31 23:58:37</td>\n",
       "      <td>2018-06-01 00:18:44</td>\n",
       "      <td>3125</td>\n",
       "      <td>45 Rd &amp; 11 St</td>\n",
       "      <td>40.747086</td>\n",
       "      <td>-73.949772</td>\n",
       "      <td>460</td>\n",
       "      <td>S 4 St &amp; Wythe Ave</td>\n",
       "      <td>40.712859</td>\n",
       "      <td>-73.965903</td>\n",
       "      <td>17035</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824631</th>\n",
       "      <td>1086</td>\n",
       "      <td>2018-05-31 23:58:47</td>\n",
       "      <td>2018-06-01 00:16:54</td>\n",
       "      <td>498</td>\n",
       "      <td>Broadway &amp; W 32 St</td>\n",
       "      <td>40.748549</td>\n",
       "      <td>-73.988084</td>\n",
       "      <td>3370</td>\n",
       "      <td>E 78 St &amp; 2 Ave</td>\n",
       "      <td>40.772797</td>\n",
       "      <td>-73.955778</td>\n",
       "      <td>14553</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824632</th>\n",
       "      <td>2218</td>\n",
       "      <td>2018-05-31 23:58:48</td>\n",
       "      <td>2018-06-01 00:35:46</td>\n",
       "      <td>3125</td>\n",
       "      <td>45 Rd &amp; 11 St</td>\n",
       "      <td>40.747086</td>\n",
       "      <td>-73.949772</td>\n",
       "      <td>401</td>\n",
       "      <td>Allen St &amp; Rivington St</td>\n",
       "      <td>40.720196</td>\n",
       "      <td>-73.989978</td>\n",
       "      <td>15768</td>\n",
       "      <td>Join Citi Bike for $14.95/month</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1978.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824634</th>\n",
       "      <td>429</td>\n",
       "      <td>2018-05-31 23:58:56</td>\n",
       "      <td>2018-06-01 00:06:05</td>\n",
       "      <td>3467</td>\n",
       "      <td>W Broadway &amp; Spring Street</td>\n",
       "      <td>40.724947</td>\n",
       "      <td>-74.001659</td>\n",
       "      <td>296</td>\n",
       "      <td>Division St &amp; Bowery</td>\n",
       "      <td>40.714131</td>\n",
       "      <td>-73.997047</td>\n",
       "      <td>28850</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1945.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824635</th>\n",
       "      <td>1539</td>\n",
       "      <td>2018-05-31 23:59:00</td>\n",
       "      <td>2018-06-01 00:24:39</td>\n",
       "      <td>529</td>\n",
       "      <td>W 42 St &amp; 8 Ave</td>\n",
       "      <td>40.757570</td>\n",
       "      <td>-73.990985</td>\n",
       "      <td>363</td>\n",
       "      <td>West Thames St</td>\n",
       "      <td>40.708347</td>\n",
       "      <td>-74.017134</td>\n",
       "      <td>31384</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1989.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824636</th>\n",
       "      <td>219</td>\n",
       "      <td>2018-05-31 23:58:59</td>\n",
       "      <td>2018-06-01 00:02:39</td>\n",
       "      <td>353</td>\n",
       "      <td>S Portland Ave &amp; Hanson Pl</td>\n",
       "      <td>40.685396</td>\n",
       "      <td>-73.974315</td>\n",
       "      <td>3415</td>\n",
       "      <td>Prospect Pl &amp; 6 Ave</td>\n",
       "      <td>40.679331</td>\n",
       "      <td>-73.975195</td>\n",
       "      <td>14628</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824637</th>\n",
       "      <td>599</td>\n",
       "      <td>2018-05-31 23:59:05</td>\n",
       "      <td>2018-06-01 00:09:05</td>\n",
       "      <td>3260</td>\n",
       "      <td>Mercer St &amp; Bleecker St</td>\n",
       "      <td>40.727064</td>\n",
       "      <td>-73.996621</td>\n",
       "      <td>453</td>\n",
       "      <td>W 22 St &amp; 8 Ave</td>\n",
       "      <td>40.744751</td>\n",
       "      <td>-73.999154</td>\n",
       "      <td>30870</td>\n",
       "      <td>Annual Membership from Citi Bike App</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824638</th>\n",
       "      <td>3544</td>\n",
       "      <td>2018-05-31 23:59:05</td>\n",
       "      <td>2018-06-01 00:58:10</td>\n",
       "      <td>3589</td>\n",
       "      <td>Broadway &amp; 12 St</td>\n",
       "      <td>40.766800</td>\n",
       "      <td>-73.934777</td>\n",
       "      <td>3300</td>\n",
       "      <td>Prospect Park West &amp; 8 St</td>\n",
       "      <td>40.665147</td>\n",
       "      <td>-73.976376</td>\n",
       "      <td>30117</td>\n",
       "      <td>Single Ride</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824639</th>\n",
       "      <td>509</td>\n",
       "      <td>2018-05-31 23:59:09</td>\n",
       "      <td>2018-06-01 00:07:38</td>\n",
       "      <td>3100</td>\n",
       "      <td>Nassau Ave &amp; Newell St</td>\n",
       "      <td>40.724813</td>\n",
       "      <td>-73.947526</td>\n",
       "      <td>532</td>\n",
       "      <td>S 5 Pl &amp; S 5 St</td>\n",
       "      <td>40.710451</td>\n",
       "      <td>-73.960876</td>\n",
       "      <td>27214</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1982.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824640</th>\n",
       "      <td>421</td>\n",
       "      <td>2018-05-31 23:59:11</td>\n",
       "      <td>2018-06-01 00:06:12</td>\n",
       "      <td>505</td>\n",
       "      <td>6 Ave &amp; W 33 St</td>\n",
       "      <td>40.749013</td>\n",
       "      <td>-73.988484</td>\n",
       "      <td>448</td>\n",
       "      <td>W 37 St &amp; 10 Ave</td>\n",
       "      <td>40.756604</td>\n",
       "      <td>-73.997901</td>\n",
       "      <td>31054</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824641</th>\n",
       "      <td>2198</td>\n",
       "      <td>2018-05-31 23:59:09</td>\n",
       "      <td>2018-06-01 00:35:48</td>\n",
       "      <td>3125</td>\n",
       "      <td>45 Rd &amp; 11 St</td>\n",
       "      <td>40.747086</td>\n",
       "      <td>-73.949772</td>\n",
       "      <td>401</td>\n",
       "      <td>Allen St &amp; Rivington St</td>\n",
       "      <td>40.720196</td>\n",
       "      <td>-73.989978</td>\n",
       "      <td>21302</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824642</th>\n",
       "      <td>476</td>\n",
       "      <td>2018-05-31 23:59:13</td>\n",
       "      <td>2018-06-01 00:07:10</td>\n",
       "      <td>257</td>\n",
       "      <td>Lispenard St &amp; Broadway</td>\n",
       "      <td>40.719392</td>\n",
       "      <td>-74.002472</td>\n",
       "      <td>257</td>\n",
       "      <td>Lispenard St &amp; Broadway</td>\n",
       "      <td>40.719392</td>\n",
       "      <td>-74.002472</td>\n",
       "      <td>30140</td>\n",
       "      <td>Citi Bike Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1971.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824643</th>\n",
       "      <td>437</td>\n",
       "      <td>2018-05-31 23:59:13</td>\n",
       "      <td>2018-06-01 00:06:31</td>\n",
       "      <td>257</td>\n",
       "      <td>Lispenard St &amp; Broadway</td>\n",
       "      <td>40.719392</td>\n",
       "      <td>-74.002472</td>\n",
       "      <td>257</td>\n",
       "      <td>Lispenard St &amp; Broadway</td>\n",
       "      <td>40.719392</td>\n",
       "      <td>-74.002472</td>\n",
       "      <td>33033</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824644</th>\n",
       "      <td>821</td>\n",
       "      <td>2018-05-31 23:59:16</td>\n",
       "      <td>2018-06-01 00:12:57</td>\n",
       "      <td>458</td>\n",
       "      <td>11 Ave &amp; W 27 St</td>\n",
       "      <td>40.751396</td>\n",
       "      <td>-74.005226</td>\n",
       "      <td>3462</td>\n",
       "      <td>E 44 St &amp; 2 Ave</td>\n",
       "      <td>40.751184</td>\n",
       "      <td>-73.971387</td>\n",
       "      <td>32355</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824645</th>\n",
       "      <td>289</td>\n",
       "      <td>2018-05-31 23:59:21</td>\n",
       "      <td>2018-06-01 00:04:10</td>\n",
       "      <td>279</td>\n",
       "      <td>Peck Slip &amp; Front St</td>\n",
       "      <td>40.707873</td>\n",
       "      <td>-74.001670</td>\n",
       "      <td>296</td>\n",
       "      <td>Division St &amp; Bowery</td>\n",
       "      <td>40.714131</td>\n",
       "      <td>-73.997047</td>\n",
       "      <td>19816</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1983.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824646</th>\n",
       "      <td>269</td>\n",
       "      <td>2018-05-31 23:59:24</td>\n",
       "      <td>2018-06-01 00:03:53</td>\n",
       "      <td>492</td>\n",
       "      <td>W 33 St &amp; 7 Ave</td>\n",
       "      <td>40.750200</td>\n",
       "      <td>-73.990931</td>\n",
       "      <td>3258</td>\n",
       "      <td>W 27 St &amp; 10 Ave</td>\n",
       "      <td>40.750182</td>\n",
       "      <td>-74.002184</td>\n",
       "      <td>30033</td>\n",
       "      <td>Annual Membership from Citi Bike App</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824647</th>\n",
       "      <td>273</td>\n",
       "      <td>2018-05-31 23:59:27</td>\n",
       "      <td>2018-06-01 00:04:01</td>\n",
       "      <td>481</td>\n",
       "      <td>S 3 St &amp; Bedford Ave</td>\n",
       "      <td>40.712605</td>\n",
       "      <td>-73.962644</td>\n",
       "      <td>3016</td>\n",
       "      <td>Kent Ave &amp; N 7 St</td>\n",
       "      <td>40.720368</td>\n",
       "      <td>-73.961651</td>\n",
       "      <td>15662</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824648</th>\n",
       "      <td>1318</td>\n",
       "      <td>2018-05-31 23:59:31</td>\n",
       "      <td>2018-06-01 00:21:30</td>\n",
       "      <td>322</td>\n",
       "      <td>Clinton St &amp; Tillary St</td>\n",
       "      <td>40.696192</td>\n",
       "      <td>-73.991218</td>\n",
       "      <td>3396</td>\n",
       "      <td>Clinton St &amp; 4 Place</td>\n",
       "      <td>40.678356</td>\n",
       "      <td>-74.000145</td>\n",
       "      <td>33003</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1970.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824649</th>\n",
       "      <td>945</td>\n",
       "      <td>2018-05-31 23:59:31</td>\n",
       "      <td>2018-06-01 00:15:17</td>\n",
       "      <td>3128</td>\n",
       "      <td>21 St &amp; 43 Ave</td>\n",
       "      <td>40.750525</td>\n",
       "      <td>-73.945948</td>\n",
       "      <td>3459</td>\n",
       "      <td>E 53 St &amp; 3 Ave</td>\n",
       "      <td>40.757632</td>\n",
       "      <td>-73.969306</td>\n",
       "      <td>30876</td>\n",
       "      <td>Annual Membership - Save 15%</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824650</th>\n",
       "      <td>216</td>\n",
       "      <td>2018-05-31 23:59:38</td>\n",
       "      <td>2018-06-01 00:03:15</td>\n",
       "      <td>537</td>\n",
       "      <td>Lexington Ave &amp; E 24 St</td>\n",
       "      <td>40.740259</td>\n",
       "      <td>-73.984092</td>\n",
       "      <td>546</td>\n",
       "      <td>E 30 St &amp; Park Ave S</td>\n",
       "      <td>40.744449</td>\n",
       "      <td>-73.983035</td>\n",
       "      <td>31641</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824651</th>\n",
       "      <td>631</td>\n",
       "      <td>2018-05-31 23:59:41</td>\n",
       "      <td>2018-06-01 00:10:13</td>\n",
       "      <td>128</td>\n",
       "      <td>MacDougal St &amp; Prince St</td>\n",
       "      <td>40.727103</td>\n",
       "      <td>-74.002971</td>\n",
       "      <td>308</td>\n",
       "      <td>St James Pl &amp; Oliver St</td>\n",
       "      <td>40.713079</td>\n",
       "      <td>-73.998512</td>\n",
       "      <td>20826</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824652</th>\n",
       "      <td>986</td>\n",
       "      <td>2018-05-31 23:59:44</td>\n",
       "      <td>2018-06-01 00:16:11</td>\n",
       "      <td>3562</td>\n",
       "      <td>Classon Ave &amp; St Marks Ave</td>\n",
       "      <td>40.676520</td>\n",
       "      <td>-73.959608</td>\n",
       "      <td>3562</td>\n",
       "      <td>Classon Ave &amp; St Marks Ave</td>\n",
       "      <td>40.676520</td>\n",
       "      <td>-73.959608</td>\n",
       "      <td>32205</td>\n",
       "      <td>$25 Off Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824653</th>\n",
       "      <td>189</td>\n",
       "      <td>2018-05-31 23:59:44</td>\n",
       "      <td>2018-06-01 00:02:53</td>\n",
       "      <td>479</td>\n",
       "      <td>9 Ave &amp; W 45 St</td>\n",
       "      <td>40.760193</td>\n",
       "      <td>-73.991255</td>\n",
       "      <td>3635</td>\n",
       "      <td>W 36 St &amp; 9 Ave</td>\n",
       "      <td>40.754623</td>\n",
       "      <td>-73.995168</td>\n",
       "      <td>31327</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824654</th>\n",
       "      <td>483</td>\n",
       "      <td>2018-05-31 23:59:46</td>\n",
       "      <td>2018-06-01 00:07:49</td>\n",
       "      <td>3341</td>\n",
       "      <td>Central Park West &amp; W 102 St</td>\n",
       "      <td>40.795346</td>\n",
       "      <td>-73.961860</td>\n",
       "      <td>3400</td>\n",
       "      <td>E 110 St &amp; Madison Ave</td>\n",
       "      <td>40.796153</td>\n",
       "      <td>-73.947821</td>\n",
       "      <td>21000</td>\n",
       "      <td>Join Citi Bike for $14.95/month</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1967.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824655</th>\n",
       "      <td>465</td>\n",
       "      <td>2018-05-31 23:59:48</td>\n",
       "      <td>2018-06-01 00:07:34</td>\n",
       "      <td>3107</td>\n",
       "      <td>Bedford Ave &amp; Nassau Ave</td>\n",
       "      <td>40.723117</td>\n",
       "      <td>-73.952123</td>\n",
       "      <td>3076</td>\n",
       "      <td>Scholes St &amp; Manhattan Ave</td>\n",
       "      <td>40.708704</td>\n",
       "      <td>-73.944862</td>\n",
       "      <td>28285</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824656</th>\n",
       "      <td>497</td>\n",
       "      <td>2018-05-31 23:59:51</td>\n",
       "      <td>2018-06-01 00:08:09</td>\n",
       "      <td>483</td>\n",
       "      <td>E 12 St &amp; 3 Ave</td>\n",
       "      <td>40.732233</td>\n",
       "      <td>-73.988900</td>\n",
       "      <td>368</td>\n",
       "      <td>Carmine St &amp; 6 Ave</td>\n",
       "      <td>40.730386</td>\n",
       "      <td>-74.002150</td>\n",
       "      <td>19692</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1979.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824657</th>\n",
       "      <td>747</td>\n",
       "      <td>2018-05-31 23:59:59</td>\n",
       "      <td>2018-06-01 00:12:27</td>\n",
       "      <td>401</td>\n",
       "      <td>Allen St &amp; Rivington St</td>\n",
       "      <td>40.720196</td>\n",
       "      <td>-73.989978</td>\n",
       "      <td>360</td>\n",
       "      <td>William St &amp; Pine St</td>\n",
       "      <td>40.707179</td>\n",
       "      <td>-74.008873</td>\n",
       "      <td>17258</td>\n",
       "      <td>Annual Membership</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1635033 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         tripduration            starttime             stoptime  \\\n",
       "0                 303  2018-05-01 00:00:11  2018-05-01 00:05:15   \n",
       "1                 700  2018-05-01 00:00:36  2018-05-01 00:12:16   \n",
       "2                 443  2018-05-01 00:00:40  2018-05-01 00:08:04   \n",
       "3                 297  2018-05-01 00:00:43  2018-05-01 00:05:41   \n",
       "4                 421  2018-05-01 00:01:01  2018-05-01 00:08:02   \n",
       "5               68905  2018-05-01 00:01:11  2018-05-01 19:09:36   \n",
       "6                 197  2018-05-01 00:01:17  2018-05-01 00:04:35   \n",
       "7                 259  2018-05-01 00:01:31  2018-05-01 00:05:50   \n",
       "8                 359  2018-05-01 00:01:42  2018-05-01 00:07:42   \n",
       "9                 460  2018-05-01 00:02:03  2018-05-01 00:09:43   \n",
       "10                295  2018-05-01 00:02:04  2018-05-01 00:07:00   \n",
       "11                204  2018-05-01 00:02:17  2018-05-01 00:05:42   \n",
       "12                589  2018-05-01 00:02:22  2018-05-01 00:12:11   \n",
       "14               1596  2018-05-01 00:02:47  2018-05-01 00:29:24   \n",
       "15                342  2018-05-01 00:02:52  2018-05-01 00:08:34   \n",
       "16                905  2018-05-01 00:03:20  2018-05-01 00:18:25   \n",
       "17                535  2018-05-01 00:03:28  2018-05-01 00:12:23   \n",
       "18                254  2018-05-01 00:03:30  2018-05-01 00:07:44   \n",
       "19                352  2018-05-01 00:03:36  2018-05-01 00:09:29   \n",
       "20                686  2018-05-01 00:03:41  2018-05-01 00:15:07   \n",
       "21                297  2018-05-01 00:03:59  2018-05-01 00:08:57   \n",
       "22                484  2018-05-01 00:04:27  2018-05-01 00:12:32   \n",
       "24               1311  2018-05-01 00:05:18  2018-05-01 00:27:09   \n",
       "25                657  2018-05-01 00:05:20  2018-05-01 00:16:18   \n",
       "26                184  2018-05-01 00:05:20  2018-05-01 00:08:25   \n",
       "27               1371  2018-05-01 00:05:32  2018-05-01 00:28:24   \n",
       "28                940  2018-05-01 00:05:45  2018-05-01 00:21:25   \n",
       "29                317  2018-05-01 00:05:48  2018-05-01 00:11:05   \n",
       "30                726  2018-05-01 00:05:51  2018-05-01 00:17:58   \n",
       "31                971  2018-05-01 00:06:59  2018-05-01 00:23:10   \n",
       "...               ...                  ...                  ...   \n",
       "1824627           117  2018-05-31 23:58:26  2018-06-01 00:00:23   \n",
       "1824628           717  2018-05-31 23:58:27  2018-06-01 00:10:25   \n",
       "1824629           166  2018-05-31 23:58:28  2018-06-01 00:01:14   \n",
       "1824630          1206  2018-05-31 23:58:37  2018-06-01 00:18:44   \n",
       "1824631          1086  2018-05-31 23:58:47  2018-06-01 00:16:54   \n",
       "1824632          2218  2018-05-31 23:58:48  2018-06-01 00:35:46   \n",
       "1824634           429  2018-05-31 23:58:56  2018-06-01 00:06:05   \n",
       "1824635          1539  2018-05-31 23:59:00  2018-06-01 00:24:39   \n",
       "1824636           219  2018-05-31 23:58:59  2018-06-01 00:02:39   \n",
       "1824637           599  2018-05-31 23:59:05  2018-06-01 00:09:05   \n",
       "1824638          3544  2018-05-31 23:59:05  2018-06-01 00:58:10   \n",
       "1824639           509  2018-05-31 23:59:09  2018-06-01 00:07:38   \n",
       "1824640           421  2018-05-31 23:59:11  2018-06-01 00:06:12   \n",
       "1824641          2198  2018-05-31 23:59:09  2018-06-01 00:35:48   \n",
       "1824642           476  2018-05-31 23:59:13  2018-06-01 00:07:10   \n",
       "1824643           437  2018-05-31 23:59:13  2018-06-01 00:06:31   \n",
       "1824644           821  2018-05-31 23:59:16  2018-06-01 00:12:57   \n",
       "1824645           289  2018-05-31 23:59:21  2018-06-01 00:04:10   \n",
       "1824646           269  2018-05-31 23:59:24  2018-06-01 00:03:53   \n",
       "1824647           273  2018-05-31 23:59:27  2018-06-01 00:04:01   \n",
       "1824648          1318  2018-05-31 23:59:31  2018-06-01 00:21:30   \n",
       "1824649           945  2018-05-31 23:59:31  2018-06-01 00:15:17   \n",
       "1824650           216  2018-05-31 23:59:38  2018-06-01 00:03:15   \n",
       "1824651           631  2018-05-31 23:59:41  2018-06-01 00:10:13   \n",
       "1824652           986  2018-05-31 23:59:44  2018-06-01 00:16:11   \n",
       "1824653           189  2018-05-31 23:59:44  2018-06-01 00:02:53   \n",
       "1824654           483  2018-05-31 23:59:46  2018-06-01 00:07:49   \n",
       "1824655           465  2018-05-31 23:59:48  2018-06-01 00:07:34   \n",
       "1824656           497  2018-05-31 23:59:51  2018-06-01 00:08:09   \n",
       "1824657           747  2018-05-31 23:59:59  2018-06-01 00:12:27   \n",
       "\n",
       "         start station id             start station name  \\\n",
       "0                     491           E 24 St & Park Ave S   \n",
       "1                     507                E 25 St & 2 Ave   \n",
       "2                    3263       Cooper Square & Astor Pl   \n",
       "3                     532                S 5 Pl & S 5 St   \n",
       "4                    3493               E 118 St & 3 Ave   \n",
       "5                     237                E 11 St & 2 Ave   \n",
       "6                     437        Macon St & Nostrand Ave   \n",
       "7                     236            St Marks Pl & 2 Ave   \n",
       "8                    3158             W 63 St & Broadway   \n",
       "9                     285             Broadway & E 14 St   \n",
       "10                    499             Broadway & W 60 St   \n",
       "11                   3146                E 81 St & 3 Ave   \n",
       "12                    462               W 22 St & 10 Ave   \n",
       "14                    439                 E 4 St & 2 Ave   \n",
       "15                    474                5 Ave & E 29 St   \n",
       "16                   3081          Graham Ave & Grand St   \n",
       "17                    416  Cumberland St & Lafayette Ave   \n",
       "18                   2002   Wythe Ave & Metropolitan Ave   \n",
       "19                    403                 E 2 St & 2 Ave   \n",
       "20                    468             Broadway & W 56 St   \n",
       "21                    498             Broadway & W 32 St   \n",
       "22                   3419            Douglass St & 4 Ave   \n",
       "24                   2003                1 Ave & E 18 St   \n",
       "25                   3335               Union St & 4 Ave   \n",
       "26                   3316       W 104 St & Amsterdam Ave   \n",
       "27                    128       MacDougal St & Prince St   \n",
       "28                    518                E 39 St & 2 Ave   \n",
       "29                    435                W 21 St & 6 Ave   \n",
       "30                    477                W 41 St & 8 Ave   \n",
       "31                    439                 E 4 St & 2 Ave   \n",
       "...                   ...                            ...   \n",
       "1824627               336    Sullivan St & Washington Sq   \n",
       "1824628              3306                  10 St & 7 Ave   \n",
       "1824629              3671                E 81 St & 2 Ave   \n",
       "1824630              3125                  45 Rd & 11 St   \n",
       "1824631               498             Broadway & W 32 St   \n",
       "1824632              3125                  45 Rd & 11 St   \n",
       "1824634              3467     W Broadway & Spring Street   \n",
       "1824635               529                W 42 St & 8 Ave   \n",
       "1824636               353     S Portland Ave & Hanson Pl   \n",
       "1824637              3260        Mercer St & Bleecker St   \n",
       "1824638              3589               Broadway & 12 St   \n",
       "1824639              3100         Nassau Ave & Newell St   \n",
       "1824640               505                6 Ave & W 33 St   \n",
       "1824641              3125                  45 Rd & 11 St   \n",
       "1824642               257        Lispenard St & Broadway   \n",
       "1824643               257        Lispenard St & Broadway   \n",
       "1824644               458               11 Ave & W 27 St   \n",
       "1824645               279           Peck Slip & Front St   \n",
       "1824646               492                W 33 St & 7 Ave   \n",
       "1824647               481           S 3 St & Bedford Ave   \n",
       "1824648               322        Clinton St & Tillary St   \n",
       "1824649              3128                 21 St & 43 Ave   \n",
       "1824650               537        Lexington Ave & E 24 St   \n",
       "1824651               128       MacDougal St & Prince St   \n",
       "1824652              3562     Classon Ave & St Marks Ave   \n",
       "1824653               479                9 Ave & W 45 St   \n",
       "1824654              3341   Central Park West & W 102 St   \n",
       "1824655              3107       Bedford Ave & Nassau Ave   \n",
       "1824656               483                E 12 St & 3 Ave   \n",
       "1824657               401        Allen St & Rivington St   \n",
       "\n",
       "         start station latitude  start station longitude  end station id  \\\n",
       "0                     40.740964               -73.986022            2003   \n",
       "1                     40.739126               -73.979738            3458   \n",
       "2                     40.729515               -73.990753             546   \n",
       "3                     40.710451               -73.960876            3096   \n",
       "4                     40.799139               -73.938915            3351   \n",
       "5                     40.730473               -73.986724             504   \n",
       "6                     40.680983               -73.950048            3241   \n",
       "7                     40.728419               -73.987140             312   \n",
       "8                     40.771639               -73.982614             495   \n",
       "9                     40.734546               -73.990741             236   \n",
       "10                    40.769155               -73.981918            3175   \n",
       "11                    40.775730               -73.956753            3135   \n",
       "12                    40.746920               -74.004519             450   \n",
       "14                    40.726281               -73.989780            3074   \n",
       "15                    40.745168               -73.986831             293   \n",
       "16                    40.711863               -73.944024            3241   \n",
       "17                    40.687534               -73.972652             373   \n",
       "18                    40.716887               -73.963198            3087   \n",
       "19                    40.725029               -73.990697             150   \n",
       "20                    40.765265               -73.981923            3658   \n",
       "21                    40.748549               -73.988084             527   \n",
       "22                    40.679279               -73.981540            3304   \n",
       "24                    40.733812               -73.980544            3140   \n",
       "25                    40.677274               -73.982820            3306   \n",
       "26                    40.798994               -73.966217            3323   \n",
       "27                    40.727103               -74.002971             481   \n",
       "28                    40.747804               -73.973442             394   \n",
       "29                    40.741740               -73.994156             285   \n",
       "30                    40.756405               -73.990026             466   \n",
       "31                    40.726281               -73.989780             435   \n",
       "...                         ...                      ...             ...   \n",
       "1824627               40.730477               -73.999061            3244   \n",
       "1824628               40.666208               -73.981999            3418   \n",
       "1824629               40.774779               -73.954275            3147   \n",
       "1824630               40.747086               -73.949772             460   \n",
       "1824631               40.748549               -73.988084            3370   \n",
       "1824632               40.747086               -73.949772             401   \n",
       "1824634               40.724947               -74.001659             296   \n",
       "1824635               40.757570               -73.990985             363   \n",
       "1824636               40.685396               -73.974315            3415   \n",
       "1824637               40.727064               -73.996621             453   \n",
       "1824638               40.766800               -73.934777            3300   \n",
       "1824639               40.724813               -73.947526             532   \n",
       "1824640               40.749013               -73.988484             448   \n",
       "1824641               40.747086               -73.949772             401   \n",
       "1824642               40.719392               -74.002472             257   \n",
       "1824643               40.719392               -74.002472             257   \n",
       "1824644               40.751396               -74.005226            3462   \n",
       "1824645               40.707873               -74.001670             296   \n",
       "1824646               40.750200               -73.990931            3258   \n",
       "1824647               40.712605               -73.962644            3016   \n",
       "1824648               40.696192               -73.991218            3396   \n",
       "1824649               40.750525               -73.945948            3459   \n",
       "1824650               40.740259               -73.984092             546   \n",
       "1824651               40.727103               -74.002971             308   \n",
       "1824652               40.676520               -73.959608            3562   \n",
       "1824653               40.760193               -73.991255            3635   \n",
       "1824654               40.795346               -73.961860            3400   \n",
       "1824655               40.723117               -73.952123            3076   \n",
       "1824656               40.732233               -73.988900             368   \n",
       "1824657               40.720196               -73.989978             360   \n",
       "\n",
       "                      end station name  end station latitude  \\\n",
       "0                      1 Ave & E 18 St             40.733812   \n",
       "1                      W 55 St & 6 Ave             40.763094   \n",
       "2                 E 30 St & Park Ave S             40.744449   \n",
       "3                  Union Ave & N 12 St             40.719240   \n",
       "4                     E 102 St & 1 Ave             40.786995   \n",
       "5                      1 Ave & E 16 St             40.732219   \n",
       "6             Monroe St & Tompkins Ave             40.686203   \n",
       "7                Allen St & Stanton St             40.722055   \n",
       "8                     W 47 St & 10 Ave             40.762699   \n",
       "9                  St Marks Pl & 2 Ave             40.728419   \n",
       "10             W 70 St & Amsterdam Ave             40.777480   \n",
       "11                     E 75 St & 3 Ave             40.771129   \n",
       "12                     W 49 St & 8 Ave             40.762272   \n",
       "14         Montrose Ave & Bushwick Ave             40.707678   \n",
       "15               Lafayette St & E 8 St             40.730207   \n",
       "16            Monroe St & Tompkins Ave             40.686203   \n",
       "17        Willoughby Ave & Walworth St             40.693317   \n",
       "18       Metropolitan Ave & Meeker Ave             40.714133   \n",
       "19                   E 2 St & Avenue C             40.720874   \n",
       "20                     W 18 St & 9 Ave             40.743534   \n",
       "21                     E 33 St & 2 Ave             40.744023   \n",
       "22                        6 Ave & 9 St             40.668127   \n",
       "24                     1 Ave & E 78 St             40.771404   \n",
       "25                       10 St & 7 Ave             40.666208   \n",
       "26        W 106 St & Central Park West             40.798186   \n",
       "27                S 3 St & Bedford Ave             40.712605   \n",
       "28                   E 9 St & Avenue C             40.725213   \n",
       "29                  Broadway & E 14 St             40.734546   \n",
       "30                     W 25 St & 6 Ave             40.743954   \n",
       "31                     W 21 St & 6 Ave             40.741740   \n",
       "...                                ...                   ...   \n",
       "1824627         University Pl & E 8 St             40.731437   \n",
       "1824628   Plaza St West & Flatbush Ave             40.675021   \n",
       "1824629                E 85 St & 3 Ave             40.778012   \n",
       "1824630             S 4 St & Wythe Ave             40.712859   \n",
       "1824631                E 78 St & 2 Ave             40.772797   \n",
       "1824632        Allen St & Rivington St             40.720196   \n",
       "1824634           Division St & Bowery             40.714131   \n",
       "1824635                 West Thames St             40.708347   \n",
       "1824636            Prospect Pl & 6 Ave             40.679331   \n",
       "1824637                W 22 St & 8 Ave             40.744751   \n",
       "1824638      Prospect Park West & 8 St             40.665147   \n",
       "1824639                S 5 Pl & S 5 St             40.710451   \n",
       "1824640               W 37 St & 10 Ave             40.756604   \n",
       "1824641        Allen St & Rivington St             40.720196   \n",
       "1824642        Lispenard St & Broadway             40.719392   \n",
       "1824643        Lispenard St & Broadway             40.719392   \n",
       "1824644                E 44 St & 2 Ave             40.751184   \n",
       "1824645           Division St & Bowery             40.714131   \n",
       "1824646               W 27 St & 10 Ave             40.750182   \n",
       "1824647              Kent Ave & N 7 St             40.720368   \n",
       "1824648           Clinton St & 4 Place             40.678356   \n",
       "1824649                E 53 St & 3 Ave             40.757632   \n",
       "1824650           E 30 St & Park Ave S             40.744449   \n",
       "1824651        St James Pl & Oliver St             40.713079   \n",
       "1824652     Classon Ave & St Marks Ave             40.676520   \n",
       "1824653                W 36 St & 9 Ave             40.754623   \n",
       "1824654         E 110 St & Madison Ave             40.796153   \n",
       "1824655     Scholes St & Manhattan Ave             40.708704   \n",
       "1824656             Carmine St & 6 Ave             40.730386   \n",
       "1824657           William St & Pine St             40.707179   \n",
       "\n",
       "         end station longitude  bikeid                  name_localizedValue0  \\\n",
       "0                   -73.980544   32191             $25 Off Annual Membership   \n",
       "1                   -73.978350   29357                     Annual Membership   \n",
       "2                   -73.983035   27255                     Annual Membership   \n",
       "3                   -73.952420   16980                     Annual Membership   \n",
       "4                   -73.941648   30645                     Annual Membership   \n",
       "5                   -73.981656   27440                     Annual Membership   \n",
       "6                   -73.944694   31566                     Annual Membership   \n",
       "7                   -73.989111   29872             $25 Off Annual Membership   \n",
       "8                   -73.993012   14824                     Annual Membership   \n",
       "9                   -73.987140   17638                     Annual Membership   \n",
       "10                  -73.982886   31475                     Annual Membership   \n",
       "11                  -73.957723   14886                     Annual Membership   \n",
       "12                  -73.987882   27251                     Annual Membership   \n",
       "14                  -73.940162   20843  Annual Membership from Citi Bike App   \n",
       "15                  -73.991026   30253                     Annual Membership   \n",
       "16                  -73.944694   30190                     Annual Membership   \n",
       "17                  -73.953820   29359                     Annual Membership   \n",
       "18                  -73.952344   20523                     Annual Membership   \n",
       "19                  -73.980858   25750                     Annual Membership   \n",
       "20                  -74.003676   32316                     Annual Membership   \n",
       "21                  -73.976056   28271                     Annual Membership   \n",
       "22                  -73.983776   19678                     Annual Membership   \n",
       "24                  -73.953517   24888             $25 Off Annual Membership   \n",
       "25                  -73.981999   31596                     Annual Membership   \n",
       "26                  -73.960591   17098             $25 Off Annual Membership   \n",
       "27                  -73.962644   30618             $25 Off Annual Membership   \n",
       "28                  -73.977688   25065             $25 Off Annual Membership   \n",
       "29                  -73.990741   29778  Annual Membership from Citi Bike App   \n",
       "30                  -73.991449   16394                     Annual Membership   \n",
       "31                  -73.994156   32796                     Annual Membership   \n",
       "...                        ...     ...                                   ...   \n",
       "1824627             -73.994903   27747                     Annual Membership   \n",
       "1824628             -73.971115   18250                     Annual Membership   \n",
       "1824629             -73.954071   32485                     Annual Membership   \n",
       "1824630             -73.965903   17035                     Annual Membership   \n",
       "1824631             -73.955778   14553                     Annual Membership   \n",
       "1824632             -73.989978   15768       Join Citi Bike for $14.95/month   \n",
       "1824634             -73.997047   28850                     Annual Membership   \n",
       "1824635             -74.017134   31384                     Annual Membership   \n",
       "1824636             -73.975195   14628                     Annual Membership   \n",
       "1824637             -73.999154   30870  Annual Membership from Citi Bike App   \n",
       "1824638             -73.976376   30117                           Single Ride   \n",
       "1824639             -73.960876   27214                     Annual Membership   \n",
       "1824640             -73.997901   31054             $25 Off Annual Membership   \n",
       "1824641             -73.989978   21302                     Annual Membership   \n",
       "1824642             -74.002472   30140           Citi Bike Annual Membership   \n",
       "1824643             -74.002472   33033                     Annual Membership   \n",
       "1824644             -73.971387   32355                     Annual Membership   \n",
       "1824645             -73.997047   19816                     Annual Membership   \n",
       "1824646             -74.002184   30033  Annual Membership from Citi Bike App   \n",
       "1824647             -73.961651   15662                     Annual Membership   \n",
       "1824648             -74.000145   33003                     Annual Membership   \n",
       "1824649             -73.969306   30876          Annual Membership - Save 15%   \n",
       "1824650             -73.983035   31641                     Annual Membership   \n",
       "1824651             -73.998512   20826                     Annual Membership   \n",
       "1824652             -73.959608   32205             $25 Off Annual Membership   \n",
       "1824653             -73.995168   31327                     Annual Membership   \n",
       "1824654             -73.947821   21000       Join Citi Bike for $14.95/month   \n",
       "1824655             -73.944862   28285                     Annual Membership   \n",
       "1824656             -74.002150   19692                     Annual Membership   \n",
       "1824657             -74.008873   17258                     Annual Membership   \n",
       "\n",
       "           usertype  birth year  gender  \n",
       "0        Subscriber      1984.0       1  \n",
       "1        Subscriber      1996.0       1  \n",
       "2        Subscriber      1969.0       1  \n",
       "3        Subscriber      1985.0       1  \n",
       "4        Subscriber      1986.0       1  \n",
       "5        Subscriber      1969.0       1  \n",
       "6        Subscriber      1988.0       1  \n",
       "7        Subscriber      1996.0       2  \n",
       "8        Subscriber      1981.0       2  \n",
       "9        Subscriber      1972.0       2  \n",
       "10       Subscriber      1958.0       1  \n",
       "11       Subscriber      1991.0       1  \n",
       "12       Subscriber      1981.0       1  \n",
       "14       Subscriber      1995.0       1  \n",
       "15       Subscriber      1991.0       1  \n",
       "16       Subscriber      1987.0       1  \n",
       "17       Subscriber      1975.0       1  \n",
       "18       Subscriber      1972.0       1  \n",
       "19       Subscriber      1995.0       1  \n",
       "20       Subscriber      1982.0       1  \n",
       "21       Subscriber      1967.0       1  \n",
       "22       Subscriber      1978.0       1  \n",
       "24       Subscriber      1972.0       2  \n",
       "25       Subscriber      1980.0       1  \n",
       "26       Subscriber      1993.0       1  \n",
       "27       Subscriber      1991.0       1  \n",
       "28       Subscriber      1991.0       1  \n",
       "29       Subscriber      1996.0       1  \n",
       "30       Subscriber      1969.0       1  \n",
       "31       Subscriber      1980.0       1  \n",
       "...             ...         ...     ...  \n",
       "1824627  Subscriber      1987.0       1  \n",
       "1824628  Subscriber      2000.0       1  \n",
       "1824629  Subscriber      1991.0       1  \n",
       "1824630  Subscriber      1991.0       2  \n",
       "1824631  Subscriber      1994.0       1  \n",
       "1824632  Subscriber      1978.0       2  \n",
       "1824634  Subscriber      1945.0       1  \n",
       "1824635  Subscriber      1989.0       1  \n",
       "1824636  Subscriber      1987.0       1  \n",
       "1824637  Subscriber      1987.0       1  \n",
       "1824638    Customer      1986.0       1  \n",
       "1824639  Subscriber      1982.0       1  \n",
       "1824640  Subscriber      1985.0       2  \n",
       "1824641  Subscriber      1991.0       2  \n",
       "1824642  Subscriber      1971.0       2  \n",
       "1824643  Subscriber      1969.0       2  \n",
       "1824644  Subscriber      1994.0       1  \n",
       "1824645  Subscriber      1983.0       2  \n",
       "1824646  Subscriber      1992.0       1  \n",
       "1824647  Subscriber      1991.0       1  \n",
       "1824648  Subscriber      1970.0       1  \n",
       "1824649  Subscriber      1987.0       1  \n",
       "1824650  Subscriber      1981.0       1  \n",
       "1824651  Subscriber      1986.0       1  \n",
       "1824652  Subscriber      1993.0       1  \n",
       "1824653  Subscriber      1984.0       1  \n",
       "1824654  Subscriber      1967.0       2  \n",
       "1824655  Subscriber      1990.0       1  \n",
       "1824656  Subscriber      1979.0       1  \n",
       "1824657  Subscriber      1994.0       1  \n",
       "\n",
       "[1635033 rows x 16 columns]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_bike.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from datetime import *\n",
    "import time\n",
    "\n",
    "hour = []\n",
    "weekend = []\n",
    "for start_time in data_bike['starttime']:\n",
    "    t1 = datetime.strptime(start_time,'%Y-%m-%d %H:%M:%S')\n",
    "    hour.append(t1.hour)\n",
    "    if t1.weekday() in [5,6]:\n",
    "        weekend.append(1)\n",
    "    else:\n",
    "        weekend.append(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "new_date_array = []\n",
    "\n",
    "for start_time in data_bike['starttime']:\n",
    "    t1 = datetime.strptime(start_time,'%Y-%m-%d %H:%M:%S')\n",
    "    \n",
    "    if ((len(str(t1.hour)) == 1) & (len(str(t1.day)) == 2) & (len(str(t1.month)) == 2)):\n",
    "        new_date_array.append(str(t1.year)+'-'+str(t1.month)+'-'+str(t1.day)+'-0'+str(t1.hour))\n",
    "        \n",
    "    elif ((len(str(t1.day)) == 1) & (len(str(t1.month)) == 2) & (len(str(t1.hour)) == 2)):\n",
    "        new_date_array.append(str(t1.year)+'-'+str(t1.month)+'-0'+str(t1.day)+'-'+str(t1.hour))\n",
    "        \n",
    "    elif ((len(str(t1.month)) == 1) & (len(str(t1.day)) == 2) & (len(str(t1.hour)) == 2)):\n",
    "        new_date_array.append(str(t1.year)+'-0'+str(t1.month)+'-'+str(t1.day)+'-'+str(t1.hour))\n",
    "        \n",
    "    elif ((len(str(t1.month)) == 1) & (len(str(t1.day)) == 1) & (len(str(t1.hour)) == 2)):\n",
    "        new_date_array.append(str(t1.year)+'-0'+str(t1.month)+'-0'+str(t1.day)+'-'+str(t1.hour))\n",
    "        \n",
    "    elif ((len(str(t1.month)) == 1) & (len(str(t1.day)) == 2) & (len(str(t1.hour)) == 1)):\n",
    "        new_date_array.append(str(t1.year)+'-0'+str(t1.month)+'-'+str(t1.day)+'-0'+str(t1.hour))\n",
    "        \n",
    "    elif ((len(str(t1.month)) == 2) & (len(str(t1.day)) == 1) & (len(str(t1.hour)) == 1)):\n",
    "        new_date_array.append(str(t1.year)+'-'+str(t1.month)+'-0'+str(t1.day)+'-0'+str(t1.hour))\n",
    "    \n",
    "    elif ((len(str(t1.month)) == 1) & (len(str(t1.day)) == 1) & (len(str(t1.hour)) == 1)):\n",
    "        new_date_array.append(str(t1.year)+'-0'+str(t1.month)+'-0'+str(t1.day)+'-0'+str(t1.hour))\n",
    "        \n",
    "    elif ((len(str(t1.month)) == 2) & (len(str(t1.day)) == 2) & (len(str(t1.hour)) == 2)):\n",
    "        new_date_array.append(str(t1.year)+'-'+str(t1.month)+'-'+str(t1.day)+'-'+str(t1.hour))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>date</th>\n",
       "      <th>duration</th>\n",
       "      <th>end_lat</th>\n",
       "      <th>end_long</th>\n",
       "      <th>gender</th>\n",
       "      <th>hour</th>\n",
       "      <th>new_date</th>\n",
       "      <th>start_lat</th>\n",
       "      <th>start_long</th>\n",
       "      <th>weekend</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34.0</td>\n",
       "      <td>2018-05-01 00:00:11</td>\n",
       "      <td>303</td>\n",
       "      <td>40.733812</td>\n",
       "      <td>-73.980544</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>40.740964</td>\n",
       "      <td>-73.986022</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>22.0</td>\n",
       "      <td>2018-05-01 00:00:36</td>\n",
       "      <td>700</td>\n",
       "      <td>40.763094</td>\n",
       "      <td>-73.978350</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>40.739126</td>\n",
       "      <td>-73.979738</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>49.0</td>\n",
       "      <td>2018-05-01 00:00:40</td>\n",
       "      <td>443</td>\n",
       "      <td>40.744449</td>\n",
       "      <td>-73.983035</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>40.729515</td>\n",
       "      <td>-73.990753</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>33.0</td>\n",
       "      <td>2018-05-01 00:00:43</td>\n",
       "      <td>297</td>\n",
       "      <td>40.719240</td>\n",
       "      <td>-73.952420</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>40.710451</td>\n",
       "      <td>-73.960876</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>32.0</td>\n",
       "      <td>2018-05-01 00:01:01</td>\n",
       "      <td>421</td>\n",
       "      <td>40.786995</td>\n",
       "      <td>-73.941648</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>40.799139</td>\n",
       "      <td>-73.938915</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    age                 date  duration    end_lat   end_long  gender  hour  \\\n",
       "0  34.0  2018-05-01 00:00:11       303  40.733812 -73.980544       0     0   \n",
       "1  22.0  2018-05-01 00:00:36       700  40.763094 -73.978350       0     0   \n",
       "2  49.0  2018-05-01 00:00:40       443  40.744449 -73.983035       0     0   \n",
       "3  33.0  2018-05-01 00:00:43       297  40.719240 -73.952420       0     0   \n",
       "4  32.0  2018-05-01 00:01:01       421  40.786995 -73.941648       0     0   \n",
       "\n",
       "        new_date  start_lat  start_long  weekend  \n",
       "0  2018-05-01-00  40.740964  -73.986022        0  \n",
       "1  2018-05-01-00  40.739126  -73.979738        0  \n",
       "2  2018-05-01-00  40.729515  -73.990753        0  \n",
       "3  2018-05-01-00  40.710451  -73.960876        0  \n",
       "4  2018-05-01-00  40.799139  -73.938915        0  "
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clean_data_bike = pd.DataFrame({\n",
    "    \"date\":data_bike['starttime'],\\\n",
    "    \"duration\":data_bike['tripduration'],\\\n",
    "    \"weekend\":weekend,\\\n",
    "    \"hour\":hour,\\\n",
    "    \"start_lat\":data_bike['start station latitude'],\\\n",
    "    \"start_long\":data_bike['start station longitude'],\\\n",
    "    \"end_lat\":data_bike['end station latitude'],\\\n",
    "    \"end_long\":data_bike['end station longitude'],\\\n",
    "    \"gender\":(data_bike['gender']-1),\\\n",
    "    \"age\":(2018 - data_bike['birth year']),\\\n",
    "    \"new_date\" : new_date_array\n",
    "})\n",
    "clean_data_bike.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date/Time</th>\n",
       "      <th>Air Temp (℉)</th>\n",
       "      <th>Dewpoint (℉)</th>\n",
       "      <th>Precip (inches)</th>\n",
       "      <th>RH (%)</th>\n",
       "      <th>Wind Spd (mph)</th>\n",
       "      <th>Wind Dir (degrees)</th>\n",
       "      <th>new_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>05/01/2018 00:00 EDT</td>\n",
       "      <td>49</td>\n",
       "      <td>38</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66</td>\n",
       "      <td>3.5</td>\n",
       "      <td>-1</td>\n",
       "      <td>05/01/2018 00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>05/01/2018 01:00 EDT</td>\n",
       "      <td>48</td>\n",
       "      <td>37</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66</td>\n",
       "      <td>4.6</td>\n",
       "      <td>270</td>\n",
       "      <td>05/01/2018 01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>05/01/2018 02:00 EDT</td>\n",
       "      <td>50</td>\n",
       "      <td>36</td>\n",
       "      <td>0.0</td>\n",
       "      <td>58</td>\n",
       "      <td>3.5</td>\n",
       "      <td>260</td>\n",
       "      <td>05/01/2018 02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>05/01/2018 03:00 EDT</td>\n",
       "      <td>49</td>\n",
       "      <td>36</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61</td>\n",
       "      <td>4.6</td>\n",
       "      <td>260</td>\n",
       "      <td>05/01/2018 03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>05/01/2018 04:00 EDT</td>\n",
       "      <td>50</td>\n",
       "      <td>36</td>\n",
       "      <td>0.0</td>\n",
       "      <td>58</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>05/01/2018 04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Date/Time  Air Temp (℉) Dewpoint (℉)  Precip (inches)  RH (%)  \\\n",
       "0  05/01/2018 00:00 EDT            49           38              0.0      66   \n",
       "1  05/01/2018 01:00 EDT            48           37              0.0      66   \n",
       "2  05/01/2018 02:00 EDT            50           36              0.0      58   \n",
       "3  05/01/2018 03:00 EDT            49           36              0.0      61   \n",
       "4  05/01/2018 04:00 EDT            50           36              0.0      58   \n",
       "\n",
       "   Wind Spd (mph)  Wind Dir (degrees)       new_date  \n",
       "0             3.5                  -1  05/01/2018 00  \n",
       "1             4.6                 270  05/01/2018 01  \n",
       "2             3.5                 260  05/01/2018 02  \n",
       "3             4.6                 260  05/01/2018 03  \n",
       "4             0.0                   0  05/01/2018 04  "
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_weather['new_date'] = data_weather['Date/Time'].str.extract('(../../.... ..)', expand=True)\n",
    "data_weather.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\emrcl\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date/Time</th>\n",
       "      <th>Air Temp (℉)</th>\n",
       "      <th>Dewpoint (℉)</th>\n",
       "      <th>Precip (inches)</th>\n",
       "      <th>RH (%)</th>\n",
       "      <th>Wind Spd (mph)</th>\n",
       "      <th>Wind Dir (degrees)</th>\n",
       "      <th>new_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>05/01/2018 00:00 EDT</td>\n",
       "      <td>49</td>\n",
       "      <td>38</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66</td>\n",
       "      <td>3.5</td>\n",
       "      <td>-1</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>05/01/2018 01:00 EDT</td>\n",
       "      <td>48</td>\n",
       "      <td>37</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66</td>\n",
       "      <td>4.6</td>\n",
       "      <td>270</td>\n",
       "      <td>2018-05-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>05/01/2018 02:00 EDT</td>\n",
       "      <td>50</td>\n",
       "      <td>36</td>\n",
       "      <td>0.0</td>\n",
       "      <td>58</td>\n",
       "      <td>3.5</td>\n",
       "      <td>260</td>\n",
       "      <td>2018-05-01-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>05/01/2018 03:00 EDT</td>\n",
       "      <td>49</td>\n",
       "      <td>36</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61</td>\n",
       "      <td>4.6</td>\n",
       "      <td>260</td>\n",
       "      <td>2018-05-01-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>05/01/2018 04:00 EDT</td>\n",
       "      <td>50</td>\n",
       "      <td>36</td>\n",
       "      <td>0.0</td>\n",
       "      <td>58</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2018-05-01-04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Date/Time  Air Temp (℉) Dewpoint (℉)  Precip (inches)  RH (%)  \\\n",
       "0  05/01/2018 00:00 EDT            49           38              0.0      66   \n",
       "1  05/01/2018 01:00 EDT            48           37              0.0      66   \n",
       "2  05/01/2018 02:00 EDT            50           36              0.0      58   \n",
       "3  05/01/2018 03:00 EDT            49           36              0.0      61   \n",
       "4  05/01/2018 04:00 EDT            50           36              0.0      58   \n",
       "\n",
       "   Wind Spd (mph)  Wind Dir (degrees)       new_date  \n",
       "0             3.5                  -1  2018-05-01-00  \n",
       "1             4.6                 270  2018-05-01-01  \n",
       "2             3.5                 260  2018-05-01-02  \n",
       "3             4.6                 260  2018-05-01-03  \n",
       "4             0.0                   0  2018-05-01-04  "
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i in range(0,len(data_weather['Date/Time'])):\n",
    "    data_weather['new_date'][i] = data_weather['Date/Time'][i][6:10]+'-'+\\\n",
    "    data_weather['Date/Time'][i][0:2]+'-'+\\\n",
    "    data_weather['Date/Time'][i][3:5]+'-'+\\\n",
    "    data_weather['Date/Time'][i][11:13]\n",
    "data_weather.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Air Temp F</th>\n",
       "      <th>Date-Time</th>\n",
       "      <th>Wind Spd (mph)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>49</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48</td>\n",
       "      <td>2018-05-01-01</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50</td>\n",
       "      <td>2018-05-01-02</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>49</td>\n",
       "      <td>2018-05-01-03</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>50</td>\n",
       "      <td>2018-05-01-04</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Air Temp F      Date-Time  Wind Spd (mph)\n",
       "0          49  2018-05-01-00             3.5\n",
       "1          48  2018-05-01-01             4.6\n",
       "2          50  2018-05-01-02             3.5\n",
       "3          49  2018-05-01-03             4.6\n",
       "4          50  2018-05-01-04             0.0"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cleaned_data_weather = pd.DataFrame({\n",
    "    'Date-Time':data_weather['new_date'],\n",
    "    'Air Temp F':data_weather['Air Temp (℉)'],\n",
    "    'Wind Spd (mph)':data_weather['Wind Spd (mph)']\n",
    "})\n",
    "cleaned_data_weather.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Age</th>\n",
       "      <th>Date-Time</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Weekend</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34.0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>303</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>22.0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>700</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>49.0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>443</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>33.0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>297</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>32.0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>421</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Age      Date-Time  Duration  Weekend\n",
       "0  34.0  2018-05-01-00       303        0\n",
       "1  22.0  2018-05-01-00       700        0\n",
       "2  49.0  2018-05-01-00       443        0\n",
       "3  33.0  2018-05-01-00       297        0\n",
       "4  32.0  2018-05-01-00       421        0"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cleaned_data_bike = pd.DataFrame({\n",
    "    'Date-Time':clean_data_bike['new_date'],\n",
    "    'Age':clean_data_bike['age'],\n",
    "    'Duration':clean_data_bike['duration'],\n",
    "    'Weekend':clean_data_bike['weekend']\n",
    "})\n",
    "cleaned_data_bike_2 = cleaned_data_bike.dropna()\n",
    "cleaned_data_bike_2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Age</th>\n",
       "      <th>Date-Time</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Weekend</th>\n",
       "      <th>Air Temp F</th>\n",
       "      <th>Wind Spd (mph)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34.0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>303</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>22.0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>700</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>49.0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>443</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>33.0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>297</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>32.0</td>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>421</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Age      Date-Time  Duration  Weekend  Air Temp F  Wind Spd (mph)\n",
       "0  34.0  2018-05-01-00       303        0          49             3.5\n",
       "1  22.0  2018-05-01-00       700        0          49             3.5\n",
       "2  49.0  2018-05-01-00       443        0          49             3.5\n",
       "3  33.0  2018-05-01-00       297        0          49             3.5\n",
       "4  32.0  2018-05-01-00       421        0          49             3.5"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df = pd.merge(cleaned_data_bike_2, cleaned_data_weather, on='Date-Time')\n",
    "merged_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Duration</th>\n",
       "      <th>Air Temp F</th>\n",
       "      <th>Wind Spd (mph)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date-Time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-05-01-00</th>\n",
       "      <td>938.207373</td>\n",
       "      <td>49</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-01-01</th>\n",
       "      <td>976.901961</td>\n",
       "      <td>48</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-01-02</th>\n",
       "      <td>592.430556</td>\n",
       "      <td>50</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-01-03</th>\n",
       "      <td>464.676923</td>\n",
       "      <td>49</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-01-04</th>\n",
       "      <td>617.026667</td>\n",
       "      <td>50</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Duration  Air Temp F  Wind Spd (mph)\n",
       "Date-Time                                            \n",
       "2018-05-01-00  938.207373          49             3.5\n",
       "2018-05-01-01  976.901961          48             4.6\n",
       "2018-05-01-02  592.430556          50             3.5\n",
       "2018-05-01-03  464.676923          49             4.6\n",
       "2018-05-01-04  617.026667          50             0.0"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Added example for two output columns from a single input column\n",
    "grouped_df = merged_df.groupby(['Date-Time']).agg({'Duration': np.mean, 'Air Temp F': np.mean,'Wind Spd (mph)': np.mean}) \n",
    "grouped_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "grouped_df.to_csv('Grouped_Data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date-Time</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Air Temp F</th>\n",
       "      <th>Wind Spd (mph)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>938.207373</td>\n",
       "      <td>49</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-05-01-01</td>\n",
       "      <td>976.901961</td>\n",
       "      <td>48</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-05-01-02</td>\n",
       "      <td>592.430556</td>\n",
       "      <td>50</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018-05-01-03</td>\n",
       "      <td>464.676923</td>\n",
       "      <td>49</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-05-01-04</td>\n",
       "      <td>617.026667</td>\n",
       "      <td>50</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Date-Time    Duration  Air Temp F  Wind Spd (mph)\n",
       "0  2018-05-01-00  938.207373          49             3.5\n",
       "1  2018-05-01-01  976.901961          48             4.6\n",
       "2  2018-05-01-02  592.430556          50             3.5\n",
       "3  2018-05-01-03  464.676923          49             4.6\n",
       "4  2018-05-01-04  617.026667          50             0.0"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_csv('Grouped_Data.csv')\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\emrcl\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \n",
      "C:\\Users\\emrcl\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n"
     ]
    }
   ],
   "source": [
    "for i in range(0,len(data['Date-Time'])):\n",
    "    data['Hour'][i] = data['Date-Time'][i][11:13]\n",
    "    data['Date'][i] = data['Date-Time'][i][0:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date-Time</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Air Temp F</th>\n",
       "      <th>Wind Spd (mph)</th>\n",
       "      <th>Hour</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-05-01-00</td>\n",
       "      <td>938.207373</td>\n",
       "      <td>49</td>\n",
       "      <td>3.5</td>\n",
       "      <td>00</td>\n",
       "      <td>2018-05-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-05-01-01</td>\n",
       "      <td>976.901961</td>\n",
       "      <td>48</td>\n",
       "      <td>4.6</td>\n",
       "      <td>01</td>\n",
       "      <td>2018-05-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-05-01-02</td>\n",
       "      <td>592.430556</td>\n",
       "      <td>50</td>\n",
       "      <td>3.5</td>\n",
       "      <td>02</td>\n",
       "      <td>2018-05-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018-05-01-03</td>\n",
       "      <td>464.676923</td>\n",
       "      <td>49</td>\n",
       "      <td>4.6</td>\n",
       "      <td>03</td>\n",
       "      <td>2018-05-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-05-01-04</td>\n",
       "      <td>617.026667</td>\n",
       "      <td>50</td>\n",
       "      <td>0.0</td>\n",
       "      <td>04</td>\n",
       "      <td>2018-05-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Date-Time    Duration  Air Temp F  Wind Spd (mph) Hour        Date\n",
       "0  2018-05-01-00  938.207373          49             3.5   00  2018-05-01\n",
       "1  2018-05-01-01  976.901961          48             4.6   01  2018-05-01\n",
       "2  2018-05-01-02  592.430556          50             3.5   02  2018-05-01\n",
       "3  2018-05-01-03  464.676923          49             4.6   03  2018-05-01\n",
       "4  2018-05-01-04  617.026667          50             0.0   04  2018-05-01"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Duration</th>\n",
       "      <th>Air Temp F</th>\n",
       "      <th>Wind Spd (mph)</th>\n",
       "      <th>Hour</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>938.207373</td>\n",
       "      <td>49</td>\n",
       "      <td>3.5</td>\n",
       "      <td>00</td>\n",
       "      <td>2018-05-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>976.901961</td>\n",
       "      <td>48</td>\n",
       "      <td>4.6</td>\n",
       "      <td>01</td>\n",
       "      <td>2018-05-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>592.430556</td>\n",
       "      <td>50</td>\n",
       "      <td>3.5</td>\n",
       "      <td>02</td>\n",
       "      <td>2018-05-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>464.676923</td>\n",
       "      <td>49</td>\n",
       "      <td>4.6</td>\n",
       "      <td>03</td>\n",
       "      <td>2018-05-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>617.026667</td>\n",
       "      <td>50</td>\n",
       "      <td>0.0</td>\n",
       "      <td>04</td>\n",
       "      <td>2018-05-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Duration  Air Temp F  Wind Spd (mph) Hour        Date\n",
       "0  938.207373          49             3.5   00  2018-05-01\n",
       "1  976.901961          48             4.6   01  2018-05-01\n",
       "2  592.430556          50             3.5   02  2018-05-01\n",
       "3  464.676923          49             4.6   03  2018-05-01\n",
       "4  617.026667          50             0.0   04  2018-05-01"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_data=data.drop(['Date-Time'],axis=1)\n",
    "final_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "final_data.to_csv('Final_Data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "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.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}