Eurostat/Venture Capital.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Importing the libraries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from pandasdmx import Request"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from bokeh.io import output_notebook, show\n",
    "from bokeh.plotting import figure\n",
    "from bokeh.models import ColumnDataSource, LabelSet"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    <div class=\"bk-root\">\n",
       "        <a href=\"http://bokeh.pydata.org\" target=\"_blank\" class=\"bk-logo bk-logo-small bk-logo-notebook\"></a>\n",
       "        <span id=\"816d6bd2-e9ec-4c0c-98c0-6da849ff6fdb\">Loading BokehJS ...</span>\n",
       "    </div>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "\n",
       "(function(global) {\n",
       "  function now() {\n",
       "    return new Date();\n",
       "  }\n",
       "\n",
       "  var force = true;\n",
       "\n",
       "  if (typeof (window._bokeh_onload_callbacks) === \"undefined\" || force === true) {\n",
       "    window._bokeh_onload_callbacks = [];\n",
       "    window._bokeh_is_loading = undefined;\n",
       "  }\n",
       "\n",
       "\n",
       "  \n",
       "  if (typeof (window._bokeh_timeout) === \"undefined\" || force === true) {\n",
       "    window._bokeh_timeout = Date.now() + 5000;\n",
       "    window._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",
       "    if (window.Bokeh !== undefined) {\n",
       "      var el = document.getElementById(\"816d6bd2-e9ec-4c0c-98c0-6da849ff6fdb\");\n",
       "      el.textContent = \"BokehJS \" + Bokeh.version + \" successfully loaded.\";\n",
       "    } else if (Date.now() < window._bokeh_timeout) {\n",
       "      setTimeout(display_loaded, 100)\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function run_callbacks() {\n",
       "    window._bokeh_onload_callbacks.forEach(function(callback) { callback() });\n",
       "    delete window._bokeh_onload_callbacks\n",
       "    console.info(\"Bokeh: all callbacks have finished\");\n",
       "  }\n",
       "\n",
       "  function load_libs(js_urls, callback) {\n",
       "    window._bokeh_onload_callbacks.push(callback);\n",
       "    if (window._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",
       "    window._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",
       "        window._bokeh_is_loading--;\n",
       "        if (window._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(\"816d6bd2-e9ec-4c0c-98c0-6da849ff6fdb\");\n",
       "  if (element == null) {\n",
       "    console.log(\"Bokeh: ERROR: autoload.js configured with elementid '816d6bd2-e9ec-4c0c-98c0-6da849ff6fdb' 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.5.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.5.min.js\"];\n",
       "\n",
       "  var inline_js = [\n",
       "    function(Bokeh) {\n",
       "      Bokeh.set_log_level(\"info\");\n",
       "    },\n",
       "    \n",
       "    function(Bokeh) {\n",
       "      \n",
       "    },\n",
       "    \n",
       "    function(Bokeh) {\n",
       "      \n",
       "      document.getElementById(\"816d6bd2-e9ec-4c0c-98c0-6da849ff6fdb\").textContent = \"BokehJS is loading...\";\n",
       "    },\n",
       "    function(Bokeh) {\n",
       "      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-0.12.5.min.css\");\n",
       "      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-0.12.5.min.css\");\n",
       "      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.5.min.css\");\n",
       "      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.5.min.css\");\n",
       "    }\n",
       "  ];\n",
       "\n",
       "  function run_inline_js() {\n",
       "    \n",
       "    if ((window.Bokeh !== undefined) || (force === true)) {\n",
       "      for (var i = 0; i < inline_js.length; i++) {\n",
       "        inline_js[i](window.Bokeh);\n",
       "      }if (force === true) {\n",
       "        display_loaded();\n",
       "      }} else if (Date.now() < window._bokeh_timeout) {\n",
       "      setTimeout(run_inline_js, 100);\n",
       "    } else if (!window._bokeh_failed_load) {\n",
       "      console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n",
       "      window._bokeh_failed_load = true;\n",
       "    } else if (force !== true) {\n",
       "      var cell = $(document.getElementById(\"816d6bd2-e9ec-4c0c-98c0-6da849ff6fdb\")).parents('.cell').data().cell;\n",
       "      cell.output_area.append_execute_result(NB_LOAD_WARNING)\n",
       "    }\n",
       "\n",
       "  }\n",
       "\n",
       "  if (window._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",
       "}(this));"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "output_notebook()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Connecting to the webservice"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "estat = Request('ESTAT')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Downloading dataflow definitions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dflow = estat.dataflow()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Defining functions"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Data structure"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def dsd_resp(id):\n",
    "    \"\"\"\n",
    "    The function takes a dataflow identifier and requests from the Eurostat SDMX api the dataflow's datastructure, datastructure id and datastructure response.\n",
    "    \"\"\"    \n",
    "    # Defining the data set's dataflow based on the data set id.\n",
    "    df = dflow.dataflow[id]\n",
    "    \n",
    "    # Printing the table's name\n",
    "    print(\"The table's name:\")\n",
    "    print(dflow.write().dataflow.loc[id][0])\n",
    "    \n",
    "    # Acquiring the dataflow's datastructure id\n",
    "    dsd_id = df.structure.id\n",
    "    \n",
    "    # Requesting for the dataflow's datastructure\n",
    "    dsd_resp = estat.get(resource_type = 'datastructure', resource_id = dsd_id)\n",
    "    \n",
    "    # Requesting the dataflow's datastructure\n",
    "    dsd = dsd_resp.datastructure[dsd_id]\n",
    "    \n",
    "    return dsd_resp, dsd_id, dsd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Datastructure attributes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def dsd_att(dsd):\n",
    "    \"\"\"The function takes a table datastructure definition and prints its measure, dimension and attribute lists.\"\"\"\n",
    "    # Measures\n",
    "    print(\"Measures:\")\n",
    "    print(dsd.measures.aslist())\n",
    "    \n",
    "    # Dimensions\n",
    "    print(\"\\nDimensions:\")\n",
    "    print(dsd.dimensions.aslist())\n",
    "    \n",
    "    # Attributes\n",
    "    print(\"\\nAttributes:\")\n",
    "    print(dsd.attributes.aslist())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Selecting the tables"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Listing the tables from the 'High-tech industry and knowledge-intensive services (**htec**)' database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dataflow</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>htec_cis3</th>\n",
       "      <td>Innovation in high-tech sectors in SMEs (CIS3)...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_cis4</th>\n",
       "      <td>Innovation in high-tech sectors (CIS 2004), EU...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_cis5</th>\n",
       "      <td>Innovation in high-tech sectors (CIS 2006), EU...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_cis6</th>\n",
       "      <td>Innovation in high-tech sectors (CIS 2008, CIS...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_eco_ent</th>\n",
       "      <td>Enterprises in high-tech sectors by NACE Rev.1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_eco_ent2</th>\n",
       "      <td>Enterprises in high-tech sectors by NACE Rev.2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_eco_sbs</th>\n",
       "      <td>Economic data in high-tech sectors by NACE Rev...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_eco_sbs2</th>\n",
       "      <td>Economic data in high-tech sectors by NACE Rev...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_nat</th>\n",
       "      <td>Employment in technology and knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_nat2</th>\n",
       "      <td>Employment in technology and knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_nisced</th>\n",
       "      <td>Employment in technology and knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_nisced2</th>\n",
       "      <td>Employment in technology and knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_nisco</th>\n",
       "      <td>Employment in technology and knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_nisco2</th>\n",
       "      <td>Employment in technology and knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_reg</th>\n",
       "      <td>Employment in technology and knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_reg2</th>\n",
       "      <td>Employment in technology and knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_risced</th>\n",
       "      <td>Employment in technology and knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_risced2</th>\n",
       "      <td>Employment in technology and knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_risco</th>\n",
       "      <td>Employment in technology and knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_risco2</th>\n",
       "      <td>Employment in technology and knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_sbs</th>\n",
       "      <td>Employment statistics on high-tech industries ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_emp_sbs2</th>\n",
       "      <td>Employment statistics on high-tech industries ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_kia_emp</th>\n",
       "      <td>Annual data on employment in knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_kia_emp2</th>\n",
       "      <td>Annual data on employment in knowledge-intensi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_si_exp4</th>\n",
       "      <td>High-tech exports - Exports of high technology...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_sti_exp</th>\n",
       "      <td>Business enterprise R&amp;D expenditure in high-te...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_sti_exp2</th>\n",
       "      <td>Business enterprise R&amp;D expenditure in high-te...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_sti_pers</th>\n",
       "      <td>Business enterprise R&amp;D personnel in high-tech...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_sti_pers2</th>\n",
       "      <td>Business enterprise R&amp;D personnel in high-tech...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_trd_group4</th>\n",
       "      <td>High-tech trade by high-tech group of products...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_trd_tot4</th>\n",
       "      <td>Total high-tech trade in million euro and as a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_vci_stage1</th>\n",
       "      <td>Venture capital investment by aggregated stage...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>htec_vci_stage2</th>\n",
       "      <td>Venture capital investment by detailed stage o...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                               name\n",
       "dataflow                                                           \n",
       "htec_cis3         Innovation in high-tech sectors in SMEs (CIS3)...\n",
       "htec_cis4         Innovation in high-tech sectors (CIS 2004), EU...\n",
       "htec_cis5         Innovation in high-tech sectors (CIS 2006), EU...\n",
       "htec_cis6         Innovation in high-tech sectors (CIS 2008, CIS...\n",
       "htec_eco_ent      Enterprises in high-tech sectors by NACE Rev.1...\n",
       "htec_eco_ent2     Enterprises in high-tech sectors by NACE Rev.2...\n",
       "htec_eco_sbs      Economic data in high-tech sectors by NACE Rev...\n",
       "htec_eco_sbs2     Economic data in high-tech sectors by NACE Rev...\n",
       "htec_emp_nat      Employment in technology and knowledge-intensi...\n",
       "htec_emp_nat2     Employment in technology and knowledge-intensi...\n",
       "htec_emp_nisced   Employment in technology and knowledge-intensi...\n",
       "htec_emp_nisced2  Employment in technology and knowledge-intensi...\n",
       "htec_emp_nisco    Employment in technology and knowledge-intensi...\n",
       "htec_emp_nisco2   Employment in technology and knowledge-intensi...\n",
       "htec_emp_reg      Employment in technology and knowledge-intensi...\n",
       "htec_emp_reg2     Employment in technology and knowledge-intensi...\n",
       "htec_emp_risced   Employment in technology and knowledge-intensi...\n",
       "htec_emp_risced2  Employment in technology and knowledge-intensi...\n",
       "htec_emp_risco    Employment in technology and knowledge-intensi...\n",
       "htec_emp_risco2   Employment in technology and knowledge-intensi...\n",
       "htec_emp_sbs      Employment statistics on high-tech industries ...\n",
       "htec_emp_sbs2     Employment statistics on high-tech industries ...\n",
       "htec_kia_emp      Annual data on employment in knowledge-intensi...\n",
       "htec_kia_emp2     Annual data on employment in knowledge-intensi...\n",
       "htec_si_exp4      High-tech exports - Exports of high technology...\n",
       "htec_sti_exp      Business enterprise R&D expenditure in high-te...\n",
       "htec_sti_exp2     Business enterprise R&D expenditure in high-te...\n",
       "htec_sti_pers     Business enterprise R&D personnel in high-tech...\n",
       "htec_sti_pers2    Business enterprise R&D personnel in high-tech...\n",
       "htec_trd_group4   High-tech trade by high-tech group of products...\n",
       "htec_trd_tot4     Total high-tech trade in million euro and as a...\n",
       "htec_vci_stage1   Venture capital investment by aggregated stage...\n",
       "htec_vci_stage2   Venture capital investment by detailed stage o..."
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dflow.write().dataflow[dflow.write().dataflow.index.str.startswith('htec') == True]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### The tables I am going to analyze"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "id1 = 'htec_sti_exp2'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Business enterprise R&D expenditure in high-tech sectors - NACE Rev. 2'"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dflow.write().dataflow.loc[id1][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "id2 = 'htec_vci_stage2'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Venture capital investment by detailed stage of development (from 2007, source: EVCA)'"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dflow.write().dataflow.loc[id2][0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Venture capital data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Getting the table's dataflow definition and datastructure"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The table's name:\n",
      "Venture capital investment by detailed stage of development (from 2007, source: EVCA)\n"
     ]
    }
   ],
   "source": [
    "dsd_resp2, dsd_id2, dsd2 = dsd_resp(id2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Downloading the table's datastructure definition"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Measures:\n",
      "[PrimaryMeasure | OBS_VALUE]\n",
      "\n",
      "Dimensions:\n",
      "[Dimension | FREQ, Dimension | EXPEND, Dimension | UNIT, Dimension | GEO, TimeDimension | TIME_PERIOD]\n",
      "\n",
      "Attributes:\n",
      "[DataAttribute | OBS_FLAG, DataAttribute | OBS_STATUS]\n"
     ]
    }
   ],
   "source": [
    "dsd_att(dsd2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Codelist:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>dim_or_attr</th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">FREQ</th>\n",
       "      <th>FREQ</th>\n",
       "      <td>D</td>\n",
       "      <td>FREQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>D</td>\n",
       "      <td>Annual</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D</th>\n",
       "      <td>D</td>\n",
       "      <td>Daily</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>H</th>\n",
       "      <td>D</td>\n",
       "      <td>Half-year</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M</th>\n",
       "      <td>D</td>\n",
       "      <td>Monthly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q</th>\n",
       "      <td>D</td>\n",
       "      <td>Quarterly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>S</th>\n",
       "      <td>D</td>\n",
       "      <td>Semi-annual</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>W</th>\n",
       "      <td>D</td>\n",
       "      <td>Weekly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"10\" valign=\"top\">EXPEND</th>\n",
       "      <th>EXPEND</th>\n",
       "      <td>D</td>\n",
       "      <td>EXPEND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INV</th>\n",
       "      <td>D</td>\n",
       "      <td>Investment</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INV_BUY</th>\n",
       "      <td>D</td>\n",
       "      <td>Investment for buyout</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INV_GROW</th>\n",
       "      <td>D</td>\n",
       "      <td>Investment in growth stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INV_REPL</th>\n",
       "      <td>D</td>\n",
       "      <td>Investment for replacement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INV_RESC</th>\n",
       "      <td>D</td>\n",
       "      <td>Investment for rescue/turnaround</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INV_VEN</th>\n",
       "      <td>D</td>\n",
       "      <td>Venture capital investment (seed, start-up and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INV_VEN_LATE</th>\n",
       "      <td>D</td>\n",
       "      <td>Investment in later stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INV_VEN_SEED</th>\n",
       "      <td>D</td>\n",
       "      <td>Investment in seed stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INV_VEN_STAR</th>\n",
       "      <td>D</td>\n",
       "      <td>Investment in start-up stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">UNIT</th>\n",
       "      <th>UNIT</th>\n",
       "      <td>D</td>\n",
       "      <td>UNIT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIO_EUR</th>\n",
       "      <td>D</td>\n",
       "      <td>Million euro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NR_COMP</th>\n",
       "      <td>D</td>\n",
       "      <td>Number of companies</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PC_GDP</th>\n",
       "      <td>D</td>\n",
       "      <td>Percentage of gross domestic product (GDP)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"22\" valign=\"top\">GEO</th>\n",
       "      <th>GEO</th>\n",
       "      <td>D</td>\n",
       "      <td>GEO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AT</th>\n",
       "      <td>D</td>\n",
       "      <td>Austria</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BE</th>\n",
       "      <td>D</td>\n",
       "      <td>Belgium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BG</th>\n",
       "      <td>D</td>\n",
       "      <td>Bulgaria</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CH</th>\n",
       "      <td>D</td>\n",
       "      <td>Switzerland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CZ</th>\n",
       "      <td>D</td>\n",
       "      <td>Czech Republic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DE</th>\n",
       "      <td>D</td>\n",
       "      <td>Germany (until 1990 former territory of the FRG)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DK</th>\n",
       "      <td>D</td>\n",
       "      <td>Denmark</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FI</th>\n",
       "      <td>D</td>\n",
       "      <td>Finland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FR</th>\n",
       "      <td>D</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HU</th>\n",
       "      <td>D</td>\n",
       "      <td>Hungary</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IE</th>\n",
       "      <td>D</td>\n",
       "      <td>Ireland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IT</th>\n",
       "      <td>D</td>\n",
       "      <td>Italy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LU</th>\n",
       "      <td>D</td>\n",
       "      <td>Luxembourg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NL</th>\n",
       "      <td>D</td>\n",
       "      <td>Netherlands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NO</th>\n",
       "      <td>D</td>\n",
       "      <td>Norway</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PL</th>\n",
       "      <td>D</td>\n",
       "      <td>Poland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PT</th>\n",
       "      <td>D</td>\n",
       "      <td>Portugal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RO</th>\n",
       "      <td>D</td>\n",
       "      <td>Romania</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SE</th>\n",
       "      <td>D</td>\n",
       "      <td>Sweden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UK</th>\n",
       "      <td>D</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"13\" valign=\"top\">OBS_FLAG</th>\n",
       "      <th>OBS_FLAG</th>\n",
       "      <td>A</td>\n",
       "      <td>Observation flag.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>b</th>\n",
       "      <td>A</td>\n",
       "      <td>break in time series</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>c</th>\n",
       "      <td>A</td>\n",
       "      <td>confidential</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>d</th>\n",
       "      <td>A</td>\n",
       "      <td>definition differs, see metadata</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>e</th>\n",
       "      <td>A</td>\n",
       "      <td>estimated</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>f</th>\n",
       "      <td>A</td>\n",
       "      <td>forecast</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>i</th>\n",
       "      <td>A</td>\n",
       "      <td>see metadata (phased out)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>n</th>\n",
       "      <td>A</td>\n",
       "      <td>not significant</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>p</th>\n",
       "      <td>A</td>\n",
       "      <td>provisional</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>r</th>\n",
       "      <td>A</td>\n",
       "      <td>revised</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>s</th>\n",
       "      <td>A</td>\n",
       "      <td>Eurostat estimate (phased out)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>u</th>\n",
       "      <td>A</td>\n",
       "      <td>low reliability</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>z</th>\n",
       "      <td>A</td>\n",
       "      <td>not applicable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">OBS_STATUS</th>\n",
       "      <th>OBS_STATUS</th>\n",
       "      <td>A</td>\n",
       "      <td>Observation status.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-</th>\n",
       "      <td>A</td>\n",
       "      <td>not applicable or real zero or zero by default</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A</td>\n",
       "      <td>less than half of the unit used</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>na</th>\n",
       "      <td>A</td>\n",
       "      <td>not available</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>63 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        dim_or_attr  \\\n",
       "FREQ       FREQ                   D   \n",
       "           A                      D   \n",
       "           D                      D   \n",
       "           H                      D   \n",
       "           M                      D   \n",
       "           Q                      D   \n",
       "           S                      D   \n",
       "           W                      D   \n",
       "EXPEND     EXPEND                 D   \n",
       "           INV                    D   \n",
       "           INV_BUY                D   \n",
       "           INV_GROW               D   \n",
       "           INV_REPL               D   \n",
       "           INV_RESC               D   \n",
       "           INV_VEN                D   \n",
       "           INV_VEN_LATE           D   \n",
       "           INV_VEN_SEED           D   \n",
       "           INV_VEN_STAR           D   \n",
       "UNIT       UNIT                   D   \n",
       "           MIO_EUR                D   \n",
       "           NR_COMP                D   \n",
       "           PC_GDP                 D   \n",
       "GEO        GEO                    D   \n",
       "           AT                     D   \n",
       "           BE                     D   \n",
       "           BG                     D   \n",
       "           CH                     D   \n",
       "           CZ                     D   \n",
       "           DE                     D   \n",
       "           DK                     D   \n",
       "...                             ...   \n",
       "           FI                     D   \n",
       "           FR                     D   \n",
       "           HU                     D   \n",
       "           IE                     D   \n",
       "           IT                     D   \n",
       "           LU                     D   \n",
       "           NL                     D   \n",
       "           NO                     D   \n",
       "           PL                     D   \n",
       "           PT                     D   \n",
       "           RO                     D   \n",
       "           SE                     D   \n",
       "           UK                     D   \n",
       "OBS_FLAG   OBS_FLAG               A   \n",
       "           b                      A   \n",
       "           c                      A   \n",
       "           d                      A   \n",
       "           e                      A   \n",
       "           f                      A   \n",
       "           i                      A   \n",
       "           n                      A   \n",
       "           p                      A   \n",
       "           r                      A   \n",
       "           s                      A   \n",
       "           u                      A   \n",
       "           z                      A   \n",
       "OBS_STATUS OBS_STATUS             A   \n",
       "           -                      A   \n",
       "           0                      A   \n",
       "           na                     A   \n",
       "\n",
       "                                                                      name  \n",
       "FREQ       FREQ                                                       FREQ  \n",
       "           A                                                        Annual  \n",
       "           D                                                         Daily  \n",
       "           H                                                     Half-year  \n",
       "           M                                                       Monthly  \n",
       "           Q                                                     Quarterly  \n",
       "           S                                                   Semi-annual  \n",
       "           W                                                        Weekly  \n",
       "EXPEND     EXPEND                                                   EXPEND  \n",
       "           INV                                                  Investment  \n",
       "           INV_BUY                                   Investment for buyout  \n",
       "           INV_GROW                             Investment in growth stage  \n",
       "           INV_REPL                             Investment for replacement  \n",
       "           INV_RESC                       Investment for rescue/turnaround  \n",
       "           INV_VEN       Venture capital investment (seed, start-up and...  \n",
       "           INV_VEN_LATE                          Investment in later stage  \n",
       "           INV_VEN_SEED                           Investment in seed stage  \n",
       "           INV_VEN_STAR                       Investment in start-up stage  \n",
       "UNIT       UNIT                                                       UNIT  \n",
       "           MIO_EUR                                            Million euro  \n",
       "           NR_COMP                                     Number of companies  \n",
       "           PC_GDP               Percentage of gross domestic product (GDP)  \n",
       "GEO        GEO                                                         GEO  \n",
       "           AT                                                      Austria  \n",
       "           BE                                                      Belgium  \n",
       "           BG                                                     Bulgaria  \n",
       "           CH                                                  Switzerland  \n",
       "           CZ                                               Czech Republic  \n",
       "           DE             Germany (until 1990 former territory of the FRG)  \n",
       "           DK                                                      Denmark  \n",
       "...                                                                    ...  \n",
       "           FI                                                      Finland  \n",
       "           FR                                                       France  \n",
       "           HU                                                      Hungary  \n",
       "           IE                                                      Ireland  \n",
       "           IT                                                        Italy  \n",
       "           LU                                                   Luxembourg  \n",
       "           NL                                                  Netherlands  \n",
       "           NO                                                       Norway  \n",
       "           PL                                                       Poland  \n",
       "           PT                                                     Portugal  \n",
       "           RO                                                      Romania  \n",
       "           SE                                                       Sweden  \n",
       "           UK                                               United Kingdom  \n",
       "OBS_FLAG   OBS_FLAG                                      Observation flag.  \n",
       "           b                                          break in time series  \n",
       "           c                                                  confidential  \n",
       "           d                              definition differs, see metadata  \n",
       "           e                                                     estimated  \n",
       "           f                                                      forecast  \n",
       "           i                                     see metadata (phased out)  \n",
       "           n                                               not significant  \n",
       "           p                                                   provisional  \n",
       "           r                                                       revised  \n",
       "           s                                Eurostat estimate (phased out)  \n",
       "           u                                               low reliability  \n",
       "           z                                                not applicable  \n",
       "OBS_STATUS OBS_STATUS                                  Observation status.  \n",
       "           -                not applicable or real zero or zero by default  \n",
       "           0                               less than half of the unit used  \n",
       "           na                                                not available  \n",
       "\n",
       "[63 rows x 2 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dsd_resp2.write().codelist.loc[:,:] # [['EXPEND', 'UNIT'],:]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Requesting the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dresp2 = estat.get(resource_type = 'data',\n",
    "                   resource_id = id2,\n",
    "                   params = {'references': None,\n",
    "                             #'startPeriod': '2014',\n",
    "                             #'endPeriod': '2014'\n",
    "                            })"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dat2 = dresp2.data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'TIME_PERIOD'"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat2.dim_at_obs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "621"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ser2 = list(dat2.series)\n",
    "len(ser2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "SeriesKey(UNIT='MIO_EUR', EXPEND='INV', GEO='DE', FREQ='A')"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ser2[5].key"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'MIO_EUR', 'NR_COMP', 'PC_GDP'}"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set(s.key.UNIT for s in dat2.series)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Writing the data into DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th>UNIT</th>\n",
       "      <th colspan=\"9\" halign=\"left\">MIO_EUR</th>\n",
       "      <th colspan=\"9\" halign=\"left\">PC_GDP</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EXPEND</th>\n",
       "      <th>INV</th>\n",
       "      <th>INV_BUY</th>\n",
       "      <th>INV_GROW</th>\n",
       "      <th>INV_REPL</th>\n",
       "      <th>INV_RESC</th>\n",
       "      <th>INV_VEN</th>\n",
       "      <th>INV_VEN_LATE</th>\n",
       "      <th>INV_VEN_SEED</th>\n",
       "      <th>INV_VEN_STAR</th>\n",
       "      <th>INV</th>\n",
       "      <th>INV_BUY</th>\n",
       "      <th>INV_GROW</th>\n",
       "      <th>INV_REPL</th>\n",
       "      <th>INV_RESC</th>\n",
       "      <th>INV_VEN</th>\n",
       "      <th>INV_VEN_LATE</th>\n",
       "      <th>INV_VEN_SEED</th>\n",
       "      <th>INV_VEN_STAR</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GEO</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>AT</th>\n",
       "      <td>109.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.032</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BE</th>\n",
       "      <td>722.0</td>\n",
       "      <td>562.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>0.176</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BG</th>\n",
       "      <td>16.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.036</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CH</th>\n",
       "      <td>640.0</td>\n",
       "      <td>197.0</td>\n",
       "      <td>107.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>283.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>134.0</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>CZ</th>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DE</th>\n",
       "      <td>5996.0</td>\n",
       "      <td>4515.0</td>\n",
       "      <td>554.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>757.0</td>\n",
       "      <td>330.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>383.0</td>\n",
       "      <td>0.198</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DK</th>\n",
       "      <td>1162.0</td>\n",
       "      <td>832.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>290.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>230.0</td>\n",
       "      <td>0.437</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EL</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ES</th>\n",
       "      <td>1051.0</td>\n",
       "      <td>667.0</td>\n",
       "      <td>152.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.097</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FI</th>\n",
       "      <td>512.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.247</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.047</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FR</th>\n",
       "      <td>9451.0</td>\n",
       "      <td>6848.0</td>\n",
       "      <td>1743.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>744.0</td>\n",
       "      <td>364.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>370.0</td>\n",
       "      <td>0.433</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HU</th>\n",
       "      <td>118.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IE</th>\n",
       "      <td>161.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>0.075</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.041</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IT</th>\n",
       "      <td>1160.0</td>\n",
       "      <td>974.0</td>\n",
       "      <td>123.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.071</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LU</th>\n",
       "      <td>74.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.141</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.079</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NL</th>\n",
       "      <td>1708.0</td>\n",
       "      <td>1031.0</td>\n",
       "      <td>388.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>0.252</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.032</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NO</th>\n",
       "      <td>1165.0</td>\n",
       "      <td>730.0</td>\n",
       "      <td>344.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>0.333</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PL</th>\n",
       "      <td>802.0</td>\n",
       "      <td>653.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.188</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PT</th>\n",
       "      <td>150.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>0.084</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.039</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RO</th>\n",
       "      <td>50.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.031</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SE</th>\n",
       "      <td>1722.0</td>\n",
       "      <td>1429.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>0.388</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UK</th>\n",
       "      <td>20521.0</td>\n",
       "      <td>17382.0</td>\n",
       "      <td>2157.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>833.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>310.0</td>\n",
       "      <td>0.799</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.032</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "UNIT    MIO_EUR                                                           \\\n",
       "EXPEND      INV  INV_BUY INV_GROW INV_REPL INV_RESC INV_VEN INV_VEN_LATE   \n",
       "GEO                                                                        \n",
       "AT        109.0     27.0     54.0      0.0      0.0    27.0          5.0   \n",
       "BE        722.0    562.0     68.0     18.0     11.0    63.0         30.0   \n",
       "BG         16.0     11.0      5.0      0.0      0.0     1.0          0.0   \n",
       "CH        640.0    197.0    107.0     27.0     26.0   283.0        143.0   \n",
       "CZ         13.0      0.0      9.0      0.0      0.0     4.0          1.0   \n",
       "DE       5996.0   4515.0    554.0    165.0      6.0   757.0        330.0   \n",
       "DK       1162.0    832.0     35.0      5.0      0.0   290.0         53.0   \n",
       "EL          0.0      0.0      0.0      0.0      0.0     0.0          0.0   \n",
       "ES       1051.0    667.0    152.0     81.0     45.0   105.0         40.0   \n",
       "FI        512.0    371.0     40.0      2.0      1.0    98.0         25.0   \n",
       "FR       9451.0   6848.0   1743.0    112.0      3.0   744.0        364.0   \n",
       "HU        118.0     94.0      0.0      0.0      0.0    24.0          3.0   \n",
       "IE        161.0     64.0      9.0      0.0      0.0    89.0         38.0   \n",
       "IT       1160.0    974.0    123.0     30.0      0.0    33.0         13.0   \n",
       "LU         74.0     32.0      0.0      0.0      0.0    41.0          7.0   \n",
       "NL       1708.0   1031.0    388.0     46.0     23.0   220.0         64.0   \n",
       "NO       1165.0    730.0    344.0      0.0      0.0    92.0         53.0   \n",
       "PL        802.0    653.0    115.0      5.0      0.0    29.0         15.0   \n",
       "PT        150.0     40.0     27.0     13.0      0.0    70.0         18.0   \n",
       "RO         50.0     46.0      2.0      0.0      0.0     1.0          1.0   \n",
       "SE       1722.0   1429.0    106.0     37.0      0.0   150.0         57.0   \n",
       "UK      20521.0  17382.0   2157.0     67.0     82.0   833.0        512.0   \n",
       "\n",
       "UNIT                             PC_GDP                                     \\\n",
       "EXPEND INV_VEN_SEED INV_VEN_STAR    INV INV_BUY INV_GROW INV_REPL INV_RESC   \n",
       "GEO                                                                          \n",
       "AT             10.0         13.0  0.032     NaN      NaN      NaN      NaN   \n",
       "BE              0.0         33.0  0.176     NaN      NaN      NaN      NaN   \n",
       "BG              0.0          1.0  0.036     NaN      NaN      NaN      NaN   \n",
       "CH              5.0        134.0    NaN     NaN      NaN      NaN      NaN   \n",
       "CZ              1.0          1.0  0.008     NaN      NaN      NaN      NaN   \n",
       "DE             44.0        383.0  0.198     NaN      NaN      NaN      NaN   \n",
       "DK              8.0        230.0  0.437     NaN      NaN      NaN      NaN   \n",
       "EL              0.0          0.0  0.000     NaN      NaN      NaN      NaN   \n",
       "ES              3.0         62.0  0.097     NaN      NaN      NaN      NaN   \n",
       "FI              9.0         64.0  0.247     NaN      NaN      NaN      NaN   \n",
       "FR             11.0        370.0  0.433     NaN      NaN      NaN      NaN   \n",
       "HU              3.0         18.0  0.109     NaN      NaN      NaN      NaN   \n",
       "IE              0.0         50.0  0.075     NaN      NaN      NaN      NaN   \n",
       "IT              2.0         18.0  0.071     NaN      NaN      NaN      NaN   \n",
       "LU              0.0         34.0  0.141     NaN      NaN      NaN      NaN   \n",
       "NL              8.0        147.0  0.252     NaN      NaN      NaN      NaN   \n",
       "NO              2.0         37.0  0.333     NaN      NaN      NaN      NaN   \n",
       "PL              3.0         12.0  0.188     NaN      NaN      NaN      NaN   \n",
       "PT              5.0         47.0  0.084     NaN      NaN      NaN      NaN   \n",
       "RO              0.0          0.0  0.031     NaN      NaN      NaN      NaN   \n",
       "SE              0.0         93.0  0.388     NaN      NaN      NaN      NaN   \n",
       "UK             10.0        310.0  0.799     NaN      NaN      NaN      NaN   \n",
       "\n",
       "UNIT                                                   \n",
       "EXPEND INV_VEN INV_VEN_LATE INV_VEN_SEED INV_VEN_STAR  \n",
       "GEO                                                    \n",
       "AT       0.008          NaN          NaN          NaN  \n",
       "BE       0.015          NaN          NaN          NaN  \n",
       "BG       0.002          NaN          NaN          NaN  \n",
       "CH         NaN          NaN          NaN          NaN  \n",
       "CZ       0.002          NaN          NaN          NaN  \n",
       "DE       0.025          NaN          NaN          NaN  \n",
       "DK       0.109          NaN          NaN          NaN  \n",
       "EL       0.000          NaN          NaN          NaN  \n",
       "ES       0.010          NaN          NaN          NaN  \n",
       "FI       0.047          NaN          NaN          NaN  \n",
       "FR       0.034          NaN          NaN          NaN  \n",
       "HU       0.022          NaN          NaN          NaN  \n",
       "IE       0.041          NaN          NaN          NaN  \n",
       "IT       0.002          NaN          NaN          NaN  \n",
       "LU       0.079          NaN          NaN          NaN  \n",
       "NL       0.032          NaN          NaN          NaN  \n",
       "NO       0.026          NaN          NaN          NaN  \n",
       "PL       0.007          NaN          NaN          NaN  \n",
       "PT       0.039          NaN          NaN          NaN  \n",
       "RO       0.001          NaN          NaN          NaN  \n",
       "SE       0.034          NaN          NaN          NaN  \n",
       "UK       0.032          NaN          NaN          NaN  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "iter2 = (s for s in dat2.series if (s.key.GEO in ['EU15']) == False)\n",
    "tab2 = dresp2.write(iter2)\n",
    "tab2 = tab2.stack('GEO')\n",
    "tab2.columns = tab2.columns.droplevel(['FREQ']) # Dropping 'FREQ' and 'UNIT' levels\n",
    "tab2.swaplevel('UNIT', 'EXPEND', axis = 1)\n",
    "tab2 = tab2.loc['2015', ['PC_GDP', 'MIO_EUR']]\n",
    "# tab2.dropna(axis = 0, how = 'any', inplace = True)\n",
    "tab2.index = tab2.index.droplevel(0) # Dropping the 'TIME_PERIOD' axis\n",
    "tab2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "    <div class=\"bk-root\">\n",
       "        <div class=\"bk-plotdiv\" id=\"76741007-8d61-4ef6-ba78-6aedbe3e8a9a\"></div>\n",
       "    </div>\n",
       "<script type=\"text/javascript\">\n",
       "  \n",
       "  (function(global) {\n",
       "    function now() {\n",
       "      return new Date();\n",
       "    }\n",
       "  \n",
       "    var force = false;\n",
       "  \n",
       "    if (typeof (window._bokeh_onload_callbacks) === \"undefined\" || force === true) {\n",
       "      window._bokeh_onload_callbacks = [];\n",
       "      window._bokeh_is_loading = undefined;\n",
       "    }\n",
       "  \n",
       "  \n",
       "    \n",
       "    if (typeof (window._bokeh_timeout) === \"undefined\" || force === true) {\n",
       "      window._bokeh_timeout = Date.now() + 0;\n",
       "      window._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",
       "      if (window.Bokeh !== undefined) {\n",
       "        var el = document.getElementById(\"76741007-8d61-4ef6-ba78-6aedbe3e8a9a\");\n",
       "        el.textContent = \"BokehJS \" + Bokeh.version + \" successfully loaded.\";\n",
       "      } else if (Date.now() < window._bokeh_timeout) {\n",
       "        setTimeout(display_loaded, 100)\n",
       "      }\n",
       "    }\n",
       "  \n",
       "    function run_callbacks() {\n",
       "      window._bokeh_onload_callbacks.forEach(function(callback) { callback() });\n",
       "      delete window._bokeh_onload_callbacks\n",
       "      console.info(\"Bokeh: all callbacks have finished\");\n",
       "    }\n",
       "  \n",
       "    function load_libs(js_urls, callback) {\n",
       "      window._bokeh_onload_callbacks.push(callback);\n",
       "      if (window._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",
       "      window._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",
       "          window._bokeh_is_loading--;\n",
       "          if (window._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(\"76741007-8d61-4ef6-ba78-6aedbe3e8a9a\");\n",
       "    if (element == null) {\n",
       "      console.log(\"Bokeh: ERROR: autoload.js configured with elementid '76741007-8d61-4ef6-ba78-6aedbe3e8a9a' but no matching script tag was found. \")\n",
       "      return false;\n",
       "    }\n",
       "  \n",
       "    var js_urls = [];\n",
       "  \n",
       "    var inline_js = [\n",
       "      function(Bokeh) {\n",
       "        (function() {\n",
       "          var fn = function() {\n",
       "            var docs_json = {\"4c8856e3-0670-4993-8f08-3e51b599c638\":{\"roots\":{\"references\":[{\"attributes\":{\"plot\":{\"id\":\"47474cd4-9791-4287-9b73-53c7de772648\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"e1f46eec-dc25-442b-8cf3-4f212fced8ab\",\"type\":\"BasicTicker\"}},\"id\":\"2303764e-b1da-4aeb-8a40-5b76e6578d49\",\"type\":\"Grid\"},{\"attributes\":{\"axis_label\":\"Venture Capital R&D Investment\",\"formatter\":{\"id\":\"a7ca5361-3eb2-489a-98cb-228e12d9c7f4\",\"type\":\"BasicTickFormatter\"},\"plot\":{\"id\":\"47474cd4-9791-4287-9b73-53c7de772648\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"6af15d14-9e92-4353-afe4-e61b7f55dfc7\",\"type\":\"BasicTicker\"}},\"id\":\"aa9e9e02-9380-4ec6-b3d5-ef6e1da38440\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"6af15d14-9e92-4353-afe4-e61b7f55dfc7\",\"type\":\"BasicTicker\"},{\"attributes\":{\"below\":[{\"id\":\"866213d1-55a1-4111-a0c7-843987d0da21\",\"type\":\"LinearAxis\"}],\"left\":[{\"id\":\"aa9e9e02-9380-4ec6-b3d5-ef6e1da38440\",\"type\":\"LinearAxis\"}],\"renderers\":[{\"id\":\"866213d1-55a1-4111-a0c7-843987d0da21\",\"type\":\"LinearAxis\"},{\"id\":\"2303764e-b1da-4aeb-8a40-5b76e6578d49\",\"type\":\"Grid\"},{\"id\":\"aa9e9e02-9380-4ec6-b3d5-ef6e1da38440\",\"type\":\"LinearAxis\"},{\"id\":\"ae67349d-878d-4ade-ac16-1dc019f8934e\",\"type\":\"Grid\"},{\"id\":\"b6776f65-4752-40ee-8d77-ebd2458ddd62\",\"type\":\"BoxAnnotation\"},{\"id\":\"bbd6732f-a217-4324-a631-3a2dc3362667\",\"type\":\"GlyphRenderer\"},{\"id\":\"aa6908ac-81b7-4828-82ca-c333ea977c9d\",\"type\":\"LabelSet\"}],\"title\":{\"id\":\"d3a6ba2c-df88-4007-a01f-232ab7c44e7c\",\"type\":\"Title\"},\"tool_events\":{\"id\":\"5150bdfc-9ad0-4fc4-8a87-cc9b6ccb30c7\",\"type\":\"ToolEvents\"},\"toolbar\":{\"id\":\"1c2fc08b-8dfe-4461-9c7f-24a4a265e77b\",\"type\":\"Toolbar\"},\"x_range\":{\"id\":\"5bb4a0b0-5980-4886-9687-e2c6e25440fe\",\"type\":\"DataRange1d\"},\"y_range\":{\"id\":\"e7aaed01-89e5-471e-b5b2-dd090fc47c52\",\"type\":\"DataRange1d\"}},\"id\":\"47474cd4-9791-4287-9b73-53c7de772648\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{\"dimension\":1,\"plot\":{\"id\":\"47474cd4-9791-4287-9b73-53c7de772648\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"6af15d14-9e92-4353-afe4-e61b7f55dfc7\",\"type\":\"BasicTicker\"}},\"id\":\"ae67349d-878d-4ade-ac16-1dc019f8934e\",\"type\":\"Grid\"},{\"attributes\":{\"plot\":null,\"text\":\"\"},\"id\":\"d3a6ba2c-df88-4007-a01f-232ab7c44e7c\",\"type\":\"Title\"},{\"attributes\":{\"callback\":null,\"column_names\":[\"x\",\"y\",\"size\"],\"data\":{\"size\":[0.218,1.444,0.032,1.28,0.026,11.992,2.324,0.0,2.102,1.024,18.902,0.236,0.322,2.32,0.148,3.416,2.33,1.604,0.3,0.1,3.444,41.042],\"x\":{\"__ndarray__\":\"/Knx0k1ioD+6SQwCK4fGPzvfT42XbqI/AAAAAAAA+H/8qfHSTWKAP/LSTWIQWMk/K4cW2c732z8AAAAAAAAAAKJFtvP91Lg/BFYOLbKdzz+DwMqhRbbbP4GVQ4ts57s/MzMzMzMzsz+TGARWDi2yPz81XrpJDMI/VOOlm8Qg0D8dWmQ730/VP6rx0k1iEMg/Gy/dJAaBtT9YObTIdr6fP6JFtvP91Ng/xSCwcmiR6T8=\",\"dtype\":\"float64\",\"shape\":[22]},\"y\":{\"__ndarray__\":\"/Knx0k1igD+4HoXrUbiOP/yp8dJNYmA/AAAAAAAA+H/8qfHSTWJgP5qZmZmZmZk/gZVDi2znuz8AAAAAAAAAAHsUrkfheoQ/qvHSTWIQqD+cxCCwcmihP7pJDAIrh5Y/y6FFtvP9pD/8qfHSTWJgP9NNYhBYObQ//Knx0k1ioD85tMh2vp+aP3npJjEIrHw/K4cW2c73oz/8qfHSTWJQP5zEILByaKE//Knx0k1ioD8=\",\"dtype\":\"float64\",\"shape\":[22]}}},\"id\":\"f2f598da-10f2-4c98-b89d-5e83ef56a5c7\",\"type\":\"ColumnDataSource\"},{\"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\":\"b6776f65-4752-40ee-8d77-ebd2458ddd62\",\"type\":\"BoxAnnotation\"},{\"attributes\":{\"plot\":{\"id\":\"47474cd4-9791-4287-9b73-53c7de772648\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"4f8befb0-8c37-4ceb-bcf6-2f7b3e725097\",\"type\":\"PanTool\"},{\"attributes\":{\"plot\":{\"id\":\"47474cd4-9791-4287-9b73-53c7de772648\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"ab4f14dd-9204-443f-affa-409c174e7654\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"overlay\":{\"id\":\"b6776f65-4752-40ee-8d77-ebd2458ddd62\",\"type\":\"BoxAnnotation\"},\"plot\":{\"id\":\"47474cd4-9791-4287-9b73-53c7de772648\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"21dc9504-ea5f-4716-a965-be28c9efb7d4\",\"type\":\"BoxZoomTool\"},{\"attributes\":{\"plot\":{\"id\":\"47474cd4-9791-4287-9b73-53c7de772648\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"0067e60d-1689-4b9f-8b47-e23e33d0f0b1\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"1af19d90-aec0-48fc-90d6-aebb736a2ae8\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"plot\":{\"id\":\"47474cd4-9791-4287-9b73-53c7de772648\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"8c9bd3b5-9394-425a-971f-b2f400c2b8d1\",\"type\":\"ResetTool\"},{\"attributes\":{\"plot\":{\"id\":\"47474cd4-9791-4287-9b73-53c7de772648\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"fc4742f0-25e8-4991-8fbd-3f9c1861f20a\",\"type\":\"HelpTool\"},{\"attributes\":{\"callback\":null,\"column_names\":[\"names\",\"invest\",\"venture\"],\"data\":{\"invest\":{\"__ndarray__\":\"/Knx0k1ioD+6SQwCK4fGPzvfT42XbqI/AAAAAAAA+H/8qfHSTWKAP/LSTWIQWMk/K4cW2c732z8AAAAAAAAAAKJFtvP91Lg/BFYOLbKdzz+DwMqhRbbbP4GVQ4ts57s/MzMzMzMzsz+TGARWDi2yPz81XrpJDMI/VOOlm8Qg0D8dWmQ730/VP6rx0k1iEMg/Gy/dJAaBtT9YObTIdr6fP6JFtvP91Ng/xSCwcmiR6T8=\",\"dtype\":\"float64\",\"shape\":[22]},\"names\":[\"AT\",\"BE\",\"BG\",\"CH\",\"CZ\",\"DE\",\"DK\",\"EL\",\"ES\",\"FI\",\"FR\",\"HU\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PL\",\"PT\",\"RO\",\"SE\",\"UK\"],\"venture\":{\"__ndarray__\":\"/Knx0k1igD+4HoXrUbiOP/yp8dJNYmA/AAAAAAAA+H/8qfHSTWJgP5qZmZmZmZk/gZVDi2znuz8AAAAAAAAAAHsUrkfheoQ/qvHSTWIQqD+cxCCwcmihP7pJDAIrh5Y/y6FFtvP9pD/8qfHSTWJgP9NNYhBYObQ//Knx0k1ioD85tMh2vp+aP3npJjEIrHw/K4cW2c73oz/8qfHSTWJQP5zEILByaKE//Knx0k1ioD8=\",\"dtype\":\"float64\",\"shape\":[22]}}},\"id\":\"8e49d820-1aac-483e-8bc9-e1852e87fd53\",\"type\":\"ColumnDataSource\"},{\"attributes\":{},\"id\":\"a7ca5361-3eb2-489a-98cb-228e12d9c7f4\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"level\":\"glyph\",\"plot\":{\"id\":\"47474cd4-9791-4287-9b73-53c7de772648\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"source\":{\"id\":\"8e49d820-1aac-483e-8bc9-e1852e87fd53\",\"type\":\"ColumnDataSource\"},\"text\":{\"field\":\"names\"},\"x\":{\"field\":\"invest\"},\"y\":{\"field\":\"venture\"}},\"id\":\"aa6908ac-81b7-4828-82ca-c333ea977c9d\",\"type\":\"LabelSet\"},{\"attributes\":{\"fill_alpha\":{\"value\":0.6},\"fill_color\":{\"value\":\"blue\"},\"line_alpha\":{\"value\":0.6},\"line_color\":{\"value\":\"blue\"},\"size\":{\"field\":\"size\",\"units\":\"screen\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"6070f4d3-eb6b-4aba-8bb9-9a2744572106\",\"type\":\"Square\"},{\"attributes\":{\"fill_alpha\":{\"value\":0.1},\"fill_color\":{\"value\":\"#1f77b4\"},\"line_alpha\":{\"value\":0.1},\"line_color\":{\"value\":\"#1f77b4\"},\"size\":{\"field\":\"size\",\"units\":\"screen\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"2365f0f4-fd47-4fa6-8a81-fa580fafa71c\",\"type\":\"Square\"},{\"attributes\":{},\"id\":\"5150bdfc-9ad0-4fc4-8a87-cc9b6ccb30c7\",\"type\":\"ToolEvents\"},{\"attributes\":{\"axis_label\":\"Total R&D Investment\",\"formatter\":{\"id\":\"1af19d90-aec0-48fc-90d6-aebb736a2ae8\",\"type\":\"BasicTickFormatter\"},\"plot\":{\"id\":\"47474cd4-9791-4287-9b73-53c7de772648\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"e1f46eec-dc25-442b-8cf3-4f212fced8ab\",\"type\":\"BasicTicker\"}},\"id\":\"866213d1-55a1-4111-a0c7-843987d0da21\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"e1f46eec-dc25-442b-8cf3-4f212fced8ab\",\"type\":\"BasicTicker\"},{\"attributes\":{\"active_drag\":\"auto\",\"active_scroll\":\"auto\",\"active_tap\":\"auto\",\"tools\":[{\"id\":\"4f8befb0-8c37-4ceb-bcf6-2f7b3e725097\",\"type\":\"PanTool\"},{\"id\":\"ab4f14dd-9204-443f-affa-409c174e7654\",\"type\":\"WheelZoomTool\"},{\"id\":\"21dc9504-ea5f-4716-a965-be28c9efb7d4\",\"type\":\"BoxZoomTool\"},{\"id\":\"0067e60d-1689-4b9f-8b47-e23e33d0f0b1\",\"type\":\"SaveTool\"},{\"id\":\"8c9bd3b5-9394-425a-971f-b2f400c2b8d1\",\"type\":\"ResetTool\"},{\"id\":\"fc4742f0-25e8-4991-8fbd-3f9c1861f20a\",\"type\":\"HelpTool\"}]},\"id\":\"1c2fc08b-8dfe-4461-9c7f-24a4a265e77b\",\"type\":\"Toolbar\"},{\"attributes\":{\"callback\":null},\"id\":\"5bb4a0b0-5980-4886-9687-e2c6e25440fe\",\"type\":\"DataRange1d\"},{\"attributes\":{\"data_source\":{\"id\":\"f2f598da-10f2-4c98-b89d-5e83ef56a5c7\",\"type\":\"ColumnDataSource\"},\"glyph\":{\"id\":\"6070f4d3-eb6b-4aba-8bb9-9a2744572106\",\"type\":\"Square\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"2365f0f4-fd47-4fa6-8a81-fa580fafa71c\",\"type\":\"Square\"},\"selection_glyph\":null},\"id\":\"bbd6732f-a217-4324-a631-3a2dc3362667\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"callback\":null},\"id\":\"e7aaed01-89e5-471e-b5b2-dd090fc47c52\",\"type\":\"DataRange1d\"}],\"root_ids\":[\"47474cd4-9791-4287-9b73-53c7de772648\"]},\"title\":\"Bokeh Application\",\"version\":\"0.12.5\"}};\n",
       "            var render_items = [{\"docid\":\"4c8856e3-0670-4993-8f08-3e51b599c638\",\"elementid\":\"76741007-8d61-4ef6-ba78-6aedbe3e8a9a\",\"modelid\":\"47474cd4-9791-4287-9b73-53c7de772648\"}];\n",
       "            \n",
       "            Bokeh.embed.embed_items(docs_json, render_items);\n",
       "          };\n",
       "          if (document.readyState != \"loading\") fn();\n",
       "          else document.addEventListener(\"DOMContentLoaded\", fn);\n",
       "        })();\n",
       "      },\n",
       "      function(Bokeh) {\n",
       "      }\n",
       "    ];\n",
       "  \n",
       "    function run_inline_js() {\n",
       "      \n",
       "      if ((window.Bokeh !== undefined) || (force === true)) {\n",
       "        for (var i = 0; i < inline_js.length; i++) {\n",
       "          inline_js[i](window.Bokeh);\n",
       "        }if (force === true) {\n",
       "          display_loaded();\n",
       "        }} else if (Date.now() < window._bokeh_timeout) {\n",
       "        setTimeout(run_inline_js, 100);\n",
       "      } else if (!window._bokeh_failed_load) {\n",
       "        console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n",
       "        window._bokeh_failed_load = true;\n",
       "      } else if (force !== true) {\n",
       "        var cell = $(document.getElementById(\"76741007-8d61-4ef6-ba78-6aedbe3e8a9a\")).parents('.cell').data().cell;\n",
       "        cell.output_area.append_execute_result(NB_LOAD_WARNING)\n",
       "      }\n",
       "  \n",
       "    }\n",
       "  \n",
       "    if (window._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",
       "  }(this));\n",
       "</script>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "source = ColumnDataSource(data = dict(names = list(tab2.index), invest = tab2.loc[:,('PC_GDP','INV')], venture = tab2.loc[:,('PC_GDP','INV_VEN')]))\n",
    "\n",
    "p = figure(plot_width = 600, plot_height = 600)\n",
    "p.square(x = tab2.loc[:,('PC_GDP','INV')], y = tab2.loc[:,('PC_GDP','INV_VEN')], size = list(tab2.loc[:,('MIO_EUR','INV')] / 500), color = \"blue\", alpha = 0.6)\n",
    "\n",
    "p.xaxis.axis_label = 'Total R&D Investment'\n",
    "p.yaxis.axis_label = 'Venture Capital R&D Investment'\n",
    "\n",
    "labels = LabelSet(x = 'invest',\n",
    "                  y = 'venture',\n",
    "                  text = 'names',\n",
    "                  source = source,\n",
    "                  render_mode='canvas',\n",
    "                  level='glyph')\n",
    "\n",
    "p.add_layout(labels)\n",
    "show(p)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}