GeneratingzipAug.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "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": 2,
   "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_raw = pd.read_csv(\"green_tripdata_2014-08.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "green_raw.columns=[c.replace(\" \", \"\") for c in green_raw.columns]  \n",
    "green_raw['lpep_pickup_datetime']=green_raw['VendorID'] # the first 3 columns are mislabeled\n",
    "green_raw.index=np.arange(green_raw.shape[0])  # index is wrong\n",
    "green=green_raw[['lpep_pickup_datetime', 'Pickup_longitude', 'Pickup_latitude']]\n",
    "green.columns=['Date', 'Lon', 'Lat']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014-08-01 14:26:18</td>\n",
       "      <td>-73.953308</td>\n",
       "      <td>40.802399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-08-01 11:03:10</td>\n",
       "      <td>-73.882423</td>\n",
       "      <td>40.847561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-08-01 20:38:16</td>\n",
       "      <td>-74.003044</td>\n",
       "      <td>40.734299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-08-01 21:23:08</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014-08-01 04:31:25</td>\n",
       "      <td>-73.941559</td>\n",
       "      <td>40.798782</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Date        Lon        Lat\n",
       "0  2014-08-01 14:26:18 -73.953308  40.802399\n",
       "1  2014-08-01 11:03:10 -73.882423  40.847561\n",
       "2  2014-08-01 20:38:16 -74.003044  40.734299\n",
       "3  2014-08-01 21:23:08   0.000000   0.000000\n",
       "4  2014-08-01 04:31:25 -73.941559  40.798782"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "green[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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",
      "/Users/whiplash/anaconda3/lib/python3.6/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/whiplash/anaconda3/lib/python3.6/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[\"Lat\"] = green[\"Lat\"].astype(str)\n",
    "green[\"Lon\"] = green[\"Lon\"].astype(str)\n",
    "green[\"Coord\"] = green[[\"Lat\", \"Lon\"]].apply(lambda x: \",\".join(x), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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-08-01 14:26:18</td>\n",
       "      <td>-73.95330810546875</td>\n",
       "      <td>40.80239868164063</td>\n",
       "      <td>40.80239868164063,-73.95330810546875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-08-01 11:03:10</td>\n",
       "      <td>-73.8824234008789</td>\n",
       "      <td>40.84756088256836</td>\n",
       "      <td>40.84756088256836,-73.8824234008789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-08-01 20:38:16</td>\n",
       "      <td>-74.00304412841797</td>\n",
       "      <td>40.73429870605469</td>\n",
       "      <td>40.73429870605469,-74.00304412841797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-08-01 21:23:08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0,0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014-08-01 04:31:25</td>\n",
       "      <td>-73.94155883789062</td>\n",
       "      <td>40.79878234863281</td>\n",
       "      <td>40.79878234863281,-73.94155883789062</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Date                 Lon                Lat  \\\n",
       "0  2014-08-01 14:26:18  -73.95330810546875  40.80239868164063   \n",
       "1  2014-08-01 11:03:10   -73.8824234008789  40.84756088256836   \n",
       "2  2014-08-01 20:38:16  -74.00304412841797  40.73429870605469   \n",
       "3  2014-08-01 21:23:08                 0.0                0.0   \n",
       "4  2014-08-01 04:31:25  -73.94155883789062  40.79878234863281   \n",
       "\n",
       "                                  Coord  \n",
       "0  40.80239868164063,-73.95330810546875  \n",
       "1   40.84756088256836,-73.8824234008789  \n",
       "2  40.73429870605469,-74.00304412841797  \n",
       "3                               0.0,0.0  \n",
       "4  40.79878234863281,-73.94155883789062  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "green[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "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)):\n",
    "    res = search.by_coordinate(float(green[\"Lat\"][n]), float(green[\"Lon\"][n]), radius=5, 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": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1273973\n"
     ]
    }
   ],
   "source": [
    "print(len(output))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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[\"Zipcode\"] = output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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-07-01 22:33:05</td>\n",
       "      <td>-73.95280456542969</td>\n",
       "      <td>40.79909133911133</td>\n",
       "      <td>40.79909133911133,-73.95280456542969</td>\n",
       "      <td>10026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-07-01 22:12:19</td>\n",
       "      <td>-73.92530059814453</td>\n",
       "      <td>40.8060417175293</td>\n",
       "      <td>40.8060417175293,-73.92530059814453</td>\n",
       "      <td>10454</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-07-01 10:33:40</td>\n",
       "      <td>-73.93170928955078</td>\n",
       "      <td>40.79714584350585</td>\n",
       "      <td>40.79714584350585,-73.93170928955078</td>\n",
       "      <td>10035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-07-01 08:54:25</td>\n",
       "      <td>-73.91569519042969</td>\n",
       "      <td>40.77207565307617</td>\n",
       "      <td>40.77207565307617,-73.91569519042969</td>\n",
       "      <td>11103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014-07-01 08:42:46</td>\n",
       "      <td>-73.91033935546875</td>\n",
       "      <td>40.74473571777344</td>\n",
       "      <td>40.74473571777344,-73.91033935546875</td>\n",
       "      <td>11377</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Date                 Lon                Lat  \\\n",
       "0  2014-07-01 22:33:05  -73.95280456542969  40.79909133911133   \n",
       "1  2014-07-01 22:12:19  -73.92530059814453   40.8060417175293   \n",
       "2  2014-07-01 10:33:40  -73.93170928955078  40.79714584350585   \n",
       "3  2014-07-01 08:54:25  -73.91569519042969  40.77207565307617   \n",
       "4  2014-07-01 08:42:46  -73.91033935546875  40.74473571777344   \n",
       "\n",
       "                                  Coord Zipcode  \n",
       "0  40.79909133911133,-73.95280456542969   10026  \n",
       "1   40.8060417175293,-73.92530059814453   10454  \n",
       "2  40.79714584350585,-73.93170928955078   10035  \n",
       "3  40.77207565307617,-73.91569519042969   11103  \n",
       "4  40.74473571777344,-73.91033935546875   11377  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "green[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "nanlist = []\n",
    "for n in range(len(green)):\n",
    "    if green[\"Zipcode\"][n] == \"NaN\":\n",
    "        nanlist.append(n)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1795"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(nanlist)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1273973"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(green)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "green1 = green.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": 71,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.series.Series'>\n"
     ]
    }
   ],
   "source": [
    "# print(type(green[\"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": 15,
   "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": 16,
   "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-03-01 19:18:34</td>\n",
       "      <td>-73.87202453613281</td>\n",
       "      <td>40.67871475219727</td>\n",
       "      <td>40.67871475219727,-73.87202453613281</td>\n",
       "      <td>11208</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-03-01 13:10:37</td>\n",
       "      <td>-73.91783905029298</td>\n",
       "      <td>40.75776672363281</td>\n",
       "      <td>40.75776672363281,-73.91783905029298</td>\n",
       "      <td>11106</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-03-01 14:36:16</td>\n",
       "      <td>-73.88289642333984</td>\n",
       "      <td>40.87045669555664</td>\n",
       "      <td>40.87045669555664,-73.88289642333984</td>\n",
       "      <td>10458</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2014-03-01 08:05:26</td>\n",
       "      <td>-73.86398315429686</td>\n",
       "      <td>40.895206451416016</td>\n",
       "      <td>40.895206451416016,-73.86398315429686</td>\n",
       "      <td>10470</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2014-03-01 10:45:08</td>\n",
       "      <td>-73.98382568359375</td>\n",
       "      <td>40.67216491699219</td>\n",
       "      <td>40.67216491699219,-73.98382568359375</td>\n",
       "      <td>11215</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2014-03-01 19:23:12</td>\n",
       "      <td>-73.8975067138672</td>\n",
       "      <td>40.85656356811523</td>\n",
       "      <td>40.85656356811523,-73.8975067138672</td>\n",
       "      <td>10458</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2014-03-01 20:30:34</td>\n",
       "      <td>-73.83473205566406</td>\n",
       "      <td>40.769981384277344</td>\n",
       "      <td>40.769981384277344,-73.83473205566406</td>\n",
       "      <td>11351</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2014-03-01 02:11:02</td>\n",
       "      <td>-73.96269226074219</td>\n",
       "      <td>40.80527877807617</td>\n",
       "      <td>40.80527877807617,-73.96269226074219</td>\n",
       "      <td>10115</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2014-03-01 01:12:02</td>\n",
       "      <td>-73.81257629394531</td>\n",
       "      <td>40.72515869140625</td>\n",
       "      <td>40.72515869140625,-73.81257629394531</td>\n",
       "      <td>11367</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2014-03-01 00:11:44</td>\n",
       "      <td>-73.7594223022461</td>\n",
       "      <td>40.7049674987793</td>\n",
       "      <td>40.7049674987793,-73.7594223022461</td>\n",
       "      <td>11412</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2014-03-01 09:35:57</td>\n",
       "      <td>-74.00832366943358</td>\n",
       "      <td>40.733074188232415</td>\n",
       "      <td>40.733074188232415,-74.00832366943358</td>\n",
       "      <td>10014</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2014-03-01 20:03:23</td>\n",
       "      <td>-73.9344711303711</td>\n",
       "      <td>40.75353240966797</td>\n",
       "      <td>40.75353240966797,-73.9344711303711</td>\n",
       "      <td>11106</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2014-03-01 09:25:16</td>\n",
       "      <td>-73.96477508544923</td>\n",
       "      <td>40.71321868896485</td>\n",
       "      <td>40.71321868896485,-73.96477508544923</td>\n",
       "      <td>11211</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2014-03-01 14:30:15</td>\n",
       "      <td>-73.79309844970702</td>\n",
       "      <td>40.6992073059082</td>\n",
       "      <td>40.6992073059082,-73.79309844970702</td>\n",
       "      <td>11433</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2014-03-01 08:15:29</td>\n",
       "      <td>-73.99456024169923</td>\n",
       "      <td>40.738136291503906</td>\n",
       "      <td>40.738136291503906,-73.99456024169923</td>\n",
       "      <td>10003</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2014-03-01 19:50:35</td>\n",
       "      <td>-73.85631561279298</td>\n",
       "      <td>40.85512161254883</td>\n",
       "      <td>40.85512161254883,-73.85631561279298</td>\n",
       "      <td>10469</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2014-03-01 07:49:00</td>\n",
       "      <td>-73.9754638671875</td>\n",
       "      <td>40.750938415527344</td>\n",
       "      <td>40.750938415527344,-73.9754638671875</td>\n",
       "      <td>10174</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2014-03-01 11:26:06</td>\n",
       "      <td>-73.93744659423827</td>\n",
       "      <td>40.758167266845696</td>\n",
       "      <td>40.758167266845696,-73.93744659423827</td>\n",
       "      <td>11106</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2014-03-01 19:53:49</td>\n",
       "      <td>-73.99596405029298</td>\n",
       "      <td>40.69075012207031</td>\n",
       "      <td>40.69075012207031,-73.99596405029298</td>\n",
       "      <td>11201</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2014-03-01 21:11:09</td>\n",
       "      <td>-73.96179962158203</td>\n",
       "      <td>40.71344757080078</td>\n",
       "      <td>40.71344757080078,-73.96179962158203</td>\n",
       "      <td>11211</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2014-03-01 09:18:54</td>\n",
       "      <td>-73.83917999267578</td>\n",
       "      <td>40.8271484375</td>\n",
       "      <td>40.8271484375,-73.83917999267578</td>\n",
       "      <td>10465</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2014-03-01 21:11:52</td>\n",
       "      <td>-73.88394165039062</td>\n",
       "      <td>40.74192810058594</td>\n",
       "      <td>40.74192810058594,-73.88394165039062</td>\n",
       "      <td>11373</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2014-03-01 20:12:17</td>\n",
       "      <td>-73.86064147949219</td>\n",
       "      <td>40.756160736083984</td>\n",
       "      <td>40.756160736083984,-73.86064147949219</td>\n",
       "      <td>11368</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2014-03-01 00:04:27</td>\n",
       "      <td>-73.93758392333984</td>\n",
       "      <td>40.80434799194336</td>\n",
       "      <td>40.80434799194336,-73.93758392333984</td>\n",
       "      <td>10037</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2014-03-01 00:39:11</td>\n",
       "      <td>-73.90825653076173</td>\n",
       "      <td>40.69879150390625</td>\n",
       "      <td>40.69879150390625,-73.90825653076173</td>\n",
       "      <td>11385</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2014-03-01 00:14:32</td>\n",
       "      <td>-73.956787109375</td>\n",
       "      <td>40.713565826416016</td>\n",
       "      <td>40.713565826416016,-73.956787109375</td>\n",
       "      <td>11211</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2014-03-01 00:08:42</td>\n",
       "      <td>-73.93524169921875</td>\n",
       "      <td>40.79600524902344</td>\n",
       "      <td>40.79600524902344,-73.93524169921875</td>\n",
       "      <td>10035</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2014-03-01 00:08:34</td>\n",
       "      <td>-73.9547348022461</td>\n",
       "      <td>40.73288345336913</td>\n",
       "      <td>40.73288345336913,-73.9547348022461</td>\n",
       "      <td>11222</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2014-03-01 00:05:14</td>\n",
       "      <td>-73.8830337524414</td>\n",
       "      <td>40.75574493408203</td>\n",
       "      <td>40.75574493408203,-73.8830337524414</td>\n",
       "      <td>11372</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2014-03-01 00:05:50</td>\n",
       "      <td>-73.8905258178711</td>\n",
       "      <td>40.76810073852539</td>\n",
       "      <td>40.76810073852539,-73.8905258178711</td>\n",
       "      <td>11370</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</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>1293441</th>\n",
       "      <td>2014-04-01 00:03:31</td>\n",
       "      <td>-73.95318603515625</td>\n",
       "      <td>40.78880310058594</td>\n",
       "      <td>40.78880310058594,-73.95318603515625</td>\n",
       "      <td>10128</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293442</th>\n",
       "      <td>2014-04-01 00:06:41</td>\n",
       "      <td>-73.9197998046875</td>\n",
       "      <td>40.73789596557617</td>\n",
       "      <td>40.73789596557617,-73.9197998046875</td>\n",
       "      <td>11104</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293443</th>\n",
       "      <td>2014-04-01 00:05:14</td>\n",
       "      <td>-73.9351577758789</td>\n",
       "      <td>40.79597473144531</td>\n",
       "      <td>40.79597473144531,-73.9351577758789</td>\n",
       "      <td>10035</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293444</th>\n",
       "      <td>2014-04-01 00:08:06</td>\n",
       "      <td>-73.92054748535155</td>\n",
       "      <td>40.76658630371094</td>\n",
       "      <td>40.76658630371094,-73.92054748535155</td>\n",
       "      <td>11103</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293445</th>\n",
       "      <td>2014-04-01 00:07:24</td>\n",
       "      <td>-73.996826171875</td>\n",
       "      <td>40.71652603149415</td>\n",
       "      <td>40.71652603149415,-73.996826171875</td>\n",
       "      <td>10278</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293446</th>\n",
       "      <td>2014-04-01 00:05:13</td>\n",
       "      <td>-73.867919921875</td>\n",
       "      <td>40.744606018066406</td>\n",
       "      <td>40.744606018066406,-73.867919921875</td>\n",
       "      <td>11373</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293447</th>\n",
       "      <td>2014-04-01 00:08:00</td>\n",
       "      <td>-73.95252990722656</td>\n",
       "      <td>40.68902587890625</td>\n",
       "      <td>40.68902587890625,-73.95252990722656</td>\n",
       "      <td>11205</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293448</th>\n",
       "      <td>2014-04-01 00:09:46</td>\n",
       "      <td>-73.98297119140625</td>\n",
       "      <td>40.72674560546875</td>\n",
       "      <td>40.72674560546875,-73.98297119140625</td>\n",
       "      <td>10009</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293449</th>\n",
       "      <td>2014-04-01 00:09:01</td>\n",
       "      <td>-73.95700073242188</td>\n",
       "      <td>40.805137634277344</td>\n",
       "      <td>40.805137634277344,-73.95700073242188</td>\n",
       "      <td>10026</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293450</th>\n",
       "      <td>2014-04-01 00:03:12</td>\n",
       "      <td>-73.9414520263672</td>\n",
       "      <td>40.8521728515625</td>\n",
       "      <td>40.8521728515625,-73.9414520263672</td>\n",
       "      <td>10033</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293451</th>\n",
       "      <td>2014-04-01 00:18:45</td>\n",
       "      <td>-73.96533203125</td>\n",
       "      <td>40.695960998535156</td>\n",
       "      <td>40.695960998535156,-73.96533203125</td>\n",
       "      <td>11205</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293452</th>\n",
       "      <td>2014-04-01 00:31:24</td>\n",
       "      <td>-73.93367767333984</td>\n",
       "      <td>40.802898406982415</td>\n",
       "      <td>40.802898406982415,-73.93367767333984</td>\n",
       "      <td>10035</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293453</th>\n",
       "      <td>2014-04-01 00:04:10</td>\n",
       "      <td>-73.9424819946289</td>\n",
       "      <td>40.84469985961913</td>\n",
       "      <td>40.84469985961913,-73.9424819946289</td>\n",
       "      <td>10032</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293454</th>\n",
       "      <td>2014-04-01 00:06:25</td>\n",
       "      <td>-73.9449462890625</td>\n",
       "      <td>40.79176712036133</td>\n",
       "      <td>40.79176712036133,-73.9449462890625</td>\n",
       "      <td>10029</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293455</th>\n",
       "      <td>2014-04-01 00:12:33</td>\n",
       "      <td>-73.8567886352539</td>\n",
       "      <td>40.8289794921875</td>\n",
       "      <td>40.8289794921875,-73.8567886352539</td>\n",
       "      <td>10472</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293456</th>\n",
       "      <td>2014-04-01 00:11:13</td>\n",
       "      <td>-73.99664306640625</td>\n",
       "      <td>40.69789123535156</td>\n",
       "      <td>40.69789123535156,-73.99664306640625</td>\n",
       "      <td>11201</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293457</th>\n",
       "      <td>2014-04-01 00:00:43</td>\n",
       "      <td>-73.94132995605469</td>\n",
       "      <td>40.83752822875977</td>\n",
       "      <td>40.83752822875977,-73.94132995605469</td>\n",
       "      <td>10032</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293458</th>\n",
       "      <td>2014-04-01 00:05:18</td>\n",
       "      <td>-73.92596435546875</td>\n",
       "      <td>40.6924057006836</td>\n",
       "      <td>40.6924057006836,-73.92596435546875</td>\n",
       "      <td>11221</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293459</th>\n",
       "      <td>2014-04-01 00:07:30</td>\n",
       "      <td>-73.9554443359375</td>\n",
       "      <td>40.69472885131836</td>\n",
       "      <td>40.69472885131836,-73.9554443359375</td>\n",
       "      <td>11205</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293460</th>\n",
       "      <td>2014-04-01 00:04:02</td>\n",
       "      <td>-73.93569946289062</td>\n",
       "      <td>40.79617309570313</td>\n",
       "      <td>40.79617309570313,-73.93569946289062</td>\n",
       "      <td>10035</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293461</th>\n",
       "      <td>2014-04-01 00:02:33</td>\n",
       "      <td>-73.91093444824219</td>\n",
       "      <td>40.844947814941406</td>\n",
       "      <td>40.844947814941406,-73.91093444824219</td>\n",
       "      <td>10453</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293462</th>\n",
       "      <td>2014-04-01 00:10:17</td>\n",
       "      <td>-73.99040985107422</td>\n",
       "      <td>40.71943664550781</td>\n",
       "      <td>40.71943664550781,-73.99040985107422</td>\n",
       "      <td>10002</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293463</th>\n",
       "      <td>2014-04-01 00:07:44</td>\n",
       "      <td>-73.95304107666014</td>\n",
       "      <td>40.78682327270508</td>\n",
       "      <td>40.78682327270508,-73.95304107666014</td>\n",
       "      <td>10128</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293464</th>\n",
       "      <td>2014-04-01 00:01:00</td>\n",
       "      <td>-73.94337463378906</td>\n",
       "      <td>40.8282356262207</td>\n",
       "      <td>40.8282356262207,-73.94337463378906</td>\n",
       "      <td>10039</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293465</th>\n",
       "      <td>2014-04-01 00:05:06</td>\n",
       "      <td>-73.92985534667969</td>\n",
       "      <td>40.85498809814453</td>\n",
       "      <td>40.85498809814453,-73.92985534667969</td>\n",
       "      <td>10040</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293466</th>\n",
       "      <td>2014-04-01 00:12:06</td>\n",
       "      <td>-73.9916458129883</td>\n",
       "      <td>40.72986602783203</td>\n",
       "      <td>40.72986602783203,-73.9916458129883</td>\n",
       "      <td>10003</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293467</th>\n",
       "      <td>2014-04-01 00:02:53</td>\n",
       "      <td>-73.96243286132812</td>\n",
       "      <td>40.71000671386719</td>\n",
       "      <td>40.71000671386719,-73.96243286132812</td>\n",
       "      <td>11211</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293468</th>\n",
       "      <td>2014-04-01 00:04:01</td>\n",
       "      <td>-73.8874740600586</td>\n",
       "      <td>40.739723205566406</td>\n",
       "      <td>40.739723205566406,-73.8874740600586</td>\n",
       "      <td>11373</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293469</th>\n",
       "      <td>2014-04-01 00:05:28</td>\n",
       "      <td>-73.86199188232422</td>\n",
       "      <td>40.71734237670898</td>\n",
       "      <td>40.71734237670898,-73.86199188232422</td>\n",
       "      <td>11374</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293470</th>\n",
       "      <td>2014-04-01 00:05:37</td>\n",
       "      <td>-73.94294738769531</td>\n",
       "      <td>40.79009246826172</td>\n",
       "      <td>40.79009246826172,-73.94294738769531</td>\n",
       "      <td>10029</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1291483 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Date                 Lon                 Lat  \\\n",
       "0        2014-03-01 19:18:34  -73.87202453613281   40.67871475219727   \n",
       "1        2014-03-01 13:10:37  -73.91783905029298   40.75776672363281   \n",
       "2        2014-03-01 14:36:16  -73.88289642333984   40.87045669555664   \n",
       "7        2014-03-01 08:05:26  -73.86398315429686  40.895206451416016   \n",
       "9        2014-03-01 10:45:08  -73.98382568359375   40.67216491699219   \n",
       "10       2014-03-01 19:23:12   -73.8975067138672   40.85656356811523   \n",
       "11       2014-03-01 20:30:34  -73.83473205566406  40.769981384277344   \n",
       "12       2014-03-01 02:11:02  -73.96269226074219   40.80527877807617   \n",
       "13       2014-03-01 01:12:02  -73.81257629394531   40.72515869140625   \n",
       "14       2014-03-01 00:11:44   -73.7594223022461    40.7049674987793   \n",
       "15       2014-03-01 09:35:57  -74.00832366943358  40.733074188232415   \n",
       "16       2014-03-01 20:03:23   -73.9344711303711   40.75353240966797   \n",
       "17       2014-03-01 09:25:16  -73.96477508544923   40.71321868896485   \n",
       "19       2014-03-01 14:30:15  -73.79309844970702    40.6992073059082   \n",
       "20       2014-03-01 08:15:29  -73.99456024169923  40.738136291503906   \n",
       "21       2014-03-01 19:50:35  -73.85631561279298   40.85512161254883   \n",
       "23       2014-03-01 07:49:00   -73.9754638671875  40.750938415527344   \n",
       "25       2014-03-01 11:26:06  -73.93744659423827  40.758167266845696   \n",
       "26       2014-03-01 19:53:49  -73.99596405029298   40.69075012207031   \n",
       "28       2014-03-01 21:11:09  -73.96179962158203   40.71344757080078   \n",
       "29       2014-03-01 09:18:54  -73.83917999267578       40.8271484375   \n",
       "31       2014-03-01 21:11:52  -73.88394165039062   40.74192810058594   \n",
       "32       2014-03-01 20:12:17  -73.86064147949219  40.756160736083984   \n",
       "33       2014-03-01 00:04:27  -73.93758392333984   40.80434799194336   \n",
       "34       2014-03-01 00:39:11  -73.90825653076173   40.69879150390625   \n",
       "35       2014-03-01 00:14:32    -73.956787109375  40.713565826416016   \n",
       "36       2014-03-01 00:08:42  -73.93524169921875   40.79600524902344   \n",
       "37       2014-03-01 00:08:34   -73.9547348022461   40.73288345336913   \n",
       "38       2014-03-01 00:05:14   -73.8830337524414   40.75574493408203   \n",
       "39       2014-03-01 00:05:50   -73.8905258178711   40.76810073852539   \n",
       "...                      ...                 ...                 ...   \n",
       "1293441  2014-04-01 00:03:31  -73.95318603515625   40.78880310058594   \n",
       "1293442  2014-04-01 00:06:41   -73.9197998046875   40.73789596557617   \n",
       "1293443  2014-04-01 00:05:14   -73.9351577758789   40.79597473144531   \n",
       "1293444  2014-04-01 00:08:06  -73.92054748535155   40.76658630371094   \n",
       "1293445  2014-04-01 00:07:24    -73.996826171875   40.71652603149415   \n",
       "1293446  2014-04-01 00:05:13    -73.867919921875  40.744606018066406   \n",
       "1293447  2014-04-01 00:08:00  -73.95252990722656   40.68902587890625   \n",
       "1293448  2014-04-01 00:09:46  -73.98297119140625   40.72674560546875   \n",
       "1293449  2014-04-01 00:09:01  -73.95700073242188  40.805137634277344   \n",
       "1293450  2014-04-01 00:03:12   -73.9414520263672    40.8521728515625   \n",
       "1293451  2014-04-01 00:18:45     -73.96533203125  40.695960998535156   \n",
       "1293452  2014-04-01 00:31:24  -73.93367767333984  40.802898406982415   \n",
       "1293453  2014-04-01 00:04:10   -73.9424819946289   40.84469985961913   \n",
       "1293454  2014-04-01 00:06:25   -73.9449462890625   40.79176712036133   \n",
       "1293455  2014-04-01 00:12:33   -73.8567886352539    40.8289794921875   \n",
       "1293456  2014-04-01 00:11:13  -73.99664306640625   40.69789123535156   \n",
       "1293457  2014-04-01 00:00:43  -73.94132995605469   40.83752822875977   \n",
       "1293458  2014-04-01 00:05:18  -73.92596435546875    40.6924057006836   \n",
       "1293459  2014-04-01 00:07:30   -73.9554443359375   40.69472885131836   \n",
       "1293460  2014-04-01 00:04:02  -73.93569946289062   40.79617309570313   \n",
       "1293461  2014-04-01 00:02:33  -73.91093444824219  40.844947814941406   \n",
       "1293462  2014-04-01 00:10:17  -73.99040985107422   40.71943664550781   \n",
       "1293463  2014-04-01 00:07:44  -73.95304107666014   40.78682327270508   \n",
       "1293464  2014-04-01 00:01:00  -73.94337463378906    40.8282356262207   \n",
       "1293465  2014-04-01 00:05:06  -73.92985534667969   40.85498809814453   \n",
       "1293466  2014-04-01 00:12:06   -73.9916458129883   40.72986602783203   \n",
       "1293467  2014-04-01 00:02:53  -73.96243286132812   40.71000671386719   \n",
       "1293468  2014-04-01 00:04:01   -73.8874740600586  40.739723205566406   \n",
       "1293469  2014-04-01 00:05:28  -73.86199188232422   40.71734237670898   \n",
       "1293470  2014-04-01 00:05:37  -73.94294738769531   40.79009246826172   \n",
       "\n",
       "                                         Coord Zipcode  Month  Day  Hour  \\\n",
       "0         40.67871475219727,-73.87202453613281   11208      3    1    19   \n",
       "1         40.75776672363281,-73.91783905029298   11106      3    1    13   \n",
       "2         40.87045669555664,-73.88289642333984   10458      3    1    14   \n",
       "7        40.895206451416016,-73.86398315429686   10470      3    1     8   \n",
       "9         40.67216491699219,-73.98382568359375   11215      3    1    10   \n",
       "10         40.85656356811523,-73.8975067138672   10458      3    1    19   \n",
       "11       40.769981384277344,-73.83473205566406   11351      3    1    20   \n",
       "12        40.80527877807617,-73.96269226074219   10115      3    1     2   \n",
       "13        40.72515869140625,-73.81257629394531   11367      3    1     1   \n",
       "14          40.7049674987793,-73.7594223022461   11412      3    1     0   \n",
       "15       40.733074188232415,-74.00832366943358   10014      3    1     9   \n",
       "16         40.75353240966797,-73.9344711303711   11106      3    1    20   \n",
       "17        40.71321868896485,-73.96477508544923   11211      3    1     9   \n",
       "19         40.6992073059082,-73.79309844970702   11433      3    1    14   \n",
       "20       40.738136291503906,-73.99456024169923   10003      3    1     8   \n",
       "21        40.85512161254883,-73.85631561279298   10469      3    1    19   \n",
       "23        40.750938415527344,-73.9754638671875   10174      3    1     7   \n",
       "25       40.758167266845696,-73.93744659423827   11106      3    1    11   \n",
       "26        40.69075012207031,-73.99596405029298   11201      3    1    19   \n",
       "28        40.71344757080078,-73.96179962158203   11211      3    1    21   \n",
       "29            40.8271484375,-73.83917999267578   10465      3    1     9   \n",
       "31        40.74192810058594,-73.88394165039062   11373      3    1    21   \n",
       "32       40.756160736083984,-73.86064147949219   11368      3    1    20   \n",
       "33        40.80434799194336,-73.93758392333984   10037      3    1     0   \n",
       "34        40.69879150390625,-73.90825653076173   11385      3    1     0   \n",
       "35         40.713565826416016,-73.956787109375   11211      3    1     0   \n",
       "36        40.79600524902344,-73.93524169921875   10035      3    1     0   \n",
       "37         40.73288345336913,-73.9547348022461   11222      3    1     0   \n",
       "38         40.75574493408203,-73.8830337524414   11372      3    1     0   \n",
       "39         40.76810073852539,-73.8905258178711   11370      3    1     0   \n",
       "...                                        ...     ...    ...  ...   ...   \n",
       "1293441   40.78880310058594,-73.95318603515625   10128      4    1     0   \n",
       "1293442    40.73789596557617,-73.9197998046875   11104      4    1     0   \n",
       "1293443    40.79597473144531,-73.9351577758789   10035      4    1     0   \n",
       "1293444   40.76658630371094,-73.92054748535155   11103      4    1     0   \n",
       "1293445     40.71652603149415,-73.996826171875   10278      4    1     0   \n",
       "1293446    40.744606018066406,-73.867919921875   11373      4    1     0   \n",
       "1293447   40.68902587890625,-73.95252990722656   11205      4    1     0   \n",
       "1293448   40.72674560546875,-73.98297119140625   10009      4    1     0   \n",
       "1293449  40.805137634277344,-73.95700073242188   10026      4    1     0   \n",
       "1293450     40.8521728515625,-73.9414520263672   10033      4    1     0   \n",
       "1293451     40.695960998535156,-73.96533203125   11205      4    1     0   \n",
       "1293452  40.802898406982415,-73.93367767333984   10035      4    1     0   \n",
       "1293453    40.84469985961913,-73.9424819946289   10032      4    1     0   \n",
       "1293454    40.79176712036133,-73.9449462890625   10029      4    1     0   \n",
       "1293455     40.8289794921875,-73.8567886352539   10472      4    1     0   \n",
       "1293456   40.69789123535156,-73.99664306640625   11201      4    1     0   \n",
       "1293457   40.83752822875977,-73.94132995605469   10032      4    1     0   \n",
       "1293458    40.6924057006836,-73.92596435546875   11221      4    1     0   \n",
       "1293459    40.69472885131836,-73.9554443359375   11205      4    1     0   \n",
       "1293460   40.79617309570313,-73.93569946289062   10035      4    1     0   \n",
       "1293461  40.844947814941406,-73.91093444824219   10453      4    1     0   \n",
       "1293462   40.71943664550781,-73.99040985107422   10002      4    1     0   \n",
       "1293463   40.78682327270508,-73.95304107666014   10128      4    1     0   \n",
       "1293464    40.8282356262207,-73.94337463378906   10039      4    1     0   \n",
       "1293465   40.85498809814453,-73.92985534667969   10040      4    1     0   \n",
       "1293466    40.72986602783203,-73.9916458129883   10003      4    1     0   \n",
       "1293467   40.71000671386719,-73.96243286132812   11211      4    1     0   \n",
       "1293468   40.739723205566406,-73.8874740600586   11373      4    1     0   \n",
       "1293469   40.71734237670898,-73.86199188232422   11374      4    1     0   \n",
       "1293470   40.79009246826172,-73.94294738769531   10029      4    1     0   \n",
       "\n",
       "         Weekday  \n",
       "0              5  \n",
       "1              5  \n",
       "2              5  \n",
       "7              5  \n",
       "9              5  \n",
       "10             5  \n",
       "11             5  \n",
       "12             5  \n",
       "13             5  \n",
       "14             5  \n",
       "15             5  \n",
       "16             5  \n",
       "17             5  \n",
       "19             5  \n",
       "20             5  \n",
       "21             5  \n",
       "23             5  \n",
       "25             5  \n",
       "26             5  \n",
       "28             5  \n",
       "29             5  \n",
       "31             5  \n",
       "32             5  \n",
       "33             5  \n",
       "34             5  \n",
       "35             5  \n",
       "36             5  \n",
       "37             5  \n",
       "38             5  \n",
       "39             5  \n",
       "...          ...  \n",
       "1293441        1  \n",
       "1293442        1  \n",
       "1293443        1  \n",
       "1293444        1  \n",
       "1293445        1  \n",
       "1293446        1  \n",
       "1293447        1  \n",
       "1293448        1  \n",
       "1293449        1  \n",
       "1293450        1  \n",
       "1293451        1  \n",
       "1293452        1  \n",
       "1293453        1  \n",
       "1293454        1  \n",
       "1293455        1  \n",
       "1293456        1  \n",
       "1293457        1  \n",
       "1293458        1  \n",
       "1293459        1  \n",
       "1293460        1  \n",
       "1293461        1  \n",
       "1293462        1  \n",
       "1293463        1  \n",
       "1293464        1  \n",
       "1293465        1  \n",
       "1293466        1  \n",
       "1293467        1  \n",
       "1293468        1  \n",
       "1293469        1  \n",
       "1293470        1  \n",
       "\n",
       "[1291483 rows x 9 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "green1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# group=green1.groupby(['Month', 'Day', 'Hour', 'Zipcode']).size().reset_index(name='count')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# group"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "green1.to_csv('nycmodeldataaug.csv',encoding='utf-8')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}