{ "cells": [ { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "#import all relevant packages\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import folium\n", "from folium import plugins\n", "import seaborn as sns\n", "import branca.colormap as cm\n", "import datetime\n", "%matplotlib inline" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | delivery_id | \n", "customer_id | \n", "dpartner_id | \n", "vehicle_type | \n", "pickup_place | \n", "place_category | \n", "item_name | \n", "item_quantity | \n", "item_category_name | \n", "how_long_it_took_to_order | \n", "pickup_lat | \n", "pickup_lon | \n", "dropoff_lat | \n", "dropoff_lon | \n", "when_the_delivery_started | \n", "when_the_dpartner_arrived_at_pickup | \n", "when_the_dpartner_left_pickup | \n", "when_the_dpartner_arrived_at_dropoff | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1457973 | \n", "327168 | \n", "162381 | \n", "van | \n", "Melt Shop | \n", "American | \n", "Lemonade | \n", "1.0 | \n", "Beverages | \n", "19:58.6 | \n", "40.744607 | \n", "-73.990742 | \n", "40.752073 | \n", "-73.985370 | \n", "51:59.9 | \n", "NaN | \n", "NaN | \n", "52:06.3 | \n", "
1 | \n", "1377056 | \n", "64452 | \n", "104533 | \n", "bicycle | \n", "Prince Street Pizza | \n", "Pizza | \n", "Neapolitan Rice Balls | \n", "3.0 | \n", "Munchables | \n", "25:09.1 | \n", "40.723080 | \n", "-73.994615 | \n", "40.719722 | \n", "-73.991858 | \n", "58:58.7 | \n", "26:02.1 | \n", "48:23.1 | \n", "59:22.9 | \n", "
2 | \n", "1476547 | \n", "83095 | \n", "132725 | \n", "bicycle | \n", "Bareburger | \n", "Burger | \n", "Bare Sodas | \n", "1.0 | \n", "Drinks | \n", "06:44.5 | \n", "40.728478 | \n", "-73.998392 | \n", "40.728606 | \n", "-73.995143 | \n", "39:52.7 | \n", "37:18.8 | \n", "59:10.0 | \n", "04:40.6 | \n", "
3 | \n", "1485494 | \n", "271149 | \n", "157175 | \n", "bicycle | \n", "Juice Press | \n", "Juice Bar | \n", "OMG! My Favorite Juice! | \n", "1.0 | \n", "Cold Pressed Juices | \n", "NaN | \n", "40.738868 | \n", "-74.002747 | \n", "40.751257 | \n", "-74.005634 | \n", "54:11.5 | \n", "04:17.8 | \n", "16:37.9 | \n", "32:38.1 | \n", "
4 | \n", "1327707 | \n", "122609 | \n", "118095 | \n", "bicycle | \n", "Blue Ribbon Sushi | \n", "Japanese | \n", "Spicy Tuna & Tempura Flakes | \n", "2.0 | \n", "Maki (Special Rolls) | \n", "03:45.0 | \n", "40.726110 | \n", "-74.002492 | \n", "40.709323 | \n", "-74.015867 | \n", "07:18.5 | \n", "14:42.7 | \n", "25:19.4 | \n", "48:27.2 | \n", "
\n", " | delivery_id | \n", "customer_id | \n", "jumpman_id | \n", "vehicle_type | \n", "pickup_place | \n", "place_category | \n", "item_name | \n", "item_quantity | \n", "item_category_name | \n", "how_long_it_took_to_order | \n", "... | \n", "when_the_Jumpman_arrived_at_pickup | \n", "when_the_Jumpman_left_pickup | \n", "when_the_Jumpman_arrived_at_dropoff | \n", "delivery_hr | \n", "time_to_order | \n", "time_to_arrive_at_pickup | \n", "time_spent_waiting | \n", "time_to_arrive_at_dropoff | \n", "total_delivery_time | \n", "vehicle_cat | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
time_to_order | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
19.0 | \n", "1457973 | \n", "327168 | \n", "162381 | \n", "van | \n", "Melt Shop | \n", "American | \n", "Lemonade | \n", "1.0 | \n", "Beverages | \n", "1900-01-01 00:19:58.582052 | \n", "... | \n", "NaT | \n", "NaT | \n", "2014-10-26 14:52:06.313088 | \n", "1970-01-01 00:00:00.000000013 | \n", "1970-01-01 00:00:00.000000019 | \n", "NaT | \n", "NaT | \n", "NaT | \n", "01:00:06.414164 | \n", "other | \n", "
25.0 | \n", "1377056 | \n", "64452 | \n", "104533 | \n", "bicycle | \n", "Prince Street Pizza | \n", "Pizza | \n", "Neapolitan Rice Balls | \n", "3.0 | \n", "Munchables | \n", "1900-01-01 00:25:09.107093 | \n", "... | \n", "2014-10-16 22:26:02.120931 | \n", "2014-10-16 22:48:23.091253 | \n", "2014-10-16 22:59:22.948873 | \n", "1970-01-01 00:00:00.000000021 | \n", "1970-01-01 00:00:00.000000025 | \n", "00:27:03.466021 | \n", "00:22:20.970322 | \n", "00:10:59.857620 | \n", "01:00:24.293963 | \n", "bicycle | \n", "
6.0 | \n", "1476547 | \n", "83095 | \n", "132725 | \n", "bicycle | \n", "Bareburger | \n", "Burger | \n", "Bare Sodas | \n", "1.0 | \n", "Drinks | \n", "1900-01-01 00:06:44.541717 | \n", "... | \n", "2014-10-28 21:37:18.793405 | \n", "2014-10-28 21:59:09.984810 | \n", "2014-10-28 22:04:40.634962 | \n", "1970-01-01 00:00:00.000000021 | \n", "1970-01-01 00:00:00.000000006 | \n", "-1 days +23:57:26.139011 | \n", "00:21:51.191405 | \n", "00:05:30.650152 | \n", "00:24:47.980568 | \n", "bicycle | \n", "
NaN | \n", "1485494 | \n", "271149 | \n", "157175 | \n", "bicycle | \n", "Juice Press | \n", "Juice Bar | \n", "OMG! My Favorite Juice! | \n", "1.0 | \n", "Cold Pressed Juices | \n", "NaT | \n", "... | \n", "2014-10-30 11:04:17.759577 | \n", "2014-10-30 11:16:37.895816 | \n", "2014-10-30 11:32:38.090061 | \n", "1970-01-01 00:00:00.000000010 | \n", "NaT | \n", "00:10:06.227683 | \n", "00:12:20.136239 | \n", "00:16:00.194245 | \n", "00:38:26.558167 | \n", "bicycle | \n", "
3.0 | \n", "1327707 | \n", "122609 | \n", "118095 | \n", "bicycle | \n", "Blue Ribbon Sushi | \n", "Japanese | \n", "Spicy Tuna & Tempura Flakes | \n", "2.0 | \n", "Maki (Special Rolls) | \n", "1900-01-01 00:03:45.035418 | \n", "... | \n", "2014-10-10 00:14:42.702223 | \n", "2014-10-10 00:25:19.400294 | \n", "2014-10-10 00:48:27.150595 | \n", "1970-01-01 00:00:00.000000000 | \n", "1970-01-01 00:00:00.000000003 | \n", "00:07:24.251718 | \n", "00:10:36.698071 | \n", "00:23:07.750301 | \n", "00:41:08.700090 | \n", "bicycle | \n", "
5 rows × 25 columns
\n", "