full_route.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: googlemaps in /Users/nicholesun/opt/anaconda3/lib/python3.7/site-packages (2.5.1)\n",
      "Requirement already satisfied: requests<3.0,>=2.11.1 in /Users/nicholesun/opt/anaconda3/lib/python3.7/site-packages (from googlemaps) (2.22.0)\n",
      "Requirement already satisfied: idna<2.9,>=2.5 in /Users/nicholesun/opt/anaconda3/lib/python3.7/site-packages (from requests<3.0,>=2.11.1->googlemaps) (2.8)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in /Users/nicholesun/opt/anaconda3/lib/python3.7/site-packages (from requests<3.0,>=2.11.1->googlemaps) (2019.11.28)\n",
      "Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /Users/nicholesun/opt/anaconda3/lib/python3.7/site-packages (from requests<3.0,>=2.11.1->googlemaps) (1.25.8)\n",
      "Requirement already satisfied: chardet<3.1.0,>=3.0.2 in /Users/nicholesun/opt/anaconda3/lib/python3.7/site-packages (from requests<3.0,>=2.11.1->googlemaps) (3.0.4)\n"
     ]
    }
   ],
   "source": [
    "!pip install googlemaps\n",
    "import pandas as pd # pandas - a powerful data analysis and manipulation library for Python\n",
    "import requests # Requests is an HTTP library, written in Python, for human beings.\n",
    "from datetime import datetime\n",
    "import googlemaps\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Google Maps API key\n",
    "apikey = 'AIzaSyDxk6272R8Yu_QDKZRyR27SZBaJKN-_3u0'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Using sample user origin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#User will input address as text\n",
    "origin_address = '1512 Shattuck Ave, Berkeley, CA 94709'\n",
    "dest_address = 'New York University,New York, NY 10003'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[37.8798419, -122.2695316]\n",
      "[40.72951339999999, -73.9964609]\n"
     ]
    }
   ],
   "source": [
    "#Use Google Maps to grab latitude and longitude\n",
    "r = requests.get('https://maps.googleapis.com/maps/api/geocode/json?address=\"%s\"&key=%s'%\n",
    "                 (origin_address, apikey))\n",
    "r1=requests.get('https://maps.googleapis.com/maps/api/geocode/json?address=\"%s\"&key=%s'%\n",
    "                 (dest_address, apikey))\n",
    "result_o = r.json()['results']\n",
    "result_d=r1.json()['results']\n",
    "location_origin = result_o[0]['geometry']['location']\n",
    "location_destination = result_d[0]['geometry']['location']\n",
    "o_lat = location_origin['lat']\n",
    "o_lon = location_origin['lng']\n",
    "d_lat = location_destination['lat']\n",
    "d_lon = location_destination['lng']\n",
    "origin = [o_lat, o_lon]\n",
    "destination=[d_lat,d_lon]\n",
    "print(origin)\n",
    "print(destination)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Using Amadeus to find nearest airport to user's starting location"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: amadeus in /Users/nicholesun/opt/anaconda3/lib/python3.7/site-packages (3.5.0)\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    }
   ],
   "source": [
    "pip install amadeus"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "from amadeus import Client, ResponseError\n",
    "\n",
    "amadeus = Client(client_id='UmuSC0LY9TgqaZoLDpBR2x74yN0GCahI',\n",
    "    client_secret='9SbiFzopXFTkVOBz')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'type': 'location', 'subType': 'AIRPORT', 'name': 'LAGUARDIA', 'detailedName': 'NEW YORK/NY/US:LAGUARDIA', 'timeZoneOffset': '-04:00', 'iataCode': 'LGA', 'geoCode': {'latitude': 40.77607, 'longitude': -73.87269}, 'address': {'cityName': 'NEW YORK', 'cityCode': 'NYC', 'countryName': 'UNITED STATES OF AMERICA', 'countryCode': 'US', 'stateCode': 'NY', 'regionCode': 'NAMER'}, 'distance': {'value': 11, 'unit': 'KM'}, 'analytics': {'flights': {'score': 25}, 'travelers': {'score': 17}}, 'relevance': 211.41658}\n",
      "{'type': 'location', 'subType': 'AIRPORT', 'name': 'NEWARK LIBERTY INTL', 'detailedName': 'NEW YORK/NJ/US:NEWARK LIBERTY', 'timeZoneOffset': '-04:00', 'iataCode': 'EWR', 'geoCode': {'latitude': 40.69709, 'longitude': -74.17557}, 'address': {'cityName': 'NEW YORK', 'cityCode': 'NYC', 'countryName': 'UNITED STATES OF AMERICA', 'countryCode': 'US', 'stateCode': 'NJ', 'regionCode': 'NAMER'}, 'distance': {'value': 15, 'unit': 'KM'}, 'analytics': {'flights': {'score': 30}, 'travelers': {'score': 24}}, 'relevance': 192.45734}\n",
      "{'type': 'location', 'subType': 'AIRPORT', 'name': 'JOHN F KENNEDY INTL', 'detailedName': 'NEW YORK/NY/US:JOHN F KENNEDY', 'timeZoneOffset': '-04:00', 'iataCode': 'JFK', 'geoCode': {'latitude': 40.63983, 'longitude': -73.77874}, 'address': {'cityName': 'NEW YORK', 'cityCode': 'NYC', 'countryName': 'UNITED STATES OF AMERICA', 'countryCode': 'US', 'stateCode': 'NY', 'regionCode': 'NAMER'}, 'distance': {'value': 20, 'unit': 'KM'}, 'analytics': {'flights': {'score': 34}, 'travelers': {'score': 35}}, 'relevance': 161.20226}\n",
      "{'type': 'location', 'subType': 'AIRPORT', 'name': 'PHILADELPHIA INTL', 'detailedName': 'PHILADELPHIA/PA/US:PHILADELPHI', 'timeZoneOffset': '-04:00', 'iataCode': 'PHL', 'geoCode': {'latitude': 39.87835, 'longitude': -75.24018}, 'address': {'cityName': 'PHILADELPHIA', 'cityCode': 'PHL', 'countryName': 'UNITED STATES OF AMERICA', 'countryCode': 'US', 'stateCode': 'PA', 'regionCode': 'NAMER'}, 'distance': {'value': 141, 'unit': 'KM'}, 'analytics': {'flights': {'score': 27}, 'travelers': {'score': 19}}, 'relevance': 18.98661}\n",
      "{'type': 'location', 'subType': 'AIRPORT', 'name': 'EDWARD L LOGAN INTL', 'detailedName': 'BOSTON/MA/US:EDWARD L LOGAN IN', 'timeZoneOffset': '-04:00', 'iataCode': 'BOS', 'geoCode': {'latitude': 42.36514, 'longitude': -71.01777}, 'address': {'cityName': 'BOSTON', 'cityCode': 'BOS', 'countryName': 'UNITED STATES OF AMERICA', 'countryCode': 'US', 'stateCode': 'MA', 'regionCode': 'NAMER'}, 'distance': {'value': 307, 'unit': 'KM'}, 'analytics': {'flights': {'score': 29}, 'travelers': {'score': 23}}, 'relevance': 9.34789}\n",
      "{'type': 'location', 'subType': 'AIRPORT', 'name': 'WESTCHESTER COUNTY', 'detailedName': 'WHITE PLAINS/NY/US:WESTCHESTER', 'timeZoneOffset': '-04:00', 'iataCode': 'HPN', 'geoCode': {'latitude': 41.06694, 'longitude': -73.7075}, 'address': {'cityName': 'WHITE PLAINS', 'cityCode': 'HPN', 'countryName': 'UNITED STATES OF AMERICA', 'countryCode': 'US', 'stateCode': 'NY', 'regionCode': 'NAMER'}, 'distance': {'value': 44, 'unit': 'KM'}, 'analytics': {'flights': {'score': 3}, 'travelers': {'score': 1}}, 'relevance': 6.14908}\n",
      "{'type': 'location', 'subType': 'AIRPORT', 'name': 'R REAGAN NAT', 'detailedName': 'WASHINGTON/DC/US:R REAGAN NAT', 'timeZoneOffset': '-04:00', 'iataCode': 'DCA', 'geoCode': {'latitude': 38.85233, 'longitude': -77.0372}, 'address': {'cityName': 'WASHINGTON', 'cityCode': 'WAS', 'countryName': 'UNITED STATES OF AMERICA', 'countryCode': 'US', 'stateCode': 'DC', 'regionCode': 'NAMER'}, 'distance': {'value': 333, 'unit': 'KM'}, 'analytics': {'flights': {'score': 20}, 'travelers': {'score': 14}}, 'relevance': 5.9629}\n",
      "{'type': 'location', 'subType': 'AIRPORT', 'name': 'BALTIMORE/WASH. INTL', 'detailedName': 'BALTIMORE/MD/US:BALTIMORE/WASH', 'timeZoneOffset': '-04:00', 'iataCode': 'BWI', 'geoCode': {'latitude': 39.17528, 'longitude': -76.66833}, 'address': {'cityName': 'BALTIMORE', 'cityCode': 'WAS', 'countryName': 'UNITED STATES OF AMERICA', 'countryCode': 'US', 'stateCode': 'MD', 'regionCode': 'NAMER'}, 'distance': {'value': 286, 'unit': 'KM'}, 'analytics': {'flights': {'score': 16}, 'travelers': {'score': 15}}, 'relevance': 5.54605}\n",
      "{'type': 'location', 'subType': 'AIRPORT', 'name': 'DULLES INTL', 'detailedName': 'WASHINGTON/DC/US:DULLES INTL', 'timeZoneOffset': '-04:00', 'iataCode': 'IAD', 'geoCode': {'latitude': 38.94877, 'longitude': -77.4491}, 'address': {'cityName': 'WASHINGTON', 'cityCode': 'WAS', 'countryName': 'UNITED STATES OF AMERICA', 'countryCode': 'US', 'stateCode': 'DC', 'regionCode': 'NAMER'}, 'distance': {'value': 355, 'unit': 'KM'}, 'analytics': {'flights': {'score': 18}, 'travelers': {'score': 14}}, 'relevance': 5.16149}\n",
      "{'type': 'location', 'subType': 'AIRPORT', 'name': 'BRAINARD', 'detailedName': 'HARTFORD/CT/US:BRAINARD', 'timeZoneOffset': '-04:00', 'iataCode': 'HFD', 'geoCode': {'latitude': 41.74119, 'longitude': -72.64958}, 'address': {'cityName': 'HARTFORD', 'cityCode': 'HFD', 'countryName': 'UNITED STATES OF AMERICA', 'countryCode': 'US', 'stateCode': 'CT', 'regionCode': 'NAMER'}, 'distance': {'value': 159, 'unit': 'KM'}, 'analytics': {'flights': {'score': 5}, 'travelers': {'score': 4}}, 'relevance': 3.0596}\n"
     ]
    }
   ],
   "source": [
    "# Nearest airport search, put into a result array\n",
    "#Need to get live latitude and longitudinal data from Google Maps\n",
    "origin_address_list = []\n",
    "dest_address_list=[]\n",
    "origin_state_list = []\n",
    "dest_state_list = []\n",
    "a_lats = []\n",
    "a_lons = []\n",
    "b_lats=[]\n",
    "b_lons=[]\n",
    "a_iata = []\n",
    "b_iata = []\n",
    "try:\n",
    "    '''\n",
    "    What relevant airports are there around the origin location?\n",
    "    '''\n",
    "    response = amadeus.reference_data.locations.airports.get(longitude=o_lon, latitude=o_lat)\n",
    "    response1 = amadeus.reference_data.locations.airports.get(longitude=d_lon, latitude=d_lat)\n",
    "    for i in response.data:\n",
    "        data_dict = i\n",
    "#         print(i)\n",
    "        origin_address_list.append(data_dict['name'])\n",
    "        origin_state_list.append(data_dict['address']['stateCode'])\n",
    "        a_lats.append(data_dict['geoCode']['latitude'])\n",
    "        a_lons.append(data_dict['geoCode']['longitude'])\n",
    "        a_iata.append(data_dict['iataCode'])\n",
    "except ResponseError as error:\n",
    "    raise error\n",
    "    \n",
    "try:\n",
    "    '''\n",
    "    What relevant airports are there around the destination location?\n",
    "    '''\n",
    "    response1 = amadeus.reference_data.locations.airports.get(longitude=d_lon, latitude=d_lat)\n",
    "    for i in response1.data:\n",
    "        data_dict1 = i\n",
    "        print(i)\n",
    "        dest_address_list.append(data_dict1['name'])\n",
    "        dest_state_list.append(data_dict1['address']['stateCode'])\n",
    "        b_lats.append(data_dict1['geoCode']['latitude'])\n",
    "        b_lons.append(data_dict1['geoCode']['longitude'])\n",
    "        b_iata.append(data_dict1['iataCode'])\n",
    "except ResponseError as error:\n",
    "    raise error"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['SAN FRANCISCO INTL', 'OAKLAND INTL', 'SAN JOSE MNPL', 'EXECUTIVE', 'INTERNATIONAL', 'BUCHANAN FLD', 'TAHOE INTL', 'CHARLES M SCHULZ', 'FRESNO YOSEMITE INTL', 'MONTEREY REGIONAL']\n",
      "[37.61882, 37.72104, 37.36189, 38.51323, 38.69518, 37.98937, 39.50597, 38.5088, 36.77606, 36.5879]\n",
      "[-122.3758, -122.2216, -121.9289, -121.4975, -121.5916, -122.058, -119.7731, -122.8139, -119.719, -121.8394]\n",
      "['SFO', 'OAK', 'SJC', 'SAC', 'SMF', 'CCR', 'RNO', 'STS', 'FAT', 'MRY']\n",
      "\n",
      "['LAGUARDIA', 'NEWARK LIBERTY INTL', 'JOHN F KENNEDY INTL', 'PHILADELPHIA INTL', 'EDWARD L LOGAN INTL', 'WESTCHESTER COUNTY', 'R REAGAN NAT', 'BALTIMORE/WASH. INTL', 'DULLES INTL', 'BRAINARD']\n",
      "[40.77607, 40.69709, 40.63983, 39.87835, 42.36514, 41.06694, 38.85233, 39.17528, 38.94877, 41.74119]\n",
      "[-73.87269, -74.17557, -73.77874, -75.24018, -71.01777, -73.7075, -77.0372, -76.66833, -77.4491, -72.64958]\n",
      "['LGA', 'EWR', 'JFK', 'PHL', 'BOS', 'HPN', 'DCA', 'BWI', 'IAD', 'HFD']\n"
     ]
    }
   ],
   "source": [
    "print(origin_address_list)\n",
    "print(a_lats)\n",
    "print(a_lons)\n",
    "print(a_iata)\n",
    "print()\n",
    "print(dest_address_list)\n",
    "print(b_lats)\n",
    "print(b_lons)\n",
    "print(b_iata)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Using Amadeus API to calculate cheapest flight cost\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The cheapest flight found costs 155.40\n"
     ]
    }
   ],
   "source": [
    "from amadeus import Client, ResponseError\n",
    "import json\n",
    "\n",
    "amadeus = Client(\n",
    "    client_id=' UmuSC0LY9TgqaZoLDpBR2x74yN0GCahI',\n",
    "    client_secret='9SbiFzopXFTkVOBz'\n",
    ")\n",
    "\n",
    "try:\n",
    "    response = amadeus.shopping.flight_offers_search.get(\n",
    "        originLocationCode=\"SFO\",\n",
    "        destinationLocationCode=\"LGA\",\n",
    "        departureDate='2020-07-01',\n",
    "        adults=1)\n",
    "    flight_cost=response.data[0]['price']['total']\n",
    "    print(\"The cheapest flight found costs\",flight_cost)\n",
    "except ResponseError as error:\n",
    "    print(error)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Using Google Maps to create dataframe of nearest airport latitudes and longitudes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "results = []\n",
    "# locations_latitude = []\n",
    "# locations_longitude = []\n",
    "formatted_address = []\n",
    "state = []\n",
    "for location_string in origin_address_list:\n",
    "    r = requests.get('https://maps.googleapis.com/maps/api/geocode/json?address=\"%s\"&key=%s'%\n",
    "                     (location_string, apikey))\n",
    "#     print(r.json())\n",
    "    result = r.json()['results']\n",
    "#     print(result)\n",
    "    location = result[0]['geometry']['location']\n",
    "#     locations_longitude.append(location['lng'])\n",
    "#     locations_latitude.append(location['lat'])\n",
    "    formatted_address.append(result[0]['formatted_address'])\n",
    "    results.append(result)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>iata code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SAN FRANCISCO INTL</td>\n",
       "      <td>37.61882</td>\n",
       "      <td>-122.3758</td>\n",
       "      <td>SFO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>OAKLAND INTL</td>\n",
       "      <td>37.72104</td>\n",
       "      <td>-122.2216</td>\n",
       "      <td>OAK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SAN JOSE MNPL</td>\n",
       "      <td>37.36189</td>\n",
       "      <td>-121.9289</td>\n",
       "      <td>SJC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EXECUTIVE</td>\n",
       "      <td>38.51323</td>\n",
       "      <td>-121.4975</td>\n",
       "      <td>SAC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>INTERNATIONAL</td>\n",
       "      <td>38.69518</td>\n",
       "      <td>-121.5916</td>\n",
       "      <td>SMF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BUCHANAN FLD</td>\n",
       "      <td>37.98937</td>\n",
       "      <td>-122.0580</td>\n",
       "      <td>CCR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>TAHOE INTL</td>\n",
       "      <td>39.50597</td>\n",
       "      <td>-119.7731</td>\n",
       "      <td>RNO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CHARLES M SCHULZ</td>\n",
       "      <td>38.50880</td>\n",
       "      <td>-122.8139</td>\n",
       "      <td>STS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>FRESNO YOSEMITE INTL</td>\n",
       "      <td>36.77606</td>\n",
       "      <td>-119.7190</td>\n",
       "      <td>FAT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>MONTEREY REGIONAL</td>\n",
       "      <td>36.58790</td>\n",
       "      <td>-121.8394</td>\n",
       "      <td>MRY</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                address  latitude  longitude iata code\n",
       "0    SAN FRANCISCO INTL  37.61882  -122.3758       SFO\n",
       "1          OAKLAND INTL  37.72104  -122.2216       OAK\n",
       "2         SAN JOSE MNPL  37.36189  -121.9289       SJC\n",
       "3             EXECUTIVE  38.51323  -121.4975       SAC\n",
       "4         INTERNATIONAL  38.69518  -121.5916       SMF\n",
       "5          BUCHANAN FLD  37.98937  -122.0580       CCR\n",
       "6            TAHOE INTL  39.50597  -119.7731       RNO\n",
       "7      CHARLES M SCHULZ  38.50880  -122.8139       STS\n",
       "8  FRESNO YOSEMITE INTL  36.77606  -119.7190       FAT\n",
       "9     MONTEREY REGIONAL  36.58790  -121.8394       MRY"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "df = pd.DataFrame({'address':origin_address_list,'latitude':a_lats,'longitude':a_lons,'iata code':a_iata})\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>iata code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LAGUARDIA</td>\n",
       "      <td>40.77607</td>\n",
       "      <td>-73.87269</td>\n",
       "      <td>LGA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NEWARK LIBERTY INTL</td>\n",
       "      <td>40.69709</td>\n",
       "      <td>-74.17557</td>\n",
       "      <td>EWR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>JOHN F KENNEDY INTL</td>\n",
       "      <td>40.63983</td>\n",
       "      <td>-73.77874</td>\n",
       "      <td>JFK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PHILADELPHIA INTL</td>\n",
       "      <td>39.87835</td>\n",
       "      <td>-75.24018</td>\n",
       "      <td>PHL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EDWARD L LOGAN INTL</td>\n",
       "      <td>42.36514</td>\n",
       "      <td>-71.01777</td>\n",
       "      <td>BOS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>WESTCHESTER COUNTY</td>\n",
       "      <td>41.06694</td>\n",
       "      <td>-73.70750</td>\n",
       "      <td>HPN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>R REAGAN NAT</td>\n",
       "      <td>38.85233</td>\n",
       "      <td>-77.03720</td>\n",
       "      <td>DCA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BALTIMORE/WASH. INTL</td>\n",
       "      <td>39.17528</td>\n",
       "      <td>-76.66833</td>\n",
       "      <td>BWI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DULLES INTL</td>\n",
       "      <td>38.94877</td>\n",
       "      <td>-77.44910</td>\n",
       "      <td>IAD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BRAINARD</td>\n",
       "      <td>41.74119</td>\n",
       "      <td>-72.64958</td>\n",
       "      <td>HFD</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                address  latitude  longitude iata code\n",
       "0             LAGUARDIA  40.77607  -73.87269       LGA\n",
       "1   NEWARK LIBERTY INTL  40.69709  -74.17557       EWR\n",
       "2   JOHN F KENNEDY INTL  40.63983  -73.77874       JFK\n",
       "3     PHILADELPHIA INTL  39.87835  -75.24018       PHL\n",
       "4   EDWARD L LOGAN INTL  42.36514  -71.01777       BOS\n",
       "5    WESTCHESTER COUNTY  41.06694  -73.70750       HPN\n",
       "6          R REAGAN NAT  38.85233  -77.03720       DCA\n",
       "7  BALTIMORE/WASH. INTL  39.17528  -76.66833       BWI\n",
       "8           DULLES INTL  38.94877  -77.44910       IAD\n",
       "9              BRAINARD  41.74119  -72.64958       HFD"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = pd.DataFrame({'address':dest_address_list,'latitude':b_lats,'longitude':b_lons, 'iata code':b_iata})\n",
    "df1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Calculate distance from each of these airports to user origin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "dist_from_origin = []\n",
    "time_from_origin = []\n",
    "dist_from_destination=[]\n",
    "time_from_destination=[]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[37.8798419, -122.2695316]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "origin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[40.72951339999999, -73.9964609]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "destination"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "37.8798419,-122.2695316\n"
     ]
    }
   ],
   "source": [
    "origin_str = str(o_lat) + \",\" + str(o_lon)\n",
    "print(origin_str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "40.72951339999999,-73.9964609\n"
     ]
    }
   ],
   "source": [
    "dest_str = str(d_lat) + \",\" + str(d_lon)\n",
    "print(dest_str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Perform request to use the Google Maps API web service\n",
    "now = datetime.now()\n",
    "gmaps = googlemaps.Client(key=apikey)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "25.6 mi\n",
      "38 mins\n",
      "1512 Shattuck Ave, Berkeley, CA 94709, USA\n",
      "4 Domestic Terminals Departures Level, San Francisco, CA 94128, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "15.4 mi\n",
      "28 mins\n",
      "1512 Shattuck Ave, Berkeley, CA 94709, USA\n",
      "178 Air Cargo Way, Oakland, CA 94621, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "46.6 mi\n",
      "58 mins\n",
      "1512 Shattuck Ave, Berkeley, CA 94709, USA\n",
      "Norman Y. Mineta San Jose International Airport (SJC), 1701 Airport Blvd, San Jose, CA 95110, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "81.0 mi\n",
      "1 hour 26 mins\n",
      "1512 Shattuck Ave, Berkeley, CA 94709, USA\n",
      "6107 Freeport Blvd, Sacramento, CA 95822, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "82.1 mi\n",
      "1 hour 28 mins\n",
      "1512 Shattuck Ave, Berkeley, CA 94709, USA\n",
      "Alaska Airlines - Sacramento, 6900 Airport Blvd, Sacramento, CA 95837, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "22.5 mi\n",
      "37 mins\n",
      "1512 Shattuck Ave, Berkeley, CA 94709, USA\n",
      "510 Sally Ride Dr, Concord, CA 94520, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "212 mi\n",
      "3 hours 29 mins\n",
      "1512 Shattuck Ave, Berkeley, CA 94709, USA\n",
      "2001 E Plumb Ln, Reno, NV 89502, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "64.1 mi\n",
      "1 hour 12 mins\n",
      "1512 Shattuck Ave, Berkeley, CA 94709, USA\n",
      "Charles M. Schulz–Sonoma County Airport, 2200 Airport Blvd, Santa Rosa, CA 95403, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "186 mi\n",
      "3 hours 5 mins\n",
      "1512 Shattuck Ave, Berkeley, CA 94709, USA\n",
      "Fresno Yosemite International Airport (FAT), 5175 E Clinton Way, Fresno, CA 93727, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "117 mi\n",
      "2 hours 4 mins\n",
      "1512 Shattuck Ave, Berkeley, CA 94709, USA\n",
      "Airport Rd, Monterey, CA 93940, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n"
     ]
    }
   ],
   "source": [
    "for idx, row in df.iterrows():\n",
    "    a_lat = row['latitude']\n",
    "    a_lon = row['longitude']\n",
    "    airport_str = str(a_lat) + \",\" + str(a_lon)\n",
    "    directions = gmaps.directions(origin = origin_str,destination = airport_str,\n",
    "                                  mode='driving',departure_time = now)\n",
    "#     print(directions)\n",
    "    print(directions[0]['legs'][0]['distance']['text'])\n",
    "    print(directions[0]['legs'][0]['duration']['text'])\n",
    "    print(directions[0]['legs'][0]['start_address'])\n",
    "    print(directions[0]['legs'][0]['end_address'])\n",
    "    dist_from_origin.append(directions[0]['legs'][0]['distance']['text'])\n",
    "    time_from_origin.append(directions[0]['legs'][0]['duration']['text'])\n",
    "    print(\"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10.3 mi\n",
      "25 mins\n",
      "50 West 4th Street, New York, NY 10012, USA\n",
      "Terminal B, LaGuardia Rd, East Elmhurst, NY 11371, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "13.7 mi\n",
      "28 mins\n",
      "50 West 4th Street, New York, NY 10012, USA\n",
      "Terminal C, 3 Brewster Rd, Newark, NJ 07114, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "18.6 mi\n",
      "37 mins\n",
      "50 West 4th Street, New York, NY 10012, USA\n",
      "John F. Kennedy International Airport (JFK), Queens, NY 11430, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "104 mi\n",
      "1 hour 51 mins\n",
      "50 West 4th Street, New York, NY 10012, USA\n",
      "Airport Terminals E & F, Philadelphia, PA 19153, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "217 mi\n",
      "3 hours 47 mins\n",
      "50 West 4th Street, New York, NY 10012, USA\n",
      "300 Terminal Dr, Boston, MA 02128, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "35.1 mi\n",
      "56 mins\n",
      "50 West 4th Street, New York, NY 10012, USA\n",
      "240 Airport Rd, West Harrison, NY 10604, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "233 mi\n",
      "3 hours 53 mins\n",
      "50 West 4th Street, New York, NY 10012, USA\n",
      "Ronald Reagan Washington National Airport (DCA), Arlington, VA 22202, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "199 mi\n",
      "3 hours 14 mins\n",
      "50 West 4th Street, New York, NY 10012, USA\n",
      "Baltimore/Washington International Thurgood Marshall Airport (BWI), Baltimore, MD 21240, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "249 mi\n",
      "4 hours 1 min\n",
      "50 West 4th Street, New York, NY 10012, USA\n",
      "Dulles International Airport (IAD), 1 Saarinen Cir, Dulles, VA 20166, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n",
      "114 mi\n",
      "2 hours 9 mins\n",
      "50 West 4th Street, New York, NY 10012, USA\n",
      "20 Lindbergh Dr, Hartford, CT 06114, USA\n",
      "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n"
     ]
    }
   ],
   "source": [
    "for idx, row in df1.iterrows():\n",
    "    b_lat = row['latitude']\n",
    "    b_lon = row['longitude']\n",
    "    airport_d_str = str(b_lat) + \",\" + str(b_lon)\n",
    "    directions_d = gmaps.directions(origin = dest_str,destination = airport_d_str,\n",
    "                                  mode='driving',departure_time = now)\n",
    "#     print(directions)\n",
    "    print(directions_d[0]['legs'][0]['distance']['text'])\n",
    "    print(directions_d[0]['legs'][0]['duration']['text'])\n",
    "    print(directions_d[0]['legs'][0]['start_address'])\n",
    "    print(directions_d[0]['legs'][0]['end_address'])\n",
    "    dist_from_destination.append(directions_d[0]['legs'][0]['distance']['text'])\n",
    "    time_from_destination.append(directions_d[0]['legs'][0]['duration']['text'])\n",
    "    print(\"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['dist from origin'] = dist_from_origin\n",
    "df['time from origin'] = time_from_origin\n",
    "df['state'] = origin_state_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1['dist from destination'] = dist_from_destination\n",
    "df1['time from destination'] = time_from_destination\n",
    "df1['state'] = dest_state_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>iata code</th>\n",
       "      <th>dist from origin</th>\n",
       "      <th>time from origin</th>\n",
       "      <th>state</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SAN FRANCISCO INTL</td>\n",
       "      <td>37.61882</td>\n",
       "      <td>-122.3758</td>\n",
       "      <td>SFO</td>\n",
       "      <td>25.6 mi</td>\n",
       "      <td>38 mins</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>OAKLAND INTL</td>\n",
       "      <td>37.72104</td>\n",
       "      <td>-122.2216</td>\n",
       "      <td>OAK</td>\n",
       "      <td>15.4 mi</td>\n",
       "      <td>28 mins</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SAN JOSE MNPL</td>\n",
       "      <td>37.36189</td>\n",
       "      <td>-121.9289</td>\n",
       "      <td>SJC</td>\n",
       "      <td>46.6 mi</td>\n",
       "      <td>58 mins</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EXECUTIVE</td>\n",
       "      <td>38.51323</td>\n",
       "      <td>-121.4975</td>\n",
       "      <td>SAC</td>\n",
       "      <td>81.0 mi</td>\n",
       "      <td>1 hour 26 mins</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>INTERNATIONAL</td>\n",
       "      <td>38.69518</td>\n",
       "      <td>-121.5916</td>\n",
       "      <td>SMF</td>\n",
       "      <td>82.1 mi</td>\n",
       "      <td>1 hour 28 mins</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BUCHANAN FLD</td>\n",
       "      <td>37.98937</td>\n",
       "      <td>-122.0580</td>\n",
       "      <td>CCR</td>\n",
       "      <td>22.5 mi</td>\n",
       "      <td>37 mins</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>TAHOE INTL</td>\n",
       "      <td>39.50597</td>\n",
       "      <td>-119.7731</td>\n",
       "      <td>RNO</td>\n",
       "      <td>212 mi</td>\n",
       "      <td>3 hours 29 mins</td>\n",
       "      <td>NV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CHARLES M SCHULZ</td>\n",
       "      <td>38.50880</td>\n",
       "      <td>-122.8139</td>\n",
       "      <td>STS</td>\n",
       "      <td>64.1 mi</td>\n",
       "      <td>1 hour 12 mins</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>FRESNO YOSEMITE INTL</td>\n",
       "      <td>36.77606</td>\n",
       "      <td>-119.7190</td>\n",
       "      <td>FAT</td>\n",
       "      <td>186 mi</td>\n",
       "      <td>3 hours 5 mins</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>MONTEREY REGIONAL</td>\n",
       "      <td>36.58790</td>\n",
       "      <td>-121.8394</td>\n",
       "      <td>MRY</td>\n",
       "      <td>117 mi</td>\n",
       "      <td>2 hours 4 mins</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                address  latitude  longitude iata code dist from origin  \\\n",
       "0    SAN FRANCISCO INTL  37.61882  -122.3758       SFO          25.6 mi   \n",
       "1          OAKLAND INTL  37.72104  -122.2216       OAK          15.4 mi   \n",
       "2         SAN JOSE MNPL  37.36189  -121.9289       SJC          46.6 mi   \n",
       "3             EXECUTIVE  38.51323  -121.4975       SAC          81.0 mi   \n",
       "4         INTERNATIONAL  38.69518  -121.5916       SMF          82.1 mi   \n",
       "5          BUCHANAN FLD  37.98937  -122.0580       CCR          22.5 mi   \n",
       "6            TAHOE INTL  39.50597  -119.7731       RNO           212 mi   \n",
       "7      CHARLES M SCHULZ  38.50880  -122.8139       STS          64.1 mi   \n",
       "8  FRESNO YOSEMITE INTL  36.77606  -119.7190       FAT           186 mi   \n",
       "9     MONTEREY REGIONAL  36.58790  -121.8394       MRY           117 mi   \n",
       "\n",
       "  time from origin state  \n",
       "0          38 mins    CA  \n",
       "1          28 mins    CA  \n",
       "2          58 mins    CA  \n",
       "3   1 hour 26 mins    CA  \n",
       "4   1 hour 28 mins    CA  \n",
       "5          37 mins    CA  \n",
       "6  3 hours 29 mins    NV  \n",
       "7   1 hour 12 mins    CA  \n",
       "8   3 hours 5 mins    CA  \n",
       "9   2 hours 4 mins    CA  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>iata code</th>\n",
       "      <th>dist from destination</th>\n",
       "      <th>time from destination</th>\n",
       "      <th>state</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LAGUARDIA</td>\n",
       "      <td>40.77607</td>\n",
       "      <td>-73.87269</td>\n",
       "      <td>LGA</td>\n",
       "      <td>10.3 mi</td>\n",
       "      <td>25 mins</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NEWARK LIBERTY INTL</td>\n",
       "      <td>40.69709</td>\n",
       "      <td>-74.17557</td>\n",
       "      <td>EWR</td>\n",
       "      <td>13.7 mi</td>\n",
       "      <td>28 mins</td>\n",
       "      <td>NJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>JOHN F KENNEDY INTL</td>\n",
       "      <td>40.63983</td>\n",
       "      <td>-73.77874</td>\n",
       "      <td>JFK</td>\n",
       "      <td>18.6 mi</td>\n",
       "      <td>37 mins</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PHILADELPHIA INTL</td>\n",
       "      <td>39.87835</td>\n",
       "      <td>-75.24018</td>\n",
       "      <td>PHL</td>\n",
       "      <td>104 mi</td>\n",
       "      <td>1 hour 51 mins</td>\n",
       "      <td>PA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EDWARD L LOGAN INTL</td>\n",
       "      <td>42.36514</td>\n",
       "      <td>-71.01777</td>\n",
       "      <td>BOS</td>\n",
       "      <td>217 mi</td>\n",
       "      <td>3 hours 47 mins</td>\n",
       "      <td>MA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>WESTCHESTER COUNTY</td>\n",
       "      <td>41.06694</td>\n",
       "      <td>-73.70750</td>\n",
       "      <td>HPN</td>\n",
       "      <td>35.1 mi</td>\n",
       "      <td>56 mins</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>R REAGAN NAT</td>\n",
       "      <td>38.85233</td>\n",
       "      <td>-77.03720</td>\n",
       "      <td>DCA</td>\n",
       "      <td>233 mi</td>\n",
       "      <td>3 hours 53 mins</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BALTIMORE/WASH. INTL</td>\n",
       "      <td>39.17528</td>\n",
       "      <td>-76.66833</td>\n",
       "      <td>BWI</td>\n",
       "      <td>199 mi</td>\n",
       "      <td>3 hours 14 mins</td>\n",
       "      <td>MD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DULLES INTL</td>\n",
       "      <td>38.94877</td>\n",
       "      <td>-77.44910</td>\n",
       "      <td>IAD</td>\n",
       "      <td>249 mi</td>\n",
       "      <td>4 hours 1 min</td>\n",
       "      <td>DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BRAINARD</td>\n",
       "      <td>41.74119</td>\n",
       "      <td>-72.64958</td>\n",
       "      <td>HFD</td>\n",
       "      <td>114 mi</td>\n",
       "      <td>2 hours 9 mins</td>\n",
       "      <td>CT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                address  latitude  longitude iata code dist from destination  \\\n",
       "0             LAGUARDIA  40.77607  -73.87269       LGA               10.3 mi   \n",
       "1   NEWARK LIBERTY INTL  40.69709  -74.17557       EWR               13.7 mi   \n",
       "2   JOHN F KENNEDY INTL  40.63983  -73.77874       JFK               18.6 mi   \n",
       "3     PHILADELPHIA INTL  39.87835  -75.24018       PHL                104 mi   \n",
       "4   EDWARD L LOGAN INTL  42.36514  -71.01777       BOS                217 mi   \n",
       "5    WESTCHESTER COUNTY  41.06694  -73.70750       HPN               35.1 mi   \n",
       "6          R REAGAN NAT  38.85233  -77.03720       DCA                233 mi   \n",
       "7  BALTIMORE/WASH. INTL  39.17528  -76.66833       BWI                199 mi   \n",
       "8           DULLES INTL  38.94877  -77.44910       IAD                249 mi   \n",
       "9              BRAINARD  41.74119  -72.64958       HFD                114 mi   \n",
       "\n",
       "  time from destination state  \n",
       "0               25 mins    NY  \n",
       "1               28 mins    NJ  \n",
       "2               37 mins    NY  \n",
       "3        1 hour 51 mins    PA  \n",
       "4       3 hours 47 mins    MA  \n",
       "5               56 mins    NY  \n",
       "6       3 hours 53 mins    DC  \n",
       "7       3 hours 14 mins    MD  \n",
       "8         4 hours 1 min    DC  \n",
       "9        2 hours 9 mins    CT  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Calculate costs to each of these airports"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "# dictionary to get full name of state from abbreviation\n",
    "states = {\n",
    "        'AK': 'Alaska',\n",
    "        'AL': 'Alabama',\n",
    "        'AR': 'Arkansas',\n",
    "        'AS': 'American Samoa',\n",
    "        'AZ': 'Arizona',\n",
    "        'CA': 'California',\n",
    "        'CO': 'Colorado',\n",
    "        'CT': 'Connecticut',\n",
    "        'DC': 'District of Columbia',\n",
    "        'DE': 'Delaware',\n",
    "        'FL': 'Florida',\n",
    "        'GA': 'Georgia',\n",
    "        'GU': 'Guam',\n",
    "        'HI': 'Hawaii',\n",
    "        'IA': 'Iowa',\n",
    "        'ID': 'Idaho',\n",
    "        'IL': 'Illinois',\n",
    "        'IN': 'Indiana',\n",
    "        'KS': 'Kansas',\n",
    "        'KY': 'Kentucky',\n",
    "        'LA': 'Louisiana',\n",
    "        'MA': 'Massachusetts',\n",
    "        'MD': 'Maryland',\n",
    "        'ME': 'Maine',\n",
    "        'MI': 'Michigan',\n",
    "        'MN': 'Minnesota',\n",
    "        'MO': 'Missouri',\n",
    "        'MP': 'Northern Mariana Islands',\n",
    "        'MS': 'Mississippi',\n",
    "        'MT': 'Montana',\n",
    "        'NA': 'National',\n",
    "        'NC': 'North Carolina',\n",
    "        'ND': 'North Dakota',\n",
    "        'NE': 'Nebraska',\n",
    "        'NH': 'New Hampshire',\n",
    "        'NJ': 'New Jersey',\n",
    "        'NM': 'New Mexico',\n",
    "        'NV': 'Nevada',\n",
    "        'NY': 'New York',\n",
    "        'OH': 'Ohio',\n",
    "        'OK': 'Oklahoma',\n",
    "        'OR': 'Oregon',\n",
    "        'PA': 'Pennsylvania',\n",
    "        'PR': 'Puerto Rico',\n",
    "        'RI': 'Rhode Island',\n",
    "        'SC': 'South Carolina',\n",
    "        'SD': 'South Dakota',\n",
    "        'TN': 'Tennessee',\n",
    "        'TX': 'Texas',\n",
    "        'UT': 'Utah',\n",
    "        'VA': 'Virginia',\n",
    "        'VI': 'Virgin Islands',\n",
    "        'VT': 'Vermont',\n",
    "        'WA': 'Washington',\n",
    "        'WI': 'Wisconsin',\n",
    "        'WV': 'West Virginia',\n",
    "        'WY': 'Wyoming'\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "gas_prices = pd.read_csv('gasprices.csv', index_col=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>State</th>\n",
       "      <th>Regular Price</th>\n",
       "      <th>Mid-Grade Price</th>\n",
       "      <th>Premium Price</th>\n",
       "      <th>Diesel Price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>2.216</td>\n",
       "      <td>2.426</td>\n",
       "      <td>2.532</td>\n",
       "      <td>2.534</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>1.647</td>\n",
       "      <td>2.019</td>\n",
       "      <td>2.348</td>\n",
       "      <td>2.383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>1.535</td>\n",
       "      <td>1.880</td>\n",
       "      <td>2.166</td>\n",
       "      <td>2.250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>2.285</td>\n",
       "      <td>2.593</td>\n",
       "      <td>2.808</td>\n",
       "      <td>2.659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>California</td>\n",
       "      <td>2.879</td>\n",
       "      <td>3.071</td>\n",
       "      <td>3.186</td>\n",
       "      <td>3.429</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        State  Regular Price  Mid-Grade Price  Premium Price  Diesel Price\n",
       "0      Alaska          2.216            2.426          2.532         2.534\n",
       "1     Alabama          1.647            2.019          2.348         2.383\n",
       "2    Arkansas          1.535            1.880          2.166         2.250\n",
       "3     Arizona          2.285            2.593          2.808         2.659\n",
       "4  California          2.879            3.071          3.186         3.429"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gas_prices.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "def calc_gas_price(state, city_mpg, highway_mpg, fuel_type, trip_length):\n",
    "    cost_per_gallon = float(gas_prices[gas_prices['State'] == state][fuel_type])\n",
    "    avg_mpg = 0.5*(city_mpg + highway_mpg)\n",
    "    price = (trip_length/avg_mpg)*cost_per_gallon\n",
    "    return price  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "#test function for 2019 Toyota Prius using example from Travel4All notebook\n",
    "city_mpg = 48\n",
    "highway_mpg = 43\n",
    "gas_type = 'Regular Price'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "costs = []\n",
    "for idx, row in df.iterrows():\n",
    "    state = row['state']\n",
    "    \n",
    "    #get rid of 'mi' and all commas\n",
    "    trip_length = float(row['dist from origin'][:-3].replace(',',''))\n",
    "    cost = calc_gas_price(states[state], city_mpg, highway_mpg, gas_type, trip_length)\n",
    "    costs.append(cost)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "costs1 = []\n",
    "for idx, row in df1.iterrows():\n",
    "    state = row['state']\n",
    "    \n",
    "    #get rid of 'mi' and all commas\n",
    "    trip_length1 = float(row['dist from destination'][:-3].replace(',',''))\n",
    "    cost1 = calc_gas_price(states[state], city_mpg, highway_mpg, gas_type, trip_length1)\n",
    "    costs1.append(cost1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>iata code</th>\n",
       "      <th>dist from origin</th>\n",
       "      <th>time from origin</th>\n",
       "      <th>state</th>\n",
       "      <th>cost</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SAN FRANCISCO INTL</td>\n",
       "      <td>37.61882</td>\n",
       "      <td>-122.3758</td>\n",
       "      <td>SFO</td>\n",
       "      <td>25.6 mi</td>\n",
       "      <td>38 mins</td>\n",
       "      <td>CA</td>\n",
       "      <td>1.619833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>OAKLAND INTL</td>\n",
       "      <td>37.72104</td>\n",
       "      <td>-122.2216</td>\n",
       "      <td>OAK</td>\n",
       "      <td>15.4 mi</td>\n",
       "      <td>28 mins</td>\n",
       "      <td>CA</td>\n",
       "      <td>0.974431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SAN JOSE MNPL</td>\n",
       "      <td>37.36189</td>\n",
       "      <td>-121.9289</td>\n",
       "      <td>SJC</td>\n",
       "      <td>46.6 mi</td>\n",
       "      <td>58 mins</td>\n",
       "      <td>CA</td>\n",
       "      <td>2.948602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EXECUTIVE</td>\n",
       "      <td>38.51323</td>\n",
       "      <td>-121.4975</td>\n",
       "      <td>SAC</td>\n",
       "      <td>81.0 mi</td>\n",
       "      <td>1 hour 26 mins</td>\n",
       "      <td>CA</td>\n",
       "      <td>5.125253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>INTERNATIONAL</td>\n",
       "      <td>38.69518</td>\n",
       "      <td>-121.5916</td>\n",
       "      <td>SMF</td>\n",
       "      <td>82.1 mi</td>\n",
       "      <td>1 hour 28 mins</td>\n",
       "      <td>CA</td>\n",
       "      <td>5.194855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BUCHANAN FLD</td>\n",
       "      <td>37.98937</td>\n",
       "      <td>-122.0580</td>\n",
       "      <td>CCR</td>\n",
       "      <td>22.5 mi</td>\n",
       "      <td>37 mins</td>\n",
       "      <td>CA</td>\n",
       "      <td>1.423681</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>TAHOE INTL</td>\n",
       "      <td>39.50597</td>\n",
       "      <td>-119.7731</td>\n",
       "      <td>RNO</td>\n",
       "      <td>212 mi</td>\n",
       "      <td>3 hours 29 mins</td>\n",
       "      <td>NV</td>\n",
       "      <td>11.457319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CHARLES M SCHULZ</td>\n",
       "      <td>38.50880</td>\n",
       "      <td>-122.8139</td>\n",
       "      <td>STS</td>\n",
       "      <td>64.1 mi</td>\n",
       "      <td>1 hour 12 mins</td>\n",
       "      <td>CA</td>\n",
       "      <td>4.055910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>FRESNO YOSEMITE INTL</td>\n",
       "      <td>36.77606</td>\n",
       "      <td>-119.7190</td>\n",
       "      <td>FAT</td>\n",
       "      <td>186 mi</td>\n",
       "      <td>3 hours 5 mins</td>\n",
       "      <td>CA</td>\n",
       "      <td>11.769099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>MONTEREY REGIONAL</td>\n",
       "      <td>36.58790</td>\n",
       "      <td>-121.8394</td>\n",
       "      <td>MRY</td>\n",
       "      <td>117 mi</td>\n",
       "      <td>2 hours 4 mins</td>\n",
       "      <td>CA</td>\n",
       "      <td>7.403143</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                address  latitude  longitude iata code dist from origin  \\\n",
       "0    SAN FRANCISCO INTL  37.61882  -122.3758       SFO          25.6 mi   \n",
       "1          OAKLAND INTL  37.72104  -122.2216       OAK          15.4 mi   \n",
       "2         SAN JOSE MNPL  37.36189  -121.9289       SJC          46.6 mi   \n",
       "3             EXECUTIVE  38.51323  -121.4975       SAC          81.0 mi   \n",
       "4         INTERNATIONAL  38.69518  -121.5916       SMF          82.1 mi   \n",
       "5          BUCHANAN FLD  37.98937  -122.0580       CCR          22.5 mi   \n",
       "6            TAHOE INTL  39.50597  -119.7731       RNO           212 mi   \n",
       "7      CHARLES M SCHULZ  38.50880  -122.8139       STS          64.1 mi   \n",
       "8  FRESNO YOSEMITE INTL  36.77606  -119.7190       FAT           186 mi   \n",
       "9     MONTEREY REGIONAL  36.58790  -121.8394       MRY           117 mi   \n",
       "\n",
       "  time from origin state       cost  \n",
       "0          38 mins    CA   1.619833  \n",
       "1          28 mins    CA   0.974431  \n",
       "2          58 mins    CA   2.948602  \n",
       "3   1 hour 26 mins    CA   5.125253  \n",
       "4   1 hour 28 mins    CA   5.194855  \n",
       "5          37 mins    CA   1.423681  \n",
       "6  3 hours 29 mins    NV  11.457319  \n",
       "7   1 hour 12 mins    CA   4.055910  \n",
       "8   3 hours 5 mins    CA  11.769099  \n",
       "9   2 hours 4 mins    CA   7.403143  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['cost'] = costs\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>iata code</th>\n",
       "      <th>dist from destination</th>\n",
       "      <th>time from destination</th>\n",
       "      <th>state</th>\n",
       "      <th>cost</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LAGUARDIA</td>\n",
       "      <td>40.77607</td>\n",
       "      <td>-73.87269</td>\n",
       "      <td>LGA</td>\n",
       "      <td>10.3 mi</td>\n",
       "      <td>25 mins</td>\n",
       "      <td>NY</td>\n",
       "      <td>0.510020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NEWARK LIBERTY INTL</td>\n",
       "      <td>40.69709</td>\n",
       "      <td>-74.17557</td>\n",
       "      <td>EWR</td>\n",
       "      <td>13.7 mi</td>\n",
       "      <td>28 mins</td>\n",
       "      <td>NJ</td>\n",
       "      <td>0.630802</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>JOHN F KENNEDY INTL</td>\n",
       "      <td>40.63983</td>\n",
       "      <td>-73.77874</td>\n",
       "      <td>JFK</td>\n",
       "      <td>18.6 mi</td>\n",
       "      <td>37 mins</td>\n",
       "      <td>NY</td>\n",
       "      <td>0.921007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PHILADELPHIA INTL</td>\n",
       "      <td>39.87835</td>\n",
       "      <td>-75.24018</td>\n",
       "      <td>PHL</td>\n",
       "      <td>104 mi</td>\n",
       "      <td>1 hour 51 mins</td>\n",
       "      <td>PA</td>\n",
       "      <td>4.843429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EDWARD L LOGAN INTL</td>\n",
       "      <td>42.36514</td>\n",
       "      <td>-71.01777</td>\n",
       "      <td>BOS</td>\n",
       "      <td>217 mi</td>\n",
       "      <td>3 hours 47 mins</td>\n",
       "      <td>MA</td>\n",
       "      <td>9.543231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>WESTCHESTER COUNTY</td>\n",
       "      <td>41.06694</td>\n",
       "      <td>-73.70750</td>\n",
       "      <td>HPN</td>\n",
       "      <td>35.1 mi</td>\n",
       "      <td>56 mins</td>\n",
       "      <td>NY</td>\n",
       "      <td>1.738029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>R REAGAN NAT</td>\n",
       "      <td>38.85233</td>\n",
       "      <td>-77.03720</td>\n",
       "      <td>DCA</td>\n",
       "      <td>233 mi</td>\n",
       "      <td>3 hours 53 mins</td>\n",
       "      <td>DC</td>\n",
       "      <td>11.061099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BALTIMORE/WASH. INTL</td>\n",
       "      <td>39.17528</td>\n",
       "      <td>-76.66833</td>\n",
       "      <td>BWI</td>\n",
       "      <td>199 mi</td>\n",
       "      <td>3 hours 14 mins</td>\n",
       "      <td>MD</td>\n",
       "      <td>8.559187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DULLES INTL</td>\n",
       "      <td>38.94877</td>\n",
       "      <td>-77.44910</td>\n",
       "      <td>IAD</td>\n",
       "      <td>249 mi</td>\n",
       "      <td>4 hours 1 min</td>\n",
       "      <td>DC</td>\n",
       "      <td>11.820659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BRAINARD</td>\n",
       "      <td>41.74119</td>\n",
       "      <td>-72.64958</td>\n",
       "      <td>HFD</td>\n",
       "      <td>114 mi</td>\n",
       "      <td>2 hours 9 mins</td>\n",
       "      <td>CT</td>\n",
       "      <td>5.053582</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                address  latitude  longitude iata code dist from destination  \\\n",
       "0             LAGUARDIA  40.77607  -73.87269       LGA               10.3 mi   \n",
       "1   NEWARK LIBERTY INTL  40.69709  -74.17557       EWR               13.7 mi   \n",
       "2   JOHN F KENNEDY INTL  40.63983  -73.77874       JFK               18.6 mi   \n",
       "3     PHILADELPHIA INTL  39.87835  -75.24018       PHL                104 mi   \n",
       "4   EDWARD L LOGAN INTL  42.36514  -71.01777       BOS                217 mi   \n",
       "5    WESTCHESTER COUNTY  41.06694  -73.70750       HPN               35.1 mi   \n",
       "6          R REAGAN NAT  38.85233  -77.03720       DCA                233 mi   \n",
       "7  BALTIMORE/WASH. INTL  39.17528  -76.66833       BWI                199 mi   \n",
       "8           DULLES INTL  38.94877  -77.44910       IAD                249 mi   \n",
       "9              BRAINARD  41.74119  -72.64958       HFD                114 mi   \n",
       "\n",
       "  time from destination state       cost  \n",
       "0               25 mins    NY   0.510020  \n",
       "1               28 mins    NJ   0.630802  \n",
       "2               37 mins    NY   0.921007  \n",
       "3        1 hour 51 mins    PA   4.843429  \n",
       "4       3 hours 47 mins    MA   9.543231  \n",
       "5               56 mins    NY   1.738029  \n",
       "6       3 hours 53 mins    DC  11.061099  \n",
       "7       3 hours 14 mins    MD   8.559187  \n",
       "8         4 hours 1 min    DC  11.820659  \n",
       "9        2 hours 9 mins    CT   5.053582  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1['cost']=costs1\n",
    "df1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Calculating the full cost of routes using different combinations of airports"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "total_costs = {}\n",
    "flight_costs = {}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The cheapest flight found from  SFO  to  LGA :  155.40\n",
      "total: 157.52985274725276\n",
      "The cheapest flight found from  SFO  to  EWR :  95.40\n",
      "total: 97.65063516483517\n",
      "The cheapest flight found from  SFO  to  JFK :  130.27\n",
      "total: 132.81083956043958\n",
      "The cheapest flight found from  OAK  to  LGA :  157.40\n",
      "total: 158.88445054945055\n",
      "The cheapest flight found from  OAK  to  EWR :  161.40\n",
      "total: 163.00523296703298\n",
      "The cheapest flight found from  OAK  to  JFK :  161.40\n",
      "total: 163.29543736263736\n",
      "The cheapest flight found from  SJC  to  LGA :  153.40\n",
      "total: 156.85862197802197\n",
      "The cheapest flight found from  SJC  to  EWR :  149.40\n",
      "total: 152.9794043956044\n",
      "The cheapest flight found from  SJC  to  JFK :  127.27\n",
      "total: 131.1396087912088\n"
     ]
    }
   ],
   "source": [
    "for idx, row in df[:3].iterrows():\n",
    "    a_code = row['iata code']\n",
    "    \n",
    "    for idx, row2 in df1[:3].iterrows():\n",
    "        b_code = row2['iata code']\n",
    "        \n",
    "        try:\n",
    "            response = amadeus.shopping.flight_offers_search.get(\n",
    "                originLocationCode=a_code,\n",
    "                destinationLocationCode=b_code,\n",
    "                departureDate='2020-07-01',\n",
    "                adults=1)\n",
    "            flight_cost=response.data[0]['price']['total']\n",
    "            flight_costs[(a_code, b_code)] = flight_cost\n",
    "            \n",
    "            driving_cost = row['cost'] + row2['cost']\n",
    "            total = float(flight_cost) + float(driving_cost)\n",
    "            total_costs[(a_code, b_code)] = total\n",
    "            \n",
    "            \n",
    "            print(\"The cheapest flight found from \", a_code, ' to ', b_code, ': ', flight_cost)\n",
    "            print('total:', total)\n",
    "\n",
    "        except ResponseError as error:\n",
    "            print(error)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{('SFO', 'LGA'): 157.52985274725276,\n",
       " ('SFO', 'EWR'): 97.65063516483517,\n",
       " ('SFO', 'JFK'): 132.81083956043958,\n",
       " ('OAK', 'LGA'): 158.88445054945055,\n",
       " ('OAK', 'EWR'): 163.00523296703298,\n",
       " ('OAK', 'JFK'): 163.29543736263736,\n",
       " ('SJC', 'LGA'): 156.85862197802197,\n",
       " ('SJC', 'EWR'): 152.9794043956044,\n",
       " ('SJC', 'JFK'): 131.1396087912088}"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total_costs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{('SFO', 'LGA'): '155.40',\n",
       " ('SFO', 'EWR'): '95.40',\n",
       " ('SFO', 'JFK'): '130.27',\n",
       " ('OAK', 'LGA'): '157.40',\n",
       " ('OAK', 'EWR'): '161.40',\n",
       " ('OAK', 'JFK'): '161.40',\n",
       " ('SJC', 'LGA'): '153.40',\n",
       " ('SJC', 'EWR'): '149.40',\n",
       " ('SJC', 'JFK'): '127.27'}"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flight_costs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "('SFO', 'EWR')\n"
     ]
    }
   ],
   "source": [
    "#finding cheapest full route\n",
    "\n",
    "cheapest_a = min(total_costs, key=total_costs.get)\n",
    "origin_airport = cheapest_a[0]\n",
    "dest_airport = cheapest_a[1]\n",
    "\n",
    "print(cheapest_a)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Start at 1512 Shattuck Ave, Berkeley, CA 94709 and drive to SFO. The cost of this portion of the trip: 1.6198329670329668\n",
      "\n",
      "Take flight from SFO to EWR. The cost of this portion of the trip: 95.40\n",
      "\n",
      "Drive from EWR to New York University,New York, NY 10003. The cost of this portion of the trip: 0.6308021978021978\n",
      "\n",
      "The total cost of the trip is: 97.65063516483517\n"
     ]
    }
   ],
   "source": [
    "#Full route: origin_address -> origin_airport -> dest_airport -> dest_address\n",
    "print(\"Start at\", origin_address, \"and drive to\", origin_airport + \".\",\n",
    "     \"The cost of this portion of the trip:\", df[df['iata code']==origin_airport]['cost'].iloc[0])\n",
    "print()\n",
    "print(\"Take flight from\", origin_airport, 'to', dest_airport + \".\",\n",
    "     \"The cost of this portion of the trip:\", flight_costs[(origin_airport, dest_airport)])\n",
    "print()\n",
    "print(\"Drive from\", dest_airport, \"to\", dest_address + \".\",\n",
    "     \"The cost of this portion of the trip:\", df1[df1['iata code']==dest_airport]['cost'].iloc[0])\n",
    "print()\n",
    "print(\"The total cost of the trip is:\", total_costs[cheapest_a])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'\\nNEXT STEPS: \\n1. Is there a way to automate getting the city and highway mpg?\\n2. Adding in the cost of the rental car (1 day)\\n3. ML TIME!!!\\n\\n'"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''\n",
    "NEXT STEPS: \n",
    "1. Is there a way to automate getting the city and highway mpg?\n",
    "2. Adding in the cost of the rental car (1 day)\n",
    "3. ML TIME!!!\n",
    "\n",
    "'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}