Stephane_DEDIEU_Peer_Graded_Assignment.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<center>\n",
    "    <img src=\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DV0101EN-SkillsNetwork/labs/Module%204/logo.png\" width=\"300\" alt=\"cognitiveclass.ai logo\" />\n",
    "</center>\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Assignment\n",
    "\n",
    "*   [Story](#story)\n",
    "*   [Components of the report items](#components-of-the-report-items)\n",
    "*   [Expected layout](#expected-layout)\n",
    "*   [Requirements to create the dashboard](#requirements-to-create-the-dashboard)\n",
    "*   [What is new in this exercise compared to other labs?](#what-is-new-in-this-exercise-compared-to-other-labs?)\n",
    "*   [Review](#review)\n",
    "*   [Hints to complete TODOs](#hints-to-complete-todos)\n",
    "*   [Application](#application)\n",
    "\n",
    "## Story:\n",
    "\n",
    "As a data analyst, you have been given a task to monitor and report US domestic airline flights performance. Goal is to analyze the performance of the reporting airline to improve fight reliability thereby improving customer relaibility.\n",
    "\n",
    "Below are the key report items,\n",
    "\n",
    "*   Yearly airline performance report \n",
    "*   Yearly average flight delay statistics\n",
    "\n",
    "*NOTE:* Year range is between 2005 and 2020.\n",
    "\n",
    "## Components of the report items\n",
    "\n",
    "1.  Yearly airline performance report\n",
    "\n",
    "    For the chosen year provide,\n",
    "\n",
    "    *   Number of flights under different cancellation categories using bar chart.\n",
    "    *   Average flight time by reporting airline using line chart.\n",
    "    *   Percentage of diverted airport landings per reporting airline using pie chart.\n",
    "    *   Number of flights flying from each state using choropleth map.\n",
    "    *   Number of flights flying to each state from each reporting airline using treemap chart.\n",
    "2.  Yearly average flight delay statistics\n",
    "\n",
    "    For the chosen year provide,\n",
    "\n",
    "    *   Monthly average carrier delay by reporting airline for the given year.\n",
    "    *   Monthly average weather delay by reporting airline for the given year.\n",
    "    *   Monthly average natioanl air system delay by reporting airline for the given year.\n",
    "    *   Monthly average security delay by reporting airline for the given year.\n",
    "    *   Monthly average late aircraft delay by reporting airline for the given year.\n",
    "\n",
    "    *NOTE:* You have worked created the same dashboard components in `Flight Delay Time Statistics Dashboard` section. We will be reusing the same.\n",
    "\n",
    "## Expected Layout\n",
    "\n",
    "<center>\n",
    "    <img src=\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DV0101EN-SkillsNetwork/labs/Module%205/images/Layout.png\" width=\"2000\" alt=\"cognitiveclass.ai logo\"/>\n",
    "</center>\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Requirements to create the dashboard\n",
    "\n",
    "*   Create dropdown using the reference [here](https://dash.plotly.com/dash-core-components/dropdown?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDeveloperSkillsNetworkDV0101ENSkillsNetwork20297740-2021-01-01)\n",
    "*   Create two HTML divisions that can accomodate two components (in one division) side by side. One is HTML heading and the other one is dropdown.\n",
    "*   Add graph components.\n",
    "*   Callback function to compute data, create graph and return to the layout.\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## What's new in this exercise compared to other labs?\n",
    "\n",
    "*   Make sure the layout is clean without any defualt graphs or graph layouts. We will do this by 3 changes:\n",
    "\n",
    "    1.  Add `app.config.suppress_callback_exceptions = True` right after `app = JupyterDash(__name__)`.\n",
    "\n",
    "    2.  Having empty html.Div and use the callback to Output the dcc.graph as the Children of that Div.\n",
    "\n",
    "    3.  Add a state variable in addition to callback decorator input and output parameter. This will allow us to pass extra values without firing the callbacks.\n",
    "        Here, we need to pass two inputs `chart type` and `year`. Input is read only after user entering all the information.\n",
    "\n",
    "*   Use new html display style `flex` to arrange the dropdown menu with description.\n",
    "\n",
    "*   Update app run step to avoid getting error message before initiating callback.\n",
    "\n",
    "*NOTE:* These steps are only for review.\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Review\n",
    "\n",
    "Search/Look for review to know how commands are used and computations are carried out. There are 7 review items.\n",
    "\n",
    "*   REVIEW1: Clear the layout and do not display exception till callback gets executed.\n",
    "*   REVIEW2: Dropdown creation.\n",
    "*   REVIEW3: Observe how we add an empty division and providing an id that will be updated during callback.\n",
    "*   REVIEW4: Holding output state till user enters all the form information. In this case, it will be chart type and year.\n",
    "*   REVIEW5: Number of flights flying from each state using choropleth\n",
    "*   REVIEW6: Return dcc.Graph component to the empty division\n",
    "*   REVIEW7: This covers chart type 2 and we have completed this exercise under Flight Delay Time Statistics Dashboard section\n",
    "\n",
    "## Hints to complete TODOs\n",
    "\n",
    "### TODO1\n",
    "\n",
    "Reference [link](https://dash.plotly.com/dash-html-components/h1?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDeveloperSkillsNetworkDV0101ENSkillsNetwork20297740-2021-01-01)\n",
    "\n",
    "*   Provide title of the dash application title as `US Domestic Airline Flights Performance`.\n",
    "*   Make the heading center aligned, set color as `#503D36`, and font size as `24`.\n",
    "    Sample: style={'textAlign': 'left', 'color': '#000000', 'font-size': 0}\n",
    "\n",
    "### TODO2\n",
    "\n",
    "Reference [link](https://dash.plotly.com/dash-core-components/dropdown?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDeveloperSkillsNetworkDV0101ENSkillsNetwork20297740-2021-01-01)\n",
    "\n",
    "Create a dropdown menu and add two chart options to it.\n",
    "\n",
    "Parameters to be updated in `dcc.Dropdown`:\n",
    "\n",
    "*   Set `id` as `input-type`.\n",
    "*   Set `options` to list containing dictionaries with key as `label` and user provided value for labels in `value`.\n",
    "\n",
    "    *1st dictionary*\n",
    "\n",
    "    *   label: Yearly Airline Performance Report\n",
    "    *   value: OPT1\n",
    "\n",
    "    *2nd dictionary*\n",
    "\n",
    "    *   label: Yearly Airline Delay Report\n",
    "    *   value: OPT2\n",
    "*   Set placeholder to `Select a report type`.\n",
    "*   Set width as `80%`, padding as `3px`, font size as `20px`, text-align-last as `center` inside style parameter dictionary.\n",
    "\n",
    "#### Skeleton:\n",
    "\n",
    "```\n",
    "  dcc.Dropdown(id='....', \n",
    "                   options=[\n",
    "                           {'label': '....', 'value': '...'},\n",
    "                           {'label': '....', 'value': '...'}\n",
    "                           ],\n",
    "                  placeholder='....',\n",
    "                  style={....})\n",
    "```\n",
    "\n",
    "### TODO3\n",
    "\n",
    "Add a division with two empty divisions inside. For reference, observe how code under `REVIEW` has been structured.\n",
    "\n",
    "Provide division ids as `plot4` and `plot5`. Display style as `flex`.\n",
    "\n",
    "#### Skeleton\n",
    "\n",
    "```\n",
    "html.Div([\n",
    "         html.Div([ ], id='....'),\n",
    "         html.Div([ ], id='....')\n",
    "         ], style={....})\n",
    "```\n",
    "\n",
    "### TODO4\n",
    "\n",
    "Our layout has 5 outputs so we need to create 5 output components. Review how input components are constructured to fill in for output component.\n",
    "\n",
    "It is a list with 5 output parameters with component id and property. Here, the component property will be `children` as we have created empty division and passing in `dcc.Graph` after computation.\n",
    "\n",
    "Component ids will be `plot1` , `plot2`, `plot2`, `plot4`, and `plot5`.\n",
    "\n",
    "#### Skeleton\n",
    "\n",
    "```\n",
    "[Output(component_id='plot1', component_property='children'),\n",
    " Output(....),\n",
    " Output(....),\n",
    " Output(....),\n",
    " Output(....)]\n",
    "```\n",
    "\n",
    "### TODO5\n",
    "\n",
    "Deals with creating line plots using returned dataframes from the above step using `plotly.express`. Link for reference is [here](https://plotly.com/python/line-charts/?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDeveloperSkillsNetworkDV0101ENSkillsNetwork20297740-2021-01-01)\n",
    "\n",
    "Average flight time by reporting airline\n",
    "\n",
    "*   Set figure name as `line_fig`, data as `line_data`, x as `Month`, y as `AirTime`, color as `Reporting_Airline` and `title` as `Average monthly flight time (minutes) by airline`.\n",
    "\n",
    "#### Skeleton\n",
    "\n",
    "```\n",
    "carrier_fig = px.line(avg_car, x='Month', y='CarrierDelay', color='Reporting_Airline', title='Average carrrier delay time (minutes) by airline')`\n",
    "```\n",
    "\n",
    ")\n",
    "\n",
    "### TODO6\n",
    "\n",
    "Deals with creating treemap plot using returned dataframes from the above step using `plotly.express`. Link for reference is [here](https://plotly.com/python/treemaps/?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDeveloperSkillsNetworkDV0101ENSkillsNetwork20297740-2021-01-01)\n",
    "\n",
    "Number of flights flying to each state from each reporting airline\n",
    "\n",
    "*   Set figure name as `tree_fig`, data as `tree_data`, path as `['DestState', 'Reporting_Airline']`, values as `Flights`, colors as `Flights`, color_continuous_scale as `'RdBu'`, and title as `'Flight count by airline to destination state'`\n",
    "\n",
    "#### Skeleton\n",
    "\n",
    "```\n",
    "tree_fig = px.treemap(data, path=['...', '...'], \n",
    "                      values='...',\n",
    "                      color='...',\n",
    "                      color_continuous_scale='...',\n",
    "                      title='...'\n",
    "                )\n",
    "```\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "ename": "SyntaxError",
     "evalue": "invalid syntax (Temp/ipykernel_20980/1235174390.py, line 2)",
     "output_type": "error",
     "traceback": [
      "\u001b[1;36m  File \u001b[1;32m\"C:\\Users\\stefo\\AppData\\Local\\Temp/ipykernel_20980/1235174390.py\"\u001b[1;36m, line \u001b[1;32m2\u001b[0m\n\u001b[1;33m    .container {\u001b[0m\n\u001b[1;37m    ^\u001b[0m\n\u001b[1;31mSyntaxError\u001b[0m\u001b[1;31m:\u001b[0m invalid syntax\n"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>.container { width:90% !important; }</style>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from IPython.display import display, HTML\n",
    "display(HTML(\"<style>.container { width:90% !important; }</style>\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: pandas in c:\\users\\stefo\\anaconda3\\lib\\site-packages (1.3.4)\n",
      "Requirement already satisfied: python-dateutil>=2.7.3 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from pandas) (2.8.2)\n",
      "Requirement already satisfied: pytz>=2017.3 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from pandas) (2021.3)\n",
      "Requirement already satisfied: numpy>=1.17.3 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from pandas) (1.20.3)\n",
      "Requirement already satisfied: six>=1.5 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from python-dateutil>=2.7.3->pandas) (1.16.0)\n",
      "Requirement already satisfied: fairlearn in c:\\users\\stefo\\anaconda3\\lib\\site-packages (0.7.0)\n",
      "Requirement already satisfied: numpy>=1.17.2 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from fairlearn) (1.20.3)\n",
      "Requirement already satisfied: pandas>=0.25.1 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from fairlearn) (1.3.4)\n",
      "Requirement already satisfied: scipy>=1.4.1 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from fairlearn) (1.7.1)\n",
      "Requirement already satisfied: scikit-learn>=0.22.1 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from fairlearn) (0.24.2)\n",
      "Requirement already satisfied: python-dateutil>=2.7.3 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from pandas>=0.25.1->fairlearn) (2.8.2)\n",
      "Requirement already satisfied: pytz>=2017.3 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from pandas>=0.25.1->fairlearn) (2021.3)\n",
      "Requirement already satisfied: six>=1.5 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from python-dateutil>=2.7.3->pandas>=0.25.1->fairlearn) (1.16.0)\n",
      "Requirement already satisfied: joblib>=0.11 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from scikit-learn>=0.22.1->fairlearn) (1.1.0)\n",
      "Requirement already satisfied: threadpoolctl>=2.0.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from scikit-learn>=0.22.1->fairlearn) (2.2.0)\n",
      "Requirement already satisfied: plotly in c:\\users\\stefo\\anaconda3\\lib\\site-packages (5.6.0)\n",
      "Requirement already satisfied: tenacity>=6.2.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from plotly) (8.0.1)\n",
      "Requirement already satisfied: six in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from plotly) (1.16.0)\n",
      "Requirement already satisfied: jupyter-dash in c:\\users\\stefo\\anaconda3\\lib\\site-packages (0.3.0)\n",
      "Requirement already satisfied: requests in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-dash) (2.26.0)\n",
      "Requirement already satisfied: dash in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-dash) (2.1.0)\n",
      "Requirement already satisfied: ansi2html in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-dash) (1.7.0)\n",
      "Requirement already satisfied: retrying in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-dash) (1.3.3)\n",
      "Requirement already satisfied: ipykernel in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-dash) (6.4.1)\n",
      "Requirement already satisfied: ipython in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-dash) (7.29.0)\n",
      "Requirement already satisfied: flask in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-dash) (2.1.0)\n",
      "Requirement already satisfied: dash-core-components==2.0.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from dash->jupyter-dash) (2.0.0)\n",
      "Requirement already satisfied: dash-html-components==2.0.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from dash->jupyter-dash) (2.0.0)\n",
      "Requirement already satisfied: flask-compress in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from dash->jupyter-dash) (1.12)\n",
      "Requirement already satisfied: plotly>=5.0.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from dash->jupyter-dash) (5.6.0)\n",
      "Requirement already satisfied: dash-table==5.0.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from dash->jupyter-dash) (5.0.0)\n",
      "Requirement already satisfied: Jinja2>=3.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from flask->jupyter-dash) (3.1.1)\n",
      "Requirement already satisfied: itsdangerous>=2.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from flask->jupyter-dash) (2.0.1)\n",
      "Requirement already satisfied: Werkzeug>=2.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from flask->jupyter-dash) (2.0.1)\n",
      "Requirement already satisfied: click>=8.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from flask->jupyter-dash) (8.0.3)\n",
      "Requirement already satisfied: importlib-metadata in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from flask->jupyter-dash) (4.8.1)\n",
      "Requirement already satisfied: colorama in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from click>=8.0->flask->jupyter-dash) (0.4.4)\n",
      "Requirement already satisfied: MarkupSafe>=2.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from Jinja2>=3.0->flask->jupyter-dash) (2.1.1)\n",
      "Requirement already satisfied: six in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from plotly>=5.0.0->dash->jupyter-dash) (1.16.0)\n",
      "Requirement already satisfied: tenacity>=6.2.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from plotly>=5.0.0->dash->jupyter-dash) (8.0.1)\n",
      "Requirement already satisfied: brotli in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from flask-compress->dash->jupyter-dash) (1.0.9)\n",
      "Requirement already satisfied: zipp>=0.5 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from importlib-metadata->flask->jupyter-dash) (3.6.0)\n",
      "Requirement already satisfied: debugpy<2.0,>=1.0.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipykernel->jupyter-dash) (1.4.1)\n",
      "Requirement already satisfied: tornado<7.0,>=4.2 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipykernel->jupyter-dash) (6.1)\n",
      "Requirement already satisfied: traitlets<6.0,>=4.1.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipykernel->jupyter-dash) (5.1.0)\n",
      "Requirement already satisfied: ipython-genutils in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipykernel->jupyter-dash) (0.2.0)\n",
      "Requirement already satisfied: matplotlib-inline<0.2.0,>=0.1.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipykernel->jupyter-dash) (0.1.2)\n",
      "Requirement already satisfied: jupyter-client<8.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipykernel->jupyter-dash) (6.1.12)\n",
      "Requirement already satisfied: pickleshare in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->jupyter-dash) (0.7.5)\n",
      "Requirement already satisfied: setuptools>=18.5 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->jupyter-dash) (58.0.4)\n",
      "Requirement already satisfied: pygments in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->jupyter-dash) (2.10.0)\n",
      "Requirement already satisfied: jedi>=0.16 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->jupyter-dash) (0.18.0)\n",
      "Requirement already satisfied: decorator in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->jupyter-dash) (5.1.0)\n",
      "Requirement already satisfied: backcall in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->jupyter-dash) (0.2.0)\n",
      "Requirement already satisfied: prompt-toolkit!=3.0.0,!=3.0.1,<3.1.0,>=2.0.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->jupyter-dash) (3.0.20)\n",
      "Requirement already satisfied: parso<0.9.0,>=0.8.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jedi>=0.16->ipython->jupyter-dash) (0.8.2)\n",
      "Requirement already satisfied: jupyter-core>=4.6.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-client<8.0->ipykernel->jupyter-dash) (4.8.1)\n",
      "Requirement already satisfied: pyzmq>=13 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-client<8.0->ipykernel->jupyter-dash) (22.2.1)\n",
      "Requirement already satisfied: python-dateutil>=2.1 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-client<8.0->ipykernel->jupyter-dash) (2.8.2)\n",
      "Requirement already satisfied: pywin32>=1.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-core>=4.6.0->jupyter-client<8.0->ipykernel->jupyter-dash) (228)\n",
      "Requirement already satisfied: wcwidth in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from prompt-toolkit!=3.0.0,!=3.0.1,<3.1.0,>=2.0.0->ipython->jupyter-dash) (0.2.5)\n",
      "Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from requests->jupyter-dash) (1.26.7)\n",
      "Requirement already satisfied: charset-normalizer~=2.0.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from requests->jupyter-dash) (2.0.4)\n",
      "Requirement already satisfied: idna<4,>=2.5 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from requests->jupyter-dash) (3.2)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from requests->jupyter-dash) (2021.10.8)\n",
      "Requirement already satisfied: Flask==2.1.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (2.1.0)\n",
      "Requirement already satisfied: itsdangerous>=2.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from Flask==2.1.0) (2.0.1)\n",
      "Requirement already satisfied: Werkzeug>=2.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from Flask==2.1.0) (2.0.1)\n",
      "Requirement already satisfied: click>=8.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from Flask==2.1.0) (8.0.3)\n",
      "Requirement already satisfied: Jinja2>=3.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from Flask==2.1.0) (3.1.1)\n",
      "Requirement already satisfied: importlib-metadata in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from Flask==2.1.0) (4.8.1)\n",
      "Requirement already satisfied: colorama in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from click>=8.0->Flask==2.1.0) (0.4.4)\n",
      "Requirement already satisfied: MarkupSafe>=2.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from Jinja2>=3.0->Flask==2.1.0) (2.1.1)\n",
      "Requirement already satisfied: zipp>=0.5 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from importlib-metadata->Flask==2.1.0) (3.6.0)\n"
     ]
    }
   ],
   "source": [
    "#!pip install pandas dash\n",
    "#!pip install sklearn\n",
    "!pip install pandas\n",
    "!pip install fairlearn\n",
    "#!pip install bokeh\n",
    "#!pip install matplotlib\n",
    "!pip install plotly\n",
    "#!pip uninstall dash --y\n",
    "#!pip install dash==2.1.0\n",
    "#!pip install pandas dash\n",
    "!pip install jupyter-dash\n",
    "!pip install Flask==2.1.0\n",
    "#!pip install environ"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import required libraries\n",
    "import pandas as pd\n",
    "import dash\n",
    "from dash import dcc\n",
    "from dash import html\n",
    "from dash.dependencies import Input, Output, State\n",
    "from jupyter_dash import JupyterDash\n",
    "import plotly.graph_objects as go\n",
    "import plotly.express as px\n",
    "from dash import no_update"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: jupyter-server-proxy in c:\\users\\stefo\\anaconda3\\lib\\site-packages (1.0)\n",
      "Requirement already satisfied: aiohttp in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-server-proxy) (3.8.1)\n",
      "Requirement already satisfied: simpervisor>=0.2 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-server-proxy) (0.3)\n",
      "Requirement already satisfied: notebook in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-server-proxy) (6.4.5)\n",
      "Requirement already satisfied: charset-normalizer<3.0,>=2.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from aiohttp->jupyter-server-proxy) (2.0.4)\n",
      "Requirement already satisfied: multidict<7.0,>=4.5 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from aiohttp->jupyter-server-proxy) (5.1.0)\n",
      "Requirement already satisfied: frozenlist>=1.1.1 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from aiohttp->jupyter-server-proxy) (1.2.0)\n",
      "Requirement already satisfied: yarl<2.0,>=1.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from aiohttp->jupyter-server-proxy) (1.6.3)\n",
      "Requirement already satisfied: attrs>=17.3.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from aiohttp->jupyter-server-proxy) (21.2.0)\n",
      "Requirement already satisfied: async-timeout<5.0,>=4.0.0a3 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from aiohttp->jupyter-server-proxy) (4.0.1)\n",
      "Requirement already satisfied: aiosignal>=1.1.2 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from aiohttp->jupyter-server-proxy) (1.2.0)\n",
      "Requirement already satisfied: typing-extensions>=3.6.5 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from async-timeout<5.0,>=4.0.0a3->aiohttp->jupyter-server-proxy) (3.10.0.2)\n",
      "Requirement already satisfied: idna>=2.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from yarl<2.0,>=1.0->aiohttp->jupyter-server-proxy) (3.2)\n",
      "Requirement already satisfied: argon2-cffi in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from notebook->jupyter-server-proxy) (20.1.0)\n",
      "Requirement already satisfied: jupyter-client>=5.3.4 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from notebook->jupyter-server-proxy) (6.1.12)\n",
      "Requirement already satisfied: jupyter-core>=4.6.1 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from notebook->jupyter-server-proxy) (4.8.1)\n",
      "Requirement already satisfied: jinja2 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from notebook->jupyter-server-proxy) (3.1.1)\n",
      "Requirement already satisfied: nbformat in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from notebook->jupyter-server-proxy) (5.1.3)\n",
      "Requirement already satisfied: nbconvert in c:\\users\\stefo\\appdata\\roaming\\python\\python39\\site-packages (from notebook->jupyter-server-proxy) (6.5.0)\n",
      "Requirement already satisfied: prometheus-client in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from notebook->jupyter-server-proxy) (0.11.0)\n",
      "Requirement already satisfied: pyzmq>=17 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from notebook->jupyter-server-proxy) (22.2.1)\n",
      "Requirement already satisfied: tornado>=6.1 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from notebook->jupyter-server-proxy) (6.1)\n",
      "Requirement already satisfied: Send2Trash>=1.5.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from notebook->jupyter-server-proxy) (1.8.0)\n",
      "Requirement already satisfied: traitlets>=4.2.1 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from notebook->jupyter-server-proxy) (5.1.0)\n",
      "Requirement already satisfied: terminado>=0.8.3 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from notebook->jupyter-server-proxy) (0.9.4)\n",
      "Requirement already satisfied: ipython-genutils in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from notebook->jupyter-server-proxy) (0.2.0)\n",
      "Requirement already satisfied: ipykernel in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from notebook->jupyter-server-proxy) (6.4.1)\n",
      "Requirement already satisfied: python-dateutil>=2.1 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-client>=5.3.4->notebook->jupyter-server-proxy) (2.8.2)\n",
      "Requirement already satisfied: pywin32>=1.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jupyter-core>=4.6.1->notebook->jupyter-server-proxy) (228)\n",
      "Requirement already satisfied: six>=1.5 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from python-dateutil>=2.1->jupyter-client>=5.3.4->notebook->jupyter-server-proxy) (1.16.0)\n",
      "Requirement already satisfied: pywinpty>=0.5 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from terminado>=0.8.3->notebook->jupyter-server-proxy) (0.5.7)\n",
      "Requirement already satisfied: cffi>=1.0.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from argon2-cffi->notebook->jupyter-server-proxy) (1.14.6)\n",
      "Requirement already satisfied: pycparser in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from cffi>=1.0.0->argon2-cffi->notebook->jupyter-server-proxy) (2.20)\n",
      "Requirement already satisfied: matplotlib-inline<0.2.0,>=0.1.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipykernel->notebook->jupyter-server-proxy) (0.1.2)\n",
      "Requirement already satisfied: debugpy<2.0,>=1.0.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipykernel->notebook->jupyter-server-proxy) (1.4.1)\n",
      "Requirement already satisfied: ipython<8.0,>=7.23.1 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipykernel->notebook->jupyter-server-proxy) (7.29.0)\n",
      "Requirement already satisfied: colorama in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython<8.0,>=7.23.1->ipykernel->notebook->jupyter-server-proxy) (0.4.4)\n",
      "Requirement already satisfied: pickleshare in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython<8.0,>=7.23.1->ipykernel->notebook->jupyter-server-proxy) (0.7.5)\n",
      "Requirement already satisfied: pygments in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython<8.0,>=7.23.1->ipykernel->notebook->jupyter-server-proxy) (2.10.0)\n",
      "Requirement already satisfied: decorator in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython<8.0,>=7.23.1->ipykernel->notebook->jupyter-server-proxy) (5.1.0)\n",
      "Requirement already satisfied: prompt-toolkit!=3.0.0,!=3.0.1,<3.1.0,>=2.0.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython<8.0,>=7.23.1->ipykernel->notebook->jupyter-server-proxy) (3.0.20)\n",
      "Requirement already satisfied: backcall in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython<8.0,>=7.23.1->ipykernel->notebook->jupyter-server-proxy) (0.2.0)\n",
      "Requirement already satisfied: setuptools>=18.5 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython<8.0,>=7.23.1->ipykernel->notebook->jupyter-server-proxy) (58.0.4)\n",
      "Requirement already satisfied: jedi>=0.16 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython<8.0,>=7.23.1->ipykernel->notebook->jupyter-server-proxy) (0.18.0)\n",
      "Requirement already satisfied: parso<0.9.0,>=0.8.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jedi>=0.16->ipython<8.0,>=7.23.1->ipykernel->notebook->jupyter-server-proxy) (0.8.2)\n",
      "Requirement already satisfied: wcwidth in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from prompt-toolkit!=3.0.0,!=3.0.1,<3.1.0,>=2.0.0->ipython<8.0,>=7.23.1->ipykernel->notebook->jupyter-server-proxy) (0.2.5)\n",
      "Requirement already satisfied: MarkupSafe>=2.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jinja2->notebook->jupyter-server-proxy) (2.1.1)\n",
      "Requirement already satisfied: entrypoints>=0.2.2 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from nbconvert->notebook->jupyter-server-proxy) (0.3)\n",
      "Requirement already satisfied: pandocfilters>=1.4.1 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from nbconvert->notebook->jupyter-server-proxy) (1.4.3)\n",
      "Requirement already satisfied: jupyterlab-pygments in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from nbconvert->notebook->jupyter-server-proxy) (0.1.2)\n",
      "Requirement already satisfied: nbclient>=0.5.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from nbconvert->notebook->jupyter-server-proxy) (0.5.3)\n",
      "Requirement already satisfied: defusedxml in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from nbconvert->notebook->jupyter-server-proxy) (0.7.1)\n",
      "Requirement already satisfied: beautifulsoup4 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from nbconvert->notebook->jupyter-server-proxy) (4.10.0)\n",
      "Requirement already satisfied: mistune<2,>=0.8.1 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from nbconvert->notebook->jupyter-server-proxy) (0.8.4)\n",
      "Requirement already satisfied: packaging in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from nbconvert->notebook->jupyter-server-proxy) (21.0)\n",
      "Requirement already satisfied: tinycss2 in c:\\users\\stefo\\appdata\\roaming\\python\\python39\\site-packages (from nbconvert->notebook->jupyter-server-proxy) (1.1.1)\n",
      "Requirement already satisfied: bleach in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from nbconvert->notebook->jupyter-server-proxy) (4.0.0)\n",
      "Requirement already satisfied: async-generator in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from nbclient>=0.5.0->nbconvert->notebook->jupyter-server-proxy) (1.10)\n",
      "Requirement already satisfied: nest-asyncio in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from nbclient>=0.5.0->nbconvert->notebook->jupyter-server-proxy) (1.5.1)\n",
      "Requirement already satisfied: jsonschema!=2.5.0,>=2.4 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from nbformat->notebook->jupyter-server-proxy) (3.2.0)\n",
      "Requirement already satisfied: pyrsistent>=0.14.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jsonschema!=2.5.0,>=2.4->nbformat->notebook->jupyter-server-proxy) (0.18.0)\n",
      "Requirement already satisfied: soupsieve>1.2 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from beautifulsoup4->nbconvert->notebook->jupyter-server-proxy) (2.2.1)\n",
      "Requirement already satisfied: webencodings in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from bleach->nbconvert->notebook->jupyter-server-proxy) (0.5.1)\n",
      "Requirement already satisfied: pyparsing>=2.0.2 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from packaging->nbconvert->notebook->jupyter-server-proxy) (3.0.4)\n"
     ]
    }
   ],
   "source": [
    "#!pip install jupyter-server-proxy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read the airline data into pandas dataframe\n",
    "airline_data =  pd.read_csv('https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DV0101EN-SkillsNetwork/Data%20Files/airline_data.csv', \n",
    "                            encoding = \"ISO-8859-1\",\n",
    "                            dtype={'Div1Airport': str, 'Div1TailNum': str, \n",
    "                                   'Div2Airport': str, 'Div2TailNum': str})"
   ]
  },
  {
   "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>Unnamed: 0</th>\n",
       "      <th>Year</th>\n",
       "      <th>Quarter</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayofMonth</th>\n",
       "      <th>DayOfWeek</th>\n",
       "      <th>FlightDate</th>\n",
       "      <th>Reporting_Airline</th>\n",
       "      <th>DOT_ID_Reporting_Airline</th>\n",
       "      <th>IATA_CODE_Reporting_Airline</th>\n",
       "      <th>...</th>\n",
       "      <th>Div4WheelsOff</th>\n",
       "      <th>Div4TailNum</th>\n",
       "      <th>Div5Airport</th>\n",
       "      <th>Div5AirportID</th>\n",
       "      <th>Div5AirportSeqID</th>\n",
       "      <th>Div5WheelsOn</th>\n",
       "      <th>Div5TotalGTime</th>\n",
       "      <th>Div5LongestGTime</th>\n",
       "      <th>Div5WheelsOff</th>\n",
       "      <th>Div5TailNum</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1295781</td>\n",
       "      <td>1998</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>1998-04-02</td>\n",
       "      <td>AS</td>\n",
       "      <td>19930</td>\n",
       "      <td>AS</td>\n",
       "      <td>...</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1125375</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>2013-05-13</td>\n",
       "      <td>EV</td>\n",
       "      <td>20366</td>\n",
       "      <td>EV</td>\n",
       "      <td>...</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>118824</td>\n",
       "      <td>1993</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>25</td>\n",
       "      <td>6</td>\n",
       "      <td>1993-09-25</td>\n",
       "      <td>UA</td>\n",
       "      <td>19977</td>\n",
       "      <td>UA</td>\n",
       "      <td>...</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>634825</td>\n",
       "      <td>1994</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>1994-11-12</td>\n",
       "      <td>HP</td>\n",
       "      <td>19991</td>\n",
       "      <td>HP</td>\n",
       "      <td>...</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1888125</td>\n",
       "      <td>2017</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>17</td>\n",
       "      <td>4</td>\n",
       "      <td>2017-08-17</td>\n",
       "      <td>UA</td>\n",
       "      <td>19977</td>\n",
       "      <td>UA</td>\n",
       "      <td>...</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 110 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  Year  Quarter  Month  DayofMonth  DayOfWeek  FlightDate  \\\n",
       "0     1295781  1998        2      4           2          4  1998-04-02   \n",
       "1     1125375  2013        2      5          13          1  2013-05-13   \n",
       "2      118824  1993        3      9          25          6  1993-09-25   \n",
       "3      634825  1994        4     11          12          6  1994-11-12   \n",
       "4     1888125  2017        3      8          17          4  2017-08-17   \n",
       "\n",
       "  Reporting_Airline  DOT_ID_Reporting_Airline IATA_CODE_Reporting_Airline  \\\n",
       "0                AS                     19930                          AS   \n",
       "1                EV                     20366                          EV   \n",
       "2                UA                     19977                          UA   \n",
       "3                HP                     19991                          HP   \n",
       "4                UA                     19977                          UA   \n",
       "\n",
       "   ... Div4WheelsOff  Div4TailNum  Div5Airport  Div5AirportID  \\\n",
       "0  ...           NaN          NaN          NaN            NaN   \n",
       "1  ...           NaN          NaN          NaN            NaN   \n",
       "2  ...           NaN          NaN          NaN            NaN   \n",
       "3  ...           NaN          NaN          NaN            NaN   \n",
       "4  ...           NaN          NaN          NaN            NaN   \n",
       "\n",
       "   Div5AirportSeqID Div5WheelsOn Div5TotalGTime Div5LongestGTime  \\\n",
       "0               NaN          NaN            NaN              NaN   \n",
       "1               NaN          NaN            NaN              NaN   \n",
       "2               NaN          NaN            NaN              NaN   \n",
       "3               NaN          NaN            NaN              NaN   \n",
       "4               NaN          NaN            NaN              NaN   \n",
       "\n",
       "   Div5WheelsOff Div5TailNum  \n",
       "0            NaN         NaN  \n",
       "1            NaN         NaN  \n",
       "2            NaN         NaN  \n",
       "3            NaN         NaN  \n",
       "4            NaN         NaN  \n",
       "\n",
       "[5 rows x 110 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "airline_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'app' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m~\\AppData\\Local\\Temp/ipykernel_13100/209845007.py\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[1;32mdel\u001b[0m \u001b[0mapp\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mconfig\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_read_only\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m\"requests_pathname_prefix\"\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m: name 'app' is not defined"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "from jupyter_dash.comms import _send_jupyter_config_comm_request\n",
    "_send_jupyter_config_comm_request()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "from jupyter_dash import JupyterDash\n",
    "#[other dash imports]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Application\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      " * Running on http://localhost:8050/ (Press CTRL+C to quit)\n",
      "127.0.0.1 - - [11/May/2022 21:11:13] \"GET /_alive_d95509ab-eda9-41dc-8db8-4569c100059b HTTP/1.1\" 200 -\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "        <iframe\n",
       "            width=\"100%\"\n",
       "            height=\"650\"\n",
       "            src=\"http://localhost:8889/proxy/8050/\"\n",
       "            frameborder=\"0\"\n",
       "            allowfullscreen\n",
       "            \n",
       "        ></iframe>\n",
       "        "
      ],
      "text/plain": [
       "<IPython.lib.display.IFrame at 0x1708d5277f0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Create a dash application\n",
    "app = JupyterDash(__name__)\n",
    "JupyterDash.infer_jupyter_proxy_config()\n",
    "\n",
    "# REVIEW1: Clear the layout and do not display exception till callback gets executed\n",
    "app.config.suppress_callback_exceptions = True\n",
    "del app.config._read_only[\"requests_pathname_prefix\"]\n",
    "# List of years \n",
    "year_list = [i for i in range(2005, 2021, 1)]\n",
    "\n",
    "\"\"\"Compute graph data for creating yearly airline performance report \n",
    "\n",
    "Function that takes airline data as input and create 5 dataframes based on the grouping condition to be used for plottling charts and grphs.\n",
    "\n",
    "Argument:\n",
    "     \n",
    "    df: Filtered dataframe\n",
    "    \n",
    "Returns:\n",
    "   Dataframes to create graph. \n",
    "\"\"\"\n",
    "def compute_data_choice_1(df):\n",
    "    # Cancellation Category Count\n",
    "    bar_data = df.groupby(['Month','CancellationCode'])['Flights'].sum().reset_index()\n",
    "    # Average flight time by reporting airline\n",
    "    line_data = df.groupby(['Month','Reporting_Airline'])['AirTime'].mean().reset_index()\n",
    "    # Diverted Airport Landings\n",
    "    div_data = df[df['DivAirportLandings'] != 0.0]\n",
    "    # Source state count\n",
    "    map_data = df.groupby(['OriginState'])['Flights'].sum().reset_index()\n",
    "    # Destination state count\n",
    "    tree_data = df.groupby(['DestState', 'Reporting_Airline'])['Flights'].sum().reset_index()\n",
    "    return bar_data, line_data, div_data, map_data, tree_data\n",
    "\n",
    "\n",
    "\"\"\"Compute graph data for creating yearly airline delay report\n",
    "\n",
    "This function takes in airline data and selected year as an input and performs computation for creating charts and plots.\n",
    "\n",
    "Arguments:\n",
    "    df: Input airline data.\n",
    "    \n",
    "Returns:\n",
    "    Computed average dataframes for carrier delay, weather delay, NAS delay, security delay, and late aircraft delay.\n",
    "\"\"\"\n",
    "def compute_data_choice_2(df):\n",
    "    # Compute delay averages\n",
    "    avg_car = df.groupby(['Month','Reporting_Airline'])['CarrierDelay'].mean().reset_index()\n",
    "    avg_weather = df.groupby(['Month','Reporting_Airline'])['WeatherDelay'].mean().reset_index()\n",
    "    avg_NAS = df.groupby(['Month','Reporting_Airline'])['NASDelay'].mean().reset_index()\n",
    "    avg_sec = df.groupby(['Month','Reporting_Airline'])['SecurityDelay'].mean().reset_index()\n",
    "    avg_late = df.groupby(['Month','Reporting_Airline'])['LateAircraftDelay'].mean().reset_index()\n",
    "    return avg_car, avg_weather, avg_NAS, avg_sec, avg_late\n",
    "\n",
    "\n",
    "# Application layout\n",
    "                                # TODO1: Add title to the dashboard - X\n",
    "    # Provide title of the dash application title as US Domestic Airline Flights Performance.\n",
    "    # Make the heading center aligned, set color as #503D36, \n",
    "    # and font size as 24. Sample: style={'textAlign': 'left', 'color': '#000000', 'font-size': 0}\n",
    "\n",
    "app.layout = html.Div(children=[html.H1('US Domestic Airline Flights Performance', \n",
    "                                style={'textAlign':'center', \n",
    "                                'color':'#503D36', \n",
    "                                'font-size': 24}), \n",
    "\n",
    "                                # REVIEW2: Dropdown creation\n",
    "                                # Create an outer division \n",
    "                                html.Div([\n",
    "                                    # Add an division\n",
    "                                    html.Div([\n",
    "                                        # Create an division for adding dropdown helper text for report type\n",
    "                                        html.Div(\n",
    "                                            [\n",
    "                                            html.H2('Report Type:', style={'margin-right': '2em'}),\n",
    "                                            ]\n",
    "                                        ),\n",
    "                                        # TODO2: Add a dropdown\n",
    "    #Create a dropdown menu and add two chart options to it.\n",
    "    #Parameters to be updated in dcc.Dropdown:\n",
    "    #Set id as input-type.\n",
    "    #Set options to list containing dictionaries with key as label and user provided value for labels in value.\n",
    "    #1st dictionary\n",
    "    #    label: Yearly Airline Performance Report\n",
    "    #    value: OPT1\n",
    "    #2nd dictionary\n",
    "    #    label: Yearly Airline Delay Report\n",
    "    #    value: OPT2\n",
    "    #Set placeholder to Select a report type.\n",
    "    #Set width as 80%, padding as 3px, font size as 20px, text-align-last as center inside style parameter dictionary.        \n",
    "                                # Place them next to each other using the division style\n",
    "                                dcc.Dropdown(id='input-type', \n",
    "                                        options=[{'label': 'Yearly Airline Performance Report', 'value': 'OPT1'},\n",
    "                                                 {'label': 'Yearly Airline Delay Report', 'value': 'OPT2'}],\n",
    "                                                placeholder='Select a Report',\n",
    "                                                style={'width':'80%', \n",
    "                                                       'padding':'3px',\n",
    "                                                       'font-size': '20px', \n",
    "                                                       'text-align-last' : 'center'}),                                           \n",
    "                                    ], style={'display':'flex'}),\n",
    "                                    \n",
    "                                   # Add next division \n",
    "                                   html.Div([\n",
    "                                       # Create an division for adding dropdown helper text for choosing year\n",
    "                                        html.Div(\n",
    "                                            [\n",
    "                                            html.H2('Choose Year:', style={'margin-right': '2em'})\n",
    "                                            ]\n",
    "                                        ),\n",
    "                                        dcc.Dropdown(id='input-year', \n",
    "                                                     # Update dropdown values using list comphrehension\n",
    "                                                     options=[{'label': i, 'value': i} for i in year_list],\n",
    "                                                     placeholder=\"Select a year\",\n",
    "                                                     style={'width':'80%', 'padding':'3px', 'font-size': '20px', 'text-align-last' : 'center'}),\n",
    "                                            # Place them next to each other using the division style\n",
    "                                            ], style={'display': 'flex'}),  \n",
    "                                          ]),\n",
    "                                \n",
    "                                # Add Computed graphs\n",
    "                                # REVIEW3: Observe how we add an empty division and providing an id that will be updated during callback\n",
    "                                html.Div([ ], id='plot1'),\n",
    "    \n",
    "                                html.Div([\n",
    "                                        html.Div([ ], id='plot2'),\n",
    "                                        html.Div([ ], id='plot3')\n",
    "                                ], style={'display': 'flex'}),\n",
    "                                \n",
    "                                # TODO3: Add a division with two empty divisions inside. See above disvision for example.\n",
    "                                # Provide division ids as plot4 and plot5. Display style as flex.\n",
    "                                 html.Div([\n",
    "                                        html.Div([ ], id='plot4'),\n",
    "                                        html.Div([ ], id='plot5')\n",
    "                                ], style={'display': 'flex'}),                               \n",
    "                                ])\n",
    "\n",
    "# Callback function definition\n",
    "# TODO4: Add 5 ouput components\n",
    "# Our layout has 5 outputs so we need to create 5 output components. Review how input components are constructured to fill in for output component.\n",
    "# It is a list with 5 output parameters with component id and property. Here, the component property will be children as we have created empty division and passing in dcc.Graph after computation.\n",
    "# Component ids will be plot1 , plot2, plot2, plot4, and plot5.\n",
    "\n",
    "\n",
    "@app.callback([ Output(component_id='plot1', component_property='children'),\n",
    "                Output(component_id='plot2', component_property='children'),\n",
    "                Output(component_id='plot3', component_property='children'),\n",
    "                Output(component_id='plot4', component_property='children'),\n",
    "                Output(component_id='plot5', component_property='children')],\n",
    "               [Input(component_id='input-type', component_property='value'),\n",
    "                Input(component_id='input-year', component_property='value')],\n",
    "               # REVIEW4: Holding output state till user enters all the form information. In this case, it will be chart type and year\n",
    "               [State(\"plot1\", 'children'), State(\"plot2\", \"children\"),\n",
    "                State(\"plot3\", \"children\"), State(\"plot4\", \"children\"),\n",
    "                State(\"plot5\", \"children\")\n",
    "               ])\n",
    "# Add computation to callback function and return graph\n",
    "def get_graph(chart, year, children1, children2, c3, c4, c5):\n",
    "      \n",
    "        # Select data\n",
    "        df =  airline_data[airline_data['Year']==int(year)]\n",
    "       \n",
    "        if chart == 'OPT1':\n",
    "            # Compute required information for creating graph from the data\n",
    "            bar_data, line_data, div_data, map_data, tree_data = compute_data_choice_1(df)\n",
    "            \n",
    "            # Number of flights under different cancellation categories\n",
    "            bar_fig = px.bar(bar_data, x='Month', y='Flights', color='CancellationCode', title='Monthly Flight Cancellation')\n",
    "            \n",
    "            # TODO5: Average flight time by reporting airline\n",
    "            # Deals with creating line plots using returned dataframes from the above step using plotly.express. Link for reference is here\n",
    "            # Average flight time by reporting airline\n",
    "            # Set figure name as line_fig, data as line_data, x as Month, y as AirTime, \n",
    "            # color as Reporting_Airline and title as Average monthly flight time (minutes) by airline.\n",
    "            #  carrier_fig = px.line(avg_car, x='Month', y='CarrierDelay', color='Reporting_Airline', title='Average carrrier delay time (minutes) by airline')`\n",
    "                        # Enter your code below. Make sure you have correct formatting.\n",
    "            line_fig = px.line(line_data, x='Month', y='AirTime', color='Reporting_Airline', title='Average monthly flight time (minutes) by airline')\n",
    "             \n",
    "            # Percentage of diverted airport landings per reporting airline\n",
    "            pie_fig = px.pie(div_data, values='Flights', names='Reporting_Airline', title='% of flights by reporting airline')\n",
    "            \n",
    "            # REVIEW5: Number of flights flying from each state using choropleth\n",
    "            map_fig = px.choropleth(map_data,  # Input data\n",
    "                    locations='OriginState', \n",
    "                    color='Flights',  \n",
    "                    hover_data=['OriginState', 'Flights'], \n",
    "                    locationmode = 'USA-states', # Set to plot as US States\n",
    "                    color_continuous_scale='GnBu',\n",
    "                    range_color=[0, map_data['Flights'].max()]) \n",
    "            map_fig.update_layout(\n",
    "                    title_text = 'Number of flights from origin state', \n",
    "                    geo_scope='usa') # Plot only the USA instead of globe\n",
    "            \n",
    "            # TODO6: Number of flights flying to each state from each reporting airline\n",
    "            # Deals with creating treemap plot using returned dataframes from the above step using plotly.express. Link for reference is here\n",
    "            # Number of flights flying to each state from each reporting airline\n",
    "            # Set figure name as tree_fig, data as tree_data, path as ['DestState', 'Reporting_Airline'], values as Flights, colors as Flights, color_continuous_scale as 'RdBu', and title as 'Flight count by airline to destination state'\n",
    "            tree_fig = px.treemap(tree_data, \n",
    "                        path=['DestState', 'Reporting_Airline'], \n",
    "                        values= 'Flights', \n",
    "                        color='Flights', \n",
    "                        color_continuous_scale='RdBu',\n",
    "                        title='Flight count by airline to destination state')\n",
    "\n",
    "            \n",
    "            # REVIEW6: Return dcc.Graph component to the empty division\n",
    "            return [dcc.Graph(figure=tree_fig), \n",
    "                    dcc.Graph(figure=pie_fig),\n",
    "                    dcc.Graph(figure=map_fig),\n",
    "                    dcc.Graph(figure=bar_fig),\n",
    "                    dcc.Graph(figure=line_fig)\n",
    "                   ]\n",
    "        else:\n",
    "            # REVIEW7: This covers chart type 2 and we have completed this exercise under Flight Delay Time Statistics Dashboard section\n",
    "            # Compute required information for creating graph from the data\n",
    "            avg_car, avg_weather, avg_NAS, avg_sec, avg_late = compute_data_choice_2(df)\n",
    "            \n",
    "            # Create graph\n",
    "            carrier_fig = px.line(avg_car, x='Month', y='CarrierDelay', color='Reporting_Airline', title='Average carrrier delay time (minutes) by airline')\n",
    "            weather_fig = px.line(avg_weather, x='Month', y='WeatherDelay', color='Reporting_Airline', title='Average weather delay time (minutes) by airline')\n",
    "            nas_fig = px.line(avg_NAS, x='Month', y='NASDelay', color='Reporting_Airline', title='Average NAS delay time (minutes) by airline')\n",
    "            sec_fig = px.line(avg_sec, x='Month', y='SecurityDelay', color='Reporting_Airline', title='Average security delay time (minutes) by airline')\n",
    "            late_fig = px.line(avg_late, x='Month', y='LateAircraftDelay', color='Reporting_Airline', title='Average late aircraft delay time (minutes) by airline')\n",
    "            \n",
    "            return[dcc.Graph(figure=carrier_fig), \n",
    "                   dcc.Graph(figure=weather_fig), \n",
    "                   dcc.Graph(figure=nas_fig), \n",
    "                   dcc.Graph(figure=sec_fig), \n",
    "                   dcc.Graph(figure=late_fig)]\n",
    "\n",
    "\n",
    "# Run the app\n",
    "if __name__ == '__main__':\n",
    "    #app.run_server(mode='inline')\n",
    "    #app.run_server()\n",
    "    # REVIEW8: Adding dev_tools_ui=False, dev_tools_props_check=False can prevent error appearing before calling callback function\n",
    "    app.run_server(mode=\"inline\", host=\"localhost\", debug=False, dev_tools_ui=False, dev_tools_props_check=False)\n",
    "    \n",
    "    #app.run_server(mode='jupyterlab')\n",
    "    #app.run_server(mode='external',port=8050)\n",
    "    #app.run_server(mode=\"external\")\n",
    "    #app.run_server(debug=True)\n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: watermark in c:\\users\\stefo\\anaconda3\\lib\\site-packages (2.3.0)\n",
      "Requirement already satisfied: ipython in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from watermark) (7.29.0)\n",
      "Requirement already satisfied: setuptools>=18.5 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->watermark) (58.0.4)\n",
      "Requirement already satisfied: colorama in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->watermark) (0.4.4)\n",
      "Requirement already satisfied: decorator in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->watermark) (5.1.0)\n",
      "Requirement already satisfied: pickleshare in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->watermark) (0.7.5)\n",
      "Requirement already satisfied: pygments in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->watermark) (2.10.0)\n",
      "Requirement already satisfied: prompt-toolkit!=3.0.0,!=3.0.1,<3.1.0,>=2.0.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->watermark) (3.0.20)\n",
      "Requirement already satisfied: jedi>=0.16 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->watermark) (0.18.0)\n",
      "Requirement already satisfied: backcall in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->watermark) (0.2.0)\n",
      "Requirement already satisfied: traitlets>=4.2 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->watermark) (5.1.0)\n",
      "Requirement already satisfied: matplotlib-inline in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from ipython->watermark) (0.1.2)\n",
      "Requirement already satisfied: parso<0.9.0,>=0.8.0 in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from jedi>=0.16->ipython->watermark) (0.8.2)\n",
      "Requirement already satisfied: wcwidth in c:\\users\\stefo\\anaconda3\\lib\\site-packages (from prompt-toolkit!=3.0.0,!=3.0.1,<3.1.0,>=2.0.0->ipython->watermark) (0.2.5)\n"
     ]
    }
   ],
   "source": [
    "!pip install  watermark"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "plotly: 5.6.0\n",
      "pandas: 1.3.4\n",
      "dash  : 2.1.0\n",
      "\n",
      " \n",
      "Last updated: Wed May 11 2022 21:21:46Eastern Daylight Time\n",
      "\n"
     ]
    }
   ],
   "source": [
    "%reload_ext watermark\n",
    "\n",
    "# python, ipython, packages, and machine characteristics\n",
    "#%watermark -v -m -p wget,pandas,numpy,altair\n",
    "%watermark --iversions\n",
    "# date\n",
    "print (\" \")\n",
    "%watermark -u -n -t -z \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Summary\n",
    "\n",
    "Congratulations for completing your dash and plotly assignment.\n",
    "\n",
    "More information about the libraries can be found [here](https://dash.plotly.com/?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDeveloperSkillsNetworkDV0101ENSkillsNetwork20297740-2021-01-01)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Author\n",
    "\n",
    "[Saishruthi Swaminathan](https://www.linkedin.com/in/saishruthi-swaminathan/?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDeveloperSkillsNetworkDV0101ENSkillsNetwork20297740-2021-01-01)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Changelog\n",
    "\n",
    "| Date       | Version | Changed by | Change Description                   |\n",
    "| ---------- | ------- | ---------- | ------------------------------------ |\n",
    "| 12-18-2020 | 1.0     | Nayef      | Added dataset link and upload to Git |\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## <h3 align=\"center\"> © IBM Corporation 2020. All rights reserved. <h3/>\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}