code/airline_with_weather.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "b8945b29",
   "metadata": {},
   "source": [
    "# ADS507_Team1_Final_Project\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "d8e5766f",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Import libraries\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import pymysql as mysql\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "eb2a0ff6",
   "metadata": {},
   "source": [
    "### Airline data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "791c8327",
   "metadata": {},
   "outputs": [],
   "source": [
    "#connectting the sql\n",
    "conn2=mysql.connect(host='localhost',\n",
    "                   port=int(3306),\n",
    "                   user='root',\n",
    "                   passwd='******',\n",
    "                   db='airline')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "9bfb5542",
   "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>Tables_in_airline</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>l_airline_id</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>l_airport</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>l_airport_id</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>l_airport_seq_id</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>l_cancellation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>l_city_market_id</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>l_deparrblk</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>l_distance_group_250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>l_diversions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>l_months</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>l_ontime_delay_groups</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>l_quarters</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>l_state_abr_aviation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>l_state_fips</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>l_unique_carriers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>l_weekdays</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>l_world_area_codes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>l_yesno_resp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>on_time_on_time_performance_2016_1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Tables_in_airline\n",
       "0                         l_airline_id\n",
       "1                            l_airport\n",
       "2                         l_airport_id\n",
       "3                     l_airport_seq_id\n",
       "4                       l_cancellation\n",
       "5                     l_city_market_id\n",
       "6                          l_deparrblk\n",
       "7                 l_distance_group_250\n",
       "8                         l_diversions\n",
       "9                             l_months\n",
       "10               l_ontime_delay_groups\n",
       "11                          l_quarters\n",
       "12                l_state_abr_aviation\n",
       "13                        l_state_fips\n",
       "14                   l_unique_carriers\n",
       "15                          l_weekdays\n",
       "16                  l_world_area_codes\n",
       "17                        l_yesno_resp\n",
       "18  on_time_on_time_performance_2016_1"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Show tables\n",
    "tableNames2 = pd.read_sql(\"\"\"SHOW TABLES\"\"\", conn2)\n",
    "tableNames2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "f1cc2a20",
   "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>Year</th>\n",
       "      <th>Quarter</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayofMonth</th>\n",
       "      <th>DayOfWeek</th>\n",
       "      <th>FlightDate</th>\n",
       "      <th>UniqueCarrier</th>\n",
       "      <th>AirlineID</th>\n",
       "      <th>Carrier</th>\n",
       "      <th>TailNum</th>\n",
       "      <th>...</th>\n",
       "      <th>Div1TotalGTime</th>\n",
       "      <th>Div1LongestGTime</th>\n",
       "      <th>Div1WheelsOff</th>\n",
       "      <th>Div1TailNum</th>\n",
       "      <th>Div2Airport</th>\n",
       "      <th>Div2AirportID</th>\n",
       "      <th>Div2AirportSeqID</th>\n",
       "      <th>Div2WheelsOn</th>\n",
       "      <th>Div2TotalGTime</th>\n",
       "      <th>Div2LongestGTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>2016-01-06</td>\n",
       "      <td>AA</td>\n",
       "      <td>19805</td>\n",
       "      <td>AA</td>\n",
       "      <td>N4YBAA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>2016-01-07</td>\n",
       "      <td>AA</td>\n",
       "      <td>19805</td>\n",
       "      <td>AA</td>\n",
       "      <td>N434AA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>2016-01-08</td>\n",
       "      <td>AA</td>\n",
       "      <td>19805</td>\n",
       "      <td>AA</td>\n",
       "      <td>N541AA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>2016-01-09</td>\n",
       "      <td>AA</td>\n",
       "      <td>19805</td>\n",
       "      <td>AA</td>\n",
       "      <td>N489AA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>2016-01-10</td>\n",
       "      <td>AA</td>\n",
       "      <td>19805</td>\n",
       "      <td>AA</td>\n",
       "      <td>N439AA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445822</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>2016-01-03</td>\n",
       "      <td>F9</td>\n",
       "      <td>20436</td>\n",
       "      <td>F9</td>\n",
       "      <td>N934FR</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445823</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>2016-01-03</td>\n",
       "      <td>F9</td>\n",
       "      <td>20436</td>\n",
       "      <td>F9</td>\n",
       "      <td>N934FR</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445824</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>2016-01-03</td>\n",
       "      <td>F9</td>\n",
       "      <td>20436</td>\n",
       "      <td>F9</td>\n",
       "      <td>N935FR</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445825</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>2016-01-03</td>\n",
       "      <td>F9</td>\n",
       "      <td>20436</td>\n",
       "      <td>F9</td>\n",
       "      <td>N935FR</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445826</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>2016-01-03</td>\n",
       "      <td>F9</td>\n",
       "      <td>20436</td>\n",
       "      <td>F9</td>\n",
       "      <td>N935FR</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>445827 rows × 83 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Year  Quarter  Month  DayofMonth  DayOfWeek  FlightDate UniqueCarrier  \\\n",
       "0       2016        1      1           6          3  2016-01-06            AA   \n",
       "1       2016        1      1           7          4  2016-01-07            AA   \n",
       "2       2016        1      1           8          5  2016-01-08            AA   \n",
       "3       2016        1      1           9          6  2016-01-09            AA   \n",
       "4       2016        1      1          10          7  2016-01-10            AA   \n",
       "...      ...      ...    ...         ...        ...         ...           ...   \n",
       "445822  2016        1      1           3          7  2016-01-03            F9   \n",
       "445823  2016        1      1           3          7  2016-01-03            F9   \n",
       "445824  2016        1      1           3          7  2016-01-03            F9   \n",
       "445825  2016        1      1           3          7  2016-01-03            F9   \n",
       "445826  2016        1      1           3          7  2016-01-03            F9   \n",
       "\n",
       "        AirlineID Carrier TailNum  ...  Div1TotalGTime  Div1LongestGTime  \\\n",
       "0           19805      AA  N4YBAA  ...             NaN               NaN   \n",
       "1           19805      AA  N434AA  ...             NaN               NaN   \n",
       "2           19805      AA  N541AA  ...             NaN               NaN   \n",
       "3           19805      AA  N489AA  ...             NaN               NaN   \n",
       "4           19805      AA  N439AA  ...             NaN               NaN   \n",
       "...           ...     ...     ...  ...             ...               ...   \n",
       "445822      20436      F9  N934FR  ...             NaN               NaN   \n",
       "445823      20436      F9  N934FR  ...             NaN               NaN   \n",
       "445824      20436      F9  N935FR  ...             NaN               NaN   \n",
       "445825      20436      F9  N935FR  ...             NaN               NaN   \n",
       "445826      20436      F9  N935FR  ...             NaN               NaN   \n",
       "\n",
       "        Div1WheelsOff  Div1TailNum Div2Airport Div2AirportID Div2AirportSeqID  \\\n",
       "0                 NaN         None        None           NaN              NaN   \n",
       "1                 NaN         None        None           NaN              NaN   \n",
       "2                 NaN         None        None           NaN              NaN   \n",
       "3                 NaN         None        None           NaN              NaN   \n",
       "4                 NaN         None        None           NaN              NaN   \n",
       "...               ...          ...         ...           ...              ...   \n",
       "445822            NaN         None        None           NaN              NaN   \n",
       "445823            NaN         None        None           NaN              NaN   \n",
       "445824            NaN         None        None           NaN              NaN   \n",
       "445825            NaN         None        None           NaN              NaN   \n",
       "445826            NaN         None        None           NaN              NaN   \n",
       "\n",
       "        Div2WheelsOn Div2TotalGTime  Div2LongestGTime  \n",
       "0                NaN            NaN               NaN  \n",
       "1                NaN            NaN               NaN  \n",
       "2                NaN            NaN               NaN  \n",
       "3                NaN            NaN               NaN  \n",
       "4                NaN            NaN               NaN  \n",
       "...              ...            ...               ...  \n",
       "445822           NaN            NaN               NaN  \n",
       "445823           NaN            NaN               NaN  \n",
       "445824           NaN            NaN               NaN  \n",
       "445825           NaN            NaN               NaN  \n",
       "445826           NaN            NaN               NaN  \n",
       "\n",
       "[445827 rows x 83 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "airline_table = \"\"\"SELECT * FROM on_time_on_time_performance_2016_1 \"\"\"\n",
    "airline_df =  pd.read_sql(airline_table, conn2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "a2e1eb64",
   "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>Year</th>\n",
       "      <th>Quarter</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayofMonth</th>\n",
       "      <th>DayOfWeek</th>\n",
       "      <th>FlightDate</th>\n",
       "      <th>UniqueCarrier</th>\n",
       "      <th>AirlineID</th>\n",
       "      <th>Carrier</th>\n",
       "      <th>TailNum</th>\n",
       "      <th>...</th>\n",
       "      <th>Div1TotalGTime</th>\n",
       "      <th>Div1LongestGTime</th>\n",
       "      <th>Div1WheelsOff</th>\n",
       "      <th>Div1TailNum</th>\n",
       "      <th>Div2Airport</th>\n",
       "      <th>Div2AirportID</th>\n",
       "      <th>Div2AirportSeqID</th>\n",
       "      <th>Div2WheelsOn</th>\n",
       "      <th>Div2TotalGTime</th>\n",
       "      <th>Div2LongestGTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>2016-01-06</td>\n",
       "      <td>AA</td>\n",
       "      <td>19805</td>\n",
       "      <td>AA</td>\n",
       "      <td>N4YBAA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>2016-01-07</td>\n",
       "      <td>AA</td>\n",
       "      <td>19805</td>\n",
       "      <td>AA</td>\n",
       "      <td>N434AA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>2016-01-08</td>\n",
       "      <td>AA</td>\n",
       "      <td>19805</td>\n",
       "      <td>AA</td>\n",
       "      <td>N541AA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>2016-01-09</td>\n",
       "      <td>AA</td>\n",
       "      <td>19805</td>\n",
       "      <td>AA</td>\n",
       "      <td>N489AA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>2016-01-10</td>\n",
       "      <td>AA</td>\n",
       "      <td>19805</td>\n",
       "      <td>AA</td>\n",
       "      <td>N439AA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445822</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>2016-01-03</td>\n",
       "      <td>F9</td>\n",
       "      <td>20436</td>\n",
       "      <td>F9</td>\n",
       "      <td>N934FR</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445823</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>2016-01-03</td>\n",
       "      <td>F9</td>\n",
       "      <td>20436</td>\n",
       "      <td>F9</td>\n",
       "      <td>N934FR</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445824</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>2016-01-03</td>\n",
       "      <td>F9</td>\n",
       "      <td>20436</td>\n",
       "      <td>F9</td>\n",
       "      <td>N935FR</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445825</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>2016-01-03</td>\n",
       "      <td>F9</td>\n",
       "      <td>20436</td>\n",
       "      <td>F9</td>\n",
       "      <td>N935FR</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445826</th>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>2016-01-03</td>\n",
       "      <td>F9</td>\n",
       "      <td>20436</td>\n",
       "      <td>F9</td>\n",
       "      <td>N935FR</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>445827 rows × 83 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Year  Quarter  Month  DayofMonth  DayOfWeek  FlightDate UniqueCarrier  \\\n",
       "0       2016        1      1           6          3  2016-01-06            AA   \n",
       "1       2016        1      1           7          4  2016-01-07            AA   \n",
       "2       2016        1      1           8          5  2016-01-08            AA   \n",
       "3       2016        1      1           9          6  2016-01-09            AA   \n",
       "4       2016        1      1          10          7  2016-01-10            AA   \n",
       "...      ...      ...    ...         ...        ...         ...           ...   \n",
       "445822  2016        1      1           3          7  2016-01-03            F9   \n",
       "445823  2016        1      1           3          7  2016-01-03            F9   \n",
       "445824  2016        1      1           3          7  2016-01-03            F9   \n",
       "445825  2016        1      1           3          7  2016-01-03            F9   \n",
       "445826  2016        1      1           3          7  2016-01-03            F9   \n",
       "\n",
       "        AirlineID Carrier TailNum  ...  Div1TotalGTime  Div1LongestGTime  \\\n",
       "0           19805      AA  N4YBAA  ...             NaN               NaN   \n",
       "1           19805      AA  N434AA  ...             NaN               NaN   \n",
       "2           19805      AA  N541AA  ...             NaN               NaN   \n",
       "3           19805      AA  N489AA  ...             NaN               NaN   \n",
       "4           19805      AA  N439AA  ...             NaN               NaN   \n",
       "...           ...     ...     ...  ...             ...               ...   \n",
       "445822      20436      F9  N934FR  ...             NaN               NaN   \n",
       "445823      20436      F9  N934FR  ...             NaN               NaN   \n",
       "445824      20436      F9  N935FR  ...             NaN               NaN   \n",
       "445825      20436      F9  N935FR  ...             NaN               NaN   \n",
       "445826      20436      F9  N935FR  ...             NaN               NaN   \n",
       "\n",
       "        Div1WheelsOff  Div1TailNum Div2Airport Div2AirportID Div2AirportSeqID  \\\n",
       "0                 NaN         None        None           NaN              NaN   \n",
       "1                 NaN         None        None           NaN              NaN   \n",
       "2                 NaN         None        None           NaN              NaN   \n",
       "3                 NaN         None        None           NaN              NaN   \n",
       "4                 NaN         None        None           NaN              NaN   \n",
       "...               ...          ...         ...           ...              ...   \n",
       "445822            NaN         None        None           NaN              NaN   \n",
       "445823            NaN         None        None           NaN              NaN   \n",
       "445824            NaN         None        None           NaN              NaN   \n",
       "445825            NaN         None        None           NaN              NaN   \n",
       "445826            NaN         None        None           NaN              NaN   \n",
       "\n",
       "        Div2WheelsOn Div2TotalGTime  Div2LongestGTime  \n",
       "0                NaN            NaN               NaN  \n",
       "1                NaN            NaN               NaN  \n",
       "2                NaN            NaN               NaN  \n",
       "3                NaN            NaN               NaN  \n",
       "4                NaN            NaN               NaN  \n",
       "...              ...            ...               ...  \n",
       "445822           NaN            NaN               NaN  \n",
       "445823           NaN            NaN               NaN  \n",
       "445824           NaN            NaN               NaN  \n",
       "445825           NaN            NaN               NaN  \n",
       "445826           NaN            NaN               NaN  \n",
       "\n",
       "[445827 rows x 83 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "airline_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "4885cb6a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(445827, 83)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "airline_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "f16d9474",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 445827 entries, 0 to 445826\n",
      "Data columns (total 83 columns):\n",
      " #   Column                Non-Null Count   Dtype  \n",
      "---  ------                --------------   -----  \n",
      " 0   Year                  445827 non-null  int64  \n",
      " 1   Quarter               445827 non-null  int64  \n",
      " 2   Month                 445827 non-null  int64  \n",
      " 3   DayofMonth            445827 non-null  int64  \n",
      " 4   DayOfWeek             445827 non-null  int64  \n",
      " 5   FlightDate            445827 non-null  object \n",
      " 6   UniqueCarrier         445827 non-null  object \n",
      " 7   AirlineID             445827 non-null  int64  \n",
      " 8   Carrier               445827 non-null  object \n",
      " 9   TailNum               441583 non-null  object \n",
      " 10  FlightNum             445827 non-null  int64  \n",
      " 11  OriginAirportID       445827 non-null  int64  \n",
      " 12  OriginAirportSeqID    445827 non-null  int64  \n",
      " 13  OriginCityMarketID    445827 non-null  int64  \n",
      " 14  Origin                445827 non-null  object \n",
      " 15  OriginCityName        445827 non-null  object \n",
      " 16  OriginState           445827 non-null  object \n",
      " 17  OriginStateFips       445827 non-null  int64  \n",
      " 18  OriginStateName       445827 non-null  object \n",
      " 19  OriginWac             445827 non-null  int64  \n",
      " 20  DestAirportID         445827 non-null  int64  \n",
      " 21  DestAirportSeqID      445827 non-null  int64  \n",
      " 22  DestCityMarketID      445827 non-null  int64  \n",
      " 23  Dest                  445827 non-null  object \n",
      " 24  DestCityName          445827 non-null  object \n",
      " 25  DestState             445827 non-null  object \n",
      " 26  DestStateFips         445827 non-null  int64  \n",
      " 27  DestStateName         445827 non-null  object \n",
      " 28  DestWac               445827 non-null  int64  \n",
      " 29  CRSDepTime            445827 non-null  int64  \n",
      " 30  DepTime               434354 non-null  float64\n",
      " 31  DepDelay              434354 non-null  float64\n",
      " 32  DepDelayMinutes       434354 non-null  float64\n",
      " 33  DepDel15              434354 non-null  float64\n",
      " 34  DepartureDelayGroups  434354 non-null  float64\n",
      " 35  DepTimeBlk            445827 non-null  object \n",
      " 36  TaxiOut               434227 non-null  float64\n",
      " 37  WheelsOff             434227 non-null  float64\n",
      " 38  WheelsOn              433920 non-null  float64\n",
      " 39  TaxiIn                433920 non-null  float64\n",
      " 40  CRSArrTime            445827 non-null  int64  \n",
      " 41  ArrTime               433920 non-null  float64\n",
      " 42  ArrDelay              433298 non-null  float64\n",
      " 43  ArrDelayMinutes       433298 non-null  float64\n",
      " 44  ArrDel15              433298 non-null  float64\n",
      " 45  ArrivalDelayGroups    433298 non-null  float64\n",
      " 46  ArrTimeBlk            445827 non-null  object \n",
      " 47  Cancelled             445827 non-null  int64  \n",
      " 48  CancellationCode      11665 non-null   object \n",
      " 49  Diverted              445827 non-null  int64  \n",
      " 50  CRSElapsedTime        445827 non-null  float64\n",
      " 51  ActualElapsedTime     433298 non-null  float64\n",
      " 52  AirTime               433298 non-null  float64\n",
      " 53  Flights               445827 non-null  float64\n",
      " 54  Distance              445827 non-null  float64\n",
      " 55  DistanceGroup         445827 non-null  int64  \n",
      " 56  CarrierDelay          70882 non-null   float64\n",
      " 57  WeatherDelay          70882 non-null   float64\n",
      " 58  NASDelay              70882 non-null   float64\n",
      " 59  SecurityDelay         70882 non-null   float64\n",
      " 60  LateAircraftDelay     70882 non-null   float64\n",
      " 61  FirstDepTime          2552 non-null    float64\n",
      " 62  TotalAddGTime         2552 non-null    float64\n",
      " 63  LongestAddGTime       2552 non-null    float64\n",
      " 64  DivAirportLandings    445827 non-null  int64  \n",
      " 65  DivReachedDest        864 non-null     float64\n",
      " 66  DivActualElapsedTime  622 non-null     float64\n",
      " 67  DivArrDelay           622 non-null     float64\n",
      " 68  DivDistance           864 non-null     float64\n",
      " 69  Div1Airport           929 non-null     object \n",
      " 70  Div1AirportID         929 non-null     float64\n",
      " 71  Div1AirportSeqID      929 non-null     float64\n",
      " 72  Div1WheelsOn          929 non-null     float64\n",
      " 73  Div1TotalGTime        929 non-null     float64\n",
      " 74  Div1LongestGTime      929 non-null     float64\n",
      " 75  Div1WheelsOff         628 non-null     float64\n",
      " 76  Div1TailNum           628 non-null     object \n",
      " 77  Div2Airport           6 non-null       object \n",
      " 78  Div2AirportID         6 non-null       float64\n",
      " 79  Div2AirportSeqID      6 non-null       float64\n",
      " 80  Div2WheelsOn          6 non-null       float64\n",
      " 81  Div2TotalGTime        6 non-null       float64\n",
      " 82  Div2LongestGTime      6 non-null       float64\n",
      "dtypes: float64(42), int64(23), object(18)\n",
      "memory usage: 282.3+ MB\n"
     ]
    }
   ],
   "source": [
    "airline_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "380e543d",
   "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>Year</th>\n",
       "      <th>Quarter</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayofMonth</th>\n",
       "      <th>DayOfWeek</th>\n",
       "      <th>AirlineID</th>\n",
       "      <th>FlightNum</th>\n",
       "      <th>OriginAirportID</th>\n",
       "      <th>OriginAirportSeqID</th>\n",
       "      <th>OriginCityMarketID</th>\n",
       "      <th>...</th>\n",
       "      <th>Div1AirportSeqID</th>\n",
       "      <th>Div1WheelsOn</th>\n",
       "      <th>Div1TotalGTime</th>\n",
       "      <th>Div1LongestGTime</th>\n",
       "      <th>Div1WheelsOff</th>\n",
       "      <th>Div2AirportID</th>\n",
       "      <th>Div2AirportSeqID</th>\n",
       "      <th>Div2WheelsOn</th>\n",
       "      <th>Div2TotalGTime</th>\n",
       "      <th>Div2LongestGTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>445827.0</td>\n",
       "      <td>445827.0</td>\n",
       "      <td>445827.0</td>\n",
       "      <td>445827.000000</td>\n",
       "      <td>445827.000000</td>\n",
       "      <td>445827.000000</td>\n",
       "      <td>445827.000000</td>\n",
       "      <td>445827.000000</td>\n",
       "      <td>4.458270e+05</td>\n",
       "      <td>445827.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>9.290000e+02</td>\n",
       "      <td>929.000000</td>\n",
       "      <td>929.000000</td>\n",
       "      <td>929.000000</td>\n",
       "      <td>628.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>6.00</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2016.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>15.893510</td>\n",
       "      <td>4.113815</td>\n",
       "      <td>19903.085069</td>\n",
       "      <td>2078.856456</td>\n",
       "      <td>12682.120789</td>\n",
       "      <td>1.268215e+06</td>\n",
       "      <td>31723.938281</td>\n",
       "      <td>...</td>\n",
       "      <td>1.302242e+06</td>\n",
       "      <td>1426.447793</td>\n",
       "      <td>26.743811</td>\n",
       "      <td>21.470398</td>\n",
       "      <td>1488.385350</td>\n",
       "      <td>12694.333333</td>\n",
       "      <td>1.269436e+06</td>\n",
       "      <td>1287.166667</td>\n",
       "      <td>6.00</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.936692</td>\n",
       "      <td>2.005007</td>\n",
       "      <td>382.853084</td>\n",
       "      <td>1757.269780</td>\n",
       "      <td>1529.485604</td>\n",
       "      <td>1.529483e+05</td>\n",
       "      <td>1280.460591</td>\n",
       "      <td>...</td>\n",
       "      <td>1.626952e+05</td>\n",
       "      <td>521.502184</td>\n",
       "      <td>28.628435</td>\n",
       "      <td>24.184087</td>\n",
       "      <td>500.923391</td>\n",
       "      <td>1442.397818</td>\n",
       "      <td>1.442401e+05</td>\n",
       "      <td>947.880249</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2016.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>19393.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>10135.000000</td>\n",
       "      <td>1.013503e+06</td>\n",
       "      <td>30070.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.013503e+06</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>10721.000000</td>\n",
       "      <td>1.072102e+06</td>\n",
       "      <td>111.000000</td>\n",
       "      <td>4.00</td>\n",
       "      <td>4.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2016.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>19790.000000</td>\n",
       "      <td>702.000000</td>\n",
       "      <td>11292.000000</td>\n",
       "      <td>1.129202e+06</td>\n",
       "      <td>30615.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.129804e+06</td>\n",
       "      <td>1036.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>1138.750000</td>\n",
       "      <td>11797.000000</td>\n",
       "      <td>1.179702e+06</td>\n",
       "      <td>451.500000</td>\n",
       "      <td>5.00</td>\n",
       "      <td>5.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2016.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>19805.000000</td>\n",
       "      <td>1594.000000</td>\n",
       "      <td>12889.000000</td>\n",
       "      <td>1.288903e+06</td>\n",
       "      <td>31453.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.320402e+06</td>\n",
       "      <td>1442.000000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>1505.000000</td>\n",
       "      <td>12889.000000</td>\n",
       "      <td>1.288903e+06</td>\n",
       "      <td>1588.500000</td>\n",
       "      <td>5.00</td>\n",
       "      <td>5.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2016.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>20304.000000</td>\n",
       "      <td>2763.000000</td>\n",
       "      <td>14027.000000</td>\n",
       "      <td>1.402702e+06</td>\n",
       "      <td>32467.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.463502e+06</td>\n",
       "      <td>1834.000000</td>\n",
       "      <td>33.000000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>1844.250000</td>\n",
       "      <td>13337.500000</td>\n",
       "      <td>1.333752e+06</td>\n",
       "      <td>1925.250000</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2016.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>21171.000000</td>\n",
       "      <td>7438.000000</td>\n",
       "      <td>16218.000000</td>\n",
       "      <td>1.621801e+06</td>\n",
       "      <td>35991.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.622902e+06</td>\n",
       "      <td>2358.000000</td>\n",
       "      <td>293.000000</td>\n",
       "      <td>173.000000</td>\n",
       "      <td>2355.000000</td>\n",
       "      <td>14747.000000</td>\n",
       "      <td>1.474703e+06</td>\n",
       "      <td>2325.000000</td>\n",
       "      <td>9.00</td>\n",
       "      <td>9.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 65 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Year   Quarter     Month     DayofMonth      DayOfWeek  \\\n",
       "count  445827.0  445827.0  445827.0  445827.000000  445827.000000   \n",
       "mean     2016.0       1.0       1.0      15.893510       4.113815   \n",
       "std         0.0       0.0       0.0       8.936692       2.005007   \n",
       "min      2016.0       1.0       1.0       1.000000       1.000000   \n",
       "25%      2016.0       1.0       1.0       8.000000       2.000000   \n",
       "50%      2016.0       1.0       1.0      16.000000       4.000000   \n",
       "75%      2016.0       1.0       1.0      24.000000       6.000000   \n",
       "max      2016.0       1.0       1.0      31.000000       7.000000   \n",
       "\n",
       "           AirlineID      FlightNum  OriginAirportID  OriginAirportSeqID  \\\n",
       "count  445827.000000  445827.000000    445827.000000        4.458270e+05   \n",
       "mean    19903.085069    2078.856456     12682.120789        1.268215e+06   \n",
       "std       382.853084    1757.269780      1529.485604        1.529483e+05   \n",
       "min     19393.000000       1.000000     10135.000000        1.013503e+06   \n",
       "25%     19790.000000     702.000000     11292.000000        1.129202e+06   \n",
       "50%     19805.000000    1594.000000     12889.000000        1.288903e+06   \n",
       "75%     20304.000000    2763.000000     14027.000000        1.402702e+06   \n",
       "max     21171.000000    7438.000000     16218.000000        1.621801e+06   \n",
       "\n",
       "       OriginCityMarketID  ...  Div1AirportSeqID  Div1WheelsOn  \\\n",
       "count       445827.000000  ...      9.290000e+02    929.000000   \n",
       "mean         31723.938281  ...      1.302242e+06   1426.447793   \n",
       "std           1280.460591  ...      1.626952e+05    521.502184   \n",
       "min          30070.000000  ...      1.013503e+06      1.000000   \n",
       "25%          30615.000000  ...      1.129804e+06   1036.000000   \n",
       "50%          31453.000000  ...      1.320402e+06   1442.000000   \n",
       "75%          32467.000000  ...      1.463502e+06   1834.000000   \n",
       "max          35991.000000  ...      1.622902e+06   2358.000000   \n",
       "\n",
       "       Div1TotalGTime  Div1LongestGTime  Div1WheelsOff  Div2AirportID  \\\n",
       "count      929.000000        929.000000     628.000000       6.000000   \n",
       "mean        26.743811         21.470398    1488.385350   12694.333333   \n",
       "std         28.628435         24.184087     500.923391    1442.397818   \n",
       "min          2.000000          2.000000       1.000000   10721.000000   \n",
       "25%          9.000000          7.000000    1138.750000   11797.000000   \n",
       "50%         19.000000         13.000000    1505.000000   12889.000000   \n",
       "75%         33.000000         25.000000    1844.250000   13337.500000   \n",
       "max        293.000000        173.000000    2355.000000   14747.000000   \n",
       "\n",
       "       Div2AirportSeqID  Div2WheelsOn  Div2TotalGTime  Div2LongestGTime  \n",
       "count      6.000000e+00      6.000000            6.00              6.00  \n",
       "mean       1.269436e+06   1287.166667            6.00              6.00  \n",
       "std        1.442401e+05    947.880249            2.00              2.00  \n",
       "min        1.072102e+06    111.000000            4.00              4.00  \n",
       "25%        1.179702e+06    451.500000            5.00              5.00  \n",
       "50%        1.288903e+06   1588.500000            5.00              5.00  \n",
       "75%        1.333752e+06   1925.250000            7.25              7.25  \n",
       "max        1.474703e+06   2325.000000            9.00              9.00  \n",
       "\n",
       "[8 rows x 65 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "airline_df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "33675e70",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Find the duplicates\n",
    "airline_df.duplicated().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "69888c41",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['AA', 'AS', 'B6', 'DL', 'F9', 'OO', 'HA', 'NK', 'EV', 'UA', 'WN',\n",
       "       'VX'], dtype=object)"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#unique values\n",
    "airline_df['UniqueCarrier'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "a38e3bc5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['AA', 'AS', 'B6', 'DL', 'F9', 'OO', 'HA', 'NK', 'EV', 'UA', 'WN',\n",
       "       'VX'], dtype=object)"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#unique values\n",
    "airline_df['UniqueCarrier'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "94502e57",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Year                     0\n",
       "Quarter                  0\n",
       "Month                    0\n",
       "DayofMonth               0\n",
       "DayOfWeek                0\n",
       "                     ...  \n",
       "Div2AirportID       445821\n",
       "Div2AirportSeqID    445821\n",
       "Div2WheelsOn        445821\n",
       "Div2TotalGTime      445821\n",
       "Div2LongestGTime    445821\n",
       "Length: 83, dtype: int64"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "### Find the Null values\n",
    "airline_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "1199f609",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\seaborn\\_decorators.py:36: FutureWarning: Pass the following variable as a keyword arg: x. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "ename": "AttributeError",
     "evalue": "'AxesSubplot' object has no attribute 'unique'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-21-c9eed422a867>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[1;31m### Visualize the Unique counts\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m \u001b[0msns\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcountplot\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mairline_df\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'Month'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0munique\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m: 'AxesSubplot' object has no attribute 'unique'"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZgAAAEGCAYAAABYV4NmAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAARIklEQVR4nO3df6zd9V3H8eeLFhlmg7VQEFtmcTQqEByhKcT5x7JqWzNdyQTTxUmjTWoY6paYGdg/3SAk4KY4lkFCpKOty6BhOuomIU0RFx0DikN+jlDHhArSwkXGZkDL3v5xPzecXm4vh0s/97aX5yM5Oef7/n4/n/M+f8Cr3+/ne+5JVSFJ0sF2xEw3IEmanQwYSVIXBowkqQsDRpLUhQEjSepi7kw3cKg4/vjja/HixTPdhiQdVu67777nqmrBRPsMmGbx4sXs3LlzptuQpMNKkv840D4vkUmSujBgJEldGDCSpC4MGElSFwaMJKkLA0aS1IUBI0nqwoCRJHVhwEiSuvCb/IeYsz+1eaZbkHSYuO9zF850C5PyDEaS1IUBI0nqwoCRJHVhwEiSujBgJEldGDCSpC4MGElSFwaMJKkLA0aS1IUBI0nqwoCRJHVhwEiSujBgJEldGDCSpC4MGElSFwaMJKkLA0aS1EX3gEkyJ8l3k3yjbc9Psj3J4+153sCxlybZleSxJCsH6mcnebDtuyZJWv2oJDe3+t1JFg+MWdve4/Eka3t/TknS/qbjDOYTwKMD25cAO6pqCbCjbZPkNGANcDqwCrg2yZw25jpgPbCkPVa1+jrghao6FbgauKrNNR/YAJwDLAM2DAaZJKm/rgGTZBHwIeCvB8qrgU3t9SbgvIH6TVX1SlU9AewCliU5CTimqu6qqgI2jxszNtctwPJ2drMS2F5VI1X1ArCd10JJkjQNep/B/BXwZ8BPBmonVtUzAO35hFZfCDw1cNzuVlvYXo+v7zemqvYBLwLHTTLXfpKsT7Izyc69e/dO4eNJkg6kW8Ak+U1gT1XdN+yQCWo1SX2qY14rVF1fVUuraumCBQuGbFOSNIyeZzDvBz6c5AfATcAHk/wN8Gy77EV73tOO3w2cPDB+EfB0qy+aoL7fmCRzgWOBkUnmkiRNk24BU1WXVtWiqlrM6OL9HVX1MWAbMHZX11rg1vZ6G7Cm3Rl2CqOL+fe0y2gvJTm3ra9cOG7M2Fznt/co4HZgRZJ5bXF/RatJkqbJ3Bl4zyuBrUnWAU8CFwBU1cNJtgKPAPuAi6vq1TbmIuBG4GjgtvYAuAHYkmQXo2cua9pcI0kuB+5tx11WVSO9P5gk6TXTEjBVdSdwZ3v9PLD8AMddAVwxQX0ncMYE9ZdpATXBvo3Axqn2LEl6a/wmvySpCwNGktSFASNJ6sKAkSR1YcBIkrowYCRJXRgwkqQuDBhJUhcGjCSpCwNGktSFASNJ6sKAkSR1YcBIkrowYCRJXRgwkqQuDBhJUhcGjCSpCwNGktSFASNJ6sKAkSR1YcBIkrowYCRJXRgwkqQuDBhJUhcGjCSpCwNGktSFASNJ6sKAkSR1YcBIkrowYCRJXRgwkqQuDBhJUhcGjCSpCwNGktSFASNJ6sKAkSR1YcBIkrroFjBJ3pHkniT/luThJJ9t9flJtid5vD3PGxhzaZJdSR5LsnKgfnaSB9u+a5Kk1Y9KcnOr351k8cCYte09Hk+yttfnlCRNrOcZzCvAB6vql4H3AauSnAtcAuyoqiXAjrZNktOANcDpwCrg2iRz2lzXAeuBJe2xqtXXAS9U1anA1cBVba75wAbgHGAZsGEwyCRJ/XULmBr1o7Z5ZHsUsBrY1OqbgPPa69XATVX1SlU9AewCliU5CTimqu6qqgI2jxszNtctwPJ2drMS2F5VI1X1ArCd10JJkjQNuq7BJJmT5H5gD6P/w78bOLGqngFozye0wxcCTw0M391qC9vr8fX9xlTVPuBF4LhJ5hrf3/okO5Ps3Lt371v4pJKk8boGTFW9WlXvAxYxejZyxiSHZ6IpJqlPdcxgf9dX1dKqWrpgwYJJWpMkvVnTchdZVf03cCejl6mebZe9aM972mG7gZMHhi0Cnm71RRPU9xuTZC5wLDAyyVySpGnS8y6yBUne3V4fDfwa8D1gGzB2V9da4Nb2ehuwpt0Zdgqji/n3tMtoLyU5t62vXDhuzNhc5wN3tHWa24EVSea1xf0VrSZJmiZzO859ErCp3Ql2BLC1qr6R5C5ga5J1wJPABQBV9XCSrcAjwD7g4qp6tc11EXAjcDRwW3sA3ABsSbKL0TOXNW2ukSSXA/e24y6rqpGOn1WSNE63gKmqB4CzJqg/Dyw/wJgrgCsmqO8EXrd+U1Uv0wJqgn0bgY1vrmtJ0sHiN/klSV0YMJKkLgwYSVIXBowkqQsDRpLUhQEjSerCgJEkdWHASJK6MGAkSV0YMJKkLgwYSVIXBowkqQsDRpLUhQEjSepiqIBJsmOYmiRJYyb9PZgk7wB+Gji+/TLk2G/dHwP8bOfeJEmHsTf6wbE/BD7JaJjcx2sB80PgS/3akiQd7iYNmKr6AvCFJH9cVV+cpp4kSbPAUD+ZXFVfTPIrwOLBMVW1uVNfkqTD3FABk2QL8F7gfuDVVi7AgJEkTWiogAGWAqdVVfVsRpI0ewz7PZiHgJ/p2YgkaXYZ9gzmeOCRJPcAr4wVq+rDXbqSJB32hg2Yz/RsQpI0+wx7F9k/9W5EkjS7DHsX2UuM3jUG8FPAkcCPq+qYXo1Jkg5vw57BvGtwO8l5wLIeDUmSZocp/TXlqvo68MGD24okaTYZ9hLZRwY2j2D0ezF+J0aSdEDD3kX2WwOv9wE/AFYf9G4kSbPGsGswv9+7EUnS7DLsD44tSvJ3SfYkeTbJ15Is6t2cJOnwNewi/5eBbYz+LsxC4O9bTZKkCQ0bMAuq6stVta89bgQWdOxLknSYGzZgnkvysSRz2uNjwPM9G5MkHd6GDZg/AH4H+C/gGeB8wIV/SdIBDXub8uXA2qp6ASDJfODzjAaPJEmvM+wZzJlj4QJQVSPAWX1akiTNBsMGzBFJ5o1ttDOYSc9+kpyc5B+TPJrk4SSfGBubZHuSx9vz4LyXJtmV5LEkKwfqZyd5sO27Jkla/agkN7f63UkWD4xZ297j8SRrh/yckqSDZNiA+Qvg20kuT3IZ8G3gz99gzD7gT6vql4BzgYuTnAZcAuyoqiXAjrZN27cGOB1YBVybZE6b6zpgPbCkPVa1+jrghao6FbgauKrNNR/YAJzD6B/l3DAYZJKk/oYKmKraDPw28CywF/hIVW15gzHPVNW/ttcvAY8y+h2a1cCmdtgm4Lz2ejVwU1W9UlVPALuAZUlOAo6pqruqqoDN48aMzXULsLyd3awEtlfVSLu0t53XQkmSNA2GXeSnqh4BHpnKm7RLV2cBdwMnVtUzbc5nkpzQDlsIfGdg2O5W+7/2enx9bMxTba59SV4EjhusTzBmsK/1jJ4Z8Z73vGcqH02SdABT+nP9b0aSdwJfAz5ZVT+c7NAJajVJfapjXitUXV9VS6tq6YIFfm9Ukg6mrgGT5EhGw+UrVfW3rfxsu+xFe97T6ruBkweGLwKebvVFE9T3G5NkLnAsMDLJXJKkadItYNpayA3Ao1X1lwO7tgFjd3WtBW4dqK9pd4adwuhi/j3tctpLSc5tc144bszYXOcDd7R1mtuBFUnmtcX9Fa0mSZomQ6/BTMH7gd8DHkxyf6t9GrgS2JpkHfAkcAFAVT2cZCuj6zz7gIur6tU27iLgRuBo4Lb2gNEA25JkF6NnLmvaXCNJLgfubcdd1r67I0maJt0Cpqr+mYnXQgCWH2DMFcAVE9R3AmdMUH+ZFlAT7NsIbBy2X0nSwdV9kV+S9PZkwEiSujBgJEldGDCSpC4MGElSFwaMJKkLA0aS1IUBI0nqwoCRJHVhwEiSujBgJEldGDCSpC4MGElSFwaMJKkLA0aS1IUBI0nqwoCRJHVhwEiSujBgJEldGDCSpC4MGElSFwaMJKkLA0aS1IUBI0nqwoCRJHVhwEiSujBgJEldGDCSpC4MGElSFwaMJKkLA0aS1IUBI0nqwoCRJHVhwEiSujBgJEldGDCSpC4MGElSF90CJsnGJHuSPDRQm59ke5LH2/O8gX2XJtmV5LEkKwfqZyd5sO27Jkla/agkN7f63UkWD4xZ297j8SRre31GSdKB9TyDuRFYNa52CbCjqpYAO9o2SU4D1gCntzHXJpnTxlwHrAeWtMfYnOuAF6rqVOBq4Ko213xgA3AOsAzYMBhkkqTp0S1gqupbwMi48mpgU3u9CThvoH5TVb1SVU8Au4BlSU4Cjqmqu6qqgM3jxozNdQuwvJ3drAS2V9VIVb0AbOf1QSdJ6my612BOrKpnANrzCa2+EHhq4LjdrbawvR5f329MVe0DXgSOm2Su10myPsnOJDv37t37Fj6WJGm8Q2WRPxPUapL6VMfsX6y6vqqWVtXSBQsWDNWoJGk40x0wz7bLXrTnPa2+Gzh54LhFwNOtvmiC+n5jkswFjmX0ktyB5pIkTaPpDphtwNhdXWuBWwfqa9qdYacwuph/T7uM9lKSc9v6yoXjxozNdT5wR1unuR1YkWReW9xf0WqSpGk0t9fESb4KfAA4PsluRu/suhLYmmQd8CRwAUBVPZxkK/AIsA+4uKpebVNdxOgdaUcDt7UHwA3AliS7GD1zWdPmGklyOXBvO+6yqhp/s4EkqbNuAVNVHz3AruUHOP4K4IoJ6juBMyaov0wLqAn2bQQ2Dt2sJOmgO1QW+SVJs4wBI0nqwoCRJHVhwEiSujBgJEldGDCSpC4MGElSFwaMJKkLA0aS1IUBI0nqwoCRJHVhwEiSujBgJEldGDCSpC4MGElSFwaMJKkLA0aS1IUBI0nqwoCRJHVhwEiSujBgJEldGDCSpC4MGElSFwaMJKkLA0aS1IUBI0nqwoCRJHVhwEiSujBgJEldGDCSpC4MGElSFwaMJKkLA0aS1IUBI0nqwoCRJHVhwEiSujBgJEldGDCSpC5mdcAkWZXksSS7klwy0/1I0tvJrA2YJHOALwG/AZwGfDTJaTPblSS9fczagAGWAbuq6vtV9b/ATcDqGe5Jkt425s50Ax0tBJ4a2N4NnDN4QJL1wPq2+aMkj01Tb9KbdTzw3Ew3oUNLPr92plsA+LkD7ZjNAZMJarXfRtX1wPXT0440dUl2VtXSme5DejNm8yWy3cDJA9uLgKdnqBdJetuZzQFzL7AkySlJfgpYA2yb4Z4k6W1j1l4iq6p9Sf4IuB2YA2ysqodnuC1pqryUq8NOquqNj5Ik6U2azZfIJEkzyICRJHVhwEiHsCQbk+xJ8tBM9yK9WQaMdGi7EVg1001IU2HASIewqvoWMDLTfUhTYcBIkrowYCRJXRgwkqQuDBhJUhcGjHQIS/JV4C7gF5LsTrJupnuShuWfipEkdeEZjCSpCwNGktSFASNJ6sKAkSR1YcBIkrowYKRpkqSSbBnYnptkb5JvTHG+dyf5+MD2B6Y6l9SDASNNnx8DZyQ5um3/OvCfb2G+dwMff6ODpJliwEjT6zbgQ+31R4Gvju1IMj/J15M8kOQ7Sc5s9c+034W5M8n3k/xJG3Il8N4k9yf5XKu9M8ktSb6X5CtJMl0fTBrPgJGm103AmiTvAM4E7h7Y91ngu1V1JvBpYPPAvl8EVgLLgA1JjgQuAf69qt5XVZ9qx50FfBI4Dfh54P0dP4s0KQNGmkZV9QCwmNGzl38Yt/tXgS3tuDuA45Ic2/Z9s6peqarngD3AiQd4i3uqandV/QS4v72XNCPmznQD0tvQNuDzwAeA4wbqE13OGvtbTq8M1F7lwP/tDnuc1J1nMNL02whcVlUPjqt/C/hdGL0jDHiuqn44yTwvAe/q0aB0MPivG2maVdVu4AsT7PoM8OUkDwD/A6x9g3meT/IvSR5i9OaBbx7sXqW3wr+mLEnqwktkkqQuDBhJUhcGjCSpCwNGktSFASNJ6sKAkSR1YcBIkrr4f0iOd88bkqLiAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "### Visualize the Unique counts\n",
    "sns.countplot(airline_df['Month']).unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3dbaafc7",
   "metadata": {},
   "source": [
    "### WEATHER DATA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "802387b2",
   "metadata": {},
   "outputs": [],
   "source": [
    "### Load the Data\n",
    "weather_data = pd.DataFrame(pd.read_csv('WeatherUS_2016 (1).csv'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "79e29a38",
   "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>EventId</th>\n",
       "      <th>Type</th>\n",
       "      <th>Severity</th>\n",
       "      <th>StartTime(UTC)</th>\n",
       "      <th>EndTime(UTC)</th>\n",
       "      <th>Precipitation(in)</th>\n",
       "      <th>TimeZone</th>\n",
       "      <th>AirportCode</th>\n",
       "      <th>LocationLat</th>\n",
       "      <th>LocationLng</th>\n",
       "      <th>City</th>\n",
       "      <th>County</th>\n",
       "      <th>State</th>\n",
       "      <th>ZipCode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>W-1</td>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-06 23:14:00</td>\n",
       "      <td>2016-01-07 00:34:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>US/Mountain</td>\n",
       "      <td>K04V</td>\n",
       "      <td>38.0972</td>\n",
       "      <td>-106.1689</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "      <td>81149.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>W-2</td>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-07 04:14:00</td>\n",
       "      <td>2016-01-07 04:54:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>US/Mountain</td>\n",
       "      <td>K04V</td>\n",
       "      <td>38.0972</td>\n",
       "      <td>-106.1689</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "      <td>81149.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>W-3</td>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-07 05:54:00</td>\n",
       "      <td>2016-01-07 15:34:00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>US/Mountain</td>\n",
       "      <td>K04V</td>\n",
       "      <td>38.0972</td>\n",
       "      <td>-106.1689</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "      <td>81149.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>W-4</td>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-08 05:34:00</td>\n",
       "      <td>2016-01-08 05:54:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>US/Mountain</td>\n",
       "      <td>K04V</td>\n",
       "      <td>38.0972</td>\n",
       "      <td>-106.1689</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "      <td>81149.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>W-5</td>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-08 13:54:00</td>\n",
       "      <td>2016-01-08 15:54:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>US/Mountain</td>\n",
       "      <td>K04V</td>\n",
       "      <td>38.0972</td>\n",
       "      <td>-106.1689</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "      <td>81149.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0 EventId  Type Severity       StartTime(UTC)  \\\n",
       "0           0     W-1  Snow    Light  2016-01-06 23:14:00   \n",
       "1           1     W-2  Snow    Light  2016-01-07 04:14:00   \n",
       "2           2     W-3  Snow    Light  2016-01-07 05:54:00   \n",
       "3           3     W-4  Snow    Light  2016-01-08 05:34:00   \n",
       "4           4     W-5  Snow    Light  2016-01-08 13:54:00   \n",
       "\n",
       "          EndTime(UTC)  Precipitation(in)     TimeZone AirportCode  \\\n",
       "0  2016-01-07 00:34:00               0.00  US/Mountain        K04V   \n",
       "1  2016-01-07 04:54:00               0.00  US/Mountain        K04V   \n",
       "2  2016-01-07 15:34:00               0.03  US/Mountain        K04V   \n",
       "3  2016-01-08 05:54:00               0.00  US/Mountain        K04V   \n",
       "4  2016-01-08 15:54:00               0.00  US/Mountain        K04V   \n",
       "\n",
       "   LocationLat  LocationLng      City    County State  ZipCode  \n",
       "0      38.0972    -106.1689  Saguache  Saguache    CO  81149.0  \n",
       "1      38.0972    -106.1689  Saguache  Saguache    CO  81149.0  \n",
       "2      38.0972    -106.1689  Saguache  Saguache    CO  81149.0  \n",
       "3      38.0972    -106.1689  Saguache  Saguache    CO  81149.0  \n",
       "4      38.0972    -106.1689  Saguache  Saguache    CO  81149.0  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weather_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "6586f9d5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1185991, 15)"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weather_data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "6a3427d3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1185991 entries, 0 to 1185990\n",
      "Data columns (total 15 columns):\n",
      " #   Column             Non-Null Count    Dtype  \n",
      "---  ------             --------------    -----  \n",
      " 0   Unnamed: 0         1185991 non-null  int64  \n",
      " 1   EventId            1185991 non-null  object \n",
      " 2   Type               1185991 non-null  object \n",
      " 3   Severity           1185991 non-null  object \n",
      " 4   StartTime(UTC)     1185991 non-null  object \n",
      " 5   EndTime(UTC)       1185991 non-null  object \n",
      " 6   Precipitation(in)  1185991 non-null  float64\n",
      " 7   TimeZone           1185991 non-null  object \n",
      " 8   AirportCode        1185991 non-null  object \n",
      " 9   LocationLat        1185991 non-null  float64\n",
      " 10  LocationLng        1185991 non-null  float64\n",
      " 11  City               1184461 non-null  object \n",
      " 12  County             1185991 non-null  object \n",
      " 13  State              1185991 non-null  object \n",
      " 14  ZipCode            1177494 non-null  float64\n",
      "dtypes: float64(4), int64(1), object(10)\n",
      "memory usage: 135.7+ MB\n"
     ]
    }
   ],
   "source": [
    "weather_data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "f71e9488",
   "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>Precipitation(in)</th>\n",
       "      <th>LocationLat</th>\n",
       "      <th>LocationLng</th>\n",
       "      <th>ZipCode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1.185991e+06</td>\n",
       "      <td>1.185991e+06</td>\n",
       "      <td>1.185991e+06</td>\n",
       "      <td>1.185991e+06</td>\n",
       "      <td>1.177494e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>3.766146e+06</td>\n",
       "      <td>1.138823e-01</td>\n",
       "      <td>3.882525e+01</td>\n",
       "      <td>-9.258823e+01</td>\n",
       "      <td>5.404086e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>2.162479e+06</td>\n",
       "      <td>1.823154e+00</td>\n",
       "      <td>5.575401e+00</td>\n",
       "      <td>1.342531e+01</td>\n",
       "      <td>2.534854e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.455710e+01</td>\n",
       "      <td>-1.245550e+02</td>\n",
       "      <td>1.022000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>1.912022e+06</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.449780e+01</td>\n",
       "      <td>-9.851840e+01</td>\n",
       "      <td>3.254100e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>3.770805e+06</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.942560e+01</td>\n",
       "      <td>-9.073970e+01</td>\n",
       "      <td>5.505100e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>5.654580e+06</td>\n",
       "      <td>5.000000e-02</td>\n",
       "      <td>4.323370e+01</td>\n",
       "      <td>-8.252010e+01</td>\n",
       "      <td>7.523500e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>7.476864e+06</td>\n",
       "      <td>1.104130e+03</td>\n",
       "      <td>4.894020e+01</td>\n",
       "      <td>-6.779280e+01</td>\n",
       "      <td>9.936200e+04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Unnamed: 0  Precipitation(in)   LocationLat   LocationLng  \\\n",
       "count  1.185991e+06       1.185991e+06  1.185991e+06  1.185991e+06   \n",
       "mean   3.766146e+06       1.138823e-01  3.882525e+01 -9.258823e+01   \n",
       "std    2.162479e+06       1.823154e+00  5.575401e+00  1.342531e+01   \n",
       "min    0.000000e+00       0.000000e+00  2.455710e+01 -1.245550e+02   \n",
       "25%    1.912022e+06       0.000000e+00  3.449780e+01 -9.851840e+01   \n",
       "50%    3.770805e+06       0.000000e+00  3.942560e+01 -9.073970e+01   \n",
       "75%    5.654580e+06       5.000000e-02  4.323370e+01 -8.252010e+01   \n",
       "max    7.476864e+06       1.104130e+03  4.894020e+01 -6.779280e+01   \n",
       "\n",
       "            ZipCode  \n",
       "count  1.177494e+06  \n",
       "mean   5.404086e+04  \n",
       "std    2.534854e+04  \n",
       "min    1.022000e+03  \n",
       "25%    3.254100e+04  \n",
       "50%    5.505100e+04  \n",
       "75%    7.523500e+04  \n",
       "max    9.936200e+04  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weather_data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "2d696308",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Find the duplicates\n",
    "weather_data.duplicated().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "2d4f8318",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Snow', 'Fog', 'Cold', 'Storm', 'Rain', 'Precipitation', 'Hail'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#unique values\n",
    "weather_data['Type'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "02e3086e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Light', 'Severe', 'Moderate', 'Heavy', 'UNK', 'Other'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#unique values\n",
    "weather_data['Severity'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "53d08ee2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['CO', 'OK', 'MN', 'LA', 'WI', 'ID', 'MI', 'KS', 'WY', 'MA', 'MO',\n",
       "       'NM', 'NC', 'SC', 'RI', 'VA', 'CT', 'OR', 'ND', 'CA', 'NY', 'OH',\n",
       "       'SD', 'AZ', 'NV', 'IA', 'TX', 'GA', 'NE', 'TN', 'AL', 'IL', 'AR',\n",
       "       'WA', 'IN', 'UT', 'FL', 'WV', 'MS', 'PA', 'ME', 'MD', 'NJ', 'KY',\n",
       "       'VT', 'MT', 'NH', 'DE'], dtype=object)"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#unique values\n",
    "weather_data['State'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "dc79d235",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\seaborn\\_decorators.py:36: FutureWarning: Pass the following variable as a keyword arg: x. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "ename": "AttributeError",
     "evalue": "'AxesSubplot' object has no attribute 'unique'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-45-332d84ba9e4d>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[1;31m### Visualize the Unique counts\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m \u001b[0msns\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcountplot\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mweather_data\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'Type'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0munique\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m: 'AxesSubplot' object has no attribute 'unique'"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZgAAAEGCAYAAABYV4NmAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAehklEQVR4nO3df5RdZX3v8ffHBDGKwQQCxgSbdJHaAiqWIeCP+iveJNYfoW3Q4V7NYNMby8Vfq6UuqHcZCiu9ULUoWHAhBAIiELGUaEVMA+hVMGHQSAjIzRQQUiIJTIr4g2jS7/1jf4/ZMzkzORnmOScJn9dae519vns/z372nDPne5797LO3IgIzM7PR9rxON8DMzPZPTjBmZlaEE4yZmRXhBGNmZkU4wZiZWRFjO92AvcWhhx4a06ZN63QzzMz2KXffffcTETGp2TInmDRt2jR6e3s73Qwzs32KpJ8MtcyHyMzMrAgnGDMzK8IJxszMinCCMTOzIpxgzMysCCcYMzMrwgnGzMyKcIIxM7MinGDMzKwI/5LfzJr6/F9/rdNNaOpDn3lXp5tgLXIPxszMinCCMTOzIpxgzMysCCcYMzMroliCkfQKSWtr088kfUzSREkrJW3Ixwm1MmdJ6pP0gKQ5tfhxktblsgslKeMHSro+46slTauV6cltbJDUU2o/zcysuWIJJiIeiIhjI+JY4Djgl8CNwJnAqoiYAazK50g6CugGjgbmAhdLGpPVXQIsAmbkNDfjC4GtEXEkcAFwftY1EVgMnADMBBbXE5mZmZXXrkNks4B/j4ifAPOAZRlfBpyU8/OA6yJiW0Q8BPQBMyVNBsZHxJ0REcBVg8o06roBmJW9mznAyojoj4itwEp2JiUzM2uDdiWYbuDanD88IjYB5ONhGZ8CPForszFjU3J+cHxAmYjYDjwFHDJMXQNIWiSpV1Lvli1bRrxzZma2q+IJRtLzgXcDX9ndqk1iMUx8pGV2BiIujYiuiOiaNKnpLaXNzGyE2tGDeTvwg4h4PJ8/noe9yMfNGd8IHFErNxV4LONTm8QHlJE0FjgY6B+mLjMza5N2JJhT2Hl4DGAF0Dirqwe4qRbvzjPDplMN5q/Jw2hPSzoxx1cWDCrTqGs+cGuO09wCzJY0IQf3Z2fMzMzapOi1yCS9EPhvwAdr4fOA5ZIWAo8AJwNExHpJy4H7gO3A6RGxI8ucBlwJjANuzgngcuBqSX1UPZfurKtf0rnAXbneORHRX2QnzcysqaIJJiJ+STXoXo89SXVWWbP1lwBLmsR7gWOaxJ8hE1STZUuBpXveajMzGw3+Jb+ZmRXhBGNmZkU4wZiZWRFOMGZmVoQTjJmZFeEEY2ZmRTjBmJlZEU4wZmZWhBOMmZkV4QRjZmZFOMGYmVkRTjBmZlaEE4yZmRXhBGNmZkU4wZiZWRFOMGZmVoQTjJmZFeEEY2ZmRTjBmJlZEUUTjKSXSLpB0o8l3S/ptZImSlopaUM+Tqitf5akPkkPSJpTix8naV0uu1CSMn6gpOszvlrStFqZntzGBkk9JffTzMx2VboH8zngmxHx+8CrgfuBM4FVETEDWJXPkXQU0A0cDcwFLpY0Juu5BFgEzMhpbsYXAlsj4kjgAuD8rGsisBg4AZgJLK4nMjMzK69YgpE0HngjcDlARPw6Iv4TmAcsy9WWASfl/DzguojYFhEPAX3ATEmTgfERcWdEBHDVoDKNum4AZmXvZg6wMiL6I2IrsJKdScnMzNqgZA/md4EtwBWSfijpMkkvAg6PiE0A+XhYrj8FeLRWfmPGpuT84PiAMhGxHXgKOGSYugaQtEhSr6TeLVu2PJt9NTOzQUommLHAHwKXRMRrgF+Qh8OGoCaxGCY+0jI7AxGXRkRXRHRNmjRpmKaZmdmeKplgNgIbI2J1Pr+BKuE8noe9yMfNtfWPqJWfCjyW8alN4gPKSBoLHAz0D1OXmZm1SbEEExE/BR6V9IoMzQLuA1YAjbO6eoCbcn4F0J1nhk2nGsxfk4fRnpZ0Yo6vLBhUplHXfODWHKe5BZgtaUIO7s/OmJmZtcnYwvV/GLhG0vOBB4EPUCW15ZIWAo8AJwNExHpJy6mS0Hbg9IjYkfWcBlwJjANuzgmqEwiultRH1XPpzrr6JZ0L3JXrnRMR/SV31MzMBiqaYCJiLdDVZNGsIdZfAixpEu8FjmkSf4ZMUE2WLQWW7kFzzcxsFPmX/GZmVoQTjJmZFeEEY2ZmRTjBmJlZEU4wZmZWhBOMmZkV4QRjZmZFOMGYmVkRTjBmZlaEE4yZmRXhBGNmZkU4wZiZWRFOMGZmVoQTjJmZFeEEY2ZmRTjBmJlZEU4wZmZWhBOMmZkV4QRjZmZFOMGYmVkRRROMpIclrZO0VlJvxiZKWilpQz5OqK1/lqQ+SQ9ImlOLH5f19Em6UJIyfqCk6zO+WtK0Wpme3MYGST0l99PMzHbVjh7MWyLi2IjoyudnAqsiYgawKp8j6SigGzgamAtcLGlMlrkEWATMyGluxhcCWyPiSOAC4PysayKwGDgBmAksricyMzMrrxOHyOYBy3J+GXBSLX5dRGyLiIeAPmCmpMnA+Ii4MyICuGpQmUZdNwCzsnczB1gZEf0RsRVYyc6kZGZmbVA6wQTwLUl3S1qUscMjYhNAPh6W8SnAo7WyGzM2JecHxweUiYjtwFPAIcPUNYCkRZJ6JfVu2bJlxDtpZma7Glu4/tdHxGOSDgNWSvrxMOuqSSyGiY+0zM5AxKXApQBdXV27LDczs5Er2oOJiMfycTNwI9V4yON52It83JyrbwSOqBWfCjyW8alN4gPKSBoLHAz0D1OXmZm1SbEEI+lFkl7cmAdmA/cCK4DGWV09wE05vwLozjPDplMN5q/Jw2hPSzoxx1cWDCrTqGs+cGuO09wCzJY0IQf3Z2fMzMzapOQhssOBG/OM4rHAlyPim5LuApZLWgg8ApwMEBHrJS0H7gO2A6dHxI6s6zTgSmAccHNOAJcDV0vqo+q5dGdd/ZLOBe7K9c6JiP6C+2pmZoMUSzAR8SDw6ibxJ4FZQ5RZAixpEu8FjmkSf4ZMUE2WLQWW7lmrzcxstPiX/GZmVoQTjJmZFeEEY2ZmRTjBmJlZEU4wZmZWhBOMmZkV4QRjZmZFOMGYmVkRTjBmZlaEE4yZmRXhBGNmZkU4wZiZWRFOMGZmVoQTjJmZFeEEY2ZmRTjBmJlZES0lGEmrWomZmZk1DHtHS0kvAF4IHJr3tlcuGg+8rHDbzMxsH7a7WyZ/EPgYVTK5m50J5mfAP5VrlpmZ7euGPUQWEZ+LiOnAGRHxuxExPadXR8TnW9mApDGSfijp6/l8oqSVkjbk44TaumdJ6pP0gKQ5tfhxktblsgslKeMHSro+46slTauV6cltbJDUs2d/FjMze7ZaGoOJiIskvU7Sf5e0oDG1uI2PAvfXnp8JrIqIGcCqfI6ko4Bu4GhgLnCxpDFZ5hJgETAjp7kZXwhsjYgjgQuA87OuicBi4ARgJrC4nsjMzKy8Vgf5rwY+DbwBOD6nrhbKTQXeAVxWC88DluX8MuCkWvy6iNgWEQ8BfcBMSZOB8RFxZ0QEcNWgMo26bgBmZe9mDrAyIvojYiuwkp1JyczM2mB3YzANXcBR+QG/Jz4LfBx4cS12eERsAoiITZIOy/gU4Pu19TZm7Dc5PzjeKPNo1rVd0lPAIfV4kzK/JWkRVc+Il7/85Xu4a2ZmNpxWfwdzL/DSPalY0juBzRFxd6tFmsRimPhIy+wMRFwaEV0R0TVp0qQWm2lmZq1otQdzKHCfpDXAtkYwIt49TJnXA++W9MfAC4Dxkr4EPC5pcvZeJgObc/2NwBG18lOBxzI+tUm8XmajpLHAwUB/xt88qMztLe6rmZmNglZ7MGdTjXv8PfCZ2jSkiDgrIqZGxDSqwftbI+J9wAqgcVZXD3BTzq8AuvPMsOlUg/lr8nDa05JOzPGVBYPKNOqan9sI4BZgtqQJObg/O2NmZtYmLfVgIuLbo7jN84DlkhYCjwAn5zbWS1oO3AdsB06PiB1Z5jTgSmAccHNOAJcDV0vqo+q5dGdd/ZLOBe7K9c6JiP5R3AczM9uNlhKMpKfZOYbxfOAA4BcRMb6V8hFxO3mIKiKeBGYNsd4SYEmTeC9wTJP4M2SCarJsKbC0lfaZmdnoa7UHUz8LDEknUf2+xMzMrKkRXU05Iv4FeOvoNsXMzPYnrR4i+9Pa0+dR/S5mT38TY2ZmzyGtnqb8rtr8duBhql/Rm5mZNdXqGMwHSjfEzMz2L61ei2yqpBslbZb0uKSv5nXGzMzMmmp1kP8Kqh81vozqml5fy5iZmVlTrSaYSRFxRURsz+lKwBfvMjOzIbWaYJ6Q9L68edgYSe8DnizZMDMz27e1mmD+HHgP8FNgE9V1vzzwb2ZmQ2r1NOVzgZ68eVfjjpGfpko8ZmZmu2i1B/OqRnKB6mKSwGvKNMnMzPYHrSaY59XvaZ89mFZ7P2Zm9hzUapL4DHCHpBuoLhHzHppc9djMzKyh1V/yXyWpl+oClwL+NCLuK9oyMzPbp7V8mCsTipOKmZm1ZESX6zczM9sdJxgzMyvCCcbMzIoolmAkvUDSGkk/krRe0t9lfKKklZI25GP99OezJPVJekDSnFr8OEnrctmFkpTxAyVdn/HVkqbVyvTkNjZI6im1n2Zm1lzJHsw24K0R8WrgWGCupBOBM4FVETEDWJXPkXQU0A0cDcwFLpY0Juu6BFgEzMhpbsYXAlsj4kjgAuD8rGsisBg4AZgJLK4nMjMzK69YgonKz/PpATkF1Z0wl2V8GXBSzs8DrouIbRHxENAHzJQ0GRgfEXdGRABXDSrTqOsGYFb2buYAKyOiP69AsJKdScnMzNqg6BhMXnl5LbCZ6gN/NXB4RGwCyMfDcvUpwKO14hszNiXnB8cHlImI7cBTwCHD1GVmZm1SNMFExI6IOBaYStUbOWaY1dWsimHiIy2zc4PSIkm9knq3bNkyTNPMzGxPteUssoj4T+B2qsNUj+dhL/Jxc662ETiiVmwq8FjGpzaJDygjaSxwMNA/TF2D23VpRHRFRNekSb5/mpnZaCp5FtkkSS/J+XHA24AfU916uXFWVw9wU86vALrzzLDpVIP5a/Iw2tOSTszxlQWDyjTqmg/cmuM0twCzJU3Iwf3ZGTMzszYpeUXkycCyPBPsecDyiPi6pDuB5ZIWAo8AJwNExHpJy6kuR7MdOD0idmRdpwFXAuOAm3MCuBy4WlIfVc+lO+vql3QucFeud07eYsDMzNqkWIKJiHtocs+YiHgSmDVEmSU0uUpzRPQCu4zfRMQzZIJqsmwpsHTPWm1mZqPFv+Q3M7MinGDMzKwIJxgzMyvCCcbMzIpwgjEzsyKcYMzMrAgnGDMzK8IJxszMinCCMTOzIpxgzMysCCcYMzMrouTFLq3DHjnnlZ1uQlMv/+S6TjfBzNrAPRgzMyvCCcbMzIpwgjEzsyKcYMzMrAgnGDMzK8IJxszMinCCMTOzIpxgzMysiGIJRtIRkm6TdL+k9ZI+mvGJklZK2pCPE2plzpLUJ+kBSXNq8eMkrctlF0pSxg+UdH3GV0uaVivTk9vYIKmn1H6amVlzJXsw24G/jog/AE4ETpd0FHAmsCoiZgCr8jm5rBs4GpgLXCxpTNZ1CbAImJHT3IwvBLZGxJHABcD5WddEYDFwAjATWFxPZGZmVl6xBBMRmyLiBzn/NHA/MAWYByzL1ZYBJ+X8POC6iNgWEQ8BfcBMSZOB8RFxZ0QEcNWgMo26bgBmZe9mDrAyIvojYiuwkp1JyczM2qAtYzB56Oo1wGrg8IjYBFUSAg7L1aYAj9aKbczYlJwfHB9QJiK2A08BhwxT1+B2LZLUK6l3y5Ytz2IPzcxssOIJRtJBwFeBj0XEz4ZbtUkshomPtMzOQMSlEdEVEV2TJk0apmlmZraniiYYSQdQJZdrIuKfM/x4HvYiHzdnfCNwRK34VOCxjE9tEh9QRtJY4GCgf5i6zMysTUqeRSbgcuD+iPjH2qIVQOOsrh7gplq8O88Mm041mL8mD6M9LenErHPBoDKNuuYDt+Y4zS3AbEkTcnB/dsbMzKxNSt4P5vXA+4F1ktZm7G+B84DlkhYCjwAnA0TEeknLgfuozkA7PSJ2ZLnTgCuBccDNOUGVwK6W1EfVc+nOuvolnQvcleudExH9hfbTzMyaKJZgIuK7NB8LAZg1RJklwJIm8V7gmCbxZ8gE1WTZUmBpq+01M7PR5V/ym5lZEU4wZmZWhBOMmZkV4QRjZmZFOMGYmVkRTjBmZlZEyd/B7POO+5urOt2Epu7+1IJON8HMbLfcgzEzsyKcYMzMrAgnGDMzK8IJxszMinCCMTOzIpxgzMysCCcYMzMrwgnGzMyKcIIxM7MinGDMzKwIJxgzMyvCCcbMzIoolmAkLZW0WdK9tdhESSslbcjHCbVlZ0nqk/SApDm1+HGS1uWyCyUp4wdKuj7jqyVNq5XpyW1skNRTah/NzGxoJXswVwJzB8XOBFZFxAxgVT5H0lFAN3B0lrlY0pgscwmwCJiRU6POhcDWiDgSuAA4P+uaCCwGTgBmAovriczMzNqjWIKJiO8A/YPC84BlOb8MOKkWvy4itkXEQ0AfMFPSZGB8RNwZEQFcNahMo64bgFnZu5kDrIyI/ojYCqxk10RnZmaFtXsM5vCI2ASQj4dlfArwaG29jRmbkvOD4wPKRMR24CngkGHq2oWkRZJ6JfVu2bLlWeyWmZkNtrcM8qtJLIaJj7TMwGDEpRHRFRFdkyZNaqmhZmbWmnYnmMfzsBf5uDnjG4EjautNBR7L+NQm8QFlJI0FDqY6JDdUXWZm1kbtTjArgMZZXT3ATbV4d54ZNp1qMH9NHkZ7WtKJOb6yYFCZRl3zgVtznOYWYLakCTm4PztjZmbWRmNLVSzpWuDNwKGSNlKd2XUesFzSQuAR4GSAiFgvaTlwH7AdOD0idmRVp1GdkTYOuDkngMuBqyX1UfVcurOufknnAnfleudExOCTDczMrLBiCSYiThli0awh1l8CLGkS7wWOaRJ/hkxQTZYtBZa23FgzMxt1e8sgv5mZ7WecYMzMrAgnGDMzK8IJxszMinCCMTOzIpxgzMysCCcYMzMrwgnGzMyKcIIxM7MinGDMzKwIJxgzMyvCCcbMzIpwgjEzsyKKXU3Z7Nl6/UWv73QTmvreh7/X6SaY7RPcgzEzsyKcYMzMrAgnGDMzK8IJxszMinCCMTOzInwWmZntd5a8b36nmzCkT3zphk43oW326wQjaS7wOWAMcFlEnNfhJtlzyLff+KZON6GpN33n251ugj1H7LeHyCSNAf4JeDtwFHCKpKM62yozs+eO/TbBADOBvoh4MCJ+DVwHzOtwm8zMnjMUEZ1uQxGS5gNzI+Iv8vn7gRMi4kO1dRYBi/LpK4AHCjbpUOCJgvWX5vZ3ltvfWfty+0u3/XciYlKzBfvzGIyaxAZk04i4FLi0LY2ReiOiqx3bKsHt7yy3v7P25fZ3su378yGyjcARtedTgcc61BYzs+ec/TnB3AXMkDRd0vOBbmBFh9tkZvacsd8eIouI7ZI+BNxCdZry0ohY38EmteVQXEFuf2e5/Z21L7e/Y23fbwf5zcyss/bnQ2RmZtZBTjBmZlaEE8yzIOkTktZLukfSWkkndLpNIyVpR+5DY5rW6Ta1QtJLJV0n6d8l3SfpG5J+b4h1p0m6d4hlt0tqy6mczd43kj4m6YXt2P5oqr1v7pX0NUkv2c36XZIuHIVtfWU0/l6SzpH0tt2s85eSFuT8qZJe1kK9A9aTdFmpK4lI+nmTbX9+N2XeLenMnD9b0hkl2rbfDvKXJum1wDuBP4yIbZIOBZ7f4WY9G7+KiGM73Yg9IUnAjcCyiOjO2LHA4cD/62DThjTM++Z64EvAL/egrjERsaNMS1v22/eNpGXA6cCSoVaOiF6gdxS2dQ3wl8A/NhaO5O8REZ9sYZ0v1J6eCtzL7n/yMGC9xg++9xYRsYI2nFXrHszITQaeiIhtABHxREQ8JulhSX8n6QeS1kn6fQBJEyX9S35r/b6kV2V8naSXqPJk7ZvS1bv7ZlWapGOzrfdIulHShIwfn7E7JX1qqF5BG7wF+E39AyAi1gLfbbQr/77vHVxQ0rjs+dwj6XpgXJvavMv7BpgPvAy4TdJt2b5Tsu33Sjq/1u6f57fu1cBr8/n5ku6W9G+SZmZv7EFJ727TPjXcCUzJds6UdIekH+bjKzL+Zklfz/mzJS2ttfcje7Ct/wscmfXdJunLwDpJY/K1vytf2w82Ckj6eP5NfyTpvIxdqeqqH+T/7vmS1uR0ZK2dZ+R6XcA12ZMaJ+mTua17JV2a/8fN1vttD3k3r+2SbN/3JR0+0heiVue7JK3O1+HfGnWqhV7OqIgITyOYgIOAtVTflC8G3pTxh4EP5/z/orqKM8BFwOKcfyuwNue/ALwDOIbqtztfzPgG4KA27s+O3J+1wI0Zu6e2X+cAn835e4HX5fx5wL0deg0+AlzQJP5nwEqq09MPBx6h+mCf1mgr8FdUp64DvArYDnR1+H1zaM6/LNs8ieoow63ASbksgPfU6gvg7Tl/I/At4ADg1Y33WOH9+Xk+jgG+QnV5JoDxwNicfxvw1Zx/M/D1nD8buAM4kOpyJk8CB7SwrbHATcBpWd8vgOm5bBHwv3P+QKre0nSqi97eAbwwl03MxyuB+bXX4BM5v2BQO8/I+dvr75NGPTl/NfCuIda7nSrp7O61bZT/h8Z+tPAa1P9312b9n89lE9h5tvBfAJ/J+VNr6/x2/0Z7cg9mhCLi58BxVG/oLcD1kk7Nxf+cj3dTfagBvIHqDUhE3AocIulgqm9ib8zpEuCVkqYA/bmNdvlVRByb059k214SEY1ruy8D3qjqGPuLI+KOjH+5jW1s1RuAayNiR0Q8DnwbOH7QOm+kOiRFRNxDlUyL2837puF44PaI2BIR24Frsr1QfZh8tbbur4Fv5vw64NsR8Zucn1ZiHwYZJ2ktVXKYSJXYAQ4GvpK92wuAo4co/68RsS2qntxmqi8Eu9tWL9WH6OUZXxMRD+X8bGBBrrcaOASYQZXkroiIXwJERP8Q27i29vjaYdrS8JbsIayj+uI41H42DPfa/hr4es7XPzt2p/6/eyxQP+w3Fbgl2/c3LbRvVDnBPAv5AXZ7RCwGPkT1zRlgWz7uYOc411DXRvsO8Ec53U71oTOfKvHsjZrtR6esp/qwHqzVNnbkR2DDvG8ahmv/MzFwnOE3kV9Dgf8i33sR8V+0Z4y1MS7yO1RjSadn/Fzgtog4BngX8IIhym+rzdf/X4bcVk4fjuoq6VD1YBpEdQShsd70iPhWxlt5vWOI+V1IegFVL3R+RLwS+CJD72e9fUOpv5a7+1u06iKqnsorgQ+20L5R5QQzQpJeIWlGLXQs8JNhinwH+B9Z9s1Ux+F/FhGPUh0emBERDwLfBc6gwwkmIp4Ctkr6owy9n+rb8VbgaUknZry7Iw2s3AocKOl/NgKSjge2Au/N4/GTqL4hrhlUtv56HEN1mKy4Yd43TwMvzthq4E2SDlV1X6NTqHphe618v3wEOEPSAVQ9mP/Ixae2sSm3AKdlG5D0e5JeRHXo8M+VZ55JmjhE+ffWHu9ssrz+OjU+rJ+QdBDVF8Nm69W1+7Wtvw49BbfTlM8iG7mDgIvykNF2oI/qsMc7h1j/bOAKSfdQnSlUf7FXUx3Dhiqx/B+qRNNpPcAX8p/yQeADGV8IfFHSL6h6XU91onEREZL+BPisqlMun6E6jv4xqtfnR1TfQj8eET/VwFOvL2Hn67GWXRNQKUO9b04Bbpa0KSLeIuks4Daqb7zfiIib2tS+EYuIH0r6EdWXjn8Alkn6K6ovAu1yGdWhpR9IEtURgZMi4puqzjDslfRr4BvA3zYpf6CqEyieR/WaDHYl1f/Er6gOoX2R6nDkw1RjqEOtB0BEbGrza3s21aHK/wC+TzUe1Ta+VIztMUkHNcaH8oN9ckR8tMPNMntWJD1MNTC/r973Za/jHoyNxDvyW9hYqsM7p3a2OWa2N3IPxszMivAgv5mZFeEEY2ZmRTjBmJlZER7kN+sASYcAq/LpS6l+WLcln8+s/YjQbJ/lQX6zDpN0NtV1tj7d6baYjSYfIjPbO4yT9FDtF+jj8+q+B+SVeD+r6qrE90qameu8SNXViO/Kq+XO6+wumA3kBGO2d/gV1VUR3pHPu6muQPybfP6iiHgd1RW6l2bsE8CtEXE81a0LPpWXRTHbKzjBmO09LmPn5Xg+AFxRW3YtQER8Bxifl5qZDZyZVw6+neraWC9vU1vNdsuD/GZ7iYj4nqrbOr8JGBMR9Ru5DR4sDaprWf1ZRDzQtkaa7QH3YMz2LldR9VauGBR/L4CkNwBP5dWLbwE+nBd1RNJr2tlQs91xgjHbu1xDdRfCawfFt0q6g+oOqAszdi7V3SvvyRt7ndu2Vpq1wKcpm+1F8n7u8yLi/bXY7VS3tO3tWMPMRsBjMGZ7CUkXUd07/o873Raz0eAejJmZFeExGDMzK8IJxszMinCCMTOzIpxgzMysCCcYMzMr4v8DKLLzPT7qP98AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "### Visualize the Unique counts\n",
    "sns.countplot(weather_data['Type']).unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "8d6dd764",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Unnamed: 0              0\n",
       "EventId                 0\n",
       "Type                    0\n",
       "Severity                0\n",
       "StartTime(UTC)          0\n",
       "EndTime(UTC)            0\n",
       "Precipitation(in)       0\n",
       "TimeZone                0\n",
       "AirportCode             0\n",
       "LocationLat             0\n",
       "LocationLng             0\n",
       "City                 1530\n",
       "County                  0\n",
       "State                   0\n",
       "ZipCode              8497\n",
       "dtype: int64"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "### Find the Null values\n",
    "weather_data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "1e060ee2",
   "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>Precipitation(in)</th>\n",
       "      <th>LocationLat</th>\n",
       "      <th>LocationLng</th>\n",
       "      <th>ZipCode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.001700</td>\n",
       "      <td>-0.037486</td>\n",
       "      <td>-0.043632</td>\n",
       "      <td>0.040073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Precipitation(in)</th>\n",
       "      <td>0.001700</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.005381</td>\n",
       "      <td>0.010087</td>\n",
       "      <td>-0.007616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LocationLat</th>\n",
       "      <td>-0.037486</td>\n",
       "      <td>-0.005381</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.171228</td>\n",
       "      <td>0.029786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LocationLng</th>\n",
       "      <td>-0.043632</td>\n",
       "      <td>0.010087</td>\n",
       "      <td>-0.171228</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.920196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZipCode</th>\n",
       "      <td>0.040073</td>\n",
       "      <td>-0.007616</td>\n",
       "      <td>0.029786</td>\n",
       "      <td>-0.920196</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Unnamed: 0  Precipitation(in)  LocationLat  LocationLng  \\\n",
       "Unnamed: 0           1.000000           0.001700    -0.037486    -0.043632   \n",
       "Precipitation(in)    0.001700           1.000000    -0.005381     0.010087   \n",
       "LocationLat         -0.037486          -0.005381     1.000000    -0.171228   \n",
       "LocationLng         -0.043632           0.010087    -0.171228     1.000000   \n",
       "ZipCode              0.040073          -0.007616     0.029786    -0.920196   \n",
       "\n",
       "                    ZipCode  \n",
       "Unnamed: 0         0.040073  \n",
       "Precipitation(in) -0.007616  \n",
       "LocationLat        0.029786  \n",
       "LocationLng       -0.920196  \n",
       "ZipCode            1.000000  "
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "### Correlation Plot - EDA\n",
    "weather_data.corr()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "9d260f48",
   "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>EventId</th>\n",
       "      <th>Type</th>\n",
       "      <th>Severity</th>\n",
       "      <th>StartTime(UTC)</th>\n",
       "      <th>EndTime(UTC)</th>\n",
       "      <th>Precipitation(in)</th>\n",
       "      <th>TimeZone</th>\n",
       "      <th>AirportCode</th>\n",
       "      <th>LocationLat</th>\n",
       "      <th>LocationLng</th>\n",
       "      <th>City</th>\n",
       "      <th>County</th>\n",
       "      <th>State</th>\n",
       "      <th>ZipCode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>W-1</td>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-06 23:14:00</td>\n",
       "      <td>2016-01-07 00:34:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>US/Mountain</td>\n",
       "      <td>K04V</td>\n",
       "      <td>38.0972</td>\n",
       "      <td>-106.1689</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "      <td>81149.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>W-2</td>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-07 04:14:00</td>\n",
       "      <td>2016-01-07 04:54:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>US/Mountain</td>\n",
       "      <td>K04V</td>\n",
       "      <td>38.0972</td>\n",
       "      <td>-106.1689</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "      <td>81149.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>W-3</td>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-07 05:54:00</td>\n",
       "      <td>2016-01-07 15:34:00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>US/Mountain</td>\n",
       "      <td>K04V</td>\n",
       "      <td>38.0972</td>\n",
       "      <td>-106.1689</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "      <td>81149.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>W-4</td>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-08 05:34:00</td>\n",
       "      <td>2016-01-08 05:54:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>US/Mountain</td>\n",
       "      <td>K04V</td>\n",
       "      <td>38.0972</td>\n",
       "      <td>-106.1689</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "      <td>81149.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>W-5</td>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-08 13:54:00</td>\n",
       "      <td>2016-01-08 15:54:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>US/Mountain</td>\n",
       "      <td>K04V</td>\n",
       "      <td>38.0972</td>\n",
       "      <td>-106.1689</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "      <td>81149.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0 EventId  Type Severity       StartTime(UTC)  \\\n",
       "0           0     W-1  Snow    Light  2016-01-06 23:14:00   \n",
       "1           1     W-2  Snow    Light  2016-01-07 04:14:00   \n",
       "2           2     W-3  Snow    Light  2016-01-07 05:54:00   \n",
       "3           3     W-4  Snow    Light  2016-01-08 05:34:00   \n",
       "4           4     W-5  Snow    Light  2016-01-08 13:54:00   \n",
       "\n",
       "          EndTime(UTC)  Precipitation(in)     TimeZone AirportCode  \\\n",
       "0  2016-01-07 00:34:00               0.00  US/Mountain        K04V   \n",
       "1  2016-01-07 04:54:00               0.00  US/Mountain        K04V   \n",
       "2  2016-01-07 15:34:00               0.03  US/Mountain        K04V   \n",
       "3  2016-01-08 05:54:00               0.00  US/Mountain        K04V   \n",
       "4  2016-01-08 15:54:00               0.00  US/Mountain        K04V   \n",
       "\n",
       "   LocationLat  LocationLng      City    County State  ZipCode  \n",
       "0      38.0972    -106.1689  Saguache  Saguache    CO  81149.0  \n",
       "1      38.0972    -106.1689  Saguache  Saguache    CO  81149.0  \n",
       "2      38.0972    -106.1689  Saguache  Saguache    CO  81149.0  \n",
       "3      38.0972    -106.1689  Saguache  Saguache    CO  81149.0  \n",
       "4      38.0972    -106.1689  Saguache  Saguache    CO  81149.0  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weather_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "a8f7ad07",
   "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>Type</th>\n",
       "      <th>Severity</th>\n",
       "      <th>StartTime(UTC)</th>\n",
       "      <th>EndTime(UTC)</th>\n",
       "      <th>Precipitation(in)</th>\n",
       "      <th>AirportCode</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-06 23:14:00</td>\n",
       "      <td>2016-01-07 00:34:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>K04V</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-07 04:14:00</td>\n",
       "      <td>2016-01-07 04:54:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>K04V</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-07 05:54:00</td>\n",
       "      <td>2016-01-07 15:34:00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>K04V</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-08 05:34:00</td>\n",
       "      <td>2016-01-08 05:54:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>K04V</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-08 13:54:00</td>\n",
       "      <td>2016-01-08 15:54:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>K04V</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Type Severity       StartTime(UTC)         EndTime(UTC)  Precipitation(in)  \\\n",
       "0  Snow    Light  2016-01-06 23:14:00  2016-01-07 00:34:00               0.00   \n",
       "1  Snow    Light  2016-01-07 04:14:00  2016-01-07 04:54:00               0.00   \n",
       "2  Snow    Light  2016-01-07 05:54:00  2016-01-07 15:34:00               0.03   \n",
       "3  Snow    Light  2016-01-08 05:34:00  2016-01-08 05:54:00               0.00   \n",
       "4  Snow    Light  2016-01-08 13:54:00  2016-01-08 15:54:00               0.00   \n",
       "\n",
       "  AirportCode      City State  \n",
       "0        K04V  Saguache    CO  \n",
       "1        K04V  Saguache    CO  \n",
       "2        K04V  Saguache    CO  \n",
       "3        K04V  Saguache    CO  \n",
       "4        K04V  Saguache    CO  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "### Removing unnecessary columns\n",
    "Reduced_df = weather_data.drop(['Unnamed: 0', 'EventId','TimeZone','LocationLat','LocationLng','County','ZipCode'], axis=1)\n",
    "Reduced_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "32ef1c00",
   "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>Type</th>\n",
       "      <th>Severity</th>\n",
       "      <th>StartTime_UTC</th>\n",
       "      <th>EndTime_UTC</th>\n",
       "      <th>Precipitation_in</th>\n",
       "      <th>AirportCode</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-06 23:14:00</td>\n",
       "      <td>2016-01-07 00:34:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>K04V</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-07 04:14:00</td>\n",
       "      <td>2016-01-07 04:54:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>K04V</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-07 05:54:00</td>\n",
       "      <td>2016-01-07 15:34:00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>K04V</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-08 05:34:00</td>\n",
       "      <td>2016-01-08 05:54:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>K04V</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Snow</td>\n",
       "      <td>Light</td>\n",
       "      <td>2016-01-08 13:54:00</td>\n",
       "      <td>2016-01-08 15:54:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>K04V</td>\n",
       "      <td>Saguache</td>\n",
       "      <td>CO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Type Severity        StartTime_UTC          EndTime_UTC  Precipitation_in  \\\n",
       "0  Snow    Light  2016-01-06 23:14:00  2016-01-07 00:34:00              0.00   \n",
       "1  Snow    Light  2016-01-07 04:14:00  2016-01-07 04:54:00              0.00   \n",
       "2  Snow    Light  2016-01-07 05:54:00  2016-01-07 15:34:00              0.03   \n",
       "3  Snow    Light  2016-01-08 05:34:00  2016-01-08 05:54:00              0.00   \n",
       "4  Snow    Light  2016-01-08 13:54:00  2016-01-08 15:54:00              0.00   \n",
       "\n",
       "  AirportCode      City State  \n",
       "0        K04V  Saguache    CO  \n",
       "1        K04V  Saguache    CO  \n",
       "2        K04V  Saguache    CO  \n",
       "3        K04V  Saguache    CO  \n",
       "4        K04V  Saguache    CO  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "### Rename the coolumns\n",
    "Reduced_df.rename(\n",
    "    columns={\"StartTime(UTC)\": \"StartTime_UTC\", \"EndTime(UTC)\": \"EndTime_UTC\", \"Precipitation(in)\": \"Precipitation_in\"},\n",
    "    inplace=True,\n",
    ")\n",
    "Reduced_df.head()"
   ]
  }
 ],
 "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}