Bokeh - Polish Trade Balance.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import datetime\n",
    "from bokeh.plotting import figure\n",
    "from bokeh.io import show, output_notebook\n",
    "from bokeh.models import ColumnDataSource, HoverTool, Range1d, Arrow, VeeHead, Label, LinearAxis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>year</th>\n",
       "      <th>quarter</th>\n",
       "      <th>export</th>\n",
       "      <th>import</th>\n",
       "      <th>balance</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2004</td>\n",
       "      <td>1</td>\n",
       "      <td>12317</td>\n",
       "      <td>13856</td>\n",
       "      <td>-1539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2004</td>\n",
       "      <td>2</td>\n",
       "      <td>15395</td>\n",
       "      <td>17089</td>\n",
       "      <td>-1694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2004</td>\n",
       "      <td>3</td>\n",
       "      <td>15479</td>\n",
       "      <td>16670</td>\n",
       "      <td>-1191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2004</td>\n",
       "      <td>4</td>\n",
       "      <td>16434</td>\n",
       "      <td>17565</td>\n",
       "      <td>-1131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2005</td>\n",
       "      <td>1</td>\n",
       "      <td>16099</td>\n",
       "      <td>16634</td>\n",
       "      <td>-535</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   year  quarter  export  import  balance\n",
       "0  2004        1   12317   13856    -1539\n",
       "1  2004        2   15395   17089    -1694\n",
       "2  2004        3   15479   16670    -1191\n",
       "3  2004        4   16434   17565    -1131\n",
       "4  2005        1   16099   16634     -535"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Read data\n",
    "trade_balance = pd.read_csv(\"PolandTradeBalance.csv\", sep=\";\")\n",
    "trade_balance.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>year</th>\n",
       "      <th>quarter</th>\n",
       "      <th>export</th>\n",
       "      <th>import</th>\n",
       "      <th>balance</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>60.000000</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>60.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2011.000000</td>\n",
       "      <td>2.500000</td>\n",
       "      <td>33244.966667</td>\n",
       "      <td>34811.650000</td>\n",
       "      <td>-1566.683333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>4.356954</td>\n",
       "      <td>1.127469</td>\n",
       "      <td>11388.995197</td>\n",
       "      <td>10796.583984</td>\n",
       "      <td>1809.126585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2004.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>12317.000000</td>\n",
       "      <td>13856.000000</td>\n",
       "      <td>-6246.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2007.000000</td>\n",
       "      <td>1.750000</td>\n",
       "      <td>24076.500000</td>\n",
       "      <td>26400.250000</td>\n",
       "      <td>-2379.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2011.000000</td>\n",
       "      <td>2.500000</td>\n",
       "      <td>33127.500000</td>\n",
       "      <td>36181.000000</td>\n",
       "      <td>-1298.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2015.000000</td>\n",
       "      <td>3.250000</td>\n",
       "      <td>42185.750000</td>\n",
       "      <td>42025.250000</td>\n",
       "      <td>-556.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2018.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>56838.000000</td>\n",
       "      <td>58511.000000</td>\n",
       "      <td>1711.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              year    quarter        export        import      balance\n",
       "count    60.000000  60.000000     60.000000     60.000000    60.000000\n",
       "mean   2011.000000   2.500000  33244.966667  34811.650000 -1566.683333\n",
       "std       4.356954   1.127469  11388.995197  10796.583984  1809.126585\n",
       "min    2004.000000   1.000000  12317.000000  13856.000000 -6246.000000\n",
       "25%    2007.000000   1.750000  24076.500000  26400.250000 -2379.500000\n",
       "50%    2011.000000   2.500000  33127.500000  36181.000000 -1298.500000\n",
       "75%    2015.000000   3.250000  42185.750000  42025.250000  -556.000000\n",
       "max    2018.000000   4.000000  56838.000000  58511.000000  1711.000000"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trade_balance.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Convert year and quarter to specific datetime objects\n",
    "quarter_begin = []\n",
    "for row in range(len(trade_balance)):\n",
    "    quarter_begin.append(datetime.datetime(trade_balance['year'][row], trade_balance['quarter'][row] * 3 - 2, 1))\n",
    "trade_balance['quarter_begin'] = quarter_begin  # Need to add column for converting to ColumnDataSource later"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create columns for HoverTool descriptions\n",
    "period = []  # '2004Q1' format\n",
    "for row in range(len(trade_balance)):\n",
    "    period.append(str(trade_balance['year'][row]) + \"Q\" + str(trade_balance['quarter'][row]))\n",
    "trade_balance['period'] = period\n",
    "\n",
    "\n",
    "def add_mln_to_column(column):  # Convert integer to string with commas and add currency\n",
    "    column_eur = []\n",
    "    for row in range(len(column)):\n",
    "        column_eur.append(\n",
    "            \"{:,}\".format(column[row]) + \" mln EUR\")\n",
    "    return column_eur\n",
    "\n",
    "\n",
    "trade_balance['import_EUR'] = add_mln_to_column(trade_balance['import'])\n",
    "trade_balance['export_EUR'] = add_mln_to_column(trade_balance['export'])\n",
    "trade_balance['balance_EUR'] = add_mln_to_column(trade_balance['balance'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "trade_balance_cds = ColumnDataSource(trade_balance) # Needed for HoverTool"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    <div class=\"bk-root\">\n",
       "        <a href=\"https://bokeh.pydata.org\" target=\"_blank\" class=\"bk-logo bk-logo-small bk-logo-notebook\"></a>\n",
       "        <span id=\"d18f43c6-d052-471f-98f4-4cac265244d6\">Loading BokehJS ...</span>\n",
       "    </div>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "\n",
       "(function(root) {\n",
       "  function now() {\n",
       "    return new Date();\n",
       "  }\n",
       "\n",
       "  var force = true;\n",
       "\n",
       "  if (typeof (root._bokeh_onload_callbacks) === \"undefined\" || force === true) {\n",
       "    root._bokeh_onload_callbacks = [];\n",
       "    root._bokeh_is_loading = undefined;\n",
       "  }\n",
       "\n",
       "  var JS_MIME_TYPE = 'application/javascript';\n",
       "  var HTML_MIME_TYPE = 'text/html';\n",
       "  var EXEC_MIME_TYPE = 'application/vnd.bokehjs_exec.v0+json';\n",
       "  var CLASS_NAME = 'output_bokeh rendered_html';\n",
       "\n",
       "  /**\n",
       "   * Render data to the DOM node\n",
       "   */\n",
       "  function render(props, node) {\n",
       "    var script = document.createElement(\"script\");\n",
       "    node.appendChild(script);\n",
       "  }\n",
       "\n",
       "  /**\n",
       "   * Handle when an output is cleared or removed\n",
       "   */\n",
       "  function handleClearOutput(event, handle) {\n",
       "    var cell = handle.cell;\n",
       "\n",
       "    var id = cell.output_area._bokeh_element_id;\n",
       "    var server_id = cell.output_area._bokeh_server_id;\n",
       "    // Clean up Bokeh references\n",
       "    if (id !== undefined) {\n",
       "      Bokeh.index[id].model.document.clear();\n",
       "      delete Bokeh.index[id];\n",
       "    }\n",
       "\n",
       "    if (server_id !== undefined) {\n",
       "      // Clean up Bokeh references\n",
       "      var cmd = \"from bokeh.io.state import curstate; print(curstate().uuid_to_server['\" + server_id + \"'].get_sessions()[0].document.roots[0]._id)\";\n",
       "      cell.notebook.kernel.execute(cmd, {\n",
       "        iopub: {\n",
       "          output: function(msg) {\n",
       "            var element_id = msg.content.text.trim();\n",
       "            Bokeh.index[element_id].model.document.clear();\n",
       "            delete Bokeh.index[element_id];\n",
       "          }\n",
       "        }\n",
       "      });\n",
       "      // Destroy server and session\n",
       "      var cmd = \"import bokeh.io.notebook as ion; ion.destroy_server('\" + server_id + \"')\";\n",
       "      cell.notebook.kernel.execute(cmd);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  /**\n",
       "   * Handle when a new output is added\n",
       "   */\n",
       "  function handleAddOutput(event, handle) {\n",
       "    var output_area = handle.output_area;\n",
       "    var output = handle.output;\n",
       "\n",
       "    // limit handleAddOutput to display_data with EXEC_MIME_TYPE content only\n",
       "    if ((output.output_type != \"display_data\") || (!output.data.hasOwnProperty(EXEC_MIME_TYPE))) {\n",
       "      return\n",
       "    }\n",
       "\n",
       "    var toinsert = output_area.element.find(\".\" + CLASS_NAME.split(' ')[0]);\n",
       "\n",
       "    if (output.metadata[EXEC_MIME_TYPE][\"id\"] !== undefined) {\n",
       "      toinsert[0].firstChild.textContent = output.data[JS_MIME_TYPE];\n",
       "      // store reference to embed id on output_area\n",
       "      output_area._bokeh_element_id = output.metadata[EXEC_MIME_TYPE][\"id\"];\n",
       "    }\n",
       "    if (output.metadata[EXEC_MIME_TYPE][\"server_id\"] !== undefined) {\n",
       "      var bk_div = document.createElement(\"div\");\n",
       "      bk_div.innerHTML = output.data[HTML_MIME_TYPE];\n",
       "      var script_attrs = bk_div.children[0].attributes;\n",
       "      for (var i = 0; i < script_attrs.length; i++) {\n",
       "        toinsert[0].firstChild.setAttribute(script_attrs[i].name, script_attrs[i].value);\n",
       "      }\n",
       "      // store reference to server id on output_area\n",
       "      output_area._bokeh_server_id = output.metadata[EXEC_MIME_TYPE][\"server_id\"];\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function register_renderer(events, OutputArea) {\n",
       "\n",
       "    function append_mime(data, metadata, element) {\n",
       "      // create a DOM node to render to\n",
       "      var toinsert = this.create_output_subarea(\n",
       "        metadata,\n",
       "        CLASS_NAME,\n",
       "        EXEC_MIME_TYPE\n",
       "      );\n",
       "      this.keyboard_manager.register_events(toinsert);\n",
       "      // Render to node\n",
       "      var props = {data: data, metadata: metadata[EXEC_MIME_TYPE]};\n",
       "      render(props, toinsert[0]);\n",
       "      element.append(toinsert);\n",
       "      return toinsert\n",
       "    }\n",
       "\n",
       "    /* Handle when an output is cleared or removed */\n",
       "    events.on('clear_output.CodeCell', handleClearOutput);\n",
       "    events.on('delete.Cell', handleClearOutput);\n",
       "\n",
       "    /* Handle when a new output is added */\n",
       "    events.on('output_added.OutputArea', handleAddOutput);\n",
       "\n",
       "    /**\n",
       "     * Register the mime type and append_mime function with output_area\n",
       "     */\n",
       "    OutputArea.prototype.register_mime_type(EXEC_MIME_TYPE, append_mime, {\n",
       "      /* Is output safe? */\n",
       "      safe: true,\n",
       "      /* Index of renderer in `output_area.display_order` */\n",
       "      index: 0\n",
       "    });\n",
       "  }\n",
       "\n",
       "  // register the mime type if in Jupyter Notebook environment and previously unregistered\n",
       "  if (root.Jupyter !== undefined) {\n",
       "    var events = require('base/js/events');\n",
       "    var OutputArea = require('notebook/js/outputarea').OutputArea;\n",
       "\n",
       "    if (OutputArea.prototype.mime_types().indexOf(EXEC_MIME_TYPE) == -1) {\n",
       "      register_renderer(events, OutputArea);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  \n",
       "  if (typeof (root._bokeh_timeout) === \"undefined\" || force === true) {\n",
       "    root._bokeh_timeout = Date.now() + 5000;\n",
       "    root._bokeh_failed_load = false;\n",
       "  }\n",
       "\n",
       "  var NB_LOAD_WARNING = {'data': {'text/html':\n",
       "     \"<div style='background-color: #fdd'>\\n\"+\n",
       "     \"<p>\\n\"+\n",
       "     \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n",
       "     \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n",
       "     \"</p>\\n\"+\n",
       "     \"<ul>\\n\"+\n",
       "     \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n",
       "     \"<li>use INLINE resources instead, as so:</li>\\n\"+\n",
       "     \"</ul>\\n\"+\n",
       "     \"<code>\\n\"+\n",
       "     \"from bokeh.resources import INLINE\\n\"+\n",
       "     \"output_notebook(resources=INLINE)\\n\"+\n",
       "     \"</code>\\n\"+\n",
       "     \"</div>\"}};\n",
       "\n",
       "  function display_loaded() {\n",
       "    var el = document.getElementById(\"d18f43c6-d052-471f-98f4-4cac265244d6\");\n",
       "    if (el != null) {\n",
       "      el.textContent = \"BokehJS is loading...\";\n",
       "    }\n",
       "    if (root.Bokeh !== undefined) {\n",
       "      if (el != null) {\n",
       "        el.textContent = \"BokehJS \" + root.Bokeh.version + \" successfully loaded.\";\n",
       "      }\n",
       "    } else if (Date.now() < root._bokeh_timeout) {\n",
       "      setTimeout(display_loaded, 100)\n",
       "    }\n",
       "  }\n",
       "\n",
       "\n",
       "  function run_callbacks() {\n",
       "    try {\n",
       "      root._bokeh_onload_callbacks.forEach(function(callback) { callback() });\n",
       "    }\n",
       "    finally {\n",
       "      delete root._bokeh_onload_callbacks\n",
       "    }\n",
       "    console.info(\"Bokeh: all callbacks have finished\");\n",
       "  }\n",
       "\n",
       "  function load_libs(js_urls, callback) {\n",
       "    root._bokeh_onload_callbacks.push(callback);\n",
       "    if (root._bokeh_is_loading > 0) {\n",
       "      console.log(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n",
       "      return null;\n",
       "    }\n",
       "    if (js_urls == null || js_urls.length === 0) {\n",
       "      run_callbacks();\n",
       "      return null;\n",
       "    }\n",
       "    console.log(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n",
       "    root._bokeh_is_loading = js_urls.length;\n",
       "    for (var i = 0; i < js_urls.length; i++) {\n",
       "      var url = js_urls[i];\n",
       "      var s = document.createElement('script');\n",
       "      s.src = url;\n",
       "      s.async = false;\n",
       "      s.onreadystatechange = s.onload = function() {\n",
       "        root._bokeh_is_loading--;\n",
       "        if (root._bokeh_is_loading === 0) {\n",
       "          console.log(\"Bokeh: all BokehJS libraries loaded\");\n",
       "          run_callbacks()\n",
       "        }\n",
       "      };\n",
       "      s.onerror = function() {\n",
       "        console.warn(\"failed to load library \" + url);\n",
       "      };\n",
       "      console.log(\"Bokeh: injecting script tag for BokehJS library: \", url);\n",
       "      document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "    }\n",
       "  };var element = document.getElementById(\"d18f43c6-d052-471f-98f4-4cac265244d6\");\n",
       "  if (element == null) {\n",
       "    console.log(\"Bokeh: ERROR: autoload.js configured with elementid 'd18f43c6-d052-471f-98f4-4cac265244d6' but no matching script tag was found. \")\n",
       "    return false;\n",
       "  }\n",
       "\n",
       "  var js_urls = [\"https://cdn.pydata.org/bokeh/release/bokeh-0.12.13.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.13.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-tables-0.12.13.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-gl-0.12.13.min.js\"];\n",
       "\n",
       "  var inline_js = [\n",
       "    function(Bokeh) {\n",
       "      Bokeh.set_log_level(\"info\");\n",
       "    },\n",
       "    \n",
       "    function(Bokeh) {\n",
       "      \n",
       "    },\n",
       "    function(Bokeh) {\n",
       "      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-0.12.13.min.css\");\n",
       "      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-0.12.13.min.css\");\n",
       "      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.13.min.css\");\n",
       "      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.13.min.css\");\n",
       "      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-tables-0.12.13.min.css\");\n",
       "      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-tables-0.12.13.min.css\");\n",
       "    }\n",
       "  ];\n",
       "\n",
       "  function run_inline_js() {\n",
       "    \n",
       "    if ((root.Bokeh !== undefined) || (force === true)) {\n",
       "      for (var i = 0; i < inline_js.length; i++) {\n",
       "        inline_js[i].call(root, root.Bokeh);\n",
       "      }if (force === true) {\n",
       "        display_loaded();\n",
       "      }} else if (Date.now() < root._bokeh_timeout) {\n",
       "      setTimeout(run_inline_js, 100);\n",
       "    } else if (!root._bokeh_failed_load) {\n",
       "      console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n",
       "      root._bokeh_failed_load = true;\n",
       "    } else if (force !== true) {\n",
       "      var cell = $(document.getElementById(\"d18f43c6-d052-471f-98f4-4cac265244d6\")).parents('.cell').data().cell;\n",
       "      cell.output_area.append_execute_result(NB_LOAD_WARNING)\n",
       "    }\n",
       "\n",
       "  }\n",
       "\n",
       "  if (root._bokeh_is_loading === 0) {\n",
       "    console.log(\"Bokeh: BokehJS loaded, going straight to plotting\");\n",
       "    run_inline_js();\n",
       "  } else {\n",
       "    load_libs(js_urls, function() {\n",
       "      console.log(\"Bokeh: BokehJS plotting callback run at\", now());\n",
       "      run_inline_js();\n",
       "    });\n",
       "  }\n",
       "}(window));"
      ],
      "application/vnd.bokehjs_load.v0+json": "\n(function(root) {\n  function now() {\n    return new Date();\n  }\n\n  var force = true;\n\n  if (typeof (root._bokeh_onload_callbacks) === \"undefined\" || force === true) {\n    root._bokeh_onload_callbacks = [];\n    root._bokeh_is_loading = undefined;\n  }\n\n  \n\n  \n  if (typeof (root._bokeh_timeout) === \"undefined\" || force === true) {\n    root._bokeh_timeout = Date.now() + 5000;\n    root._bokeh_failed_load = false;\n  }\n\n  var NB_LOAD_WARNING = {'data': {'text/html':\n     \"<div style='background-color: #fdd'>\\n\"+\n     \"<p>\\n\"+\n     \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n     \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n     \"</p>\\n\"+\n     \"<ul>\\n\"+\n     \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n     \"<li>use INLINE resources instead, as so:</li>\\n\"+\n     \"</ul>\\n\"+\n     \"<code>\\n\"+\n     \"from bokeh.resources import INLINE\\n\"+\n     \"output_notebook(resources=INLINE)\\n\"+\n     \"</code>\\n\"+\n     \"</div>\"}};\n\n  function display_loaded() {\n    var el = document.getElementById(\"d18f43c6-d052-471f-98f4-4cac265244d6\");\n    if (el != null) {\n      el.textContent = \"BokehJS is loading...\";\n    }\n    if (root.Bokeh !== undefined) {\n      if (el != null) {\n        el.textContent = \"BokehJS \" + root.Bokeh.version + \" successfully loaded.\";\n      }\n    } else if (Date.now() < root._bokeh_timeout) {\n      setTimeout(display_loaded, 100)\n    }\n  }\n\n\n  function run_callbacks() {\n    try {\n      root._bokeh_onload_callbacks.forEach(function(callback) { callback() });\n    }\n    finally {\n      delete root._bokeh_onload_callbacks\n    }\n    console.info(\"Bokeh: all callbacks have finished\");\n  }\n\n  function load_libs(js_urls, callback) {\n    root._bokeh_onload_callbacks.push(callback);\n    if (root._bokeh_is_loading > 0) {\n      console.log(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n      return null;\n    }\n    if (js_urls == null || js_urls.length === 0) {\n      run_callbacks();\n      return null;\n    }\n    console.log(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n    root._bokeh_is_loading = js_urls.length;\n    for (var i = 0; i < js_urls.length; i++) {\n      var url = js_urls[i];\n      var s = document.createElement('script');\n      s.src = url;\n      s.async = false;\n      s.onreadystatechange = s.onload = function() {\n        root._bokeh_is_loading--;\n        if (root._bokeh_is_loading === 0) {\n          console.log(\"Bokeh: all BokehJS libraries loaded\");\n          run_callbacks()\n        }\n      };\n      s.onerror = function() {\n        console.warn(\"failed to load library \" + url);\n      };\n      console.log(\"Bokeh: injecting script tag for BokehJS library: \", url);\n      document.getElementsByTagName(\"head\")[0].appendChild(s);\n    }\n  };var element = document.getElementById(\"d18f43c6-d052-471f-98f4-4cac265244d6\");\n  if (element == null) {\n    console.log(\"Bokeh: ERROR: autoload.js configured with elementid 'd18f43c6-d052-471f-98f4-4cac265244d6' but no matching script tag was found. \")\n    return false;\n  }\n\n  var js_urls = [\"https://cdn.pydata.org/bokeh/release/bokeh-0.12.13.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.13.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-tables-0.12.13.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-gl-0.12.13.min.js\"];\n\n  var inline_js = [\n    function(Bokeh) {\n      Bokeh.set_log_level(\"info\");\n    },\n    \n    function(Bokeh) {\n      \n    },\n    function(Bokeh) {\n      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-0.12.13.min.css\");\n      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-0.12.13.min.css\");\n      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.13.min.css\");\n      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.13.min.css\");\n      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-tables-0.12.13.min.css\");\n      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-tables-0.12.13.min.css\");\n    }\n  ];\n\n  function run_inline_js() {\n    \n    if ((root.Bokeh !== undefined) || (force === true)) {\n      for (var i = 0; i < inline_js.length; i++) {\n        inline_js[i].call(root, root.Bokeh);\n      }if (force === true) {\n        display_loaded();\n      }} else if (Date.now() < root._bokeh_timeout) {\n      setTimeout(run_inline_js, 100);\n    } else if (!root._bokeh_failed_load) {\n      console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n      root._bokeh_failed_load = true;\n    } else if (force !== true) {\n      var cell = $(document.getElementById(\"d18f43c6-d052-471f-98f4-4cac265244d6\")).parents('.cell').data().cell;\n      cell.output_area.append_execute_result(NB_LOAD_WARNING)\n    }\n\n  }\n\n  if (root._bokeh_is_loading === 0) {\n    console.log(\"Bokeh: BokehJS loaded, going straight to plotting\");\n    run_inline_js();\n  } else {\n    load_libs(js_urls, function() {\n      console.log(\"Bokeh: BokehJS plotting callback run at\", now());\n      run_inline_js();\n    });\n  }\n}(window));"
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "<div class=\"bk-root\">\n",
       "    <div class=\"bk-plotdiv\" id=\"1aa0fe10-a8af-4938-a07e-84cecd875634\"></div>\n",
       "</div>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"c9a59949-a1ad-426f-af85-6c2a4962b5fb\":{\"roots\":{\"references\":[{\"attributes\":{\"axis_label\":\"Trade balance (mln EUR)\",\"axis_label_text_font_style\":\"bold\",\"formatter\":{\"id\":\"a019b383-2518-4a32-aa79-d6c385f4bddb\",\"type\":\"BasicTickFormatter\"},\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"58082cc6-9258-4b75-a13d-cf27c19f1156\",\"type\":\"BasicTicker\"},\"y_range_name\":\"foo\"},\"id\":\"4e1d005b-9691-4f1c-8f8b-6594d4f9c3ce\",\"type\":\"LinearAxis\"},{\"attributes\":{\"callback\":null,\"end\":5000,\"start\":-7000},\"id\":\"0f6aec41-940b-46be-a46d-d7e03a3b0edb\",\"type\":\"Range1d\"},{\"attributes\":{\"below\":[{\"id\":\"5e8b9af2-458b-4ac5-8f78-591f76ddf04e\",\"type\":\"DatetimeAxis\"}],\"extra_y_ranges\":{\"foo\":{\"id\":\"0f6aec41-940b-46be-a46d-d7e03a3b0edb\",\"type\":\"Range1d\"}},\"left\":[{\"id\":\"151a95e0-7a95-45c8-8734-155c37bc15f6\",\"type\":\"LinearAxis\"}],\"plot_height\":900,\"plot_width\":900,\"renderers\":[{\"id\":\"5e8b9af2-458b-4ac5-8f78-591f76ddf04e\",\"type\":\"DatetimeAxis\"},{\"id\":\"eb3446a8-d7db-4f47-b54d-8ab3177e016a\",\"type\":\"Grid\"},{\"id\":\"151a95e0-7a95-45c8-8734-155c37bc15f6\",\"type\":\"LinearAxis\"},{\"id\":\"b8982026-b426-4397-9166-94a3eade4cae\",\"type\":\"Grid\"},{\"id\":\"670d106d-bec5-417e-be3d-6c2df50b25c3\",\"type\":\"BoxAnnotation\"},{\"id\":\"4e1d005b-9691-4f1c-8f8b-6594d4f9c3ce\",\"type\":\"LinearAxis\"},{\"id\":\"83a55ade-c341-4aff-89b9-18b16e756af7\",\"type\":\"Legend\"},{\"id\":\"d74f3dff-396e-4495-abf7-c8e1b06720f8\",\"type\":\"GlyphRenderer\"},{\"id\":\"31987c72-b325-44bc-8ec7-91cd3b6eccb0\",\"type\":\"GlyphRenderer\"},{\"id\":\"98cbad33-faec-4419-99b6-11e306449ad7\",\"type\":\"GlyphRenderer\"},{\"id\":\"c1479399-0858-447b-9ce7-37e1c108862b\",\"type\":\"Arrow\"},{\"id\":\"4b201a95-dc23-4aa9-bbc2-d020a4cd0764\",\"type\":\"Arrow\"},{\"id\":\"0b2d58af-4d69-42f8-a21a-f5ba34d59a8a\",\"type\":\"Label\"},{\"id\":\"75ff37cd-17f0-4f61-8ade-1b1e6238d92b\",\"type\":\"Label\"},{\"id\":\"76b54f8d-6442-4a49-8c8e-6d4d74458d4a\",\"type\":\"Label\"},{\"id\":\"1e444b60-8708-4f83-8f42-7195c4e52144\",\"type\":\"Label\"},{\"id\":\"2146f314-c00b-4445-8296-8817ffef692b\",\"type\":\"Label\"},{\"id\":\"8073075d-f53a-4b80-9feb-14fcd93cede5\",\"type\":\"Label\"}],\"right\":[{\"id\":\"4e1d005b-9691-4f1c-8f8b-6594d4f9c3ce\",\"type\":\"LinearAxis\"}],\"title\":{\"id\":\"d2faa5d8-0223-445b-a80a-2eb9277e89db\",\"type\":\"Title\"},\"toolbar\":{\"id\":\"af803ebf-c294-488f-bdc4-19034ee6c87e\",\"type\":\"Toolbar\"},\"x_range\":{\"id\":\"9bf707ab-ce0b-40a8-97a6-c59d18f9efb2\",\"type\":\"DataRange1d\"},\"x_scale\":{\"id\":\"77501c0a-84bc-4b25-8a87-8acb50fc18bc\",\"type\":\"LinearScale\"},\"y_range\":{\"id\":\"f5f83fc6-076e-44ca-93b6-905c1ad00f6f\",\"type\":\"Range1d\"},\"y_scale\":{\"id\":\"ce36fd40-14f2-4484-aed6-a8edcbc0ec87\",\"type\":\"LinearScale\"}},\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{},\"id\":\"6b227ac6-c7ee-4815-869b-7a854283c6a5\",\"type\":\"DatetimeTickFormatter\"},{\"attributes\":{\"align\":\"center\",\"plot\":null,\"text\":\"Polish Trade Balance 2004-2018\",\"text_font_size\":{\"value\":\"18pt\"}},\"id\":\"d2faa5d8-0223-445b-a80a-2eb9277e89db\",\"type\":\"Title\"},{\"attributes\":{\"callback\":null},\"id\":\"9bf707ab-ce0b-40a8-97a6-c59d18f9efb2\",\"type\":\"DataRange1d\"},{\"attributes\":{\"active_drag\":\"auto\",\"active_inspect\":\"auto\",\"active_scroll\":\"auto\",\"active_tap\":\"auto\",\"tools\":[{\"id\":\"2e900b6e-f740-44b5-ae82-07f85c2a9712\",\"type\":\"PanTool\"},{\"id\":\"efeb3494-2a45-4e8c-a581-0f030ba6fcb0\",\"type\":\"WheelZoomTool\"},{\"id\":\"fcda189d-e05c-4236-adc1-0f263a6e04fa\",\"type\":\"BoxZoomTool\"},{\"id\":\"14ea270c-5397-43b4-80c6-77487ad74a2b\",\"type\":\"SaveTool\"},{\"id\":\"7dbf536c-ab07-40d4-8d26-eb90ac13fb10\",\"type\":\"ResetTool\"},{\"id\":\"1c1b7635-470b-49cb-9d98-c5f85f613999\",\"type\":\"HelpTool\"},{\"id\":\"19500115-0b03-47f2-b463-4338cf58c462\",\"type\":\"HoverTool\"}]},\"id\":\"af803ebf-c294-488f-bdc4-19034ee6c87e\",\"type\":\"Toolbar\"},{\"attributes\":{\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"text\":\"Hover over bar chart to get more details.\",\"text_alpha\":{\"value\":0.5},\"text_font_size\":{\"value\":\"10pt\"},\"x\":1236552800000,\"y\":56000},\"id\":\"76b54f8d-6442-4a49-8c8e-6d4d74458d4a\",\"type\":\"Label\"},{\"attributes\":{},\"id\":\"77501c0a-84bc-4b25-8a87-8acb50fc18bc\",\"type\":\"LinearScale\"},{\"attributes\":{\"callback\":null,\"end\":60000,\"start\":5000},\"id\":\"f5f83fc6-076e-44ca-93b6-905c1ad00f6f\",\"type\":\"Range1d\"},{\"attributes\":{},\"id\":\"ce36fd40-14f2-4484-aed6-a8edcbc0ec87\",\"type\":\"LinearScale\"},{\"attributes\":{\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"9ea8e51d-d6bc-45a3-812e-2c29b33bc3b1\",\"type\":\"DatetimeTicker\"},\"visible\":false},\"id\":\"eb3446a8-d7db-4f47-b54d-8ab3177e016a\",\"type\":\"Grid\"},{\"attributes\":{\"axis_label\":\"Period\",\"axis_label_text_font_style\":\"bold\",\"formatter\":{\"id\":\"6b227ac6-c7ee-4815-869b-7a854283c6a5\",\"type\":\"DatetimeTickFormatter\"},\"major_label_orientation\":0.7853981633974483,\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"9ea8e51d-d6bc-45a3-812e-2c29b33bc3b1\",\"type\":\"DatetimeTicker\"}},\"id\":\"5e8b9af2-458b-4ac5-8f78-591f76ddf04e\",\"type\":\"DatetimeAxis\"},{\"attributes\":{\"num_minor_ticks\":5,\"tickers\":[{\"id\":\"0f3cbf36-0cd2-4187-aff0-b7088c6462b5\",\"type\":\"AdaptiveTicker\"},{\"id\":\"59555760-9a60-4cbd-aec2-d69c383e213d\",\"type\":\"AdaptiveTicker\"},{\"id\":\"e0d14a0e-87f0-4a0e-9b48-51cd2ed7ed93\",\"type\":\"AdaptiveTicker\"},{\"id\":\"d8b34216-c420-4142-afbe-c4390004250f\",\"type\":\"DaysTicker\"},{\"id\":\"a2de0a2b-bace-407f-8503-40c82bb98d7b\",\"type\":\"DaysTicker\"},{\"id\":\"1283f7ca-a7db-4db5-a00e-25e9fc03ff16\",\"type\":\"DaysTicker\"},{\"id\":\"6c0e8fb3-d463-437c-905e-f72658e6b629\",\"type\":\"DaysTicker\"},{\"id\":\"3121359a-f597-4b54-bce5-f7e27e03bcc6\",\"type\":\"MonthsTicker\"},{\"id\":\"f17e40ca-aec4-4a8b-8660-a17ab20195c3\",\"type\":\"MonthsTicker\"},{\"id\":\"b0f20661-905f-4657-b588-e94baaef1cf2\",\"type\":\"MonthsTicker\"},{\"id\":\"a4c085be-d11b-4d57-873c-fb33fc537bea\",\"type\":\"MonthsTicker\"},{\"id\":\"ea7e45c7-7769-4587-84ec-4c53c61ec487\",\"type\":\"YearsTicker\"}]},\"id\":\"9ea8e51d-d6bc-45a3-812e-2c29b33bc3b1\",\"type\":\"DatetimeTicker\"},{\"attributes\":{\"axis_label\":\"Import and export (mln EUR)\",\"axis_label_text_font_style\":\"bold\",\"formatter\":{\"id\":\"cb051505-1102-457e-bb4c-d3e6446bdca2\",\"type\":\"BasicTickFormatter\"},\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"1a4120dc-b485-4439-8f85-169f6399abe0\",\"type\":\"BasicTicker\"}},\"id\":\"151a95e0-7a95-45c8-8734-155c37bc15f6\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"1a4120dc-b485-4439-8f85-169f6399abe0\",\"type\":\"BasicTicker\"},{\"attributes\":{\"dimension\":1,\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"1a4120dc-b485-4439-8f85-169f6399abe0\",\"type\":\"BasicTicker\"}},\"id\":\"b8982026-b426-4397-9166-94a3eade4cae\",\"type\":\"Grid\"},{\"attributes\":{\"fill_color\":{\"value\":\"lightsteelblue\"},\"line_color\":{\"value\":\"lightsteelblue\"},\"top\":{\"field\":\"balance\"},\"width\":{\"value\":5000000000},\"x\":{\"field\":\"quarter_begin\"}},\"id\":\"ea6e23ae-6501-4be0-98a8-7883dfc212ca\",\"type\":\"VBar\"},{\"attributes\":{\"plot\":null,\"size\":4},\"id\":\"e3e61432-b4b1-4b0e-b2b5-b19b66f71054\",\"type\":\"VeeHead\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":{\"value\":0.5},\"fill_color\":{\"value\":\"lightgrey\"},\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":{\"value\":1.0},\"line_color\":{\"value\":\"black\"},\"line_dash\":[4,4],\"line_width\":{\"value\":2},\"plot\":null,\"render_mode\":\"css\",\"right_units\":\"screen\",\"top_units\":\"screen\"},\"id\":\"670d106d-bec5-417e-be3d-6c2df50b25c3\",\"type\":\"BoxAnnotation\"},{\"attributes\":{},\"id\":\"2e900b6e-f740-44b5-ae82-07f85c2a9712\",\"type\":\"PanTool\"},{\"attributes\":{},\"id\":\"58082cc6-9258-4b75-a13d-cf27c19f1156\",\"type\":\"BasicTicker\"},{\"attributes\":{},\"id\":\"efeb3494-2a45-4e8c-a581-0f030ba6fcb0\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"overlay\":{\"id\":\"670d106d-bec5-417e-be3d-6c2df50b25c3\",\"type\":\"BoxAnnotation\"}},\"id\":\"fcda189d-e05c-4236-adc1-0f263a6e04fa\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"14ea270c-5397-43b4-80c6-77487ad74a2b\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"7dbf536c-ab07-40d4-8d26-eb90ac13fb10\",\"type\":\"ResetTool\"},{\"attributes\":{},\"id\":\"1c1b7635-470b-49cb-9d98-c5f85f613999\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"a019b383-2518-4a32-aa79-d6c385f4bddb\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"fill_alpha\":{\"value\":0.1},\"fill_color\":{\"value\":\"#1f77b4\"},\"line_alpha\":{\"value\":0.1},\"line_color\":{\"value\":\"#1f77b4\"},\"top\":{\"field\":\"balance\"},\"width\":{\"value\":5000000000},\"x\":{\"field\":\"quarter_begin\"}},\"id\":\"270da803-0f21-49d0-8973-1d8d4fffb470\",\"type\":\"VBar\"},{\"attributes\":{\"data_source\":{\"id\":\"5b75f5bc-750d-4e85-b427-a6c33abcfc0d\",\"type\":\"ColumnDataSource\"},\"glyph\":{\"id\":\"ea6e23ae-6501-4be0-98a8-7883dfc212ca\",\"type\":\"VBar\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"270da803-0f21-49d0-8973-1d8d4fffb470\",\"type\":\"VBar\"},\"selection_glyph\":null,\"view\":{\"id\":\"4e0f1b24-967d-450f-9bba-af65fb8c7655\",\"type\":\"CDSView\"},\"y_range_name\":\"foo\"},\"id\":\"d74f3dff-396e-4495-abf7-c8e1b06720f8\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"source\":{\"id\":\"5b75f5bc-750d-4e85-b427-a6c33abcfc0d\",\"type\":\"ColumnDataSource\"}},\"id\":\"4e0f1b24-967d-450f-9bba-af65fb8c7655\",\"type\":\"CDSView\"},{\"attributes\":{\"days\":[1,8,15,22]},\"id\":\"1283f7ca-a7db-4db5-a00e-25e9fc03ff16\",\"type\":\"DaysTicker\"},{\"attributes\":{},\"id\":\"cb051505-1102-457e-bb4c-d3e6446bdca2\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"data_source\":{\"id\":\"5b75f5bc-750d-4e85-b427-a6c33abcfc0d\",\"type\":\"ColumnDataSource\"},\"glyph\":{\"id\":\"b13c4374-49eb-4b7c-aa99-5c6e46de70f6\",\"type\":\"Step\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"ff712933-e2f1-4ecf-b4c4-423ed47c09f9\",\"type\":\"Step\"},\"selection_glyph\":null,\"view\":{\"id\":\"f5c79662-9e93-4273-8a57-82f773f71b9c\",\"type\":\"CDSView\"}},\"id\":\"31987c72-b325-44bc-8ec7-91cd3b6eccb0\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"mantissas\":[1,2,5],\"max_interval\":500.0,\"num_minor_ticks\":0},\"id\":\"0f3cbf36-0cd2-4187-aff0-b7088c6462b5\",\"type\":\"AdaptiveTicker\"},{\"attributes\":{\"base\":60,\"mantissas\":[1,2,5,10,15,20,30],\"max_interval\":1800000.0,\"min_interval\":1000.0,\"num_minor_ticks\":0},\"id\":\"59555760-9a60-4cbd-aec2-d69c383e213d\",\"type\":\"AdaptiveTicker\"},{\"attributes\":{\"callback\":null,\"column_names\":[\"year\",\"quarter\",\"export\",\"import\",\"balance\",\"quarter_begin\",\"period\",\"import_EUR\",\"export_EUR\",\"balance_EUR\",\"index\"],\"data\":{\"balance\":[-1539,-1694,-1191,-1131,-535,-784,-809,-814,-1038,-1278,-1685,-2298,-3046,-3830,-3565,-4952,-4368,-5681,-6241,-6246,-1405,-1364,-1835,-2111,-1950,-2336,-3144,-3510,-2510,-4090,-3290,-3405,-2811,-2219,-1204,-1897,-1054,541,284,-106,-780,-834,-396,-1245,1564,322,-719,1046,1184,1711,-432,472,696,769,524,-563,-1567,-620,-1319,-1673],\"balance_EUR\":[\"-1,539 mln EUR\",\"-1,694 mln EUR\",\"-1,191 mln EUR\",\"-1,131 mln EUR\",\"-535 mln EUR\",\"-784 mln EUR\",\"-809 mln EUR\",\"-814 mln EUR\",\"-1,038 mln EUR\",\"-1,278 mln EUR\",\"-1,685 mln EUR\",\"-2,298 mln EUR\",\"-3,046 mln EUR\",\"-3,830 mln EUR\",\"-3,565 mln EUR\",\"-4,952 mln EUR\",\"-4,368 mln EUR\",\"-5,681 mln EUR\",\"-6,241 mln EUR\",\"-6,246 mln EUR\",\"-1,405 mln EUR\",\"-1,364 mln EUR\",\"-1,835 mln EUR\",\"-2,111 mln EUR\",\"-1,950 mln EUR\",\"-2,336 mln EUR\",\"-3,144 mln EUR\",\"-3,510 mln EUR\",\"-2,510 mln EUR\",\"-4,090 mln EUR\",\"-3,290 mln EUR\",\"-3,405 mln EUR\",\"-2,811 mln EUR\",\"-2,219 mln EUR\",\"-1,204 mln EUR\",\"-1,897 mln EUR\",\"-1,054 mln EUR\",\"541 mln EUR\",\"284 mln EUR\",\"-106 mln EUR\",\"-780 mln EUR\",\"-834 mln EUR\",\"-396 mln EUR\",\"-1,245 mln EUR\",\"1,564 mln EUR\",\"322 mln EUR\",\"-719 mln EUR\",\"1,046 mln EUR\",\"1,184 mln EUR\",\"1,711 mln EUR\",\"-432 mln EUR\",\"472 mln EUR\",\"696 mln EUR\",\"769 mln EUR\",\"524 mln EUR\",\"-563 mln EUR\",\"-1,567 mln EUR\",\"-620 mln EUR\",\"-1,319 mln EUR\",\"-1,673 mln EUR\"],\"export\":[12317,15395,15479,16434,16099,17524,18147,20384,20381,21277,21858,24097,23325,24015,24990,26918,28618,29910,29858,25347,22885,23205,24567,25790,27161,29570,30075,31275,32759,33445,32954,33301,34622,34469,35266,36667,35693,36659,37932,38812,38708,39176,39717,41018,42509,42938,42078,44599,43130,44861,43132,46325,49684,50145,49418,52643,52441,53378,52480,56838],\"export_EUR\":[\"12,317 mln EUR\",\"15,395 mln EUR\",\"15,479 mln EUR\",\"16,434 mln EUR\",\"16,099 mln EUR\",\"17,524 mln EUR\",\"18,147 mln EUR\",\"20,384 mln EUR\",\"20,381 mln EUR\",\"21,277 mln EUR\",\"21,858 mln EUR\",\"24,097 mln EUR\",\"23,325 mln EUR\",\"24,015 mln EUR\",\"24,990 mln EUR\",\"26,918 mln EUR\",\"28,618 mln EUR\",\"29,910 mln EUR\",\"29,858 mln EUR\",\"25,347 mln EUR\",\"22,885 mln EUR\",\"23,205 mln EUR\",\"24,567 mln EUR\",\"25,790 mln EUR\",\"27,161 mln EUR\",\"29,570 mln EUR\",\"30,075 mln EUR\",\"31,275 mln EUR\",\"32,759 mln EUR\",\"33,445 mln EUR\",\"32,954 mln EUR\",\"33,301 mln EUR\",\"34,622 mln EUR\",\"34,469 mln EUR\",\"35,266 mln EUR\",\"36,667 mln EUR\",\"35,693 mln EUR\",\"36,659 mln EUR\",\"37,932 mln EUR\",\"38,812 mln EUR\",\"38,708 mln EUR\",\"39,176 mln EUR\",\"39,717 mln EUR\",\"41,018 mln EUR\",\"42,509 mln EUR\",\"42,938 mln EUR\",\"42,078 mln EUR\",\"44,599 mln EUR\",\"43,130 mln EUR\",\"44,861 mln EUR\",\"43,132 mln EUR\",\"46,325 mln EUR\",\"49,684 mln EUR\",\"50,145 mln EUR\",\"49,418 mln EUR\",\"52,643 mln EUR\",\"52,441 mln EUR\",\"53,378 mln EUR\",\"52,480 mln EUR\",\"56,838 mln EUR\"],\"import\":[13856,17089,16670,17565,16634,18308,18956,21198,21419,22555,23543,26395,26371,27845,28555,31870,32986,35591,36099,31593,24290,24569,26402,27901,29111,31906,33219,34785,35269,37535,36244,36706,37433,36688,36470,38564,36747,36118,37648,38918,39488,40010,40113,42263,40945,42616,42797,43553,41946,43150,43564,45853,48988,49376,48894,53206,54008,53998,53799,58511],\"import_EUR\":[\"13,856 mln EUR\",\"17,089 mln EUR\",\"16,670 mln EUR\",\"17,565 mln EUR\",\"16,634 mln EUR\",\"18,308 mln EUR\",\"18,956 mln EUR\",\"21,198 mln EUR\",\"21,419 mln EUR\",\"22,555 mln EUR\",\"23,543 mln EUR\",\"26,395 mln EUR\",\"26,371 mln EUR\",\"27,845 mln EUR\",\"28,555 mln EUR\",\"31,870 mln EUR\",\"32,986 mln EUR\",\"35,591 mln EUR\",\"36,099 mln EUR\",\"31,593 mln EUR\",\"24,290 mln EUR\",\"24,569 mln EUR\",\"26,402 mln EUR\",\"27,901 mln EUR\",\"29,111 mln EUR\",\"31,906 mln EUR\",\"33,219 mln EUR\",\"34,785 mln EUR\",\"35,269 mln EUR\",\"37,535 mln EUR\",\"36,244 mln EUR\",\"36,706 mln EUR\",\"37,433 mln EUR\",\"36,688 mln EUR\",\"36,470 mln EUR\",\"38,564 mln EUR\",\"36,747 mln EUR\",\"36,118 mln EUR\",\"37,648 mln EUR\",\"38,918 mln EUR\",\"39,488 mln EUR\",\"40,010 mln EUR\",\"40,113 mln EUR\",\"42,263 mln EUR\",\"40,945 mln EUR\",\"42,616 mln EUR\",\"42,797 mln EUR\",\"43,553 mln EUR\",\"41,946 mln EUR\",\"43,150 mln EUR\",\"43,564 mln EUR\",\"45,853 mln EUR\",\"48,988 mln EUR\",\"49,376 mln EUR\",\"48,894 mln EUR\",\"53,206 mln EUR\",\"54,008 mln EUR\",\"53,998 mln EUR\",\"53,799 mln EUR\",\"58,511 mln EUR\"],\"index\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59],\"period\":[\"2004Q1\",\"2004Q2\",\"2004Q3\",\"2004Q4\",\"2005Q1\",\"2005Q2\",\"2005Q3\",\"2005Q4\",\"2006Q1\",\"2006Q2\",\"2006Q3\",\"2006Q4\",\"2007Q1\",\"2007Q2\",\"2007Q3\",\"2007Q4\",\"2008Q1\",\"2008Q2\",\"2008Q3\",\"2008Q4\",\"2009Q1\",\"2009Q2\",\"2009Q3\",\"2009Q4\",\"2010Q1\",\"2010Q2\",\"2010Q3\",\"2010Q4\",\"2011Q1\",\"2011Q2\",\"2011Q3\",\"2011Q4\",\"2012Q1\",\"2012Q2\",\"2012Q3\",\"2012Q4\",\"2013Q1\",\"2013Q2\",\"2013Q3\",\"2013Q4\",\"2014Q1\",\"2014Q2\",\"2014Q3\",\"2014Q4\",\"2015Q1\",\"2015Q2\",\"2015Q3\",\"2015Q4\",\"2016Q1\",\"2016Q2\",\"2016Q3\",\"2016Q4\",\"2017Q1\",\"2017Q2\",\"2017Q3\",\"2017Q4\",\"2018Q1\",\"2018Q2\",\"2018Q3\",\"2018Q4\"],\"quarter\":[1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4],\"quarter_begin\":{\"__ndarray__\":\"AAAAV9c5b0IAAICta3RvQgAAAAQAr29CAAAAJjnqb0IAAAAkuRJwQgAAgOmwL3BCAADAFPtMcEIAAMCll2pwQgAAwDY0iHBCAABA/CulcEIAAIAndsJwQgAAgLgS4HBCAACASa/9cEIAAAAPpxpxQgAAQDrxN3FCAABAy41VcUIAAEBcKnNxQgAAgId0kHFCAADAsr6tcUIAAMBDW8txQgAAwNT36HFCAABAmu8FckIAAIDFOSNyQgAAgFbWQHJCAACA53JeckIAAACtantyQgAAQNi0mHJCAABAaVG2ckIAAED67dNyQgAAwL/l8HJCAAAA6y8Oc0IAAAB8zCtzQgAAAA1pSXNCAABAOLNmc0IAAIBj/YNzQgAAgPSZoXNCAACAhTa/c0IAAABLLtxzQgAAQHZ4+XNCAABABxUXdEIAAECYsTR0QgAAwF2pUXRCAAAAifNudEIAAAAakIx0QgAAAKssqnRCAACAcCTHdEIAAMCbbuR0QgAAwCwLAnVCAADAvacfdUIAAADp8Tx1QgAAQBQ8WnVCAABApdh3dUIAAEA2dZV1QgAAwPtssnVCAAAAJ7fPdUIAAAC4U+11QgAAAEnwCnZCAACADugndkIAAMA5MkV2QgAAwMrOYnZC\",\"dtype\":\"float64\",\"shape\":[60]},\"year\":[2004,2004,2004,2004,2005,2005,2005,2005,2006,2006,2006,2006,2007,2007,2007,2007,2008,2008,2008,2008,2009,2009,2009,2009,2010,2010,2010,2010,2011,2011,2011,2011,2012,2012,2012,2012,2013,2013,2013,2013,2014,2014,2014,2014,2015,2015,2015,2015,2016,2016,2016,2016,2017,2017,2017,2017,2018,2018,2018,2018]}},\"id\":\"5b75f5bc-750d-4e85-b427-a6c33abcfc0d\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"base\":24,\"mantissas\":[1,2,4,6,8,12],\"max_interval\":43200000.0,\"min_interval\":3600000.0,\"num_minor_ticks\":0},\"id\":\"e0d14a0e-87f0-4a0e-9b48-51cd2ed7ed93\",\"type\":\"AdaptiveTicker\"},{\"attributes\":{\"days\":[1,15]},\"id\":\"6c0e8fb3-d463-437c-905e-f72658e6b629\",\"type\":\"DaysTicker\"},{\"attributes\":{\"days\":[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]},\"id\":\"d8b34216-c420-4142-afbe-c4390004250f\",\"type\":\"DaysTicker\"},{\"attributes\":{\"days\":[1,4,7,10,13,16,19,22,25,28]},\"id\":\"a2de0a2b-bace-407f-8503-40c82bb98d7b\",\"type\":\"DaysTicker\"},{\"attributes\":{\"months\":[0,1,2,3,4,5,6,7,8,9,10,11]},\"id\":\"3121359a-f597-4b54-bce5-f7e27e03bcc6\",\"type\":\"MonthsTicker\"},{\"attributes\":{\"months\":[0,2,4,6,8,10]},\"id\":\"f17e40ca-aec4-4a8b-8660-a17ab20195c3\",\"type\":\"MonthsTicker\"},{\"attributes\":{\"months\":[0,4,8]},\"id\":\"b0f20661-905f-4657-b588-e94baaef1cf2\",\"type\":\"MonthsTicker\"},{\"attributes\":{\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"text\":\"2008Q3 - Financial crisis hits EU\",\"text_font_size\":{\"value\":\"10pt\"},\"x\":1216552800000,\"y\":42300},\"id\":\"0b2d58af-4d69-42f8-a21a-f5ba34d59a8a\",\"type\":\"Label\"},{\"attributes\":{\"months\":[0,6]},\"id\":\"a4c085be-d11b-4d57-873c-fb33fc537bea\",\"type\":\"MonthsTicker\"},{\"attributes\":{},\"id\":\"ea7e45c7-7769-4587-84ec-4c53c61ec487\",\"type\":\"YearsTicker\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"a3cf87a6-1b9b-4378-9962-a732ca88b62d\",\"type\":\"LegendItem\"},{\"id\":\"a4db887d-cbe5-4309-bd6e-48a62294aaba\",\"type\":\"LegendItem\"},{\"id\":\"0f36a614-32f7-43f7-9963-178ac7d1f594\",\"type\":\"LegendItem\"}],\"location\":\"top_left\",\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"83a55ade-c341-4aff-89b9-18b16e756af7\",\"type\":\"Legend\"},{\"attributes\":{\"label\":{\"value\":\"Trade balance\"},\"renderers\":[{\"id\":\"d74f3dff-396e-4495-abf7-c8e1b06720f8\",\"type\":\"GlyphRenderer\"}]},\"id\":\"a3cf87a6-1b9b-4378-9962-a732ca88b62d\",\"type\":\"LegendItem\"},{\"attributes\":{\"line_color\":{\"value\":\"blue\"},\"line_width\":{\"value\":2},\"x\":{\"field\":\"quarter_begin\"},\"y\":{\"field\":\"import\"}},\"id\":\"b13c4374-49eb-4b7c-aa99-5c6e46de70f6\",\"type\":\"Step\"},{\"attributes\":{\"label\":{\"value\":\"Import\"},\"renderers\":[{\"id\":\"31987c72-b325-44bc-8ec7-91cd3b6eccb0\",\"type\":\"GlyphRenderer\"}]},\"id\":\"a4db887d-cbe5-4309-bd6e-48a62294aaba\",\"type\":\"LegendItem\"},{\"attributes\":{\"source\":{\"id\":\"5b75f5bc-750d-4e85-b427-a6c33abcfc0d\",\"type\":\"ColumnDataSource\"}},\"id\":\"f5c79662-9e93-4273-8a57-82f773f71b9c\",\"type\":\"CDSView\"},{\"attributes\":{\"line_alpha\":{\"value\":0.1},\"line_color\":{\"value\":\"#1f77b4\"},\"line_width\":{\"value\":2},\"x\":{\"field\":\"quarter_begin\"},\"y\":{\"field\":\"import\"}},\"id\":\"ff712933-e2f1-4ecf-b4c4-423ed47c09f9\",\"type\":\"Step\"},{\"attributes\":{\"line_alpha\":{\"value\":0.1},\"line_color\":{\"value\":\"#1f77b4\"},\"line_width\":{\"value\":2},\"x\":{\"field\":\"quarter_begin\"},\"y\":{\"field\":\"export\"}},\"id\":\"b0365f78-5548-4375-884e-4327ff91115a\",\"type\":\"Step\"},{\"attributes\":{\"plot\":null,\"size\":4},\"id\":\"7a053a3b-7f90-4f57-b0d1-74a7aabb9ffb\",\"type\":\"VeeHead\"},{\"attributes\":{\"end\":{\"id\":\"e3e61432-b4b1-4b0e-b2b5-b19b66f71054\",\"type\":\"VeeHead\"},\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"source\":null,\"start\":null,\"x_end\":{\"value\":1218751200000},\"x_start\":{\"value\":1236552800000},\"y_end\":{\"value\":37500},\"y_start\":{\"value\":42000}},\"id\":\"c1479399-0858-447b-9ce7-37e1c108862b\",\"type\":\"Arrow\"},{\"attributes\":{\"line_color\":{\"value\":\"green\"},\"line_width\":{\"value\":2},\"x\":{\"field\":\"quarter_begin\"},\"y\":{\"field\":\"export\"}},\"id\":\"4556262b-0a43-4b86-9008-52147f4a6113\",\"type\":\"Step\"},{\"attributes\":{\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"text\":\"Most of the time trade balance is still negative.\",\"text_alpha\":{\"value\":0.8},\"text_font_size\":{\"value\":\"10pt\"},\"x\":1236552800000,\"y\":14500},\"id\":\"8073075d-f53a-4b80-9feb-14fcd93cede5\",\"type\":\"Label\"},{\"attributes\":{\"label\":{\"value\":\"Export\"},\"renderers\":[{\"id\":\"98cbad33-faec-4419-99b6-11e306449ad7\",\"type\":\"GlyphRenderer\"}]},\"id\":\"0f36a614-32f7-43f7-9963-178ac7d1f594\",\"type\":\"LegendItem\"},{\"attributes\":{\"source\":{\"id\":\"5b75f5bc-750d-4e85-b427-a6c33abcfc0d\",\"type\":\"ColumnDataSource\"}},\"id\":\"d96002df-88fe-45b5-be6a-c8879dae1b83\",\"type\":\"CDSView\"},{\"attributes\":{\"data_source\":{\"id\":\"5b75f5bc-750d-4e85-b427-a6c33abcfc0d\",\"type\":\"ColumnDataSource\"},\"glyph\":{\"id\":\"4556262b-0a43-4b86-9008-52147f4a6113\",\"type\":\"Step\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"b0365f78-5548-4375-884e-4327ff91115a\",\"type\":\"Step\"},\"selection_glyph\":null,\"view\":{\"id\":\"d96002df-88fe-45b5-be6a-c8879dae1b83\",\"type\":\"CDSView\"}},\"id\":\"98cbad33-faec-4419-99b6-11e306449ad7\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"text\":\"2004/05/01 - Poland joins EU\",\"text_font_size\":{\"value\":\"10pt\"},\"x\":1053362400000,\"y\":40300},\"id\":\"75ff37cd-17f0-4f61-8ade-1b1e6238d92b\",\"type\":\"Label\"},{\"attributes\":{\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"text\":\"Both import and export grew almost 5x since joining EU.\",\"text_alpha\":{\"value\":0.8},\"text_font_size\":{\"value\":\"10pt\"},\"x\":1236552800000,\"y\":16000},\"id\":\"2146f314-c00b-4445-8296-8817ffef692b\",\"type\":\"Label\"},{\"attributes\":{\"end\":{\"id\":\"7a053a3b-7f90-4f57-b0d1-74a7aabb9ffb\",\"type\":\"VeeHead\"},\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"source\":null,\"start\":null,\"x_end\":{\"value\":1083362400000},\"x_start\":{\"value\":1083362400000},\"y_end\":{\"value\":37500},\"y_start\":{\"value\":40000}},\"id\":\"4b201a95-dc23-4aa9-bbc2-d020a4cd0764\",\"type\":\"Arrow\"},{\"attributes\":{\"plot\":{\"id\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"text\":\"Click on legend item to hide/show plot.\",\"text_alpha\":{\"value\":0.5},\"text_font_size\":{\"value\":\"10pt\"},\"x\":1236552800000,\"y\":54500},\"id\":\"1e444b60-8708-4f83-8f42-7195c4e52144\",\"type\":\"Label\"},{\"attributes\":{\"callback\":null,\"tooltips\":[[\"Period\",\"@period\"],[\"Import\",\"@import_EUR\"],[\"Export\",\"@export_EUR\"],[\"Tradebalance\",\"@balance_EUR\"]]},\"id\":\"19500115-0b03-47f2-b463-4338cf58c462\",\"type\":\"HoverTool\"}],\"root_ids\":[\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\"]},\"title\":\"Bokeh Application\",\"version\":\"0.12.13\"}};\n",
       "  var render_items = [{\"docid\":\"c9a59949-a1ad-426f-af85-6c2a4962b5fb\",\"elementid\":\"1aa0fe10-a8af-4938-a07e-84cecd875634\",\"modelid\":\"a9b4fa8c-77f7-45da-86b8-59669ffeb11d\"}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        embed_document(root);\n",
       "        clearInterval(timer);\n",
       "      }\n",
       "      attempts++;\n",
       "      if (attempts > 100) {\n",
       "        console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\")\n",
       "        clearInterval(timer);\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "a9b4fa8c-77f7-45da-86b8-59669ffeb11d"
      }
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Create plot\n",
    "p = figure(plot_width=900,\n",
    "           plot_height=900,\n",
    "           title='Polish Trade Balance 2004-2018',\n",
    "           x_axis_label='Period',\n",
    "           y_axis_label='Import and export (mln EUR)',\n",
    "           x_axis_type='datetime',\n",
    "           y_range=(5000, 60000))\n",
    "p.extra_y_ranges = {\"foo\": Range1d(start=-7000, end=5000)}  # Needed to add right scale\n",
    "p.add_layout(LinearAxis(y_range_name=\"foo\",\n",
    "                        axis_label='Trade balance (mln EUR)',\n",
    "                        axis_label_text_font_style='bold'),\n",
    "             'right')  # Right scale\n",
    "p.title.align = 'center'\n",
    "p.title.text_font_size = '18pt'\n",
    "p.xaxis.axis_label_text_font_style = 'bold'\n",
    "p.yaxis.axis_label_text_font_style = 'bold'\n",
    "p.xgrid.visible = False  # Delete vertical grid\n",
    "p.vbar(x='quarter_begin',\n",
    "       bottom=0,\n",
    "       top='balance',\n",
    "       width=5000000000,  # milliseconds\n",
    "       y_range_name='foo',  # Use right scale instead of left\n",
    "       source=trade_balance_cds,\n",
    "       color='lightsteelblue',\n",
    "       legend=\"Trade balance\")\n",
    "p.step('quarter_begin',\n",
    "       'import',\n",
    "       source=trade_balance_cds,\n",
    "       line_width=2,\n",
    "       mode=\"before\",\n",
    "       color=\"blue\",\n",
    "       legend=\"Import\")\n",
    "p.step('quarter_begin',\n",
    "       'export',\n",
    "       source=trade_balance_cds,\n",
    "       line_width=2,\n",
    "       mode=\"before\",\n",
    "       color=\"green\",\n",
    "       legend=\"Export\")\n",
    "p.xaxis.major_label_orientation = np.pi / 4  # Flip x-axis labels\n",
    "hover = HoverTool(tooltips=[('Period', '@period'),\n",
    "                            ('Import', '@import_EUR'),\n",
    "                            ('Export', '@export_EUR'),\n",
    "                            ('Tradebalance', '@balance_EUR')])\n",
    "p.add_tools(hover)\n",
    "p.legend.location = \"top_left\"\n",
    "p.legend.click_policy = \"hide\"\n",
    "p.add_layout(Arrow(end=VeeHead(size=4),\n",
    "                   line_color=\"black\",\n",
    "                   x_start=1236552800000,  # Dates converted to milliseconds using online converter\n",
    "                   y_start=42000,\n",
    "                   x_end=1218751200000,\n",
    "                   y_end=37500))\n",
    "p.add_layout(Arrow(end=VeeHead(size=4),\n",
    "                   line_color=\"black\",\n",
    "                   x_start=1083362400000,\n",
    "                   y_start=40000,\n",
    "                   x_end=1083362400000,\n",
    "                   y_end=37500))\n",
    "p.add_layout(Label(x=1216552800000,\n",
    "                   y=42300,\n",
    "                   text='2008Q3 - Financial crisis hits EU',\n",
    "                   text_font_size='10pt'))\n",
    "p.add_layout(Label(x=1053362400000,\n",
    "                   y=40300,\n",
    "                   text='2004/05/01 - Poland joins EU',\n",
    "                   text_font_size='10pt'))\n",
    "p.add_layout(Label(x=1236552800000,\n",
    "                   y=56000,\n",
    "                   text='Hover over bar chart to get more details.',\n",
    "                   text_font_size='10pt',\n",
    "                   text_alpha=0.5))  # Add transparency\n",
    "p.add_layout(Label(x=1236552800000,\n",
    "                   y=54500,\n",
    "                   text='Click on legend item to hide/show plot.',\n",
    "                   text_font_size='10pt',\n",
    "                   text_alpha=0.5))\n",
    "p.add_layout(Label(x=1236552800000,\n",
    "                   y=16000,\n",
    "                   text='Both import and export grew almost 5x since joining EU.',\n",
    "                   text_font_size='10pt',\n",
    "                   text_alpha=0.8))\n",
    "p.add_layout(Label(x=1236552800000,\n",
    "                   y=14500,\n",
    "                   text='Most of the time trade balance is still negative.',\n",
    "                   text_font_size='10pt',\n",
    "                   text_alpha=0.8))\n",
    "output_notebook()\n",
    "show(p)\n"
   ]
  },
  {
   "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}