Eurostat/Business R&D expenditure.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=\"4a7c2b58-2129-4240-9990-807e61c56583\">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(\"4a7c2b58-2129-4240-9990-807e61c56583\");\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(\"4a7c2b58-2129-4240-9990-807e61c56583\");\n",
       "  if (element == null) {\n",
       "    console.log(\"Bokeh: ERROR: autoload.js configured with elementid '4a7c2b58-2129-4240-9990-807e61c56583' 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(\"4a7c2b58-2129-4240-9990-807e61c56583\").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(\"4a7c2b58-2129-4240-9990-807e61c56583\")).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": [
    "# Business R&D expenditure"
   ]
  },
  {
   "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",
      "Business enterprise R&D expenditure in high-tech sectors - NACE Rev. 2\n"
     ]
    }
   ],
   "source": [
    "dsd_resp1, dsd_id1, dsd1 = dsd_resp(id1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Datastructure measures, dimensions, attributes and codelist"
   ]
  },
  {
   "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 | UNIT, Dimension | NACE_R2, Dimension | GEO, TimeDimension | TIME_PERIOD]\n",
      "\n",
      "Attributes:\n",
      "[DataAttribute | OBS_FLAG, DataAttribute | OBS_STATUS]\n"
     ]
    }
   ],
   "source": [
    "dsd_att(dsd1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Codelist:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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></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=\"2\" 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 rowspan=\"8\" valign=\"top\">NACE_R2</th>\n",
       "      <th>NACE_R2</th>\n",
       "      <td>D</td>\n",
       "      <td>NACE_R2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C</th>\n",
       "      <td>D</td>\n",
       "      <td>Manufacturing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_HTC</th>\n",
       "      <td>D</td>\n",
       "      <td>High-technology manufacturing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_HTC_M</th>\n",
       "      <td>D</td>\n",
       "      <td>Medium high-technology manufacturing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_LTC</th>\n",
       "      <td>D</td>\n",
       "      <td>Low-technology manufacturing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_LTC_M</th>\n",
       "      <td>D</td>\n",
       "      <td>Medium low-technology manufacturing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G-N</th>\n",
       "      <td>D</td>\n",
       "      <td>Services of the business economy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TOTAL</th>\n",
       "      <td>D</td>\n",
       "      <td>Total - all NACE activities</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"26\" 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>CN_X_HK</th>\n",
       "      <td>D</td>\n",
       "      <td>China except Hong Kong</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CY</th>\n",
       "      <td>D</td>\n",
       "      <td>Cyprus</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>EE</th>\n",
       "      <td>D</td>\n",
       "      <td>Estonia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EL</th>\n",
       "      <td>D</td>\n",
       "      <td>Greece</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</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>RS</th>\n",
       "      <td>D</td>\n",
       "      <td>Serbia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RU</th>\n",
       "      <td>D</td>\n",
       "      <td>Russia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SE</th>\n",
       "      <td>D</td>\n",
       "      <td>Sweden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SI</th>\n",
       "      <td>D</td>\n",
       "      <td>Slovenia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SK</th>\n",
       "      <td>D</td>\n",
       "      <td>Slovakia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TR</th>\n",
       "      <td>D</td>\n",
       "      <td>Turkey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UK</th>\n",
       "      <td>D</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>US</th>\n",
       "      <td>D</td>\n",
       "      <td>United States</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>76 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",
       "UNIT       UNIT                 D   \n",
       "           MIO_EUR              D   \n",
       "NACE_R2    NACE_R2              D   \n",
       "           C                    D   \n",
       "           C_HTC                D   \n",
       "           C_HTC_M              D   \n",
       "           C_LTC                D   \n",
       "           C_LTC_M              D   \n",
       "           G-N                  D   \n",
       "           TOTAL                D   \n",
       "GEO        GEO                  D   \n",
       "           AT                   D   \n",
       "           BE                   D   \n",
       "           BG                   D   \n",
       "           CH                   D   \n",
       "           CN_X_HK              D   \n",
       "           CY                   D   \n",
       "           CZ                   D   \n",
       "           DE                   D   \n",
       "           DK                   D   \n",
       "           EE                   D   \n",
       "           EL                   D   \n",
       "...                           ...   \n",
       "           NL                   D   \n",
       "           NO                   D   \n",
       "           PL                   D   \n",
       "           PT                   D   \n",
       "           RO                   D   \n",
       "           RS                   D   \n",
       "           RU                   D   \n",
       "           SE                   D   \n",
       "           SI                   D   \n",
       "           SK                   D   \n",
       "           TR                   D   \n",
       "           UK                   D   \n",
       "           US                   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",
       "UNIT       UNIT                                                    UNIT  \n",
       "           MIO_EUR                                         Million euro  \n",
       "NACE_R2    NACE_R2                                              NACE_R2  \n",
       "           C                                              Manufacturing  \n",
       "           C_HTC                          High-technology manufacturing  \n",
       "           C_HTC_M                 Medium high-technology manufacturing  \n",
       "           C_LTC                           Low-technology manufacturing  \n",
       "           C_LTC_M                  Medium low-technology manufacturing  \n",
       "           G-N                         Services of the business economy  \n",
       "           TOTAL                            Total - all NACE activities  \n",
       "GEO        GEO                                                      GEO  \n",
       "           AT                                                   Austria  \n",
       "           BE                                                   Belgium  \n",
       "           BG                                                  Bulgaria  \n",
       "           CH                                               Switzerland  \n",
       "           CN_X_HK                               China except Hong Kong  \n",
       "           CY                                                    Cyprus  \n",
       "           CZ                                            Czech Republic  \n",
       "           DE          Germany (until 1990 former territory of the FRG)  \n",
       "           DK                                                   Denmark  \n",
       "           EE                                                   Estonia  \n",
       "           EL                                                    Greece  \n",
       "...                                                                 ...  \n",
       "           NL                                               Netherlands  \n",
       "           NO                                                    Norway  \n",
       "           PL                                                    Poland  \n",
       "           PT                                                  Portugal  \n",
       "           RO                                                   Romania  \n",
       "           RS                                                    Serbia  \n",
       "           RU                                                    Russia  \n",
       "           SE                                                    Sweden  \n",
       "           SI                                                  Slovenia  \n",
       "           SK                                                  Slovakia  \n",
       "           TR                                                    Turkey  \n",
       "           UK                                            United Kingdom  \n",
       "           US                                             United States  \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",
       "[76 rows x 2 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dsd_resp1.write().codelist"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Requesting the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dresp1 = estat.get(resource_type = 'data',\n",
    "                   resource_id = id1,\n",
    "                   params = {'references': None,\n",
    "                             'startPeriod': '2014',\n",
    "                             'endPeriod': '2014'\n",
    "                            })"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dat1 = dresp1.data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'TIME_PERIOD'"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat1.dim_at_obs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "280"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ser1 = list(dat1.series)\n",
    "len(ser1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "SeriesKey(UNIT='MIO_EUR', NACE_R2='C', GEO='CY', FREQ='A')"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ser1[5].key"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'AT',\n",
       " 'BE',\n",
       " 'BG',\n",
       " 'CH',\n",
       " 'CN_X_HK',\n",
       " 'CY',\n",
       " 'CZ',\n",
       " 'DE',\n",
       " 'DK',\n",
       " 'EE',\n",
       " 'EL',\n",
       " 'ES',\n",
       " 'EU28',\n",
       " 'FI',\n",
       " 'FR',\n",
       " 'HR',\n",
       " 'HU',\n",
       " 'IE',\n",
       " 'IS',\n",
       " 'IT',\n",
       " 'JP',\n",
       " 'KR',\n",
       " 'LT',\n",
       " 'LU',\n",
       " 'LV',\n",
       " 'ME',\n",
       " 'MT',\n",
       " 'NL',\n",
       " 'NO',\n",
       " 'PL',\n",
       " 'PT',\n",
       " 'RO',\n",
       " 'RS',\n",
       " 'RU',\n",
       " 'SE',\n",
       " 'SI',\n",
       " 'SK',\n",
       " 'TR',\n",
       " 'UK',\n",
       " 'US'}"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set(s.key.GEO for s in dat1.series)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Writing the data into DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "scrolled": false
   },
   "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>NACE_R2</th>\n",
       "      <th>C</th>\n",
       "      <th>C_HTC</th>\n",
       "      <th>C_HTC_M</th>\n",
       "      <th>C_LTC</th>\n",
       "      <th>C_LTC_M</th>\n",
       "      <th>G-N</th>\n",
       "      <th>TOTAL</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>CY</th>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CZ</th>\n",
       "      <td>976.0</td>\n",
       "      <td>107.0</td>\n",
       "      <td>609.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>223.0</td>\n",
       "      <td>688.0</td>\n",
       "      <td>1730.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DE</th>\n",
       "      <td>49482.0</td>\n",
       "      <td>11541.0</td>\n",
       "      <td>33187.0</td>\n",
       "      <td>1343.0</td>\n",
       "      <td>3401.0</td>\n",
       "      <td>7061.0</td>\n",
       "      <td>56997.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DK</th>\n",
       "      <td>2814.0</td>\n",
       "      <td>1526.0</td>\n",
       "      <td>956.0</td>\n",
       "      <td>236.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>4865.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ES</th>\n",
       "      <td>3096.0</td>\n",
       "      <td>748.0</td>\n",
       "      <td>1519.0</td>\n",
       "      <td>426.0</td>\n",
       "      <td>403.0</td>\n",
       "      <td>3212.0</td>\n",
       "      <td>6784.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FI</th>\n",
       "      <td>3126.0</td>\n",
       "      <td>1873.0</td>\n",
       "      <td>892.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>1133.0</td>\n",
       "      <td>4410.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HR</th>\n",
       "      <td>85.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>164.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HU</th>\n",
       "      <td>526.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>201.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>1022.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IT</th>\n",
       "      <td>8736.0</td>\n",
       "      <td>1822.0</td>\n",
       "      <td>5029.0</td>\n",
       "      <td>966.0</td>\n",
       "      <td>919.0</td>\n",
       "      <td>3163.0</td>\n",
       "      <td>12344.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LT</th>\n",
       "      <td>50.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>116.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MT</th>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NL</th>\n",
       "      <td>4389.0</td>\n",
       "      <td>942.0</td>\n",
       "      <td>2455.0</td>\n",
       "      <td>463.0</td>\n",
       "      <td>529.0</td>\n",
       "      <td>2627.0</td>\n",
       "      <td>7433.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PL</th>\n",
       "      <td>821.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>399.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>891.0</td>\n",
       "      <td>1800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SI</th>\n",
       "      <td>455.0</td>\n",
       "      <td>204.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>224.0</td>\n",
       "      <td>689.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TR</th>\n",
       "      <td>1562.0</td>\n",
       "      <td>166.0</td>\n",
       "      <td>1064.0</td>\n",
       "      <td>117.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>1404.0</td>\n",
       "      <td>3014.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UK</th>\n",
       "      <td>9656.0</td>\n",
       "      <td>1745.0</td>\n",
       "      <td>6080.0</td>\n",
       "      <td>689.0</td>\n",
       "      <td>1143.0</td>\n",
       "      <td>14296.0</td>\n",
       "      <td>24730.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "NACE_R2        C    C_HTC  C_HTC_M   C_LTC  C_LTC_M      G-N    TOTAL\n",
       "GEO                                                                  \n",
       "CY           5.0      4.0      0.0     0.0      1.0      4.0     15.0\n",
       "CZ         976.0    107.0    609.0    37.0    223.0    688.0   1730.0\n",
       "DE       49482.0  11541.0  33187.0  1343.0   3401.0   7061.0  56997.0\n",
       "DK        2814.0   1526.0    956.0   236.0     96.0   1985.0   4865.0\n",
       "ES        3096.0    748.0   1519.0   426.0    403.0   3212.0   6784.0\n",
       "FI        3126.0   1873.0    892.0   190.0    171.0   1133.0   4410.0\n",
       "HR          85.0     49.0     28.0     6.0      3.0     73.0    164.0\n",
       "HU         526.0    232.0    201.0    44.0     49.0    435.0   1022.0\n",
       "IT        8736.0   1822.0   5029.0   966.0    919.0   3163.0  12344.0\n",
       "LT          50.0     15.0     17.0    12.0      5.0     64.0    116.0\n",
       "MT          10.0      5.0      3.0     1.0      1.0     23.0     33.0\n",
       "NL        4389.0    942.0   2455.0   463.0    529.0   2627.0   7433.0\n",
       "PL         821.0    104.0    399.0   145.0    173.0    891.0   1800.0\n",
       "SI         455.0    204.0    165.0    22.0     65.0    224.0    689.0\n",
       "TR        1562.0    166.0   1064.0   117.0    216.0   1404.0   3014.0\n",
       "UK        9656.0   1745.0   6080.0   689.0   1143.0  14296.0  24730.0"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "iter1 = (s for s in dat1.series if (s.key.GEO in ['CN_X_HK', 'EU28', 'US']) == False)\n",
    "tab1 = dresp1.write(iter1)\n",
    "tab1 = tab1.stack('GEO')\n",
    "tab1.columns = tab1.columns.droplevel(['FREQ','UNIT']) # Dropping 'FREQ' and 'UNIT' levels\n",
    "tab1 = tab1.loc['2014']\n",
    "tab1.index = tab1.index.droplevel(0) # Dropping the 'TIME_PERIOD' axis\n",
    "tab1.dropna(axis = 0, how = 'any', inplace = True)\n",
    "tab1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['CY',\n",
       " 'CZ',\n",
       " 'DE',\n",
       " 'DK',\n",
       " 'ES',\n",
       " 'FI',\n",
       " 'HR',\n",
       " 'HU',\n",
       " 'IT',\n",
       " 'LT',\n",
       " 'MT',\n",
       " 'NL',\n",
       " 'PL',\n",
       " 'SI',\n",
       " 'TR',\n",
       " 'UK']"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(tab1.index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "    <div class=\"bk-root\">\n",
       "        <div class=\"bk-plotdiv\" id=\"5257ff3e-c7b2-4c50-ad02-5b3afb4f416b\"></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(\"5257ff3e-c7b2-4c50-ad02-5b3afb4f416b\");\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(\"5257ff3e-c7b2-4c50-ad02-5b3afb4f416b\");\n",
       "    if (element == null) {\n",
       "      console.log(\"Bokeh: ERROR: autoload.js configured with elementid '5257ff3e-c7b2-4c50-ad02-5b3afb4f416b' 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 = {\"ebf3167e-24a0-4f85-9f8d-58c5f3ff0c2d\":{\"roots\":{\"references\":[{\"attributes\":{\"plot\":{\"id\":\"807b9bee-3728-457b-9b7e-2da32c5105da\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"57727887-120b-4e02-bed4-101385463663\",\"type\":\"SaveTool\"},{\"attributes\":{\"plot\":{\"id\":\"807b9bee-3728-457b-9b7e-2da32c5105da\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"a3a7bd27-55ee-44dd-b14e-700bcde8257a\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"level\":\"glyph\",\"plot\":{\"id\":\"807b9bee-3728-457b-9b7e-2da32c5105da\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"source\":{\"id\":\"8d329ead-7369-4c49-8e1f-16366b326aef\",\"type\":\"ColumnDataSource\"},\"text\":{\"field\":\"names\"},\"x\":{\"field\":\"manuf\"},\"y\":{\"field\":\"serv\"}},\"id\":\"1b4434f8-6703-4e93-926a-751f69f01a2f\",\"type\":\"LabelSet\"},{\"attributes\":{\"axis_label\":\"Manufacturing\",\"formatter\":{\"id\":\"88e7a488-c18d-4768-adb6-19f9f9599efa\",\"type\":\"BasicTickFormatter\"},\"plot\":{\"id\":\"807b9bee-3728-457b-9b7e-2da32c5105da\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"636f1eb0-2037-413f-9e69-bf4a37a58b61\",\"type\":\"BasicTicker\"}},\"id\":\"7591276f-a420-443f-9a25-0dc53c980883\",\"type\":\"LinearAxis\"},{\"attributes\":{\"plot\":null,\"text\":\"\"},\"id\":\"9351d42e-30d4-4ca0-93ce-e9f25c724881\",\"type\":\"Title\"},{\"attributes\":{\"overlay\":{\"id\":\"c992e646-1bbd-480e-9268-fca172b12171\",\"type\":\"BoxAnnotation\"},\"plot\":{\"id\":\"807b9bee-3728-457b-9b7e-2da32c5105da\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"87024a3a-5e7c-417c-bf4b-27aee83633dc\",\"type\":\"BoxZoomTool\"},{\"attributes\":{\"callback\":null},\"id\":\"4ec6d5b8-0317-4647-bc3b-8551479cb2fb\",\"type\":\"DataRange1d\"},{\"attributes\":{\"data_source\":{\"id\":\"8d329ead-7369-4c49-8e1f-16366b326aef\",\"type\":\"ColumnDataSource\"},\"glyph\":{\"id\":\"9c38257b-3b4c-4abf-a7d7-3557bc71eed4\",\"type\":\"Circle\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"fa0d1725-3da6-4310-a8c6-5195cec19d43\",\"type\":\"Circle\"},\"selection_glyph\":null},\"id\":\"d2062742-64b0-420b-b7ba-93093c60570e\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"plot\":{\"id\":\"807b9bee-3728-457b-9b7e-2da32c5105da\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"f873cc66-84f9-4692-8471-f7e7d2538023\",\"type\":\"ResetTool\"},{\"attributes\":{\"plot\":{\"id\":\"807b9bee-3728-457b-9b7e-2da32c5105da\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"636f1eb0-2037-413f-9e69-bf4a37a58b61\",\"type\":\"BasicTicker\"}},\"id\":\"ad9fa746-7e80-42a8-b453-ccbd0841ae03\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"636f1eb0-2037-413f-9e69-bf4a37a58b61\",\"type\":\"BasicTicker\"},{\"attributes\":{\"plot\":{\"id\":\"807b9bee-3728-457b-9b7e-2da32c5105da\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"0e4a3d4d-a9be-46b9-855f-46d9df853d84\",\"type\":\"HelpTool\"},{\"attributes\":{\"dimension\":1,\"plot\":{\"id\":\"807b9bee-3728-457b-9b7e-2da32c5105da\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"824e48a8-9609-447c-8522-5c2b1e50fbef\",\"type\":\"BasicTicker\"}},\"id\":\"c8db0c1c-8c98-48ca-8f54-458c6468b807\",\"type\":\"Grid\"},{\"attributes\":{\"fill_alpha\":{\"value\":0.1},\"fill_color\":{\"value\":\"#1f77b4\"},\"line_alpha\":{\"value\":0.1},\"line_color\":{\"value\":\"#1f77b4\"},\"size\":{\"units\":\"screen\",\"value\":10},\"x\":{\"field\":\"manuf\"},\"y\":{\"field\":\"serv\"}},\"id\":\"fa0d1725-3da6-4310-a8c6-5195cec19d43\",\"type\":\"Circle\"},{\"attributes\":{},\"id\":\"8c3856be-dabf-4acf-9155-9b404f121eb3\",\"type\":\"ToolEvents\"},{\"attributes\":{\"callback\":null},\"id\":\"51e7a091-bcfa-4533-9397-e003fd15823e\",\"type\":\"DataRange1d\"},{\"attributes\":{\"axis_label\":\"Business Services\",\"formatter\":{\"id\":\"f945ac6b-03f9-4040-92f4-cce92f02ebbf\",\"type\":\"BasicTickFormatter\"},\"plot\":{\"id\":\"807b9bee-3728-457b-9b7e-2da32c5105da\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"824e48a8-9609-447c-8522-5c2b1e50fbef\",\"type\":\"BasicTicker\"}},\"id\":\"38dc9f7b-cdc8-4792-a43b-b894f8da80f1\",\"type\":\"LinearAxis\"},{\"attributes\":{\"fill_alpha\":{\"value\":0.6},\"fill_color\":{\"value\":\"purple\"},\"line_alpha\":{\"value\":0.6},\"line_color\":{\"value\":\"purple\"},\"size\":{\"units\":\"screen\",\"value\":10},\"x\":{\"field\":\"manuf\"},\"y\":{\"field\":\"serv\"}},\"id\":\"9c38257b-3b4c-4abf-a7d7-3557bc71eed4\",\"type\":\"Circle\"},{\"attributes\":{},\"id\":\"f945ac6b-03f9-4040-92f4-cce92f02ebbf\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"plot\":{\"id\":\"807b9bee-3728-457b-9b7e-2da32c5105da\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"3fb478cc-ff5a-4754-9903-2263e5af8c2b\",\"type\":\"PanTool\"},{\"attributes\":{},\"id\":\"88e7a488-c18d-4768-adb6-19f9f9599efa\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"824e48a8-9609-447c-8522-5c2b1e50fbef\",\"type\":\"BasicTicker\"},{\"attributes\":{\"below\":[{\"id\":\"7591276f-a420-443f-9a25-0dc53c980883\",\"type\":\"LinearAxis\"}],\"left\":[{\"id\":\"38dc9f7b-cdc8-4792-a43b-b894f8da80f1\",\"type\":\"LinearAxis\"}],\"renderers\":[{\"id\":\"7591276f-a420-443f-9a25-0dc53c980883\",\"type\":\"LinearAxis\"},{\"id\":\"ad9fa746-7e80-42a8-b453-ccbd0841ae03\",\"type\":\"Grid\"},{\"id\":\"38dc9f7b-cdc8-4792-a43b-b894f8da80f1\",\"type\":\"LinearAxis\"},{\"id\":\"c8db0c1c-8c98-48ca-8f54-458c6468b807\",\"type\":\"Grid\"},{\"id\":\"c992e646-1bbd-480e-9268-fca172b12171\",\"type\":\"BoxAnnotation\"},{\"id\":\"d2062742-64b0-420b-b7ba-93093c60570e\",\"type\":\"GlyphRenderer\"},{\"id\":\"1b4434f8-6703-4e93-926a-751f69f01a2f\",\"type\":\"LabelSet\"}],\"title\":{\"id\":\"9351d42e-30d4-4ca0-93ce-e9f25c724881\",\"type\":\"Title\"},\"tool_events\":{\"id\":\"8c3856be-dabf-4acf-9155-9b404f121eb3\",\"type\":\"ToolEvents\"},\"toolbar\":{\"id\":\"3d25d4b4-891d-48b8-be2a-2dffcd04be50\",\"type\":\"Toolbar\"},\"x_range\":{\"id\":\"51e7a091-bcfa-4533-9397-e003fd15823e\",\"type\":\"DataRange1d\"},\"y_range\":{\"id\":\"4ec6d5b8-0317-4647-bc3b-8551479cb2fb\",\"type\":\"DataRange1d\"}},\"id\":\"807b9bee-3728-457b-9b7e-2da32c5105da\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{\"callback\":null,\"column_names\":[\"names\",\"manuf\",\"serv\"],\"data\":{\"manuf\":{\"__ndarray__\":\"AAAAAAAAFEAAAAAAAICOQAAAAABAKehAAAAAAAD8pUAAAAAAADCoQAAAAAAAbKhAAAAAAABAVUAAAAAAAHCAQAAAAAAAEMFAAAAAAAAASUAAAAAAAAAkQAAAAAAAJbFAAAAAAACoiUAAAAAAAHB8QAAAAAAAaJhAAAAAAADcwkA=\",\"dtype\":\"float64\",\"shape\":[16]},\"names\":[\"CY\",\"CZ\",\"DE\",\"DK\",\"ES\",\"FI\",\"HR\",\"HU\",\"IT\",\"LT\",\"MT\",\"NL\",\"PL\",\"SI\",\"TR\",\"UK\"],\"serv\":{\"__ndarray__\":\"AAAAAAAAEEAAAAAAAICFQAAAAAAAlbtAAAAAAAAEn0AAAAAAABipQAAAAAAAtJFAAAAAAABAUkAAAAAAADB7QAAAAAAAtqhAAAAAAAAAUEAAAAAAAAA3QAAAAAAAhqRAAAAAAADYi0AAAAAAAABsQAAAAAAA8JVAAAAAAADsy0A=\",\"dtype\":\"float64\",\"shape\":[16]}}},\"id\":\"8d329ead-7369-4c49-8e1f-16366b326aef\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"active_drag\":\"auto\",\"active_scroll\":\"auto\",\"active_tap\":\"auto\",\"tools\":[{\"id\":\"3fb478cc-ff5a-4754-9903-2263e5af8c2b\",\"type\":\"PanTool\"},{\"id\":\"a3a7bd27-55ee-44dd-b14e-700bcde8257a\",\"type\":\"WheelZoomTool\"},{\"id\":\"87024a3a-5e7c-417c-bf4b-27aee83633dc\",\"type\":\"BoxZoomTool\"},{\"id\":\"57727887-120b-4e02-bed4-101385463663\",\"type\":\"SaveTool\"},{\"id\":\"f873cc66-84f9-4692-8471-f7e7d2538023\",\"type\":\"ResetTool\"},{\"id\":\"0e4a3d4d-a9be-46b9-855f-46d9df853d84\",\"type\":\"HelpTool\"}]},\"id\":\"3d25d4b4-891d-48b8-be2a-2dffcd04be50\",\"type\":\"Toolbar\"},{\"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\":\"c992e646-1bbd-480e-9268-fca172b12171\",\"type\":\"BoxAnnotation\"}],\"root_ids\":[\"807b9bee-3728-457b-9b7e-2da32c5105da\"]},\"title\":\"Bokeh Application\",\"version\":\"0.12.5\"}};\n",
       "            var render_items = [{\"docid\":\"ebf3167e-24a0-4f85-9f8d-58c5f3ff0c2d\",\"elementid\":\"5257ff3e-c7b2-4c50-ad02-5b3afb4f416b\",\"modelid\":\"807b9bee-3728-457b-9b7e-2da32c5105da\"}];\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(\"5257ff3e-c7b2-4c50-ad02-5b3afb4f416b\")).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(tab1.index),\n",
    "                                      manuf = tab1.loc[:,'C'],\n",
    "                                      serv = tab1.loc[:,'G-N']))\n",
    "\n",
    "p = figure(plot_width = 600, plot_height = 600)\n",
    "p.scatter(x = 'manuf' , y = 'serv', size = 10, color = \"purple\", alpha = 0.6, source = source)\n",
    "p.xaxis.axis_label = 'Manufacturing'\n",
    "p.yaxis.axis_label = 'Business Services'\n",
    "\n",
    "labels = LabelSet(x = 'manuf', y = 'serv', text = 'names', source = source, render_mode='canvas', level='glyph')\n",
    "\n",
    "\n",
    "p.add_layout(labels)\n",
    "show(p)"
   ]
  }
 ],
 "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
}