GeneratingzipJun.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#### green taxi: feature selection\n",
    "\n",
    "#os.chdir(\"/Users/whiplash/SJSU/Semester 2/Github/Predicting-High-Taxi-Demand-Regions/Data\")\n",
    "# green_raw = []\n",
    "green_taxi_raw = pd.read_csv(\"green_tripdata_2014-05.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "green_taxi_raw.columns=[c.replace(\" \", \"\") for c in green_taxi_raw.columns]  \n",
    "green_taxi_raw['lpep_pickup_datetime']=green_taxi_raw['VendorID'] # the first 3 columns are mislabeled\n",
    "green_taxi_raw.index=np.arange(green_taxi_raw.shape[0])  # index is wrong\n",
    "green_taxi_data=green_taxi_raw[['lpep_pickup_datetime', 'Pickup_longitude', 'Pickup_latitude']]\n",
    "green_taxi_data.columns=['Date', 'Lon', 'Lat']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Lon</th>\n",
       "      <th>Lat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014-01-01 01:08:06</td>\n",
       "      <td>-73.865044</td>\n",
       "      <td>40.872307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-01-01 06:03:57</td>\n",
       "      <td>-73.776367</td>\n",
       "      <td>40.645489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-01-01 18:22:44</td>\n",
       "      <td>-73.932648</td>\n",
       "      <td>40.852573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-01-01 00:52:03</td>\n",
       "      <td>-73.994080</td>\n",
       "      <td>40.749092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014-01-01 00:49:25</td>\n",
       "      <td>-73.936066</td>\n",
       "      <td>40.734726</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Date        Lon        Lat\n",
       "0  2014-01-01 01:08:06 -73.865044  40.872307\n",
       "1  2014-01-01 06:03:57 -73.776367  40.645489\n",
       "2  2014-01-01 18:22:44 -73.932648  40.852573\n",
       "3  2014-01-01 00:52:03 -73.994080  40.749092\n",
       "4  2014-01-01 00:49:25 -73.936066  40.734726"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "green_taxi_data[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/sneha/anaconda2/lib/python2.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n",
      "/Users/sneha/anaconda2/lib/python2.7/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",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \n",
      "/Users/sneha/anaconda2/lib/python2.7/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",
      "Try using .loc[row_indexer,col_indexer] = value instead\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": [
    "green_taxi_data[\"Lat\"] = green_taxi_data[\"Lat\"].astype(str)\n",
    "green_taxi_data[\"Lon\"] = green_taxi_data[\"Lon\"].astype(str)\n",
    "green_taxi_data[\"Coord\"] = green_taxi_data[[\"Lat\", \"Lon\"]].apply(lambda x: \",\".join(x), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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</th>\n",
       "      <th>Lon</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Coord</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014-01-01 01:08:06</td>\n",
       "      <td>-73.86504364013672</td>\n",
       "      <td>40.87230682373047</td>\n",
       "      <td>40.87230682373047,-73.86504364013672</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-01-01 06:03:57</td>\n",
       "      <td>-73.7763671875</td>\n",
       "      <td>40.64548873901367</td>\n",
       "      <td>40.64548873901367,-73.7763671875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-01-01 18:22:44</td>\n",
       "      <td>-73.93264770507811</td>\n",
       "      <td>40.85257339477539</td>\n",
       "      <td>40.85257339477539,-73.93264770507811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-01-01 00:52:03</td>\n",
       "      <td>-73.99407958984375</td>\n",
       "      <td>40.74909210205078</td>\n",
       "      <td>40.74909210205078,-73.99407958984375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014-01-01 00:49:25</td>\n",
       "      <td>-73.93606567382812</td>\n",
       "      <td>40.73472595214844</td>\n",
       "      <td>40.73472595214844,-73.93606567382812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2014-01-01 00:01:15</td>\n",
       "      <td>-73.9121551513672</td>\n",
       "      <td>40.684059143066406</td>\n",
       "      <td>40.684059143066406,-73.9121551513672</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2014-01-01 02:37:20</td>\n",
       "      <td>-73.93531799316406</td>\n",
       "      <td>40.73701095581055</td>\n",
       "      <td>40.73701095581055,-73.93531799316406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2014-01-01 15:24:02</td>\n",
       "      <td>-73.93746948242188</td>\n",
       "      <td>40.804195404052734</td>\n",
       "      <td>40.804195404052734,-73.93746948242188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2014-01-01 06:11:44</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0,0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2014-01-01 01:17:43</td>\n",
       "      <td>-73.91567993164062</td>\n",
       "      <td>40.77630615234375</td>\n",
       "      <td>40.77630615234375,-73.91567993164062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2014-01-01 19:07:40</td>\n",
       "      <td>-73.94893646240234</td>\n",
       "      <td>40.66542053222656</td>\n",
       "      <td>40.66542053222656,-73.94893646240234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2014-01-01 05:08:05</td>\n",
       "      <td>-74.01026916503906</td>\n",
       "      <td>40.64192199707031</td>\n",
       "      <td>40.64192199707031,-74.01026916503906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2014-01-01 13:04:11</td>\n",
       "      <td>-73.99115753173827</td>\n",
       "      <td>40.639381408691406</td>\n",
       "      <td>40.639381408691406,-73.99115753173827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2014-01-01 00:08:28</td>\n",
       "      <td>-73.8885498046875</td>\n",
       "      <td>40.745452880859375</td>\n",
       "      <td>40.745452880859375,-73.8885498046875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2014-01-01 00:10:30</td>\n",
       "      <td>-73.7994155883789</td>\n",
       "      <td>40.73357772827149</td>\n",
       "      <td>40.73357772827149,-73.7994155883789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2014-01-01 00:07:26</td>\n",
       "      <td>-73.81632995605469</td>\n",
       "      <td>40.71437454223633</td>\n",
       "      <td>40.71437454223633,-73.81632995605469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2014-01-01 00:18:35</td>\n",
       "      <td>-73.94696044921875</td>\n",
       "      <td>40.751373291015625</td>\n",
       "      <td>40.751373291015625,-73.94696044921875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2014-01-01 00:04:05</td>\n",
       "      <td>-73.94689178466798</td>\n",
       "      <td>40.81333541870117</td>\n",
       "      <td>40.81333541870117,-73.94689178466798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2014-01-01 00:08:32</td>\n",
       "      <td>-73.93402099609375</td>\n",
       "      <td>40.73625564575195</td>\n",
       "      <td>40.73625564575195,-73.93402099609375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2014-01-01 00:11:36</td>\n",
       "      <td>-73.96392822265625</td>\n",
       "      <td>40.76107025146485</td>\n",
       "      <td>40.76107025146485,-73.96392822265625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2014-01-01 00:06:03</td>\n",
       "      <td>-73.88463592529298</td>\n",
       "      <td>40.84214782714844</td>\n",
       "      <td>40.84214782714844,-73.88463592529298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2014-01-01 00:16:14</td>\n",
       "      <td>-73.9070816040039</td>\n",
       "      <td>40.836612701416016</td>\n",
       "      <td>40.836612701416016,-73.9070816040039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2014-01-01 00:08:37</td>\n",
       "      <td>-73.90294647216798</td>\n",
       "      <td>40.74587631225585</td>\n",
       "      <td>40.74587631225585,-73.90294647216798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2014-01-01 00:07:44</td>\n",
       "      <td>-73.942626953125</td>\n",
       "      <td>40.8218879699707</td>\n",
       "      <td>40.8218879699707,-73.942626953125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2014-01-01 00:05:42</td>\n",
       "      <td>-74.00379943847656</td>\n",
       "      <td>40.65483474731445</td>\n",
       "      <td>40.65483474731445,-74.00379943847656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2014-01-01 00:07:29</td>\n",
       "      <td>-73.88490295410156</td>\n",
       "      <td>40.739173889160156</td>\n",
       "      <td>40.739173889160156,-73.88490295410156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2014-01-01 00:14:42</td>\n",
       "      <td>-73.94159698486328</td>\n",
       "      <td>40.70816040039063</td>\n",
       "      <td>40.70816040039063,-73.94159698486328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2014-01-01 00:05:36</td>\n",
       "      <td>-73.93653106689453</td>\n",
       "      <td>40.669700622558594</td>\n",
       "      <td>40.669700622558594,-73.93653106689453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2014-01-01 00:15:36</td>\n",
       "      <td>-73.98289489746094</td>\n",
       "      <td>40.77192687988281</td>\n",
       "      <td>40.77192687988281,-73.98289489746094</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2014-01-01 00:28:57</td>\n",
       "      <td>-73.99605560302734</td>\n",
       "      <td>40.73101425170898</td>\n",
       "      <td>40.73101425170898,-73.99605560302734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803822</th>\n",
       "      <td>2014-02-01 00:04:46</td>\n",
       "      <td>-73.93846893310547</td>\n",
       "      <td>40.82762145996094</td>\n",
       "      <td>40.82762145996094,-73.93846893310547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803823</th>\n",
       "      <td>2014-02-01 00:06:55</td>\n",
       "      <td>-73.88549041748048</td>\n",
       "      <td>40.84670639038085</td>\n",
       "      <td>40.84670639038085,-73.88549041748048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803824</th>\n",
       "      <td>2014-02-01 00:24:29</td>\n",
       "      <td>-73.99298858642578</td>\n",
       "      <td>40.75647735595703</td>\n",
       "      <td>40.75647735595703,-73.99298858642578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803825</th>\n",
       "      <td>2014-02-01 00:17:20</td>\n",
       "      <td>-73.98692321777342</td>\n",
       "      <td>40.75789260864258</td>\n",
       "      <td>40.75789260864258,-73.98692321777342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803826</th>\n",
       "      <td>2014-02-01 00:13:14</td>\n",
       "      <td>-74.00065612792969</td>\n",
       "      <td>40.72328567504883</td>\n",
       "      <td>40.72328567504883,-74.00065612792969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803827</th>\n",
       "      <td>2014-02-01 00:21:41</td>\n",
       "      <td>-73.99188995361328</td>\n",
       "      <td>40.74481201171875</td>\n",
       "      <td>40.74481201171875,-73.99188995361328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803828</th>\n",
       "      <td>2014-02-01 00:06:45</td>\n",
       "      <td>-73.96165466308594</td>\n",
       "      <td>40.80596160888672</td>\n",
       "      <td>40.80596160888672,-73.96165466308594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803829</th>\n",
       "      <td>2014-02-01 00:09:26</td>\n",
       "      <td>-73.95069885253906</td>\n",
       "      <td>40.70836639404297</td>\n",
       "      <td>40.70836639404297,-73.95069885253906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803830</th>\n",
       "      <td>2014-02-01 00:03:06</td>\n",
       "      <td>-73.90729522705078</td>\n",
       "      <td>40.82366561889648</td>\n",
       "      <td>40.82366561889648,-73.90729522705078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803831</th>\n",
       "      <td>2014-02-01 00:24:37</td>\n",
       "      <td>-73.99241638183594</td>\n",
       "      <td>40.77412796020508</td>\n",
       "      <td>40.77412796020508,-73.99241638183594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803832</th>\n",
       "      <td>2014-02-01 00:13:19</td>\n",
       "      <td>-73.92374420166014</td>\n",
       "      <td>40.848541259765625</td>\n",
       "      <td>40.848541259765625,-73.92374420166014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803833</th>\n",
       "      <td>2014-02-01 00:01:41</td>\n",
       "      <td>-73.91270446777344</td>\n",
       "      <td>40.65454864501953</td>\n",
       "      <td>40.65454864501953,-73.91270446777344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803834</th>\n",
       "      <td>2014-02-01 00:04:41</td>\n",
       "      <td>-73.8609619140625</td>\n",
       "      <td>40.71916580200195</td>\n",
       "      <td>40.71916580200195,-73.8609619140625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803835</th>\n",
       "      <td>2014-02-01 00:11:57</td>\n",
       "      <td>-73.91472625732422</td>\n",
       "      <td>40.766029357910156</td>\n",
       "      <td>40.766029357910156,-73.91472625732422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803836</th>\n",
       "      <td>2014-02-01 00:04:13</td>\n",
       "      <td>-73.91758728027342</td>\n",
       "      <td>40.75825119018555</td>\n",
       "      <td>40.75825119018555,-73.91758728027342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803837</th>\n",
       "      <td>2014-02-01 00:04:19</td>\n",
       "      <td>-73.8267822265625</td>\n",
       "      <td>40.853111267089844</td>\n",
       "      <td>40.853111267089844,-73.8267822265625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803838</th>\n",
       "      <td>2014-02-01 00:28:32</td>\n",
       "      <td>-73.99227142333984</td>\n",
       "      <td>40.75989151000977</td>\n",
       "      <td>40.75989151000977,-73.99227142333984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803839</th>\n",
       "      <td>2014-02-01 00:36:05</td>\n",
       "      <td>-73.99736022949219</td>\n",
       "      <td>40.71893310546875</td>\n",
       "      <td>40.71893310546875,-73.99736022949219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803840</th>\n",
       "      <td>2014-02-01 00:03:38</td>\n",
       "      <td>-73.98847198486328</td>\n",
       "      <td>40.66653823852539</td>\n",
       "      <td>40.66653823852539,-73.98847198486328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803841</th>\n",
       "      <td>2014-02-01 00:22:18</td>\n",
       "      <td>-73.86181640625</td>\n",
       "      <td>40.69072341918945</td>\n",
       "      <td>40.69072341918945,-73.86181640625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803842</th>\n",
       "      <td>2014-02-01 00:08:49</td>\n",
       "      <td>-73.96247100830078</td>\n",
       "      <td>40.68169403076172</td>\n",
       "      <td>40.68169403076172,-73.96247100830078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803843</th>\n",
       "      <td>2014-02-01 00:05:06</td>\n",
       "      <td>-73.9397964477539</td>\n",
       "      <td>40.6927146911621</td>\n",
       "      <td>40.6927146911621,-73.9397964477539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803844</th>\n",
       "      <td>2014-02-01 00:28:47</td>\n",
       "      <td>-73.97882843017578</td>\n",
       "      <td>40.64572525024415</td>\n",
       "      <td>40.64572525024415,-73.97882843017578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803845</th>\n",
       "      <td>2014-02-01 00:05:17</td>\n",
       "      <td>-73.94651794433594</td>\n",
       "      <td>40.83050537109375</td>\n",
       "      <td>40.83050537109375,-73.94651794433594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803846</th>\n",
       "      <td>2014-02-01 00:10:00</td>\n",
       "      <td>-73.96923828125</td>\n",
       "      <td>40.69315719604492</td>\n",
       "      <td>40.69315719604492,-73.96923828125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803847</th>\n",
       "      <td>2014-02-01 00:03:26</td>\n",
       "      <td>-73.95223999023438</td>\n",
       "      <td>40.723331451416016</td>\n",
       "      <td>40.723331451416016,-73.95223999023438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803848</th>\n",
       "      <td>2014-02-01 00:06:59</td>\n",
       "      <td>-73.87631225585938</td>\n",
       "      <td>40.76841354370117</td>\n",
       "      <td>40.76841354370117,-73.87631225585938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803849</th>\n",
       "      <td>2014-02-01 00:03:49</td>\n",
       "      <td>-73.99173736572266</td>\n",
       "      <td>40.66295623779297</td>\n",
       "      <td>40.66295623779297,-73.99173736572266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803850</th>\n",
       "      <td>2014-02-01 00:24:27</td>\n",
       "      <td>-74.00752258300781</td>\n",
       "      <td>40.725669860839844</td>\n",
       "      <td>40.725669860839844,-74.00752258300781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803851</th>\n",
       "      <td>2014-02-01 00:01:53</td>\n",
       "      <td>-73.94210815429686</td>\n",
       "      <td>40.75413513183594</td>\n",
       "      <td>40.75413513183594,-73.94210815429686</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>803852 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Date                 Lon                 Lat  \\\n",
       "0       2014-01-01 01:08:06  -73.86504364013672   40.87230682373047   \n",
       "1       2014-01-01 06:03:57      -73.7763671875   40.64548873901367   \n",
       "2       2014-01-01 18:22:44  -73.93264770507811   40.85257339477539   \n",
       "3       2014-01-01 00:52:03  -73.99407958984375   40.74909210205078   \n",
       "4       2014-01-01 00:49:25  -73.93606567382812   40.73472595214844   \n",
       "5       2014-01-01 00:01:15   -73.9121551513672  40.684059143066406   \n",
       "6       2014-01-01 02:37:20  -73.93531799316406   40.73701095581055   \n",
       "7       2014-01-01 15:24:02  -73.93746948242188  40.804195404052734   \n",
       "8       2014-01-01 06:11:44                 0.0                 0.0   \n",
       "9       2014-01-01 01:17:43  -73.91567993164062   40.77630615234375   \n",
       "10      2014-01-01 19:07:40  -73.94893646240234   40.66542053222656   \n",
       "11      2014-01-01 05:08:05  -74.01026916503906   40.64192199707031   \n",
       "12      2014-01-01 13:04:11  -73.99115753173827  40.639381408691406   \n",
       "13      2014-01-01 00:08:28   -73.8885498046875  40.745452880859375   \n",
       "14      2014-01-01 00:10:30   -73.7994155883789   40.73357772827149   \n",
       "15      2014-01-01 00:07:26  -73.81632995605469   40.71437454223633   \n",
       "16      2014-01-01 00:18:35  -73.94696044921875  40.751373291015625   \n",
       "17      2014-01-01 00:04:05  -73.94689178466798   40.81333541870117   \n",
       "18      2014-01-01 00:08:32  -73.93402099609375   40.73625564575195   \n",
       "19      2014-01-01 00:11:36  -73.96392822265625   40.76107025146485   \n",
       "20      2014-01-01 00:06:03  -73.88463592529298   40.84214782714844   \n",
       "21      2014-01-01 00:16:14   -73.9070816040039  40.836612701416016   \n",
       "22      2014-01-01 00:08:37  -73.90294647216798   40.74587631225585   \n",
       "23      2014-01-01 00:07:44    -73.942626953125    40.8218879699707   \n",
       "24      2014-01-01 00:05:42  -74.00379943847656   40.65483474731445   \n",
       "25      2014-01-01 00:07:29  -73.88490295410156  40.739173889160156   \n",
       "26      2014-01-01 00:14:42  -73.94159698486328   40.70816040039063   \n",
       "27      2014-01-01 00:05:36  -73.93653106689453  40.669700622558594   \n",
       "28      2014-01-01 00:15:36  -73.98289489746094   40.77192687988281   \n",
       "29      2014-01-01 00:28:57  -73.99605560302734   40.73101425170898   \n",
       "...                     ...                 ...                 ...   \n",
       "803822  2014-02-01 00:04:46  -73.93846893310547   40.82762145996094   \n",
       "803823  2014-02-01 00:06:55  -73.88549041748048   40.84670639038085   \n",
       "803824  2014-02-01 00:24:29  -73.99298858642578   40.75647735595703   \n",
       "803825  2014-02-01 00:17:20  -73.98692321777342   40.75789260864258   \n",
       "803826  2014-02-01 00:13:14  -74.00065612792969   40.72328567504883   \n",
       "803827  2014-02-01 00:21:41  -73.99188995361328   40.74481201171875   \n",
       "803828  2014-02-01 00:06:45  -73.96165466308594   40.80596160888672   \n",
       "803829  2014-02-01 00:09:26  -73.95069885253906   40.70836639404297   \n",
       "803830  2014-02-01 00:03:06  -73.90729522705078   40.82366561889648   \n",
       "803831  2014-02-01 00:24:37  -73.99241638183594   40.77412796020508   \n",
       "803832  2014-02-01 00:13:19  -73.92374420166014  40.848541259765625   \n",
       "803833  2014-02-01 00:01:41  -73.91270446777344   40.65454864501953   \n",
       "803834  2014-02-01 00:04:41   -73.8609619140625   40.71916580200195   \n",
       "803835  2014-02-01 00:11:57  -73.91472625732422  40.766029357910156   \n",
       "803836  2014-02-01 00:04:13  -73.91758728027342   40.75825119018555   \n",
       "803837  2014-02-01 00:04:19   -73.8267822265625  40.853111267089844   \n",
       "803838  2014-02-01 00:28:32  -73.99227142333984   40.75989151000977   \n",
       "803839  2014-02-01 00:36:05  -73.99736022949219   40.71893310546875   \n",
       "803840  2014-02-01 00:03:38  -73.98847198486328   40.66653823852539   \n",
       "803841  2014-02-01 00:22:18     -73.86181640625   40.69072341918945   \n",
       "803842  2014-02-01 00:08:49  -73.96247100830078   40.68169403076172   \n",
       "803843  2014-02-01 00:05:06   -73.9397964477539    40.6927146911621   \n",
       "803844  2014-02-01 00:28:47  -73.97882843017578   40.64572525024415   \n",
       "803845  2014-02-01 00:05:17  -73.94651794433594   40.83050537109375   \n",
       "803846  2014-02-01 00:10:00     -73.96923828125   40.69315719604492   \n",
       "803847  2014-02-01 00:03:26  -73.95223999023438  40.723331451416016   \n",
       "803848  2014-02-01 00:06:59  -73.87631225585938   40.76841354370117   \n",
       "803849  2014-02-01 00:03:49  -73.99173736572266   40.66295623779297   \n",
       "803850  2014-02-01 00:24:27  -74.00752258300781  40.725669860839844   \n",
       "803851  2014-02-01 00:01:53  -73.94210815429686   40.75413513183594   \n",
       "\n",
       "                                        Coord  \n",
       "0        40.87230682373047,-73.86504364013672  \n",
       "1            40.64548873901367,-73.7763671875  \n",
       "2        40.85257339477539,-73.93264770507811  \n",
       "3        40.74909210205078,-73.99407958984375  \n",
       "4        40.73472595214844,-73.93606567382812  \n",
       "5        40.684059143066406,-73.9121551513672  \n",
       "6        40.73701095581055,-73.93531799316406  \n",
       "7       40.804195404052734,-73.93746948242188  \n",
       "8                                     0.0,0.0  \n",
       "9        40.77630615234375,-73.91567993164062  \n",
       "10       40.66542053222656,-73.94893646240234  \n",
       "11       40.64192199707031,-74.01026916503906  \n",
       "12      40.639381408691406,-73.99115753173827  \n",
       "13       40.745452880859375,-73.8885498046875  \n",
       "14        40.73357772827149,-73.7994155883789  \n",
       "15       40.71437454223633,-73.81632995605469  \n",
       "16      40.751373291015625,-73.94696044921875  \n",
       "17       40.81333541870117,-73.94689178466798  \n",
       "18       40.73625564575195,-73.93402099609375  \n",
       "19       40.76107025146485,-73.96392822265625  \n",
       "20       40.84214782714844,-73.88463592529298  \n",
       "21       40.836612701416016,-73.9070816040039  \n",
       "22       40.74587631225585,-73.90294647216798  \n",
       "23          40.8218879699707,-73.942626953125  \n",
       "24       40.65483474731445,-74.00379943847656  \n",
       "25      40.739173889160156,-73.88490295410156  \n",
       "26       40.70816040039063,-73.94159698486328  \n",
       "27      40.669700622558594,-73.93653106689453  \n",
       "28       40.77192687988281,-73.98289489746094  \n",
       "29       40.73101425170898,-73.99605560302734  \n",
       "...                                       ...  \n",
       "803822   40.82762145996094,-73.93846893310547  \n",
       "803823   40.84670639038085,-73.88549041748048  \n",
       "803824   40.75647735595703,-73.99298858642578  \n",
       "803825   40.75789260864258,-73.98692321777342  \n",
       "803826   40.72328567504883,-74.00065612792969  \n",
       "803827   40.74481201171875,-73.99188995361328  \n",
       "803828   40.80596160888672,-73.96165466308594  \n",
       "803829   40.70836639404297,-73.95069885253906  \n",
       "803830   40.82366561889648,-73.90729522705078  \n",
       "803831   40.77412796020508,-73.99241638183594  \n",
       "803832  40.848541259765625,-73.92374420166014  \n",
       "803833   40.65454864501953,-73.91270446777344  \n",
       "803834    40.71916580200195,-73.8609619140625  \n",
       "803835  40.766029357910156,-73.91472625732422  \n",
       "803836   40.75825119018555,-73.91758728027342  \n",
       "803837   40.853111267089844,-73.8267822265625  \n",
       "803838   40.75989151000977,-73.99227142333984  \n",
       "803839   40.71893310546875,-73.99736022949219  \n",
       "803840   40.66653823852539,-73.98847198486328  \n",
       "803841      40.69072341918945,-73.86181640625  \n",
       "803842   40.68169403076172,-73.96247100830078  \n",
       "803843     40.6927146911621,-73.9397964477539  \n",
       "803844   40.64572525024415,-73.97882843017578  \n",
       "803845   40.83050537109375,-73.94651794433594  \n",
       "803846      40.69315719604492,-73.96923828125  \n",
       "803847  40.723331451416016,-73.95223999023438  \n",
       "803848   40.76841354370117,-73.87631225585938  \n",
       "803849   40.66295623779297,-73.99173736572266  \n",
       "803850  40.725669860839844,-74.00752258300781  \n",
       "803851   40.75413513183594,-73.94210815429686  \n",
       "\n",
       "[803852 rows x 4 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "green_taxi_data[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyboardInterrupt",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m                         Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-11-d6f2fb98568a>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m     11\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     12\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0mn\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mrange\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mgreen_taxi_data\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 13\u001b[0;31m     \u001b[0mres\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0msearch\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mby_coordinate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfloat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mgreen_taxi_data\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"Lat\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mn\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mfloat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mgreen_taxi_data\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"Lon\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mn\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mradius\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m30\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mreturns\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     14\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mres\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m>\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     15\u001b[0m         \u001b[0moutput\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mres\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"Zipcode\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/sneha/anaconda2/lib/python2.7/site-packages/uszipcode/searchengine.pyc\u001b[0m in \u001b[0;36mby_coordinate\u001b[0;34m(self, lat, lng, radius, ascending, standard_only, returns)\u001b[0m\n\u001b[1;32m    507\u001b[0m           \u001b[0;31m限\u001b[0m\u001b[0;31m定\u001b[0m\u001b[0;31m的\u001b[0m\u001b[0;31m半\u001b[0m\u001b[0;31m径\u001b[0m\u001b[0;31m的\u001b[0m\u001b[0;31m直\u001b[0m\u001b[0;31m接\u001b[0m\u001b[0;31m丢\u001b[0m\u001b[0;31m弃\u001b[0m\u001b[0;31m。\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    508\u001b[0m         \"\"\"\n\u001b[0;32m--> 509\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mfind\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlat\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mlat\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlng\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mlng\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mradius\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mradius\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mstandard_only\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mstandard_only\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0msort_by\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mNone\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mascending\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mascending\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mreturns\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mreturns\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    510\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    511\u001b[0m     def by_city_and_state(self, city, state,\n",
      "\u001b[0;32m/Users/sneha/anaconda2/lib/python2.7/site-packages/uszipcode/searchengine.pyc\u001b[0m in \u001b[0;36mfind\u001b[0;34m(self, lat, lng, radius, city, state, prefix, pattern, population_lower, population_upper, density_lower, density_upper, landarea_lower, landarea_upper, waterarea_lower, waterarea_upper, totalwages_lower, totalwages_upper, wealthy_lower, wealthy_upper, house_lower, house_upper, standard_only, sort_by, ascending, returns)\u001b[0m\n\u001b[1;32m    996\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    997\u001b[0m                     \u001b[0;32mif\u001b[0m \u001b[0mascending\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 998\u001b[0;31m                         \u001b[0mdata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mnsmallest\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mreturns\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mgen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mlambda\u001b[0m \u001b[0mx\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0mx\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    999\u001b[0m                     \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1000\u001b[0m                         \u001b[0mdata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mnlargest\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mreturns\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mgen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mlambda\u001b[0m \u001b[0mx\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0mx\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/sneha/anaconda2/lib/python2.7/heapq.pyc\u001b[0m in \u001b[0;36mnsmallest\u001b[0;34m(n, iterable, key)\u001b[0m\n\u001b[1;32m    410\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mkey\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    411\u001b[0m             \u001b[0;32mreturn\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0mmin\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mchain\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mhead\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mit\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 412\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0mmin\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mchain\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mhead\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mit\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    413\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    414\u001b[0m     \u001b[0;31m# When n>=size, it's faster to use sorted()\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/sneha/anaconda2/lib/python2.7/site-packages/uszipcode/searchengine.pyc\u001b[0m in \u001b[0;36mgen\u001b[0;34m()\u001b[0m\n\u001b[1;32m    987\u001b[0m                 \u001b[0;31m# use heap sort find top N closest zipcode\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    988\u001b[0m                 \u001b[0;32mdef\u001b[0m \u001b[0mgen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 989\u001b[0;31m                     \u001b[0;32mfor\u001b[0m \u001b[0mrow\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcursor\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mexecute\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mselect_sql\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    990\u001b[0m                         dist = great_circle(\n\u001b[1;32m    991\u001b[0m                             (row[\"Latitude\"], row[\"Longitude\"]), (lat, lng))\n",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m: "
     ]
    }
   ],
   "source": [
    "from uszipcode import ZipcodeSearchEngine\n",
    "search = ZipcodeSearchEngine()\n",
    "zipcode = {}\n",
    "output=[]\n",
    "# green[\"Zipcode\"] = \"NaN\"\n",
    "# for n in range(len(green)):\n",
    "#     res = search.by_coordinate(float(green[\"Lat\"][n]), float(green[\"Lon\"][n]), radius=30, returns=1)\n",
    "#     if len(res)>0:\n",
    "#         green[\"Zipcode\"][n] = str(res[0][\"Zipcode\"])\n",
    "\n",
    "\n",
    "for n in range(len(green_taxi_data)):\n",
    "    res = search.by_coordinate(float(green_taxi_data[\"Lat\"][n]), float(green_taxi_data[\"Lon\"][n]), radius=30, returns=1)\n",
    "    if len(res)>0:\n",
    "        output.append(str(res[0][\"Zipcode\"]))        \n",
    "    else:\n",
    "        output.append(\"NaN\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "803852\n"
     ]
    }
   ],
   "source": [
    "print(len(output))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/whiplash/anaconda3/lib/python3.6/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "green_taxi_data[\"Zipcode\"] = output"
   ]
  },
  {
   "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</th>\n",
       "      <th>Lon</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Coord</th>\n",
       "      <th>Zipcode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014-01-01 01:08:06</td>\n",
       "      <td>-73.86504364013672</td>\n",
       "      <td>40.87230682373047</td>\n",
       "      <td>40.87230682373047,-73.86504364013672</td>\n",
       "      <td>10467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-01-01 06:03:57</td>\n",
       "      <td>-73.7763671875</td>\n",
       "      <td>40.64548873901367</td>\n",
       "      <td>40.64548873901367,-73.7763671875</td>\n",
       "      <td>11430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-01-01 18:22:44</td>\n",
       "      <td>-73.93264770507811</td>\n",
       "      <td>40.85257339477539</td>\n",
       "      <td>40.85257339477539,-73.93264770507811</td>\n",
       "      <td>10033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-01-01 00:52:03</td>\n",
       "      <td>-73.99407958984375</td>\n",
       "      <td>40.74909210205078</td>\n",
       "      <td>40.74909210205078,-73.99407958984375</td>\n",
       "      <td>10119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014-01-01 00:49:25</td>\n",
       "      <td>-73.93606567382812</td>\n",
       "      <td>40.73472595214844</td>\n",
       "      <td>40.73472595214844,-73.93606567382812</td>\n",
       "      <td>11101</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Date                 Lon                Lat  \\\n",
       "0  2014-01-01 01:08:06  -73.86504364013672  40.87230682373047   \n",
       "1  2014-01-01 06:03:57      -73.7763671875  40.64548873901367   \n",
       "2  2014-01-01 18:22:44  -73.93264770507811  40.85257339477539   \n",
       "3  2014-01-01 00:52:03  -73.99407958984375  40.74909210205078   \n",
       "4  2014-01-01 00:49:25  -73.93606567382812  40.73472595214844   \n",
       "\n",
       "                                  Coord Zipcode  \n",
       "0  40.87230682373047,-73.86504364013672   10467  \n",
       "1      40.64548873901367,-73.7763671875   11430  \n",
       "2  40.85257339477539,-73.93264770507811   10033  \n",
       "3  40.74909210205078,-73.99407958984375   10119  \n",
       "4  40.73472595214844,-73.93606567382812   11101  "
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "green_taxi_data[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "green_taxi_data.to_csv(\"finalMay.csv\", encoding = 'utf-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "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</th>\n",
       "      <th>Lon</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Coord</th>\n",
       "      <th>Zipcode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014-01-01 01:08:06</td>\n",
       "      <td>-73.86504364013672</td>\n",
       "      <td>40.87230682373047</td>\n",
       "      <td>40.87230682373047,-73.86504364013672</td>\n",
       "      <td>10467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-01-01 06:03:57</td>\n",
       "      <td>-73.7763671875</td>\n",
       "      <td>40.64548873901367</td>\n",
       "      <td>40.64548873901367,-73.7763671875</td>\n",
       "      <td>11430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-01-01 18:22:44</td>\n",
       "      <td>-73.93264770507811</td>\n",
       "      <td>40.85257339477539</td>\n",
       "      <td>40.85257339477539,-73.93264770507811</td>\n",
       "      <td>10033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-01-01 00:52:03</td>\n",
       "      <td>-73.99407958984375</td>\n",
       "      <td>40.74909210205078</td>\n",
       "      <td>40.74909210205078,-73.99407958984375</td>\n",
       "      <td>10119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014-01-01 00:49:25</td>\n",
       "      <td>-73.93606567382812</td>\n",
       "      <td>40.73472595214844</td>\n",
       "      <td>40.73472595214844,-73.93606567382812</td>\n",
       "      <td>11101</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Date                 Lon                Lat  \\\n",
       "0  2014-01-01 01:08:06  -73.86504364013672  40.87230682373047   \n",
       "1  2014-01-01 06:03:57      -73.7763671875  40.64548873901367   \n",
       "2  2014-01-01 18:22:44  -73.93264770507811  40.85257339477539   \n",
       "3  2014-01-01 00:52:03  -73.99407958984375  40.74909210205078   \n",
       "4  2014-01-01 00:49:25  -73.93606567382812  40.73472595214844   \n",
       "\n",
       "                                  Coord Zipcode  \n",
       "0  40.87230682373047,-73.86504364013672   10467  \n",
       "1      40.64548873901367,-73.7763671875   11430  \n",
       "2  40.85257339477539,-73.93264770507811   10033  \n",
       "3  40.74909210205078,-73.99407958984375   10119  \n",
       "4  40.73472595214844,-73.93606567382812   11101  "
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "green_taxi_data[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "nanlist = []\n",
    "for n in range(len(green_taxi_data)):\n",
    "    if green_taxi_data[\"Zipcode\"][n] == \"NaN\":\n",
    "        nanlist.append(n)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1659"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(nanlist)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "803852"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(green_taxi_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "green1 = green_taxi_data.drop(green.index[nanlist])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "zipcode = pd.read_csv(\"/Users/whiplash/SJSU/Semester 2/Github/Predicting-High-Taxi-Demand-Regions/Data/Zip_CodeNYC.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "green1.to_csv(\"finalpreprocessed.csv\", encoding = 'utf-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.series.Series'>\n"
     ]
    }
   ],
   "source": [
    "print(type(green_taxi_data[\"Zipcode\"]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.series.Series'>\n"
     ]
    }
   ],
   "source": [
    "print(type(zipcode[\"JURISDICTION NAME\"]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "date=pd.to_datetime(green1['Date'])\n",
    "green1['Month']=date.dt.month\n",
    "green1['Day']=date.dt.day\n",
    "green1['Hour']=date.dt.hour\n",
    "temp=pd.DatetimeIndex(date)\n",
    "green1['Weekday']=temp.weekday\n",
    "# data_model=data_final[['Month', 'Weekday', 'Hour']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "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</th>\n",
       "      <th>Lon</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Coord</th>\n",
       "      <th>Zipcode</th>\n",
       "      <th>Month</th>\n",
       "      <th>Day</th>\n",
       "      <th>Hour</th>\n",
       "      <th>Weekday</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014-01-01 01:08:06</td>\n",
       "      <td>-73.86504364013672</td>\n",
       "      <td>40.87230682373047</td>\n",
       "      <td>40.87230682373047,-73.86504364013672</td>\n",
       "      <td>10467</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-01-01 06:03:57</td>\n",
       "      <td>-73.7763671875</td>\n",
       "      <td>40.64548873901367</td>\n",
       "      <td>40.64548873901367,-73.7763671875</td>\n",
       "      <td>11430</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-01-01 18:22:44</td>\n",
       "      <td>-73.93264770507811</td>\n",
       "      <td>40.85257339477539</td>\n",
       "      <td>40.85257339477539,-73.93264770507811</td>\n",
       "      <td>10033</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-01-01 00:52:03</td>\n",
       "      <td>-73.99407958984375</td>\n",
       "      <td>40.74909210205078</td>\n",
       "      <td>40.74909210205078,-73.99407958984375</td>\n",
       "      <td>10119</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014-01-01 00:49:25</td>\n",
       "      <td>-73.93606567382812</td>\n",
       "      <td>40.73472595214844</td>\n",
       "      <td>40.73472595214844,-73.93606567382812</td>\n",
       "      <td>11101</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2014-01-01 00:01:15</td>\n",
       "      <td>-73.9121551513672</td>\n",
       "      <td>40.684059143066406</td>\n",
       "      <td>40.684059143066406,-73.9121551513672</td>\n",
       "      <td>11233</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2014-01-01 02:37:20</td>\n",
       "      <td>-73.93531799316406</td>\n",
       "      <td>40.73701095581055</td>\n",
       "      <td>40.73701095581055,-73.93531799316406</td>\n",
       "      <td>11101</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2014-01-01 15:24:02</td>\n",
       "      <td>-73.93746948242188</td>\n",
       "      <td>40.804195404052734</td>\n",
       "      <td>40.804195404052734,-73.93746948242188</td>\n",
       "      <td>10037</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2014-01-01 01:17:43</td>\n",
       "      <td>-73.91567993164062</td>\n",
       "      <td>40.77630615234375</td>\n",
       "      <td>40.77630615234375,-73.91567993164062</td>\n",
       "      <td>11105</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2014-01-01 19:07:40</td>\n",
       "      <td>-73.94893646240234</td>\n",
       "      <td>40.66542053222656</td>\n",
       "      <td>40.66542053222656,-73.94893646240234</td>\n",
       "      <td>11225</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2014-01-01 05:08:05</td>\n",
       "      <td>-74.01026916503906</td>\n",
       "      <td>40.64192199707031</td>\n",
       "      <td>40.64192199707031,-74.01026916503906</td>\n",
       "      <td>11220</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2014-01-01 13:04:11</td>\n",
       "      <td>-73.99115753173827</td>\n",
       "      <td>40.639381408691406</td>\n",
       "      <td>40.639381408691406,-73.99115753173827</td>\n",
       "      <td>11219</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2014-01-01 00:08:28</td>\n",
       "      <td>-73.8885498046875</td>\n",
       "      <td>40.745452880859375</td>\n",
       "      <td>40.745452880859375,-73.8885498046875</td>\n",
       "      <td>11372</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2014-01-01 00:10:30</td>\n",
       "      <td>-73.7994155883789</td>\n",
       "      <td>40.73357772827149</td>\n",
       "      <td>40.73357772827149,-73.7994155883789</td>\n",
       "      <td>11366</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2014-01-01 00:07:26</td>\n",
       "      <td>-73.81632995605469</td>\n",
       "      <td>40.71437454223633</td>\n",
       "      <td>40.71437454223633,-73.81632995605469</td>\n",
       "      <td>11415</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2014-01-01 00:18:35</td>\n",
       "      <td>-73.94696044921875</td>\n",
       "      <td>40.751373291015625</td>\n",
       "      <td>40.751373291015625,-73.94696044921875</td>\n",
       "      <td>11101</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2014-01-01 00:04:05</td>\n",
       "      <td>-73.94689178466798</td>\n",
       "      <td>40.81333541870117</td>\n",
       "      <td>40.81333541870117,-73.94689178466798</td>\n",
       "      <td>10030</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2014-01-01 00:08:32</td>\n",
       "      <td>-73.93402099609375</td>\n",
       "      <td>40.73625564575195</td>\n",
       "      <td>40.73625564575195,-73.93402099609375</td>\n",
       "      <td>11101</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2014-01-01 00:11:36</td>\n",
       "      <td>-73.96392822265625</td>\n",
       "      <td>40.76107025146485</td>\n",
       "      <td>40.76107025146485,-73.96392822265625</td>\n",
       "      <td>10065</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2014-01-01 00:06:03</td>\n",
       "      <td>-73.88463592529298</td>\n",
       "      <td>40.84214782714844</td>\n",
       "      <td>40.84214782714844,-73.88463592529298</td>\n",
       "      <td>10460</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2014-01-01 00:16:14</td>\n",
       "      <td>-73.9070816040039</td>\n",
       "      <td>40.836612701416016</td>\n",
       "      <td>40.836612701416016,-73.9070816040039</td>\n",
       "      <td>10456</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2014-01-01 00:08:37</td>\n",
       "      <td>-73.90294647216798</td>\n",
       "      <td>40.74587631225585</td>\n",
       "      <td>40.74587631225585,-73.90294647216798</td>\n",
       "      <td>11377</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2014-01-01 00:07:44</td>\n",
       "      <td>-73.942626953125</td>\n",
       "      <td>40.8218879699707</td>\n",
       "      <td>40.8218879699707,-73.942626953125</td>\n",
       "      <td>10030</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2014-01-01 00:05:42</td>\n",
       "      <td>-74.00379943847656</td>\n",
       "      <td>40.65483474731445</td>\n",
       "      <td>40.65483474731445,-74.00379943847656</td>\n",
       "      <td>11232</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2014-01-01 00:07:29</td>\n",
       "      <td>-73.88490295410156</td>\n",
       "      <td>40.739173889160156</td>\n",
       "      <td>40.739173889160156,-73.88490295410156</td>\n",
       "      <td>11373</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2014-01-01 00:14:42</td>\n",
       "      <td>-73.94159698486328</td>\n",
       "      <td>40.70816040039063</td>\n",
       "      <td>40.70816040039063,-73.94159698486328</td>\n",
       "      <td>11206</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2014-01-01 00:05:36</td>\n",
       "      <td>-73.93653106689453</td>\n",
       "      <td>40.669700622558594</td>\n",
       "      <td>40.669700622558594,-73.93653106689453</td>\n",
       "      <td>11213</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2014-01-01 00:15:36</td>\n",
       "      <td>-73.98289489746094</td>\n",
       "      <td>40.77192687988281</td>\n",
       "      <td>40.77192687988281,-73.98289489746094</td>\n",
       "      <td>10023</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2014-01-01 00:28:57</td>\n",
       "      <td>-73.99605560302734</td>\n",
       "      <td>40.73101425170898</td>\n",
       "      <td>40.73101425170898,-73.99605560302734</td>\n",
       "      <td>10012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2014-01-01 00:12:13</td>\n",
       "      <td>-73.99508666992188</td>\n",
       "      <td>40.66054153442383</td>\n",
       "      <td>40.66054153442383,-73.99508666992188</td>\n",
       "      <td>11232</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803822</th>\n",
       "      <td>2014-02-01 00:04:46</td>\n",
       "      <td>-73.93846893310547</td>\n",
       "      <td>40.82762145996094</td>\n",
       "      <td>40.82762145996094,-73.93846893310547</td>\n",
       "      <td>10039</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803823</th>\n",
       "      <td>2014-02-01 00:06:55</td>\n",
       "      <td>-73.88549041748048</td>\n",
       "      <td>40.84670639038085</td>\n",
       "      <td>40.84670639038085,-73.88549041748048</td>\n",
       "      <td>10460</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803824</th>\n",
       "      <td>2014-02-01 00:24:29</td>\n",
       "      <td>-73.99298858642578</td>\n",
       "      <td>40.75647735595703</td>\n",
       "      <td>40.75647735595703,-73.99298858642578</td>\n",
       "      <td>10018</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803825</th>\n",
       "      <td>2014-02-01 00:17:20</td>\n",
       "      <td>-73.98692321777342</td>\n",
       "      <td>40.75789260864258</td>\n",
       "      <td>40.75789260864258,-73.98692321777342</td>\n",
       "      <td>10020</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803826</th>\n",
       "      <td>2014-02-01 00:13:14</td>\n",
       "      <td>-74.00065612792969</td>\n",
       "      <td>40.72328567504883</td>\n",
       "      <td>40.72328567504883,-74.00065612792969</td>\n",
       "      <td>10012</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803827</th>\n",
       "      <td>2014-02-01 00:21:41</td>\n",
       "      <td>-73.99188995361328</td>\n",
       "      <td>40.74481201171875</td>\n",
       "      <td>40.74481201171875,-73.99188995361328</td>\n",
       "      <td>10119</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803828</th>\n",
       "      <td>2014-02-01 00:06:45</td>\n",
       "      <td>-73.96165466308594</td>\n",
       "      <td>40.80596160888672</td>\n",
       "      <td>40.80596160888672,-73.96165466308594</td>\n",
       "      <td>10115</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803829</th>\n",
       "      <td>2014-02-01 00:09:26</td>\n",
       "      <td>-73.95069885253906</td>\n",
       "      <td>40.70836639404297</td>\n",
       "      <td>40.70836639404297,-73.95069885253906</td>\n",
       "      <td>11211</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803830</th>\n",
       "      <td>2014-02-01 00:03:06</td>\n",
       "      <td>-73.90729522705078</td>\n",
       "      <td>40.82366561889648</td>\n",
       "      <td>40.82366561889648,-73.90729522705078</td>\n",
       "      <td>10456</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803831</th>\n",
       "      <td>2014-02-01 00:24:37</td>\n",
       "      <td>-73.99241638183594</td>\n",
       "      <td>40.77412796020508</td>\n",
       "      <td>40.77412796020508,-73.99241638183594</td>\n",
       "      <td>10069</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803832</th>\n",
       "      <td>2014-02-01 00:13:19</td>\n",
       "      <td>-73.92374420166014</td>\n",
       "      <td>40.848541259765625</td>\n",
       "      <td>40.848541259765625,-73.92374420166014</td>\n",
       "      <td>10453</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803833</th>\n",
       "      <td>2014-02-01 00:01:41</td>\n",
       "      <td>-73.91270446777344</td>\n",
       "      <td>40.65454864501953</td>\n",
       "      <td>40.65454864501953,-73.91270446777344</td>\n",
       "      <td>11212</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803834</th>\n",
       "      <td>2014-02-01 00:04:41</td>\n",
       "      <td>-73.8609619140625</td>\n",
       "      <td>40.71916580200195</td>\n",
       "      <td>40.71916580200195,-73.8609619140625</td>\n",
       "      <td>11374</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803835</th>\n",
       "      <td>2014-02-01 00:11:57</td>\n",
       "      <td>-73.91472625732422</td>\n",
       "      <td>40.766029357910156</td>\n",
       "      <td>40.766029357910156,-73.91472625732422</td>\n",
       "      <td>11103</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803836</th>\n",
       "      <td>2014-02-01 00:04:13</td>\n",
       "      <td>-73.91758728027342</td>\n",
       "      <td>40.75825119018555</td>\n",
       "      <td>40.75825119018555,-73.91758728027342</td>\n",
       "      <td>11103</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803837</th>\n",
       "      <td>2014-02-01 00:04:19</td>\n",
       "      <td>-73.8267822265625</td>\n",
       "      <td>40.853111267089844</td>\n",
       "      <td>40.853111267089844,-73.8267822265625</td>\n",
       "      <td>10461</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803838</th>\n",
       "      <td>2014-02-01 00:28:32</td>\n",
       "      <td>-73.99227142333984</td>\n",
       "      <td>40.75989151000977</td>\n",
       "      <td>40.75989151000977,-73.99227142333984</td>\n",
       "      <td>10036</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803839</th>\n",
       "      <td>2014-02-01 00:36:05</td>\n",
       "      <td>-73.99736022949219</td>\n",
       "      <td>40.71893310546875</td>\n",
       "      <td>40.71893310546875,-73.99736022949219</td>\n",
       "      <td>10012</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803840</th>\n",
       "      <td>2014-02-01 00:03:38</td>\n",
       "      <td>-73.98847198486328</td>\n",
       "      <td>40.66653823852539</td>\n",
       "      <td>40.66653823852539,-73.98847198486328</td>\n",
       "      <td>11215</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803841</th>\n",
       "      <td>2014-02-01 00:22:18</td>\n",
       "      <td>-73.86181640625</td>\n",
       "      <td>40.69072341918945</td>\n",
       "      <td>40.69072341918945,-73.86181640625</td>\n",
       "      <td>11421</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803842</th>\n",
       "      <td>2014-02-01 00:08:49</td>\n",
       "      <td>-73.96247100830078</td>\n",
       "      <td>40.68169403076172</td>\n",
       "      <td>40.68169403076172,-73.96247100830078</td>\n",
       "      <td>11238</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803843</th>\n",
       "      <td>2014-02-01 00:05:06</td>\n",
       "      <td>-73.9397964477539</td>\n",
       "      <td>40.6927146911621</td>\n",
       "      <td>40.6927146911621,-73.9397964477539</td>\n",
       "      <td>11221</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803844</th>\n",
       "      <td>2014-02-01 00:28:47</td>\n",
       "      <td>-73.97882843017578</td>\n",
       "      <td>40.64572525024415</td>\n",
       "      <td>40.64572525024415,-73.97882843017578</td>\n",
       "      <td>11218</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803845</th>\n",
       "      <td>2014-02-01 00:05:17</td>\n",
       "      <td>-73.94651794433594</td>\n",
       "      <td>40.83050537109375</td>\n",
       "      <td>40.83050537109375,-73.94651794433594</td>\n",
       "      <td>10031</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803846</th>\n",
       "      <td>2014-02-01 00:10:00</td>\n",
       "      <td>-73.96923828125</td>\n",
       "      <td>40.69315719604492</td>\n",
       "      <td>40.69315719604492,-73.96923828125</td>\n",
       "      <td>11205</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803847</th>\n",
       "      <td>2014-02-01 00:03:26</td>\n",
       "      <td>-73.95223999023438</td>\n",
       "      <td>40.723331451416016</td>\n",
       "      <td>40.723331451416016,-73.95223999023438</td>\n",
       "      <td>11222</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803848</th>\n",
       "      <td>2014-02-01 00:06:59</td>\n",
       "      <td>-73.87631225585938</td>\n",
       "      <td>40.76841354370117</td>\n",
       "      <td>40.76841354370117,-73.87631225585938</td>\n",
       "      <td>11369</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803849</th>\n",
       "      <td>2014-02-01 00:03:49</td>\n",
       "      <td>-73.99173736572266</td>\n",
       "      <td>40.66295623779297</td>\n",
       "      <td>40.66295623779297,-73.99173736572266</td>\n",
       "      <td>11215</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803850</th>\n",
       "      <td>2014-02-01 00:24:27</td>\n",
       "      <td>-74.00752258300781</td>\n",
       "      <td>40.725669860839844</td>\n",
       "      <td>40.725669860839844,-74.00752258300781</td>\n",
       "      <td>10013</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803851</th>\n",
       "      <td>2014-02-01 00:01:53</td>\n",
       "      <td>-73.94210815429686</td>\n",
       "      <td>40.75413513183594</td>\n",
       "      <td>40.75413513183594,-73.94210815429686</td>\n",
       "      <td>11101</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>802193 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Date                 Lon                 Lat  \\\n",
       "0       2014-01-01 01:08:06  -73.86504364013672   40.87230682373047   \n",
       "1       2014-01-01 06:03:57      -73.7763671875   40.64548873901367   \n",
       "2       2014-01-01 18:22:44  -73.93264770507811   40.85257339477539   \n",
       "3       2014-01-01 00:52:03  -73.99407958984375   40.74909210205078   \n",
       "4       2014-01-01 00:49:25  -73.93606567382812   40.73472595214844   \n",
       "5       2014-01-01 00:01:15   -73.9121551513672  40.684059143066406   \n",
       "6       2014-01-01 02:37:20  -73.93531799316406   40.73701095581055   \n",
       "7       2014-01-01 15:24:02  -73.93746948242188  40.804195404052734   \n",
       "9       2014-01-01 01:17:43  -73.91567993164062   40.77630615234375   \n",
       "10      2014-01-01 19:07:40  -73.94893646240234   40.66542053222656   \n",
       "11      2014-01-01 05:08:05  -74.01026916503906   40.64192199707031   \n",
       "12      2014-01-01 13:04:11  -73.99115753173827  40.639381408691406   \n",
       "13      2014-01-01 00:08:28   -73.8885498046875  40.745452880859375   \n",
       "14      2014-01-01 00:10:30   -73.7994155883789   40.73357772827149   \n",
       "15      2014-01-01 00:07:26  -73.81632995605469   40.71437454223633   \n",
       "16      2014-01-01 00:18:35  -73.94696044921875  40.751373291015625   \n",
       "17      2014-01-01 00:04:05  -73.94689178466798   40.81333541870117   \n",
       "18      2014-01-01 00:08:32  -73.93402099609375   40.73625564575195   \n",
       "19      2014-01-01 00:11:36  -73.96392822265625   40.76107025146485   \n",
       "20      2014-01-01 00:06:03  -73.88463592529298   40.84214782714844   \n",
       "21      2014-01-01 00:16:14   -73.9070816040039  40.836612701416016   \n",
       "22      2014-01-01 00:08:37  -73.90294647216798   40.74587631225585   \n",
       "23      2014-01-01 00:07:44    -73.942626953125    40.8218879699707   \n",
       "24      2014-01-01 00:05:42  -74.00379943847656   40.65483474731445   \n",
       "25      2014-01-01 00:07:29  -73.88490295410156  40.739173889160156   \n",
       "26      2014-01-01 00:14:42  -73.94159698486328   40.70816040039063   \n",
       "27      2014-01-01 00:05:36  -73.93653106689453  40.669700622558594   \n",
       "28      2014-01-01 00:15:36  -73.98289489746094   40.77192687988281   \n",
       "29      2014-01-01 00:28:57  -73.99605560302734   40.73101425170898   \n",
       "30      2014-01-01 00:12:13  -73.99508666992188   40.66054153442383   \n",
       "...                     ...                 ...                 ...   \n",
       "803822  2014-02-01 00:04:46  -73.93846893310547   40.82762145996094   \n",
       "803823  2014-02-01 00:06:55  -73.88549041748048   40.84670639038085   \n",
       "803824  2014-02-01 00:24:29  -73.99298858642578   40.75647735595703   \n",
       "803825  2014-02-01 00:17:20  -73.98692321777342   40.75789260864258   \n",
       "803826  2014-02-01 00:13:14  -74.00065612792969   40.72328567504883   \n",
       "803827  2014-02-01 00:21:41  -73.99188995361328   40.74481201171875   \n",
       "803828  2014-02-01 00:06:45  -73.96165466308594   40.80596160888672   \n",
       "803829  2014-02-01 00:09:26  -73.95069885253906   40.70836639404297   \n",
       "803830  2014-02-01 00:03:06  -73.90729522705078   40.82366561889648   \n",
       "803831  2014-02-01 00:24:37  -73.99241638183594   40.77412796020508   \n",
       "803832  2014-02-01 00:13:19  -73.92374420166014  40.848541259765625   \n",
       "803833  2014-02-01 00:01:41  -73.91270446777344   40.65454864501953   \n",
       "803834  2014-02-01 00:04:41   -73.8609619140625   40.71916580200195   \n",
       "803835  2014-02-01 00:11:57  -73.91472625732422  40.766029357910156   \n",
       "803836  2014-02-01 00:04:13  -73.91758728027342   40.75825119018555   \n",
       "803837  2014-02-01 00:04:19   -73.8267822265625  40.853111267089844   \n",
       "803838  2014-02-01 00:28:32  -73.99227142333984   40.75989151000977   \n",
       "803839  2014-02-01 00:36:05  -73.99736022949219   40.71893310546875   \n",
       "803840  2014-02-01 00:03:38  -73.98847198486328   40.66653823852539   \n",
       "803841  2014-02-01 00:22:18     -73.86181640625   40.69072341918945   \n",
       "803842  2014-02-01 00:08:49  -73.96247100830078   40.68169403076172   \n",
       "803843  2014-02-01 00:05:06   -73.9397964477539    40.6927146911621   \n",
       "803844  2014-02-01 00:28:47  -73.97882843017578   40.64572525024415   \n",
       "803845  2014-02-01 00:05:17  -73.94651794433594   40.83050537109375   \n",
       "803846  2014-02-01 00:10:00     -73.96923828125   40.69315719604492   \n",
       "803847  2014-02-01 00:03:26  -73.95223999023438  40.723331451416016   \n",
       "803848  2014-02-01 00:06:59  -73.87631225585938   40.76841354370117   \n",
       "803849  2014-02-01 00:03:49  -73.99173736572266   40.66295623779297   \n",
       "803850  2014-02-01 00:24:27  -74.00752258300781  40.725669860839844   \n",
       "803851  2014-02-01 00:01:53  -73.94210815429686   40.75413513183594   \n",
       "\n",
       "                                        Coord Zipcode  Month  Day  Hour  \\\n",
       "0        40.87230682373047,-73.86504364013672   10467      1    1     1   \n",
       "1            40.64548873901367,-73.7763671875   11430      1    1     6   \n",
       "2        40.85257339477539,-73.93264770507811   10033      1    1    18   \n",
       "3        40.74909210205078,-73.99407958984375   10119      1    1     0   \n",
       "4        40.73472595214844,-73.93606567382812   11101      1    1     0   \n",
       "5        40.684059143066406,-73.9121551513672   11233      1    1     0   \n",
       "6        40.73701095581055,-73.93531799316406   11101      1    1     2   \n",
       "7       40.804195404052734,-73.93746948242188   10037      1    1    15   \n",
       "9        40.77630615234375,-73.91567993164062   11105      1    1     1   \n",
       "10       40.66542053222656,-73.94893646240234   11225      1    1    19   \n",
       "11       40.64192199707031,-74.01026916503906   11220      1    1     5   \n",
       "12      40.639381408691406,-73.99115753173827   11219      1    1    13   \n",
       "13       40.745452880859375,-73.8885498046875   11372      1    1     0   \n",
       "14        40.73357772827149,-73.7994155883789   11366      1    1     0   \n",
       "15       40.71437454223633,-73.81632995605469   11415      1    1     0   \n",
       "16      40.751373291015625,-73.94696044921875   11101      1    1     0   \n",
       "17       40.81333541870117,-73.94689178466798   10030      1    1     0   \n",
       "18       40.73625564575195,-73.93402099609375   11101      1    1     0   \n",
       "19       40.76107025146485,-73.96392822265625   10065      1    1     0   \n",
       "20       40.84214782714844,-73.88463592529298   10460      1    1     0   \n",
       "21       40.836612701416016,-73.9070816040039   10456      1    1     0   \n",
       "22       40.74587631225585,-73.90294647216798   11377      1    1     0   \n",
       "23          40.8218879699707,-73.942626953125   10030      1    1     0   \n",
       "24       40.65483474731445,-74.00379943847656   11232      1    1     0   \n",
       "25      40.739173889160156,-73.88490295410156   11373      1    1     0   \n",
       "26       40.70816040039063,-73.94159698486328   11206      1    1     0   \n",
       "27      40.669700622558594,-73.93653106689453   11213      1    1     0   \n",
       "28       40.77192687988281,-73.98289489746094   10023      1    1     0   \n",
       "29       40.73101425170898,-73.99605560302734   10012      1    1     0   \n",
       "30       40.66054153442383,-73.99508666992188   11232      1    1     0   \n",
       "...                                       ...     ...    ...  ...   ...   \n",
       "803822   40.82762145996094,-73.93846893310547   10039      2    1     0   \n",
       "803823   40.84670639038085,-73.88549041748048   10460      2    1     0   \n",
       "803824   40.75647735595703,-73.99298858642578   10018      2    1     0   \n",
       "803825   40.75789260864258,-73.98692321777342   10020      2    1     0   \n",
       "803826   40.72328567504883,-74.00065612792969   10012      2    1     0   \n",
       "803827   40.74481201171875,-73.99188995361328   10119      2    1     0   \n",
       "803828   40.80596160888672,-73.96165466308594   10115      2    1     0   \n",
       "803829   40.70836639404297,-73.95069885253906   11211      2    1     0   \n",
       "803830   40.82366561889648,-73.90729522705078   10456      2    1     0   \n",
       "803831   40.77412796020508,-73.99241638183594   10069      2    1     0   \n",
       "803832  40.848541259765625,-73.92374420166014   10453      2    1     0   \n",
       "803833   40.65454864501953,-73.91270446777344   11212      2    1     0   \n",
       "803834    40.71916580200195,-73.8609619140625   11374      2    1     0   \n",
       "803835  40.766029357910156,-73.91472625732422   11103      2    1     0   \n",
       "803836   40.75825119018555,-73.91758728027342   11103      2    1     0   \n",
       "803837   40.853111267089844,-73.8267822265625   10461      2    1     0   \n",
       "803838   40.75989151000977,-73.99227142333984   10036      2    1     0   \n",
       "803839   40.71893310546875,-73.99736022949219   10012      2    1     0   \n",
       "803840   40.66653823852539,-73.98847198486328   11215      2    1     0   \n",
       "803841      40.69072341918945,-73.86181640625   11421      2    1     0   \n",
       "803842   40.68169403076172,-73.96247100830078   11238      2    1     0   \n",
       "803843     40.6927146911621,-73.9397964477539   11221      2    1     0   \n",
       "803844   40.64572525024415,-73.97882843017578   11218      2    1     0   \n",
       "803845   40.83050537109375,-73.94651794433594   10031      2    1     0   \n",
       "803846      40.69315719604492,-73.96923828125   11205      2    1     0   \n",
       "803847  40.723331451416016,-73.95223999023438   11222      2    1     0   \n",
       "803848   40.76841354370117,-73.87631225585938   11369      2    1     0   \n",
       "803849   40.66295623779297,-73.99173736572266   11215      2    1     0   \n",
       "803850  40.725669860839844,-74.00752258300781   10013      2    1     0   \n",
       "803851   40.75413513183594,-73.94210815429686   11101      2    1     0   \n",
       "\n",
       "        Weekday  \n",
       "0             2  \n",
       "1             2  \n",
       "2             2  \n",
       "3             2  \n",
       "4             2  \n",
       "5             2  \n",
       "6             2  \n",
       "7             2  \n",
       "9             2  \n",
       "10            2  \n",
       "11            2  \n",
       "12            2  \n",
       "13            2  \n",
       "14            2  \n",
       "15            2  \n",
       "16            2  \n",
       "17            2  \n",
       "18            2  \n",
       "19            2  \n",
       "20            2  \n",
       "21            2  \n",
       "22            2  \n",
       "23            2  \n",
       "24            2  \n",
       "25            2  \n",
       "26            2  \n",
       "27            2  \n",
       "28            2  \n",
       "29            2  \n",
       "30            2  \n",
       "...         ...  \n",
       "803822        5  \n",
       "803823        5  \n",
       "803824        5  \n",
       "803825        5  \n",
       "803826        5  \n",
       "803827        5  \n",
       "803828        5  \n",
       "803829        5  \n",
       "803830        5  \n",
       "803831        5  \n",
       "803832        5  \n",
       "803833        5  \n",
       "803834        5  \n",
       "803835        5  \n",
       "803836        5  \n",
       "803837        5  \n",
       "803838        5  \n",
       "803839        5  \n",
       "803840        5  \n",
       "803841        5  \n",
       "803842        5  \n",
       "803843        5  \n",
       "803844        5  \n",
       "803845        5  \n",
       "803846        5  \n",
       "803847        5  \n",
       "803848        5  \n",
       "803849        5  \n",
       "803850        5  \n",
       "803851        5  \n",
       "\n",
       "[802193 rows x 9 columns]"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "green1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "group=green1.groupby(['Month', 'Day', 'Hour', 'Zipcode']).size().reset_index(name='count')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "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>Month</th>\n",
       "      <th>Day</th>\n",
       "      <th>Hour</th>\n",
       "      <th>Zipcode</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>07030</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>07605</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10001</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10002</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10003</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10004</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10005</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10006</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10007</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10009</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10010</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10011</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10012</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10013</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10014</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10016</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10017</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10019</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10020</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10021</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10022</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10023</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10024</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10025</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10026</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10027</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10028</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10029</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10030</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10031</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98998</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>11415</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98999</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>11419</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99000</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>11420</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99001</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>11421</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99002</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>11422</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99003</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>11423</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99004</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>11429</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99005</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>11434</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99006</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>11435</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99007</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>11580</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99008</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>10009</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99009</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>10037</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99010</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>11354</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99011</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>11103</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99012</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>11370</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99013</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>10003</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99014</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>10453</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99015</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>10028</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99016</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>11226</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99017</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>11413</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99018</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>10128</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99019</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>10455</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99020</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>11217</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99021</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>11367</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99022</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>10119</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99023</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>11231</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99024</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>11205</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99025</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>10040</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99026</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>10069</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99027</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>10456</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>99028 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Month  Day  Hour Zipcode  count\n",
       "0          1    1     0   07030      1\n",
       "1          1    1     0   07605      1\n",
       "2          1    1     0   10001      4\n",
       "3          1    1     0   10002     13\n",
       "4          1    1     0   10003      7\n",
       "5          1    1     0   10004      2\n",
       "6          1    1     0   10005      8\n",
       "7          1    1     0   10006      1\n",
       "8          1    1     0   10007      2\n",
       "9          1    1     0   10009     18\n",
       "10         1    1     0   10010     14\n",
       "11         1    1     0   10011      4\n",
       "12         1    1     0   10012     32\n",
       "13         1    1     0   10013      5\n",
       "14         1    1     0   10014     14\n",
       "15         1    1     0   10016     11\n",
       "16         1    1     0   10017      2\n",
       "17         1    1     0   10019     11\n",
       "18         1    1     0   10020      1\n",
       "19         1    1     0   10021      5\n",
       "20         1    1     0   10022     12\n",
       "21         1    1     0   10023      6\n",
       "22         1    1     0   10024     19\n",
       "23         1    1     0   10025     21\n",
       "24         1    1     0   10026     41\n",
       "25         1    1     0   10027     17\n",
       "26         1    1     0   10028      6\n",
       "27         1    1     0   10029     30\n",
       "28         1    1     0   10030     43\n",
       "29         1    1     0   10031     36\n",
       "...      ...  ...   ...     ...    ...\n",
       "98998      2    1     0   11415      4\n",
       "98999      2    1     0   11419      2\n",
       "99000      2    1     0   11420      1\n",
       "99001      2    1     0   11421      3\n",
       "99002      2    1     0   11422      2\n",
       "99003      2    1     0   11423      1\n",
       "99004      2    1     0   11429      1\n",
       "99005      2    1     0   11434      1\n",
       "99006      2    1     0   11435      1\n",
       "99007      2    1     0   11580      1\n",
       "99008      2    1     1   10009      1\n",
       "99009      2    1     1   10037      1\n",
       "99010      2    1     1   11354      1\n",
       "99011      2    1     3   11103      1\n",
       "99012      2    1     3   11370      1\n",
       "99013      2    1     9   10003      1\n",
       "99014      2    1    11   10453      1\n",
       "99015      2    1    14   10028      1\n",
       "99016      2    1    14   11226      1\n",
       "99017      2    1    14   11413      1\n",
       "99018      2    1    15   10128      1\n",
       "99019      2    1    15   10455      1\n",
       "99020      2    1    16   11217      1\n",
       "99021      2    1    16   11367      1\n",
       "99022      2    1    17   10119      1\n",
       "99023      2    1    18   11231      1\n",
       "99024      2    1    20   11205      1\n",
       "99025      2    1    21   10040      1\n",
       "99026      2    1    22   10069      1\n",
       "99027      2    1    23   10456      1\n",
       "\n",
       "[99028 rows x 5 columns]"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "group"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "green1.to_csv('nycmodeldataMay.csv',encoding='utf-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}