Plane_Prediction_Project.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "f0eec539",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "fd17cd33",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"itineraries.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "c8ab8b84",
   "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>legId</th>\n",
       "      <th>searchDate</th>\n",
       "      <th>flightDate</th>\n",
       "      <th>startingAirport</th>\n",
       "      <th>destinationAirport</th>\n",
       "      <th>fareBasisCode</th>\n",
       "      <th>travelDuration</th>\n",
       "      <th>elapsedDays</th>\n",
       "      <th>isBasicEconomy</th>\n",
       "      <th>isRefundable</th>\n",
       "      <th>...</th>\n",
       "      <th>segmentsArrivalTimeEpochSeconds</th>\n",
       "      <th>segmentsArrivalTimeRaw</th>\n",
       "      <th>segmentsArrivalAirportCode</th>\n",
       "      <th>segmentsDepartureAirportCode</th>\n",
       "      <th>segmentsAirlineName</th>\n",
       "      <th>segmentsAirlineCode</th>\n",
       "      <th>segmentsEquipmentDescription</th>\n",
       "      <th>segmentsDurationInSeconds</th>\n",
       "      <th>segmentsDistance</th>\n",
       "      <th>segmentsCabinCode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9ca0e81111c683bec1012473feefd28f</td>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>LA0NX0MC</td>\n",
       "      <td>PT2H29M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>1650223560</td>\n",
       "      <td>2022-04-17T15:26:00.000-04:00</td>\n",
       "      <td>BOS</td>\n",
       "      <td>ATL</td>\n",
       "      <td>Delta</td>\n",
       "      <td>DL</td>\n",
       "      <td>Airbus A321</td>\n",
       "      <td>8940</td>\n",
       "      <td>947</td>\n",
       "      <td>coach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>98685953630e772a098941b71906592b</td>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>LA0NX0MC</td>\n",
       "      <td>PT2H30M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>1650200400</td>\n",
       "      <td>2022-04-17T09:00:00.000-04:00</td>\n",
       "      <td>BOS</td>\n",
       "      <td>ATL</td>\n",
       "      <td>Delta</td>\n",
       "      <td>DL</td>\n",
       "      <td>Airbus A321</td>\n",
       "      <td>9000</td>\n",
       "      <td>947</td>\n",
       "      <td>coach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>98d90cbc32bfbb05c2fc32897c7c1087</td>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>LA0NX0MC</td>\n",
       "      <td>PT2H30M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>1650218700</td>\n",
       "      <td>2022-04-17T14:05:00.000-04:00</td>\n",
       "      <td>BOS</td>\n",
       "      <td>ATL</td>\n",
       "      <td>Delta</td>\n",
       "      <td>DL</td>\n",
       "      <td>Boeing 757-200</td>\n",
       "      <td>9000</td>\n",
       "      <td>947</td>\n",
       "      <td>coach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>969a269d38eae583f455486fa90877b4</td>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>LA0NX0MC</td>\n",
       "      <td>PT2H32M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>1650227460</td>\n",
       "      <td>2022-04-17T16:31:00.000-04:00</td>\n",
       "      <td>BOS</td>\n",
       "      <td>ATL</td>\n",
       "      <td>Delta</td>\n",
       "      <td>DL</td>\n",
       "      <td>Airbus A321</td>\n",
       "      <td>9120</td>\n",
       "      <td>947</td>\n",
       "      <td>coach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>980370cf27c89b40d2833a1d5afc9751</td>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>LA0NX0MC</td>\n",
       "      <td>PT2H34M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>1650213180</td>\n",
       "      <td>2022-04-17T12:33:00.000-04:00</td>\n",
       "      <td>BOS</td>\n",
       "      <td>ATL</td>\n",
       "      <td>Delta</td>\n",
       "      <td>DL</td>\n",
       "      <td>Airbus A321</td>\n",
       "      <td>9240</td>\n",
       "      <td>947</td>\n",
       "      <td>coach</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              legId  searchDate  flightDate startingAirport  \\\n",
       "0  9ca0e81111c683bec1012473feefd28f  2022-04-16  2022-04-17             ATL   \n",
       "1  98685953630e772a098941b71906592b  2022-04-16  2022-04-17             ATL   \n",
       "2  98d90cbc32bfbb05c2fc32897c7c1087  2022-04-16  2022-04-17             ATL   \n",
       "3  969a269d38eae583f455486fa90877b4  2022-04-16  2022-04-17             ATL   \n",
       "4  980370cf27c89b40d2833a1d5afc9751  2022-04-16  2022-04-17             ATL   \n",
       "\n",
       "  destinationAirport fareBasisCode travelDuration  elapsedDays  \\\n",
       "0                BOS      LA0NX0MC        PT2H29M            0   \n",
       "1                BOS      LA0NX0MC        PT2H30M            0   \n",
       "2                BOS      LA0NX0MC        PT2H30M            0   \n",
       "3                BOS      LA0NX0MC        PT2H32M            0   \n",
       "4                BOS      LA0NX0MC        PT2H34M            0   \n",
       "\n",
       "   isBasicEconomy  isRefundable  ...  segmentsArrivalTimeEpochSeconds  \\\n",
       "0           False         False  ...                       1650223560   \n",
       "1           False         False  ...                       1650200400   \n",
       "2           False         False  ...                       1650218700   \n",
       "3           False         False  ...                       1650227460   \n",
       "4           False         False  ...                       1650213180   \n",
       "\n",
       "          segmentsArrivalTimeRaw  segmentsArrivalAirportCode  \\\n",
       "0  2022-04-17T15:26:00.000-04:00                         BOS   \n",
       "1  2022-04-17T09:00:00.000-04:00                         BOS   \n",
       "2  2022-04-17T14:05:00.000-04:00                         BOS   \n",
       "3  2022-04-17T16:31:00.000-04:00                         BOS   \n",
       "4  2022-04-17T12:33:00.000-04:00                         BOS   \n",
       "\n",
       "   segmentsDepartureAirportCode  segmentsAirlineName segmentsAirlineCode  \\\n",
       "0                           ATL                Delta                  DL   \n",
       "1                           ATL                Delta                  DL   \n",
       "2                           ATL                Delta                  DL   \n",
       "3                           ATL                Delta                  DL   \n",
       "4                           ATL                Delta                  DL   \n",
       "\n",
       "  segmentsEquipmentDescription segmentsDurationInSeconds segmentsDistance  \\\n",
       "0                  Airbus A321                      8940              947   \n",
       "1                  Airbus A321                      9000              947   \n",
       "2               Boeing 757-200                      9000              947   \n",
       "3                  Airbus A321                      9120              947   \n",
       "4                  Airbus A321                      9240              947   \n",
       "\n",
       "  segmentsCabinCode  \n",
       "0             coach  \n",
       "1             coach  \n",
       "2             coach  \n",
       "3             coach  \n",
       "4             coach  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "33ee0418",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['legId', 'searchDate', 'flightDate', 'startingAirport',\n",
       "       'destinationAirport', 'fareBasisCode', 'travelDuration', 'elapsedDays',\n",
       "       'isBasicEconomy', 'isRefundable', 'isNonStop', 'baseFare', 'totalFare',\n",
       "       'seatsRemaining', 'totalTravelDistance',\n",
       "       'segmentsDepartureTimeEpochSeconds', 'segmentsDepartureTimeRaw',\n",
       "       'segmentsArrivalTimeEpochSeconds', 'segmentsArrivalTimeRaw',\n",
       "       'segmentsArrivalAirportCode', 'segmentsDepartureAirportCode',\n",
       "       'segmentsAirlineName', 'segmentsAirlineCode',\n",
       "       'segmentsEquipmentDescription', 'segmentsDurationInSeconds',\n",
       "       'segmentsDistance', 'segmentsCabinCode'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1dc71d5c",
   "metadata": {},
   "source": [
    "**searchDate**: Date the record was obtained from Expedia.<br>\n",
    "**flightDate**: The date of the flight.<br>\n",
    "**startingAirport**: 3-letter code for the starting airport.<br>\n",
    "**destinationAirport**: 3-letter code for the destination airport.<br>\n",
    "**fareBasisCode**: Fare basis code.<br>\n",
    "**travelDuration**: Travel duration in hours and minutes.<br>\n",
    "**elapsedDays**: Number of elapsed days for the flight.<br>\n",
    "**isBasicEconomy**: Is basic economy?<br>\n",
    "**isRefundable**: Is the ticket refundable?<br>\n",
    "**isNonStop**: Is the flight non-stop?<br>\n",
    "**baseFare**: Price of the ticket (not including taxes).<br>\n",
    "**totalFare**: Price of the ticket, including taxes and fees.<br>\n",
    "**seatsRemaining**:Number of remaining seats.<br>\n",
    "**totalTravelDistance** : The total travel distance in miles.<br>\n",
    "**segmentsDepartureTimeRaw**: Departure time for each leg (human-legible date format).<br>\n",
    "**segmentsArrivalTimeRaw**: Arrival time for each leg (human-legible date format).<br>\n",
    "**segmentsArrivalAirportCode**: Arrival airport for each leg.<br>\n",
    "**segmentsDepartureAirportCode**: Departure airport for each leg.<br>\n",
    "**segmentsAirlineName**: Name of the airline for each leg.<br>\n",
    "**segmentsAirlineCode**: Code for the airline for each leg.<br>\n",
    "**segmentsEquipmentDescription**: Type of airplane, for each leg.<br>\n",
    "**segmentsDurationInSeconds**: Flight duration in seconds, for each leg.<br>\n",
    "**segmentsDistance**: Flight distance in miles, for each leg. <br>\n",
    "**segmentsCabinCode**: Cabin, for each leg.<br>\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "dff521f6",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.drop(columns=['legId','segmentsDepartureTimeEpochSeconds','segmentsArrivalTimeEpochSeconds'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "064ecaa8",
   "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>searchDate</th>\n",
       "      <th>flightDate</th>\n",
       "      <th>startingAirport</th>\n",
       "      <th>destinationAirport</th>\n",
       "      <th>fareBasisCode</th>\n",
       "      <th>travelDuration</th>\n",
       "      <th>elapsedDays</th>\n",
       "      <th>isBasicEconomy</th>\n",
       "      <th>isRefundable</th>\n",
       "      <th>isNonStop</th>\n",
       "      <th>...</th>\n",
       "      <th>segmentsDepartureTimeRaw</th>\n",
       "      <th>segmentsArrivalTimeRaw</th>\n",
       "      <th>segmentsArrivalAirportCode</th>\n",
       "      <th>segmentsDepartureAirportCode</th>\n",
       "      <th>segmentsAirlineName</th>\n",
       "      <th>segmentsAirlineCode</th>\n",
       "      <th>segmentsEquipmentDescription</th>\n",
       "      <th>segmentsDurationInSeconds</th>\n",
       "      <th>segmentsDistance</th>\n",
       "      <th>segmentsCabinCode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>LA0NX0MC</td>\n",
       "      <td>PT2H29M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-04-17T12:57:00.000-04:00</td>\n",
       "      <td>2022-04-17T15:26:00.000-04:00</td>\n",
       "      <td>BOS</td>\n",
       "      <td>ATL</td>\n",
       "      <td>Delta</td>\n",
       "      <td>DL</td>\n",
       "      <td>Airbus A321</td>\n",
       "      <td>8940</td>\n",
       "      <td>947</td>\n",
       "      <td>coach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>LA0NX0MC</td>\n",
       "      <td>PT2H30M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-04-17T06:30:00.000-04:00</td>\n",
       "      <td>2022-04-17T09:00:00.000-04:00</td>\n",
       "      <td>BOS</td>\n",
       "      <td>ATL</td>\n",
       "      <td>Delta</td>\n",
       "      <td>DL</td>\n",
       "      <td>Airbus A321</td>\n",
       "      <td>9000</td>\n",
       "      <td>947</td>\n",
       "      <td>coach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>LA0NX0MC</td>\n",
       "      <td>PT2H30M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-04-17T11:35:00.000-04:00</td>\n",
       "      <td>2022-04-17T14:05:00.000-04:00</td>\n",
       "      <td>BOS</td>\n",
       "      <td>ATL</td>\n",
       "      <td>Delta</td>\n",
       "      <td>DL</td>\n",
       "      <td>Boeing 757-200</td>\n",
       "      <td>9000</td>\n",
       "      <td>947</td>\n",
       "      <td>coach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>LA0NX0MC</td>\n",
       "      <td>PT2H32M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-04-17T13:59:00.000-04:00</td>\n",
       "      <td>2022-04-17T16:31:00.000-04:00</td>\n",
       "      <td>BOS</td>\n",
       "      <td>ATL</td>\n",
       "      <td>Delta</td>\n",
       "      <td>DL</td>\n",
       "      <td>Airbus A321</td>\n",
       "      <td>9120</td>\n",
       "      <td>947</td>\n",
       "      <td>coach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>LA0NX0MC</td>\n",
       "      <td>PT2H34M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-04-17T09:59:00.000-04:00</td>\n",
       "      <td>2022-04-17T12:33:00.000-04:00</td>\n",
       "      <td>BOS</td>\n",
       "      <td>ATL</td>\n",
       "      <td>Delta</td>\n",
       "      <td>DL</td>\n",
       "      <td>Airbus A321</td>\n",
       "      <td>9240</td>\n",
       "      <td>947</td>\n",
       "      <td>coach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>VH0AUEL1</td>\n",
       "      <td>PT2H38M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-04-17T10:45:00.000-04:00</td>\n",
       "      <td>2022-04-17T13:23:00.000-04:00</td>\n",
       "      <td>BOS</td>\n",
       "      <td>ATL</td>\n",
       "      <td>JetBlue Airways</td>\n",
       "      <td>B6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9480</td>\n",
       "      <td>947</td>\n",
       "      <td>coach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>V0AJZNN1</td>\n",
       "      <td>PT4H12M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-04-17T08:20:00.000-04:00||2022-04-17T10:2...</td>\n",
       "      <td>2022-04-17T09:50:00.000-04:00||2022-04-17T12:3...</td>\n",
       "      <td>CLT||BOS</td>\n",
       "      <td>ATL||CLT</td>\n",
       "      <td>American Airlines||American Airlines</td>\n",
       "      <td>AA||AA</td>\n",
       "      <td>Airbus A320||Airbus A320</td>\n",
       "      <td>5400||7500</td>\n",
       "      <td>228||728</td>\n",
       "      <td>coach||coach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>V0AJZNN1</td>\n",
       "      <td>PT5H18M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-04-17T08:20:00.000-04:00||2022-04-17T11:2...</td>\n",
       "      <td>2022-04-17T09:50:00.000-04:00||2022-04-17T13:3...</td>\n",
       "      <td>CLT||BOS</td>\n",
       "      <td>ATL||CLT</td>\n",
       "      <td>American Airlines||American Airlines</td>\n",
       "      <td>AA||AA</td>\n",
       "      <td>Airbus A320||Boeing 737-800</td>\n",
       "      <td>5400||8280</td>\n",
       "      <td>228||728</td>\n",
       "      <td>coach||coach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>V0AJZNN1</td>\n",
       "      <td>PT5H32M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-04-17T07:00:00.000-04:00||2022-04-17T10:2...</td>\n",
       "      <td>2022-04-17T08:21:00.000-04:00||2022-04-17T12:3...</td>\n",
       "      <td>CLT||BOS</td>\n",
       "      <td>ATL||CLT</td>\n",
       "      <td>American Airlines||American Airlines</td>\n",
       "      <td>AA||AA</td>\n",
       "      <td>Airbus A319||Airbus A320</td>\n",
       "      <td>4860||7500</td>\n",
       "      <td>228||728</td>\n",
       "      <td>coach||coach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2022-04-16</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>ATL</td>\n",
       "      <td>BOS</td>\n",
       "      <td>V0AJZNN1</td>\n",
       "      <td>PT6H38M</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-04-17T07:00:00.000-04:00||2022-04-17T11:2...</td>\n",
       "      <td>2022-04-17T08:21:00.000-04:00||2022-04-17T13:3...</td>\n",
       "      <td>CLT||BOS</td>\n",
       "      <td>ATL||CLT</td>\n",
       "      <td>American Airlines||American Airlines</td>\n",
       "      <td>AA||AA</td>\n",
       "      <td>Airbus A319||Boeing 737-800</td>\n",
       "      <td>4860||8280</td>\n",
       "      <td>228||728</td>\n",
       "      <td>coach||coach</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   searchDate  flightDate startingAirport destinationAirport fareBasisCode  \\\n",
       "0  2022-04-16  2022-04-17             ATL                BOS      LA0NX0MC   \n",
       "1  2022-04-16  2022-04-17             ATL                BOS      LA0NX0MC   \n",
       "2  2022-04-16  2022-04-17             ATL                BOS      LA0NX0MC   \n",
       "3  2022-04-16  2022-04-17             ATL                BOS      LA0NX0MC   \n",
       "4  2022-04-16  2022-04-17             ATL                BOS      LA0NX0MC   \n",
       "5  2022-04-16  2022-04-17             ATL                BOS      VH0AUEL1   \n",
       "6  2022-04-16  2022-04-17             ATL                BOS      V0AJZNN1   \n",
       "7  2022-04-16  2022-04-17             ATL                BOS      V0AJZNN1   \n",
       "8  2022-04-16  2022-04-17             ATL                BOS      V0AJZNN1   \n",
       "9  2022-04-16  2022-04-17             ATL                BOS      V0AJZNN1   \n",
       "\n",
       "  travelDuration  elapsedDays  isBasicEconomy  isRefundable  isNonStop  ...  \\\n",
       "0        PT2H29M            0           False         False       True  ...   \n",
       "1        PT2H30M            0           False         False       True  ...   \n",
       "2        PT2H30M            0           False         False       True  ...   \n",
       "3        PT2H32M            0           False         False       True  ...   \n",
       "4        PT2H34M            0           False         False       True  ...   \n",
       "5        PT2H38M            0           False         False       True  ...   \n",
       "6        PT4H12M            0           False         False      False  ...   \n",
       "7        PT5H18M            0           False         False      False  ...   \n",
       "8        PT5H32M            0           False         False      False  ...   \n",
       "9        PT6H38M            0           False         False      False  ...   \n",
       "\n",
       "                            segmentsDepartureTimeRaw  \\\n",
       "0                      2022-04-17T12:57:00.000-04:00   \n",
       "1                      2022-04-17T06:30:00.000-04:00   \n",
       "2                      2022-04-17T11:35:00.000-04:00   \n",
       "3                      2022-04-17T13:59:00.000-04:00   \n",
       "4                      2022-04-17T09:59:00.000-04:00   \n",
       "5                      2022-04-17T10:45:00.000-04:00   \n",
       "6  2022-04-17T08:20:00.000-04:00||2022-04-17T10:2...   \n",
       "7  2022-04-17T08:20:00.000-04:00||2022-04-17T11:2...   \n",
       "8  2022-04-17T07:00:00.000-04:00||2022-04-17T10:2...   \n",
       "9  2022-04-17T07:00:00.000-04:00||2022-04-17T11:2...   \n",
       "\n",
       "                              segmentsArrivalTimeRaw  \\\n",
       "0                      2022-04-17T15:26:00.000-04:00   \n",
       "1                      2022-04-17T09:00:00.000-04:00   \n",
       "2                      2022-04-17T14:05:00.000-04:00   \n",
       "3                      2022-04-17T16:31:00.000-04:00   \n",
       "4                      2022-04-17T12:33:00.000-04:00   \n",
       "5                      2022-04-17T13:23:00.000-04:00   \n",
       "6  2022-04-17T09:50:00.000-04:00||2022-04-17T12:3...   \n",
       "7  2022-04-17T09:50:00.000-04:00||2022-04-17T13:3...   \n",
       "8  2022-04-17T08:21:00.000-04:00||2022-04-17T12:3...   \n",
       "9  2022-04-17T08:21:00.000-04:00||2022-04-17T13:3...   \n",
       "\n",
       "   segmentsArrivalAirportCode  segmentsDepartureAirportCode  \\\n",
       "0                         BOS                           ATL   \n",
       "1                         BOS                           ATL   \n",
       "2                         BOS                           ATL   \n",
       "3                         BOS                           ATL   \n",
       "4                         BOS                           ATL   \n",
       "5                         BOS                           ATL   \n",
       "6                    CLT||BOS                      ATL||CLT   \n",
       "7                    CLT||BOS                      ATL||CLT   \n",
       "8                    CLT||BOS                      ATL||CLT   \n",
       "9                    CLT||BOS                      ATL||CLT   \n",
       "\n",
       "                    segmentsAirlineName segmentsAirlineCode  \\\n",
       "0                                 Delta                  DL   \n",
       "1                                 Delta                  DL   \n",
       "2                                 Delta                  DL   \n",
       "3                                 Delta                  DL   \n",
       "4                                 Delta                  DL   \n",
       "5                       JetBlue Airways                  B6   \n",
       "6  American Airlines||American Airlines              AA||AA   \n",
       "7  American Airlines||American Airlines              AA||AA   \n",
       "8  American Airlines||American Airlines              AA||AA   \n",
       "9  American Airlines||American Airlines              AA||AA   \n",
       "\n",
       "  segmentsEquipmentDescription segmentsDurationInSeconds segmentsDistance  \\\n",
       "0                  Airbus A321                      8940              947   \n",
       "1                  Airbus A321                      9000              947   \n",
       "2               Boeing 757-200                      9000              947   \n",
       "3                  Airbus A321                      9120              947   \n",
       "4                  Airbus A321                      9240              947   \n",
       "5                          NaN                      9480              947   \n",
       "6     Airbus A320||Airbus A320                5400||7500         228||728   \n",
       "7  Airbus A320||Boeing 737-800                5400||8280         228||728   \n",
       "8     Airbus A319||Airbus A320                4860||7500         228||728   \n",
       "9  Airbus A319||Boeing 737-800                4860||8280         228||728   \n",
       "\n",
       "  segmentsCabinCode  \n",
       "0             coach  \n",
       "1             coach  \n",
       "2             coach  \n",
       "3             coach  \n",
       "4             coach  \n",
       "5             coach  \n",
       "6      coach||coach  \n",
       "7      coach||coach  \n",
       "8      coach||coach  \n",
       "9      coach||coach  \n",
       "\n",
       "[10 rows x 24 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "190680cf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().any().any()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "87e2a90c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "searchDate                            0\n",
       "flightDate                            0\n",
       "startingAirport                       0\n",
       "destinationAirport                    0\n",
       "fareBasisCode                         0\n",
       "travelDuration                        0\n",
       "elapsedDays                           0\n",
       "isBasicEconomy                        0\n",
       "isRefundable                          0\n",
       "isNonStop                             0\n",
       "baseFare                              0\n",
       "totalFare                             0\n",
       "seatsRemaining                        0\n",
       "totalTravelDistance             6094532\n",
       "segmentsDepartureTimeRaw              0\n",
       "segmentsArrivalTimeRaw                0\n",
       "segmentsArrivalAirportCode            0\n",
       "segmentsDepartureAirportCode          0\n",
       "segmentsAirlineName                   0\n",
       "segmentsAirlineCode                   0\n",
       "segmentsEquipmentDescription    1557592\n",
       "segmentsDurationInSeconds             0\n",
       "segmentsDistance                      0\n",
       "segmentsCabinCode                     0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}