Airplane_Crashes_and_Fatalities.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "collapsed_sections": [],
      "authorship_tag": "ABX9TyM6KHthYXSYG99GggiWr0qL",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Shivang2003/Data-Analysis-Projects/blob/main/Airplane_Crashes_and_Fatalities.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 22,
      "metadata": {
        "id": "YFalV3iOh2G1"
      },
      "outputs": [],
      "source": [
        "%matplotlib inline\n",
        "import matplotlib.pyplot as plt\n",
        "import seaborn as sns\n",
        "import numpy as np\n",
        "import pandas as pd\n",
        "import io"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "**READING CSV FILE :**"
      ],
      "metadata": {
        "id": "gGhb9xEvU54q"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data=pd.read_csv('Airplane_Crashes_and_Fatalities_Since_1908.csv')\n",
        "print(data)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ceZTlNHMjmbv",
        "outputId": "2ddeb102-8e9e-419b-f3da-b662ad206ed1"
      },
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "      index        Date   Time  \\\n",
            "0         0  09/17/1908  17:18   \n",
            "1         1  07/12/1912  06:30   \n",
            "2         2  08/06/1913    NaN   \n",
            "3         3  09/09/1913  18:30   \n",
            "4         4  10/17/1913  10:30   \n",
            "...     ...         ...    ...   \n",
            "5263   5263  05/20/2009  06:30   \n",
            "5264   5264  05/26/2009    NaN   \n",
            "5265   5265  06/01/2009  00:15   \n",
            "5266   5266  06/07/2009  08:30   \n",
            "5267   5267  06/08/2009    NaN   \n",
            "\n",
            "                                               Location  \\\n",
            "0                                   Fort Myer, Virginia   \n",
            "1                               AtlantiCity, New Jersey   \n",
            "2                    Victoria, British Columbia, Canada   \n",
            "3                                    Over the North Sea   \n",
            "4                            Near Johannisthal, Germany   \n",
            "...                                                 ...   \n",
            "5263                             Near Madiun, Indonesia   \n",
            "5264                  Near Isiro, DemocratiRepubliCongo   \n",
            "5265  AtlantiOcean, 570 miles northeast of Natal, Br...   \n",
            "5266       Near Port Hope Simpson, Newfoundland, Canada   \n",
            "5267                  State of Arunachal Pradesh, India   \n",
            "\n",
            "                             Operator Flight #  \\\n",
            "0                Military - U.S. Army      NaN   \n",
            "1                Military - U.S. Navy      NaN   \n",
            "2                             Private        -   \n",
            "3              Military - German Navy      NaN   \n",
            "4              Military - German Navy      NaN   \n",
            "...                               ...      ...   \n",
            "5263  Military - Indonesian Air Force      NaN   \n",
            "5264                      Service Air      NaN   \n",
            "5265                       Air France      447   \n",
            "5266                       Strait Air      NaN   \n",
            "5267      Military - Indian Air Force      NaN   \n",
            "\n",
            "                                          Route  \\\n",
            "0                                 Demonstration   \n",
            "1                                   Test flight   \n",
            "2                                           NaN   \n",
            "3                                           NaN   \n",
            "4                                           NaN   \n",
            "...                                         ...   \n",
            "5263                           Jakarta - Maduin   \n",
            "5264                               Goma - Isiro   \n",
            "5265                     Rio de Janeiro - Paris   \n",
            "5266  Lourdes de BlanSablon - Port Hope Simpson   \n",
            "5267                         Mechuka for Jorhat   \n",
            "\n",
            "                                  Type Registration cn/In  Aboard  Fatalities  \\\n",
            "0                     Wright Flyer III          NaN     1     2.0         1.0   \n",
            "1                            Dirigible          NaN   NaN     5.0         5.0   \n",
            "2                     Curtiss seaplane          NaN   NaN     1.0         1.0   \n",
            "3               Zeppelin L-1 (airship)          NaN   NaN    20.0        14.0   \n",
            "4               Zeppelin L-2 (airship)          NaN   NaN    30.0        30.0   \n",
            "...                                ...          ...   ...     ...         ...   \n",
            "5263           Lockheed C-130 Hercules       A-1325  1982   112.0        98.0   \n",
            "5264                     Antonov An-26       9Q-CSA  5005     4.0         4.0   \n",
            "5265                   Airbus A330-203       F-GZCP   660   228.0       228.0   \n",
            "5266  Britten-Norman BN-2A-27 Islander      C-FJJR    424     1.0         1.0   \n",
            "5267                     Antonov An-32          NaN   NaN    13.0        13.0   \n",
            "\n",
            "      Ground                                            Summary  \n",
            "0        0.0  During a demonstration flight, a U.S. Army fly...  \n",
            "1        0.0  First U.S. dirigible Akron exploded just offsh...  \n",
            "2        0.0  The first fatal airplane accident in Canada oc...  \n",
            "3        0.0  The airship flew into a thunderstorm and encou...  \n",
            "4        0.0  Hydrogen gas which was being vented was sucked...  \n",
            "...      ...                                                ...  \n",
            "5263     2.0  While on approach, the military transport cras...  \n",
            "5264     NaN  The cargo plane crashed while on approach to I...  \n",
            "5265     0.0  The Airbus went missing over the AtlantiOcean ...  \n",
            "5266     0.0  The air ambulance crashed into hills while att...  \n",
            "5267     0.0  The military transport went missing while en r...  \n",
            "\n",
            "[5268 rows x 14 columns]\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "WIjcyJ-9jwHn",
        "outputId": "f956219b-8763-4eca-b4c0-7e1b73a267a5"
      },
      "execution_count": 24,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 5268 entries, 0 to 5267\n",
            "Data columns (total 14 columns):\n",
            " #   Column        Non-Null Count  Dtype  \n",
            "---  ------        --------------  -----  \n",
            " 0   index         5268 non-null   int64  \n",
            " 1   Date          5268 non-null   object \n",
            " 2   Time          3049 non-null   object \n",
            " 3   Location      5248 non-null   object \n",
            " 4   Operator      5250 non-null   object \n",
            " 5   Flight #      1069 non-null   object \n",
            " 6   Route         3562 non-null   object \n",
            " 7   Type          5241 non-null   object \n",
            " 8   Registration  4933 non-null   object \n",
            " 9   cn/In         4040 non-null   object \n",
            " 10  Aboard        5246 non-null   float64\n",
            " 11  Fatalities    5256 non-null   float64\n",
            " 12  Ground        5246 non-null   float64\n",
            " 13  Summary       4878 non-null   object \n",
            "dtypes: float64(3), int64(1), object(10)\n",
            "memory usage: 576.3+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "**CHECKING NULL VALUES :**"
      ],
      "metadata": {
        "id": "C_a12bqJzBos"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data[data.Date.isnull()]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 93
        },
        "id": "H7lYep5TkNug",
        "outputId": "f6f1732f-8f2a-490b-b958-203fb7b4342c"
      },
      "execution_count": 25,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Empty DataFrame\n",
              "Columns: [index, Date, Time, Location, Operator, Flight #, Route, Type, Registration, cn/In, Aboard, Fatalities, Ground, Summary]\n",
              "Index: []"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-527d3ace-3da0-4820-9f7e-86b154d3c13a\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>index</th>\n",
              "      <th>Date</th>\n",
              "      <th>Time</th>\n",
              "      <th>Location</th>\n",
              "      <th>Operator</th>\n",
              "      <th>Flight #</th>\n",
              "      <th>Route</th>\n",
              "      <th>Type</th>\n",
              "      <th>Registration</th>\n",
              "      <th>cn/In</th>\n",
              "      <th>Aboard</th>\n",
              "      <th>Fatalities</th>\n",
              "      <th>Ground</th>\n",
              "      <th>Summary</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-527d3ace-3da0-4820-9f7e-86b154d3c13a')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-527d3ace-3da0-4820-9f7e-86b154d3c13a button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-527d3ace-3da0-4820-9f7e-86b154d3c13a');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data[data.Location.isnull()]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "mWLBeFIhlBl5",
        "outputId": "168f09cd-95d7-47ff-f73c-03312afa777a"
      },
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      index        Date   Time Location  \\\n",
              "142     142  05/07/1928    NaN      NaN   \n",
              "411     411  10/09/1936    NaN      NaN   \n",
              "564     564  10/28/1941    NaN      NaN   \n",
              "573     573  02/14/1942    NaN      NaN   \n",
              "588     588  08/21/1942    NaN      NaN   \n",
              "596     596  10/22/1942    NaN      NaN   \n",
              "704     704  04/20/1945    NaN      NaN   \n",
              "904     904  11/27/1947    NaN      NaN   \n",
              "1500   1500  09/28/1957    NaN      NaN   \n",
              "1916   1916  05/27/1964    NaN      NaN   \n",
              "1918   1918  06/13/1964    NaN      NaN   \n",
              "1978   1978  05/05/1965  21:17      NaN   \n",
              "2914   2914  08/09/1976    NaN      NaN   \n",
              "2953   2953  01/20/1977    NaN      NaN   \n",
              "3868   3868  08/15/1989    NaN      NaN   \n",
              "3880   3880  09/21/1989    NaN      NaN   \n",
              "4034   4034  08/15/1991    NaN      NaN   \n",
              "4043   4043  09/17/1991    NaN      NaN   \n",
              "4975   4975  03/04/2004  09:40      NaN   \n",
              "5039   5039  02/22/2005  07:15      NaN   \n",
              "\n",
              "                                    Operator Flight #                   Route  \\\n",
              "142                              Aeropostale      NaN                     NaN   \n",
              "411   North Sea Aerial and General Transport      NaN                     NaN   \n",
              "564                       Deutsche Lufthansa      NaN                     NaN   \n",
              "573      China National Aviation Corporation      NaN                     NaN   \n",
              "588                       Deutsche Lufthansa      NaN                     NaN   \n",
              "596                       Deutsche Lufthansa     7208                     NaN   \n",
              "704                                      NaN      NaN                     NaN   \n",
              "904      China National Aviation Corporation      NaN                     NaN   \n",
              "1500                British European Airways      NaN                     NaN   \n",
              "1916                                    VASP      NaN                Training   \n",
              "1918                  Saudi Arabian Airlines      NaN                Training   \n",
              "1978                         Iberia Airlines      401       Madrid - Tenerife   \n",
              "2914            Military - Spanish Air Force      NaN  Moron - Canary Islands   \n",
              "2953                        North Canada Air      NaN                     NaN   \n",
              "3868                  China Eastern Airlines      NaN     Shanghai - Hongqiao   \n",
              "3880  Military - Afghan Republican Air Force      NaN                     NaN   \n",
              "4034  Transports Aériens de la Guinee-Bissau      NaN           Kano - Bamako   \n",
              "4043                      Ethiopian Airlines      NaN                     NaN   \n",
              "4975                      Azov Avia Airlines      NaN   Ankara - Baku - Kabul   \n",
              "5039              Indonesian National Police      NaN        Jayapura - Sarmi   \n",
              "\n",
              "                                       Type Registration       cn/In  Aboard  \\\n",
              "142                            Latecoere 26       F-AIMQ         NaN     1.0   \n",
              "411                           Blackburn B-2       G-ABWI         NaN     1.0   \n",
              "564                        Junkers JU-53/3m       D-AUXZ        7172    13.0   \n",
              "573                            Douglas DC-2           45         NaN     NaN   \n",
              "588                           Siebel Si-204          NaN         NaN     4.0   \n",
              "596                        Junkers JU-52/3m       D-AYGX        7208    17.0   \n",
              "704                        Junkers JU-53/3m       D-ANAJ         NaN    18.0   \n",
              "904                            Douglas DC-3          NaN         NaN     3.0   \n",
              "1500              de Havilland DH-114 Heron       G-AOFY       14099     3.0   \n",
              "1916                        Douglas C-47-DL       PP-SPZ        4649     3.0   \n",
              "1918                          Douglas C-47A       HZ-AAN       12899     2.0   \n",
              "1978  Lockheed 1049G-55 Super Constellation       EC-AIN        4550    49.0   \n",
              "2914                          Douglas C-54E    T4/11-352       27344    33.0   \n",
              "2953              Bristol 170 Freighter 31M       C-FWAD       13253     2.0   \n",
              "3868                        Antonov AN-24RV       B-3417    37309006    40.0   \n",
              "3880                  Mil Mi-8 (helicopter)          NaN         NaN    26.0   \n",
              "4034             Fokker F-27 Friendship 100       J5-GBB       10119     3.0   \n",
              "4043             Lockheed L-100-30 Hercules       ET-AJL        5029     4.0   \n",
              "4975                         Ilyushin II-76       UR-ZVA  0063468036     7.0   \n",
              "5039                       CASA 212 Aviocar          NaN         NaN    18.0   \n",
              "\n",
              "      Fatalities  Ground                                            Summary  \n",
              "142          1.0     0.0                                                NaN  \n",
              "411          1.0     0.0                                                NaN  \n",
              "564         13.0     0.0                                                NaN  \n",
              "573          NaN     NaN                                                NaN  \n",
              "588          4.0     0.0            Lufthansa chairman, Von Gablenz killed.  \n",
              "596         17.0     0.0                                                NaN  \n",
              "704         18.0     0.0  Missing on an evacuation flight from Berlin to...  \n",
              "904          2.0     0.0  The cargo plane was shot down by communist ant...  \n",
              "1500         3.0     0.0  The pilot did not appreciate that the air ambu...  \n",
              "1916         3.0     0.0                                                NaN  \n",
              "1918         2.0     0.0                          Crashed into the Red Sea.  \n",
              "1978        30.0     0.0  The pilot, who saw the beginning of the runway...  \n",
              "2914        11.0     0.0               Crashed 15 minutes after taking off.  \n",
              "2953         1.0     0.0  The cargo plane stalled nearly vertical and cr...  \n",
              "3868        34.0     0.0  Lost power and crashed into a river shortly af...  \n",
              "3880        26.0     0.0                                                NaN  \n",
              "4034         3.0     0.0  On a positioning flight the plane struck trees...  \n",
              "4043         4.0     0.0  After experiencing a nose gear problem and att...  \n",
              "4975         3.0     0.0  Shortly after taking off and climbing to about...  \n",
              "5039        15.0     0.0  On final approach, the aircraft crashed into t...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-13ac9ee5-fd47-4fd0-8793-130ed2cf0014\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>index</th>\n",
              "      <th>Date</th>\n",
              "      <th>Time</th>\n",
              "      <th>Location</th>\n",
              "      <th>Operator</th>\n",
              "      <th>Flight #</th>\n",
              "      <th>Route</th>\n",
              "      <th>Type</th>\n",
              "      <th>Registration</th>\n",
              "      <th>cn/In</th>\n",
              "      <th>Aboard</th>\n",
              "      <th>Fatalities</th>\n",
              "      <th>Ground</th>\n",
              "      <th>Summary</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>142</th>\n",
              "      <td>142</td>\n",
              "      <td>05/07/1928</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Aeropostale</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Latecoere 26</td>\n",
              "      <td>F-AIMQ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>411</th>\n",
              "      <td>411</td>\n",
              "      <td>10/09/1936</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>North Sea Aerial and General Transport</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Blackburn B-2</td>\n",
              "      <td>G-ABWI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>564</th>\n",
              "      <td>564</td>\n",
              "      <td>10/28/1941</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Deutsche Lufthansa</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Junkers JU-53/3m</td>\n",
              "      <td>D-AUXZ</td>\n",
              "      <td>7172</td>\n",
              "      <td>13.0</td>\n",
              "      <td>13.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>573</th>\n",
              "      <td>573</td>\n",
              "      <td>02/14/1942</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>China National Aviation Corporation</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Douglas DC-2</td>\n",
              "      <td>45</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>588</th>\n",
              "      <td>588</td>\n",
              "      <td>08/21/1942</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Deutsche Lufthansa</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Siebel Si-204</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Lufthansa chairman, Von Gablenz killed.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>596</th>\n",
              "      <td>596</td>\n",
              "      <td>10/22/1942</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Deutsche Lufthansa</td>\n",
              "      <td>7208</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Junkers JU-52/3m</td>\n",
              "      <td>D-AYGX</td>\n",
              "      <td>7208</td>\n",
              "      <td>17.0</td>\n",
              "      <td>17.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>704</th>\n",
              "      <td>704</td>\n",
              "      <td>04/20/1945</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Junkers JU-53/3m</td>\n",
              "      <td>D-ANAJ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Missing on an evacuation flight from Berlin to...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>904</th>\n",
              "      <td>904</td>\n",
              "      <td>11/27/1947</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>China National Aviation Corporation</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Douglas DC-3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The cargo plane was shot down by communist ant...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1500</th>\n",
              "      <td>1500</td>\n",
              "      <td>09/28/1957</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>British European Airways</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>de Havilland DH-114 Heron</td>\n",
              "      <td>G-AOFY</td>\n",
              "      <td>14099</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The pilot did not appreciate that the air ambu...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1916</th>\n",
              "      <td>1916</td>\n",
              "      <td>05/27/1964</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>VASP</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Training</td>\n",
              "      <td>Douglas C-47-DL</td>\n",
              "      <td>PP-SPZ</td>\n",
              "      <td>4649</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1918</th>\n",
              "      <td>1918</td>\n",
              "      <td>06/13/1964</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Saudi Arabian Airlines</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Training</td>\n",
              "      <td>Douglas C-47A</td>\n",
              "      <td>HZ-AAN</td>\n",
              "      <td>12899</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Crashed into the Red Sea.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1978</th>\n",
              "      <td>1978</td>\n",
              "      <td>05/05/1965</td>\n",
              "      <td>21:17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Iberia Airlines</td>\n",
              "      <td>401</td>\n",
              "      <td>Madrid - Tenerife</td>\n",
              "      <td>Lockheed 1049G-55 Super Constellation</td>\n",
              "      <td>EC-AIN</td>\n",
              "      <td>4550</td>\n",
              "      <td>49.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The pilot, who saw the beginning of the runway...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2914</th>\n",
              "      <td>2914</td>\n",
              "      <td>08/09/1976</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Military - Spanish Air Force</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Moron - Canary Islands</td>\n",
              "      <td>Douglas C-54E</td>\n",
              "      <td>T4/11-352</td>\n",
              "      <td>27344</td>\n",
              "      <td>33.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Crashed 15 minutes after taking off.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2953</th>\n",
              "      <td>2953</td>\n",
              "      <td>01/20/1977</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>North Canada Air</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Bristol 170 Freighter 31M</td>\n",
              "      <td>C-FWAD</td>\n",
              "      <td>13253</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The cargo plane stalled nearly vertical and cr...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3868</th>\n",
              "      <td>3868</td>\n",
              "      <td>08/15/1989</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>China Eastern Airlines</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Shanghai - Hongqiao</td>\n",
              "      <td>Antonov AN-24RV</td>\n",
              "      <td>B-3417</td>\n",
              "      <td>37309006</td>\n",
              "      <td>40.0</td>\n",
              "      <td>34.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Lost power and crashed into a river shortly af...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3880</th>\n",
              "      <td>3880</td>\n",
              "      <td>09/21/1989</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Military - Afghan Republican Air Force</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Mil Mi-8 (helicopter)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>26.0</td>\n",
              "      <td>26.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4034</th>\n",
              "      <td>4034</td>\n",
              "      <td>08/15/1991</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Transports Aériens de la Guinee-Bissau</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Kano - Bamako</td>\n",
              "      <td>Fokker F-27 Friendship 100</td>\n",
              "      <td>J5-GBB</td>\n",
              "      <td>10119</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>On a positioning flight the plane struck trees...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4043</th>\n",
              "      <td>4043</td>\n",
              "      <td>09/17/1991</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Ethiopian Airlines</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Lockheed L-100-30 Hercules</td>\n",
              "      <td>ET-AJL</td>\n",
              "      <td>5029</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>After experiencing a nose gear problem and att...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4975</th>\n",
              "      <td>4975</td>\n",
              "      <td>03/04/2004</td>\n",
              "      <td>09:40</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Azov Avia Airlines</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Ankara - Baku - Kabul</td>\n",
              "      <td>Ilyushin II-76</td>\n",
              "      <td>UR-ZVA</td>\n",
              "      <td>0063468036</td>\n",
              "      <td>7.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Shortly after taking off and climbing to about...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5039</th>\n",
              "      <td>5039</td>\n",
              "      <td>02/22/2005</td>\n",
              "      <td>07:15</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Indonesian National Police</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Jayapura - Sarmi</td>\n",
              "      <td>CASA 212 Aviocar</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>On final approach, the aircraft crashed into t...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-13ac9ee5-fd47-4fd0-8793-130ed2cf0014')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-13ac9ee5-fd47-4fd0-8793-130ed2cf0014 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-13ac9ee5-fd47-4fd0-8793-130ed2cf0014');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data[data.Operator.isnull()]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "24619aaWlEaP",
        "outputId": "3fb03eeb-195b-4ec1-ede4-96accc83c745"
      },
      "execution_count": 27,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      index        Date   Time                                  Location  \\\n",
              "61       61  04/08/1922    NaN                       Pao Ting Fou, China   \n",
              "67       67  10/02/1922    NaN                             Venice, Italy   \n",
              "106     106  09/26/1926    NaN                        New York, New York   \n",
              "138     138  03/03/1928    NaN                    Rio de Janeiro, Brazil   \n",
              "164     164  12/04/1928    NaN                    Rio de Janeiro, Brazil   \n",
              "359     359  05/29/1935    NaN                      San Barbra, Honduras   \n",
              "482     482  08/10/1938    NaN                         Debrecen, Hungary   \n",
              "545     545  11/09/1940    NaN                    Rio de Janeiro, Brazil   \n",
              "618     618  07/04/1943  23:00                                 Gibraltar   \n",
              "704     704  04/20/1945    NaN                                       NaN   \n",
              "772     772  04/08/1946    NaN                        Near Shensi, China   \n",
              "975     975  12/06/1948    NaN                              Milan, Italy   \n",
              "2041   2041  03/10/1966  17:14                       Reef Island, Alaska   \n",
              "2775   2775  11/07/1974    NaN                   Off Sonderborg, Denmark   \n",
              "3176   3176  10/27/1979  23:46               Near San Ysidro, California   \n",
              "4525   4525  10/30/1997    NaN            Near La Roche, Alberta, Canada   \n",
              "4602   4602  11/27/1998    NaN                     King Island, Tasmania   \n",
              "5140   5140  03/14/2007    NaN  Fazenda Nossa Senhora de Lourdes, Brazil   \n",
              "\n",
              "     Operator Flight #                              Route  \\\n",
              "61        NaN      NaN                                NaN   \n",
              "67        NaN      NaN                                NaN   \n",
              "106       NaN      NaN                   New York - Paris   \n",
              "138       NaN      NaN                                NaN   \n",
              "164       NaN      NaN                                NaN   \n",
              "359       NaN      NaN                                NaN   \n",
              "482       NaN      NaN                                NaN   \n",
              "545       NaN      NaN         Rio de Janeiro - Sao Paulo   \n",
              "618       NaN      NaN                                NaN   \n",
              "704       NaN      NaN                                NaN   \n",
              "772       NaN      NaN                     Shensi - Yenan   \n",
              "975       NaN      NaN                   Milan - Brussels   \n",
              "2041      NaN      NaN                                NaN   \n",
              "2775      NaN      NaN                                NaN   \n",
              "3176      NaN      NaN  Monterey, Mexico - San Ysidro, CA   \n",
              "4525      NaN      NaN            Fort MMurray - La Loche   \n",
              "4602      NaN      NaN                                NaN   \n",
              "5140      NaN      NaN               Petrolina - Salvador   \n",
              "\n",
              "                                Type Registration cn/In  Aboard  Fatalities  \\\n",
              "61                               NaN          NaN   NaN    17.0        17.0   \n",
              "67                 de Havilland DH-9       G-EAYT   NaN     4.0         4.0   \n",
              "106                    Sikorsky S-25          NaN   NaN     5.0         2.0   \n",
              "138                              NaN          NaN   NaN    10.0        10.0   \n",
              "164                      Junkers G24          NaN   NaN     6.0         6.0   \n",
              "359                              NaN          NaN   NaN     9.0         6.0   \n",
              "482                   Ford Tri-motor          NaN   NaN    12.0        12.0   \n",
              "545                              NaN          NaN   NaN    18.0        18.0   \n",
              "618     Consolidated Liberator B24 C      A-L-523   NaN    13.0        12.0   \n",
              "704                 Junkers JU-53/3m       D-ANAJ   NaN    18.0        18.0   \n",
              "772                              NaN          NaN   NaN    14.0        14.0   \n",
              "975                     Douglas C-47       I-ETNA  4396     7.0         7.0   \n",
              "2041                   Grumman G-21A       CF-MSK  B-32     7.0         6.0   \n",
              "2775   Britten-Norman BN-2A Islander       OY-DVJ   154     3.0         3.0   \n",
              "3176                       Beech 200       XC-PGR   NaN    10.0        10.0   \n",
              "4525               Cessna 206 Seneca       C-GPRL   NaN     6.0         3.0   \n",
              "4602                             NaN          NaN   NaN     6.0         4.0   \n",
              "5140  Rockwell 500S Shrike Commander       PP-SEC   NaN     4.0         4.0   \n",
              "\n",
              "      Ground                                            Summary  \n",
              "61       0.0       All seventeen aboard were Chinese nationals.  \n",
              "67       0.0                                                NaN  \n",
              "106      0.0  Too much weight caused the landing gear to col...  \n",
              "138      0.0                                                NaN  \n",
              "164      0.0  The aircraft's wingtip struck the water and cr...  \n",
              "359      0.0                       Crashed into the Ulua River.  \n",
              "482      0.0      The plane was carrying Hungarian journalists.  \n",
              "545      0.0            Midair collisioin with a private plane.  \n",
              "618      0.0  The flight, bound for London, crashed into the...  \n",
              "704      0.0  Missing on an evacuation flight from Berlin to...  \n",
              "772      0.0                                                NaN  \n",
              "975      0.0        The aircraft crashed during takeoff in fog.  \n",
              "2041     0.0  Undershot the runway on final approach in snow...  \n",
              "2775     0.0                            Ditched into the ocean.  \n",
              "3176     0.0  Crashed while on final approach. The plane hit...  \n",
              "4525     0.0  Crashed while en route. The pilot continued fl...  \n",
              "4602     0.0  Windshear or strong crosswinds caused the airc...  \n",
              "5140     0.0  Fifteen minutes before arriving at its destina...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-77789cbc-f4c8-4d04-8519-8bb4ad33d5ae\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>index</th>\n",
              "      <th>Date</th>\n",
              "      <th>Time</th>\n",
              "      <th>Location</th>\n",
              "      <th>Operator</th>\n",
              "      <th>Flight #</th>\n",
              "      <th>Route</th>\n",
              "      <th>Type</th>\n",
              "      <th>Registration</th>\n",
              "      <th>cn/In</th>\n",
              "      <th>Aboard</th>\n",
              "      <th>Fatalities</th>\n",
              "      <th>Ground</th>\n",
              "      <th>Summary</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>61</th>\n",
              "      <td>61</td>\n",
              "      <td>04/08/1922</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Pao Ting Fou, China</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>17.0</td>\n",
              "      <td>17.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>All seventeen aboard were Chinese nationals.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>67</th>\n",
              "      <td>67</td>\n",
              "      <td>10/02/1922</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Venice, Italy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>de Havilland DH-9</td>\n",
              "      <td>G-EAYT</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>106</th>\n",
              "      <td>106</td>\n",
              "      <td>09/26/1926</td>\n",
              "      <td>NaN</td>\n",
              "      <td>New York, New York</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>New York - Paris</td>\n",
              "      <td>Sikorsky S-25</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Too much weight caused the landing gear to col...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>138</th>\n",
              "      <td>138</td>\n",
              "      <td>03/03/1928</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Rio de Janeiro, Brazil</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>10.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>164</th>\n",
              "      <td>164</td>\n",
              "      <td>12/04/1928</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Rio de Janeiro, Brazil</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Junkers G24</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The aircraft's wingtip struck the water and cr...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>359</th>\n",
              "      <td>359</td>\n",
              "      <td>05/29/1935</td>\n",
              "      <td>NaN</td>\n",
              "      <td>San Barbra, Honduras</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Crashed into the Ulua River.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>482</th>\n",
              "      <td>482</td>\n",
              "      <td>08/10/1938</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Debrecen, Hungary</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Ford Tri-motor</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The plane was carrying Hungarian journalists.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>545</th>\n",
              "      <td>545</td>\n",
              "      <td>11/09/1940</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Rio de Janeiro, Brazil</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Rio de Janeiro - Sao Paulo</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Midair collisioin with a private plane.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>618</th>\n",
              "      <td>618</td>\n",
              "      <td>07/04/1943</td>\n",
              "      <td>23:00</td>\n",
              "      <td>Gibraltar</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Consolidated Liberator B24 C</td>\n",
              "      <td>A-L-523</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The flight, bound for London, crashed into the...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>704</th>\n",
              "      <td>704</td>\n",
              "      <td>04/20/1945</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Junkers JU-53/3m</td>\n",
              "      <td>D-ANAJ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Missing on an evacuation flight from Berlin to...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>772</th>\n",
              "      <td>772</td>\n",
              "      <td>04/08/1946</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Near Shensi, China</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Shensi - Yenan</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>14.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>975</th>\n",
              "      <td>975</td>\n",
              "      <td>12/06/1948</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Milan, Italy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Milan - Brussels</td>\n",
              "      <td>Douglas C-47</td>\n",
              "      <td>I-ETNA</td>\n",
              "      <td>4396</td>\n",
              "      <td>7.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The aircraft crashed during takeoff in fog.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2041</th>\n",
              "      <td>2041</td>\n",
              "      <td>03/10/1966</td>\n",
              "      <td>17:14</td>\n",
              "      <td>Reef Island, Alaska</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Grumman G-21A</td>\n",
              "      <td>CF-MSK</td>\n",
              "      <td>B-32</td>\n",
              "      <td>7.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Undershot the runway on final approach in snow...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2775</th>\n",
              "      <td>2775</td>\n",
              "      <td>11/07/1974</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Off Sonderborg, Denmark</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Britten-Norman BN-2A Islander</td>\n",
              "      <td>OY-DVJ</td>\n",
              "      <td>154</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Ditched into the ocean.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3176</th>\n",
              "      <td>3176</td>\n",
              "      <td>10/27/1979</td>\n",
              "      <td>23:46</td>\n",
              "      <td>Near San Ysidro, California</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Monterey, Mexico - San Ysidro, CA</td>\n",
              "      <td>Beech 200</td>\n",
              "      <td>XC-PGR</td>\n",
              "      <td>NaN</td>\n",
              "      <td>10.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Crashed while on final approach. The plane hit...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4525</th>\n",
              "      <td>4525</td>\n",
              "      <td>10/30/1997</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Near La Roche, Alberta, Canada</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Fort MMurray - La Loche</td>\n",
              "      <td>Cessna 206 Seneca</td>\n",
              "      <td>C-GPRL</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Crashed while en route. The pilot continued fl...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4602</th>\n",
              "      <td>4602</td>\n",
              "      <td>11/27/1998</td>\n",
              "      <td>NaN</td>\n",
              "      <td>King Island, Tasmania</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Windshear or strong crosswinds caused the airc...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5140</th>\n",
              "      <td>5140</td>\n",
              "      <td>03/14/2007</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Fazenda Nossa Senhora de Lourdes, Brazil</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Petrolina - Salvador</td>\n",
              "      <td>Rockwell 500S Shrike Commander</td>\n",
              "      <td>PP-SEC</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Fifteen minutes before arriving at its destina...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-77789cbc-f4c8-4d04-8519-8bb4ad33d5ae')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-77789cbc-f4c8-4d04-8519-8bb4ad33d5ae button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-77789cbc-f4c8-4d04-8519-8bb4ad33d5ae');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 27
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data[data.Registration.isnull()]\n",
        "data"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "DqWFKtj90AJo",
        "outputId": "4048aa26-e156-4ba8-e4ea-c026516f09fd"
      },
      "execution_count": 28,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      index        Date   Time  \\\n",
              "0         0  09/17/1908  17:18   \n",
              "1         1  07/12/1912  06:30   \n",
              "2         2  08/06/1913    NaN   \n",
              "3         3  09/09/1913  18:30   \n",
              "4         4  10/17/1913  10:30   \n",
              "...     ...         ...    ...   \n",
              "5263   5263  05/20/2009  06:30   \n",
              "5264   5264  05/26/2009    NaN   \n",
              "5265   5265  06/01/2009  00:15   \n",
              "5266   5266  06/07/2009  08:30   \n",
              "5267   5267  06/08/2009    NaN   \n",
              "\n",
              "                                               Location  \\\n",
              "0                                   Fort Myer, Virginia   \n",
              "1                               AtlantiCity, New Jersey   \n",
              "2                    Victoria, British Columbia, Canada   \n",
              "3                                    Over the North Sea   \n",
              "4                            Near Johannisthal, Germany   \n",
              "...                                                 ...   \n",
              "5263                             Near Madiun, Indonesia   \n",
              "5264                  Near Isiro, DemocratiRepubliCongo   \n",
              "5265  AtlantiOcean, 570 miles northeast of Natal, Br...   \n",
              "5266       Near Port Hope Simpson, Newfoundland, Canada   \n",
              "5267                  State of Arunachal Pradesh, India   \n",
              "\n",
              "                             Operator Flight #  \\\n",
              "0                Military - U.S. Army      NaN   \n",
              "1                Military - U.S. Navy      NaN   \n",
              "2                             Private        -   \n",
              "3              Military - German Navy      NaN   \n",
              "4              Military - German Navy      NaN   \n",
              "...                               ...      ...   \n",
              "5263  Military - Indonesian Air Force      NaN   \n",
              "5264                      Service Air      NaN   \n",
              "5265                       Air France      447   \n",
              "5266                       Strait Air      NaN   \n",
              "5267      Military - Indian Air Force      NaN   \n",
              "\n",
              "                                          Route  \\\n",
              "0                                 Demonstration   \n",
              "1                                   Test flight   \n",
              "2                                           NaN   \n",
              "3                                           NaN   \n",
              "4                                           NaN   \n",
              "...                                         ...   \n",
              "5263                           Jakarta - Maduin   \n",
              "5264                               Goma - Isiro   \n",
              "5265                     Rio de Janeiro - Paris   \n",
              "5266  Lourdes de BlanSablon - Port Hope Simpson   \n",
              "5267                         Mechuka for Jorhat   \n",
              "\n",
              "                                  Type Registration cn/In  Aboard  Fatalities  \\\n",
              "0                     Wright Flyer III          NaN     1     2.0         1.0   \n",
              "1                            Dirigible          NaN   NaN     5.0         5.0   \n",
              "2                     Curtiss seaplane          NaN   NaN     1.0         1.0   \n",
              "3               Zeppelin L-1 (airship)          NaN   NaN    20.0        14.0   \n",
              "4               Zeppelin L-2 (airship)          NaN   NaN    30.0        30.0   \n",
              "...                                ...          ...   ...     ...         ...   \n",
              "5263           Lockheed C-130 Hercules       A-1325  1982   112.0        98.0   \n",
              "5264                     Antonov An-26       9Q-CSA  5005     4.0         4.0   \n",
              "5265                   Airbus A330-203       F-GZCP   660   228.0       228.0   \n",
              "5266  Britten-Norman BN-2A-27 Islander      C-FJJR    424     1.0         1.0   \n",
              "5267                     Antonov An-32          NaN   NaN    13.0        13.0   \n",
              "\n",
              "      Ground                                            Summary  \n",
              "0        0.0  During a demonstration flight, a U.S. Army fly...  \n",
              "1        0.0  First U.S. dirigible Akron exploded just offsh...  \n",
              "2        0.0  The first fatal airplane accident in Canada oc...  \n",
              "3        0.0  The airship flew into a thunderstorm and encou...  \n",
              "4        0.0  Hydrogen gas which was being vented was sucked...  \n",
              "...      ...                                                ...  \n",
              "5263     2.0  While on approach, the military transport cras...  \n",
              "5264     NaN  The cargo plane crashed while on approach to I...  \n",
              "5265     0.0  The Airbus went missing over the AtlantiOcean ...  \n",
              "5266     0.0  The air ambulance crashed into hills while att...  \n",
              "5267     0.0  The military transport went missing while en r...  \n",
              "\n",
              "[5268 rows x 14 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a5eb8664-ab13-4deb-8af0-ecfa988d9c96\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>index</th>\n",
              "      <th>Date</th>\n",
              "      <th>Time</th>\n",
              "      <th>Location</th>\n",
              "      <th>Operator</th>\n",
              "      <th>Flight #</th>\n",
              "      <th>Route</th>\n",
              "      <th>Type</th>\n",
              "      <th>Registration</th>\n",
              "      <th>cn/In</th>\n",
              "      <th>Aboard</th>\n",
              "      <th>Fatalities</th>\n",
              "      <th>Ground</th>\n",
              "      <th>Summary</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>09/17/1908</td>\n",
              "      <td>17:18</td>\n",
              "      <td>Fort Myer, Virginia</td>\n",
              "      <td>Military - U.S. Army</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Demonstration</td>\n",
              "      <td>Wright Flyer III</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>During a demonstration flight, a U.S. Army fly...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>07/12/1912</td>\n",
              "      <td>06:30</td>\n",
              "      <td>AtlantiCity, New Jersey</td>\n",
              "      <td>Military - U.S. Navy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Test flight</td>\n",
              "      <td>Dirigible</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>First U.S. dirigible Akron exploded just offsh...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>08/06/1913</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Victoria, British Columbia, Canada</td>\n",
              "      <td>Private</td>\n",
              "      <td>-</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Curtiss seaplane</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The first fatal airplane accident in Canada oc...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>09/09/1913</td>\n",
              "      <td>18:30</td>\n",
              "      <td>Over the North Sea</td>\n",
              "      <td>Military - German Navy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Zeppelin L-1 (airship)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>20.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The airship flew into a thunderstorm and encou...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>10/17/1913</td>\n",
              "      <td>10:30</td>\n",
              "      <td>Near Johannisthal, Germany</td>\n",
              "      <td>Military - German Navy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Zeppelin L-2 (airship)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>30.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Hydrogen gas which was being vented was sucked...</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5263</th>\n",
              "      <td>5263</td>\n",
              "      <td>05/20/2009</td>\n",
              "      <td>06:30</td>\n",
              "      <td>Near Madiun, Indonesia</td>\n",
              "      <td>Military - Indonesian Air Force</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Jakarta - Maduin</td>\n",
              "      <td>Lockheed C-130 Hercules</td>\n",
              "      <td>A-1325</td>\n",
              "      <td>1982</td>\n",
              "      <td>112.0</td>\n",
              "      <td>98.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>While on approach, the military transport cras...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5264</th>\n",
              "      <td>5264</td>\n",
              "      <td>05/26/2009</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Near Isiro, DemocratiRepubliCongo</td>\n",
              "      <td>Service Air</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Goma - Isiro</td>\n",
              "      <td>Antonov An-26</td>\n",
              "      <td>9Q-CSA</td>\n",
              "      <td>5005</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>The cargo plane crashed while on approach to I...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5265</th>\n",
              "      <td>5265</td>\n",
              "      <td>06/01/2009</td>\n",
              "      <td>00:15</td>\n",
              "      <td>AtlantiOcean, 570 miles northeast of Natal, Br...</td>\n",
              "      <td>Air France</td>\n",
              "      <td>447</td>\n",
              "      <td>Rio de Janeiro - Paris</td>\n",
              "      <td>Airbus A330-203</td>\n",
              "      <td>F-GZCP</td>\n",
              "      <td>660</td>\n",
              "      <td>228.0</td>\n",
              "      <td>228.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The Airbus went missing over the AtlantiOcean ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5266</th>\n",
              "      <td>5266</td>\n",
              "      <td>06/07/2009</td>\n",
              "      <td>08:30</td>\n",
              "      <td>Near Port Hope Simpson, Newfoundland, Canada</td>\n",
              "      <td>Strait Air</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Lourdes de BlanSablon - Port Hope Simpson</td>\n",
              "      <td>Britten-Norman BN-2A-27 Islander</td>\n",
              "      <td>C-FJJR</td>\n",
              "      <td>424</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The air ambulance crashed into hills while att...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5267</th>\n",
              "      <td>5267</td>\n",
              "      <td>06/08/2009</td>\n",
              "      <td>NaN</td>\n",
              "      <td>State of Arunachal Pradesh, India</td>\n",
              "      <td>Military - Indian Air Force</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Mechuka for Jorhat</td>\n",
              "      <td>Antonov An-32</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13.0</td>\n",
              "      <td>13.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The military transport went missing while en r...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5268 rows × 14 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a5eb8664-ab13-4deb-8af0-ecfa988d9c96')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-a5eb8664-ab13-4deb-8af0-ecfa988d9c96 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-a5eb8664-ab13-4deb-8af0-ecfa988d9c96');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data[data.Time.isnull()]\n",
        "data"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "lZRerCzh08Pj",
        "outputId": "dc4545cd-61ee-40e6-dfdf-cfaf9f239120"
      },
      "execution_count": 29,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      index        Date   Time  \\\n",
              "0         0  09/17/1908  17:18   \n",
              "1         1  07/12/1912  06:30   \n",
              "2         2  08/06/1913    NaN   \n",
              "3         3  09/09/1913  18:30   \n",
              "4         4  10/17/1913  10:30   \n",
              "...     ...         ...    ...   \n",
              "5263   5263  05/20/2009  06:30   \n",
              "5264   5264  05/26/2009    NaN   \n",
              "5265   5265  06/01/2009  00:15   \n",
              "5266   5266  06/07/2009  08:30   \n",
              "5267   5267  06/08/2009    NaN   \n",
              "\n",
              "                                               Location  \\\n",
              "0                                   Fort Myer, Virginia   \n",
              "1                               AtlantiCity, New Jersey   \n",
              "2                    Victoria, British Columbia, Canada   \n",
              "3                                    Over the North Sea   \n",
              "4                            Near Johannisthal, Germany   \n",
              "...                                                 ...   \n",
              "5263                             Near Madiun, Indonesia   \n",
              "5264                  Near Isiro, DemocratiRepubliCongo   \n",
              "5265  AtlantiOcean, 570 miles northeast of Natal, Br...   \n",
              "5266       Near Port Hope Simpson, Newfoundland, Canada   \n",
              "5267                  State of Arunachal Pradesh, India   \n",
              "\n",
              "                             Operator Flight #  \\\n",
              "0                Military - U.S. Army      NaN   \n",
              "1                Military - U.S. Navy      NaN   \n",
              "2                             Private        -   \n",
              "3              Military - German Navy      NaN   \n",
              "4              Military - German Navy      NaN   \n",
              "...                               ...      ...   \n",
              "5263  Military - Indonesian Air Force      NaN   \n",
              "5264                      Service Air      NaN   \n",
              "5265                       Air France      447   \n",
              "5266                       Strait Air      NaN   \n",
              "5267      Military - Indian Air Force      NaN   \n",
              "\n",
              "                                          Route  \\\n",
              "0                                 Demonstration   \n",
              "1                                   Test flight   \n",
              "2                                           NaN   \n",
              "3                                           NaN   \n",
              "4                                           NaN   \n",
              "...                                         ...   \n",
              "5263                           Jakarta - Maduin   \n",
              "5264                               Goma - Isiro   \n",
              "5265                     Rio de Janeiro - Paris   \n",
              "5266  Lourdes de BlanSablon - Port Hope Simpson   \n",
              "5267                         Mechuka for Jorhat   \n",
              "\n",
              "                                  Type Registration cn/In  Aboard  Fatalities  \\\n",
              "0                     Wright Flyer III          NaN     1     2.0         1.0   \n",
              "1                            Dirigible          NaN   NaN     5.0         5.0   \n",
              "2                     Curtiss seaplane          NaN   NaN     1.0         1.0   \n",
              "3               Zeppelin L-1 (airship)          NaN   NaN    20.0        14.0   \n",
              "4               Zeppelin L-2 (airship)          NaN   NaN    30.0        30.0   \n",
              "...                                ...          ...   ...     ...         ...   \n",
              "5263           Lockheed C-130 Hercules       A-1325  1982   112.0        98.0   \n",
              "5264                     Antonov An-26       9Q-CSA  5005     4.0         4.0   \n",
              "5265                   Airbus A330-203       F-GZCP   660   228.0       228.0   \n",
              "5266  Britten-Norman BN-2A-27 Islander      C-FJJR    424     1.0         1.0   \n",
              "5267                     Antonov An-32          NaN   NaN    13.0        13.0   \n",
              "\n",
              "      Ground                                            Summary  \n",
              "0        0.0  During a demonstration flight, a U.S. Army fly...  \n",
              "1        0.0  First U.S. dirigible Akron exploded just offsh...  \n",
              "2        0.0  The first fatal airplane accident in Canada oc...  \n",
              "3        0.0  The airship flew into a thunderstorm and encou...  \n",
              "4        0.0  Hydrogen gas which was being vented was sucked...  \n",
              "...      ...                                                ...  \n",
              "5263     2.0  While on approach, the military transport cras...  \n",
              "5264     NaN  The cargo plane crashed while on approach to I...  \n",
              "5265     0.0  The Airbus went missing over the AtlantiOcean ...  \n",
              "5266     0.0  The air ambulance crashed into hills while att...  \n",
              "5267     0.0  The military transport went missing while en r...  \n",
              "\n",
              "[5268 rows x 14 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1b6dfbb8-6842-46b1-81c7-b8b79901647c\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>index</th>\n",
              "      <th>Date</th>\n",
              "      <th>Time</th>\n",
              "      <th>Location</th>\n",
              "      <th>Operator</th>\n",
              "      <th>Flight #</th>\n",
              "      <th>Route</th>\n",
              "      <th>Type</th>\n",
              "      <th>Registration</th>\n",
              "      <th>cn/In</th>\n",
              "      <th>Aboard</th>\n",
              "      <th>Fatalities</th>\n",
              "      <th>Ground</th>\n",
              "      <th>Summary</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>09/17/1908</td>\n",
              "      <td>17:18</td>\n",
              "      <td>Fort Myer, Virginia</td>\n",
              "      <td>Military - U.S. Army</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Demonstration</td>\n",
              "      <td>Wright Flyer III</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>During a demonstration flight, a U.S. Army fly...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>07/12/1912</td>\n",
              "      <td>06:30</td>\n",
              "      <td>AtlantiCity, New Jersey</td>\n",
              "      <td>Military - U.S. Navy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Test flight</td>\n",
              "      <td>Dirigible</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>First U.S. dirigible Akron exploded just offsh...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>08/06/1913</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Victoria, British Columbia, Canada</td>\n",
              "      <td>Private</td>\n",
              "      <td>-</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Curtiss seaplane</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The first fatal airplane accident in Canada oc...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>09/09/1913</td>\n",
              "      <td>18:30</td>\n",
              "      <td>Over the North Sea</td>\n",
              "      <td>Military - German Navy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Zeppelin L-1 (airship)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>20.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The airship flew into a thunderstorm and encou...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>10/17/1913</td>\n",
              "      <td>10:30</td>\n",
              "      <td>Near Johannisthal, Germany</td>\n",
              "      <td>Military - German Navy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Zeppelin L-2 (airship)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>30.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Hydrogen gas which was being vented was sucked...</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5263</th>\n",
              "      <td>5263</td>\n",
              "      <td>05/20/2009</td>\n",
              "      <td>06:30</td>\n",
              "      <td>Near Madiun, Indonesia</td>\n",
              "      <td>Military - Indonesian Air Force</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Jakarta - Maduin</td>\n",
              "      <td>Lockheed C-130 Hercules</td>\n",
              "      <td>A-1325</td>\n",
              "      <td>1982</td>\n",
              "      <td>112.0</td>\n",
              "      <td>98.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>While on approach, the military transport cras...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5264</th>\n",
              "      <td>5264</td>\n",
              "      <td>05/26/2009</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Near Isiro, DemocratiRepubliCongo</td>\n",
              "      <td>Service Air</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Goma - Isiro</td>\n",
              "      <td>Antonov An-26</td>\n",
              "      <td>9Q-CSA</td>\n",
              "      <td>5005</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>The cargo plane crashed while on approach to I...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5265</th>\n",
              "      <td>5265</td>\n",
              "      <td>06/01/2009</td>\n",
              "      <td>00:15</td>\n",
              "      <td>AtlantiOcean, 570 miles northeast of Natal, Br...</td>\n",
              "      <td>Air France</td>\n",
              "      <td>447</td>\n",
              "      <td>Rio de Janeiro - Paris</td>\n",
              "      <td>Airbus A330-203</td>\n",
              "      <td>F-GZCP</td>\n",
              "      <td>660</td>\n",
              "      <td>228.0</td>\n",
              "      <td>228.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The Airbus went missing over the AtlantiOcean ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5266</th>\n",
              "      <td>5266</td>\n",
              "      <td>06/07/2009</td>\n",
              "      <td>08:30</td>\n",
              "      <td>Near Port Hope Simpson, Newfoundland, Canada</td>\n",
              "      <td>Strait Air</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Lourdes de BlanSablon - Port Hope Simpson</td>\n",
              "      <td>Britten-Norman BN-2A-27 Islander</td>\n",
              "      <td>C-FJJR</td>\n",
              "      <td>424</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The air ambulance crashed into hills while att...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5267</th>\n",
              "      <td>5267</td>\n",
              "      <td>06/08/2009</td>\n",
              "      <td>NaN</td>\n",
              "      <td>State of Arunachal Pradesh, India</td>\n",
              "      <td>Military - Indian Air Force</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Mechuka for Jorhat</td>\n",
              "      <td>Antonov An-32</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13.0</td>\n",
              "      <td>13.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The military transport went missing while en r...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5268 rows × 14 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1b6dfbb8-6842-46b1-81c7-b8b79901647c')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-1b6dfbb8-6842-46b1-81c7-b8b79901647c button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-1b6dfbb8-6842-46b1-81c7-b8b79901647c');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "**ELIMINATING NULL FIELDS**"
      ],
      "metadata": {
        "id": "pfK20eD4zImV"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data.drop(data[data['Location'].isnull()].index, inplace=True)\n",
        "data"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "25chCkKPzSR8",
        "outputId": "e7d794d8-c3c4-4691-a0eb-2211e77a09c7"
      },
      "execution_count": 30,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      index        Date   Time  \\\n",
              "0         0  09/17/1908  17:18   \n",
              "1         1  07/12/1912  06:30   \n",
              "2         2  08/06/1913    NaN   \n",
              "3         3  09/09/1913  18:30   \n",
              "4         4  10/17/1913  10:30   \n",
              "...     ...         ...    ...   \n",
              "5263   5263  05/20/2009  06:30   \n",
              "5264   5264  05/26/2009    NaN   \n",
              "5265   5265  06/01/2009  00:15   \n",
              "5266   5266  06/07/2009  08:30   \n",
              "5267   5267  06/08/2009    NaN   \n",
              "\n",
              "                                               Location  \\\n",
              "0                                   Fort Myer, Virginia   \n",
              "1                               AtlantiCity, New Jersey   \n",
              "2                    Victoria, British Columbia, Canada   \n",
              "3                                    Over the North Sea   \n",
              "4                            Near Johannisthal, Germany   \n",
              "...                                                 ...   \n",
              "5263                             Near Madiun, Indonesia   \n",
              "5264                  Near Isiro, DemocratiRepubliCongo   \n",
              "5265  AtlantiOcean, 570 miles northeast of Natal, Br...   \n",
              "5266       Near Port Hope Simpson, Newfoundland, Canada   \n",
              "5267                  State of Arunachal Pradesh, India   \n",
              "\n",
              "                             Operator Flight #  \\\n",
              "0                Military - U.S. Army      NaN   \n",
              "1                Military - U.S. Navy      NaN   \n",
              "2                             Private        -   \n",
              "3              Military - German Navy      NaN   \n",
              "4              Military - German Navy      NaN   \n",
              "...                               ...      ...   \n",
              "5263  Military - Indonesian Air Force      NaN   \n",
              "5264                      Service Air      NaN   \n",
              "5265                       Air France      447   \n",
              "5266                       Strait Air      NaN   \n",
              "5267      Military - Indian Air Force      NaN   \n",
              "\n",
              "                                          Route  \\\n",
              "0                                 Demonstration   \n",
              "1                                   Test flight   \n",
              "2                                           NaN   \n",
              "3                                           NaN   \n",
              "4                                           NaN   \n",
              "...                                         ...   \n",
              "5263                           Jakarta - Maduin   \n",
              "5264                               Goma - Isiro   \n",
              "5265                     Rio de Janeiro - Paris   \n",
              "5266  Lourdes de BlanSablon - Port Hope Simpson   \n",
              "5267                         Mechuka for Jorhat   \n",
              "\n",
              "                                  Type Registration cn/In  Aboard  Fatalities  \\\n",
              "0                     Wright Flyer III          NaN     1     2.0         1.0   \n",
              "1                            Dirigible          NaN   NaN     5.0         5.0   \n",
              "2                     Curtiss seaplane          NaN   NaN     1.0         1.0   \n",
              "3               Zeppelin L-1 (airship)          NaN   NaN    20.0        14.0   \n",
              "4               Zeppelin L-2 (airship)          NaN   NaN    30.0        30.0   \n",
              "...                                ...          ...   ...     ...         ...   \n",
              "5263           Lockheed C-130 Hercules       A-1325  1982   112.0        98.0   \n",
              "5264                     Antonov An-26       9Q-CSA  5005     4.0         4.0   \n",
              "5265                   Airbus A330-203       F-GZCP   660   228.0       228.0   \n",
              "5266  Britten-Norman BN-2A-27 Islander      C-FJJR    424     1.0         1.0   \n",
              "5267                     Antonov An-32          NaN   NaN    13.0        13.0   \n",
              "\n",
              "      Ground                                            Summary  \n",
              "0        0.0  During a demonstration flight, a U.S. Army fly...  \n",
              "1        0.0  First U.S. dirigible Akron exploded just offsh...  \n",
              "2        0.0  The first fatal airplane accident in Canada oc...  \n",
              "3        0.0  The airship flew into a thunderstorm and encou...  \n",
              "4        0.0  Hydrogen gas which was being vented was sucked...  \n",
              "...      ...                                                ...  \n",
              "5263     2.0  While on approach, the military transport cras...  \n",
              "5264     NaN  The cargo plane crashed while on approach to I...  \n",
              "5265     0.0  The Airbus went missing over the AtlantiOcean ...  \n",
              "5266     0.0  The air ambulance crashed into hills while att...  \n",
              "5267     0.0  The military transport went missing while en r...  \n",
              "\n",
              "[5248 rows x 14 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-836360dc-e6a5-4285-9bd3-7e29bd156cd6\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>index</th>\n",
              "      <th>Date</th>\n",
              "      <th>Time</th>\n",
              "      <th>Location</th>\n",
              "      <th>Operator</th>\n",
              "      <th>Flight #</th>\n",
              "      <th>Route</th>\n",
              "      <th>Type</th>\n",
              "      <th>Registration</th>\n",
              "      <th>cn/In</th>\n",
              "      <th>Aboard</th>\n",
              "      <th>Fatalities</th>\n",
              "      <th>Ground</th>\n",
              "      <th>Summary</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>09/17/1908</td>\n",
              "      <td>17:18</td>\n",
              "      <td>Fort Myer, Virginia</td>\n",
              "      <td>Military - U.S. Army</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Demonstration</td>\n",
              "      <td>Wright Flyer III</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>During a demonstration flight, a U.S. Army fly...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>07/12/1912</td>\n",
              "      <td>06:30</td>\n",
              "      <td>AtlantiCity, New Jersey</td>\n",
              "      <td>Military - U.S. Navy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Test flight</td>\n",
              "      <td>Dirigible</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>First U.S. dirigible Akron exploded just offsh...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>08/06/1913</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Victoria, British Columbia, Canada</td>\n",
              "      <td>Private</td>\n",
              "      <td>-</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Curtiss seaplane</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The first fatal airplane accident in Canada oc...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>09/09/1913</td>\n",
              "      <td>18:30</td>\n",
              "      <td>Over the North Sea</td>\n",
              "      <td>Military - German Navy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Zeppelin L-1 (airship)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>20.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The airship flew into a thunderstorm and encou...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>10/17/1913</td>\n",
              "      <td>10:30</td>\n",
              "      <td>Near Johannisthal, Germany</td>\n",
              "      <td>Military - German Navy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Zeppelin L-2 (airship)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>30.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Hydrogen gas which was being vented was sucked...</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5263</th>\n",
              "      <td>5263</td>\n",
              "      <td>05/20/2009</td>\n",
              "      <td>06:30</td>\n",
              "      <td>Near Madiun, Indonesia</td>\n",
              "      <td>Military - Indonesian Air Force</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Jakarta - Maduin</td>\n",
              "      <td>Lockheed C-130 Hercules</td>\n",
              "      <td>A-1325</td>\n",
              "      <td>1982</td>\n",
              "      <td>112.0</td>\n",
              "      <td>98.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>While on approach, the military transport cras...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5264</th>\n",
              "      <td>5264</td>\n",
              "      <td>05/26/2009</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Near Isiro, DemocratiRepubliCongo</td>\n",
              "      <td>Service Air</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Goma - Isiro</td>\n",
              "      <td>Antonov An-26</td>\n",
              "      <td>9Q-CSA</td>\n",
              "      <td>5005</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>The cargo plane crashed while on approach to I...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5265</th>\n",
              "      <td>5265</td>\n",
              "      <td>06/01/2009</td>\n",
              "      <td>00:15</td>\n",
              "      <td>AtlantiOcean, 570 miles northeast of Natal, Br...</td>\n",
              "      <td>Air France</td>\n",
              "      <td>447</td>\n",
              "      <td>Rio de Janeiro - Paris</td>\n",
              "      <td>Airbus A330-203</td>\n",
              "      <td>F-GZCP</td>\n",
              "      <td>660</td>\n",
              "      <td>228.0</td>\n",
              "      <td>228.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The Airbus went missing over the AtlantiOcean ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5266</th>\n",
              "      <td>5266</td>\n",
              "      <td>06/07/2009</td>\n",
              "      <td>08:30</td>\n",
              "      <td>Near Port Hope Simpson, Newfoundland, Canada</td>\n",
              "      <td>Strait Air</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Lourdes de BlanSablon - Port Hope Simpson</td>\n",
              "      <td>Britten-Norman BN-2A-27 Islander</td>\n",
              "      <td>C-FJJR</td>\n",
              "      <td>424</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The air ambulance crashed into hills while att...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5267</th>\n",
              "      <td>5267</td>\n",
              "      <td>06/08/2009</td>\n",
              "      <td>NaN</td>\n",
              "      <td>State of Arunachal Pradesh, India</td>\n",
              "      <td>Military - Indian Air Force</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Mechuka for Jorhat</td>\n",
              "      <td>Antonov An-32</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13.0</td>\n",
              "      <td>13.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The military transport went missing while en r...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5248 rows × 14 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-836360dc-e6a5-4285-9bd3-7e29bd156cd6')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-836360dc-e6a5-4285-9bd3-7e29bd156cd6 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-836360dc-e6a5-4285-9bd3-7e29bd156cd6');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 30
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data.drop(data[data['Operator'].isnull()].index, inplace=True)\n",
        "data"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "wtwZDPW1zpLU",
        "outputId": "825313b1-d952-4cb7-ba00-2359d0222c53"
      },
      "execution_count": 31,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      index        Date   Time  \\\n",
              "0         0  09/17/1908  17:18   \n",
              "1         1  07/12/1912  06:30   \n",
              "2         2  08/06/1913    NaN   \n",
              "3         3  09/09/1913  18:30   \n",
              "4         4  10/17/1913  10:30   \n",
              "...     ...         ...    ...   \n",
              "5263   5263  05/20/2009  06:30   \n",
              "5264   5264  05/26/2009    NaN   \n",
              "5265   5265  06/01/2009  00:15   \n",
              "5266   5266  06/07/2009  08:30   \n",
              "5267   5267  06/08/2009    NaN   \n",
              "\n",
              "                                               Location  \\\n",
              "0                                   Fort Myer, Virginia   \n",
              "1                               AtlantiCity, New Jersey   \n",
              "2                    Victoria, British Columbia, Canada   \n",
              "3                                    Over the North Sea   \n",
              "4                            Near Johannisthal, Germany   \n",
              "...                                                 ...   \n",
              "5263                             Near Madiun, Indonesia   \n",
              "5264                  Near Isiro, DemocratiRepubliCongo   \n",
              "5265  AtlantiOcean, 570 miles northeast of Natal, Br...   \n",
              "5266       Near Port Hope Simpson, Newfoundland, Canada   \n",
              "5267                  State of Arunachal Pradesh, India   \n",
              "\n",
              "                             Operator Flight #  \\\n",
              "0                Military - U.S. Army      NaN   \n",
              "1                Military - U.S. Navy      NaN   \n",
              "2                             Private        -   \n",
              "3              Military - German Navy      NaN   \n",
              "4              Military - German Navy      NaN   \n",
              "...                               ...      ...   \n",
              "5263  Military - Indonesian Air Force      NaN   \n",
              "5264                      Service Air      NaN   \n",
              "5265                       Air France      447   \n",
              "5266                       Strait Air      NaN   \n",
              "5267      Military - Indian Air Force      NaN   \n",
              "\n",
              "                                          Route  \\\n",
              "0                                 Demonstration   \n",
              "1                                   Test flight   \n",
              "2                                           NaN   \n",
              "3                                           NaN   \n",
              "4                                           NaN   \n",
              "...                                         ...   \n",
              "5263                           Jakarta - Maduin   \n",
              "5264                               Goma - Isiro   \n",
              "5265                     Rio de Janeiro - Paris   \n",
              "5266  Lourdes de BlanSablon - Port Hope Simpson   \n",
              "5267                         Mechuka for Jorhat   \n",
              "\n",
              "                                  Type Registration cn/In  Aboard  Fatalities  \\\n",
              "0                     Wright Flyer III          NaN     1     2.0         1.0   \n",
              "1                            Dirigible          NaN   NaN     5.0         5.0   \n",
              "2                     Curtiss seaplane          NaN   NaN     1.0         1.0   \n",
              "3               Zeppelin L-1 (airship)          NaN   NaN    20.0        14.0   \n",
              "4               Zeppelin L-2 (airship)          NaN   NaN    30.0        30.0   \n",
              "...                                ...          ...   ...     ...         ...   \n",
              "5263           Lockheed C-130 Hercules       A-1325  1982   112.0        98.0   \n",
              "5264                     Antonov An-26       9Q-CSA  5005     4.0         4.0   \n",
              "5265                   Airbus A330-203       F-GZCP   660   228.0       228.0   \n",
              "5266  Britten-Norman BN-2A-27 Islander      C-FJJR    424     1.0         1.0   \n",
              "5267                     Antonov An-32          NaN   NaN    13.0        13.0   \n",
              "\n",
              "      Ground                                            Summary  \n",
              "0        0.0  During a demonstration flight, a U.S. Army fly...  \n",
              "1        0.0  First U.S. dirigible Akron exploded just offsh...  \n",
              "2        0.0  The first fatal airplane accident in Canada oc...  \n",
              "3        0.0  The airship flew into a thunderstorm and encou...  \n",
              "4        0.0  Hydrogen gas which was being vented was sucked...  \n",
              "...      ...                                                ...  \n",
              "5263     2.0  While on approach, the military transport cras...  \n",
              "5264     NaN  The cargo plane crashed while on approach to I...  \n",
              "5265     0.0  The Airbus went missing over the AtlantiOcean ...  \n",
              "5266     0.0  The air ambulance crashed into hills while att...  \n",
              "5267     0.0  The military transport went missing while en r...  \n",
              "\n",
              "[5231 rows x 14 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-483b37d1-c9be-4453-83e0-16e0c24321c3\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>index</th>\n",
              "      <th>Date</th>\n",
              "      <th>Time</th>\n",
              "      <th>Location</th>\n",
              "      <th>Operator</th>\n",
              "      <th>Flight #</th>\n",
              "      <th>Route</th>\n",
              "      <th>Type</th>\n",
              "      <th>Registration</th>\n",
              "      <th>cn/In</th>\n",
              "      <th>Aboard</th>\n",
              "      <th>Fatalities</th>\n",
              "      <th>Ground</th>\n",
              "      <th>Summary</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>09/17/1908</td>\n",
              "      <td>17:18</td>\n",
              "      <td>Fort Myer, Virginia</td>\n",
              "      <td>Military - U.S. Army</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Demonstration</td>\n",
              "      <td>Wright Flyer III</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>During a demonstration flight, a U.S. Army fly...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>07/12/1912</td>\n",
              "      <td>06:30</td>\n",
              "      <td>AtlantiCity, New Jersey</td>\n",
              "      <td>Military - U.S. Navy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Test flight</td>\n",
              "      <td>Dirigible</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>First U.S. dirigible Akron exploded just offsh...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>08/06/1913</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Victoria, British Columbia, Canada</td>\n",
              "      <td>Private</td>\n",
              "      <td>-</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Curtiss seaplane</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The first fatal airplane accident in Canada oc...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>09/09/1913</td>\n",
              "      <td>18:30</td>\n",
              "      <td>Over the North Sea</td>\n",
              "      <td>Military - German Navy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Zeppelin L-1 (airship)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>20.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The airship flew into a thunderstorm and encou...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>10/17/1913</td>\n",
              "      <td>10:30</td>\n",
              "      <td>Near Johannisthal, Germany</td>\n",
              "      <td>Military - German Navy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Zeppelin L-2 (airship)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>30.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Hydrogen gas which was being vented was sucked...</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5263</th>\n",
              "      <td>5263</td>\n",
              "      <td>05/20/2009</td>\n",
              "      <td>06:30</td>\n",
              "      <td>Near Madiun, Indonesia</td>\n",
              "      <td>Military - Indonesian Air Force</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Jakarta - Maduin</td>\n",
              "      <td>Lockheed C-130 Hercules</td>\n",
              "      <td>A-1325</td>\n",
              "      <td>1982</td>\n",
              "      <td>112.0</td>\n",
              "      <td>98.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>While on approach, the military transport cras...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5264</th>\n",
              "      <td>5264</td>\n",
              "      <td>05/26/2009</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Near Isiro, DemocratiRepubliCongo</td>\n",
              "      <td>Service Air</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Goma - Isiro</td>\n",
              "      <td>Antonov An-26</td>\n",
              "      <td>9Q-CSA</td>\n",
              "      <td>5005</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>The cargo plane crashed while on approach to I...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5265</th>\n",
              "      <td>5265</td>\n",
              "      <td>06/01/2009</td>\n",
              "      <td>00:15</td>\n",
              "      <td>AtlantiOcean, 570 miles northeast of Natal, Br...</td>\n",
              "      <td>Air France</td>\n",
              "      <td>447</td>\n",
              "      <td>Rio de Janeiro - Paris</td>\n",
              "      <td>Airbus A330-203</td>\n",
              "      <td>F-GZCP</td>\n",
              "      <td>660</td>\n",
              "      <td>228.0</td>\n",
              "      <td>228.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The Airbus went missing over the AtlantiOcean ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5266</th>\n",
              "      <td>5266</td>\n",
              "      <td>06/07/2009</td>\n",
              "      <td>08:30</td>\n",
              "      <td>Near Port Hope Simpson, Newfoundland, Canada</td>\n",
              "      <td>Strait Air</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Lourdes de BlanSablon - Port Hope Simpson</td>\n",
              "      <td>Britten-Norman BN-2A-27 Islander</td>\n",
              "      <td>C-FJJR</td>\n",
              "      <td>424</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The air ambulance crashed into hills while att...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5267</th>\n",
              "      <td>5267</td>\n",
              "      <td>06/08/2009</td>\n",
              "      <td>NaN</td>\n",
              "      <td>State of Arunachal Pradesh, India</td>\n",
              "      <td>Military - Indian Air Force</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Mechuka for Jorhat</td>\n",
              "      <td>Antonov An-32</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13.0</td>\n",
              "      <td>13.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The military transport went missing while en r...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5231 rows × 14 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-483b37d1-c9be-4453-83e0-16e0c24321c3')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-483b37d1-c9be-4453-83e0-16e0c24321c3 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-483b37d1-c9be-4453-83e0-16e0c24321c3');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data.drop(data[data['Registration'].isnull()].index, inplace=True)\n",
        "data"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "d9eDOtOo0XFH",
        "outputId": "7762db27-4372-4914-ebc7-44347b50ebc4"
      },
      "execution_count": 32,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      index        Date   Time  \\\n",
              "21       21  12/16/1918    NaN   \n",
              "22       22  05/25/1919    NaN   \n",
              "23       23  07/19/1919    NaN   \n",
              "25       25  10/14/1919    NaN   \n",
              "26       26  10/20/1919    NaN   \n",
              "...     ...         ...    ...   \n",
              "5262   5262  05/03/2009  12:00   \n",
              "5263   5263  05/20/2009  06:30   \n",
              "5264   5264  05/26/2009    NaN   \n",
              "5265   5265  06/01/2009  00:15   \n",
              "5266   5266  06/07/2009  08:30   \n",
              "\n",
              "                                               Location  \\\n",
              "21                                Elizabeth, New Jersey   \n",
              "22                                      Cleveland, Ohio   \n",
              "23                                Dix Run, Pennsylvania   \n",
              "25                               Cantonsville, Maryland   \n",
              "26                                      English Channel   \n",
              "...                                                 ...   \n",
              "5262                   Near El Alto de Rubio, Venezuela   \n",
              "5263                             Near Madiun, Indonesia   \n",
              "5264                  Near Isiro, DemocratiRepubliCongo   \n",
              "5265  AtlantiOcean, 570 miles northeast of Natal, Br...   \n",
              "5266       Near Port Hope Simpson, Newfoundland, Canada   \n",
              "\n",
              "                             Operator Flight #  \\\n",
              "21             US Aerial Mail Service      NaN   \n",
              "22             US Aerial Mail Service      NaN   \n",
              "23             US Aerial Mail Service      NaN   \n",
              "25             US Aerial Mail Service      NaN   \n",
              "26      Aircraft Transport and Travel      NaN   \n",
              "...                               ...      ...   \n",
              "5262       Military - Venezuelan Army      NaN   \n",
              "5263  Military - Indonesian Air Force      NaN   \n",
              "5264                      Service Air      NaN   \n",
              "5265                       Air France      447   \n",
              "5266                       Strait Air      NaN   \n",
              "\n",
              "                                          Route  \\\n",
              "21                                          NaN   \n",
              "22                                          NaN   \n",
              "23                                          NaN   \n",
              "25                                          NaN   \n",
              "26                                          NaN   \n",
              "...                                         ...   \n",
              "5262                                     Patrol   \n",
              "5263                           Jakarta - Maduin   \n",
              "5264                               Goma - Isiro   \n",
              "5265                     Rio de Janeiro - Paris   \n",
              "5266  Lourdes de BlanSablon - Port Hope Simpson   \n",
              "\n",
              "                                  Type Registration cn/In  Aboard  Fatalities  \\\n",
              "21                   De Havilland DH-4           97   NaN     1.0         1.0   \n",
              "22                   De Havilland DH-4           61   NaN     1.0         1.0   \n",
              "23                   De Havilland DH-4           82   NaN     1.0         1.0   \n",
              "25                       Curtiss R-4LM           32   NaN     1.0         1.0   \n",
              "26                   De Havilland DH-4       G-EAHG   NaN     NaN         NaN   \n",
              "...                                ...          ...   ...     ...         ...   \n",
              "5262                             Mi-35     EV08114    NaN    18.0        18.0   \n",
              "5263           Lockheed C-130 Hercules       A-1325  1982   112.0        98.0   \n",
              "5264                     Antonov An-26       9Q-CSA  5005     4.0         4.0   \n",
              "5265                   Airbus A330-203       F-GZCP   660   228.0       228.0   \n",
              "5266  Britten-Norman BN-2A-27 Islander      C-FJJR    424     1.0         1.0   \n",
              "\n",
              "      Ground                                            Summary  \n",
              "21       0.0                                                NaN  \n",
              "22       0.0  Caught fire in midair. The pilot leaped from t...  \n",
              "23       0.0                                                NaN  \n",
              "25       0.0                                                NaN  \n",
              "26       NaN                                                NaN  \n",
              "...      ...                                                ...  \n",
              "5262     0.0  The helicopter was patrolling along the Venezu...  \n",
              "5263     2.0  While on approach, the military transport cras...  \n",
              "5264     NaN  The cargo plane crashed while on approach to I...  \n",
              "5265     0.0  The Airbus went missing over the AtlantiOcean ...  \n",
              "5266     0.0  The air ambulance crashed into hills while att...  \n",
              "\n",
              "[4909 rows x 14 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-6dddc18c-4dc7-41fc-850d-21739c883d91\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>index</th>\n",
              "      <th>Date</th>\n",
              "      <th>Time</th>\n",
              "      <th>Location</th>\n",
              "      <th>Operator</th>\n",
              "      <th>Flight #</th>\n",
              "      <th>Route</th>\n",
              "      <th>Type</th>\n",
              "      <th>Registration</th>\n",
              "      <th>cn/In</th>\n",
              "      <th>Aboard</th>\n",
              "      <th>Fatalities</th>\n",
              "      <th>Ground</th>\n",
              "      <th>Summary</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>21</td>\n",
              "      <td>12/16/1918</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Elizabeth, New Jersey</td>\n",
              "      <td>US Aerial Mail Service</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>De Havilland DH-4</td>\n",
              "      <td>97</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>22</td>\n",
              "      <td>05/25/1919</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Cleveland, Ohio</td>\n",
              "      <td>US Aerial Mail Service</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>De Havilland DH-4</td>\n",
              "      <td>61</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Caught fire in midair. The pilot leaped from t...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>23</td>\n",
              "      <td>07/19/1919</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Dix Run, Pennsylvania</td>\n",
              "      <td>US Aerial Mail Service</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>De Havilland DH-4</td>\n",
              "      <td>82</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>25</td>\n",
              "      <td>10/14/1919</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Cantonsville, Maryland</td>\n",
              "      <td>US Aerial Mail Service</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Curtiss R-4LM</td>\n",
              "      <td>32</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>26</td>\n",
              "      <td>10/20/1919</td>\n",
              "      <td>NaN</td>\n",
              "      <td>English Channel</td>\n",
              "      <td>Aircraft Transport and Travel</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>De Havilland DH-4</td>\n",
              "      <td>G-EAHG</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5262</th>\n",
              "      <td>5262</td>\n",
              "      <td>05/03/2009</td>\n",
              "      <td>12:00</td>\n",
              "      <td>Near El Alto de Rubio, Venezuela</td>\n",
              "      <td>Military - Venezuelan Army</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Patrol</td>\n",
              "      <td>Mi-35</td>\n",
              "      <td>EV08114</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The helicopter was patrolling along the Venezu...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5263</th>\n",
              "      <td>5263</td>\n",
              "      <td>05/20/2009</td>\n",
              "      <td>06:30</td>\n",
              "      <td>Near Madiun, Indonesia</td>\n",
              "      <td>Military - Indonesian Air Force</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Jakarta - Maduin</td>\n",
              "      <td>Lockheed C-130 Hercules</td>\n",
              "      <td>A-1325</td>\n",
              "      <td>1982</td>\n",
              "      <td>112.0</td>\n",
              "      <td>98.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>While on approach, the military transport cras...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5264</th>\n",
              "      <td>5264</td>\n",
              "      <td>05/26/2009</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Near Isiro, DemocratiRepubliCongo</td>\n",
              "      <td>Service Air</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Goma - Isiro</td>\n",
              "      <td>Antonov An-26</td>\n",
              "      <td>9Q-CSA</td>\n",
              "      <td>5005</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>The cargo plane crashed while on approach to I...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5265</th>\n",
              "      <td>5265</td>\n",
              "      <td>06/01/2009</td>\n",
              "      <td>00:15</td>\n",
              "      <td>AtlantiOcean, 570 miles northeast of Natal, Br...</td>\n",
              "      <td>Air France</td>\n",
              "      <td>447</td>\n",
              "      <td>Rio de Janeiro - Paris</td>\n",
              "      <td>Airbus A330-203</td>\n",
              "      <td>F-GZCP</td>\n",
              "      <td>660</td>\n",
              "      <td>228.0</td>\n",
              "      <td>228.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The Airbus went missing over the AtlantiOcean ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5266</th>\n",
              "      <td>5266</td>\n",
              "      <td>06/07/2009</td>\n",
              "      <td>08:30</td>\n",
              "      <td>Near Port Hope Simpson, Newfoundland, Canada</td>\n",
              "      <td>Strait Air</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Lourdes de BlanSablon - Port Hope Simpson</td>\n",
              "      <td>Britten-Norman BN-2A-27 Islander</td>\n",
              "      <td>C-FJJR</td>\n",
              "      <td>424</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>The air ambulance crashed into hills while att...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>4909 rows × 14 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-6dddc18c-4dc7-41fc-850d-21739c883d91')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-6dddc18c-4dc7-41fc-850d-21739c883d91 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-6dddc18c-4dc7-41fc-850d-21739c883d91');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "**COUNTING THE MAXIMUM VALUES :**"
      ],
      "metadata": {
        "id": "vc_B-nUvTVTa"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data['Operator'].value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "g5BPd_Bz2oKM",
        "outputId": "5cc8b31f-369a-44c9-ecf9-a2f65b1ea5da"
      },
      "execution_count": 33,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Military - U.S. Air Force       167\n",
              "Aeroflot                        166\n",
              "Air France                       69\n",
              "Deutsche Lufthansa               59\n",
              "United Air Lines                 44\n",
              "                               ... \n",
              "Taxi Aereo El Venado              1\n",
              "Hamilton Aviation                 1\n",
              "Foster Aviation                   1\n",
              "Skips Air Service - Air Taxi      1\n",
              "Strait Air                        1\n",
              "Name: Operator, Length: 2385, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 33
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data['Location'].value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "DwWzECwn44Tu",
        "outputId": "54248a9c-5722-4aa3-f7dd-4eae1a2a3fab"
      },
      "execution_count": 34,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Sao Paulo, Brazil                               14\n",
              "Bogota, Colombia                                13\n",
              "Moscow, Russia                                  13\n",
              "Anchorage, Alaska                               13\n",
              "Manila, Philippines                             13\n",
              "                                                ..\n",
              "Near Chicago Illinois                            1\n",
              "Boston, Massachutes                              1\n",
              "Near Danbury, North Carolina                     1\n",
              "Mt. Vesuvius, Italy                              1\n",
              "Near Port Hope Simpson, Newfoundland, Canada     1\n",
              "Name: Location, Length: 4035, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 34
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "**LINEAR REGRESSION RELATED TO ABOARD**"
      ],
      "metadata": {
        "id": "00uvdO8QTd5a"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data.plot(x=\"Aboard\", y=\"Fatalities\", kind=\"scatter\")\n",
        "plt.show()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 279
        },
        "id": "Dv6fcCx65PhL",
        "outputId": "6c7e3dfb-7e19-408d-e2b2-bf281d979bfa"
      },
      "execution_count": 35,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEGCAYAAACKB4k+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3de3xU9Z3/8ddnZpKA3A0W5SYqWH9iAd2symIvSttVa7G7Urdqq9t1l724Xbu1gq5rlbrdVm1r7WXdutqt7tKtCq2guK0WaLvaYhtroIC3qFAS5GIKGBAmyczn98c5M0ySmWRymcxM8n4+HnlkzvecmXyC8XzO927ujoiICECk2AGIiEjpUFIQEZE0JQUREUlTUhARkTQlBRERSYsVO4C+GD9+vE+bNq3YYYiIlJXnnnvuTXc/Jtu5giYFMxsL3AecBjjwF8BLwEPANGArcKm77zUzA+4GLgTeBv7c3X/T1edPmzaN2tragsUvIjIYmdm2XOcK3Xx0N/Ajdz8FmA28ANwArHH3GcCa8BjgAmBG+LUIuKfAsYmISAcFSwpmNgZ4D3A/gLu3uPs+4GLggfCyB4CPhK8vBh70wHpgrJkdV6j4RESks0LWFE4A9gD/aWbPm9l9ZjYCmODub4TX7AQmhK8nAdsz3t8QlrVjZovMrNbMavfs2VPA8EVEhp5CJoUYcAZwj7ufDhzkSFMRAB6ssdGjdTbc/V53r3H3mmOOydpPIiIivVTIpNAANLj7s+HxcoIksSvVLBR+3x2ebwSmZLx/clgmIiIDpGBJwd13AtvN7J1h0XxgC7AKuCosuwpYGb5eBVxpgbOB/RnNTCIiEmo6EGfD9n00HYj3+2cXep7Cp4BlZlYJvAZ8kiARPWxmVwPbgEvDa58gGI5aTzAk9ZMFjk1EpOysrGtkyYqNVEQitCaT3HHJLBbM6dT92msFTQruXgfUZDk1P8u1DlxTyHhERMpZ04E4S1Zs5HBrksMkAVi8YiPzpo+nemRVv/wMLXMhIlImGvYeoiLS/rZdEYnQsPdQv/0MJQURkTIxedxwWpPJdmWtySSTxw3vt5+hpCAiUiaqR1ZxxyWzGFYRYVRVjGEVEe64ZFa/NR1BmS+IJyIy1CyYM4l508fTsPcQk8cN79eEAEoKIiJlp3pkVb8ngxQ1H4mISJqSgoiIpCkpiIhImpKCiIikKSmIiEiakoKIiKQpKYiISJqSgoiIpCkpiIhImpKCiIikKSmIiEiakoKIiKQpKYiISJqSgoiIpCkpiMig0nQgzobt+2g6EC92KGVJ+ymIyKCxsq6RJSs2UhGJ0JpMcscls1gwZ1KxwyorqimIyKDQdCDOkhUbOdyapDnexuHWJItXbFSNoYeUFERkUGjYe4iKSPtbWkUkQsPeQ0WKqDwpKYjIoDB53HBak8l2Za3JJJPHDS9SROVJSUFEBoXqkVXccckshlVEGFUVY1hFhDsumVWwvYwHq4J2NJvZVqAZSABt7l5jZkcDDwHTgK3Ape6+18wMuBu4EHgb+HN3/00h4xORwWXBnEnMmz6ehr2HmDxuuBJCLwxETeFcd5/j7jXh8Q3AGnefAawJjwEuAGaEX4uAewYgNhEZZKpHVjF7ylglhF4qRvPRxcAD4esHgI9klD/ogfXAWDM7rgjxiYgMWYVOCg48aWbPmdmisGyCu78Rvt4JTAhfTwK2Z7y3ISxrx8wWmVmtmdXu2bOnUHGLiAxJhZ68do67N5rZO4CnzOzFzJPu7mbmPflAd78XuBegpqamR+8VEZGuFbSm4O6N4ffdwA+BM4FdqWah8Pvu8PJGYErG2yeHZSIiMkAKlhTMbISZjUq9Bj4IbAJWAVeFl10FrAxfrwKutMDZwP6MZiYRERkAhWw+mgD8MBhpSgz4nrv/yMx+DTxsZlcD24BLw+ufIBiOWk8wJPWTBYxNRESyKFhScPfXgNlZypuA+VnKHbimUPGIiEj3NKNZRETSlBRERCRNSUFERNKUFEREJE1JQURE0pQUREQkTUlBRETSlBRERCRNSUFERNKUFEREJE1JQURE0pQUREQkTUlBRETSlBRERCRNSUFERNKUFEREJE1JQURE0pQUREQkTUlBRETSlBRERCRNSUFERNKUFEREJE1JQURE0pQUREQkTUlBRETSCp4UzCxqZs+b2ePh8Qlm9qyZ1ZvZQ2ZWGZZXhcf14flphY5NRETaG4iawrXACxnHtwN3uft0YC9wdVh+NbA3LL8rvE5ERAZQQZOCmU0GPgTcFx4bcB6wPLzkAeAj4euLw2PC8/PD60VEZIAUuqbwNWAxkAyPq4F97t4WHjcAk8LXk4DtAOH5/eH17ZjZIjOrNbPaPXv2FDJ2EZEhp2BJwcwuAna7+3P9+bnufq+717h7zTHHHNOfHy0iMuTFCvjZ84AFZnYhMAwYDdwNjDWzWFgbmAw0htc3AlOABjOLAWOApgLGJyIiHRSspuDuN7r7ZHefBnwMWOvuVwDrgIXhZVcBK8PXq8JjwvNr3d0LFZ+IiHRWjHkKS4DPmFk9QZ/B/WH5/UB1WP4Z4IYixCYiMqQVsvkozd1/Cvw0fP0acGaWaw4DHx2IeEREJDvNaBYRkTQlBRERSVNSEBGRNCUFERFJU1IQEZE0JQUREUlTUhARkTQlBRERSVNSEBGRNCUFkRLQdCDOhu37aDoQL3YoMsQNyDIXIpLbsvXbWPr4FiqjRlvSueOSWSyYM6n7N4oUQF41BTMbYWaR8PXJZrbAzCoKG5rI4Lds/TZuenQTLW1JDsQTHG5NsnjFRtUYpGjybT76OTDMzCYBTwKfAL5bqKBEhoKmA3GWPra5U3k0YjTsPVSEiETyTwrm7m8Dfwr8m7t/FJhZuLBEBr+GvYeoiHb+X7A14UweN7wIEYn0ICmY2VzgCmB1WBYtTEgiQ8PkccNJZNlH6pYPn0r1yKoiRCSSf1L4NHAj8EN332xmJxLsoCYi3cg1sqh6ZBV3XDKLYRURRlRGqYwaX/jIaVxx1vFFilQkaBbK/2Kzo8JmpJJQU1PjtbW1xQ5DJKeVdY0sWbGRikiE1mQy68iipgNxGvYeYvK44aohyIAws+fcvSbbuXxHH801sy3Ai+HxbDP7t36MUWTQaToQZ8mKjRxuTdIcb8s5sqh6ZBWzp4xVQpCSkG/z0deAPwaaANx9A/CeQgUlMhg07D1ERaT9/2IVkYhGFklJy3tGs7tv71CU6OdYRAaVyeOG05pMtitrTSY1skhKWr5JYbuZ/RHgZlZhZp8FXihgXCJlL7MjeVRVjGEVEe64ZJaaiaSk5bvMxd8AdwOTgEaCCWzXFCookcFiwZxJzJs+Xh3JUjbySgru/ibBHAUR6aHqkVVKBlI2ukwKZrbY3e8ws28Ancauuvs/FCwyEREZcN3VFFL9BpoMICIyBHSZFNz9sfDl2+7+SOY5M/toV+81s2EEC+lVhT9nubvfYmYnAN8HqoHngE+4e4uZVQEPAn9AMPT1z9x9a89/JZHC0CQzGQryHX10Y55lmeLAee4+G5gDnG9mZwO3A3e5+3RgL3B1eP3VwN6w/K7wOpGSsLKukXm3r+Xj9z3LvNvXsqqusdghiRREd30KFwAXApPM7OsZp0YDbV2914P1Mw6EhxXhlwPnAZeH5Q8AtwL3ABeHrwGWA980M/OerMMhUgCZM5MPE8w7WLxiI/Omj1eNQQad7moKOwj6Ew4TNPWkvlYRzHDukplFzawO2A08BbwK7HP3VEJpIBjmSvh9O0B4fj9BE1PHz1xkZrVmVrtnz57uQhDpM81MlqGkuz6FDcAGM1uWcSPPm7sngDlmNhb4IXBK78Js95n3AvdCsCBeXz9PJJvM/gPNTJahpLvmo4fd/VLgeTPLNiR1Vj4/xN33mdk6YC4w1sxiYZKZTDAZjvD7FKDBzGLAGMK1lkQGUraVTe+4ZBaLO5Sp6UgGo+6GpF4bfr+opx9sZscArWFCGA58gKDzeB2wkGAE0lXAyvAtq8LjX4bn16o/QQZarv6DZ5acxzNLztPoIxn0ums+eiP8vq0Xn30c8ICZRQn6Lh5298fDJbi/b2b/AjwP3B9efz/wX2ZWD/we+FgvfqZIn6T6D1IJAY70H2h5axkKums+aibLTGbACAYYjc71XnffCJyepfw14Mws5YeBLuc+iBSa+g9kqOty9JG7j3L30Vm+RnWVEETKQbZtMrWyqQx1+a6SCoCZvQMYljp299/1e0QiBdZ0IM6yZ3/Ht9bVUxntvE2mVjaVoSyvpGBmC4CvABMJ5hwcT7Au0szChSbS/5at38atqzbRGrYQxduyT0bTyqYyVOW7zMVtwNnAy+5+AjAfWF+wqEQKYNn6bdz06JGEkEmT0UQC+TYftbp7k5lFzCzi7uvM7GsFjUykH6QmoY2ojLL08S05r1Nnskgg36Swz8xGEqx6uszMdgMHCxeWSN8tW7+NWx/bTCxitCUdyzHtpSqmzmSRlHyTwsXAIeAfCXZgGwMsLVRQIn1115MvcffaegBaE7nnQFZEjf+4sob3nHzMQIUmUtLy7VP4nLsn3b3N3R9w968DSwoZmEhvLX6kLp0QuhONGDMnanS1SEq+SeEDWcou6M9ARPpD/a5mHn4u914Hfz73eCpjEUZURTUHQSSL7mY0/y3wd8CJZrYx49Qo4JlCBibSG3Xb9+U8VxE1PjV/Bp+aP0NzEERy6K5P4XvA/wJfBG7IKG92998XLCqRXpozZWzW8ljE+MpHZ7ebhyAinXW3zMV+d9/q7peFi+IdIlgLaaSZTR2QCEV6YPqEUVw5t/2f5vv/3zE8+0/z0zOWRSS3fGc0fxj4KprRLCUicxOcjk/9n7/4XVx59jTqtu9jzpSxTJ8wqkhRipSffIek/gvBjOafuPvpZnYu8PHChSWSW7ZNcDrWAqZPGKVkINIL+Y4+anX3JiA9oxmoKWBcIlnV72rm+kc2cLg1SXO8jcOtSRav2NhupVMR6T3NaJaS13QgzuYd+/nFq0185+mttHSYjJZatyjVjNRV05KIdK27IalTw+Wxs81o/nzhw5OhbmVdI9c9XEdblkXsUjLXLcqnaUlEcuuu+ehRAHc/CDySOaM5bE4SKYimA3Ee37CDf3yo64RQGbX0BLTM/ZXVtCTSO901H1nG6xMLGYhISj61A4DKWIQnPnVOukO5q/2V1Ywkkp/uagqe47VIQdTvauazeSSEqliELy+c1W6EkfZXFum77moKs83sLYIaw/DwNeGxa59m6U8r6xq5fvnGrJvgZPrb957IX777xE5P/6n9lRd36FNQLUEkf10mBXePDlQgMrTV72rm+uUbaemiilARNW5dMJMrzjo+5zXaX1mkb/IdkipSMCvrGrn+kQ2dhpqmxCJw7fyTufysqXnd5LW/skjvKSlIUaVGDGVLCBVR465L5zD3pGrd5EUGiJKCFFW2EUMQjCz68sJZXDR7YpEiExma8l3mosfMbIqZrTOzLWa22cyuDcuPNrOnzOyV8Pu4sNzM7OtmVm9mG83sjELFJsXRdCDOhu372s0byDZiqDJqPPGpczTpTKQICpYUgDbgOnc/lWAxvWvM7FSCfRnWuPsMYA1H9mm4AJgRfi0C7ilgbDLAlq3fxtwvruHy/1jPvNvXsqou2B0tNWJoWEWEUVUxhlVE+PJHZ2sxO5EiKVjzkbu/AbwRvm42sxeASQRLZrwvvOwB4KcE+z1fDDzo7g6sN7OxZnZc+DlSxpat38ZNj24CoCWRAGDxio3Mmz6e6pFVGjEkUkIGpE/BzKYBpwPPAhMybvQ7gQnh60nA9oy3NYRl7ZKCmS0iqEkwdar2+SllwUJ2b7H0sc2dzkXN2s001oghkdJQ8KQQrq66Avi0u79ldmTlDHd3M+vRTGl3vxe4F6CmpkazrEvUvT97lTt+/CJRs6wji1oTmmksUooKmhTMrIIgISxz9x+ExbtSzUJmdhzBTm4AjcCUjLdPDsukzPzD//yGVRuCCl5bjtVRbvnwTNUMREpQIUcfGXA/8IK7fzXj1CrgqvD1VcDKjPIrw1FIZwP71Z9QXpoOxLl15W/TCaGj4RVRKmMRvvAnp3HF2blnJRciro6jnkQku0LWFOYBnwB+a2Z1Ydk/AV8CHjazq4FtwKXhuSeAC4F64G3gkwWMTfrZsvXbuPWxzbTmmJUcAb79iTOYOXHMgNYQtL+CSM8UcvTR07RfejvT/CzXO3BNoeKRwmg6EOcba17hu7/c1uV1kQjse7sVgA3b9w3IKKPM/RVSk+MyRz2JSGea0Sy9tmz9Nm5+dBPdLGoKQFsSrntkAxGDymh0QJ7atb+CSM8pKUiP5Vs76CjVtBRvawMK/9Su/RVEeq6QM5plEPr2z17lzC/8pMcJIZvUU3uhZJstrf0VRLqmmoLkLXOoaU+MqIzSlnQSyWS7HdUG4qlds6VFekZJQfJy15Mv9SghHFUZIelw80WnctrEMUweN5xn6t8syq5omi0tkj8lBelS/a5mbv/fF3jqxT15v6cqFuHzC07j3FPe0e5mrKd2kdKnpCBZ1e9q5tMPPc+mHc1dXmdALGrt5ieY0SkhpAzFp/amA3ElQikbSgrSyece/S0Prv9dt9edPmUMdy6czZY33ipKs1A50OQ5KTcWzBkrTzU1NV5bW1vsMAaV+l3NvP+un3d7XdSMoyqPzDdQs1BnTQfizLt9LYdbj/SuD6uI8MyS8/RvJEVlZs+5e022cxqSKkBwA3t8ww7+9YkX8ro+4U5zvI3DrUkWr9gIwOwpY3Wzy5CaPJep0MNwRfpKzUfCZx+uY/lv8l+QtjIaoSWhWcLd0eQ5KUeqKQxxM29+oocJwbAOK1rpRpedJs9JOVJNYYiq39XMXz34aw629qxP6WNnTqHm+KPVsZwnDcOVcqOO5iFo8SN1PPxc97WDa953Ivc9vZV4xjTkqliEX9xwHoBudCJlSh3NAsCaLTv54Fd/mldCuHLuVD448zgqo+3/ROJtSb737O+oHlmljmWRQUjNR0PEu29fw/a9h/O6dvlfn03NCdU0HYi361BOuXvNy1x+1tQeJwRN4hIpfaopDHJNB+KceduTeSeEL/zJadScUA0EHaV/MW9ap2vakrB5x/705+ez1eXKukbm3b6Wj9/3LH/0pTV8Y80reW2Pqa00RQaWagqD2LL127jp0U3dXjf16GHs2HeYqliU2x7fwqiqWHrW7dyTxnPPz17r9J5fvtrE3rdb85qtm20HtK889TLfXFfPnQtzz/DVbGCRgaeawiB115Mv5ZUQPnHWFHY3t9CWhIMtifRktNST+cyJo4lm2VT1O89sZfHyDRxuTbabxJbtiT7bJC4I+idyvSczkXT3+SLSf5QUBpna15v4oy/+hLvX1nd7rQEfmHksnmw/As2Tnp51Wz2yik+//+RO741GjKjlN1s32ySu7t6j2cAixaGkMIhc+LWfsfDb69mxP7+n6ZFVMd461EY80T4pxBPOiMpo+vjys6ZSFWv/p5JIOgnPb7ZuahJXVaxzlSPXezQbWKQ4lBQGgfpdzZx802q27DzQo/e1JpOMHh7MtM00rCLCwZZE+rh6ZBV3Lmw/M/fOhbO4c+HsvGfrLpgziV/cMJ/rPnAyVbHu31Nqs4HV4S1DhTqay9yl//4Mv9q6r0fvqYoaFjHuuGQWMyeOIdv8xY5P5Llm5vZktm71yCo+NX8Gl581Na/3lMpsYHV4y1CipFDG3nnTauKJ7q/LFDX4i3NO4C/ffSLVI6tYWddIIqOZpiJqXT69dyzvzaY5PXlPsTflyTZyavGKjcybPl5zLWRQUvNRGarf1dyrhACQcLjnZ6/xo8070ze8jFUsMJx508fn/XmDvVlFHd4y1BQsKZjZd8xst5ltyig72syeMrNXwu/jwnIzs6+bWb2ZbTSzMwoVV7n75Hd+xfvv+nmvEkKmpY9tYfOOtzrd8FoS8L1nc++6lpkEMiekzbt9Lavq8l9ttVyow1uGmkLWFL4LnN+h7AZgjbvPANaExwAXADPCr0XAPQWMqyw1HYhz+tIfse7lPXldXxE1IlnmF2SeB6cl0Tm7fHNdfdYn//azktdy3cN1g34eQal1eIsUWsH6FNz952Y2rUPxxcD7wtcPAD8FloTlD3qwZOt6MxtrZse5+xuFiq+c3PXkS3nNO8jUmvAuk0Jrwpk4Zjh/f+4MvvLUy+3OVUY7b5qTrW29o8G62U6pdHiLDISB7lOYkHGj3wlMCF9PArZnXNcQlnViZovMrNbMavfsye+puVyt2bKTmZ97oscJISWZZVRRZTg92dy56JtPc/SIyk5zELI1j+Saldzd+wYLrQorQ0XRRh+5u5tZjzdzcPd7gXsh2E+h3wMrEbOX/i/7D2V/Iu+LlnCiWjzhkHBuW72Fi+dM5OHahvQ1l9ZM7nTzy9a2nmqiqoxGtdmOyCAx0ElhV6pZyMyOA3aH5Y3AlIzrJodlQ9K0G1YP2M+KmvFo3Y52ZQ/XNnDt/JPb3eBTbesdd1xTs4rI4DLQSWEVcBXwpfD7yozyvzez7wNnAfuHYn/Cf//idf551ZZ++7xLaybz6PON6dpBNq2JJJWxCC1tR8py9Q3kaluvHlmVHpWk5CBS3gqWFMzsfwg6lcebWQNwC0EyeNjMrga2AZeGlz8BXAjUA28DnyxUXKXq5BtX09KDxrBg7FBuIyqjXHHW8Sx694lc+I2naWlLdjqfcOfmD53KbavbJ6Ku+gayTSbTjF+RwaOQo48uy3FqfpZrHbimULGUsjVbdnL1g8/1+H3d5Y+2ZJL9h1qYPG4MX17Yvtnn5otO5bSJY9JP9aOGxTo1C+X7tN+TGb/aeU2k9GmZiyKa98WnaNzf0i+fldnpe6i1jaTDNcueT9/kn1lyXs4bcldDLru7kadGJWUOU83W/KTahEh5UFIoknfd+gTNh/s2eKoyalTFou06fTfveIu/erCWeFuS1kTQUbB4xUaeWXIes6eMzflZvW0WymfGr9YPEikfSgpFcMINq7tt/unOlXOncu38k2nYe4gRldH0UtdjhldQGY0Qb+v6yb07+d7IM0clRSNGa8K5+aJT212Tb21CRIpPSWEA1b7exMJvr+/TZ5w2cRR/896TOOXY0TTsPcSmxv3ctnpLu/6C/lirpyc38gVzJtF8uI2lj22mIhrptM+z1g8SKR9KCgPk9KU/Yu+hPq5iB7y4s5nrHt5APOFUxY7UCFI379se35IeUdSbjuOUntzImw7EuW31FloSR9ZSyqxV5JrjoFqCSOlRUiiw3o4uyqUtCW1h41O8rfOM54pIhNMmjemyYzkf1SOruPmiU1n62BYqokYiGTQLZe7dnJJPrULrB4mUByWFAqr5/I958+227i/MUwRyLEV3REsiyYjKaLc33+5GFa2sa+S2x7dQETFa25J8ZM7E8Lhzp3O+tYpib5hTSjQ8V0qVeba9GMtETU2N19bWFjuMThZ991mefPHNfvu8aMRYeMYkHq1rJN7W9X+viAVfwytiOUcMdTeqqOlAnHm3r+Vwa+4UNKwiwjNLzkvf0FbVNXZqHtKQ0+w0PFeKzcyec/eabOdUU+hn/b1uUYRgC80nfruTpAevu1i1gqQHX83xI8NRM0cM5TOqKFtzUEdqHuqdgRyeq9qI9IaSQj8qxEJ2SQg7cIObfFUsQsSd1q4yQ4ZoxFj34m7OPeUdVI+syqv9P1tzUEcD2Tw0mG5uAzU8V7UR6S3t0dwP/vsXrw/YyqaV0Qj/cN4MhlVEOKoyQjQCsS520zkYT3DLqs3p7TLzaf/PttvYlXOnFmX3scG25edADM/NrI0M5l3xpDBUU+ijgVzmGiDeluCC047l6BGVLH1sM8NiUeJtCSqixrBYlMNtCdydqoooB8ONnFMT21Izm/MZHpqtOSg1WW6gntgH40zogRieq8mC0hdKCr30/i+vpf7NQwP+c82MD33jaRLJJG1J0vMCqmLwrStOZ+bEMQCse3E3t6zanE4IcOTGkG/7f8fmoIEePTRYb26F7n/RZEHpCzUf9cK0G1YXJSFAMDch3hYkhEyV0Shjhlemb9znnvIOEh1GlmXeGMphe8nBfHMr5L9/tuY/TRaUfKmm0ANn3vZjdh/sv3kHKbGI0ZZtQ+UeyNUvUC6ziLN1Jpfb71BKNBpMektJIU+F7Dvoa0IAuPlDp+bVL9CV3o7y6evooK5Gyujm1nuaLCi9oaSQh4HuTO6oImokk55zfsKIqiinTRqTPu54k87nxtDxxtxxI55839fToY/5dCbr5iYycJQUunDSDavp+xJ2fVMVMz734Zl8/rHNJHLMZk4kPd10lLpJR81oTSS55cMzueLs47O+L5U8RlRGO92Yb/rhJkZURmlLOn9/7nQuP2tqpxtz/a5mrn9kAy0J7/XooMHamSxSrpQUcih27QDgqMoo//7xM3jPye9gVFWMzzxc166DuTJqRCLGHZfMAuDnL+9m8fIN7ZbCuOnRTWBwxVntE0PmE348kcSyLHeSGrn0lade5pvrXuHOhbPTtYCVdY1cv3wjLR2qLz29oQ/mzmSRcqSk0EEpJIOURNLTQ0xTbev/8X+vcf/Tr1MRdk7f/KFTaT7cxtwvrSVqlnVtpKWrNnP+zGO7XOqiO/E2T9cCAJas2EhLllVae3pDHwydyaUy47pU4pDypqSQoZQSAsAlZ7RfpG7zjv385zOv05o4sszFPz+6qdtd3FoSzvee/R2fmj8DyN5kUxmN0JLoOkGkagGp1x0TSmXUenVD78se0cVWKstJlEocUv6UFEKllhAg+B/9B883cmnNZB76dQMGnWoC+Y5b+ua6V9L9AtmabJLuxAy6WoQ1sxbQ8f0VUeOrl85h7knVeUbUXm/3iC6mUplxXSpxyOCgyWuUZkIAONiS5HBrkgd/+TvibUkOZ2muySbbf9TKaLDHQv2uZta9uJu/fveJVMYi6XWT2pJOm4MRjGbKJjXstePkqFj4A2/8wW/T6xM1HYizYfu+duvtZCvLpRzW70nVuDJl1qZ6qyf/ToWMQ4amIV1TKNVk0FeRSDCENVO8LcH9T7/Gqg1vHLmOzpv2OPB37z2Jf/vpq+2WyOg47DXV5Pmj7KoAAAtwSURBVLN5x1v81YO1xNuStIYruV73yAYiFiSi1BO+Q4+e+vtjVFKhm54K0Unem9qROuulPw3ZpDBYE0I0x+xod2+XECD3Lm4jqqKdlsjIHPaaOZR191uHiUWMzGfaVH9HvC1IEtcv3wBYUNvJ0ryR7ebd3Y0un53j2s27+NCpnDap/byL7j6ju/OZneTRiNGaCLYs7W0C6m0z0GDorJfSUVJJwczOB+4GosB97v6lQvycwZoQILh5Z9PFJmqdxMz4oxOq+dkrexhWEaUtmeSa900HYNn6bSx9fEvYv5GkMmqdhqV2FLVI1kTVsPcQT9e/mXPSXK4bXT47x6WG5qbnXTy6iZFVwbyLVM1l8fLgZp5IOncubP8ZK+saWbx8AxGMNk/yd++bzpRxRzFnyljGjahMJ8Xjq0fwmfefzJeffImKaITbHt/CqKpYr/o++lI7ytZZX+qd9FKaSmY7TjOLAi8DHwAagF8Dl7n7llzv6c12nIM5IRSCEWzveVRljEOtbZ0W4uuoImq0JbxdB3iu3eKW//XZfPw7v+q07eeIyqCmcscls7Le6DpuFdpxa9Cvr3mFrz71cs4Yq2JG0mm3UVFF1Fh/4/z0zzjrX3+S83eNRoyYQTzhVMUixDtc2DGefOXzu+Wr1Dvppbi62o6zlDqazwTq3f01d28Bvg9c3J8/QAmh55zght4c7z4hABhOLNp+0x8zo7LDX1pV1Nja9HanDlIIJs2lOpaBdquJdtep2nQgzrfW1Xcdo1mnnetaE87mHfsB2LzjrS5/10TSiaebyDpf2NtO3v5a3bQcOumldJVS89EkYHvGcQNwVseLzGwRsAhg6tSpAxOZ5C0WiYJBa+JIJ3VVRYTWtiSZA2gtYsyZMrbLbT+zNZ1019fQsPcQldHOT++ZcjWxBfUiyH+gb3Z96eTtjwUAtXSI9EUp1RTy4u73unuNu9ccc8wxxQ5HOkh4stNNN5F0bvnwzE5PwNMnjEo/GWcbBptrH+iunqazJY2oBXtbp66/dcHM9DDalFgEZk4cDcDMiWM6nc/HiMpov+xd0Ne9FjQaSfqilGoKjcCUjOPJYVm/2fqlD5VcE5IRPJdWRYMmjXz7gyMGqXuvAe+aNIqNjc3tPvdv3nsiz/9uL+tf35v15xrB8NVUZys4iWT752QDohEYXhFLb/UZAVqSUBmFRBLMgvOptmugUwfxgjmTOP+0Yzs9AWc+GW9q3M9tq7d0O4Kmq6fpXCNxOl4/qirG9cs3ELUICU9y58LZ7VZl/eqlc/jHh+qy9oVk9ikMqwiyR76ryg4EjUaSviiljuYYQUfzfIJk8GvgcnffnOs9velohvz7FoZF4bixw2lLJDkYT9CaSJLEGXdUJcMroiTdmDJuOPNmjMeArU1vc3z1UbzZHOeZV96ksiLCuyaO4UBrgmQySTRivPPY0YysihFvS3LaxNFUxKKMqIxysCWRfpJ7cvNONu94i2nVR3HysaOZOXE0ew+28OPNOwHnj2cex7gRlWEbuDFz4miqR1ZRv6uZp+vfZPzISuaedGQYY+3rTfx4yy5GVkYZc1Rl+udmNrlkvn6z+TC/fO33TD9mBB+YeWzWazrG3PEGXay9GXryOfkMSd284y3AOaoiytamtzuNPkr9G5TiDVejjySXrjqaSyYpAJjZhcDXCIakfsfdv9DV9b1NCiIiQ1lXSaGUmo9w9yeAJ4odh4jIUFV2Hc0iIlI4SgoiIpKmpCAiImlKCiIiklZSo496ysz2ANt6+fbxwJv9GM5AUuzFU87xK/biKbX4j3f3rLN/yzop9IWZ1eYaklXqFHvxlHP8ir14yil+NR+JiEiakoKIiKQN5aRwb7ED6APFXjzlHL9iL56yiX/I9imIiEhnQ7mmICIiHSgpiIhI2pBLCmZ2vpm9ZGb1ZnZDsePJxsy+Y2a7zWxTRtnRZvaUmb0Sfh8XlpuZfT38fTaa2RnFixzMbIqZrTOzLWa22cyuLZf4zWyYmf3KzDaEsS8Ny08ws2fDGB8ys8qwvCo8rg/PTytW7ClmFjWz583s8fC4nGLfama/NbM6M6sNy0r+7yaMZ6yZLTezF83sBTObWy6xdzSkkoKZRYFvARcApwKXmdmpxY0qq+8C53couwFY4+4zgDXhMQS/y4zwaxFwzwDFmEsbcJ27nwqcDVwT/huXQ/xx4Dx3nw3MAc43s7OB24G73H06sBe4Orz+amBvWH5XeF2xXQu8kHFcTrEDnOvuczLG9JfD3w3A3cCP3P0UYDbBf4Nyib09dx8yX8Bc4McZxzcCNxY7rhyxTgM2ZRy/BBwXvj4OeCl8/W3gsmzXlcIXsBL4QLnFDxwF/IZgn/A3gVjHvyHgx8Dc8HUsvM6KGPNkgpvPecDjBBvnlUXsYRxbgfEdykr+7wYYA7ze8d+vHGLP9jWkagrAJGB7xnFDWFYOJrj7G+HrncCE8HXJ/k5hk8TpwLOUSfxh80sdsBt4CngV2OfubVniS8cent8PVA9sxO18DVgM6V1dqymf2CHYCfZJM3vOzBaFZeXwd3MCsAf4z7Dp7j4zG0F5xN7JUEsKg4IHjxclPZbYzEYCK4BPu/tbmedKOX53T7j7HIKn7jOBU4ocUl7M7CJgt7s/V+xY+uAcdz+DoHnlGjN7T+bJEv67iQFnAPe4++nAQY40FQElHXsnQy0pNAJTMo4nh2XlYJeZHQcQft8dlpfc72RmFQQJYZm7/yAsLpv4Adx9H7COoMllrAV7iEP7+NKxh+fHAE0DHGrKPGCBmW0Fvk/QhHQ35RE7AO7eGH7fDfyQICmXw99NA9Dg7s+Gx8sJkkQ5xN7JUEsKvwZmhCMyKoGPAauKHFO+VgFXha+vImirT5VfGY5oOBvYn1FlHXBmZsD9wAvu/tWMUyUfv5kdY2Zjw9fDCfpCXiBIDgvDyzrGnvqdFgJrwyfCAefuN7r7ZHefRvB3vdbdr6AMYgcwsxFmNir1GvggsIky+Ltx953AdjN7Z1g0H9hCGcSeVbE7NQb6C7gQeJmgrfimYseTI8b/Ad4AWgmeQq4maO9dA7wC/AQ4OrzWCEZUvQr8FqgpcuznEFSTNwJ14deF5RA/MAt4Pox9E/C5sPxE4FdAPfAIUBWWDwuP68PzJxb7byeM633A4+UUexjnhvBrc+r/zXL4uwnjmQPUhn87jwLjyiX2jl9a5kJERNKGWvORiIh0QUlBRETSlBRERCRNSUFERNKUFEREJE1JQSQHM/uImbmZnRIevy+1+miBf+6A/ByRbJQURHK7DHg6/F4w4eq9IiVBSUEki3DtpnMIJg5+LOPUaDNbbcGeHP9uZpHw+svCvQA2mdntGZ9zj5nVWsb+DGH5VjO73cx+A3zUgn0+XgyP/3RgfkuRzmLdXyIyJF1MsD7+y2bWZGZ/EJafSbAXxzbgR8CfmtkvCPYj+AOCPQueNLOPuPujBDNzfx/WBtaY2Sx33xh+VpO7n2FmwwhmvZ5HMMP4oQH7LUU6UE1BJLvLCBaWI/yeakL6lbu/5u4JguVIzgH+EPipu+/xYBnqZUBqhc9Lw6f/54GZBAklJXXzPwV43d1f8WCJgf8u1C8l0h3VFEQ6MLOjCZ7a32VmDkQJ1nNaTeflj3OuE2NmJwCfBf7Q3fea2XcJ1hxKOdifcYv0B9UURDpbCPyXux/v7tPcfQrBzlrvBs4MV9mNAH9G0BH9K+C9ZjY+bCa6DPgZMJrgxr/fzCYQ7BOQzYvANDM7KTwuaMe2SFdUUxDp7DI671m8AvhbguXXvwlMJ1iW+ofunjSzG8JjA1a7+0oAM3ue4Ka/HXgm2w9z98PhTmOrzext4P+AUf3+W4nkQaukiohImpqPREQkTUlBRETSlBRERCRNSUFERNKUFEREJE1JQURE0pQUREQk7f8DGN44jS8NGCYAAAAASUVORK5CYII=\n"
          },
          "metadata": {
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "def std_based(col_name,df):\n",
        "    mean = df[col_name].mean()\n",
        "    std = df[col_name].std()\n",
        "    cut_off = std * 2\n",
        "    lower, upper = mean - cut_off, mean + cut_off\n",
        "    new_df = df[(df[col_name] < upper) & (df[col_name] > lower)]\n",
        "    return new_df"
      ],
      "metadata": {
        "id": "iAP2bPMOKW7h"
      },
      "execution_count": 36,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "**REMOVING OUTLIERS OF FATALITIES COLUMN :**"
      ],
      "metadata": {
        "id": "axGtVPa9TpDF"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "fatality_cols = ['Fatalities']"
      ],
      "metadata": {
        "id": "dhvcG0DmNGmE"
      },
      "execution_count": 37,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "print(f\"dataset size before removing outliers= {data.shape[0]}\")\n",
        "for col in fatality_cols:\n",
        "    data = std_based(col, data)\n",
        "print(f\"dataset size after removing outliers= {data.shape[0]}\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "uyiKrPLCMCpi",
        "outputId": "8841270f-4794-4e72-a059-e53f82bd3643"
      },
      "execution_count": 38,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "dataset size before removing outliers= 4909\n",
            "dataset size after removing outliers= 4691\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "**REMOVING OUTLIERS OF ABOARD COLUMN :**"
      ],
      "metadata": {
        "id": "X4353m6eUUCc"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "abroad_cols = ['Aboard']"
      ],
      "metadata": {
        "id": "eFR-7GU0RZ3E"
      },
      "execution_count": 39,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "print(f\"dataset size before removing outliers= {data.shape[0]}\")\n",
        "for col in abroad_cols:\n",
        "    data = std_based(col, data)\n",
        "print(f\"dataset size after removing outliers= {data.shape[0]}\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "3-pnFHwzRQUr",
        "outputId": "0b0251a9-a756-405f-fe7b-526ca44c40ba"
      },
      "execution_count": 40,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "dataset size before removing outliers= 4691\n",
            "dataset size after removing outliers= 4533\n"
          ]
        }
      ]
    }
  ]
}