SDMX.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandasdmx as sdmx\n",
    "import pandas as pd\n",
    "import dash_core_components as dcc\n",
    "import dash_html_components as html\n",
    "from dash.dependencies import Input, Output\n",
    "import plotly.graph_objects as go\n",
    "import plotly.express as px\n",
    "# from jupyter_dash import JupyterDash"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandasdmx.StructureMessage>\n",
       "  <Header>\n",
       "    id: 'IREF152663'\n",
       "    prepared: '2022-02-16T12:41:02+00:00'\n",
       "    receiver: <Agency not_supplied>\n",
       "    sender: <Agency UNICEF>\n",
       "    source: \n",
       "    test: False\n",
       "  response: <Response [200]>\n",
       "  Codelist (37): CL_INDICATORS_TRANSMONEE CL_CONF_STATUS CL_DECIMALS CL...\n",
       "  ConceptScheme (3): CROSS_DOMAIN_CONCEPTS CS_SDG UNICEF_CONCEPTS\n",
       "  DataflowDefinition (1): TRANSMONEE\n",
       "  DataStructureDefinition (1): DSD_ECARO_TRANSMONEE\n",
       "  AgencyScheme (2): AGENCIES DATA_PROVIDERS\n",
       "  ProvisionAgreement (1): TRANSMONEE_ECARO_ECARO"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ind_code = \"HT_ADOL_UNMETMED_NOUNMET\"\n",
    "\n",
    "unicef = sdmx.Request(\"UNICEF\")\n",
    "\n",
    "metadata = unicef.dataflow(\"TRANSMONEE\", provider=\"ECARO\", version=\"1.0\")\n",
    "metadata"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://sdmx.data.unicef.org/ws/public/sdmxapi/rest/dataflow/ECARO/TRANSMONEE/1.0?references=all'"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "metadata.response.url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "metadata.response.from_cache"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandasdmx.StructureMessage>\n",
       "  <Header>\n",
       "    id: 'IREF578808'\n",
       "    prepared: '2022-02-15T20:44:45+00:00'\n",
       "    receiver: <Agency not_supplied>\n",
       "    sender: <Agency UNICEF>\n",
       "    source: \n",
       "    test: False\n",
       "  response: <Response [200]>\n",
       "  Codelist (37): CL_INDICATORS_TRANSMONEE CL_CONF_STATUS CL_DECIMALS CL...\n",
       "  ConceptScheme (3): CROSS_DOMAIN_CONCEPTS CS_SDG UNICEF_CONCEPTS\n",
       "  DataflowDefinition (1): TRANSMONEE\n",
       "  DataStructureDefinition (1): DSD_ECARO_TRANSMONEE\n",
       "  AgencyScheme (2): AGENCIES DATA_PROVIDERS\n",
       "  ProvisionAgreement (1): TRANSMONEE_ECARO_ECARO"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "metadata"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://sdmx.data.unicef.org/ws/public/sdmxapi/rest/dataflow/ECARO/TRANSMONEE/1.0?references=all'"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "metadata.response.url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "TRANSMONEE    ECARO for TransMonEE\n",
       "dtype: object"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataflows = sdmx.to_pandas(metadata.dataflow)\n",
    "dataflows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CL_AGE</th>\n",
       "      <th>name</th>\n",
       "      <th>parent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M0</td>\n",
       "      <td>Under 1 month old</td>\n",
       "      <td>CL_AGE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M0T1</td>\n",
       "      <td>Under 2 months old</td>\n",
       "      <td>CL_AGE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M0T11</td>\n",
       "      <td>Under 12 months old</td>\n",
       "      <td>CL_AGE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M0T23</td>\n",
       "      <td>Under 24 months old</td>\n",
       "      <td>CL_AGE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M0T35</td>\n",
       "      <td>Under 36 months old</td>\n",
       "      <td>CL_AGE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>Y_GE85</td>\n",
       "      <td>85 years old and over</td>\n",
       "      <td>CL_AGE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>Y_GE90</td>\n",
       "      <td>90 years old and over</td>\n",
       "      <td>CL_AGE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>Y_GE95</td>\n",
       "      <td>95 years old and over</td>\n",
       "      <td>CL_AGE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>_T</td>\n",
       "      <td>Total</td>\n",
       "      <td>CL_AGE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393</th>\n",
       "      <td>_U</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>CL_AGE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>394 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     CL_AGE                   name  parent\n",
       "0        M0      Under 1 month old  CL_AGE\n",
       "1      M0T1     Under 2 months old  CL_AGE\n",
       "2     M0T11    Under 12 months old  CL_AGE\n",
       "3     M0T23    Under 24 months old  CL_AGE\n",
       "4     M0T35    Under 36 months old  CL_AGE\n",
       "..      ...                    ...     ...\n",
       "389  Y_GE85  85 years old and over  CL_AGE\n",
       "390  Y_GE90  90 years old and over  CL_AGE\n",
       "391  Y_GE95  95 years old and over  CL_AGE\n",
       "392      _T                  Total  CL_AGE\n",
       "393      _U                Unknown  CL_AGE\n",
       "\n",
       "[394 rows x 3 columns]"
      ]
     },
     "execution_count": 159,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cl_age = unicef.codelist(\"CL_AGE\", version=\"1.0\")\n",
    "age_groups = sdmx.to_pandas(cl_age)\n",
    "dict_age_groups = age_groups['codelist']['CL_AGE'].reset_index()\n",
    "dict_age_groups\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CL_AGE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: []\n",
       "Index: []"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "age_groups = sdmx.to_pandas(metadata.codelist['CL_AGE'])\n",
    "age_groups"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'_T'"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gender = list(dsd.dimensions.get('RESIDENCE').local_representation.enumerated)[0]\n",
    "gender.id\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<DataAttribute COVERAGE_TIME>,\n",
       " <DataAttribute UNIT_MEASURE>,\n",
       " <DataAttribute OBS_FOOTNOTE>,\n",
       " <DataAttribute FREQ>,\n",
       " <DataAttribute DATA_SOURCE>,\n",
       " <DataAttribute UNIT_MULTIPLIER>,\n",
       " <DataAttribute OBS_STATUS>]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dsd.attributes.components"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<Code BINARY: Binary>,\n",
       " <Code BIRTHS: Births>,\n",
       " <Code BIRTHSPER1000WOMEN: Births per 1000 women>,\n",
       " <Code BIRTHS_1000: 1000 Births>,\n",
       " <Code D: Number of deaths>,\n",
       " <Code DPIA: Adjusted disability parity index>,\n",
       " <Code D_PER_1000_1: Deaths per 1000 children aged 1>,\n",
       " <Code D_PER_1000_10: Deaths per 1000 children aged 10>,\n",
       " <Code D_PER_1000_15: Deaths per 1000 children aged 15>,\n",
       " <Code D_PER_1000_20: Deaths per 1000 children aged 20>,\n",
       " <Code D_PER_1000_5: Deaths per 1000 children aged 5>,\n",
       " <Code D_PER_1000_B: Deaths per 1000 live births>,\n",
       " <Code EUR: Euro>,\n",
       " <Code GDP_CAP: As % of GDP per capita>,\n",
       " <Code GDP_PERC: % of GDP>,\n",
       " <Code GOV_EXP_EDU: % of government expenditure on education>,\n",
       " <Code GOV_EXP_HT: Percentage of government expenditure on health>,\n",
       " <Code GOV_EXP_T: % of total government expenditure>,\n",
       " <Code GPERM3: Micrograms per cubic meter>,\n",
       " <Code GPI: Gender Parity Index>,\n",
       " <Code GPIA: Adjusted gender parity index>,\n",
       " <Code HRS_WK: Hours Worked>,\n",
       " <Code IDX: Index>,\n",
       " <Code LIVEBIRTHSPERWOMAN: Live births per woman>,\n",
       " <Code LPI: Location Parity Index>,\n",
       " <Code LPIA: Adjusted location parity index>,\n",
       " <Code LTPIA: Adjusted speaks language of the test parity index>,\n",
       " <Code NPIA: Adjusted native parity index>,\n",
       " <Code NUMBER: Number>,\n",
       " <Code NUMBER_1000: 1000>,\n",
       " <Code PARITY_IDX: Parity Index>,\n",
       " <Code PCNT: %>,\n",
       " <Code PER100: Per 100>,\n",
       " <Code PER1000: Per 1000>,\n",
       " <Code PER100000: Per 100000>,\n",
       " <Code PER1000LIVEBIRTHS: Per 1000 live births>,\n",
       " <Code PER1000POP: Per 1000 population>,\n",
       " <Code PER100KLIVEBIRTHS: Per 100000 live births>,\n",
       " <Code PER1USD_GNI_CAP: per 1 USD GNI per capita>,\n",
       " <Code PER_100: Per 100>,\n",
       " <Code PER_1000_UNINFECTED_POP: Per 1000 uninfected population>,\n",
       " <Code PER_POP_U5: Per population under 5>,\n",
       " <Code PPP_CONST: Constant PPP$ (Purchasing Power Parity)>,\n",
       " <Code PPP_CUR: Current PPP$ (Purchasing Power Parity)>,\n",
       " <Code PPY: Annual % point change per year>,\n",
       " <Code PROB: Probability>,\n",
       " <Code PS: Persons>,\n",
       " <Code RATE_100: Rate per 100 of Population>,\n",
       " <Code RATE_1000: Rate per 1,000 of Population>,\n",
       " <Code RATE_100000: Rate per 100,000 of Population>,\n",
       " <Code RATE_1M: Rate per 1,000,000 of Population>,\n",
       " <Code RATIO: Ratio>,\n",
       " <Code SB_PER_1000_B: Stillbirths per 1,000 total births>,\n",
       " <Code SCORE: Learning Outcomes Score>,\n",
       " <Code STILLBIRTHS: Number of stillbirths>,\n",
       " <Code USD: USD>,\n",
       " <Code USD_CONST: Constant US$>,\n",
       " <Code USD_CUR: Current US$>,\n",
       " <Code WPI: Wealth Parity Index>,\n",
       " <Code WPIA: Adjusted wealth parity index>,\n",
       " <Code YR: Years>]"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(dsd.attributes.get('UNIT_MEASURE').local_representation.enumerated)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "61"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "units=list(dsd.attributes.get('UNIT_MEASURE').local_representation.enumerated)\n",
    "len(units)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'BIRTHSPER1000WOMEN'"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "unit=list(dsd.attributes.get('UNIT_MEASURE').local_representation.enumerated)[2]\n",
    "unit.id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<PrimaryMeasure OBS_VALUE>]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dsd.measures.components"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<DimensionDescriptor: <Dimension REF_AREA>; <Dimension INDICATOR>; <Dimension SEX>; <Dimension AGE>; <Dimension RESIDENCE>; <Dimension WEALTH_QUINTILE>; <TimeDimension TIME_PERIOD>>"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dsd.dimensions"
   ]
  },
  {
   "cell_type": "code",

   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "DEFAULT_DIMENSIONS = [\n",
    "    \"SEX\",\n",
    "    \"RESIDENCE\",\n",
    "    \"WEALTH_QUINTILE\",\n",
    "    \"AGE\",\n",
    "    \"TOTAL\"\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "with open(\"./transmonee_dashboard/src/transmonee_dashboard/pages/indicator_config.json\") as config_file:\n",
    "    indicators_config = json.load(config_file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'SEX': {'SEX': ['F', 'M']}, 'TOTAL': {'SEX': ['_T']}}\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'INDICATOR': ['CME_MRY0'], 'SEX': ['F']}"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indicators = [\"CME_MRY0\"]\n",
    "keys = dict(INDICATOR=indicators)\n",
    "dimensions = {\"SEX\": [\"F\"]}\n",
    "keys.update(dimensions)\n",
    "for indicator in indicators:\n",
    "    indicator_config = indicators_config.get(indicator, {})\n",
    "    print(indicator_config)\n",
    "    for dim in dimensions.keys():\n",
    "        # if the dimension is in the config and has not overridden here\n",
    "        if (dim in keys and dim in indicator_config) and not keys[dim]:\n",
    "            # replace the empty with the config value\n",
    "            keys.pop(dim)\n",
    "            keys.update(indicator_config[dim])\n",
    "    \n",
    "keys"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/usr/local/lib/python3.9/site-packages/pandasdmx/api.py:260: UserWarning: 'provider' argument is redundant for <Resource.data: 'data'>\n",
      "  warn(f\"'provider' argument is redundant for {resource_type!r}\")\n"
     ]
    }
   ],
   "source": [
    "message = unicef.data(\n",
    "    \"TRANSMONEE\", \n",
    "    provider=\"ECARO\", \n",
    "    key={\n",
    "        'INDICATOR': ['EDUNF_ADMIN_L2_MAT'],\n",
    "        'SEX': ['_T'],\n",
    "        'RESIDENCE': ['_T'],\n",
    "        'WEALTH_QUINTILE': ['_T']\n",
    "    }, \n",
    "    params = dict(startPeriod='2010', endPeriod='2021', lastNObservations=1), \n",
    "    dsd=dsd\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "message.response.from_cache"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://sdmx.data.unicef.org/ws/public/sdmxapi/rest/data/TRANSMONEE/.EDUNF_OFST_L1+EDUNF_OFST_L2+EDUNF_OFST_L3.F+M.._T._T?startPeriod=2010&endPeriod=2021&lastNObservations=1&labels=True'"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "message.response.url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "ename": "SyntaxError",
     "evalue": "invalid syntax (<ipython-input-20-f51f2b5b6cdf>, line 1)",
     "output_type": "error",
     "traceback": [
      "\u001b[0;36m  File \u001b[0;32m\"<ipython-input-20-f51f2b5b6cdf>\"\u001b[0;36m, line \u001b[0;32m1\u001b[0m\n\u001b[0;31m    https://sdmx.data.unicef.org/ws/public/sdmxapi/rest/data/TRANSMONEE/ALB+AND+ARM+AUT+AZE+BEL+BGR+BIH+BLR+CHE+CYP+CZE+DEU+DNK+ESP+EST+FIN+FRA+GBR+GEO+GRC+HRV+HUN+IRL+ISL+ITA+KAZ+KGZ+LIE+LTU+LUX+LVA+MCO+MDA+MKD+MLT+MNE+NLD+NOR+POL+PRT+ROU+RUS+SMR+SRB+SVK+SVN+SWE+TJK+TKM+TUR+UKR+UZB+VAT+XKX.EDUNF_OFST_L1+EDUNF_OFST_L2+EDUNF_OFST_L3._T._T._T._T?startPeriod=2010&endPeriod=2020&lastNObservations=1\u001b[0m\n\u001b[0m          ^\u001b[0m\n\u001b[0;31mSyntaxError\u001b[0m\u001b[0;31m:\u001b[0m invalid syntax\n"
     ]
    }
   ],
   "source": [
    "https://sdmx.data.unicef.org/ws/public/sdmxapi/rest/data/TRANSMONEE/ALB+AND+ARM+AUT+AZE+BEL+BGR+BIH+BLR+CHE+CYP+CZE+DEU+DNK+ESP+EST+FIN+FRA+GBR+GEO+GRC+HRV+HUN+IRL+ISL+ITA+KAZ+KGZ+LIE+LTU+LUX+LVA+MCO+MDA+MKD+MLT+MNE+NLD+NOR+POL+PRT+ROU+RUS+SMR+SRB+SVK+SVN+SWE+TJK+TKM+TUR+UKR+UZB+VAT+XKX.EDUNF_OFST_L1+EDUNF_OFST_L2+EDUNF_OFST_L3._T._T._T._T?startPeriod=2010&endPeriod=2020&lastNObservations=1 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = message.to_pandas(attributes=\"o\", rtype=\"rows\", dtype=\"str\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "FrozenList([None])"
      ]
     },
     "execution_count": 272,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns.names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'Index' object has no attribute 'levels'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "Input \u001b[0;32mIn [273]\u001b[0m, in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0m \u001b[43mdf\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mcolumns\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mlevels\u001b[49m\n",
      "\u001b[0;31mAttributeError\u001b[0m: 'Index' object has no attribute 'levels'"
     ]
    }
   ],
   "source": [
    "df.columns.levels"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2010-01-01', '2011-01-01'], dtype='datetime64[ns]', name='TIME_PERIOD', freq=None)"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "6"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df.columns.levels)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.columns = df.columns.droplevel(-1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>value</th>\n",
       "      <th>UNIT_MEASURE</th>\n",
       "      <th>FREQ</th>\n",
       "      <th>DATA_SOURCE</th>\n",
       "      <th>UNIT_MULTIPLIER</th>\n",
       "      <th>OBS_STATUS</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REF_AREA</th>\n",
       "      <th>INDICATOR</th>\n",
       "      <th>SEX</th>\n",
       "      <th>AGE</th>\n",
       "      <th>RESIDENCE</th>\n",
       "      <th>WEALTH_QUINTILE</th>\n",
       "      <th>TIME_PERIOD</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>AND</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>No</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALB</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARM</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AUT</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AZE</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>No</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BIH</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BEL</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BGR</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BLR</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHE</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CYP</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CZE</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DEU</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DNK</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EST</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ESP</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FIN</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FRA</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GBR</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GEO</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GRC</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HRV</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HUN</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IRL</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ISL</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ITA</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KGZ</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KAZ</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LIE</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>No</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LTU</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LUX</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LVA</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MCO</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>No</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MDA</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MNE</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MKD</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MLT</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NLD</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOR</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>POL</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PRT</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ROU</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SRB</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RUS</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SWE</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SVN</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SVK</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SMR</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>No</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TJK</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>No</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TKM</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>No</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TUR</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UKR</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>Yes</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UZB</th>\n",
       "      <th>EDUNF_ADMIN_L2_MAT</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>2018</th>\n",
       "      <td>No</td>\n",
       "      <td>BINARY</td>\n",
       "      <td>1</td>\n",
       "      <td>UNESCO</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                          value  \\\n",
       "REF_AREA INDICATOR          SEX AGE RESIDENCE WEALTH_QUINTILE TIME_PERIOD         \n",
       "AND      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           No   \n",
       "ALB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "ARM      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "AUT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "AZE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           No   \n",
       "BIH      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "BEL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "BGR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "BLR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "CHE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "CYP      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "CZE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "DEU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "DNK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "EST      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "ESP      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "FIN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "FRA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "GBR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "GEO      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "GRC      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "HRV      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "HUN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "IRL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "ISL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "ITA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "KGZ      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "KAZ      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "LIE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           No   \n",
       "LTU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "LUX      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "LVA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "MCO      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           No   \n",
       "MDA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "MNE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "MKD      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "MLT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "NLD      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "NOR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "POL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "PRT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "ROU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "SRB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "RUS      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "SWE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "SVN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "SVK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "SMR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           No   \n",
       "TJK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           No   \n",
       "TKM      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           No   \n",
       "TUR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "UKR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018          Yes   \n",
       "UZB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           No   \n",
       "\n",
       "                                                                          UNIT_MEASURE  \\\n",
       "REF_AREA INDICATOR          SEX AGE RESIDENCE WEALTH_QUINTILE TIME_PERIOD                \n",
       "AND      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "ALB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "ARM      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "AUT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "AZE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "BIH      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "BEL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "BGR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "BLR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "CHE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "CYP      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "CZE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "DEU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "DNK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "EST      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "ESP      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "FIN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "FRA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "GBR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "GEO      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "GRC      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "HRV      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "HUN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "IRL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "ISL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "ITA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "KGZ      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "KAZ      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "LIE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "LTU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "LUX      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "LVA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "MCO      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "MDA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "MNE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "MKD      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "MLT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "NLD      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "NOR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "POL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "PRT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "ROU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "SRB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "RUS      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "SWE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "SVN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "SVK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "SMR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "TJK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "TKM      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "TUR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "UKR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "UZB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018              BINARY   \n",
       "\n",
       "                                                                          FREQ  \\\n",
       "REF_AREA INDICATOR          SEX AGE RESIDENCE WEALTH_QUINTILE TIME_PERIOD        \n",
       "AND      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "ALB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "ARM      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "AUT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "AZE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "BIH      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "BEL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "BGR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "BLR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "CHE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "CYP      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "CZE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "DEU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "DNK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "EST      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "ESP      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "FIN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "FRA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "GBR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "GEO      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "GRC      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "HRV      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "HUN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "IRL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "ISL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "ITA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "KGZ      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "KAZ      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "LIE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "LTU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "LUX      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "LVA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "MCO      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "MDA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "MNE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "MKD      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "MLT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "NLD      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "NOR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "POL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "PRT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "ROU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "SRB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "RUS      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "SWE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "SVN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "SVK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "SMR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "TJK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "TKM      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "TUR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "UKR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "UZB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018           1   \n",
       "\n",
       "                                                                          DATA_SOURCE  \\\n",
       "REF_AREA INDICATOR          SEX AGE RESIDENCE WEALTH_QUINTILE TIME_PERIOD               \n",
       "AND      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "ALB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "ARM      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "AUT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "AZE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "BIH      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "BEL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "BGR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "BLR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "CHE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "CYP      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "CZE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "DEU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "DNK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "EST      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "ESP      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "FIN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "FRA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "GBR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "GEO      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "GRC      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "HRV      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "HUN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "IRL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "ISL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "ITA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "KGZ      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "KAZ      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "LIE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "LTU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "LUX      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "LVA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "MCO      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "MDA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "MNE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "MKD      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "MLT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "NLD      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "NOR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "POL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "PRT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "ROU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "SRB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "RUS      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "SWE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "SVN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "SVK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "SMR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "TJK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "TKM      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "TUR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "UKR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "UZB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018             UNESCO   \n",
       "\n",
       "                                                                          UNIT_MULTIPLIER  \\\n",
       "REF_AREA INDICATOR          SEX AGE RESIDENCE WEALTH_QUINTILE TIME_PERIOD                   \n",
       "AND      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "ALB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "ARM      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "AUT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "AZE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "BIH      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "BEL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "BGR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "BLR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "CHE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "CYP      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "CZE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "DEU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "DNK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "EST      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "ESP      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "FIN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "FRA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "GBR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "GEO      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "GRC      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "HRV      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "HUN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "IRL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "ISL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "ITA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "KGZ      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "KAZ      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "LIE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "LTU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "LUX      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "LVA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "MCO      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "MDA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "MNE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "MKD      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "MLT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "NLD      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "NOR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "POL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "PRT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "ROU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "SRB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "RUS      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "SWE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "SVN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "SVK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "SMR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "TJK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "TKM      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "TUR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "UKR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "UZB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                      0   \n",
       "\n",
       "                                                                          OBS_STATUS  \n",
       "REF_AREA INDICATOR          SEX AGE RESIDENCE WEALTH_QUINTILE TIME_PERIOD             \n",
       "AND      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "ALB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "ARM      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "AUT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "AZE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "BIH      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "BEL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "BGR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "BLR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "CHE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "CYP      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "CZE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "DEU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "DNK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "EST      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "ESP      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "FIN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "FRA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "GBR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "GEO      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "GRC      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "HRV      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "HUN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "IRL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "ISL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "ITA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "KGZ      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "KAZ      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "LIE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "LTU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "LUX      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "LVA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "MCO      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "MDA      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "MNE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "MKD      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "MLT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "NLD      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "NOR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "POL      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "PRT      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "ROU      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "SRB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "RUS      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "SWE      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "SVN      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "SVK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "SMR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "TJK      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "TKM      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "TUR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "UKR      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  \n",
       "UZB      EDUNF_ADMIN_L2_MAT _T  _T  _T        _T              2018                 A  "
      ]
     },
     "execution_count": 305,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['OVER_AGE', 'SCHOOL_AGE', 'UNDER_AGE'], dtype=object)"
      ]
     },
     "execution_count": 287,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"AGE\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th>REF_AREA</th>\n",
       "      <th colspan=\"10\" halign=\"left\">AUT</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"10\" halign=\"left\">TUR</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INDICATOR</th>\n",
       "      <th colspan=\"10\" halign=\"left\">HT_ADOL_UNMETMED_NOUNMET</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"10\" halign=\"left\">HT_ADOL_UNMETMED_NOUNMET</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SEX</th>\n",
       "      <th colspan=\"10\" halign=\"left\">_T</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"10\" halign=\"left\">_T</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AGE</th>\n",
       "      <th>Y16T19</th>\n",
       "      <th>Y16T24</th>\n",
       "      <th>Y16T29</th>\n",
       "      <th>Y16T44</th>\n",
       "      <th>Y16T64</th>\n",
       "      <th>Y18T44</th>\n",
       "      <th>Y20T24</th>\n",
       "      <th>Y20T29</th>\n",
       "      <th>Y25T29</th>\n",
       "      <th>Y25T34</th>\n",
       "      <th>...</th>\n",
       "      <th>Y35T44</th>\n",
       "      <th>Y45T54</th>\n",
       "      <th>Y45T64</th>\n",
       "      <th>Y55T64</th>\n",
       "      <th>Y65T74</th>\n",
       "      <th>Y75T84</th>\n",
       "      <th>Y_GE16</th>\n",
       "      <th>Y_GE65</th>\n",
       "      <th>Y_GE75</th>\n",
       "      <th>Y_GE85</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RESIDENCE</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>...</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WEALTH_QUINTILE</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>...</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</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>2010-01-01</th>\n",
       "      <td>96.3</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.2</td>\n",
       "      <td>97.2</td>\n",
       "      <td>97.4</td>\n",
       "      <td>97.1</td>\n",
       "      <td>97.4</td>\n",
       "      <td>97.6</td>\n",
       "      <td>97.7</td>\n",
       "      <td>97.6</td>\n",
       "      <td>...</td>\n",
       "      <td>72.9</td>\n",
       "      <td>74.4</td>\n",
       "      <td>75.9</td>\n",
       "      <td>78.1</td>\n",
       "      <td>77.5</td>\n",
       "      <td>79.2</td>\n",
       "      <td>78.3</td>\n",
       "      <td>77.7</td>\n",
       "      <td>78.1</td>\n",
       "      <td>68.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-01</th>\n",
       "      <td>98.3</td>\n",
       "      <td>98.4</td>\n",
       "      <td>98.4</td>\n",
       "      <td>97.9</td>\n",
       "      <td>97.9</td>\n",
       "      <td>97.9</td>\n",
       "      <td>98.4</td>\n",
       "      <td>98.4</td>\n",
       "      <td>98.4</td>\n",
       "      <td>97.7</td>\n",
       "      <td>...</td>\n",
       "      <td>77.9</td>\n",
       "      <td>80.5</td>\n",
       "      <td>81.3</td>\n",
       "      <td>82.6</td>\n",
       "      <td>80.9</td>\n",
       "      <td>80.2</td>\n",
       "      <td>82.9</td>\n",
       "      <td>80.4</td>\n",
       "      <td>79.6</td>\n",
       "      <td>75.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 658 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "REF_AREA                             AUT                                     \\\n",
       "INDICATOR       HT_ADOL_UNMETMED_NOUNMET                                      \n",
       "SEX                                   _T                                      \n",
       "AGE                               Y16T19 Y16T24 Y16T29 Y16T44 Y16T64 Y18T44   \n",
       "RESIDENCE                             _T     _T     _T     _T     _T     _T   \n",
       "WEALTH_QUINTILE                       _T     _T     _T     _T     _T     _T   \n",
       "TIME_PERIOD                                                                   \n",
       "2010-01-01                          96.3   97.0   97.2   97.2   97.4   97.1   \n",
       "2011-01-01                          98.3   98.4   98.4   97.9   97.9   97.9   \n",
       "\n",
       "REF_AREA                                     ...                      TUR  \\\n",
       "INDICATOR                                    ... HT_ADOL_UNMETMED_NOUNMET   \n",
       "SEX                                          ...                       _T   \n",
       "AGE             Y20T24 Y20T29 Y25T29 Y25T34  ...                   Y35T44   \n",
       "RESIDENCE           _T     _T     _T     _T  ...                       _T   \n",
       "WEALTH_QUINTILE     _T     _T     _T     _T  ...                       _T   \n",
       "TIME_PERIOD                                  ...                            \n",
       "2010-01-01        97.4   97.6   97.7   97.6  ...                     72.9   \n",
       "2011-01-01        98.4   98.4   98.4   97.7  ...                     77.9   \n",
       "\n",
       "REF_AREA                                                                        \n",
       "INDICATOR                                                                       \n",
       "SEX                                                                             \n",
       "AGE             Y45T54 Y45T64 Y55T64 Y65T74 Y75T84 Y_GE16 Y_GE65 Y_GE75 Y_GE85  \n",
       "RESIDENCE           _T     _T     _T     _T     _T     _T     _T     _T     _T  \n",
       "WEALTH_QUINTILE     _T     _T     _T     _T     _T     _T     _T     _T     _T  \n",
       "TIME_PERIOD                                                                     \n",
       "2010-01-01        74.4   75.9   78.1   77.5   79.2   78.3   77.7   78.1   68.6  \n",
       "2011-01-01        80.5   81.3   82.6   80.9   80.2   82.9   80.4   79.6   75.8  \n",
       "\n",
       "[2 rows x 658 columns]"
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.xs(('_T', '_T'), level=('SEX', 'RESIDENCE'), axis=1, drop_level=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.columns = df.columns.droplevel(-1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th>REF_AREA</th>\n",
       "      <th colspan=\"10\" halign=\"left\">AUT</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"10\" halign=\"left\">TUR</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INDICATOR</th>\n",
       "      <th colspan=\"10\" halign=\"left\">HT_ADOL_UNMETMED_NOUNMET</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"10\" halign=\"left\">HT_ADOL_UNMETMED_NOUNMET</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SEX</th>\n",
       "      <th colspan=\"10\" halign=\"left\">_T</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"10\" halign=\"left\">_T</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AGE</th>\n",
       "      <th>Y16T19</th>\n",
       "      <th>Y16T24</th>\n",
       "      <th>Y16T29</th>\n",
       "      <th>Y16T44</th>\n",
       "      <th>Y16T64</th>\n",
       "      <th>Y18T44</th>\n",
       "      <th>Y20T24</th>\n",
       "      <th>Y20T29</th>\n",
       "      <th>Y25T29</th>\n",
       "      <th>Y25T34</th>\n",
       "      <th>...</th>\n",
       "      <th>Y35T44</th>\n",
       "      <th>Y45T54</th>\n",
       "      <th>Y45T64</th>\n",
       "      <th>Y55T64</th>\n",
       "      <th>Y65T74</th>\n",
       "      <th>Y75T84</th>\n",
       "      <th>Y_GE16</th>\n",
       "      <th>Y_GE65</th>\n",
       "      <th>Y_GE75</th>\n",
       "      <th>Y_GE85</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RESIDENCE</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>...</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</th>\n",
       "      <th>_T</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>2010-01-01</th>\n",
       "      <td>96.3</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.2</td>\n",
       "      <td>97.2</td>\n",
       "      <td>97.4</td>\n",
       "      <td>97.1</td>\n",
       "      <td>97.4</td>\n",
       "      <td>97.6</td>\n",
       "      <td>97.7</td>\n",
       "      <td>97.6</td>\n",
       "      <td>...</td>\n",
       "      <td>72.9</td>\n",
       "      <td>74.4</td>\n",
       "      <td>75.9</td>\n",
       "      <td>78.1</td>\n",
       "      <td>77.5</td>\n",
       "      <td>79.2</td>\n",
       "      <td>78.3</td>\n",
       "      <td>77.7</td>\n",
       "      <td>78.1</td>\n",
       "      <td>68.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-01</th>\n",
       "      <td>98.3</td>\n",
       "      <td>98.4</td>\n",
       "      <td>98.4</td>\n",
       "      <td>97.9</td>\n",
       "      <td>97.9</td>\n",
       "      <td>97.9</td>\n",
       "      <td>98.4</td>\n",
       "      <td>98.4</td>\n",
       "      <td>98.4</td>\n",
       "      <td>97.7</td>\n",
       "      <td>...</td>\n",
       "      <td>77.9</td>\n",
       "      <td>80.5</td>\n",
       "      <td>81.3</td>\n",
       "      <td>82.6</td>\n",
       "      <td>80.9</td>\n",
       "      <td>80.2</td>\n",
       "      <td>82.9</td>\n",
       "      <td>80.4</td>\n",
       "      <td>79.6</td>\n",
       "      <td>75.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 658 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "REF_AREA                         AUT                                     \\\n",
       "INDICATOR   HT_ADOL_UNMETMED_NOUNMET                                      \n",
       "SEX                               _T                                      \n",
       "AGE                           Y16T19 Y16T24 Y16T29 Y16T44 Y16T64 Y18T44   \n",
       "RESIDENCE                         _T     _T     _T     _T     _T     _T   \n",
       "TIME_PERIOD                                                               \n",
       "2010-01-01                      96.3   97.0   97.2   97.2   97.4   97.1   \n",
       "2011-01-01                      98.3   98.4   98.4   97.9   97.9   97.9   \n",
       "\n",
       "REF_AREA                                 ...                      TUR         \\\n",
       "INDICATOR                                ... HT_ADOL_UNMETMED_NOUNMET          \n",
       "SEX                                      ...                       _T          \n",
       "AGE         Y20T24 Y20T29 Y25T29 Y25T34  ...                   Y35T44 Y45T54   \n",
       "RESIDENCE       _T     _T     _T     _T  ...                       _T     _T   \n",
       "TIME_PERIOD                              ...                                   \n",
       "2010-01-01    97.4   97.6   97.7   97.6  ...                     72.9   74.4   \n",
       "2011-01-01    98.4   98.4   98.4   97.7  ...                     77.9   80.5   \n",
       "\n",
       "REF_AREA                                                             \n",
       "INDICATOR                                                            \n",
       "SEX                                                                  \n",
       "AGE         Y45T64 Y55T64 Y65T74 Y75T84 Y_GE16 Y_GE65 Y_GE75 Y_GE85  \n",
       "RESIDENCE       _T     _T     _T     _T     _T     _T     _T     _T  \n",
       "TIME_PERIOD                                                          \n",
       "2010-01-01    75.9   78.1   77.5   79.2   78.3   77.7   78.1   68.6  \n",
       "2011-01-01    81.3   82.6   80.9   80.2   82.9   80.4   79.6   75.8  \n",
       "\n",
       "[2 rows x 658 columns]"
      ]
     },
     "execution_count": 135,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/homebrew/Caskroom/miniforge/base/envs/dash/lib/python3.9/site-packages/jupyter_dash/jupyter_app.py:139: UserWarning:\n",
      "\n",
      "The 'environ['werkzeug.server.shutdown']' function is deprecated and will be removed in Werkzeug 2.1.\n",
      "\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "        <iframe\n",
       "            width=\"100%\"\n",
       "            height=\"650\"\n",
       "            src=\"http://127.0.0.1:8050/\"\n",
       "            frameborder=\"0\"\n",
       "            allowfullscreen\n",
       "            \n",
       "        ></iframe>\n",
       "        "
      ],
      "text/plain": [
       "<IPython.lib.display.IFrame at 0x1568c9ee0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Build App\n",
    "app = JupyterDash(__name__)\n",
    "app.layout = html.Div([\n",
    "    dcc.Graph(id='graph', figure=px.bar(df, x='REF_AREA', y='value', color='SEX', barmode='group', title='Indicator')),\n",
    "    \n",
    "])\n",
    "# # Define callback to update graph\n",
    "# @app.callback(\n",
    "#     Output('graph', 'figure'),\n",
    "#     [Input(\"colorscale-dropdown\", \"value\")]\n",
    "# )\n",
    "# def update_figure(colorscale):\n",
    "#     return px.scatter(\n",
    "#         df, x=\"total_bill\", y=\"tip\", color=\"size\",\n",
    "#         color_continuous_scale=colorscale,\n",
    "#         render_mode=\"webgl\", title=\"Tips\"\n",
    "#     )\n",
    "# Run app and display result inline in the notebook\n",
    "del app.config._read_only[\"requests_pathname_prefix\"]\n",
    "app.run_server(mode='inline')"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "0aa7b01207476ce8330e11dbd19b34c75771f5f59308d9cb7bdeaaa98916ea6b"
  },
  "kernelspec": {
   "display_name": "Python 3.9.7 ('azure')",
   "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.9.7"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}