tasks/Task_07_lh_fleet.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The same way as Databricks shows the dependecies that we used in the previous task, Lufthansa also provides a table of its fleet on the following page:\n",
    "https://investor-relations.lufthansagroup.com/en/corporate-facts/fleet.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "fleet = \"\"\"Manufacturer/type\tLH\tLX\tOS\tEW\tLCAG\tGroup fleet\n",
    "Airbus A220\t \t29\t \t \t \t29\n",
    "Airbus A319\t30\t3\t7\t73\t \t113\n",
    "Airbus A320\t95\t29\t25\t76\t \t225\n",
    "Airbus A321\t68\t9\t6\t5\t \t88\n",
    "Airbus A330\t15\t16\t \t221)\t \t53\n",
    "Airbus A340\t34\t9\t \t \t \t43\n",
    "Airbus A350\t15\t \t \t \t \t15\n",
    "Airbus A380\t14\t \t \t \t \t14\n",
    "Boeing 747\t32\t \t \t \t \t32\n",
    "Boeing 767\t \t \t6\t \t \t6\n",
    "Boeing 777\t \t12\t6\t \t \t18\n",
    "Boeing 777F\t \t \t \t \t112)\t11\n",
    "Boeing MD-11F\t \t \t \t \t8\t8\n",
    "Bombardier CRJ\t35\t \t \t \t \t35\n",
    "Bombardier Q-Series\t \t \t15\t153)\t \t30\n",
    "Embraer\t26\t \t17\t \t \t43\n",
    "Total aircraft\t364\t107\t82\t191\t19\t763\"\"\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "As this fleet will in the future change quickly for more fuel efficient airplanes, we want to automatically load that table in our script. A hint on how to do that can be found in this [base64](https://docs.python.org/3/library/base64.html) encoded string:\n",
    "```\n",
    "aHR0cHM6Ly9wYW5kYXMucHlkYXRhLm9yZy9wYW5kYXMtZG9jcy9zdGFibGUvcmVmZXJlbmNlL2FwaS9wYW5kYXMucmVhZF9odG1sLmh0bWw=\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# write your code here"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Manufacturer/type</th>\n",
       "      <th>LH</th>\n",
       "      <th>LX</th>\n",
       "      <th>OS</th>\n",
       "      <th>EW</th>\n",
       "      <th>LCAG</th>\n",
       "      <th>Group fleet</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Airbus A220</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Airbus A319</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>73</td>\n",
       "      <td>NaN</td>\n",
       "      <td>113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Airbus A320</td>\n",
       "      <td>95.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>76</td>\n",
       "      <td>NaN</td>\n",
       "      <td>225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Airbus A321</td>\n",
       "      <td>68.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Airbus A330</td>\n",
       "      <td>15.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>221)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Airbus A340</td>\n",
       "      <td>34.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Airbus A350</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Airbus A380</td>\n",
       "      <td>14.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Boeing 747</td>\n",
       "      <td>32.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Boeing 767</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Boeing 777</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Boeing 777F</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>112)</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Boeing MD-11F</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Bombardier CRJ</td>\n",
       "      <td>35.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Bombardier Q-Series</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.0</td>\n",
       "      <td>153)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Embraer</td>\n",
       "      <td>26.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Total aircraft</td>\n",
       "      <td>364.0</td>\n",
       "      <td>107.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>191</td>\n",
       "      <td>19</td>\n",
       "      <td>763</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Manufacturer/type     LH     LX    OS    EW  LCAG  Group fleet\n",
       "0           Airbus A220    NaN   29.0   NaN   NaN   NaN           29\n",
       "1           Airbus A319   30.0    3.0   7.0    73   NaN          113\n",
       "2           Airbus A320   95.0   29.0  25.0    76   NaN          225\n",
       "3           Airbus A321   68.0    9.0   6.0     5   NaN           88\n",
       "4           Airbus A330   15.0   16.0   NaN  221)   NaN           53\n",
       "5           Airbus A340   34.0    9.0   NaN   NaN   NaN           43\n",
       "6           Airbus A350   15.0    NaN   NaN   NaN   NaN           15\n",
       "7           Airbus A380   14.0    NaN   NaN   NaN   NaN           14\n",
       "8            Boeing 747   32.0    NaN   NaN   NaN   NaN           32\n",
       "9            Boeing 767    NaN    NaN   6.0   NaN   NaN            6\n",
       "10           Boeing 777    NaN   12.0   6.0   NaN   NaN           18\n",
       "11          Boeing 777F    NaN    NaN   NaN   NaN  112)           11\n",
       "12        Boeing MD-11F    NaN    NaN   NaN   NaN     8            8\n",
       "13       Bombardier CRJ   35.0    NaN   NaN   NaN   NaN           35\n",
       "14  Bombardier Q-Series    NaN    NaN  15.0  153)   NaN           30\n",
       "15              Embraer   26.0    NaN  17.0   NaN   NaN           43\n",
       "16       Total aircraft  364.0  107.0  82.0   191    19          763"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}