3.5 pandas简单分析 空难数据.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "1a466e6a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "825f686b",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv('./dataset/air1908.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "e12f0765",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 5268 entries, 0 to 5267\n",
      "Data columns (total 13 columns):\n",
      " #   Column        Non-Null Count  Dtype  \n",
      "---  ------        --------------  -----  \n",
      " 0   Date          5268 non-null   object \n",
      " 1   Time          3049 non-null   object \n",
      " 2   Location      5248 non-null   object \n",
      " 3   Operator      5250 non-null   object \n",
      " 4   Flight #      1069 non-null   object \n",
      " 5   Route         3562 non-null   object \n",
      " 6   Type          5241 non-null   object \n",
      " 7   Registration  4933 non-null   object \n",
      " 8   cn/In         4040 non-null   object \n",
      " 9   Aboard        5246 non-null   float64\n",
      " 10  Fatalities    5256 non-null   float64\n",
      " 11  Ground        5246 non-null   float64\n",
      " 12  Summary       4878 non-null   object \n",
      "dtypes: float64(3), object(10)\n",
      "memory usage: 535.2+ KB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "9f33bd30",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>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>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>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>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>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",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Date   Time                            Location  \\\n",
       "0  09/17/1908  17:18                 Fort Myer, Virginia   \n",
       "1  07/12/1912  06:30             AtlantiCity, New Jersey   \n",
       "2  08/06/1913    NaN  Victoria, British Columbia, Canada   \n",
       "3  09/09/1913  18:30                  Over the North Sea   \n",
       "4  10/17/1913  10:30          Near Johannisthal, Germany   \n",
       "\n",
       "                 Operator Flight #          Route                    Type  \\\n",
       "0    Military - U.S. Army      NaN  Demonstration        Wright Flyer III   \n",
       "1    Military - U.S. Navy      NaN    Test flight               Dirigible   \n",
       "2                 Private        -            NaN        Curtiss seaplane   \n",
       "3  Military - German Navy      NaN            NaN  Zeppelin L-1 (airship)   \n",
       "4  Military - German Navy      NaN            NaN  Zeppelin L-2 (airship)   \n",
       "\n",
       "  Registration cn/In  Aboard  Fatalities  Ground  \\\n",
       "0          NaN     1     2.0         1.0     0.0   \n",
       "1          NaN   NaN     5.0         5.0     0.0   \n",
       "2          NaN   NaN     1.0         1.0     0.0   \n",
       "3          NaN   NaN    20.0        14.0     0.0   \n",
       "4          NaN   NaN    30.0        30.0     0.0   \n",
       "\n",
       "                                             Summary  \n",
       "0  During a demonstration flight, a U.S. Army fly...  \n",
       "1  First U.S. dirigible Akron exploded just offsh...  \n",
       "2  The first fatal airplane accident in Canada oc...  \n",
       "3  The airship flew into a thunderstorm and encou...  \n",
       "4  Hydrogen gas which was being vented was sucked...  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "646352e0",
   "metadata": {},
   "outputs": [],
   "source": [
    "top10 = data.Type.value_counts()[:10].index  # 空难次数最多的前十种机型"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "313173d7",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_top_10 = data[data.Type.isin(top10)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "6c824113",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "753"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data_top_10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "41812535",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date            753\n",
       "Time            291\n",
       "Location        750\n",
       "Operator        752\n",
       "Flight #         91\n",
       "Route           458\n",
       "Type            753\n",
       "Registration    705\n",
       "cn/In           610\n",
       "Aboard          749\n",
       "Fatalities      750\n",
       "Ground          750\n",
       "Summary         688\n",
       "dtype: int64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_top_10.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "76023418",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Kunming, China                    4\n",
       "Bogota, Colombia                  4\n",
       "Sao Paulo, Brazil                 4\n",
       "Nagpur, India                     3\n",
       "New Delhi, India                  3\n",
       "                                 ..\n",
       "North of San Juan, Puerto Rico    1\n",
       "Delhi,  India                     1\n",
       "Near Skien, Norway                1\n",
       "Ipoh, Malaysia                    1\n",
       "Lukla, Nepal                      1\n",
       "Name: Location, Length: 705, dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_top_10.Location.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "eeb42da5",
   "metadata": {},
   "outputs": [],
   "source": [
    "data['su'] = (data.Aboard - data.Fatalities)/data.Aboard  # 生存率"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "9d6bda5b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <td>09/17/1908</td>\n",
       "      <td>07/12/1912</td>\n",
       "      <td>08/06/1913</td>\n",
       "      <td>09/09/1913</td>\n",
       "      <td>10/17/1913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Time</th>\n",
       "      <td>17:18</td>\n",
       "      <td>06:30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18:30</td>\n",
       "      <td>10:30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Location</th>\n",
       "      <td>Fort Myer, Virginia</td>\n",
       "      <td>AtlantiCity, New Jersey</td>\n",
       "      <td>Victoria, British Columbia, Canada</td>\n",
       "      <td>Over the North Sea</td>\n",
       "      <td>Near Johannisthal, Germany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Operator</th>\n",
       "      <td>Military - U.S. Army</td>\n",
       "      <td>Military - U.S. Navy</td>\n",
       "      <td>Private</td>\n",
       "      <td>Military - German Navy</td>\n",
       "      <td>Military - German Navy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Flight #</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Route</th>\n",
       "      <td>Demonstration</td>\n",
       "      <td>Test flight</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Type</th>\n",
       "      <td>Wright Flyer III</td>\n",
       "      <td>Dirigible</td>\n",
       "      <td>Curtiss seaplane</td>\n",
       "      <td>Zeppelin L-1 (airship)</td>\n",
       "      <td>Zeppelin L-2 (airship)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Registration</th>\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>cn/In</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aboard</th>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fatalities</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ground</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Summary</th>\n",
       "      <td>During a demonstration flight, a U.S. Army fly...</td>\n",
       "      <td>First U.S. dirigible Akron exploded just offsh...</td>\n",
       "      <td>The first fatal airplane accident in Canada oc...</td>\n",
       "      <td>The airship flew into a thunderstorm and encou...</td>\n",
       "      <td>Hydrogen gas which was being vented was sucked...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>su</th>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                              0  \\\n",
       "Date                                                 09/17/1908   \n",
       "Time                                                      17:18   \n",
       "Location                                    Fort Myer, Virginia   \n",
       "Operator                                   Military - U.S. Army   \n",
       "Flight #                                                    NaN   \n",
       "Route                                             Demonstration   \n",
       "Type                                           Wright Flyer III   \n",
       "Registration                                                NaN   \n",
       "cn/In                                                         1   \n",
       "Aboard                                                      2.0   \n",
       "Fatalities                                                  1.0   \n",
       "Ground                                                      0.0   \n",
       "Summary       During a demonstration flight, a U.S. Army fly...   \n",
       "su                                                          0.5   \n",
       "\n",
       "                                                              1  \\\n",
       "Date                                                 07/12/1912   \n",
       "Time                                                      06:30   \n",
       "Location                                AtlantiCity, New Jersey   \n",
       "Operator                                   Military - U.S. Navy   \n",
       "Flight #                                                    NaN   \n",
       "Route                                               Test flight   \n",
       "Type                                                  Dirigible   \n",
       "Registration                                                NaN   \n",
       "cn/In                                                       NaN   \n",
       "Aboard                                                      5.0   \n",
       "Fatalities                                                  5.0   \n",
       "Ground                                                      0.0   \n",
       "Summary       First U.S. dirigible Akron exploded just offsh...   \n",
       "su                                                          0.0   \n",
       "\n",
       "                                                              2  \\\n",
       "Date                                                 08/06/1913   \n",
       "Time                                                        NaN   \n",
       "Location                     Victoria, British Columbia, Canada   \n",
       "Operator                                                Private   \n",
       "Flight #                                                      -   \n",
       "Route                                                       NaN   \n",
       "Type                                           Curtiss seaplane   \n",
       "Registration                                                NaN   \n",
       "cn/In                                                       NaN   \n",
       "Aboard                                                      1.0   \n",
       "Fatalities                                                  1.0   \n",
       "Ground                                                      0.0   \n",
       "Summary       The first fatal airplane accident in Canada oc...   \n",
       "su                                                          0.0   \n",
       "\n",
       "                                                              3  \\\n",
       "Date                                                 09/09/1913   \n",
       "Time                                                      18:30   \n",
       "Location                                     Over the North Sea   \n",
       "Operator                                 Military - German Navy   \n",
       "Flight #                                                    NaN   \n",
       "Route                                                       NaN   \n",
       "Type                                     Zeppelin L-1 (airship)   \n",
       "Registration                                                NaN   \n",
       "cn/In                                                       NaN   \n",
       "Aboard                                                     20.0   \n",
       "Fatalities                                                 14.0   \n",
       "Ground                                                      0.0   \n",
       "Summary       The airship flew into a thunderstorm and encou...   \n",
       "su                                                          0.3   \n",
       "\n",
       "                                                              4  \n",
       "Date                                                 10/17/1913  \n",
       "Time                                                      10:30  \n",
       "Location                             Near Johannisthal, Germany  \n",
       "Operator                                 Military - German Navy  \n",
       "Flight #                                                    NaN  \n",
       "Route                                                       NaN  \n",
       "Type                                     Zeppelin L-2 (airship)  \n",
       "Registration                                                NaN  \n",
       "cn/In                                                       NaN  \n",
       "Aboard                                                     30.0  \n",
       "Fatalities                                                 30.0  \n",
       "Ground                                                      0.0  \n",
       "Summary       Hydrogen gas which was being vented was sucked...  \n",
       "su                                                          0.0  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head().T # 转置方便显示"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "eb5f1c9b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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",
       "      <th>su</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>10/21/1926</td>\n",
       "      <td>13:15</td>\n",
       "      <td>English Channel</td>\n",
       "      <td>Imperial Airways</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Handley Page W-10</td>\n",
       "      <td>G-EBMS</td>\n",
       "      <td>W10/3</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>The plane was on a flight from London to Paris...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5074</th>\n",
       "      <td>12/08/2005</td>\n",
       "      <td>19:15</td>\n",
       "      <td>Chicago, Illinois</td>\n",
       "      <td>Southwest Airlines</td>\n",
       "      <td>1248</td>\n",
       "      <td>Baltimore, Maryland - Chicago, Illinois - Las ...</td>\n",
       "      <td>Boeing B-737-7H4</td>\n",
       "      <td>N471WN</td>\n",
       "      <td>32471/1535</td>\n",
       "      <td>103.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The jetliner slid off Runway 13C at Chicago's ...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3428</th>\n",
       "      <td>07/23/1983</td>\n",
       "      <td>19:30</td>\n",
       "      <td>Gimli, Manitoba, Canada</td>\n",
       "      <td>Air Canada</td>\n",
       "      <td>143</td>\n",
       "      <td>Ottawa - Edmonton</td>\n",
       "      <td>Boeing B-767-233ER</td>\n",
       "      <td>C-GAUN</td>\n",
       "      <td>22520/47</td>\n",
       "      <td>69.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>The aircraft took off from Ottawa bound for Ed...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4199</th>\n",
       "      <td>08/18/1993</td>\n",
       "      <td>16:56</td>\n",
       "      <td>Leeward Point Airfield, Guantanamo Bay, Cuba</td>\n",
       "      <td>American International Airways</td>\n",
       "      <td>808</td>\n",
       "      <td>Norfolk, VA - Guantanamo, Cuba</td>\n",
       "      <td>McDonnell Douglas DC-8-61</td>\n",
       "      <td>N814CK</td>\n",
       "      <td>46127</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>The plane crashed 1/4 of a mile short of the r...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3417</th>\n",
       "      <td>05/05/1983</td>\n",
       "      <td>09:15</td>\n",
       "      <td>En route Miami, FL - Nassau, Bahamas</td>\n",
       "      <td>Eastern Air Lines</td>\n",
       "      <td>855</td>\n",
       "      <td>Miami, FL - Nassau, Bahamas</td>\n",
       "      <td>Lockheed L-1011</td>\n",
       "      <td>N334EA</td>\n",
       "      <td>1141</td>\n",
       "      <td>172.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Procedural error by maintenance crew caused O-...</td>\n",
       "      <td>1.0</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>3369</th>\n",
       "      <td>08/11/1982</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PacifiOcean</td>\n",
       "      <td>Pan American World Airways</td>\n",
       "      <td>830</td>\n",
       "      <td>Tokyo - Honolulu</td>\n",
       "      <td>Boeing B-747-121</td>\n",
       "      <td>N754PA</td>\n",
       "      <td>19658/47</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>A sixteen-year-old boy was killed when a bomb ...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3611</th>\n",
       "      <td>03/27/1986</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bangui, Central African Republic</td>\n",
       "      <td>Military - French Air Force</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sepecat Jaguar A</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>The jet fighter crashed into a school shortly ...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3843</th>\n",
       "      <td>05/09/1989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Near Tainjin, China</td>\n",
       "      <td>Aero Asahi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bell 412</td>\n",
       "      <td>JA9596</td>\n",
       "      <td>33070</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4080</th>\n",
       "      <td>02/20/1992</td>\n",
       "      <td>NaN</td>\n",
       "      <td>En route from Argentina  to  California</td>\n",
       "      <td>Aerolineas Argentinas</td>\n",
       "      <td>386</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Boeing B-747</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>A passenger died of cholera while en route.</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4705</th>\n",
       "      <td>03/22/2000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Herreira, Spain</td>\n",
       "      <td>Military - Ejército del Aire</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sevilla - Herreira</td>\n",
       "      <td>CASA 212-DE Aviocar 200</td>\n",
       "      <td>TM-12D-73</td>\n",
       "      <td>314</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Crashed while attempting to land in poor weather.</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5268 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Date   Time                                      Location  \\\n",
       "108   10/21/1926  13:15                               English Channel   \n",
       "5074  12/08/2005  19:15                             Chicago, Illinois   \n",
       "3428  07/23/1983  19:30                       Gimli, Manitoba, Canada   \n",
       "4199  08/18/1993  16:56  Leeward Point Airfield, Guantanamo Bay, Cuba   \n",
       "3417  05/05/1983  09:15          En route Miami, FL - Nassau, Bahamas   \n",
       "...          ...    ...                                           ...   \n",
       "3369  08/11/1982    NaN                                   PacifiOcean   \n",
       "3611  03/27/1986    NaN              Bangui, Central African Republic   \n",
       "3843  05/09/1989    NaN                           Near Tainjin, China   \n",
       "4080  02/20/1992    NaN       En route from Argentina  to  California   \n",
       "4705  03/22/2000    NaN                               Herreira, Spain   \n",
       "\n",
       "                            Operator Flight #  \\\n",
       "108                 Imperial Airways      NaN   \n",
       "5074              Southwest Airlines     1248   \n",
       "3428                      Air Canada      143   \n",
       "4199  American International Airways      808   \n",
       "3417               Eastern Air Lines      855   \n",
       "...                              ...      ...   \n",
       "3369      Pan American World Airways      830   \n",
       "3611     Military - French Air Force      NaN   \n",
       "3843                      Aero Asahi      NaN   \n",
       "4080           Aerolineas Argentinas      386   \n",
       "4705    Military - Ejército del Aire      NaN   \n",
       "\n",
       "                                                  Route  \\\n",
       "108                                                 NaN   \n",
       "5074  Baltimore, Maryland - Chicago, Illinois - Las ...   \n",
       "3428                                  Ottawa - Edmonton   \n",
       "4199                     Norfolk, VA - Guantanamo, Cuba   \n",
       "3417                        Miami, FL - Nassau, Bahamas   \n",
       "...                                                 ...   \n",
       "3369                                   Tokyo - Honolulu   \n",
       "3611                                                NaN   \n",
       "3843                                                NaN   \n",
       "4080                                                NaN   \n",
       "4705                                 Sevilla - Herreira   \n",
       "\n",
       "                           Type Registration       cn/In  Aboard  Fatalities  \\\n",
       "108           Handley Page W-10       G-EBMS       W10/3    12.0         0.0   \n",
       "5074           Boeing B-737-7H4       N471WN  32471/1535   103.0         0.0   \n",
       "3428         Boeing B-767-233ER       C-GAUN    22520/47    69.0         0.0   \n",
       "4199  McDonnell Douglas DC-8-61       N814CK       46127     3.0         0.0   \n",
       "3417            Lockheed L-1011       N334EA        1141   172.0         0.0   \n",
       "...                         ...          ...         ...     ...         ...   \n",
       "3369           Boeing B-747-121       N754PA    19658/47     NaN         1.0   \n",
       "3611           Sepecat Jaguar A          NaN         NaN     0.0         0.0   \n",
       "3843                   Bell 412       JA9596       33070     NaN        10.0   \n",
       "4080               Boeing B-747          NaN         NaN     NaN         1.0   \n",
       "4705    CASA 212-DE Aviocar 200    TM-12D-73         314     NaN         NaN   \n",
       "\n",
       "      Ground                                            Summary   su  \n",
       "108      0.0  The plane was on a flight from London to Paris...  1.0  \n",
       "5074     1.0  The jetliner slid off Runway 13C at Chicago's ...  1.0  \n",
       "3428     0.0  The aircraft took off from Ottawa bound for Ed...  1.0  \n",
       "4199     0.0  The plane crashed 1/4 of a mile short of the r...  1.0  \n",
       "3417     0.0  Procedural error by maintenance crew caused O-...  1.0  \n",
       "...      ...                                                ...  ...  \n",
       "3369     0.0  A sixteen-year-old boy was killed when a bomb ...  NaN  \n",
       "3611    35.0  The jet fighter crashed into a school shortly ...  NaN  \n",
       "3843     0.0                                                NaN  NaN  \n",
       "4080     0.0        A passenger died of cholera while en route.  NaN  \n",
       "4705     NaN  Crashed while attempting to land in poor weather.  NaN  \n",
       "\n",
       "[5268 rows x 14 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.sort_values(by='su', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d16108d4",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}