tableau_data_mergeing..ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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>FL_DATE</th>\n",
       "      <th>OP_CARRIER</th>\n",
       "      <th>OP_CARRIER_FL_NUM</th>\n",
       "      <th>ORIGIN</th>\n",
       "      <th>DEST</th>\n",
       "      <th>CRS_DEP_TIME</th>\n",
       "      <th>DEP_TIME</th>\n",
       "      <th>CRS_ARR_TIME</th>\n",
       "      <th>ARR_TIME</th>\n",
       "      <th>ARR_DELAY</th>\n",
       "      <th>flight_status</th>\n",
       "      <th>Weekday</th>\n",
       "      <th>cancelled</th>\n",
       "      <th>Origin Airport</th>\n",
       "      <th>Destination Airport</th>\n",
       "      <th>DEST_CODE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2554</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1040</td>\n",
       "      <td>1032</td>\n",
       "      <td>1340</td>\n",
       "      <td>1320</td>\n",
       "      <td>-20</td>\n",
       "      <td>Early</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2555</td>\n",
       "      <td>PHL</td>\n",
       "      <td>MKE</td>\n",
       "      <td>1405</td>\n",
       "      <td>1355</td>\n",
       "      <td>1530</td>\n",
       "      <td>1525</td>\n",
       "      <td>-5</td>\n",
       "      <td>Early</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>MKE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2556</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1555</td>\n",
       "      <td>1554</td>\n",
       "      <td>1900</td>\n",
       "      <td>1843</td>\n",
       "      <td>-17</td>\n",
       "      <td>Early</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2582</td>\n",
       "      <td>PHL</td>\n",
       "      <td>MKE</td>\n",
       "      <td>1105</td>\n",
       "      <td>1105</td>\n",
       "      <td>1230</td>\n",
       "      <td>1224</td>\n",
       "      <td>-6</td>\n",
       "      <td>Early</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>MKE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2620</td>\n",
       "      <td>MKE</td>\n",
       "      <td>MSN</td>\n",
       "      <td>1335</td>\n",
       "      <td>1345</td>\n",
       "      <td>1412</td>\n",
       "      <td>1419</td>\n",
       "      <td>7</td>\n",
       "      <td>Delayed</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Dane County Regional Airport, Madison (MSN)</td>\n",
       "      <td>MSN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    FL_DATE OP_CARRIER  OP_CARRIER_FL_NUM ORIGIN DEST  CRS_DEP_TIME  DEP_TIME  \\\n",
       "0  1/1/2009         OO               2554    MKE  PHL          1040      1032   \n",
       "1  1/1/2009         OO               2555    PHL  MKE          1405      1355   \n",
       "2  1/1/2009         OO               2556    MKE  PHL          1555      1554   \n",
       "3  1/1/2009         OO               2582    PHL  MKE          1105      1105   \n",
       "4  1/1/2009         OO               2620    MKE  MSN          1335      1345   \n",
       "\n",
       "   CRS_ARR_TIME  ARR_TIME  ARR_DELAY flight_status   Weekday cancelled  \\\n",
       "0          1340      1320        -20         Early  Thursday        No   \n",
       "1          1530      1525         -5         Early  Thursday        No   \n",
       "2          1900      1843        -17         Early  Thursday        No   \n",
       "3          1230      1224         -6         Early  Thursday        No   \n",
       "4          1412      1419          7       Delayed  Thursday        No   \n",
       "\n",
       "                                      Origin Airport  \\\n",
       "0  General Mitchell International Airport, Milwau...   \n",
       "1           Philadelphia International Airport (PHL)   \n",
       "2  General Mitchell International Airport, Milwau...   \n",
       "3           Philadelphia International Airport (PHL)   \n",
       "4  General Mitchell International Airport, Milwau...   \n",
       "\n",
       "                                 Destination Airport DEST_CODE  \n",
       "0           Philadelphia International Airport (PHL)       PHL  \n",
       "1  General Mitchell International Airport, Milwau...       MKE  \n",
       "2           Philadelphia International Airport (PHL)       PHL  \n",
       "3  General Mitchell International Airport, Milwau...       MKE  \n",
       "4        Dane County Regional Airport, Madison (MSN)       MSN  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_csv('SS_cleaned.csv')\n",
    "data.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>DEST_CODE</th>\n",
       "      <th>dest_longitude</th>\n",
       "      <th>dest_latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>UTK</td>\n",
       "      <td>169.852005</td>\n",
       "      <td>11.222000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>OCA</td>\n",
       "      <td>-80.274803</td>\n",
       "      <td>25.325399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PQS</td>\n",
       "      <td>-162.899994</td>\n",
       "      <td>61.934601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CSE</td>\n",
       "      <td>-106.928341</td>\n",
       "      <td>38.851918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>JCY</td>\n",
       "      <td>-98.622498</td>\n",
       "      <td>30.251801</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  DEST_CODE  dest_longitude  dest_latitude\n",
       "0       UTK      169.852005      11.222000\n",
       "1       OCA      -80.274803      25.325399\n",
       "2       PQS     -162.899994      61.934601\n",
       "3       CSE     -106.928341      38.851918\n",
       "4       JCY      -98.622498      30.251801"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dest_codes = pd.read_csv('cleaned_airport_codes.csv')\n",
    "dest_codes.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "FL_DATE                object\n",
       "OP_CARRIER             object\n",
       "OP_CARRIER_FL_NUM       int64\n",
       "ORIGIN                 object\n",
       "DEST                   object\n",
       "CRS_DEP_TIME            int64\n",
       "DEP_TIME                int64\n",
       "CRS_ARR_TIME            int64\n",
       "ARR_TIME                int64\n",
       "ARR_DELAY               int64\n",
       "flight_status          object\n",
       "Weekday                object\n",
       "cancelled              object\n",
       "Origin Airport         object\n",
       "Destination Airport    object\n",
       "DEST_CODE              object\n",
       "dtype: object"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DEST_CODE          object\n",
       "dest_longitude    float64\n",
       "dest_latitude     float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dest_codes.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>FL_DATE</th>\n",
       "      <th>OP_CARRIER</th>\n",
       "      <th>OP_CARRIER_FL_NUM</th>\n",
       "      <th>ORIGIN</th>\n",
       "      <th>DEST</th>\n",
       "      <th>CRS_DEP_TIME</th>\n",
       "      <th>DEP_TIME</th>\n",
       "      <th>CRS_ARR_TIME</th>\n",
       "      <th>ARR_TIME</th>\n",
       "      <th>ARR_DELAY</th>\n",
       "      <th>flight_status</th>\n",
       "      <th>Weekday</th>\n",
       "      <th>cancelled</th>\n",
       "      <th>Origin Airport</th>\n",
       "      <th>Destination Airport</th>\n",
       "      <th>DEST_CODE</th>\n",
       "      <th>dest_longitude</th>\n",
       "      <th>dest_latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2554</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1040</td>\n",
       "      <td>1032</td>\n",
       "      <td>1340</td>\n",
       "      <td>1320</td>\n",
       "      <td>-20</td>\n",
       "      <td>Early</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2556</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1555</td>\n",
       "      <td>1554</td>\n",
       "      <td>1900</td>\n",
       "      <td>1843</td>\n",
       "      <td>-17</td>\n",
       "      <td>Early</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2550</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>730</td>\n",
       "      <td>744</td>\n",
       "      <td>1035</td>\n",
       "      <td>1035</td>\n",
       "      <td>0</td>\n",
       "      <td>On Time</td>\n",
       "      <td>Friday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2554</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1040</td>\n",
       "      <td>1041</td>\n",
       "      <td>1340</td>\n",
       "      <td>1401</td>\n",
       "      <td>21</td>\n",
       "      <td>Delayed</td>\n",
       "      <td>Friday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2556</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1555</td>\n",
       "      <td>1555</td>\n",
       "      <td>1900</td>\n",
       "      <td>1847</td>\n",
       "      <td>-13</td>\n",
       "      <td>Early</td>\n",
       "      <td>Friday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    FL_DATE OP_CARRIER  OP_CARRIER_FL_NUM ORIGIN DEST  CRS_DEP_TIME  DEP_TIME  \\\n",
       "0  1/1/2009         OO               2554    MKE  PHL          1040      1032   \n",
       "1  1/1/2009         OO               2556    MKE  PHL          1555      1554   \n",
       "2  2/1/2009         OO               2550    MKE  PHL           730       744   \n",
       "3  2/1/2009         OO               2554    MKE  PHL          1040      1041   \n",
       "4  2/1/2009         OO               2556    MKE  PHL          1555      1555   \n",
       "\n",
       "   CRS_ARR_TIME  ARR_TIME  ARR_DELAY flight_status   Weekday cancelled  \\\n",
       "0          1340      1320        -20         Early  Thursday        No   \n",
       "1          1900      1843        -17         Early  Thursday        No   \n",
       "2          1035      1035          0       On Time    Friday        No   \n",
       "3          1340      1401         21       Delayed    Friday        No   \n",
       "4          1900      1847        -13         Early    Friday        No   \n",
       "\n",
       "                                      Origin Airport  \\\n",
       "0  General Mitchell International Airport, Milwau...   \n",
       "1  General Mitchell International Airport, Milwau...   \n",
       "2  General Mitchell International Airport, Milwau...   \n",
       "3  General Mitchell International Airport, Milwau...   \n",
       "4  General Mitchell International Airport, Milwau...   \n",
       "\n",
       "                        Destination Airport DEST_CODE  dest_longitude  \\\n",
       "0  Philadelphia International Airport (PHL)       PHL      -75.241096   \n",
       "1  Philadelphia International Airport (PHL)       PHL      -75.241096   \n",
       "2  Philadelphia International Airport (PHL)       PHL      -75.241096   \n",
       "3  Philadelphia International Airport (PHL)       PHL      -75.241096   \n",
       "4  Philadelphia International Airport (PHL)       PHL      -75.241096   \n",
       "\n",
       "   dest_latitude  \n",
       "0      39.871899  \n",
       "1      39.871899  \n",
       "2      39.871899  \n",
       "3      39.871899  \n",
       "4      39.871899  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Combine the data into a single dataset.\n",
    "oo_complete = pd.merge(data, dest_codes, on=[\"DEST_CODE\", \"DEST_CODE\"])\n",
    "oo_complete.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "oo_complete.to_csv('dest_update.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>Unnamed: 0</th>\n",
       "      <th>FL_DATE</th>\n",
       "      <th>OP_CARRIER</th>\n",
       "      <th>OP_CARRIER_FL_NUM</th>\n",
       "      <th>ORIGIN_CODE</th>\n",
       "      <th>DEST</th>\n",
       "      <th>CRS_DEP_TIME</th>\n",
       "      <th>DEP_TIME</th>\n",
       "      <th>CRS_ARR_TIME</th>\n",
       "      <th>ARR_TIME</th>\n",
       "      <th>...</th>\n",
       "      <th>flight_status</th>\n",
       "      <th>Weekday</th>\n",
       "      <th>cancelled</th>\n",
       "      <th>Origin Airport</th>\n",
       "      <th>Destination Airport</th>\n",
       "      <th>DEST_CODE</th>\n",
       "      <th>dest_longitude</th>\n",
       "      <th>dest_latitude</th>\n",
       "      <th>Unnamed: 19</th>\n",
       "      <th>ORIGIN_CODE.1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2554</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1040</td>\n",
       "      <td>1032</td>\n",
       "      <td>1340</td>\n",
       "      <td>1320</td>\n",
       "      <td>...</td>\n",
       "      <td>Early</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>MKE</td>\n",
       "      <td>-87.896599</td>\n",
       "      <td>42.947201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2556</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1555</td>\n",
       "      <td>1554</td>\n",
       "      <td>1900</td>\n",
       "      <td>1843</td>\n",
       "      <td>...</td>\n",
       "      <td>Early</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>MKE</td>\n",
       "      <td>-87.896599</td>\n",
       "      <td>42.947201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2620</td>\n",
       "      <td>MKE</td>\n",
       "      <td>MSN</td>\n",
       "      <td>1335</td>\n",
       "      <td>1345</td>\n",
       "      <td>1412</td>\n",
       "      <td>1419</td>\n",
       "      <td>...</td>\n",
       "      <td>Delayed</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Dane County Regional Airport, Madison (MSN)</td>\n",
       "      <td>MKE</td>\n",
       "      <td>-87.896599</td>\n",
       "      <td>42.947201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2625</td>\n",
       "      <td>MKE</td>\n",
       "      <td>MSN</td>\n",
       "      <td>1605</td>\n",
       "      <td>1600</td>\n",
       "      <td>1643</td>\n",
       "      <td>1643</td>\n",
       "      <td>...</td>\n",
       "      <td>On Time</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Dane County Regional Airport, Madison (MSN)</td>\n",
       "      <td>MKE</td>\n",
       "      <td>-87.896599</td>\n",
       "      <td>42.947201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2638</td>\n",
       "      <td>MKE</td>\n",
       "      <td>GRR</td>\n",
       "      <td>1333</td>\n",
       "      <td>1332</td>\n",
       "      <td>1515</td>\n",
       "      <td>1515</td>\n",
       "      <td>...</td>\n",
       "      <td>On Time</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Gerald R. Ford International Airport, Grand Ra...</td>\n",
       "      <td>MKE</td>\n",
       "      <td>-87.896599</td>\n",
       "      <td>42.947201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0   FL_DATE OP_CARRIER  OP_CARRIER_FL_NUM ORIGIN_CODE DEST  \\\n",
       "0           0  1/1/2009         OO               2554         MKE  PHL   \n",
       "1           1  1/1/2009         OO               2556         MKE  PHL   \n",
       "2           2  1/1/2009         OO               2620         MKE  MSN   \n",
       "3           3  1/1/2009         OO               2625         MKE  MSN   \n",
       "4           4  1/1/2009         OO               2638         MKE  GRR   \n",
       "\n",
       "   CRS_DEP_TIME  DEP_TIME  CRS_ARR_TIME  ARR_TIME  ...  flight_status  \\\n",
       "0          1040      1032          1340      1320  ...          Early   \n",
       "1          1555      1554          1900      1843  ...          Early   \n",
       "2          1335      1345          1412      1419  ...        Delayed   \n",
       "3          1605      1600          1643      1643  ...        On Time   \n",
       "4          1333      1332          1515      1515  ...        On Time   \n",
       "\n",
       "    Weekday cancelled                                     Origin Airport  \\\n",
       "0  Thursday        No  General Mitchell International Airport, Milwau...   \n",
       "1  Thursday        No  General Mitchell International Airport, Milwau...   \n",
       "2  Thursday        No  General Mitchell International Airport, Milwau...   \n",
       "3  Thursday        No  General Mitchell International Airport, Milwau...   \n",
       "4  Thursday        No  General Mitchell International Airport, Milwau...   \n",
       "\n",
       "                                 Destination Airport DEST_CODE dest_longitude  \\\n",
       "0           Philadelphia International Airport (PHL)       MKE     -87.896599   \n",
       "1           Philadelphia International Airport (PHL)       MKE     -87.896599   \n",
       "2        Dane County Regional Airport, Madison (MSN)       MKE     -87.896599   \n",
       "3        Dane County Regional Airport, Madison (MSN)       MKE     -87.896599   \n",
       "4  Gerald R. Ford International Airport, Grand Ra...       MKE     -87.896599   \n",
       "\n",
       "   dest_latitude  Unnamed: 19  ORIGIN_CODE.1  \n",
       "0      42.947201          NaN            NaN  \n",
       "1      42.947201          NaN            NaN  \n",
       "2      42.947201          NaN            NaN  \n",
       "3      42.947201          NaN            NaN  \n",
       "4      42.947201          NaN            NaN  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_two = pd.read_csv('dest_update.csv')\n",
    "data_two.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "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>Unnamed: 0</th>\n",
       "      <th>FL_DATE</th>\n",
       "      <th>OP_CARRIER</th>\n",
       "      <th>OP_CARRIER_FL_NUM</th>\n",
       "      <th>ORIGIN</th>\n",
       "      <th>DEST</th>\n",
       "      <th>CRS_DEP_TIME</th>\n",
       "      <th>DEP_TIME</th>\n",
       "      <th>CRS_ARR_TIME</th>\n",
       "      <th>ARR_TIME</th>\n",
       "      <th>ARR_DELAY</th>\n",
       "      <th>flight_status</th>\n",
       "      <th>Weekday</th>\n",
       "      <th>cancelled</th>\n",
       "      <th>Origin Airport</th>\n",
       "      <th>Destination Airport</th>\n",
       "      <th>DEST_CODE</th>\n",
       "      <th>dest_longitude</th>\n",
       "      <th>dest_latitude</th>\n",
       "      <th>ORIGIN_CODE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2554</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1040</td>\n",
       "      <td>1032</td>\n",
       "      <td>1340</td>\n",
       "      <td>1320</td>\n",
       "      <td>-20</td>\n",
       "      <td>Early</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "      <td>MKE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2556</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1555</td>\n",
       "      <td>1554</td>\n",
       "      <td>1900</td>\n",
       "      <td>1843</td>\n",
       "      <td>-17</td>\n",
       "      <td>Early</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "      <td>MKE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2550</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>730</td>\n",
       "      <td>744</td>\n",
       "      <td>1035</td>\n",
       "      <td>1035</td>\n",
       "      <td>0</td>\n",
       "      <td>On Time</td>\n",
       "      <td>Friday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "      <td>MKE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2554</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1040</td>\n",
       "      <td>1041</td>\n",
       "      <td>1340</td>\n",
       "      <td>1401</td>\n",
       "      <td>21</td>\n",
       "      <td>Delayed</td>\n",
       "      <td>Friday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "      <td>MKE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2556</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1555</td>\n",
       "      <td>1555</td>\n",
       "      <td>1900</td>\n",
       "      <td>1847</td>\n",
       "      <td>-13</td>\n",
       "      <td>Early</td>\n",
       "      <td>Friday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "      <td>MKE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0   FL_DATE OP_CARRIER  OP_CARRIER_FL_NUM ORIGIN DEST  \\\n",
       "0           0  1/1/2009         OO               2554    MKE  PHL   \n",
       "1           1  1/1/2009         OO               2556    MKE  PHL   \n",
       "2           2  2/1/2009         OO               2550    MKE  PHL   \n",
       "3           3  2/1/2009         OO               2554    MKE  PHL   \n",
       "4           4  2/1/2009         OO               2556    MKE  PHL   \n",
       "\n",
       "   CRS_DEP_TIME  DEP_TIME  CRS_ARR_TIME  ARR_TIME  ARR_DELAY flight_status  \\\n",
       "0          1040      1032          1340      1320        -20         Early   \n",
       "1          1555      1554          1900      1843        -17         Early   \n",
       "2           730       744          1035      1035          0       On Time   \n",
       "3          1040      1041          1340      1401         21       Delayed   \n",
       "4          1555      1555          1900      1847        -13         Early   \n",
       "\n",
       "    Weekday cancelled                                     Origin Airport  \\\n",
       "0  Thursday        No  General Mitchell International Airport, Milwau...   \n",
       "1  Thursday        No  General Mitchell International Airport, Milwau...   \n",
       "2    Friday        No  General Mitchell International Airport, Milwau...   \n",
       "3    Friday        No  General Mitchell International Airport, Milwau...   \n",
       "4    Friday        No  General Mitchell International Airport, Milwau...   \n",
       "\n",
       "                        Destination Airport DEST_CODE  dest_longitude  \\\n",
       "0  Philadelphia International Airport (PHL)       PHL      -75.241096   \n",
       "1  Philadelphia International Airport (PHL)       PHL      -75.241096   \n",
       "2  Philadelphia International Airport (PHL)       PHL      -75.241096   \n",
       "3  Philadelphia International Airport (PHL)       PHL      -75.241096   \n",
       "4  Philadelphia International Airport (PHL)       PHL      -75.241096   \n",
       "\n",
       "   dest_latitude ORIGIN_CODE  \n",
       "0      39.871899         MKE  \n",
       "1      39.871899         MKE  \n",
       "2      39.871899         MKE  \n",
       "3      39.871899         MKE  \n",
       "4      39.871899         MKE  "
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ori = pd.read_csv('dest_update_ii.csv')\n",
    "ori.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "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>ORIGIN_CODE</th>\n",
       "      <th>origin_longitude</th>\n",
       "      <th>origin_latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>UTK</td>\n",
       "      <td>169.852005</td>\n",
       "      <td>11.222000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>OCA</td>\n",
       "      <td>-80.274803</td>\n",
       "      <td>25.325399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PQS</td>\n",
       "      <td>-162.899994</td>\n",
       "      <td>61.934601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CSE</td>\n",
       "      <td>-106.928341</td>\n",
       "      <td>38.851918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>JCY</td>\n",
       "      <td>-98.622498</td>\n",
       "      <td>30.251801</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  ORIGIN_CODE  origin_longitude  origin_latitude\n",
       "0         UTK        169.852005        11.222000\n",
       "1         OCA        -80.274803        25.325399\n",
       "2         PQS       -162.899994        61.934601\n",
       "3         CSE       -106.928341        38.851918\n",
       "4         JCY        -98.622498        30.251801"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ori_codes = pd.read_csv('cleaned_airport_codes_ii.csv')\n",
    "ori_codes.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "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>Unnamed: 0</th>\n",
       "      <th>FL_DATE</th>\n",
       "      <th>OP_CARRIER</th>\n",
       "      <th>OP_CARRIER_FL_NUM</th>\n",
       "      <th>ORIGIN</th>\n",
       "      <th>DEST</th>\n",
       "      <th>CRS_DEP_TIME</th>\n",
       "      <th>DEP_TIME</th>\n",
       "      <th>CRS_ARR_TIME</th>\n",
       "      <th>ARR_TIME</th>\n",
       "      <th>...</th>\n",
       "      <th>Weekday</th>\n",
       "      <th>cancelled</th>\n",
       "      <th>Origin Airport</th>\n",
       "      <th>Destination Airport</th>\n",
       "      <th>DEST_CODE</th>\n",
       "      <th>dest_longitude</th>\n",
       "      <th>dest_latitude</th>\n",
       "      <th>ORIGIN_CODE</th>\n",
       "      <th>origin_longitude</th>\n",
       "      <th>origin_latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2554</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1040</td>\n",
       "      <td>1032</td>\n",
       "      <td>1340</td>\n",
       "      <td>1320</td>\n",
       "      <td>...</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "      <td>MKE</td>\n",
       "      <td>-87.896599</td>\n",
       "      <td>42.947201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2556</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1555</td>\n",
       "      <td>1554</td>\n",
       "      <td>1900</td>\n",
       "      <td>1843</td>\n",
       "      <td>...</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "      <td>MKE</td>\n",
       "      <td>-87.896599</td>\n",
       "      <td>42.947201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2550</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>730</td>\n",
       "      <td>744</td>\n",
       "      <td>1035</td>\n",
       "      <td>1035</td>\n",
       "      <td>...</td>\n",
       "      <td>Friday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "      <td>MKE</td>\n",
       "      <td>-87.896599</td>\n",
       "      <td>42.947201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2554</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1040</td>\n",
       "      <td>1041</td>\n",
       "      <td>1340</td>\n",
       "      <td>1401</td>\n",
       "      <td>...</td>\n",
       "      <td>Friday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "      <td>MKE</td>\n",
       "      <td>-87.896599</td>\n",
       "      <td>42.947201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2/1/2009</td>\n",
       "      <td>OO</td>\n",
       "      <td>2556</td>\n",
       "      <td>MKE</td>\n",
       "      <td>PHL</td>\n",
       "      <td>1555</td>\n",
       "      <td>1555</td>\n",
       "      <td>1900</td>\n",
       "      <td>1847</td>\n",
       "      <td>...</td>\n",
       "      <td>Friday</td>\n",
       "      <td>No</td>\n",
       "      <td>General Mitchell International Airport, Milwau...</td>\n",
       "      <td>Philadelphia International Airport (PHL)</td>\n",
       "      <td>PHL</td>\n",
       "      <td>-75.241096</td>\n",
       "      <td>39.871899</td>\n",
       "      <td>MKE</td>\n",
       "      <td>-87.896599</td>\n",
       "      <td>42.947201</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0   FL_DATE OP_CARRIER  OP_CARRIER_FL_NUM ORIGIN DEST  \\\n",
       "0           0  1/1/2009         OO               2554    MKE  PHL   \n",
       "1           1  1/1/2009         OO               2556    MKE  PHL   \n",
       "2           2  2/1/2009         OO               2550    MKE  PHL   \n",
       "3           3  2/1/2009         OO               2554    MKE  PHL   \n",
       "4           4  2/1/2009         OO               2556    MKE  PHL   \n",
       "\n",
       "   CRS_DEP_TIME  DEP_TIME  CRS_ARR_TIME  ARR_TIME  ...   Weekday cancelled  \\\n",
       "0          1040      1032          1340      1320  ...  Thursday        No   \n",
       "1          1555      1554          1900      1843  ...  Thursday        No   \n",
       "2           730       744          1035      1035  ...    Friday        No   \n",
       "3          1040      1041          1340      1401  ...    Friday        No   \n",
       "4          1555      1555          1900      1847  ...    Friday        No   \n",
       "\n",
       "                                      Origin Airport  \\\n",
       "0  General Mitchell International Airport, Milwau...   \n",
       "1  General Mitchell International Airport, Milwau...   \n",
       "2  General Mitchell International Airport, Milwau...   \n",
       "3  General Mitchell International Airport, Milwau...   \n",
       "4  General Mitchell International Airport, Milwau...   \n",
       "\n",
       "                        Destination Airport DEST_CODE dest_longitude  \\\n",
       "0  Philadelphia International Airport (PHL)       PHL     -75.241096   \n",
       "1  Philadelphia International Airport (PHL)       PHL     -75.241096   \n",
       "2  Philadelphia International Airport (PHL)       PHL     -75.241096   \n",
       "3  Philadelphia International Airport (PHL)       PHL     -75.241096   \n",
       "4  Philadelphia International Airport (PHL)       PHL     -75.241096   \n",
       "\n",
       "  dest_latitude  ORIGIN_CODE  origin_longitude origin_latitude  \n",
       "0     39.871899          MKE        -87.896599       42.947201  \n",
       "1     39.871899          MKE        -87.896599       42.947201  \n",
       "2     39.871899          MKE        -87.896599       42.947201  \n",
       "3     39.871899          MKE        -87.896599       42.947201  \n",
       "4     39.871899          MKE        -87.896599       42.947201  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Combine the data into a single dataset.\n",
    "merge = pd.merge(ori, ori_codes, on=[\"ORIGIN_CODE\", \"ORIGIN_CODE\"])\n",
    "merge.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "merge.to_csv('complete.csv', index=False)"
   ]
  },
  {
   "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.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}