Cleaning_Green_Taxis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#imports\n",
    "import pandas as pd\n",
    "import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#Load the csv file for green taxis into a pandas dataframe\n",
    "greenAug = pd.read_csv('green_tripdata_2013-08.csv')\n",
    "df_greenAug = pd.DataFrame(greenAug)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>VendorID</th>\n",
       "      <th>lpep_pickup_datetime</th>\n",
       "      <th>Lpep_dropoff_datetime</th>\n",
       "      <th>Store_and_fwd_flag</th>\n",
       "      <th>RateCodeID</th>\n",
       "      <th>Pickup_longitude</th>\n",
       "      <th>Pickup_latitude</th>\n",
       "      <th>Dropoff_longitude</th>\n",
       "      <th>Dropoff_latitude</th>\n",
       "      <th>Passenger_count</th>\n",
       "      <th>Trip_distance</th>\n",
       "      <th>Fare_amount</th>\n",
       "      <th>Extra</th>\n",
       "      <th>MTA_tax</th>\n",
       "      <th>Tip_amount</th>\n",
       "      <th>Tolls_amount</th>\n",
       "      <th>Ehail_fee</th>\n",
       "      <th>Total_amount</th>\n",
       "      <th>Payment_type</th>\n",
       "      <th>Trip_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"10\" valign=\"top\">2</th>\n",
       "      <th>2013-08-01 08:14:37</th>\n",
       "      <td>2013-08-01 09:09:06</td>\n",
       "      <td>N</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21.25</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.25</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-01 09:13:00</th>\n",
       "      <td>2013-08-01 11:38:00</td>\n",
       "      <td>N</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>74.50</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.00</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-01 09:48:00</th>\n",
       "      <td>2013-08-01 09:49:00</td>\n",
       "      <td>N</td>\n",
       "      <td>5</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.10</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-01 10:38:35</th>\n",
       "      <td>2013-08-01 10:38:51</td>\n",
       "      <td>N</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.25</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.25</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-01 11:51:45</th>\n",
       "      <td>2013-08-01 12:03:52</td>\n",
       "      <td>N</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.50</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.00</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-01 14:33:39</th>\n",
       "      <td>2013-08-01 15:49:00</td>\n",
       "      <td>N</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.50</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-01 17:19:00</th>\n",
       "      <td>2013-08-01 17:19:00</td>\n",
       "      <td>N</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.00</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-01 17:22:00</th>\n",
       "      <td>2013-08-01 17:22:00</td>\n",
       "      <td>N</td>\n",
       "      <td>1</td>\n",
       "      <td>-73.937767</td>\n",
       "      <td>40.758480</td>\n",
       "      <td>-73.937767</td>\n",
       "      <td>40.758480</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.33</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-01 17:24:00</th>\n",
       "      <td>2013-08-01 17:25:00</td>\n",
       "      <td>N</td>\n",
       "      <td>1</td>\n",
       "      <td>-73.937927</td>\n",
       "      <td>40.757843</td>\n",
       "      <td>-73.937927</td>\n",
       "      <td>40.757843</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.11</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-01 19:21:09</th>\n",
       "      <td>2013-08-01 19:22:30</td>\n",
       "      <td>N</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.50</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  VendorID lpep_pickup_datetime  \\\n",
       "2 2013-08-01 08:14:37  2013-08-01 09:09:06                    N   \n",
       "  2013-08-01 09:13:00  2013-08-01 11:38:00                    N   \n",
       "  2013-08-01 09:48:00  2013-08-01 09:49:00                    N   \n",
       "  2013-08-01 10:38:35  2013-08-01 10:38:51                    N   \n",
       "  2013-08-01 11:51:45  2013-08-01 12:03:52                    N   \n",
       "  2013-08-01 14:33:39  2013-08-01 15:49:00                    N   \n",
       "  2013-08-01 17:19:00  2013-08-01 17:19:00                    N   \n",
       "  2013-08-01 17:22:00  2013-08-01 17:22:00                    N   \n",
       "  2013-08-01 17:24:00  2013-08-01 17:25:00                    N   \n",
       "  2013-08-01 19:21:09  2013-08-01 19:22:30                    N   \n",
       "\n",
       "                       Lpep_dropoff_datetime  Store_and_fwd_flag  RateCodeID  \\\n",
       "2 2013-08-01 08:14:37                      1            0.000000    0.000000   \n",
       "  2013-08-01 09:13:00                      1            0.000000    0.000000   \n",
       "  2013-08-01 09:48:00                      5            0.000000    0.000000   \n",
       "  2013-08-01 10:38:35                      1            0.000000    0.000000   \n",
       "  2013-08-01 11:51:45                      1            0.000000    0.000000   \n",
       "  2013-08-01 14:33:39                      1            0.000000    0.000000   \n",
       "  2013-08-01 17:19:00                      1            0.000000    0.000000   \n",
       "  2013-08-01 17:22:00                      1          -73.937767   40.758480   \n",
       "  2013-08-01 17:24:00                      1          -73.937927   40.757843   \n",
       "  2013-08-01 19:21:09                      1            0.000000    0.000000   \n",
       "\n",
       "                       Pickup_longitude  Pickup_latitude  Dropoff_longitude  \\\n",
       "2 2013-08-01 08:14:37          0.000000         0.000000                  1   \n",
       "  2013-08-01 09:13:00          0.000000         0.000000                  2   \n",
       "  2013-08-01 09:48:00          0.000000         0.000000                  1   \n",
       "  2013-08-01 10:38:35          0.000000         0.000000                  1   \n",
       "  2013-08-01 11:51:45          0.000000         0.000000                  1   \n",
       "  2013-08-01 14:33:39          0.000000         0.000000                  1   \n",
       "  2013-08-01 17:19:00          0.000000         0.000000                  1   \n",
       "  2013-08-01 17:22:00        -73.937767        40.758480                  1   \n",
       "  2013-08-01 17:24:00        -73.937927        40.757843                  1   \n",
       "  2013-08-01 19:21:09          0.000000         0.000000                  5   \n",
       "\n",
       "                       Dropoff_latitude  Passenger_count  Trip_distance  \\\n",
       "2 2013-08-01 08:14:37               0.0            21.25            0.0   \n",
       "  2013-08-01 09:13:00               0.0            74.50            0.0   \n",
       "  2013-08-01 09:48:00               0.0             1.00            0.1   \n",
       "  2013-08-01 10:38:35               0.0             3.25            0.0   \n",
       "  2013-08-01 11:51:45               0.0             8.50            0.0   \n",
       "  2013-08-01 14:33:39               0.0             9.00            0.0   \n",
       "  2013-08-01 17:19:00               0.0             2.50            1.0   \n",
       "  2013-08-01 17:22:00               0.0             2.50            1.0   \n",
       "  2013-08-01 17:24:00               0.0             2.50            1.0   \n",
       "  2013-08-01 19:21:09               0.0             3.00            1.0   \n",
       "\n",
       "                       Fare_amount  Extra  MTA_tax  Tip_amount  Tolls_amount  \\\n",
       "2 2013-08-01 08:14:37          0.0    0.0     0.00         NaN         21.25   \n",
       "  2013-08-01 09:13:00          0.5    0.0     0.00         NaN         75.00   \n",
       "  2013-08-01 09:48:00          0.0    0.0     1.00         NaN          2.10   \n",
       "  2013-08-01 10:38:35          0.0    0.0     0.00         NaN          3.25   \n",
       "  2013-08-01 11:51:45          0.5    0.0     0.00         NaN          9.00   \n",
       "  2013-08-01 14:33:39          0.5    0.0     0.00         NaN          9.50   \n",
       "  2013-08-01 17:19:00          0.5    0.0     0.00         NaN          4.00   \n",
       "  2013-08-01 17:22:00          0.5    0.0     5.33         NaN          9.33   \n",
       "  2013-08-01 17:24:00          0.5    0.0     1.11         NaN          5.11   \n",
       "  2013-08-01 19:21:09          0.5    0.0     0.00         NaN          4.50   \n",
       "\n",
       "                       Ehail_fee  Total_amount  Payment_type  Trip_type   \n",
       "2 2013-08-01 08:14:37          2           NaN           NaN         NaN  \n",
       "  2013-08-01 09:13:00          2           NaN           NaN         NaN  \n",
       "  2013-08-01 09:48:00          2           NaN           NaN         NaN  \n",
       "  2013-08-01 10:38:35          2           NaN           NaN         NaN  \n",
       "  2013-08-01 11:51:45          2           NaN           NaN         NaN  \n",
       "  2013-08-01 14:33:39          2           NaN           NaN         NaN  \n",
       "  2013-08-01 17:19:00          2           NaN           NaN         NaN  \n",
       "  2013-08-01 17:22:00          2           NaN           NaN         NaN  \n",
       "  2013-08-01 17:24:00          2           NaN           NaN         NaN  \n",
       "  2013-08-01 19:21:09          1           NaN           NaN         NaN  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df_greenAug.head(n=10)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#drop rows without location data\n",
    "df_greenAug= df_greenAug[df_greenAug.Pickup_longitude != 0]\n",
    "#drop useless columns\n",
    "df_greenAug.drop(df_greenAug.columns[[1,2,7,8,10,11,12,13,14,15,16,17,18,19]],axis = 1,inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>VendorID</th>\n",
       "      <th>Store_and_fwd_flag</th>\n",
       "      <th>RateCodeID</th>\n",
       "      <th>Pickup_longitude</th>\n",
       "      <th>Pickup_latitude</th>\n",
       "      <th>Passenger_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">2</th>\n",
       "      <th>2013-08-01 17:22:00</th>\n",
       "      <td>2013-08-01 17:22:00</td>\n",
       "      <td>-73.937767</td>\n",
       "      <td>40.758480</td>\n",
       "      <td>-73.937767</td>\n",
       "      <td>40.758480</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-01 17:24:00</th>\n",
       "      <td>2013-08-01 17:25:00</td>\n",
       "      <td>-73.937927</td>\n",
       "      <td>40.757843</td>\n",
       "      <td>-73.937927</td>\n",
       "      <td>40.757843</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-05 11:31:47</th>\n",
       "      <td>2013-08-05 11:34:01</td>\n",
       "      <td>-115.179100</td>\n",
       "      <td>36.137096</td>\n",
       "      <td>-115.179337</td>\n",
       "      <td>36.136684</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-05 11:31:47</th>\n",
       "      <td>2013-08-05 11:32:16</td>\n",
       "      <td>-115.179100</td>\n",
       "      <td>36.137096</td>\n",
       "      <td>-115.179337</td>\n",
       "      <td>36.136684</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-05 11:51:21</th>\n",
       "      <td>2013-08-05 11:51:36</td>\n",
       "      <td>-115.179199</td>\n",
       "      <td>36.137047</td>\n",
       "      <td>-115.179199</td>\n",
       "      <td>36.137009</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-05 11:53:27</th>\n",
       "      <td>2013-08-05 11:53:43</td>\n",
       "      <td>-115.179337</td>\n",
       "      <td>36.136753</td>\n",
       "      <td>-115.179276</td>\n",
       "      <td>36.136826</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-06 06:51:19</th>\n",
       "      <td>2013-08-06 06:51:36</td>\n",
       "      <td>-73.937721</td>\n",
       "      <td>40.758404</td>\n",
       "      <td>-73.937721</td>\n",
       "      <td>40.758369</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-06 10:33:07</th>\n",
       "      <td>2013-08-06 10:33:46</td>\n",
       "      <td>-76.979668</td>\n",
       "      <td>38.927082</td>\n",
       "      <td>-76.979713</td>\n",
       "      <td>38.927326</td>\n",
       "      <td>3.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-06 13:26:34</th>\n",
       "      <td>2013-08-06 13:26:57</td>\n",
       "      <td>-73.937691</td>\n",
       "      <td>40.758419</td>\n",
       "      <td>-73.937790</td>\n",
       "      <td>40.758358</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-06 13:27:53</th>\n",
       "      <td>2013-08-06 13:28:08</td>\n",
       "      <td>-73.937805</td>\n",
       "      <td>40.758396</td>\n",
       "      <td>-73.937775</td>\n",
       "      <td>40.758450</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-06 13:29:17</th>\n",
       "      <td>2013-08-06 13:29:52</td>\n",
       "      <td>-73.937744</td>\n",
       "      <td>40.758415</td>\n",
       "      <td>-73.937759</td>\n",
       "      <td>40.758389</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-06 13:30:55</th>\n",
       "      <td>2013-08-06 13:31:12</td>\n",
       "      <td>-73.937775</td>\n",
       "      <td>40.758366</td>\n",
       "      <td>-73.937790</td>\n",
       "      <td>40.758350</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 10:22:30</th>\n",
       "      <td>2013-08-07 10:23:24</td>\n",
       "      <td>-76.979950</td>\n",
       "      <td>38.927292</td>\n",
       "      <td>-76.979591</td>\n",
       "      <td>38.927288</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 10:24:53</th>\n",
       "      <td>2013-08-07 10:28:16</td>\n",
       "      <td>-76.979668</td>\n",
       "      <td>38.927311</td>\n",
       "      <td>-76.979889</td>\n",
       "      <td>38.927174</td>\n",
       "      <td>3.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 10:24:53</th>\n",
       "      <td>2013-08-07 10:27:24</td>\n",
       "      <td>-76.979668</td>\n",
       "      <td>38.927311</td>\n",
       "      <td>-76.979813</td>\n",
       "      <td>38.927128</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 10:33:23</th>\n",
       "      <td>2013-08-07 10:34:10</td>\n",
       "      <td>-76.979790</td>\n",
       "      <td>38.927311</td>\n",
       "      <td>-76.979561</td>\n",
       "      <td>38.927151</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 14:12:46</th>\n",
       "      <td>2013-08-07 14:15:16</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758392</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758209</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 15:13:35</th>\n",
       "      <td>2013-08-07 15:13:49</td>\n",
       "      <td>-115.179192</td>\n",
       "      <td>36.136860</td>\n",
       "      <td>-115.179283</td>\n",
       "      <td>36.137066</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 15:38:07</th>\n",
       "      <td>2013-08-07 15:38:27</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758125</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758137</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 15:42:29</th>\n",
       "      <td>2013-08-07 15:43:25</td>\n",
       "      <td>-73.937477</td>\n",
       "      <td>40.758175</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758152</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 15:46:09</th>\n",
       "      <td>2013-08-07 15:48:56</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758244</td>\n",
       "      <td>-73.937508</td>\n",
       "      <td>40.758251</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 15:49:16</th>\n",
       "      <td>2013-08-07 15:49:32</td>\n",
       "      <td>-73.937508</td>\n",
       "      <td>40.758240</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758183</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:06:29</th>\n",
       "      <td>2013-08-07 16:08:52</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758240</td>\n",
       "      <td>-73.937469</td>\n",
       "      <td>40.758202</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:15:27</th>\n",
       "      <td>2013-08-07 16:18:27</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758167</td>\n",
       "      <td>-73.937431</td>\n",
       "      <td>40.758213</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:15:27</th>\n",
       "      <td>2013-08-07 16:20:09</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758167</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758251</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:27:31</th>\n",
       "      <td>2013-08-07 16:27:55</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758183</td>\n",
       "      <td>-73.937492</td>\n",
       "      <td>40.758194</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:27:31</th>\n",
       "      <td>2013-08-07 16:35:34</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758183</td>\n",
       "      <td>-73.937325</td>\n",
       "      <td>40.758198</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:38:29</th>\n",
       "      <td>2013-08-07 16:40:06</td>\n",
       "      <td>-73.937363</td>\n",
       "      <td>40.758148</td>\n",
       "      <td>-73.937416</td>\n",
       "      <td>40.758087</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:38:29</th>\n",
       "      <td>2013-08-07 16:46:51</td>\n",
       "      <td>-73.937363</td>\n",
       "      <td>40.758148</td>\n",
       "      <td>-73.937241</td>\n",
       "      <td>40.758106</td>\n",
       "      <td>5.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:43:27</th>\n",
       "      <td>2013-08-07 16:44:24</td>\n",
       "      <td>-73.937660</td>\n",
       "      <td>40.758347</td>\n",
       "      <td>-73.937729</td>\n",
       "      <td>40.758305</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <th>2013-08-31 23:23:38</th>\n",
       "      <td>2013-08-31 23:36:16</td>\n",
       "      <td>-73.913605</td>\n",
       "      <td>40.765427</td>\n",
       "      <td>-73.918091</td>\n",
       "      <td>40.741680</td>\n",
       "      <td>11.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"16\" valign=\"top\">2</th>\n",
       "      <th>2013-08-31 23:23:45</th>\n",
       "      <td>2013-08-31 23:34:26</td>\n",
       "      <td>-73.950272</td>\n",
       "      <td>40.680496</td>\n",
       "      <td>-73.934990</td>\n",
       "      <td>40.702396</td>\n",
       "      <td>10.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:23:49</th>\n",
       "      <td>2013-08-31 23:31:26</td>\n",
       "      <td>-73.844254</td>\n",
       "      <td>40.721390</td>\n",
       "      <td>-73.818474</td>\n",
       "      <td>40.734043</td>\n",
       "      <td>9.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:24:42</th>\n",
       "      <td>2013-08-31 23:50:50</td>\n",
       "      <td>-73.846169</td>\n",
       "      <td>40.754543</td>\n",
       "      <td>-73.965820</td>\n",
       "      <td>40.677544</td>\n",
       "      <td>39.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:25:05</th>\n",
       "      <td>2013-08-31 23:35:31</td>\n",
       "      <td>-73.861031</td>\n",
       "      <td>40.893051</td>\n",
       "      <td>-73.901611</td>\n",
       "      <td>40.876530</td>\n",
       "      <td>14.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:27:26</th>\n",
       "      <td>2013-08-31 23:54:49</td>\n",
       "      <td>-73.844818</td>\n",
       "      <td>40.754986</td>\n",
       "      <td>-73.969231</td>\n",
       "      <td>40.761219</td>\n",
       "      <td>26.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:27:46</th>\n",
       "      <td>2013-08-31 23:41:39</td>\n",
       "      <td>-73.954086</td>\n",
       "      <td>40.742813</td>\n",
       "      <td>-74.000793</td>\n",
       "      <td>40.736462</td>\n",
       "      <td>13.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:28:21</th>\n",
       "      <td>2013-09-01 00:00:58</td>\n",
       "      <td>-73.846001</td>\n",
       "      <td>40.754578</td>\n",
       "      <td>-73.974899</td>\n",
       "      <td>40.759235</td>\n",
       "      <td>38.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:30:53</th>\n",
       "      <td>2013-08-31 23:54:56</td>\n",
       "      <td>-73.849991</td>\n",
       "      <td>40.753479</td>\n",
       "      <td>-73.977623</td>\n",
       "      <td>40.779022</td>\n",
       "      <td>34.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:33:19</th>\n",
       "      <td>2013-08-31 23:38:51</td>\n",
       "      <td>-73.829971</td>\n",
       "      <td>40.713734</td>\n",
       "      <td>-73.824730</td>\n",
       "      <td>40.705601</td>\n",
       "      <td>5.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:34:00</th>\n",
       "      <td>2013-08-31 23:43:00</td>\n",
       "      <td>-73.845917</td>\n",
       "      <td>40.754639</td>\n",
       "      <td>-73.860458</td>\n",
       "      <td>40.739819</td>\n",
       "      <td>8.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:34:55</th>\n",
       "      <td>2013-08-31 23:51:43</td>\n",
       "      <td>-73.967758</td>\n",
       "      <td>40.693268</td>\n",
       "      <td>-73.989105</td>\n",
       "      <td>40.720303</td>\n",
       "      <td>14.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:34:58</th>\n",
       "      <td>2013-08-31 23:50:56</td>\n",
       "      <td>-73.991852</td>\n",
       "      <td>40.702530</td>\n",
       "      <td>-74.007256</td>\n",
       "      <td>40.733669</td>\n",
       "      <td>14.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:35:21</th>\n",
       "      <td>2013-08-31 23:48:13</td>\n",
       "      <td>-73.833656</td>\n",
       "      <td>40.771580</td>\n",
       "      <td>-73.843651</td>\n",
       "      <td>40.689556</td>\n",
       "      <td>22.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:40:04</th>\n",
       "      <td>2013-08-31 23:41:42</td>\n",
       "      <td>-73.926193</td>\n",
       "      <td>40.761082</td>\n",
       "      <td>-73.928421</td>\n",
       "      <td>40.756069</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:41:33</th>\n",
       "      <td>2013-09-01 00:00:18</td>\n",
       "      <td>-73.921158</td>\n",
       "      <td>40.743267</td>\n",
       "      <td>-73.902840</td>\n",
       "      <td>40.701447</td>\n",
       "      <td>17.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:44:17</th>\n",
       "      <td>2013-08-31 23:52:01</td>\n",
       "      <td>-73.946342</td>\n",
       "      <td>40.711445</td>\n",
       "      <td>-73.951027</td>\n",
       "      <td>40.724358</td>\n",
       "      <td>7.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <th>2013-08-31 23:45:43</th>\n",
       "      <td>2013-08-31 23:50:19</td>\n",
       "      <td>-73.979172</td>\n",
       "      <td>40.678406</td>\n",
       "      <td>-73.988785</td>\n",
       "      <td>40.670506</td>\n",
       "      <td>5.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"11\" valign=\"top\">2</th>\n",
       "      <th>2013-08-31 23:46:58</th>\n",
       "      <td>2013-08-31 23:51:07</td>\n",
       "      <td>-73.943985</td>\n",
       "      <td>40.784100</td>\n",
       "      <td>-73.952507</td>\n",
       "      <td>40.773121</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:48:10</th>\n",
       "      <td>2013-09-01 00:09:26</td>\n",
       "      <td>-73.924644</td>\n",
       "      <td>40.756287</td>\n",
       "      <td>-73.984779</td>\n",
       "      <td>40.710838</td>\n",
       "      <td>25.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:48:29</th>\n",
       "      <td>2013-08-31 23:59:44</td>\n",
       "      <td>-73.920647</td>\n",
       "      <td>40.767956</td>\n",
       "      <td>-73.885201</td>\n",
       "      <td>40.755516</td>\n",
       "      <td>11.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:50:37</th>\n",
       "      <td>2013-09-01 00:01:12</td>\n",
       "      <td>-73.941200</td>\n",
       "      <td>40.805779</td>\n",
       "      <td>-73.967400</td>\n",
       "      <td>40.801105</td>\n",
       "      <td>9.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:51:16</th>\n",
       "      <td>2013-08-31 23:58:45</td>\n",
       "      <td>-73.844307</td>\n",
       "      <td>40.721352</td>\n",
       "      <td>-73.827965</td>\n",
       "      <td>40.710865</td>\n",
       "      <td>8.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:52:57</th>\n",
       "      <td>2013-08-31 23:58:45</td>\n",
       "      <td>-73.917976</td>\n",
       "      <td>40.765259</td>\n",
       "      <td>-73.922600</td>\n",
       "      <td>40.755390</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:54:00</th>\n",
       "      <td>2013-08-31 00:06:00</td>\n",
       "      <td>-73.845985</td>\n",
       "      <td>40.754650</td>\n",
       "      <td>-73.884468</td>\n",
       "      <td>40.737869</td>\n",
       "      <td>15.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:54:50</th>\n",
       "      <td>2013-08-31 23:57:30</td>\n",
       "      <td>-73.943115</td>\n",
       "      <td>40.785336</td>\n",
       "      <td>-73.932846</td>\n",
       "      <td>40.796619</td>\n",
       "      <td>5.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:57:33</th>\n",
       "      <td>2013-09-01 00:10:03</td>\n",
       "      <td>-73.824432</td>\n",
       "      <td>40.734287</td>\n",
       "      <td>-73.850494</td>\n",
       "      <td>40.722317</td>\n",
       "      <td>11.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:58:18</th>\n",
       "      <td>2013-09-01 00:25:07</td>\n",
       "      <td>-73.964668</td>\n",
       "      <td>40.681309</td>\n",
       "      <td>-74.000633</td>\n",
       "      <td>40.732147</td>\n",
       "      <td>25.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:58:58</th>\n",
       "      <td>2013-09-01 00:06:31</td>\n",
       "      <td>-73.932343</td>\n",
       "      <td>40.796421</td>\n",
       "      <td>-73.955841</td>\n",
       "      <td>40.804691</td>\n",
       "      <td>7.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <th>2013-08-31 23:59:14</th>\n",
       "      <td>2013-09-01 00:07:40</td>\n",
       "      <td>-73.980034</td>\n",
       "      <td>40.676315</td>\n",
       "      <td>-73.964218</td>\n",
       "      <td>40.652081</td>\n",
       "      <td>9.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7095 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  VendorID  Store_and_fwd_flag  RateCodeID  \\\n",
       "2 2013-08-01 17:22:00  2013-08-01 17:22:00          -73.937767   40.758480   \n",
       "  2013-08-01 17:24:00  2013-08-01 17:25:00          -73.937927   40.757843   \n",
       "  2013-08-05 11:31:47  2013-08-05 11:34:01         -115.179100   36.137096   \n",
       "  2013-08-05 11:31:47  2013-08-05 11:32:16         -115.179100   36.137096   \n",
       "  2013-08-05 11:51:21  2013-08-05 11:51:36         -115.179199   36.137047   \n",
       "  2013-08-05 11:53:27  2013-08-05 11:53:43         -115.179337   36.136753   \n",
       "  2013-08-06 06:51:19  2013-08-06 06:51:36          -73.937721   40.758404   \n",
       "  2013-08-06 10:33:07  2013-08-06 10:33:46          -76.979668   38.927082   \n",
       "  2013-08-06 13:26:34  2013-08-06 13:26:57          -73.937691   40.758419   \n",
       "  2013-08-06 13:27:53  2013-08-06 13:28:08          -73.937805   40.758396   \n",
       "  2013-08-06 13:29:17  2013-08-06 13:29:52          -73.937744   40.758415   \n",
       "  2013-08-06 13:30:55  2013-08-06 13:31:12          -73.937775   40.758366   \n",
       "  2013-08-07 10:22:30  2013-08-07 10:23:24          -76.979950   38.927292   \n",
       "  2013-08-07 10:24:53  2013-08-07 10:28:16          -76.979668   38.927311   \n",
       "  2013-08-07 10:24:53  2013-08-07 10:27:24          -76.979668   38.927311   \n",
       "  2013-08-07 10:33:23  2013-08-07 10:34:10          -76.979790   38.927311   \n",
       "  2013-08-07 14:12:46  2013-08-07 14:15:16          -73.937485   40.758392   \n",
       "  2013-08-07 15:13:35  2013-08-07 15:13:49         -115.179192   36.136860   \n",
       "  2013-08-07 15:38:07  2013-08-07 15:38:27          -73.937485   40.758125   \n",
       "  2013-08-07 15:42:29  2013-08-07 15:43:25          -73.937477   40.758175   \n",
       "  2013-08-07 15:46:09  2013-08-07 15:48:56          -73.937447   40.758244   \n",
       "  2013-08-07 15:49:16  2013-08-07 15:49:32          -73.937508   40.758240   \n",
       "  2013-08-07 16:06:29  2013-08-07 16:08:52          -73.937424   40.758240   \n",
       "  2013-08-07 16:15:27  2013-08-07 16:18:27          -73.937424   40.758167   \n",
       "  2013-08-07 16:15:27  2013-08-07 16:20:09          -73.937424   40.758167   \n",
       "  2013-08-07 16:27:31  2013-08-07 16:27:55          -73.937447   40.758183   \n",
       "  2013-08-07 16:27:31  2013-08-07 16:35:34          -73.937447   40.758183   \n",
       "  2013-08-07 16:38:29  2013-08-07 16:40:06          -73.937363   40.758148   \n",
       "  2013-08-07 16:38:29  2013-08-07 16:46:51          -73.937363   40.758148   \n",
       "  2013-08-07 16:43:27  2013-08-07 16:44:24          -73.937660   40.758347   \n",
       "...                                    ...                 ...         ...   \n",
       "1 2013-08-31 23:23:38  2013-08-31 23:36:16          -73.913605   40.765427   \n",
       "2 2013-08-31 23:23:45  2013-08-31 23:34:26          -73.950272   40.680496   \n",
       "  2013-08-31 23:23:49  2013-08-31 23:31:26          -73.844254   40.721390   \n",
       "  2013-08-31 23:24:42  2013-08-31 23:50:50          -73.846169   40.754543   \n",
       "  2013-08-31 23:25:05  2013-08-31 23:35:31          -73.861031   40.893051   \n",
       "  2013-08-31 23:27:26  2013-08-31 23:54:49          -73.844818   40.754986   \n",
       "  2013-08-31 23:27:46  2013-08-31 23:41:39          -73.954086   40.742813   \n",
       "  2013-08-31 23:28:21  2013-09-01 00:00:58          -73.846001   40.754578   \n",
       "  2013-08-31 23:30:53  2013-08-31 23:54:56          -73.849991   40.753479   \n",
       "  2013-08-31 23:33:19  2013-08-31 23:38:51          -73.829971   40.713734   \n",
       "  2013-08-31 23:34:00  2013-08-31 23:43:00          -73.845917   40.754639   \n",
       "  2013-08-31 23:34:55  2013-08-31 23:51:43          -73.967758   40.693268   \n",
       "  2013-08-31 23:34:58  2013-08-31 23:50:56          -73.991852   40.702530   \n",
       "  2013-08-31 23:35:21  2013-08-31 23:48:13          -73.833656   40.771580   \n",
       "  2013-08-31 23:40:04  2013-08-31 23:41:42          -73.926193   40.761082   \n",
       "  2013-08-31 23:41:33  2013-09-01 00:00:18          -73.921158   40.743267   \n",
       "  2013-08-31 23:44:17  2013-08-31 23:52:01          -73.946342   40.711445   \n",
       "1 2013-08-31 23:45:43  2013-08-31 23:50:19          -73.979172   40.678406   \n",
       "2 2013-08-31 23:46:58  2013-08-31 23:51:07          -73.943985   40.784100   \n",
       "  2013-08-31 23:48:10  2013-09-01 00:09:26          -73.924644   40.756287   \n",
       "  2013-08-31 23:48:29  2013-08-31 23:59:44          -73.920647   40.767956   \n",
       "  2013-08-31 23:50:37  2013-09-01 00:01:12          -73.941200   40.805779   \n",
       "  2013-08-31 23:51:16  2013-08-31 23:58:45          -73.844307   40.721352   \n",
       "  2013-08-31 23:52:57  2013-08-31 23:58:45          -73.917976   40.765259   \n",
       "  2013-08-31 23:54:00  2013-08-31 00:06:00          -73.845985   40.754650   \n",
       "  2013-08-31 23:54:50  2013-08-31 23:57:30          -73.943115   40.785336   \n",
       "  2013-08-31 23:57:33  2013-09-01 00:10:03          -73.824432   40.734287   \n",
       "  2013-08-31 23:58:18  2013-09-01 00:25:07          -73.964668   40.681309   \n",
       "  2013-08-31 23:58:58  2013-09-01 00:06:31          -73.932343   40.796421   \n",
       "1 2013-08-31 23:59:14  2013-09-01 00:07:40          -73.980034   40.676315   \n",
       "\n",
       "                       Pickup_longitude  Pickup_latitude  Passenger_count  \n",
       "2 2013-08-01 17:22:00        -73.937767        40.758480             2.50  \n",
       "  2013-08-01 17:24:00        -73.937927        40.757843             2.50  \n",
       "  2013-08-05 11:31:47       -115.179337        36.136684             1.00  \n",
       "  2013-08-05 11:31:47       -115.179337        36.136684             1.20  \n",
       "  2013-08-05 11:51:21       -115.179199        36.137009             1.00  \n",
       "  2013-08-05 11:53:27       -115.179276        36.136826             1.00  \n",
       "  2013-08-06 06:51:19        -73.937721        40.758369             3.30  \n",
       "  2013-08-06 10:33:07        -76.979713        38.927326             3.25  \n",
       "  2013-08-06 13:26:34        -73.937790        40.758358             3.30  \n",
       "  2013-08-06 13:27:53        -73.937775        40.758450             3.30  \n",
       "  2013-08-06 13:29:17        -73.937759        40.758389             3.50  \n",
       "  2013-08-06 13:30:55        -73.937790        40.758350             3.30  \n",
       "  2013-08-07 10:22:30        -76.979591        38.927288             3.52  \n",
       "  2013-08-07 10:24:53        -76.979889        38.927174             3.25  \n",
       "  2013-08-07 10:24:53        -76.979813        38.927128             3.52  \n",
       "  2013-08-07 10:33:23        -76.979561        38.927151             3.52  \n",
       "  2013-08-07 14:12:46        -73.937485        40.758209             3.50  \n",
       "  2013-08-07 15:13:35       -115.179283        36.137066             1.00  \n",
       "  2013-08-07 15:38:07        -73.937485        40.758137             2.50  \n",
       "  2013-08-07 15:42:29        -73.937424        40.758152             2.50  \n",
       "  2013-08-07 15:46:09        -73.937508        40.758251             3.50  \n",
       "  2013-08-07 15:49:16        -73.937447        40.758183             2.50  \n",
       "  2013-08-07 16:06:29        -73.937469        40.758202             3.50  \n",
       "  2013-08-07 16:15:27        -73.937431        40.758213             2.50  \n",
       "  2013-08-07 16:15:27        -73.937424        40.758251             3.00  \n",
       "  2013-08-07 16:27:31        -73.937492        40.758194             2.50  \n",
       "  2013-08-07 16:27:31        -73.937325        40.758198             3.00  \n",
       "  2013-08-07 16:38:29        -73.937416        40.758087             2.50  \n",
       "  2013-08-07 16:38:29        -73.937241        40.758106             5.50  \n",
       "  2013-08-07 16:43:27        -73.937729        40.758305             2.50  \n",
       "...                                 ...              ...              ...  \n",
       "1 2013-08-31 23:23:38        -73.918091        40.741680            11.00  \n",
       "2 2013-08-31 23:23:45        -73.934990        40.702396            10.50  \n",
       "  2013-08-31 23:23:49        -73.818474        40.734043             9.00  \n",
       "  2013-08-31 23:24:42        -73.965820        40.677544            39.00  \n",
       "  2013-08-31 23:25:05        -73.901611        40.876530            14.00  \n",
       "  2013-08-31 23:27:26        -73.969231        40.761219            26.00  \n",
       "  2013-08-31 23:27:46        -74.000793        40.736462            13.50  \n",
       "  2013-08-31 23:28:21        -73.974899        40.759235            38.50  \n",
       "  2013-08-31 23:30:53        -73.977623        40.779022            34.00  \n",
       "  2013-08-31 23:33:19        -73.824730        40.705601             5.50  \n",
       "  2013-08-31 23:34:00        -73.860458        40.739819             8.50  \n",
       "  2013-08-31 23:34:55        -73.989105        40.720303            14.50  \n",
       "  2013-08-31 23:34:58        -74.007256        40.733669            14.50  \n",
       "  2013-08-31 23:35:21        -73.843651        40.689556            22.50  \n",
       "  2013-08-31 23:40:04        -73.928421        40.756069             3.50  \n",
       "  2013-08-31 23:41:33        -73.902840        40.701447            17.00  \n",
       "  2013-08-31 23:44:17        -73.951027        40.724358             7.50  \n",
       "1 2013-08-31 23:45:43        -73.988785        40.670506             5.50  \n",
       "2 2013-08-31 23:46:58        -73.952507        40.773121             6.00  \n",
       "  2013-08-31 23:48:10        -73.984779        40.710838            25.00  \n",
       "  2013-08-31 23:48:29        -73.885201        40.755516            11.50  \n",
       "  2013-08-31 23:50:37        -73.967400        40.801105             9.50  \n",
       "  2013-08-31 23:51:16        -73.827965        40.710865             8.00  \n",
       "  2013-08-31 23:52:57        -73.922600        40.755390             6.00  \n",
       "  2013-08-31 23:54:00        -73.884468        40.737869            15.00  \n",
       "  2013-08-31 23:54:50        -73.932846        40.796619             5.00  \n",
       "  2013-08-31 23:57:33        -73.850494        40.722317            11.50  \n",
       "  2013-08-31 23:58:18        -74.000633        40.732147            25.50  \n",
       "  2013-08-31 23:58:58        -73.955841        40.804691             7.50  \n",
       "1 2013-08-31 23:59:14        -73.964218        40.652081             9.00  \n",
       "\n",
       "[7095 rows x 6 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_greenAug"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#rename columns because of some extra commas in the csv\n",
    "df_greenAug.columns = ['Dropoff_time','Pickup_longitude','Pickup_latitude','Dropoff_longitude','Dropoff_latitude','Trip_distance']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Dropoff_time</th>\n",
       "      <th>Pickup_longitude</th>\n",
       "      <th>Pickup_latitude</th>\n",
       "      <th>Dropoff_longitude</th>\n",
       "      <th>Dropoff_latitude</th>\n",
       "      <th>Trip_distance</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">2</th>\n",
       "      <th>2013-08-01 17:22:00</th>\n",
       "      <td>2013-08-01 17:22:00</td>\n",
       "      <td>-73.937767</td>\n",
       "      <td>40.758480</td>\n",
       "      <td>-73.937767</td>\n",
       "      <td>40.758480</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-01 17:24:00</th>\n",
       "      <td>2013-08-01 17:25:00</td>\n",
       "      <td>-73.937927</td>\n",
       "      <td>40.757843</td>\n",
       "      <td>-73.937927</td>\n",
       "      <td>40.757843</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-05 11:31:47</th>\n",
       "      <td>2013-08-05 11:34:01</td>\n",
       "      <td>-115.179100</td>\n",
       "      <td>36.137096</td>\n",
       "      <td>-115.179337</td>\n",
       "      <td>36.136684</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-05 11:31:47</th>\n",
       "      <td>2013-08-05 11:32:16</td>\n",
       "      <td>-115.179100</td>\n",
       "      <td>36.137096</td>\n",
       "      <td>-115.179337</td>\n",
       "      <td>36.136684</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-05 11:51:21</th>\n",
       "      <td>2013-08-05 11:51:36</td>\n",
       "      <td>-115.179199</td>\n",
       "      <td>36.137047</td>\n",
       "      <td>-115.179199</td>\n",
       "      <td>36.137009</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-05 11:53:27</th>\n",
       "      <td>2013-08-05 11:53:43</td>\n",
       "      <td>-115.179337</td>\n",
       "      <td>36.136753</td>\n",
       "      <td>-115.179276</td>\n",
       "      <td>36.136826</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-06 06:51:19</th>\n",
       "      <td>2013-08-06 06:51:36</td>\n",
       "      <td>-73.937721</td>\n",
       "      <td>40.758404</td>\n",
       "      <td>-73.937721</td>\n",
       "      <td>40.758369</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-06 10:33:07</th>\n",
       "      <td>2013-08-06 10:33:46</td>\n",
       "      <td>-76.979668</td>\n",
       "      <td>38.927082</td>\n",
       "      <td>-76.979713</td>\n",
       "      <td>38.927326</td>\n",
       "      <td>3.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-06 13:26:34</th>\n",
       "      <td>2013-08-06 13:26:57</td>\n",
       "      <td>-73.937691</td>\n",
       "      <td>40.758419</td>\n",
       "      <td>-73.937790</td>\n",
       "      <td>40.758358</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-06 13:27:53</th>\n",
       "      <td>2013-08-06 13:28:08</td>\n",
       "      <td>-73.937805</td>\n",
       "      <td>40.758396</td>\n",
       "      <td>-73.937775</td>\n",
       "      <td>40.758450</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-06 13:29:17</th>\n",
       "      <td>2013-08-06 13:29:52</td>\n",
       "      <td>-73.937744</td>\n",
       "      <td>40.758415</td>\n",
       "      <td>-73.937759</td>\n",
       "      <td>40.758389</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-06 13:30:55</th>\n",
       "      <td>2013-08-06 13:31:12</td>\n",
       "      <td>-73.937775</td>\n",
       "      <td>40.758366</td>\n",
       "      <td>-73.937790</td>\n",
       "      <td>40.758350</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 10:22:30</th>\n",
       "      <td>2013-08-07 10:23:24</td>\n",
       "      <td>-76.979950</td>\n",
       "      <td>38.927292</td>\n",
       "      <td>-76.979591</td>\n",
       "      <td>38.927288</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 10:24:53</th>\n",
       "      <td>2013-08-07 10:28:16</td>\n",
       "      <td>-76.979668</td>\n",
       "      <td>38.927311</td>\n",
       "      <td>-76.979889</td>\n",
       "      <td>38.927174</td>\n",
       "      <td>3.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 10:24:53</th>\n",
       "      <td>2013-08-07 10:27:24</td>\n",
       "      <td>-76.979668</td>\n",
       "      <td>38.927311</td>\n",
       "      <td>-76.979813</td>\n",
       "      <td>38.927128</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 10:33:23</th>\n",
       "      <td>2013-08-07 10:34:10</td>\n",
       "      <td>-76.979790</td>\n",
       "      <td>38.927311</td>\n",
       "      <td>-76.979561</td>\n",
       "      <td>38.927151</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 14:12:46</th>\n",
       "      <td>2013-08-07 14:15:16</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758392</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758209</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 15:13:35</th>\n",
       "      <td>2013-08-07 15:13:49</td>\n",
       "      <td>-115.179192</td>\n",
       "      <td>36.136860</td>\n",
       "      <td>-115.179283</td>\n",
       "      <td>36.137066</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 15:38:07</th>\n",
       "      <td>2013-08-07 15:38:27</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758125</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758137</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 15:42:29</th>\n",
       "      <td>2013-08-07 15:43:25</td>\n",
       "      <td>-73.937477</td>\n",
       "      <td>40.758175</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758152</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 15:46:09</th>\n",
       "      <td>2013-08-07 15:48:56</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758244</td>\n",
       "      <td>-73.937508</td>\n",
       "      <td>40.758251</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 15:49:16</th>\n",
       "      <td>2013-08-07 15:49:32</td>\n",
       "      <td>-73.937508</td>\n",
       "      <td>40.758240</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758183</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:06:29</th>\n",
       "      <td>2013-08-07 16:08:52</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758240</td>\n",
       "      <td>-73.937469</td>\n",
       "      <td>40.758202</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:15:27</th>\n",
       "      <td>2013-08-07 16:18:27</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758167</td>\n",
       "      <td>-73.937431</td>\n",
       "      <td>40.758213</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:15:27</th>\n",
       "      <td>2013-08-07 16:20:09</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758167</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758251</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:27:31</th>\n",
       "      <td>2013-08-07 16:27:55</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758183</td>\n",
       "      <td>-73.937492</td>\n",
       "      <td>40.758194</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:27:31</th>\n",
       "      <td>2013-08-07 16:35:34</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758183</td>\n",
       "      <td>-73.937325</td>\n",
       "      <td>40.758198</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:38:29</th>\n",
       "      <td>2013-08-07 16:40:06</td>\n",
       "      <td>-73.937363</td>\n",
       "      <td>40.758148</td>\n",
       "      <td>-73.937416</td>\n",
       "      <td>40.758087</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:38:29</th>\n",
       "      <td>2013-08-07 16:46:51</td>\n",
       "      <td>-73.937363</td>\n",
       "      <td>40.758148</td>\n",
       "      <td>-73.937241</td>\n",
       "      <td>40.758106</td>\n",
       "      <td>5.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-07 16:43:27</th>\n",
       "      <td>2013-08-07 16:44:24</td>\n",
       "      <td>-73.937660</td>\n",
       "      <td>40.758347</td>\n",
       "      <td>-73.937729</td>\n",
       "      <td>40.758305</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <th>2013-08-31 23:23:38</th>\n",
       "      <td>2013-08-31 23:36:16</td>\n",
       "      <td>-73.913605</td>\n",
       "      <td>40.765427</td>\n",
       "      <td>-73.918091</td>\n",
       "      <td>40.741680</td>\n",
       "      <td>11.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"16\" valign=\"top\">2</th>\n",
       "      <th>2013-08-31 23:23:45</th>\n",
       "      <td>2013-08-31 23:34:26</td>\n",
       "      <td>-73.950272</td>\n",
       "      <td>40.680496</td>\n",
       "      <td>-73.934990</td>\n",
       "      <td>40.702396</td>\n",
       "      <td>10.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:23:49</th>\n",
       "      <td>2013-08-31 23:31:26</td>\n",
       "      <td>-73.844254</td>\n",
       "      <td>40.721390</td>\n",
       "      <td>-73.818474</td>\n",
       "      <td>40.734043</td>\n",
       "      <td>9.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:24:42</th>\n",
       "      <td>2013-08-31 23:50:50</td>\n",
       "      <td>-73.846169</td>\n",
       "      <td>40.754543</td>\n",
       "      <td>-73.965820</td>\n",
       "      <td>40.677544</td>\n",
       "      <td>39.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:25:05</th>\n",
       "      <td>2013-08-31 23:35:31</td>\n",
       "      <td>-73.861031</td>\n",
       "      <td>40.893051</td>\n",
       "      <td>-73.901611</td>\n",
       "      <td>40.876530</td>\n",
       "      <td>14.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:27:26</th>\n",
       "      <td>2013-08-31 23:54:49</td>\n",
       "      <td>-73.844818</td>\n",
       "      <td>40.754986</td>\n",
       "      <td>-73.969231</td>\n",
       "      <td>40.761219</td>\n",
       "      <td>26.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:27:46</th>\n",
       "      <td>2013-08-31 23:41:39</td>\n",
       "      <td>-73.954086</td>\n",
       "      <td>40.742813</td>\n",
       "      <td>-74.000793</td>\n",
       "      <td>40.736462</td>\n",
       "      <td>13.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:28:21</th>\n",
       "      <td>2013-09-01 00:00:58</td>\n",
       "      <td>-73.846001</td>\n",
       "      <td>40.754578</td>\n",
       "      <td>-73.974899</td>\n",
       "      <td>40.759235</td>\n",
       "      <td>38.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:30:53</th>\n",
       "      <td>2013-08-31 23:54:56</td>\n",
       "      <td>-73.849991</td>\n",
       "      <td>40.753479</td>\n",
       "      <td>-73.977623</td>\n",
       "      <td>40.779022</td>\n",
       "      <td>34.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:33:19</th>\n",
       "      <td>2013-08-31 23:38:51</td>\n",
       "      <td>-73.829971</td>\n",
       "      <td>40.713734</td>\n",
       "      <td>-73.824730</td>\n",
       "      <td>40.705601</td>\n",
       "      <td>5.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:34:00</th>\n",
       "      <td>2013-08-31 23:43:00</td>\n",
       "      <td>-73.845917</td>\n",
       "      <td>40.754639</td>\n",
       "      <td>-73.860458</td>\n",
       "      <td>40.739819</td>\n",
       "      <td>8.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:34:55</th>\n",
       "      <td>2013-08-31 23:51:43</td>\n",
       "      <td>-73.967758</td>\n",
       "      <td>40.693268</td>\n",
       "      <td>-73.989105</td>\n",
       "      <td>40.720303</td>\n",
       "      <td>14.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:34:58</th>\n",
       "      <td>2013-08-31 23:50:56</td>\n",
       "      <td>-73.991852</td>\n",
       "      <td>40.702530</td>\n",
       "      <td>-74.007256</td>\n",
       "      <td>40.733669</td>\n",
       "      <td>14.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:35:21</th>\n",
       "      <td>2013-08-31 23:48:13</td>\n",
       "      <td>-73.833656</td>\n",
       "      <td>40.771580</td>\n",
       "      <td>-73.843651</td>\n",
       "      <td>40.689556</td>\n",
       "      <td>22.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:40:04</th>\n",
       "      <td>2013-08-31 23:41:42</td>\n",
       "      <td>-73.926193</td>\n",
       "      <td>40.761082</td>\n",
       "      <td>-73.928421</td>\n",
       "      <td>40.756069</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:41:33</th>\n",
       "      <td>2013-09-01 00:00:18</td>\n",
       "      <td>-73.921158</td>\n",
       "      <td>40.743267</td>\n",
       "      <td>-73.902840</td>\n",
       "      <td>40.701447</td>\n",
       "      <td>17.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:44:17</th>\n",
       "      <td>2013-08-31 23:52:01</td>\n",
       "      <td>-73.946342</td>\n",
       "      <td>40.711445</td>\n",
       "      <td>-73.951027</td>\n",
       "      <td>40.724358</td>\n",
       "      <td>7.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <th>2013-08-31 23:45:43</th>\n",
       "      <td>2013-08-31 23:50:19</td>\n",
       "      <td>-73.979172</td>\n",
       "      <td>40.678406</td>\n",
       "      <td>-73.988785</td>\n",
       "      <td>40.670506</td>\n",
       "      <td>5.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"11\" valign=\"top\">2</th>\n",
       "      <th>2013-08-31 23:46:58</th>\n",
       "      <td>2013-08-31 23:51:07</td>\n",
       "      <td>-73.943985</td>\n",
       "      <td>40.784100</td>\n",
       "      <td>-73.952507</td>\n",
       "      <td>40.773121</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:48:10</th>\n",
       "      <td>2013-09-01 00:09:26</td>\n",
       "      <td>-73.924644</td>\n",
       "      <td>40.756287</td>\n",
       "      <td>-73.984779</td>\n",
       "      <td>40.710838</td>\n",
       "      <td>25.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:48:29</th>\n",
       "      <td>2013-08-31 23:59:44</td>\n",
       "      <td>-73.920647</td>\n",
       "      <td>40.767956</td>\n",
       "      <td>-73.885201</td>\n",
       "      <td>40.755516</td>\n",
       "      <td>11.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:50:37</th>\n",
       "      <td>2013-09-01 00:01:12</td>\n",
       "      <td>-73.941200</td>\n",
       "      <td>40.805779</td>\n",
       "      <td>-73.967400</td>\n",
       "      <td>40.801105</td>\n",
       "      <td>9.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:51:16</th>\n",
       "      <td>2013-08-31 23:58:45</td>\n",
       "      <td>-73.844307</td>\n",
       "      <td>40.721352</td>\n",
       "      <td>-73.827965</td>\n",
       "      <td>40.710865</td>\n",
       "      <td>8.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:52:57</th>\n",
       "      <td>2013-08-31 23:58:45</td>\n",
       "      <td>-73.917976</td>\n",
       "      <td>40.765259</td>\n",
       "      <td>-73.922600</td>\n",
       "      <td>40.755390</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:54:00</th>\n",
       "      <td>2013-08-31 00:06:00</td>\n",
       "      <td>-73.845985</td>\n",
       "      <td>40.754650</td>\n",
       "      <td>-73.884468</td>\n",
       "      <td>40.737869</td>\n",
       "      <td>15.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:54:50</th>\n",
       "      <td>2013-08-31 23:57:30</td>\n",
       "      <td>-73.943115</td>\n",
       "      <td>40.785336</td>\n",
       "      <td>-73.932846</td>\n",
       "      <td>40.796619</td>\n",
       "      <td>5.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:57:33</th>\n",
       "      <td>2013-09-01 00:10:03</td>\n",
       "      <td>-73.824432</td>\n",
       "      <td>40.734287</td>\n",
       "      <td>-73.850494</td>\n",
       "      <td>40.722317</td>\n",
       "      <td>11.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:58:18</th>\n",
       "      <td>2013-09-01 00:25:07</td>\n",
       "      <td>-73.964668</td>\n",
       "      <td>40.681309</td>\n",
       "      <td>-74.000633</td>\n",
       "      <td>40.732147</td>\n",
       "      <td>25.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-08-31 23:58:58</th>\n",
       "      <td>2013-09-01 00:06:31</td>\n",
       "      <td>-73.932343</td>\n",
       "      <td>40.796421</td>\n",
       "      <td>-73.955841</td>\n",
       "      <td>40.804691</td>\n",
       "      <td>7.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <th>2013-08-31 23:59:14</th>\n",
       "      <td>2013-09-01 00:07:40</td>\n",
       "      <td>-73.980034</td>\n",
       "      <td>40.676315</td>\n",
       "      <td>-73.964218</td>\n",
       "      <td>40.652081</td>\n",
       "      <td>9.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7095 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Dropoff_time  Pickup_longitude  Pickup_latitude  \\\n",
       "2 2013-08-01 17:22:00  2013-08-01 17:22:00        -73.937767        40.758480   \n",
       "  2013-08-01 17:24:00  2013-08-01 17:25:00        -73.937927        40.757843   \n",
       "  2013-08-05 11:31:47  2013-08-05 11:34:01       -115.179100        36.137096   \n",
       "  2013-08-05 11:31:47  2013-08-05 11:32:16       -115.179100        36.137096   \n",
       "  2013-08-05 11:51:21  2013-08-05 11:51:36       -115.179199        36.137047   \n",
       "  2013-08-05 11:53:27  2013-08-05 11:53:43       -115.179337        36.136753   \n",
       "  2013-08-06 06:51:19  2013-08-06 06:51:36        -73.937721        40.758404   \n",
       "  2013-08-06 10:33:07  2013-08-06 10:33:46        -76.979668        38.927082   \n",
       "  2013-08-06 13:26:34  2013-08-06 13:26:57        -73.937691        40.758419   \n",
       "  2013-08-06 13:27:53  2013-08-06 13:28:08        -73.937805        40.758396   \n",
       "  2013-08-06 13:29:17  2013-08-06 13:29:52        -73.937744        40.758415   \n",
       "  2013-08-06 13:30:55  2013-08-06 13:31:12        -73.937775        40.758366   \n",
       "  2013-08-07 10:22:30  2013-08-07 10:23:24        -76.979950        38.927292   \n",
       "  2013-08-07 10:24:53  2013-08-07 10:28:16        -76.979668        38.927311   \n",
       "  2013-08-07 10:24:53  2013-08-07 10:27:24        -76.979668        38.927311   \n",
       "  2013-08-07 10:33:23  2013-08-07 10:34:10        -76.979790        38.927311   \n",
       "  2013-08-07 14:12:46  2013-08-07 14:15:16        -73.937485        40.758392   \n",
       "  2013-08-07 15:13:35  2013-08-07 15:13:49       -115.179192        36.136860   \n",
       "  2013-08-07 15:38:07  2013-08-07 15:38:27        -73.937485        40.758125   \n",
       "  2013-08-07 15:42:29  2013-08-07 15:43:25        -73.937477        40.758175   \n",
       "  2013-08-07 15:46:09  2013-08-07 15:48:56        -73.937447        40.758244   \n",
       "  2013-08-07 15:49:16  2013-08-07 15:49:32        -73.937508        40.758240   \n",
       "  2013-08-07 16:06:29  2013-08-07 16:08:52        -73.937424        40.758240   \n",
       "  2013-08-07 16:15:27  2013-08-07 16:18:27        -73.937424        40.758167   \n",
       "  2013-08-07 16:15:27  2013-08-07 16:20:09        -73.937424        40.758167   \n",
       "  2013-08-07 16:27:31  2013-08-07 16:27:55        -73.937447        40.758183   \n",
       "  2013-08-07 16:27:31  2013-08-07 16:35:34        -73.937447        40.758183   \n",
       "  2013-08-07 16:38:29  2013-08-07 16:40:06        -73.937363        40.758148   \n",
       "  2013-08-07 16:38:29  2013-08-07 16:46:51        -73.937363        40.758148   \n",
       "  2013-08-07 16:43:27  2013-08-07 16:44:24        -73.937660        40.758347   \n",
       "...                                    ...               ...              ...   \n",
       "1 2013-08-31 23:23:38  2013-08-31 23:36:16        -73.913605        40.765427   \n",
       "2 2013-08-31 23:23:45  2013-08-31 23:34:26        -73.950272        40.680496   \n",
       "  2013-08-31 23:23:49  2013-08-31 23:31:26        -73.844254        40.721390   \n",
       "  2013-08-31 23:24:42  2013-08-31 23:50:50        -73.846169        40.754543   \n",
       "  2013-08-31 23:25:05  2013-08-31 23:35:31        -73.861031        40.893051   \n",
       "  2013-08-31 23:27:26  2013-08-31 23:54:49        -73.844818        40.754986   \n",
       "  2013-08-31 23:27:46  2013-08-31 23:41:39        -73.954086        40.742813   \n",
       "  2013-08-31 23:28:21  2013-09-01 00:00:58        -73.846001        40.754578   \n",
       "  2013-08-31 23:30:53  2013-08-31 23:54:56        -73.849991        40.753479   \n",
       "  2013-08-31 23:33:19  2013-08-31 23:38:51        -73.829971        40.713734   \n",
       "  2013-08-31 23:34:00  2013-08-31 23:43:00        -73.845917        40.754639   \n",
       "  2013-08-31 23:34:55  2013-08-31 23:51:43        -73.967758        40.693268   \n",
       "  2013-08-31 23:34:58  2013-08-31 23:50:56        -73.991852        40.702530   \n",
       "  2013-08-31 23:35:21  2013-08-31 23:48:13        -73.833656        40.771580   \n",
       "  2013-08-31 23:40:04  2013-08-31 23:41:42        -73.926193        40.761082   \n",
       "  2013-08-31 23:41:33  2013-09-01 00:00:18        -73.921158        40.743267   \n",
       "  2013-08-31 23:44:17  2013-08-31 23:52:01        -73.946342        40.711445   \n",
       "1 2013-08-31 23:45:43  2013-08-31 23:50:19        -73.979172        40.678406   \n",
       "2 2013-08-31 23:46:58  2013-08-31 23:51:07        -73.943985        40.784100   \n",
       "  2013-08-31 23:48:10  2013-09-01 00:09:26        -73.924644        40.756287   \n",
       "  2013-08-31 23:48:29  2013-08-31 23:59:44        -73.920647        40.767956   \n",
       "  2013-08-31 23:50:37  2013-09-01 00:01:12        -73.941200        40.805779   \n",
       "  2013-08-31 23:51:16  2013-08-31 23:58:45        -73.844307        40.721352   \n",
       "  2013-08-31 23:52:57  2013-08-31 23:58:45        -73.917976        40.765259   \n",
       "  2013-08-31 23:54:00  2013-08-31 00:06:00        -73.845985        40.754650   \n",
       "  2013-08-31 23:54:50  2013-08-31 23:57:30        -73.943115        40.785336   \n",
       "  2013-08-31 23:57:33  2013-09-01 00:10:03        -73.824432        40.734287   \n",
       "  2013-08-31 23:58:18  2013-09-01 00:25:07        -73.964668        40.681309   \n",
       "  2013-08-31 23:58:58  2013-09-01 00:06:31        -73.932343        40.796421   \n",
       "1 2013-08-31 23:59:14  2013-09-01 00:07:40        -73.980034        40.676315   \n",
       "\n",
       "                       Dropoff_longitude  Dropoff_latitude  Trip_distance  \n",
       "2 2013-08-01 17:22:00         -73.937767         40.758480           2.50  \n",
       "  2013-08-01 17:24:00         -73.937927         40.757843           2.50  \n",
       "  2013-08-05 11:31:47        -115.179337         36.136684           1.00  \n",
       "  2013-08-05 11:31:47        -115.179337         36.136684           1.20  \n",
       "  2013-08-05 11:51:21        -115.179199         36.137009           1.00  \n",
       "  2013-08-05 11:53:27        -115.179276         36.136826           1.00  \n",
       "  2013-08-06 06:51:19         -73.937721         40.758369           3.30  \n",
       "  2013-08-06 10:33:07         -76.979713         38.927326           3.25  \n",
       "  2013-08-06 13:26:34         -73.937790         40.758358           3.30  \n",
       "  2013-08-06 13:27:53         -73.937775         40.758450           3.30  \n",
       "  2013-08-06 13:29:17         -73.937759         40.758389           3.50  \n",
       "  2013-08-06 13:30:55         -73.937790         40.758350           3.30  \n",
       "  2013-08-07 10:22:30         -76.979591         38.927288           3.52  \n",
       "  2013-08-07 10:24:53         -76.979889         38.927174           3.25  \n",
       "  2013-08-07 10:24:53         -76.979813         38.927128           3.52  \n",
       "  2013-08-07 10:33:23         -76.979561         38.927151           3.52  \n",
       "  2013-08-07 14:12:46         -73.937485         40.758209           3.50  \n",
       "  2013-08-07 15:13:35        -115.179283         36.137066           1.00  \n",
       "  2013-08-07 15:38:07         -73.937485         40.758137           2.50  \n",
       "  2013-08-07 15:42:29         -73.937424         40.758152           2.50  \n",
       "  2013-08-07 15:46:09         -73.937508         40.758251           3.50  \n",
       "  2013-08-07 15:49:16         -73.937447         40.758183           2.50  \n",
       "  2013-08-07 16:06:29         -73.937469         40.758202           3.50  \n",
       "  2013-08-07 16:15:27         -73.937431         40.758213           2.50  \n",
       "  2013-08-07 16:15:27         -73.937424         40.758251           3.00  \n",
       "  2013-08-07 16:27:31         -73.937492         40.758194           2.50  \n",
       "  2013-08-07 16:27:31         -73.937325         40.758198           3.00  \n",
       "  2013-08-07 16:38:29         -73.937416         40.758087           2.50  \n",
       "  2013-08-07 16:38:29         -73.937241         40.758106           5.50  \n",
       "  2013-08-07 16:43:27         -73.937729         40.758305           2.50  \n",
       "...                                  ...               ...            ...  \n",
       "1 2013-08-31 23:23:38         -73.918091         40.741680          11.00  \n",
       "2 2013-08-31 23:23:45         -73.934990         40.702396          10.50  \n",
       "  2013-08-31 23:23:49         -73.818474         40.734043           9.00  \n",
       "  2013-08-31 23:24:42         -73.965820         40.677544          39.00  \n",
       "  2013-08-31 23:25:05         -73.901611         40.876530          14.00  \n",
       "  2013-08-31 23:27:26         -73.969231         40.761219          26.00  \n",
       "  2013-08-31 23:27:46         -74.000793         40.736462          13.50  \n",
       "  2013-08-31 23:28:21         -73.974899         40.759235          38.50  \n",
       "  2013-08-31 23:30:53         -73.977623         40.779022          34.00  \n",
       "  2013-08-31 23:33:19         -73.824730         40.705601           5.50  \n",
       "  2013-08-31 23:34:00         -73.860458         40.739819           8.50  \n",
       "  2013-08-31 23:34:55         -73.989105         40.720303          14.50  \n",
       "  2013-08-31 23:34:58         -74.007256         40.733669          14.50  \n",
       "  2013-08-31 23:35:21         -73.843651         40.689556          22.50  \n",
       "  2013-08-31 23:40:04         -73.928421         40.756069           3.50  \n",
       "  2013-08-31 23:41:33         -73.902840         40.701447          17.00  \n",
       "  2013-08-31 23:44:17         -73.951027         40.724358           7.50  \n",
       "1 2013-08-31 23:45:43         -73.988785         40.670506           5.50  \n",
       "2 2013-08-31 23:46:58         -73.952507         40.773121           6.00  \n",
       "  2013-08-31 23:48:10         -73.984779         40.710838          25.00  \n",
       "  2013-08-31 23:48:29         -73.885201         40.755516          11.50  \n",
       "  2013-08-31 23:50:37         -73.967400         40.801105           9.50  \n",
       "  2013-08-31 23:51:16         -73.827965         40.710865           8.00  \n",
       "  2013-08-31 23:52:57         -73.922600         40.755390           6.00  \n",
       "  2013-08-31 23:54:00         -73.884468         40.737869          15.00  \n",
       "  2013-08-31 23:54:50         -73.932846         40.796619           5.00  \n",
       "  2013-08-31 23:57:33         -73.850494         40.722317          11.50  \n",
       "  2013-08-31 23:58:18         -74.000633         40.732147          25.50  \n",
       "  2013-08-31 23:58:58         -73.955841         40.804691           7.50  \n",
       "1 2013-08-31 23:59:14         -73.964218         40.652081           9.00  \n",
       "\n",
       "[7095 rows x 6 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_greenAug"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#df_greenAug['new_date'] = [d.date() for d in df_greenAug['']]\n",
    "#df['new_time'] = [d.time() for d in df['my_timestamp']]\n",
    "    \n",
    "df_greenAug.index.name = 'Pickup_time'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df_greenAug.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>level_0</th>\n",
       "      <th>level_1</th>\n",
       "      <th>Dropoff_time</th>\n",
       "      <th>Pickup_longitude</th>\n",
       "      <th>Pickup_latitude</th>\n",
       "      <th>Dropoff_longitude</th>\n",
       "      <th>Dropoff_latitude</th>\n",
       "      <th>Trip_distance</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-01 17:22:00</td>\n",
       "      <td>2013-08-01 17:22:00</td>\n",
       "      <td>-73.937767</td>\n",
       "      <td>40.758480</td>\n",
       "      <td>-73.937767</td>\n",
       "      <td>40.758480</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-01 17:24:00</td>\n",
       "      <td>2013-08-01 17:25:00</td>\n",
       "      <td>-73.937927</td>\n",
       "      <td>40.757843</td>\n",
       "      <td>-73.937927</td>\n",
       "      <td>40.757843</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-05 11:31:47</td>\n",
       "      <td>2013-08-05 11:34:01</td>\n",
       "      <td>-115.179100</td>\n",
       "      <td>36.137096</td>\n",
       "      <td>-115.179337</td>\n",
       "      <td>36.136684</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-05 11:31:47</td>\n",
       "      <td>2013-08-05 11:32:16</td>\n",
       "      <td>-115.179100</td>\n",
       "      <td>36.137096</td>\n",
       "      <td>-115.179337</td>\n",
       "      <td>36.136684</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-05 11:51:21</td>\n",
       "      <td>2013-08-05 11:51:36</td>\n",
       "      <td>-115.179199</td>\n",
       "      <td>36.137047</td>\n",
       "      <td>-115.179199</td>\n",
       "      <td>36.137009</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-05 11:53:27</td>\n",
       "      <td>2013-08-05 11:53:43</td>\n",
       "      <td>-115.179337</td>\n",
       "      <td>36.136753</td>\n",
       "      <td>-115.179276</td>\n",
       "      <td>36.136826</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-06 06:51:19</td>\n",
       "      <td>2013-08-06 06:51:36</td>\n",
       "      <td>-73.937721</td>\n",
       "      <td>40.758404</td>\n",
       "      <td>-73.937721</td>\n",
       "      <td>40.758369</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-06 10:33:07</td>\n",
       "      <td>2013-08-06 10:33:46</td>\n",
       "      <td>-76.979668</td>\n",
       "      <td>38.927082</td>\n",
       "      <td>-76.979713</td>\n",
       "      <td>38.927326</td>\n",
       "      <td>3.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-06 13:26:34</td>\n",
       "      <td>2013-08-06 13:26:57</td>\n",
       "      <td>-73.937691</td>\n",
       "      <td>40.758419</td>\n",
       "      <td>-73.937790</td>\n",
       "      <td>40.758358</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-06 13:27:53</td>\n",
       "      <td>2013-08-06 13:28:08</td>\n",
       "      <td>-73.937805</td>\n",
       "      <td>40.758396</td>\n",
       "      <td>-73.937775</td>\n",
       "      <td>40.758450</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-06 13:29:17</td>\n",
       "      <td>2013-08-06 13:29:52</td>\n",
       "      <td>-73.937744</td>\n",
       "      <td>40.758415</td>\n",
       "      <td>-73.937759</td>\n",
       "      <td>40.758389</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-06 13:30:55</td>\n",
       "      <td>2013-08-06 13:31:12</td>\n",
       "      <td>-73.937775</td>\n",
       "      <td>40.758366</td>\n",
       "      <td>-73.937790</td>\n",
       "      <td>40.758350</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 10:22:30</td>\n",
       "      <td>2013-08-07 10:23:24</td>\n",
       "      <td>-76.979950</td>\n",
       "      <td>38.927292</td>\n",
       "      <td>-76.979591</td>\n",
       "      <td>38.927288</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 10:24:53</td>\n",
       "      <td>2013-08-07 10:28:16</td>\n",
       "      <td>-76.979668</td>\n",
       "      <td>38.927311</td>\n",
       "      <td>-76.979889</td>\n",
       "      <td>38.927174</td>\n",
       "      <td>3.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 10:24:53</td>\n",
       "      <td>2013-08-07 10:27:24</td>\n",
       "      <td>-76.979668</td>\n",
       "      <td>38.927311</td>\n",
       "      <td>-76.979813</td>\n",
       "      <td>38.927128</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 10:33:23</td>\n",
       "      <td>2013-08-07 10:34:10</td>\n",
       "      <td>-76.979790</td>\n",
       "      <td>38.927311</td>\n",
       "      <td>-76.979561</td>\n",
       "      <td>38.927151</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 14:12:46</td>\n",
       "      <td>2013-08-07 14:15:16</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758392</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758209</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 15:13:35</td>\n",
       "      <td>2013-08-07 15:13:49</td>\n",
       "      <td>-115.179192</td>\n",
       "      <td>36.136860</td>\n",
       "      <td>-115.179283</td>\n",
       "      <td>36.137066</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 15:38:07</td>\n",
       "      <td>2013-08-07 15:38:27</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758125</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758137</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 15:42:29</td>\n",
       "      <td>2013-08-07 15:43:25</td>\n",
       "      <td>-73.937477</td>\n",
       "      <td>40.758175</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758152</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 15:46:09</td>\n",
       "      <td>2013-08-07 15:48:56</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758244</td>\n",
       "      <td>-73.937508</td>\n",
       "      <td>40.758251</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 15:49:16</td>\n",
       "      <td>2013-08-07 15:49:32</td>\n",
       "      <td>-73.937508</td>\n",
       "      <td>40.758240</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758183</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 16:06:29</td>\n",
       "      <td>2013-08-07 16:08:52</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758240</td>\n",
       "      <td>-73.937469</td>\n",
       "      <td>40.758202</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 16:15:27</td>\n",
       "      <td>2013-08-07 16:18:27</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758167</td>\n",
       "      <td>-73.937431</td>\n",
       "      <td>40.758213</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 16:15:27</td>\n",
       "      <td>2013-08-07 16:20:09</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758167</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758251</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 16:27:31</td>\n",
       "      <td>2013-08-07 16:27:55</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758183</td>\n",
       "      <td>-73.937492</td>\n",
       "      <td>40.758194</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 16:27:31</td>\n",
       "      <td>2013-08-07 16:35:34</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758183</td>\n",
       "      <td>-73.937325</td>\n",
       "      <td>40.758198</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 16:38:29</td>\n",
       "      <td>2013-08-07 16:40:06</td>\n",
       "      <td>-73.937363</td>\n",
       "      <td>40.758148</td>\n",
       "      <td>-73.937416</td>\n",
       "      <td>40.758087</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 16:38:29</td>\n",
       "      <td>2013-08-07 16:46:51</td>\n",
       "      <td>-73.937363</td>\n",
       "      <td>40.758148</td>\n",
       "      <td>-73.937241</td>\n",
       "      <td>40.758106</td>\n",
       "      <td>5.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-07 16:43:27</td>\n",
       "      <td>2013-08-07 16:44:24</td>\n",
       "      <td>-73.937660</td>\n",
       "      <td>40.758347</td>\n",
       "      <td>-73.937729</td>\n",
       "      <td>40.758305</td>\n",
       "      <td>2.50</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7065</th>\n",
       "      <td>1</td>\n",
       "      <td>2013-08-31 23:23:38</td>\n",
       "      <td>2013-08-31 23:36:16</td>\n",
       "      <td>-73.913605</td>\n",
       "      <td>40.765427</td>\n",
       "      <td>-73.918091</td>\n",
       "      <td>40.741680</td>\n",
       "      <td>11.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7066</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:23:45</td>\n",
       "      <td>2013-08-31 23:34:26</td>\n",
       "      <td>-73.950272</td>\n",
       "      <td>40.680496</td>\n",
       "      <td>-73.934990</td>\n",
       "      <td>40.702396</td>\n",
       "      <td>10.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7067</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:23:49</td>\n",
       "      <td>2013-08-31 23:31:26</td>\n",
       "      <td>-73.844254</td>\n",
       "      <td>40.721390</td>\n",
       "      <td>-73.818474</td>\n",
       "      <td>40.734043</td>\n",
       "      <td>9.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7068</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:24:42</td>\n",
       "      <td>2013-08-31 23:50:50</td>\n",
       "      <td>-73.846169</td>\n",
       "      <td>40.754543</td>\n",
       "      <td>-73.965820</td>\n",
       "      <td>40.677544</td>\n",
       "      <td>39.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7069</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:25:05</td>\n",
       "      <td>2013-08-31 23:35:31</td>\n",
       "      <td>-73.861031</td>\n",
       "      <td>40.893051</td>\n",
       "      <td>-73.901611</td>\n",
       "      <td>40.876530</td>\n",
       "      <td>14.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7070</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:27:26</td>\n",
       "      <td>2013-08-31 23:54:49</td>\n",
       "      <td>-73.844818</td>\n",
       "      <td>40.754986</td>\n",
       "      <td>-73.969231</td>\n",
       "      <td>40.761219</td>\n",
       "      <td>26.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7071</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:27:46</td>\n",
       "      <td>2013-08-31 23:41:39</td>\n",
       "      <td>-73.954086</td>\n",
       "      <td>40.742813</td>\n",
       "      <td>-74.000793</td>\n",
       "      <td>40.736462</td>\n",
       "      <td>13.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7072</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:28:21</td>\n",
       "      <td>2013-09-01 00:00:58</td>\n",
       "      <td>-73.846001</td>\n",
       "      <td>40.754578</td>\n",
       "      <td>-73.974899</td>\n",
       "      <td>40.759235</td>\n",
       "      <td>38.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7073</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:30:53</td>\n",
       "      <td>2013-08-31 23:54:56</td>\n",
       "      <td>-73.849991</td>\n",
       "      <td>40.753479</td>\n",
       "      <td>-73.977623</td>\n",
       "      <td>40.779022</td>\n",
       "      <td>34.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7074</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:33:19</td>\n",
       "      <td>2013-08-31 23:38:51</td>\n",
       "      <td>-73.829971</td>\n",
       "      <td>40.713734</td>\n",
       "      <td>-73.824730</td>\n",
       "      <td>40.705601</td>\n",
       "      <td>5.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7075</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:34:00</td>\n",
       "      <td>2013-08-31 23:43:00</td>\n",
       "      <td>-73.845917</td>\n",
       "      <td>40.754639</td>\n",
       "      <td>-73.860458</td>\n",
       "      <td>40.739819</td>\n",
       "      <td>8.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7076</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:34:55</td>\n",
       "      <td>2013-08-31 23:51:43</td>\n",
       "      <td>-73.967758</td>\n",
       "      <td>40.693268</td>\n",
       "      <td>-73.989105</td>\n",
       "      <td>40.720303</td>\n",
       "      <td>14.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7077</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:34:58</td>\n",
       "      <td>2013-08-31 23:50:56</td>\n",
       "      <td>-73.991852</td>\n",
       "      <td>40.702530</td>\n",
       "      <td>-74.007256</td>\n",
       "      <td>40.733669</td>\n",
       "      <td>14.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7078</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:35:21</td>\n",
       "      <td>2013-08-31 23:48:13</td>\n",
       "      <td>-73.833656</td>\n",
       "      <td>40.771580</td>\n",
       "      <td>-73.843651</td>\n",
       "      <td>40.689556</td>\n",
       "      <td>22.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7079</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:40:04</td>\n",
       "      <td>2013-08-31 23:41:42</td>\n",
       "      <td>-73.926193</td>\n",
       "      <td>40.761082</td>\n",
       "      <td>-73.928421</td>\n",
       "      <td>40.756069</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7080</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:41:33</td>\n",
       "      <td>2013-09-01 00:00:18</td>\n",
       "      <td>-73.921158</td>\n",
       "      <td>40.743267</td>\n",
       "      <td>-73.902840</td>\n",
       "      <td>40.701447</td>\n",
       "      <td>17.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7081</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:44:17</td>\n",
       "      <td>2013-08-31 23:52:01</td>\n",
       "      <td>-73.946342</td>\n",
       "      <td>40.711445</td>\n",
       "      <td>-73.951027</td>\n",
       "      <td>40.724358</td>\n",
       "      <td>7.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7082</th>\n",
       "      <td>1</td>\n",
       "      <td>2013-08-31 23:45:43</td>\n",
       "      <td>2013-08-31 23:50:19</td>\n",
       "      <td>-73.979172</td>\n",
       "      <td>40.678406</td>\n",
       "      <td>-73.988785</td>\n",
       "      <td>40.670506</td>\n",
       "      <td>5.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7083</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:46:58</td>\n",
       "      <td>2013-08-31 23:51:07</td>\n",
       "      <td>-73.943985</td>\n",
       "      <td>40.784100</td>\n",
       "      <td>-73.952507</td>\n",
       "      <td>40.773121</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7084</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:48:10</td>\n",
       "      <td>2013-09-01 00:09:26</td>\n",
       "      <td>-73.924644</td>\n",
       "      <td>40.756287</td>\n",
       "      <td>-73.984779</td>\n",
       "      <td>40.710838</td>\n",
       "      <td>25.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7085</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:48:29</td>\n",
       "      <td>2013-08-31 23:59:44</td>\n",
       "      <td>-73.920647</td>\n",
       "      <td>40.767956</td>\n",
       "      <td>-73.885201</td>\n",
       "      <td>40.755516</td>\n",
       "      <td>11.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7086</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:50:37</td>\n",
       "      <td>2013-09-01 00:01:12</td>\n",
       "      <td>-73.941200</td>\n",
       "      <td>40.805779</td>\n",
       "      <td>-73.967400</td>\n",
       "      <td>40.801105</td>\n",
       "      <td>9.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7087</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:51:16</td>\n",
       "      <td>2013-08-31 23:58:45</td>\n",
       "      <td>-73.844307</td>\n",
       "      <td>40.721352</td>\n",
       "      <td>-73.827965</td>\n",
       "      <td>40.710865</td>\n",
       "      <td>8.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7088</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:52:57</td>\n",
       "      <td>2013-08-31 23:58:45</td>\n",
       "      <td>-73.917976</td>\n",
       "      <td>40.765259</td>\n",
       "      <td>-73.922600</td>\n",
       "      <td>40.755390</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7089</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:54:00</td>\n",
       "      <td>2013-08-31 00:06:00</td>\n",
       "      <td>-73.845985</td>\n",
       "      <td>40.754650</td>\n",
       "      <td>-73.884468</td>\n",
       "      <td>40.737869</td>\n",
       "      <td>15.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7090</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:54:50</td>\n",
       "      <td>2013-08-31 23:57:30</td>\n",
       "      <td>-73.943115</td>\n",
       "      <td>40.785336</td>\n",
       "      <td>-73.932846</td>\n",
       "      <td>40.796619</td>\n",
       "      <td>5.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7091</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:57:33</td>\n",
       "      <td>2013-09-01 00:10:03</td>\n",
       "      <td>-73.824432</td>\n",
       "      <td>40.734287</td>\n",
       "      <td>-73.850494</td>\n",
       "      <td>40.722317</td>\n",
       "      <td>11.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7092</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:58:18</td>\n",
       "      <td>2013-09-01 00:25:07</td>\n",
       "      <td>-73.964668</td>\n",
       "      <td>40.681309</td>\n",
       "      <td>-74.000633</td>\n",
       "      <td>40.732147</td>\n",
       "      <td>25.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7093</th>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-31 23:58:58</td>\n",
       "      <td>2013-09-01 00:06:31</td>\n",
       "      <td>-73.932343</td>\n",
       "      <td>40.796421</td>\n",
       "      <td>-73.955841</td>\n",
       "      <td>40.804691</td>\n",
       "      <td>7.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7094</th>\n",
       "      <td>1</td>\n",
       "      <td>2013-08-31 23:59:14</td>\n",
       "      <td>2013-09-01 00:07:40</td>\n",
       "      <td>-73.980034</td>\n",
       "      <td>40.676315</td>\n",
       "      <td>-73.964218</td>\n",
       "      <td>40.652081</td>\n",
       "      <td>9.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7095 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      level_0              level_1         Dropoff_time  Pickup_longitude  \\\n",
       "0           2  2013-08-01 17:22:00  2013-08-01 17:22:00        -73.937767   \n",
       "1           2  2013-08-01 17:24:00  2013-08-01 17:25:00        -73.937927   \n",
       "2           2  2013-08-05 11:31:47  2013-08-05 11:34:01       -115.179100   \n",
       "3           2  2013-08-05 11:31:47  2013-08-05 11:32:16       -115.179100   \n",
       "4           2  2013-08-05 11:51:21  2013-08-05 11:51:36       -115.179199   \n",
       "5           2  2013-08-05 11:53:27  2013-08-05 11:53:43       -115.179337   \n",
       "6           2  2013-08-06 06:51:19  2013-08-06 06:51:36        -73.937721   \n",
       "7           2  2013-08-06 10:33:07  2013-08-06 10:33:46        -76.979668   \n",
       "8           2  2013-08-06 13:26:34  2013-08-06 13:26:57        -73.937691   \n",
       "9           2  2013-08-06 13:27:53  2013-08-06 13:28:08        -73.937805   \n",
       "10          2  2013-08-06 13:29:17  2013-08-06 13:29:52        -73.937744   \n",
       "11          2  2013-08-06 13:30:55  2013-08-06 13:31:12        -73.937775   \n",
       "12          2  2013-08-07 10:22:30  2013-08-07 10:23:24        -76.979950   \n",
       "13          2  2013-08-07 10:24:53  2013-08-07 10:28:16        -76.979668   \n",
       "14          2  2013-08-07 10:24:53  2013-08-07 10:27:24        -76.979668   \n",
       "15          2  2013-08-07 10:33:23  2013-08-07 10:34:10        -76.979790   \n",
       "16          2  2013-08-07 14:12:46  2013-08-07 14:15:16        -73.937485   \n",
       "17          2  2013-08-07 15:13:35  2013-08-07 15:13:49       -115.179192   \n",
       "18          2  2013-08-07 15:38:07  2013-08-07 15:38:27        -73.937485   \n",
       "19          2  2013-08-07 15:42:29  2013-08-07 15:43:25        -73.937477   \n",
       "20          2  2013-08-07 15:46:09  2013-08-07 15:48:56        -73.937447   \n",
       "21          2  2013-08-07 15:49:16  2013-08-07 15:49:32        -73.937508   \n",
       "22          2  2013-08-07 16:06:29  2013-08-07 16:08:52        -73.937424   \n",
       "23          2  2013-08-07 16:15:27  2013-08-07 16:18:27        -73.937424   \n",
       "24          2  2013-08-07 16:15:27  2013-08-07 16:20:09        -73.937424   \n",
       "25          2  2013-08-07 16:27:31  2013-08-07 16:27:55        -73.937447   \n",
       "26          2  2013-08-07 16:27:31  2013-08-07 16:35:34        -73.937447   \n",
       "27          2  2013-08-07 16:38:29  2013-08-07 16:40:06        -73.937363   \n",
       "28          2  2013-08-07 16:38:29  2013-08-07 16:46:51        -73.937363   \n",
       "29          2  2013-08-07 16:43:27  2013-08-07 16:44:24        -73.937660   \n",
       "...       ...                  ...                  ...               ...   \n",
       "7065        1  2013-08-31 23:23:38  2013-08-31 23:36:16        -73.913605   \n",
       "7066        2  2013-08-31 23:23:45  2013-08-31 23:34:26        -73.950272   \n",
       "7067        2  2013-08-31 23:23:49  2013-08-31 23:31:26        -73.844254   \n",
       "7068        2  2013-08-31 23:24:42  2013-08-31 23:50:50        -73.846169   \n",
       "7069        2  2013-08-31 23:25:05  2013-08-31 23:35:31        -73.861031   \n",
       "7070        2  2013-08-31 23:27:26  2013-08-31 23:54:49        -73.844818   \n",
       "7071        2  2013-08-31 23:27:46  2013-08-31 23:41:39        -73.954086   \n",
       "7072        2  2013-08-31 23:28:21  2013-09-01 00:00:58        -73.846001   \n",
       "7073        2  2013-08-31 23:30:53  2013-08-31 23:54:56        -73.849991   \n",
       "7074        2  2013-08-31 23:33:19  2013-08-31 23:38:51        -73.829971   \n",
       "7075        2  2013-08-31 23:34:00  2013-08-31 23:43:00        -73.845917   \n",
       "7076        2  2013-08-31 23:34:55  2013-08-31 23:51:43        -73.967758   \n",
       "7077        2  2013-08-31 23:34:58  2013-08-31 23:50:56        -73.991852   \n",
       "7078        2  2013-08-31 23:35:21  2013-08-31 23:48:13        -73.833656   \n",
       "7079        2  2013-08-31 23:40:04  2013-08-31 23:41:42        -73.926193   \n",
       "7080        2  2013-08-31 23:41:33  2013-09-01 00:00:18        -73.921158   \n",
       "7081        2  2013-08-31 23:44:17  2013-08-31 23:52:01        -73.946342   \n",
       "7082        1  2013-08-31 23:45:43  2013-08-31 23:50:19        -73.979172   \n",
       "7083        2  2013-08-31 23:46:58  2013-08-31 23:51:07        -73.943985   \n",
       "7084        2  2013-08-31 23:48:10  2013-09-01 00:09:26        -73.924644   \n",
       "7085        2  2013-08-31 23:48:29  2013-08-31 23:59:44        -73.920647   \n",
       "7086        2  2013-08-31 23:50:37  2013-09-01 00:01:12        -73.941200   \n",
       "7087        2  2013-08-31 23:51:16  2013-08-31 23:58:45        -73.844307   \n",
       "7088        2  2013-08-31 23:52:57  2013-08-31 23:58:45        -73.917976   \n",
       "7089        2  2013-08-31 23:54:00  2013-08-31 00:06:00        -73.845985   \n",
       "7090        2  2013-08-31 23:54:50  2013-08-31 23:57:30        -73.943115   \n",
       "7091        2  2013-08-31 23:57:33  2013-09-01 00:10:03        -73.824432   \n",
       "7092        2  2013-08-31 23:58:18  2013-09-01 00:25:07        -73.964668   \n",
       "7093        2  2013-08-31 23:58:58  2013-09-01 00:06:31        -73.932343   \n",
       "7094        1  2013-08-31 23:59:14  2013-09-01 00:07:40        -73.980034   \n",
       "\n",
       "      Pickup_latitude  Dropoff_longitude  Dropoff_latitude  Trip_distance  \n",
       "0           40.758480         -73.937767         40.758480           2.50  \n",
       "1           40.757843         -73.937927         40.757843           2.50  \n",
       "2           36.137096        -115.179337         36.136684           1.00  \n",
       "3           36.137096        -115.179337         36.136684           1.20  \n",
       "4           36.137047        -115.179199         36.137009           1.00  \n",
       "5           36.136753        -115.179276         36.136826           1.00  \n",
       "6           40.758404         -73.937721         40.758369           3.30  \n",
       "7           38.927082         -76.979713         38.927326           3.25  \n",
       "8           40.758419         -73.937790         40.758358           3.30  \n",
       "9           40.758396         -73.937775         40.758450           3.30  \n",
       "10          40.758415         -73.937759         40.758389           3.50  \n",
       "11          40.758366         -73.937790         40.758350           3.30  \n",
       "12          38.927292         -76.979591         38.927288           3.52  \n",
       "13          38.927311         -76.979889         38.927174           3.25  \n",
       "14          38.927311         -76.979813         38.927128           3.52  \n",
       "15          38.927311         -76.979561         38.927151           3.52  \n",
       "16          40.758392         -73.937485         40.758209           3.50  \n",
       "17          36.136860        -115.179283         36.137066           1.00  \n",
       "18          40.758125         -73.937485         40.758137           2.50  \n",
       "19          40.758175         -73.937424         40.758152           2.50  \n",
       "20          40.758244         -73.937508         40.758251           3.50  \n",
       "21          40.758240         -73.937447         40.758183           2.50  \n",
       "22          40.758240         -73.937469         40.758202           3.50  \n",
       "23          40.758167         -73.937431         40.758213           2.50  \n",
       "24          40.758167         -73.937424         40.758251           3.00  \n",
       "25          40.758183         -73.937492         40.758194           2.50  \n",
       "26          40.758183         -73.937325         40.758198           3.00  \n",
       "27          40.758148         -73.937416         40.758087           2.50  \n",
       "28          40.758148         -73.937241         40.758106           5.50  \n",
       "29          40.758347         -73.937729         40.758305           2.50  \n",
       "...               ...                ...               ...            ...  \n",
       "7065        40.765427         -73.918091         40.741680          11.00  \n",
       "7066        40.680496         -73.934990         40.702396          10.50  \n",
       "7067        40.721390         -73.818474         40.734043           9.00  \n",
       "7068        40.754543         -73.965820         40.677544          39.00  \n",
       "7069        40.893051         -73.901611         40.876530          14.00  \n",
       "7070        40.754986         -73.969231         40.761219          26.00  \n",
       "7071        40.742813         -74.000793         40.736462          13.50  \n",
       "7072        40.754578         -73.974899         40.759235          38.50  \n",
       "7073        40.753479         -73.977623         40.779022          34.00  \n",
       "7074        40.713734         -73.824730         40.705601           5.50  \n",
       "7075        40.754639         -73.860458         40.739819           8.50  \n",
       "7076        40.693268         -73.989105         40.720303          14.50  \n",
       "7077        40.702530         -74.007256         40.733669          14.50  \n",
       "7078        40.771580         -73.843651         40.689556          22.50  \n",
       "7079        40.761082         -73.928421         40.756069           3.50  \n",
       "7080        40.743267         -73.902840         40.701447          17.00  \n",
       "7081        40.711445         -73.951027         40.724358           7.50  \n",
       "7082        40.678406         -73.988785         40.670506           5.50  \n",
       "7083        40.784100         -73.952507         40.773121           6.00  \n",
       "7084        40.756287         -73.984779         40.710838          25.00  \n",
       "7085        40.767956         -73.885201         40.755516          11.50  \n",
       "7086        40.805779         -73.967400         40.801105           9.50  \n",
       "7087        40.721352         -73.827965         40.710865           8.00  \n",
       "7088        40.765259         -73.922600         40.755390           6.00  \n",
       "7089        40.754650         -73.884468         40.737869          15.00  \n",
       "7090        40.785336         -73.932846         40.796619           5.00  \n",
       "7091        40.734287         -73.850494         40.722317          11.50  \n",
       "7092        40.681309         -74.000633         40.732147          25.50  \n",
       "7093        40.796421         -73.955841         40.804691           7.50  \n",
       "7094        40.676315         -73.964218         40.652081           9.00  \n",
       "\n",
       "[7095 rows x 8 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_greenAug"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#drop useless level 0 column,not sure where it came from\n",
    "del df_greenAug['level_0']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#rename level_1 to pickup time\n",
    "df_greenAug.rename(columns={'level_1': 'Pickup_time'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Pickup_time</th>\n",
       "      <th>Dropoff_time</th>\n",
       "      <th>Pickup_longitude</th>\n",
       "      <th>Pickup_latitude</th>\n",
       "      <th>Dropoff_longitude</th>\n",
       "      <th>Dropoff_latitude</th>\n",
       "      <th>Trip_distance</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2013-08-01 17:22:00</td>\n",
       "      <td>2013-08-01 17:22:00</td>\n",
       "      <td>-73.937767</td>\n",
       "      <td>40.758480</td>\n",
       "      <td>-73.937767</td>\n",
       "      <td>40.758480</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2013-08-01 17:24:00</td>\n",
       "      <td>2013-08-01 17:25:00</td>\n",
       "      <td>-73.937927</td>\n",
       "      <td>40.757843</td>\n",
       "      <td>-73.937927</td>\n",
       "      <td>40.757843</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2013-08-05 11:31:47</td>\n",
       "      <td>2013-08-05 11:34:01</td>\n",
       "      <td>-115.179100</td>\n",
       "      <td>36.137096</td>\n",
       "      <td>-115.179337</td>\n",
       "      <td>36.136684</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2013-08-05 11:31:47</td>\n",
       "      <td>2013-08-05 11:32:16</td>\n",
       "      <td>-115.179100</td>\n",
       "      <td>36.137096</td>\n",
       "      <td>-115.179337</td>\n",
       "      <td>36.136684</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2013-08-05 11:51:21</td>\n",
       "      <td>2013-08-05 11:51:36</td>\n",
       "      <td>-115.179199</td>\n",
       "      <td>36.137047</td>\n",
       "      <td>-115.179199</td>\n",
       "      <td>36.137009</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2013-08-05 11:53:27</td>\n",
       "      <td>2013-08-05 11:53:43</td>\n",
       "      <td>-115.179337</td>\n",
       "      <td>36.136753</td>\n",
       "      <td>-115.179276</td>\n",
       "      <td>36.136826</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2013-08-06 06:51:19</td>\n",
       "      <td>2013-08-06 06:51:36</td>\n",
       "      <td>-73.937721</td>\n",
       "      <td>40.758404</td>\n",
       "      <td>-73.937721</td>\n",
       "      <td>40.758369</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2013-08-06 10:33:07</td>\n",
       "      <td>2013-08-06 10:33:46</td>\n",
       "      <td>-76.979668</td>\n",
       "      <td>38.927082</td>\n",
       "      <td>-76.979713</td>\n",
       "      <td>38.927326</td>\n",
       "      <td>3.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2013-08-06 13:26:34</td>\n",
       "      <td>2013-08-06 13:26:57</td>\n",
       "      <td>-73.937691</td>\n",
       "      <td>40.758419</td>\n",
       "      <td>-73.937790</td>\n",
       "      <td>40.758358</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2013-08-06 13:27:53</td>\n",
       "      <td>2013-08-06 13:28:08</td>\n",
       "      <td>-73.937805</td>\n",
       "      <td>40.758396</td>\n",
       "      <td>-73.937775</td>\n",
       "      <td>40.758450</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2013-08-06 13:29:17</td>\n",
       "      <td>2013-08-06 13:29:52</td>\n",
       "      <td>-73.937744</td>\n",
       "      <td>40.758415</td>\n",
       "      <td>-73.937759</td>\n",
       "      <td>40.758389</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2013-08-06 13:30:55</td>\n",
       "      <td>2013-08-06 13:31:12</td>\n",
       "      <td>-73.937775</td>\n",
       "      <td>40.758366</td>\n",
       "      <td>-73.937790</td>\n",
       "      <td>40.758350</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2013-08-07 10:22:30</td>\n",
       "      <td>2013-08-07 10:23:24</td>\n",
       "      <td>-76.979950</td>\n",
       "      <td>38.927292</td>\n",
       "      <td>-76.979591</td>\n",
       "      <td>38.927288</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2013-08-07 10:24:53</td>\n",
       "      <td>2013-08-07 10:28:16</td>\n",
       "      <td>-76.979668</td>\n",
       "      <td>38.927311</td>\n",
       "      <td>-76.979889</td>\n",
       "      <td>38.927174</td>\n",
       "      <td>3.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2013-08-07 10:24:53</td>\n",
       "      <td>2013-08-07 10:27:24</td>\n",
       "      <td>-76.979668</td>\n",
       "      <td>38.927311</td>\n",
       "      <td>-76.979813</td>\n",
       "      <td>38.927128</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2013-08-07 10:33:23</td>\n",
       "      <td>2013-08-07 10:34:10</td>\n",
       "      <td>-76.979790</td>\n",
       "      <td>38.927311</td>\n",
       "      <td>-76.979561</td>\n",
       "      <td>38.927151</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2013-08-07 14:12:46</td>\n",
       "      <td>2013-08-07 14:15:16</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758392</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758209</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2013-08-07 15:13:35</td>\n",
       "      <td>2013-08-07 15:13:49</td>\n",
       "      <td>-115.179192</td>\n",
       "      <td>36.136860</td>\n",
       "      <td>-115.179283</td>\n",
       "      <td>36.137066</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2013-08-07 15:38:07</td>\n",
       "      <td>2013-08-07 15:38:27</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758125</td>\n",
       "      <td>-73.937485</td>\n",
       "      <td>40.758137</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2013-08-07 15:42:29</td>\n",
       "      <td>2013-08-07 15:43:25</td>\n",
       "      <td>-73.937477</td>\n",
       "      <td>40.758175</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758152</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2013-08-07 15:46:09</td>\n",
       "      <td>2013-08-07 15:48:56</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758244</td>\n",
       "      <td>-73.937508</td>\n",
       "      <td>40.758251</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2013-08-07 15:49:16</td>\n",
       "      <td>2013-08-07 15:49:32</td>\n",
       "      <td>-73.937508</td>\n",
       "      <td>40.758240</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758183</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2013-08-07 16:06:29</td>\n",
       "      <td>2013-08-07 16:08:52</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758240</td>\n",
       "      <td>-73.937469</td>\n",
       "      <td>40.758202</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2013-08-07 16:15:27</td>\n",
       "      <td>2013-08-07 16:18:27</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758167</td>\n",
       "      <td>-73.937431</td>\n",
       "      <td>40.758213</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2013-08-07 16:15:27</td>\n",
       "      <td>2013-08-07 16:20:09</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758167</td>\n",
       "      <td>-73.937424</td>\n",
       "      <td>40.758251</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2013-08-07 16:27:31</td>\n",
       "      <td>2013-08-07 16:27:55</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758183</td>\n",
       "      <td>-73.937492</td>\n",
       "      <td>40.758194</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2013-08-07 16:27:31</td>\n",
       "      <td>2013-08-07 16:35:34</td>\n",
       "      <td>-73.937447</td>\n",
       "      <td>40.758183</td>\n",
       "      <td>-73.937325</td>\n",
       "      <td>40.758198</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2013-08-07 16:38:29</td>\n",
       "      <td>2013-08-07 16:40:06</td>\n",
       "      <td>-73.937363</td>\n",
       "      <td>40.758148</td>\n",
       "      <td>-73.937416</td>\n",
       "      <td>40.758087</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2013-08-07 16:38:29</td>\n",
       "      <td>2013-08-07 16:46:51</td>\n",
       "      <td>-73.937363</td>\n",
       "      <td>40.758148</td>\n",
       "      <td>-73.937241</td>\n",
       "      <td>40.758106</td>\n",
       "      <td>5.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2013-08-07 16:43:27</td>\n",
       "      <td>2013-08-07 16:44:24</td>\n",
       "      <td>-73.937660</td>\n",
       "      <td>40.758347</td>\n",
       "      <td>-73.937729</td>\n",
       "      <td>40.758305</td>\n",
       "      <td>2.50</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7065</th>\n",
       "      <td>2013-08-31 23:23:38</td>\n",
       "      <td>2013-08-31 23:36:16</td>\n",
       "      <td>-73.913605</td>\n",
       "      <td>40.765427</td>\n",
       "      <td>-73.918091</td>\n",
       "      <td>40.741680</td>\n",
       "      <td>11.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7066</th>\n",
       "      <td>2013-08-31 23:23:45</td>\n",
       "      <td>2013-08-31 23:34:26</td>\n",
       "      <td>-73.950272</td>\n",
       "      <td>40.680496</td>\n",
       "      <td>-73.934990</td>\n",
       "      <td>40.702396</td>\n",
       "      <td>10.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7067</th>\n",
       "      <td>2013-08-31 23:23:49</td>\n",
       "      <td>2013-08-31 23:31:26</td>\n",
       "      <td>-73.844254</td>\n",
       "      <td>40.721390</td>\n",
       "      <td>-73.818474</td>\n",
       "      <td>40.734043</td>\n",
       "      <td>9.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7068</th>\n",
       "      <td>2013-08-31 23:24:42</td>\n",
       "      <td>2013-08-31 23:50:50</td>\n",
       "      <td>-73.846169</td>\n",
       "      <td>40.754543</td>\n",
       "      <td>-73.965820</td>\n",
       "      <td>40.677544</td>\n",
       "      <td>39.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7069</th>\n",
       "      <td>2013-08-31 23:25:05</td>\n",
       "      <td>2013-08-31 23:35:31</td>\n",
       "      <td>-73.861031</td>\n",
       "      <td>40.893051</td>\n",
       "      <td>-73.901611</td>\n",
       "      <td>40.876530</td>\n",
       "      <td>14.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7070</th>\n",
       "      <td>2013-08-31 23:27:26</td>\n",
       "      <td>2013-08-31 23:54:49</td>\n",
       "      <td>-73.844818</td>\n",
       "      <td>40.754986</td>\n",
       "      <td>-73.969231</td>\n",
       "      <td>40.761219</td>\n",
       "      <td>26.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7071</th>\n",
       "      <td>2013-08-31 23:27:46</td>\n",
       "      <td>2013-08-31 23:41:39</td>\n",
       "      <td>-73.954086</td>\n",
       "      <td>40.742813</td>\n",
       "      <td>-74.000793</td>\n",
       "      <td>40.736462</td>\n",
       "      <td>13.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7072</th>\n",
       "      <td>2013-08-31 23:28:21</td>\n",
       "      <td>2013-09-01 00:00:58</td>\n",
       "      <td>-73.846001</td>\n",
       "      <td>40.754578</td>\n",
       "      <td>-73.974899</td>\n",
       "      <td>40.759235</td>\n",
       "      <td>38.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7073</th>\n",
       "      <td>2013-08-31 23:30:53</td>\n",
       "      <td>2013-08-31 23:54:56</td>\n",
       "      <td>-73.849991</td>\n",
       "      <td>40.753479</td>\n",
       "      <td>-73.977623</td>\n",
       "      <td>40.779022</td>\n",
       "      <td>34.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7074</th>\n",
       "      <td>2013-08-31 23:33:19</td>\n",
       "      <td>2013-08-31 23:38:51</td>\n",
       "      <td>-73.829971</td>\n",
       "      <td>40.713734</td>\n",
       "      <td>-73.824730</td>\n",
       "      <td>40.705601</td>\n",
       "      <td>5.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7075</th>\n",
       "      <td>2013-08-31 23:34:00</td>\n",
       "      <td>2013-08-31 23:43:00</td>\n",
       "      <td>-73.845917</td>\n",
       "      <td>40.754639</td>\n",
       "      <td>-73.860458</td>\n",
       "      <td>40.739819</td>\n",
       "      <td>8.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7076</th>\n",
       "      <td>2013-08-31 23:34:55</td>\n",
       "      <td>2013-08-31 23:51:43</td>\n",
       "      <td>-73.967758</td>\n",
       "      <td>40.693268</td>\n",
       "      <td>-73.989105</td>\n",
       "      <td>40.720303</td>\n",
       "      <td>14.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7077</th>\n",
       "      <td>2013-08-31 23:34:58</td>\n",
       "      <td>2013-08-31 23:50:56</td>\n",
       "      <td>-73.991852</td>\n",
       "      <td>40.702530</td>\n",
       "      <td>-74.007256</td>\n",
       "      <td>40.733669</td>\n",
       "      <td>14.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7078</th>\n",
       "      <td>2013-08-31 23:35:21</td>\n",
       "      <td>2013-08-31 23:48:13</td>\n",
       "      <td>-73.833656</td>\n",
       "      <td>40.771580</td>\n",
       "      <td>-73.843651</td>\n",
       "      <td>40.689556</td>\n",
       "      <td>22.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7079</th>\n",
       "      <td>2013-08-31 23:40:04</td>\n",
       "      <td>2013-08-31 23:41:42</td>\n",
       "      <td>-73.926193</td>\n",
       "      <td>40.761082</td>\n",
       "      <td>-73.928421</td>\n",
       "      <td>40.756069</td>\n",
       "      <td>3.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7080</th>\n",
       "      <td>2013-08-31 23:41:33</td>\n",
       "      <td>2013-09-01 00:00:18</td>\n",
       "      <td>-73.921158</td>\n",
       "      <td>40.743267</td>\n",
       "      <td>-73.902840</td>\n",
       "      <td>40.701447</td>\n",
       "      <td>17.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7081</th>\n",
       "      <td>2013-08-31 23:44:17</td>\n",
       "      <td>2013-08-31 23:52:01</td>\n",
       "      <td>-73.946342</td>\n",
       "      <td>40.711445</td>\n",
       "      <td>-73.951027</td>\n",
       "      <td>40.724358</td>\n",
       "      <td>7.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7082</th>\n",
       "      <td>2013-08-31 23:45:43</td>\n",
       "      <td>2013-08-31 23:50:19</td>\n",
       "      <td>-73.979172</td>\n",
       "      <td>40.678406</td>\n",
       "      <td>-73.988785</td>\n",
       "      <td>40.670506</td>\n",
       "      <td>5.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7083</th>\n",
       "      <td>2013-08-31 23:46:58</td>\n",
       "      <td>2013-08-31 23:51:07</td>\n",
       "      <td>-73.943985</td>\n",
       "      <td>40.784100</td>\n",
       "      <td>-73.952507</td>\n",
       "      <td>40.773121</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7084</th>\n",
       "      <td>2013-08-31 23:48:10</td>\n",
       "      <td>2013-09-01 00:09:26</td>\n",
       "      <td>-73.924644</td>\n",
       "      <td>40.756287</td>\n",
       "      <td>-73.984779</td>\n",
       "      <td>40.710838</td>\n",
       "      <td>25.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7085</th>\n",
       "      <td>2013-08-31 23:48:29</td>\n",
       "      <td>2013-08-31 23:59:44</td>\n",
       "      <td>-73.920647</td>\n",
       "      <td>40.767956</td>\n",
       "      <td>-73.885201</td>\n",
       "      <td>40.755516</td>\n",
       "      <td>11.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7086</th>\n",
       "      <td>2013-08-31 23:50:37</td>\n",
       "      <td>2013-09-01 00:01:12</td>\n",
       "      <td>-73.941200</td>\n",
       "      <td>40.805779</td>\n",
       "      <td>-73.967400</td>\n",
       "      <td>40.801105</td>\n",
       "      <td>9.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7087</th>\n",
       "      <td>2013-08-31 23:51:16</td>\n",
       "      <td>2013-08-31 23:58:45</td>\n",
       "      <td>-73.844307</td>\n",
       "      <td>40.721352</td>\n",
       "      <td>-73.827965</td>\n",
       "      <td>40.710865</td>\n",
       "      <td>8.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7088</th>\n",
       "      <td>2013-08-31 23:52:57</td>\n",
       "      <td>2013-08-31 23:58:45</td>\n",
       "      <td>-73.917976</td>\n",
       "      <td>40.765259</td>\n",
       "      <td>-73.922600</td>\n",
       "      <td>40.755390</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7089</th>\n",
       "      <td>2013-08-31 23:54:00</td>\n",
       "      <td>2013-08-31 00:06:00</td>\n",
       "      <td>-73.845985</td>\n",
       "      <td>40.754650</td>\n",
       "      <td>-73.884468</td>\n",
       "      <td>40.737869</td>\n",
       "      <td>15.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7090</th>\n",
       "      <td>2013-08-31 23:54:50</td>\n",
       "      <td>2013-08-31 23:57:30</td>\n",
       "      <td>-73.943115</td>\n",
       "      <td>40.785336</td>\n",
       "      <td>-73.932846</td>\n",
       "      <td>40.796619</td>\n",
       "      <td>5.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7091</th>\n",
       "      <td>2013-08-31 23:57:33</td>\n",
       "      <td>2013-09-01 00:10:03</td>\n",
       "      <td>-73.824432</td>\n",
       "      <td>40.734287</td>\n",
       "      <td>-73.850494</td>\n",
       "      <td>40.722317</td>\n",
       "      <td>11.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7092</th>\n",
       "      <td>2013-08-31 23:58:18</td>\n",
       "      <td>2013-09-01 00:25:07</td>\n",
       "      <td>-73.964668</td>\n",
       "      <td>40.681309</td>\n",
       "      <td>-74.000633</td>\n",
       "      <td>40.732147</td>\n",
       "      <td>25.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7093</th>\n",
       "      <td>2013-08-31 23:58:58</td>\n",
       "      <td>2013-09-01 00:06:31</td>\n",
       "      <td>-73.932343</td>\n",
       "      <td>40.796421</td>\n",
       "      <td>-73.955841</td>\n",
       "      <td>40.804691</td>\n",
       "      <td>7.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7094</th>\n",
       "      <td>2013-08-31 23:59:14</td>\n",
       "      <td>2013-09-01 00:07:40</td>\n",
       "      <td>-73.980034</td>\n",
       "      <td>40.676315</td>\n",
       "      <td>-73.964218</td>\n",
       "      <td>40.652081</td>\n",
       "      <td>9.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7095 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Pickup_time         Dropoff_time  Pickup_longitude  \\\n",
       "0     2013-08-01 17:22:00  2013-08-01 17:22:00        -73.937767   \n",
       "1     2013-08-01 17:24:00  2013-08-01 17:25:00        -73.937927   \n",
       "2     2013-08-05 11:31:47  2013-08-05 11:34:01       -115.179100   \n",
       "3     2013-08-05 11:31:47  2013-08-05 11:32:16       -115.179100   \n",
       "4     2013-08-05 11:51:21  2013-08-05 11:51:36       -115.179199   \n",
       "5     2013-08-05 11:53:27  2013-08-05 11:53:43       -115.179337   \n",
       "6     2013-08-06 06:51:19  2013-08-06 06:51:36        -73.937721   \n",
       "7     2013-08-06 10:33:07  2013-08-06 10:33:46        -76.979668   \n",
       "8     2013-08-06 13:26:34  2013-08-06 13:26:57        -73.937691   \n",
       "9     2013-08-06 13:27:53  2013-08-06 13:28:08        -73.937805   \n",
       "10    2013-08-06 13:29:17  2013-08-06 13:29:52        -73.937744   \n",
       "11    2013-08-06 13:30:55  2013-08-06 13:31:12        -73.937775   \n",
       "12    2013-08-07 10:22:30  2013-08-07 10:23:24        -76.979950   \n",
       "13    2013-08-07 10:24:53  2013-08-07 10:28:16        -76.979668   \n",
       "14    2013-08-07 10:24:53  2013-08-07 10:27:24        -76.979668   \n",
       "15    2013-08-07 10:33:23  2013-08-07 10:34:10        -76.979790   \n",
       "16    2013-08-07 14:12:46  2013-08-07 14:15:16        -73.937485   \n",
       "17    2013-08-07 15:13:35  2013-08-07 15:13:49       -115.179192   \n",
       "18    2013-08-07 15:38:07  2013-08-07 15:38:27        -73.937485   \n",
       "19    2013-08-07 15:42:29  2013-08-07 15:43:25        -73.937477   \n",
       "20    2013-08-07 15:46:09  2013-08-07 15:48:56        -73.937447   \n",
       "21    2013-08-07 15:49:16  2013-08-07 15:49:32        -73.937508   \n",
       "22    2013-08-07 16:06:29  2013-08-07 16:08:52        -73.937424   \n",
       "23    2013-08-07 16:15:27  2013-08-07 16:18:27        -73.937424   \n",
       "24    2013-08-07 16:15:27  2013-08-07 16:20:09        -73.937424   \n",
       "25    2013-08-07 16:27:31  2013-08-07 16:27:55        -73.937447   \n",
       "26    2013-08-07 16:27:31  2013-08-07 16:35:34        -73.937447   \n",
       "27    2013-08-07 16:38:29  2013-08-07 16:40:06        -73.937363   \n",
       "28    2013-08-07 16:38:29  2013-08-07 16:46:51        -73.937363   \n",
       "29    2013-08-07 16:43:27  2013-08-07 16:44:24        -73.937660   \n",
       "...                   ...                  ...               ...   \n",
       "7065  2013-08-31 23:23:38  2013-08-31 23:36:16        -73.913605   \n",
       "7066  2013-08-31 23:23:45  2013-08-31 23:34:26        -73.950272   \n",
       "7067  2013-08-31 23:23:49  2013-08-31 23:31:26        -73.844254   \n",
       "7068  2013-08-31 23:24:42  2013-08-31 23:50:50        -73.846169   \n",
       "7069  2013-08-31 23:25:05  2013-08-31 23:35:31        -73.861031   \n",
       "7070  2013-08-31 23:27:26  2013-08-31 23:54:49        -73.844818   \n",
       "7071  2013-08-31 23:27:46  2013-08-31 23:41:39        -73.954086   \n",
       "7072  2013-08-31 23:28:21  2013-09-01 00:00:58        -73.846001   \n",
       "7073  2013-08-31 23:30:53  2013-08-31 23:54:56        -73.849991   \n",
       "7074  2013-08-31 23:33:19  2013-08-31 23:38:51        -73.829971   \n",
       "7075  2013-08-31 23:34:00  2013-08-31 23:43:00        -73.845917   \n",
       "7076  2013-08-31 23:34:55  2013-08-31 23:51:43        -73.967758   \n",
       "7077  2013-08-31 23:34:58  2013-08-31 23:50:56        -73.991852   \n",
       "7078  2013-08-31 23:35:21  2013-08-31 23:48:13        -73.833656   \n",
       "7079  2013-08-31 23:40:04  2013-08-31 23:41:42        -73.926193   \n",
       "7080  2013-08-31 23:41:33  2013-09-01 00:00:18        -73.921158   \n",
       "7081  2013-08-31 23:44:17  2013-08-31 23:52:01        -73.946342   \n",
       "7082  2013-08-31 23:45:43  2013-08-31 23:50:19        -73.979172   \n",
       "7083  2013-08-31 23:46:58  2013-08-31 23:51:07        -73.943985   \n",
       "7084  2013-08-31 23:48:10  2013-09-01 00:09:26        -73.924644   \n",
       "7085  2013-08-31 23:48:29  2013-08-31 23:59:44        -73.920647   \n",
       "7086  2013-08-31 23:50:37  2013-09-01 00:01:12        -73.941200   \n",
       "7087  2013-08-31 23:51:16  2013-08-31 23:58:45        -73.844307   \n",
       "7088  2013-08-31 23:52:57  2013-08-31 23:58:45        -73.917976   \n",
       "7089  2013-08-31 23:54:00  2013-08-31 00:06:00        -73.845985   \n",
       "7090  2013-08-31 23:54:50  2013-08-31 23:57:30        -73.943115   \n",
       "7091  2013-08-31 23:57:33  2013-09-01 00:10:03        -73.824432   \n",
       "7092  2013-08-31 23:58:18  2013-09-01 00:25:07        -73.964668   \n",
       "7093  2013-08-31 23:58:58  2013-09-01 00:06:31        -73.932343   \n",
       "7094  2013-08-31 23:59:14  2013-09-01 00:07:40        -73.980034   \n",
       "\n",
       "      Pickup_latitude  Dropoff_longitude  Dropoff_latitude  Trip_distance  \n",
       "0           40.758480         -73.937767         40.758480           2.50  \n",
       "1           40.757843         -73.937927         40.757843           2.50  \n",
       "2           36.137096        -115.179337         36.136684           1.00  \n",
       "3           36.137096        -115.179337         36.136684           1.20  \n",
       "4           36.137047        -115.179199         36.137009           1.00  \n",
       "5           36.136753        -115.179276         36.136826           1.00  \n",
       "6           40.758404         -73.937721         40.758369           3.30  \n",
       "7           38.927082         -76.979713         38.927326           3.25  \n",
       "8           40.758419         -73.937790         40.758358           3.30  \n",
       "9           40.758396         -73.937775         40.758450           3.30  \n",
       "10          40.758415         -73.937759         40.758389           3.50  \n",
       "11          40.758366         -73.937790         40.758350           3.30  \n",
       "12          38.927292         -76.979591         38.927288           3.52  \n",
       "13          38.927311         -76.979889         38.927174           3.25  \n",
       "14          38.927311         -76.979813         38.927128           3.52  \n",
       "15          38.927311         -76.979561         38.927151           3.52  \n",
       "16          40.758392         -73.937485         40.758209           3.50  \n",
       "17          36.136860        -115.179283         36.137066           1.00  \n",
       "18          40.758125         -73.937485         40.758137           2.50  \n",
       "19          40.758175         -73.937424         40.758152           2.50  \n",
       "20          40.758244         -73.937508         40.758251           3.50  \n",
       "21          40.758240         -73.937447         40.758183           2.50  \n",
       "22          40.758240         -73.937469         40.758202           3.50  \n",
       "23          40.758167         -73.937431         40.758213           2.50  \n",
       "24          40.758167         -73.937424         40.758251           3.00  \n",
       "25          40.758183         -73.937492         40.758194           2.50  \n",
       "26          40.758183         -73.937325         40.758198           3.00  \n",
       "27          40.758148         -73.937416         40.758087           2.50  \n",
       "28          40.758148         -73.937241         40.758106           5.50  \n",
       "29          40.758347         -73.937729         40.758305           2.50  \n",
       "...               ...                ...               ...            ...  \n",
       "7065        40.765427         -73.918091         40.741680          11.00  \n",
       "7066        40.680496         -73.934990         40.702396          10.50  \n",
       "7067        40.721390         -73.818474         40.734043           9.00  \n",
       "7068        40.754543         -73.965820         40.677544          39.00  \n",
       "7069        40.893051         -73.901611         40.876530          14.00  \n",
       "7070        40.754986         -73.969231         40.761219          26.00  \n",
       "7071        40.742813         -74.000793         40.736462          13.50  \n",
       "7072        40.754578         -73.974899         40.759235          38.50  \n",
       "7073        40.753479         -73.977623         40.779022          34.00  \n",
       "7074        40.713734         -73.824730         40.705601           5.50  \n",
       "7075        40.754639         -73.860458         40.739819           8.50  \n",
       "7076        40.693268         -73.989105         40.720303          14.50  \n",
       "7077        40.702530         -74.007256         40.733669          14.50  \n",
       "7078        40.771580         -73.843651         40.689556          22.50  \n",
       "7079        40.761082         -73.928421         40.756069           3.50  \n",
       "7080        40.743267         -73.902840         40.701447          17.00  \n",
       "7081        40.711445         -73.951027         40.724358           7.50  \n",
       "7082        40.678406         -73.988785         40.670506           5.50  \n",
       "7083        40.784100         -73.952507         40.773121           6.00  \n",
       "7084        40.756287         -73.984779         40.710838          25.00  \n",
       "7085        40.767956         -73.885201         40.755516          11.50  \n",
       "7086        40.805779         -73.967400         40.801105           9.50  \n",
       "7087        40.721352         -73.827965         40.710865           8.00  \n",
       "7088        40.765259         -73.922600         40.755390           6.00  \n",
       "7089        40.754650         -73.884468         40.737869          15.00  \n",
       "7090        40.785336         -73.932846         40.796619           5.00  \n",
       "7091        40.734287         -73.850494         40.722317          11.50  \n",
       "7092        40.681309         -74.000633         40.732147          25.50  \n",
       "7093        40.796421         -73.955841         40.804691           7.50  \n",
       "7094        40.676315         -73.964218         40.652081           9.00  \n",
       "\n",
       "[7095 rows x 7 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_greenAug"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#Translates dates into weekdays (not working yet since date and time are together)\n",
    "#for i, row in df_greenAug.iterrows():\n",
    " #   df_greenAug.loc[i, 'Weekday'] = datetime.datetime.strptime(df_greenAug.loc[i, df_greenAug.ix[:,0]], '%Y-%m-%d ').strftime('%A')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df_greenAug.to_csv('Cleaned_Green_Traffic.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}