us_trade_alu_detailed.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd             # data package\n",
    "import matplotlib.pyplot as plt # graphics \n",
    "import datetime as dt\n",
    "import numpy as np\n",
    "from census import Census # This is new...\n",
    "\n",
    "import requests, io             # internet and input tools  \n",
    "import zipfile as zf            # zip file tools \n",
    "import os  \n",
    "\n",
    "#import weightedcalcs as wc\n",
    "#import numpy as np\n",
    "\n",
    "import pyarrow as pa\n",
    "import pyarrow.parquet as pq\n",
    " \n",
    "from bokeh.palettes import brewer, Spectral6\n",
    "from bokeh.io import show, output_file, curdoc\n",
    "from bokeh.plotting import figure\n",
    "from bokeh.models import ColumnDataSource, HoverTool, Panel, Tabs, GeoJSONDataSource, LinearColorMapper\n",
    "from bokeh.models import ColorBar\n",
    "from bokeh.layouts import column, gridplot, row\n",
    "from bokeh.transform import factor_cmap\n",
    "from bokeh.models import NumeralTickFormatter, Title, Label, Paragraph, Div, CustomJSHover, BoxAnnotation"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This notebook grabs lobster exports and then illustrates what is going on with them"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_month = 5\n",
    "\n",
    "trade_type = \"imports\"\n",
    "\n",
    "my_key = \"&key=34e40301bda77077e24c859c6c6c0b721ad73fc7\"\n",
    "# This is my key. I'm nice and I have it posted. If you will be doing more with this\n",
    "# please get your own key!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "crl = [\"darkblue\",\"slategray\",\"crimson\"]\n",
    "\n",
    "background = \"#ffffff\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "#### Grabe the trade data using the Census's API"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "def census_trade(url, trade_type, product_level):\n",
    "    \n",
    "    r = requests.get(url) \n",
    "    \n",
    "    print(r)\n",
    "    \n",
    "    df = pd.DataFrame(r.json()[1:]) # This then converts it to a dataframe\n",
    "    # Note that the first entry is the labels\n",
    "\n",
    "    df.columns = r.json()[0]\n",
    "\n",
    "    df.time = pd.to_datetime(df.time, format=\"%Y-%m\")\n",
    "    # This is so I can call this correctly...\n",
    "    \n",
    "    if trade_type == \"imports\":\n",
    "        \n",
    "        trade_label = trade_type\n",
    "        \n",
    "        df[trade_label] = df[\"CON_VAL_MO\"].astype(float)\n",
    "        \n",
    "        df[\"import_quantity\"] = df[\"CON_QY1_MO\"].astype(float)\n",
    "        \n",
    "        df[product_level] = df[\"I_COMMODITY\"].astype(str)\n",
    "        \n",
    "        df.drop([\"CON_VAL_MO\", \"I_COMMODITY\", \"COMM_LVL\",\"CON_QY1_MO\"], axis = 1, inplace = True)\n",
    "        \n",
    "    if trade_type == \"exports\":\n",
    "    \n",
    "        trade_label = trade_type\n",
    "        \n",
    "        df[trade_label] = df[\"ALL_VAL_MO\"].astype(float)\n",
    "\n",
    "        df[product_level] = df[\"E_COMMODITY\"].astype(str)        \n",
    "        \n",
    "        df.drop([\"ALL_VAL_MO\", \"E_COMMODITY\", \"CTY_CODE\", \"COMM_LVL\"], axis = 1, inplace = True)\n",
    "    \n",
    "    return df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "### This is the Product Specific plot..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<Response [200]>\n"
     ]
    }
   ],
   "source": [
    "end_use = \"hs?get=CON_VAL_MO,CTY_CODE,CTY_NAME,I_COMMODITY_LDESC,CON_QY1_MO,UNIT_QY1\"\n",
    "\n",
    "url = \"https://api.census.gov/data/timeseries/intltrade/imports/\" + end_use \n",
    "url = url + my_key + \"&time==from+2013-01\" + \"&COMM_LVL=HS10\" + \"&I_COMMODITY=760110*\"\n",
    "\n",
    "# This will grab all products that fall under the \"non-alloyed unwrought aluminum\"\n",
    "# and will have the quantity values that all appear to be in Killograms\n",
    "\n",
    "url = url\n",
    "\n",
    "df = census_trade(url,\"imports\",\"hs6\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>CTY_CODE</th>\n",
       "      <th>CTY_NAME</th>\n",
       "      <th>I_COMMODITY_LDESC</th>\n",
       "      <th>UNIT_QY1</th>\n",
       "      <th>time</th>\n",
       "      <th>imports</th>\n",
       "      <th>import_quantity</th>\n",
       "      <th>hs6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5710</th>\n",
       "      <td>7XXX</td>\n",
       "      <td>AFRICA</td>\n",
       "      <td>UNWROUGHT ALUMINUM NOT ALLOYED, NESOI</td>\n",
       "      <td>KG</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7601106090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5711</th>\n",
       "      <td>7XXX</td>\n",
       "      <td>AFRICA</td>\n",
       "      <td>UNWROUGHT ALUMINUM NOT ALLOYED, GREATER THAN 9...</td>\n",
       "      <td>KG</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7601106030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5712</th>\n",
       "      <td>7XXX</td>\n",
       "      <td>AFRICA</td>\n",
       "      <td>UNWROUGHT ALUMINUM NOT ALLOYED, NESOI</td>\n",
       "      <td>KG</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7601106090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5713</th>\n",
       "      <td>7XXX</td>\n",
       "      <td>AFRICA</td>\n",
       "      <td>UNWROUGHT ALUMINUM NOT ALLOYED, GREATER THAN 9...</td>\n",
       "      <td>KG</td>\n",
       "      <td>2021-02-01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7601106030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5714</th>\n",
       "      <td>7XXX</td>\n",
       "      <td>AFRICA</td>\n",
       "      <td>UNWROUGHT ALUMINUM NOT ALLOYED, NESOI</td>\n",
       "      <td>KG</td>\n",
       "      <td>2021-02-01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7601106090</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     CTY_CODE CTY_NAME                                  I_COMMODITY_LDESC  \\\n",
       "5710     7XXX   AFRICA              UNWROUGHT ALUMINUM NOT ALLOYED, NESOI   \n",
       "5711     7XXX   AFRICA  UNWROUGHT ALUMINUM NOT ALLOYED, GREATER THAN 9...   \n",
       "5712     7XXX   AFRICA              UNWROUGHT ALUMINUM NOT ALLOYED, NESOI   \n",
       "5713     7XXX   AFRICA  UNWROUGHT ALUMINUM NOT ALLOYED, GREATER THAN 9...   \n",
       "5714     7XXX   AFRICA              UNWROUGHT ALUMINUM NOT ALLOYED, NESOI   \n",
       "\n",
       "     UNIT_QY1       time  imports  import_quantity         hs6  \n",
       "5710       KG 2020-12-01      0.0              0.0  7601106090  \n",
       "5711       KG 2021-01-01      0.0              0.0  7601106030  \n",
       "5712       KG 2021-01-01      0.0              0.0  7601106090  \n",
       "5713       KG 2021-02-01      0.0              0.0  7601106030  \n",
       "5714       KG 2021-02-01      0.0              0.0  7601106090  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "clist = [\"CANADA\"]\n",
    "\n",
    "df = df[df.CTY_NAME.isin(clist)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['7601106000', '7601103000', '7601106030', '7601106090'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.hs6.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "grp = df.groupby(\"time\")\n",
    "\n",
    "canada_df = grp.agg({\"CTY_NAME\": \"first\", \"imports\": \"sum\", \"import_quantity\": \"sum\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "canada_df[\"import_tons\"] = canada_df[\"import_quantity\"]*0.00110231"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "canada_df[\"alu_price\"] = canada_df[\"imports\"]/canada_df[\"import_tons\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>CTY_NAME</th>\n",
       "      <th>imports</th>\n",
       "      <th>import_quantity</th>\n",
       "      <th>import_tons</th>\n",
       "      <th>alu_price</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-10-01</th>\n",
       "      <td>CANADA</td>\n",
       "      <td>150411931.0</td>\n",
       "      <td>79646192.0</td>\n",
       "      <td>87794.793904</td>\n",
       "      <td>1713.221528</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-11-01</th>\n",
       "      <td>CANADA</td>\n",
       "      <td>130757265.0</td>\n",
       "      <td>65475046.0</td>\n",
       "      <td>72173.797956</td>\n",
       "      <td>1811.699934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-01</th>\n",
       "      <td>CANADA</td>\n",
       "      <td>173886798.0</td>\n",
       "      <td>80555947.0</td>\n",
       "      <td>88797.625938</td>\n",
       "      <td>1958.237016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-01</th>\n",
       "      <td>CANADA</td>\n",
       "      <td>147414134.0</td>\n",
       "      <td>66540831.0</td>\n",
       "      <td>73348.623420</td>\n",
       "      <td>2009.773696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-02-01</th>\n",
       "      <td>CANADA</td>\n",
       "      <td>214495865.0</td>\n",
       "      <td>95101429.0</td>\n",
       "      <td>104831.256201</td>\n",
       "      <td>2046.106026</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           CTY_NAME      imports  import_quantity    import_tons    alu_price\n",
       "time                                                                         \n",
       "2020-10-01   CANADA  150411931.0       79646192.0   87794.793904  1713.221528\n",
       "2020-11-01   CANADA  130757265.0       65475046.0   72173.797956  1811.699934\n",
       "2020-12-01   CANADA  173886798.0       80555947.0   88797.625938  1958.237016\n",
       "2021-01-01   CANADA  147414134.0       66540831.0   73348.623420  2009.773696\n",
       "2021-02-01   CANADA  214495865.0       95101429.0  104831.256201  2046.106026"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "canada_df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "def make_time_by_country(df, level):\n",
    "\n",
    "    height = 533\n",
    "    width = 600\n",
    "\n",
    "    foobar = df[level]\n",
    "    \n",
    "    if level == \"imports\":\n",
    "        \n",
    "        title = \"$ US Imports from CANADA (HS 760110, NON-ALLOYED UNWROUGHT ALUMINUM)\"\n",
    "        \n",
    "    if level == \"import_tons\":\n",
    "        \n",
    "        title = \"TONS of US Imports from CANADA (HS 760110, NON-ALLOYED UNWROUGHT ALUMINUM)\"\n",
    "        \n",
    "    if level == \"alu_price\":\n",
    "        \n",
    "        title = \"$ Price per TON of US Imports from CANADA (HS 760110, NON-ALLOYED UNWROUGHT ALUMINUM)\"\n",
    "\n",
    "    p = figure(plot_height=height, plot_width = width, x_axis_type=\"datetime\",toolbar_location = 'below',\n",
    "           tools = \"box_zoom, reset, pan, xwheel_zoom\", title = title, x_range = (dt.datetime(2017,1,1),dt.datetime(2021,final_month,28)) ) \n",
    "\n",
    "    numlines=1\n",
    "\n",
    "    multi_line_source = ColumnDataSource({\n",
    "        'xs': [foobar.index.values]*numlines,\n",
    "        'ys': [foobar.values],\n",
    "        'label': [df[\"CTY_NAME\"].unique()],\n",
    "        'color': [\"crimson\", \"darkblue\"]})\n",
    "\n",
    "    p.multi_line(xs= \"xs\",\n",
    "                ys= \"ys\",\n",
    "                line_width=4, line_alpha=0.75, line_color = \"color\",\n",
    "                 hover_line_alpha=0.75, hover_line_width = 4,\n",
    "                hover_line_color= \"color\", source = multi_line_source)\n",
    "    \n",
    "    y_custom = CustomJSHover(code=\"\"\" return '' + special_vars.data_y\n",
    "            \"\"\")\n",
    "            \n",
    "    TIMETOOLTIPS = \"\"\"\n",
    "            <div style=\"background-color:#F5F5F5; opacity: 0.95; border: 5px 5px 5px 5px;\">\n",
    "            <div style = \"text-align:left;\">\n",
    "            <span style=\"font-size: 13px; font-weight: bold\"> @label\n",
    "             </span>\n",
    "             </div>\n",
    "             <div style = \"text-align:left;\">\"\"\"\n",
    "    \n",
    "    if level == \"imports\": \n",
    "    \n",
    "        TIMETOOLTIPS = TIMETOOLTIPS + \"\"\"\n",
    "            <span style=\"font-size: 13px; font-weight: bold\"> $data_x{%b %Y}:  $data_y{$0.0a}</span>   \n",
    "            </div>\n",
    "            </div>\n",
    "            \"\"\"\n",
    "        \n",
    "    if level == \"alu_price\": \n",
    "    \n",
    "        TIMETOOLTIPS = TIMETOOLTIPS + \"\"\"\n",
    "            <span style=\"font-size: 13px; font-weight: bold\"> $data_x{%b %Y}:  $data_y{$0.00a}</span>   \n",
    "            </div>\n",
    "            </div>\n",
    "            \"\"\"\n",
    "        \n",
    "    if level == \"import_tons\":\n",
    "        \n",
    "        TIMETOOLTIPS = TIMETOOLTIPS + \"\"\"\n",
    "            <span style=\"font-size: 13px; font-weight: bold\"> $data_x{%b %Y}:  $data_y{0.0a}</span>   \n",
    "            </div>\n",
    "            </div>\n",
    "            \"\"\"        \n",
    "        \n",
    "    p.add_tools(HoverTool(tooltips = TIMETOOLTIPS,  line_policy='nearest', formatters={'$data_x': 'datetime'}))\n",
    "    p.title.text_font_size = '13pt'\n",
    "    p.background_fill_color = background \n",
    "    p.background_fill_alpha = 0.75\n",
    "    p.border_fill_color = background \n",
    "    \n",
    "    \n",
    "    tariffs232_box = BoxAnnotation(left=dt.datetime(2018,5,31), right=dt.datetime(2019,5,20), fill_color='slategray', fill_alpha=0.1)\n",
    "    p.add_layout(tariffs232_box)\n",
    "    \n",
    "    if level == \"import_tons\":\n",
    "        \n",
    "        tariffs232_box1 = BoxAnnotation(top =  83000*(1+1.05), bottom = 83000, left=dt.datetime(2020,9,1), right=dt.datetime(2020,9,30), fill_color=\"darkblue\", fill_alpha=0.1)\n",
    "        p.add_layout(tariffs232_box1)\n",
    "        \n",
    "        tariffs232_box2 = BoxAnnotation(top =  70000*(1+1.05), bottom = 70000, left=dt.datetime(2020,10,1), right=dt.datetime(2020,10,31), fill_color=\"darkblue\", fill_alpha=0.1)\n",
    "        p.add_layout(tariffs232_box2)\n",
    "        \n",
    "        tariffs232_box3 = BoxAnnotation(top =  83000*(1+1.05), bottom = 83000, left=dt.datetime(2020,11,1), right=dt.datetime(2020,11,30), fill_color=\"darkblue\", fill_alpha=0.1)\n",
    "        p.add_layout(tariffs232_box3)\n",
    "        \n",
    "        tariffs232_box4 = BoxAnnotation(top =  70000*(1+1.05), bottom = 70000,left=dt.datetime(2020,12,1), right=dt.datetime(2020,12,31), fill_color=\"darkblue\", fill_alpha=0.1)\n",
    "        p.add_layout(tariffs232_box4)\n",
    "\n",
    "    p.yaxis.axis_label_text_font_style = 'bold'\n",
    "    p.yaxis.axis_label_text_font_size = \"13px\"\n",
    "\n",
    "    p.yaxis.minor_tick_line_color = None\n",
    "    \n",
    "    \n",
    "    if level == \"imports\":\n",
    "        p.yaxis.formatter = NumeralTickFormatter(format=\"($0. a)\")\n",
    "        \n",
    "    if level == \"alu_price\":\n",
    "        p.yaxis.formatter = NumeralTickFormatter(format=\"($0.0a)\")\n",
    "        \n",
    "    if level == \"import_tons\":\n",
    "        p.yaxis.formatter = NumeralTickFormatter(format=\"(0 a)\")\n",
    "    \n",
    "    p.outline_line_color = None\n",
    "    p.sizing_mode= \"scale_both\"\n",
    "    p.max_height = height\n",
    "    p.max_width = width\n",
    "    \n",
    "    p.toolbar.active_drag = None\n",
    "    p.toolbar.autohide = True\n",
    "    p.min_border_left = 0\n",
    "    p.min_border_bottom = 0\n",
    "\n",
    "    return p"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "BokehUserWarning: ColumnDataSource's columns must be of the same length. Current lengths: ('color', 2), ('label', 1), ('xs', 1), ('ys', 1)\n",
      "BokehUserWarning: ColumnDataSource's columns must be of the same length. Current lengths: ('color', 2), ('label', 1), ('xs', 1), ('ys', 1)\n",
      "BokehUserWarning: ColumnDataSource's columns must be of the same length. Current lengths: ('color', 2), ('label', 1), ('xs', 1), ('ys', 1)\n"
     ]
    }
   ],
   "source": [
    "qlevel = make_time_by_country(canada_df, \"import_tons\")\n",
    "    \n",
    "dlevel = make_time_by_country(canada_df, \"imports\")\n",
    "\n",
    "plevel = make_time_by_country(canada_df, \"alu_price\")\n",
    "\n",
    "tab3 = Panel(child= qlevel, title=\"Imports in Tons\")\n",
    "\n",
    "tab4 = Panel(child= dlevel, title=\"Imports in $\")\n",
    "\n",
    "tab5 = Panel(child= plevel, title=\"Price Per Ton in $\")\n",
    "\n",
    "output_file('.\\\\docs\\\\' + \"us_alu_detailed.html\")\n",
    "\n",
    "div0 = Div(text = \"\"\"Shaded grey area indicates when the Section 232 tariffs, under Proclamation 9704, on Canada went into effect\n",
    "and were removed. Shaded blue area indicates date and ranges for which tariffs will not be \n",
    "reimposed. Hover over the line with your curser to view month by month values.\"\"\", max_width=555, background = background )\n",
    "div0.sizing_mode= \"scale_both\"\n",
    "        \n",
    "outfig = column(Tabs(tabs=[tab3,  tab4, tab5], tabs_location = \"above\"), div0, sizing_mode=\"scale_both\")\n",
    "\n",
    "show(outfig)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}