Eurostat/Eurostat_api.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": 509,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Connecting to the webservice"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "estat = Request('ESTAT')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Downloading dataflow definitions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 346,
   "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": 473,
   "metadata": {},
   "outputs": [],
   "source": [
    "def dsd_resp(id):\n",
    "    \"\"\"\n",
    "    The function takes the table identifier from the Eurostat SDMX api by the given id and returns the table's datastructure response.\n",
    "    \"\"\"    \n",
    "    # Defining the table's dataflow\n",
    "    df = flows.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 table's datastructure id\n",
    "    dsd_id = df.structure.id\n",
    "    \n",
    "    # Requesting for the table's datastructure\n",
    "    dsd_resp = estat.get(resource_type = 'datastructure', resource_id = dsd_id)\n",
    "    \n",
    "    return dsd_resp    "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Datastructure attributes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 455,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def dsd_att(dsd):\n",
    "    \"\"\"The function takes a table datastructure definition and returns its measures, dimensions and attributes.\"\"\"\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": 347,
   "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": 347,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dflow.write().dataflow[flows.write().dataflow.index.str.startswith('htec') == True]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### The tables I am going to analyze"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 381,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "id1 = 'htec_sti_exp2'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 426,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Business enterprise R&D expenditure in high-tech sectors - NACE Rev. 2'"
      ]
     },
     "execution_count": 426,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dflow.write().dataflow.loc[id1][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 382,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "id2 = 'htec_vci_stage2'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 427,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Venture capital investment by detailed stage of development (from 2007, source: EVCA)'"
      ]
     },
     "execution_count": 427,
     "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": 483,
   "metadata": {
    "scrolled": false
   },
   "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"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<pandasdmx.api.Response at 0x2a8e3190be0>"
      ]
     },
     "execution_count": 483,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dsd_resp1 = dsd_resp(id1)\n",
    "dsd_resp1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Downloading the table's datastructure definition"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 484,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dsd1 = dsd_resp1.datastructure[dsd_id1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 485,
   "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": [
    "### Requesting the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 486,
   "metadata": {},
   "outputs": [],
   "source": [
    "dresp1 = estat.get(resource_type = 'data', resource_id = id1, params = {'references': None})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 487,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dat1 = dresp1.data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 488,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'TIME_PERIOD'"
      ]
     },
     "execution_count": 488,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat1.dim_at_obs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 489,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "280"
      ]
     },
     "execution_count": 489,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ser1 = list(dat1.series)\n",
    "len(ser1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Codes in the table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 490,
   "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": 490,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dsd_resp1.write().codelist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 491,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "SeriesKey(UNIT='MIO_EUR', NACE_R2='C', GEO='CY', FREQ='A')"
      ]
     },
     "execution_count": 491,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ser1[5].key"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 492,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'MIO_EUR'}"
      ]
     },
     "execution_count": 492,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set(s.key.UNIT for s in dat1.series)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Writing the data into DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 493,
   "metadata": {},
   "outputs": [],
   "source": [
    "iter1 = (s for s in dat1.series)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 494,
   "metadata": {},
   "outputs": [],
   "source": [
    "tab1 = dresp1.write(iter1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 495,
   "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=\"21\" halign=\"left\">MIO_EUR</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NACE_R2</th>\n",
       "      <th colspan=\"10\" halign=\"left\">C</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"10\" halign=\"left\">TOTAL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GEO</th>\n",
       "      <th>AT</th>\n",
       "      <th>BE</th>\n",
       "      <th>BG</th>\n",
       "      <th>CH</th>\n",
       "      <th>CN_X_HK</th>\n",
       "      <th>CY</th>\n",
       "      <th>CZ</th>\n",
       "      <th>DE</th>\n",
       "      <th>DK</th>\n",
       "      <th>EE</th>\n",
       "      <th>...</th>\n",
       "      <th>PT</th>\n",
       "      <th>RO</th>\n",
       "      <th>RS</th>\n",
       "      <th>RU</th>\n",
       "      <th>SE</th>\n",
       "      <th>SI</th>\n",
       "      <th>SK</th>\n",
       "      <th>TR</th>\n",
       "      <th>UK</th>\n",
       "      <th>US</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FREQ</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>...</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TIME_PERIOD</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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2015</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1079.0</td>\n",
       "      <td>344.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7955.0</td>\n",
       "      <td>10137.0</td>\n",
       "      <td>651.0</td>\n",
       "      <td>259.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28839.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>976.0</td>\n",
       "      <td>49482.0</td>\n",
       "      <td>2814.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1036.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>9915.0</td>\n",
       "      <td>9126.0</td>\n",
       "      <td>689.0</td>\n",
       "      <td>247.0</td>\n",
       "      <td>3014.0</td>\n",
       "      <td>24730.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>4206.0</td>\n",
       "      <td>4148.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>934.0</td>\n",
       "      <td>46049.0</td>\n",
       "      <td>2831.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1073.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>10733.0</td>\n",
       "      <td>9933.0</td>\n",
       "      <td>716.0</td>\n",
       "      <td>283.0</td>\n",
       "      <td>2775.0</td>\n",
       "      <td>21721.0</td>\n",
       "      <td>242849.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>NaN</td>\n",
       "      <td>4018.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>7294.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>848.0</td>\n",
       "      <td>46333.0</td>\n",
       "      <td>2799.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1153.0</td>\n",
       "      <td>251.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>10226.0</td>\n",
       "      <td>9417.0</td>\n",
       "      <td>703.0</td>\n",
       "      <td>242.0</td>\n",
       "      <td>2546.0</td>\n",
       "      <td>21096.0</td>\n",
       "      <td>235251.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>3626.0</td>\n",
       "      <td>3532.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>794.0</td>\n",
       "      <td>43733.0</td>\n",
       "      <td>2530.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1216.0</td>\n",
       "      <td>237.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>9101.0</td>\n",
       "      <td>9088.0</td>\n",
       "      <td>660.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>2061.0</td>\n",
       "      <td>20058.0</td>\n",
       "      <td>211273.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>NaN</td>\n",
       "      <td>3016.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>675.0</td>\n",
       "      <td>40241.0</td>\n",
       "      <td>2488.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1266.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>7866.0</td>\n",
       "      <td>8160.0</td>\n",
       "      <td>506.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>18731.0</td>\n",
       "      <td>210438.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>3435.0</td>\n",
       "      <td>2956.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>609.0</td>\n",
       "      <td>38711.0</td>\n",
       "      <td>2433.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1311.0</td>\n",
       "      <td>223.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>6866.0</td>\n",
       "      <td>7577.0</td>\n",
       "      <td>424.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>1496.0</td>\n",
       "      <td>17537.0</td>\n",
       "      <td>202461.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>NaN</td>\n",
       "      <td>3009.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>5636.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>665.0</td>\n",
       "      <td>40778.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1295.0</td>\n",
       "      <td>242.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7446.0</td>\n",
       "      <td>9119.0</td>\n",
       "      <td>398.0</td>\n",
       "      <td>131.0</td>\n",
       "      <td>1599.0</td>\n",
       "      <td>19962.0</td>\n",
       "      <td>197635.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007</th>\n",
       "      <td>3383.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>594.0</td>\n",
       "      <td>37934.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1011.0</td>\n",
       "      <td>272.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6807.0</td>\n",
       "      <td>8470.0</td>\n",
       "      <td>299.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1407.0</td>\n",
       "      <td>22842.0</td>\n",
       "      <td>196474.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2006</th>\n",
       "      <td>3160.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>552.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>736.0</td>\n",
       "      <td>215.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5643.0</td>\n",
       "      <td>8754.0</td>\n",
       "      <td>291.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>901.0</td>\n",
       "      <td>20985.0</td>\n",
       "      <td>197252.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2005</th>\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>445.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>462.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4458.0</td>\n",
       "      <td>7725.0</td>\n",
       "      <td>243.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>774.0</td>\n",
       "      <td>19464.0</td>\n",
       "      <td>181785.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11 rows × 280 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "UNIT        MIO_EUR                                                     \\\n",
       "NACE_R2           C                                                      \n",
       "GEO              AT      BE    BG      CH CN_X_HK   CY     CZ       DE   \n",
       "FREQ              A       A     A       A       A    A      A        A   \n",
       "TIME_PERIOD                                                              \n",
       "2015            NaN     NaN   NaN     NaN     NaN  NaN    NaN      NaN   \n",
       "2014            NaN     NaN  39.0     NaN     NaN  5.0  976.0  49482.0   \n",
       "2013         4206.0  4148.0  23.0     NaN     NaN  5.0  934.0  46049.0   \n",
       "2012            NaN  4018.0  24.0  7294.0     NaN  4.0  848.0  46333.0   \n",
       "2011         3626.0  3532.0  14.0     NaN     NaN  4.0  794.0  43733.0   \n",
       "2010            NaN  3016.0  17.0     NaN     NaN  5.0  675.0  40241.0   \n",
       "2009         3435.0  2956.0  13.0     NaN     NaN  5.0  609.0  38711.0   \n",
       "2008            NaN  3009.0  21.0  5636.0     NaN  6.0  665.0  40778.0   \n",
       "2007         3383.0     NaN  15.0     NaN     NaN  NaN  594.0  37934.0   \n",
       "2006         3160.0     NaN  13.0     NaN     NaN  NaN  552.0      NaN   \n",
       "2005            NaN     NaN   NaN     NaN     NaN  NaN  445.0      NaN   \n",
       "\n",
       "UNIT                          ...                                            \\\n",
       "NACE_R2                       ...      TOTAL                                  \n",
       "GEO              DK     EE    ...         PT     RO    RS       RU       SE   \n",
       "FREQ              A      A    ...          A      A     A        A        A   \n",
       "TIME_PERIOD                   ...                                             \n",
       "2015            NaN    NaN    ...     1079.0  344.0   NaN   7955.0  10137.0   \n",
       "2014         2814.0   27.0    ...     1036.0  238.0  76.0   9915.0   9126.0   \n",
       "2013         2831.0   54.0    ...     1073.0  171.0  33.0  10733.0   9933.0   \n",
       "2012         2799.0   95.0    ...     1153.0  251.0  72.0  10226.0   9417.0   \n",
       "2011         2530.0  155.0    ...     1216.0  237.0  23.0   9101.0   9088.0   \n",
       "2010         2488.0   43.0    ...     1266.0  220.0  26.0   7866.0   8160.0   \n",
       "2009         2433.0   18.0    ...     1311.0  223.0  38.0   6866.0   7577.0   \n",
       "2008            NaN   20.0    ...     1295.0  242.0   NaN   7446.0   9119.0   \n",
       "2007            NaN   27.0    ...     1011.0  272.0   NaN   6807.0   8470.0   \n",
       "2006            NaN    NaN    ...      736.0  215.0   NaN   5643.0   8754.0   \n",
       "2005            NaN    NaN    ...      462.0  163.0   NaN   4458.0   7725.0   \n",
       "\n",
       "UNIT                                                  \n",
       "NACE_R2                                               \n",
       "GEO             SI     SK      TR       UK        US  \n",
       "FREQ             A      A       A        A         A  \n",
       "TIME_PERIOD                                           \n",
       "2015         651.0  259.0     NaN  28839.0       NaN  \n",
       "2014         689.0  247.0  3014.0  24730.0       NaN  \n",
       "2013         716.0  283.0  2775.0  21721.0  242849.0  \n",
       "2012         703.0  242.0  2546.0  21096.0  235251.0  \n",
       "2011         660.0  174.0  2061.0  20058.0  211273.0  \n",
       "2010         506.0  175.0  1975.0  18731.0  210438.0  \n",
       "2009         424.0  124.0  1496.0  17537.0  202461.0  \n",
       "2008         398.0  131.0  1599.0  19962.0  197635.0  \n",
       "2007         299.0  100.0  1407.0  22842.0  196474.0  \n",
       "2006         291.0   93.0   901.0  20985.0  197252.0  \n",
       "2005         243.0   97.0   774.0  19464.0  181785.0  \n",
       "\n",
       "[11 rows x 280 columns]"
      ]
     },
     "execution_count": 495,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tab1"
   ]
  },
  {
   "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": 496,
   "metadata": {
    "scrolled": false
   },
   "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"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<pandasdmx.api.Response at 0x2a8e28cb390>"
      ]
     },
     "execution_count": 496,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dsd_resp2 = dsd_resp(id2)\n",
    "dsd_resp2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Downloading the table's datastructure definition"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 497,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dsd2 = dsd_resp2.datastructure[dsd_id2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 498,
   "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": [
    "### Requesting the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 499,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dresp2 = estat.get(resource_type = 'data', resource_id = id2, params = {'references': None})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 500,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dat2 = dresp2.data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 501,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'TIME_PERIOD'"
      ]
     },
     "execution_count": 501,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat2.dim_at_obs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 502,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "621"
      ]
     },
     "execution_count": 502,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ser2 = list(dat2.series)\n",
    "len(ser2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Codes in the table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 503,
   "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=\"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": 503,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dsd_resp2.write().codelist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 504,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "SeriesKey(UNIT='MIO_EUR', EXPEND='INV', GEO='DE', FREQ='A')"
      ]
     },
     "execution_count": 504,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ser2[5].key"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 505,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'MIO_EUR', 'NR_COMP', 'PC_GDP'}"
      ]
     },
     "execution_count": 505,
     "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": 506,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "iter2 = (s for s in dat2.series)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 507,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "tab2 = dresp2.write(iter2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 508,
   "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=\"10\" halign=\"left\">MIO_EUR</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"10\" halign=\"left\">PC_GDP</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EXPEND</th>\n",
       "      <th colspan=\"10\" halign=\"left\">INV</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"10\" halign=\"left\">INV_VEN_STAR</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GEO</th>\n",
       "      <th>AT</th>\n",
       "      <th>BE</th>\n",
       "      <th>BG</th>\n",
       "      <th>CH</th>\n",
       "      <th>CZ</th>\n",
       "      <th>DE</th>\n",
       "      <th>DK</th>\n",
       "      <th>EL</th>\n",
       "      <th>ES</th>\n",
       "      <th>EU15</th>\n",
       "      <th>...</th>\n",
       "      <th>IE</th>\n",
       "      <th>IT</th>\n",
       "      <th>LU</th>\n",
       "      <th>NL</th>\n",
       "      <th>NO</th>\n",
       "      <th>PL</th>\n",
       "      <th>PT</th>\n",
       "      <th>RO</th>\n",
       "      <th>SE</th>\n",
       "      <th>UK</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FREQ</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>...</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "      <th>A</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TIME_PERIOD</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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2015</th>\n",
       "      <td>109.0</td>\n",
       "      <td>722.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>640.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>5996.0</td>\n",
       "      <td>1162.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1051.0</td>\n",
       "      <td>44497.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>106.0</td>\n",
       "      <td>664.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1237.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>5922.0</td>\n",
       "      <td>663.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>958.0</td>\n",
       "      <td>38745.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>86.0</td>\n",
       "      <td>925.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>609.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>6146.0</td>\n",
       "      <td>1484.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>754.0</td>\n",
       "      <td>36116.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>155.0</td>\n",
       "      <td>522.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>662.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>5315.0</td>\n",
       "      <td>694.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1475.0</td>\n",
       "      <td>35275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>124.0</td>\n",
       "      <td>590.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>640.0</td>\n",
       "      <td>193.0</td>\n",
       "      <td>4439.0</td>\n",
       "      <td>421.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1974.0</td>\n",
       "      <td>44570.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>130.0</td>\n",
       "      <td>476.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1555.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>4826.0</td>\n",
       "      <td>439.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2480.0</td>\n",
       "      <td>40019.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>140.0</td>\n",
       "      <td>1018.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>718.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>2619.0</td>\n",
       "      <td>452.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>959.0</td>\n",
       "      <td>22816.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>214.0</td>\n",
       "      <td>636.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1084.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>7115.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>234.0</td>\n",
       "      <td>1681.0</td>\n",
       "      <td>51636.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007</th>\n",
       "      <td>394.0</td>\n",
       "      <td>1048.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>970.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>8083.0</td>\n",
       "      <td>1334.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>2923.0</td>\n",
       "      <td>70276.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9 rows × 621 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "UNIT        MIO_EUR                                                      \\\n",
       "EXPEND          INV                                                       \n",
       "GEO              AT      BE    BG      CH     CZ      DE      DK     EL   \n",
       "FREQ              A       A     A       A      A       A       A      A   \n",
       "TIME_PERIOD                                                               \n",
       "2015          109.0   722.0  16.0   640.0   13.0  5996.0  1162.0    0.0   \n",
       "2014          106.0   664.0   1.0  1237.0   14.0  5922.0   663.0    0.0   \n",
       "2013           86.0   925.0   2.0   609.0   24.0  6146.0  1484.0    1.0   \n",
       "2012          155.0   522.0  65.0   662.0   17.0  5315.0   694.0    0.0   \n",
       "2011          124.0   590.0  11.0   640.0  193.0  4439.0   421.0    9.0   \n",
       "2010          130.0   476.0   5.0  1555.0   37.0  4826.0   439.0   15.0   \n",
       "2009          140.0  1018.0   6.0   718.0   61.0  2619.0   452.0   39.0   \n",
       "2008          214.0   636.0  15.0  1084.0   40.0  7115.0   512.0  234.0   \n",
       "2007          394.0  1048.0  39.0   970.0   70.0  8083.0  1334.0   90.0   \n",
       "\n",
       "UNIT                         ...       PC_GDP                                  \\\n",
       "EXPEND                       ... INV_VEN_STAR                                   \n",
       "GEO              ES     EU15 ...           IE  IT  LU  NL  NO  PL  PT  RO  SE   \n",
       "FREQ              A        A ...            A   A   A   A   A   A   A   A   A   \n",
       "TIME_PERIOD                  ...                                                \n",
       "2015         1051.0  44497.0 ...          NaN NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "2014          958.0  38745.0 ...          NaN NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "2013          754.0  36116.0 ...          NaN NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "2012         1475.0  35275.0 ...          NaN NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "2011         1974.0  44570.0 ...          NaN NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "2010         2480.0  40019.0 ...          NaN NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "2009          959.0  22816.0 ...          NaN NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "2008         1681.0  51636.0 ...          NaN NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "2007         2923.0  70276.0 ...          NaN NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "\n",
       "UNIT             \n",
       "EXPEND           \n",
       "GEO          UK  \n",
       "FREQ          A  \n",
       "TIME_PERIOD      \n",
       "2015        NaN  \n",
       "2014        NaN  \n",
       "2013        NaN  \n",
       "2012        NaN  \n",
       "2011        NaN  \n",
       "2010        NaN  \n",
       "2009        NaN  \n",
       "2008        NaN  \n",
       "2007        NaN  \n",
       "\n",
       "[9 rows x 621 columns]"
      ]
     },
     "execution_count": 508,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tab2"
   ]
  }
 ],
 "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
}