{ "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", "
" ] }, "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", " \"\\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", " \"
\\n\"+\n", " \"\\n\"+\n",
" \"from bokeh.resources import INLINE\\n\"+\n",
" \"output_notebook(resources=INLINE)\\n\"+\n",
" \"
\\n\"+\n",
" \"\n", " | name | \n", "
---|---|
dataflow | \n", "\n", " |
htec_cis3 | \n", "Innovation in high-tech sectors in SMEs (CIS3)... | \n", "
htec_cis4 | \n", "Innovation in high-tech sectors (CIS 2004), EU... | \n", "
htec_cis5 | \n", "Innovation in high-tech sectors (CIS 2006), EU... | \n", "
htec_cis6 | \n", "Innovation in high-tech sectors (CIS 2008, CIS... | \n", "
htec_eco_ent | \n", "Enterprises in high-tech sectors by NACE Rev.1... | \n", "
htec_eco_ent2 | \n", "Enterprises in high-tech sectors by NACE Rev.2... | \n", "
htec_eco_sbs | \n", "Economic data in high-tech sectors by NACE Rev... | \n", "
htec_eco_sbs2 | \n", "Economic data in high-tech sectors by NACE Rev... | \n", "
htec_emp_nat | \n", "Employment in technology and knowledge-intensi... | \n", "
htec_emp_nat2 | \n", "Employment in technology and knowledge-intensi... | \n", "
htec_emp_nisced | \n", "Employment in technology and knowledge-intensi... | \n", "
htec_emp_nisced2 | \n", "Employment in technology and knowledge-intensi... | \n", "
htec_emp_nisco | \n", "Employment in technology and knowledge-intensi... | \n", "
htec_emp_nisco2 | \n", "Employment in technology and knowledge-intensi... | \n", "
htec_emp_reg | \n", "Employment in technology and knowledge-intensi... | \n", "
htec_emp_reg2 | \n", "Employment in technology and knowledge-intensi... | \n", "
htec_emp_risced | \n", "Employment in technology and knowledge-intensi... | \n", "
htec_emp_risced2 | \n", "Employment in technology and knowledge-intensi... | \n", "
htec_emp_risco | \n", "Employment in technology and knowledge-intensi... | \n", "
htec_emp_risco2 | \n", "Employment in technology and knowledge-intensi... | \n", "
htec_emp_sbs | \n", "Employment statistics on high-tech industries ... | \n", "
htec_emp_sbs2 | \n", "Employment statistics on high-tech industries ... | \n", "
htec_kia_emp | \n", "Annual data on employment in knowledge-intensi... | \n", "
htec_kia_emp2 | \n", "Annual data on employment in knowledge-intensi... | \n", "
htec_si_exp4 | \n", "High-tech exports - Exports of high technology... | \n", "
htec_sti_exp | \n", "Business enterprise R&D expenditure in high-te... | \n", "
htec_sti_exp2 | \n", "Business enterprise R&D expenditure in high-te... | \n", "
htec_sti_pers | \n", "Business enterprise R&D personnel in high-tech... | \n", "
htec_sti_pers2 | \n", "Business enterprise R&D personnel in high-tech... | \n", "
htec_trd_group4 | \n", "High-tech trade by high-tech group of products... | \n", "
htec_trd_tot4 | \n", "Total high-tech trade in million euro and as a... | \n", "
htec_vci_stage1 | \n", "Venture capital investment by aggregated stage... | \n", "
htec_vci_stage2 | \n", "Venture capital investment by detailed stage o... | \n", "
\n", " | \n", " | dim_or_attr | \n", "name | \n", "
---|---|---|---|
FREQ | \n", "FREQ | \n", "D | \n", "FREQ | \n", "
A | \n", "D | \n", "Annual | \n", "|
D | \n", "D | \n", "Daily | \n", "|
H | \n", "D | \n", "Half-year | \n", "|
M | \n", "D | \n", "Monthly | \n", "|
Q | \n", "D | \n", "Quarterly | \n", "|
S | \n", "D | \n", "Semi-annual | \n", "|
W | \n", "D | \n", "Weekly | \n", "|
UNIT | \n", "UNIT | \n", "D | \n", "UNIT | \n", "
MIO_EUR | \n", "D | \n", "Million euro | \n", "|
NACE_R2 | \n", "NACE_R2 | \n", "D | \n", "NACE_R2 | \n", "
C | \n", "D | \n", "Manufacturing | \n", "|
C_HTC | \n", "D | \n", "High-technology manufacturing | \n", "|
C_HTC_M | \n", "D | \n", "Medium high-technology manufacturing | \n", "|
C_LTC | \n", "D | \n", "Low-technology manufacturing | \n", "|
C_LTC_M | \n", "D | \n", "Medium low-technology manufacturing | \n", "|
G-N | \n", "D | \n", "Services of the business economy | \n", "|
TOTAL | \n", "D | \n", "Total - all NACE activities | \n", "|
GEO | \n", "GEO | \n", "D | \n", "GEO | \n", "
AT | \n", "D | \n", "Austria | \n", "|
BE | \n", "D | \n", "Belgium | \n", "|
BG | \n", "D | \n", "Bulgaria | \n", "|
CH | \n", "D | \n", "Switzerland | \n", "|
CN_X_HK | \n", "D | \n", "China except Hong Kong | \n", "|
CY | \n", "D | \n", "Cyprus | \n", "|
CZ | \n", "D | \n", "Czech Republic | \n", "|
DE | \n", "D | \n", "Germany (until 1990 former territory of the FRG) | \n", "|
DK | \n", "D | \n", "Denmark | \n", "|
EE | \n", "D | \n", "Estonia | \n", "|
EL | \n", "D | \n", "Greece | \n", "|
... | \n", "... | \n", "... | \n", "|
NL | \n", "D | \n", "Netherlands | \n", "|
NO | \n", "D | \n", "Norway | \n", "|
PL | \n", "D | \n", "Poland | \n", "|
PT | \n", "D | \n", "Portugal | \n", "|
RO | \n", "D | \n", "Romania | \n", "|
RS | \n", "D | \n", "Serbia | \n", "|
RU | \n", "D | \n", "Russia | \n", "|
SE | \n", "D | \n", "Sweden | \n", "|
SI | \n", "D | \n", "Slovenia | \n", "|
SK | \n", "D | \n", "Slovakia | \n", "|
TR | \n", "D | \n", "Turkey | \n", "|
UK | \n", "D | \n", "United Kingdom | \n", "|
US | \n", "D | \n", "United States | \n", "|
OBS_FLAG | \n", "OBS_FLAG | \n", "A | \n", "Observation flag. | \n", "
b | \n", "A | \n", "break in time series | \n", "|
c | \n", "A | \n", "confidential | \n", "|
d | \n", "A | \n", "definition differs, see metadata | \n", "|
e | \n", "A | \n", "estimated | \n", "|
f | \n", "A | \n", "forecast | \n", "|
i | \n", "A | \n", "see metadata (phased out) | \n", "|
n | \n", "A | \n", "not significant | \n", "|
p | \n", "A | \n", "provisional | \n", "|
r | \n", "A | \n", "revised | \n", "|
s | \n", "A | \n", "Eurostat estimate (phased out) | \n", "|
u | \n", "A | \n", "low reliability | \n", "|
z | \n", "A | \n", "not applicable | \n", "|
OBS_STATUS | \n", "OBS_STATUS | \n", "A | \n", "Observation status. | \n", "
- | \n", "A | \n", "not applicable or real zero or zero by default | \n", "|
0 | \n", "A | \n", "less than half of the unit used | \n", "|
na | \n", "A | \n", "not available | \n", "
76 rows × 2 columns
\n", "NACE_R2 | \n", "C | \n", "C_HTC | \n", "C_HTC_M | \n", "C_LTC | \n", "C_LTC_M | \n", "G-N | \n", "TOTAL | \n", "
---|---|---|---|---|---|---|---|
GEO | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
CY | \n", "5.0 | \n", "4.0 | \n", "0.0 | \n", "0.0 | \n", "1.0 | \n", "4.0 | \n", "15.0 | \n", "
CZ | \n", "976.0 | \n", "107.0 | \n", "609.0 | \n", "37.0 | \n", "223.0 | \n", "688.0 | \n", "1730.0 | \n", "
DE | \n", "49482.0 | \n", "11541.0 | \n", "33187.0 | \n", "1343.0 | \n", "3401.0 | \n", "7061.0 | \n", "56997.0 | \n", "
DK | \n", "2814.0 | \n", "1526.0 | \n", "956.0 | \n", "236.0 | \n", "96.0 | \n", "1985.0 | \n", "4865.0 | \n", "
ES | \n", "3096.0 | \n", "748.0 | \n", "1519.0 | \n", "426.0 | \n", "403.0 | \n", "3212.0 | \n", "6784.0 | \n", "
FI | \n", "3126.0 | \n", "1873.0 | \n", "892.0 | \n", "190.0 | \n", "171.0 | \n", "1133.0 | \n", "4410.0 | \n", "
HR | \n", "85.0 | \n", "49.0 | \n", "28.0 | \n", "6.0 | \n", "3.0 | \n", "73.0 | \n", "164.0 | \n", "
HU | \n", "526.0 | \n", "232.0 | \n", "201.0 | \n", "44.0 | \n", "49.0 | \n", "435.0 | \n", "1022.0 | \n", "
IT | \n", "8736.0 | \n", "1822.0 | \n", "5029.0 | \n", "966.0 | \n", "919.0 | \n", "3163.0 | \n", "12344.0 | \n", "
LT | \n", "50.0 | \n", "15.0 | \n", "17.0 | \n", "12.0 | \n", "5.0 | \n", "64.0 | \n", "116.0 | \n", "
MT | \n", "10.0 | \n", "5.0 | \n", "3.0 | \n", "1.0 | \n", "1.0 | \n", "23.0 | \n", "33.0 | \n", "
NL | \n", "4389.0 | \n", "942.0 | \n", "2455.0 | \n", "463.0 | \n", "529.0 | \n", "2627.0 | \n", "7433.0 | \n", "
PL | \n", "821.0 | \n", "104.0 | \n", "399.0 | \n", "145.0 | \n", "173.0 | \n", "891.0 | \n", "1800.0 | \n", "
SI | \n", "455.0 | \n", "204.0 | \n", "165.0 | \n", "22.0 | \n", "65.0 | \n", "224.0 | \n", "689.0 | \n", "
TR | \n", "1562.0 | \n", "166.0 | \n", "1064.0 | \n", "117.0 | \n", "216.0 | \n", "1404.0 | \n", "3014.0 | \n", "
UK | \n", "9656.0 | \n", "1745.0 | \n", "6080.0 | \n", "689.0 | \n", "1143.0 | \n", "14296.0 | \n", "24730.0 | \n", "