census_table_via_api.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Census 2022 Results for Germany - Accessing the Data API with Python/Pandas\n",
    "Get your free account at  \n",
    "https://ergebnisse2011.zensus2022.de/datenbank/online#modal=register  \n",
    "API Documentation (latest update 2023-11-27)  \n",
    "German\n",
    "https://ergebnisse2011.zensus2022.de/datenbank/online/docs/ZENSUS-Webservices_Einfuehrung.pdf  \n",
    "English\n",
    "https://ergebnisse2011.zensus2022.de/datenbank/online/docs/ZENSUS-Webservices_Introduction.pdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import requests\n",
    "import json\n",
    "# credentials in hidden file\n",
    "from dotenv import dotenv_values, load_dotenv\n",
    "# timestamps\n",
    "import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2.1.1'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.__version__"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# convenience function for timestamps while logging\n",
    "def tStamp():\n",
    "    return datetime.datetime.now().strftime(\"%Y-%m-%d %H:%M:%S\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Set your download directory"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# e.g. relative to current working directory\n",
    "myDownloads = \"download/\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "# Load credentials from .env file\n",
    "load_dotenv()  \n",
    "usr, pwd = dotenv_values().values()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "tags": []
   },
   "source": [
    "## URL will likely change with 2022 results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "# Set base path for API calls\n",
    "BASE_URL = 'https://ergebnisse2011.zensus2022.de/api/rest/2020/'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Check credentials, network and endpoint availability\n",
    "Status may also return 'exceeded limit of parallel jobs'  \n",
    "which can happen after too many failures and will suspend the user temporarily"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "You have been logged in and out successfully!\n"
     ]
    }
   ],
   "source": [
    "try:\n",
    "    hello = requests.get(BASE_URL + 'helloworld/logincheck', params={\n",
    "        'username': usr,\n",
    "        'password': pwd,\n",
    "        'language': 'en'\n",
    "        }, timeout=300)\n",
    "    \n",
    "    print(hello.json()[\"Status\"])\n",
    "\n",
    "except:\n",
    "    print(tStamp(), usr, hello)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Basic table download function\n",
    "* be kind to the database\n",
    "* only request the data-depth that you need\n",
    "* download municipality data to disk, it changes only once a decade\n",
    "* parallel downloads don't work"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# this takes a RESTful/JSON response as input\n",
    "# usually from the 'data/tablefile' service\n",
    "# covers up to 2 dimensions, may be extended up to classifyingvariable5\n",
    "\n",
    "def response2disk(resp, classVar1=\"\", classKey1=\"\", classVar2=\"\", classKey2=\"\"):\n",
    "\n",
    "    filename = resp.headers[\"Content-Disposition\"].split(\"=\")[1].replace('\"','').replace('.zip','')\n",
    "\n",
    "    # writing the modifications of the table into the filename\n",
    "    destination = myDownloads+filename+\"_\"+classVar1+\"_\"+classKey1+\"_\"+classVar2+\"_\"+classKey2+\".zip\"\n",
    "    # beware we now have a zip-archive that contains a csv with a much shorter name (without classVar/classKey)\n",
    "\n",
    "    # in case of asterisk notation convert to sensible filename\n",
    "    with open(destination.replace(\"*\",\"x\"), 'wb') as f:\n",
    "        \n",
    "        f.write(resp.content)\n",
    "\n",
    "    print(tStamp(), filename, \"download complete\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Method “tablefile“ starts a value retrieval and returns a table\n",
    "* example function fetches municipal data for selected regions (SH, HH, NI, MV)\n",
    "* this makes sense if your repeated table requests always cover the same region \n",
    "* make sure regionalvariable exists for table in question\n",
    "* e.g. 2000S (sample) tables are only available for GEOGM3 (pop >10k)\n",
    "* there can be up to 5 pairs of classifying-variable and -key"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "def tab2download(tablename, classVar1=\"\", classKey1=\"\", classVar2=\"\", classKey2=\"\"):\n",
    "\n",
    "    if tablename.find(\"S\") == 4:\n",
    "\n",
    "        regio = \"GEOGM3\" # municipalities, pop >10k\n",
    "    \n",
    "    else:\n",
    "\n",
    "        regio = \"GEOGM1\" # municipalities, 11k for all of Germany\n",
    "    \n",
    "    try:\n",
    "\n",
    "        response = requests.get(BASE_URL + 'data/tablefile', params={\n",
    "            'username': usr,\n",
    "            'password': pwd,\n",
    "            'name': tablename,\n",
    "            'regionalvariable': regio,       \n",
    "            'regionalkey': \"01*,02*,03*,13*\",  # e.g. NDR Sendegebiet\n",
    "            'classifyingvariable1': classVar1,\n",
    "            'classifyingkey1': classKey1,           \n",
    "            'classifyingvariable2': classVar2,\n",
    "            'classifyingkey2': classKey2,\n",
    "            #'startyear': 2011,\n",
    "            'format': \"ffcsv\",\n",
    "            'quality': \"on\", # include quality symbols, see below\n",
    "            'language': \"de\",\n",
    "            'job': \"false\"   # get the data directly\n",
    "            }, timeout=600)  # large tables may take some time\n",
    "\n",
    "        try:\n",
    "            response2disk(response, classVar1, classKey1, classVar2, classKey2)  # save to disk for re-use\n",
    "            myFilename = myDownloads+tablename+\"_de_flat_\"+classVar1+\"_\"+classKey1+\"_\"+classVar2+\"_\"+classKey2+\".zip\"\n",
    "            return(tab2df(myFilename.replace(\"*\",\"x\")))\n",
    "            \n",
    "        except:\n",
    "        \n",
    "            if response.status_code == 200:\n",
    "                \n",
    "                # here the api will tell you if your request could not be processed\n",
    "                # e.g.\n",
    "                # 'Code': 25, 'Content': 'Mindestens ein Parameter enthält ungültige Werte'\n",
    "                # 'Code': 90, 'Content': 'Die angeforderte Tabelle ist nicht vorhanden.'\n",
    "                \n",
    "                try:\n",
    "                    print(tStamp()+\" : \"+tablename+\" : \"+str(response.json()[\"Status\"])[0:80])\n",
    "                except:\n",
    "                    # in case response isn't json formatted\n",
    "                    print(tStamp()+\" : \"+tablename+\" : \"+str(response.text[0:300]))\n",
    "            \n",
    "            else:\n",
    "                # log if api times out or otherwise disconnects (500, 404...)\n",
    "                print(tStamp()+\" : \"+tablename+\" http code \"+str(response.status_code))\n",
    "\n",
    "    except requests.exceptions.Timeout:\n",
    "\n",
    "        # log if this request has hit its own timeout limit as set above\n",
    "        print(tStamp()+\" : \"+tablename + \" timed out\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Check if table has been downloaded before, then download or load"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "def tab2reuse(tablename, classVar1=\"\", classKey1=\"\", classVar2=\"\", classKey2=\"\"):\n",
    "\n",
    "    # check if desired table is already available locally\n",
    "    myFilename = myDownloads+tablename+\"_de_flat_\"+classVar1+\"_\"+classKey1+\"_\"+classVar2+\"_\"+classKey2+\".zip\"\n",
    "    try:\n",
    "        myDF = tab2df(myFilename.replace(\"*\",\"x\"))\n",
    "    except:\n",
    "        print(\"... will fetch from database, thank you for your patience ...\")\n",
    "        myDF = tab2download(tablename, classVar1, classKey1, classVar2, classKey2)\n",
    "    return(myDF)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### ffcsv will be delivered as zip starting Feb 5th, 2024"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "from zipfile import ZipFile"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# New flatfile csv (ffcsv) datastructure\n",
    "* identical english variable lables in both en/de localizations\n",
    "* Colon `;` delimited for both de/en\n",
    "* Decimal point `.` in English but comma `,` in German\n",
    "* utf-8 via API (as always) and utf-8 with BOM via web\n",
    "* currently not sorted by regional key (may change in the future)\n",
    "* only one `value` column\n",
    "* counts and percentages mixed in this value\n",
    "* observe `value_unit` to see which is which\n",
    "* see `value_q` for how to interpret the data (see explanation of symbols above)\n",
    "* ffcsv always comes zip-compressed with matching filename of .zip and .csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "def tab2df(ffcsv):\n",
    "    zip_file = ZipFile(ffcsv)\n",
    "    # name of internal csv file without classVar/classKey\n",
    "    zcsv = ffcsv.split(myDownloads)[1][:18]+\".csv\"\n",
    "    # decimal setting for german default\n",
    "    df = pd.read_csv(zip_file.open(zcsv), delimiter = ';', decimal = \",\",\n",
    "                     # quality indicators (strings) may replace numerical values\n",
    "                     na_values = [\"...\",\".\",\"-\",\"/\",\"x\"],\n",
    "                     # regional key (ARS, AGS) has leading zeroes, force as string\n",
    "                     dtype = {\"1_variable_attribute_code\": str})\n",
    "\n",
    "    print(ffcsv, \"is ready to use\")\n",
    "    return(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Explanation of symbols\n",
    "`e`   final value  \n",
    "`-`   Exactly zero or adjusted to zero  \n",
    "`()`  Limited information value because the numerical value may have been modified relatively strongly by the confidentiality procedure\n",
    "#### for Sample Data\n",
    "`/`   No data because the numerical value is not sufficiently reliable  \n",
    "`-`   no figures"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Example Table \"5000H-2005\" \n",
    "#### Haushalte: Größe des privaten Haushalts - Ausstattung der Wohnung/Fläche der Wohnung (20 m²-Intervalle)/Räume\n",
    "Notice the slashes: On the second axis `/` denote variable features of which the first is selected by default  \n",
    "Maybe experiment with all the options on the web first, switch on 'code' wherever possible, then come back here  \n",
    "https://ergebnisse2011.zensus2022.de/datenbank/online/statistic/5000H/table/5000H-2005"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "... will fetch from database, thank you for your patience ...\n",
      "2024-02-06 08:59:03 : 5000H-2905 : {'Code': 2, 'Content': 'Ein Fehler ist aufgetreten.', 'Type': 'Fehler'}\n"
     ]
    }
   ],
   "source": [
    "# download single table, deliberate typo, table doesn't exist\n",
    "myTable = tab2reuse(\"5000H-2905\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "download/5000H-2005_de_flat____.zip is ready to use\n"
     ]
    }
   ],
   "source": [
    "# try again, now with correct name\n",
    "myTable = tab2reuse(\"5000H-2005\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Switching to \"Fläche der Wohnung (20 m²-Intervalle)\" instead of the default \"Ausstattung der Wohnung\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "... will fetch from database, thank you for your patience ...\n",
      "2024-02-05 22:20:14 5000H-2005_de_flat download complete\n",
      "download/5000H-2005_de_flat_HSHGR2__WHGFL3_.zip is ready to use\n"
     ]
    }
   ],
   "source": [
    "# variable features switched\n",
    "myTable = tab2reuse(\"5000H-2005\", \"HSHGR2\", \"\", \"WHGFL3\", \"\")\n",
    "# as of May 23rd, 2024 \"\" or * for classKey are selecting all keys as expected"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "... will fetch from database, thank you for your patience ...\n",
      "2024-02-06 08:53:19 5000H-2005_de_flat download complete\n",
      "download/5000H-2005_de_flat_HSHGR2_x_WHGRM2_x.zip is ready to use\n"
     ]
    }
   ],
   "source": [
    "# asterisk notation, gets converted to x in filenames\n",
    "myTable = tab2reuse(\"5000H-2005\", \"HSHGR2\", \"*\", \"WHGRM2\", \"*\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>statistics_code</th>\n",
       "      <th>statistics_label</th>\n",
       "      <th>time_code</th>\n",
       "      <th>time_label</th>\n",
       "      <th>time</th>\n",
       "      <th>1_variable_code</th>\n",
       "      <th>1_variable_label</th>\n",
       "      <th>1_variable_attribute_code</th>\n",
       "      <th>1_variable_attribute_label</th>\n",
       "      <th>2_variable_code</th>\n",
       "      <th>...</th>\n",
       "      <th>2_variable_attribute_label</th>\n",
       "      <th>3_variable_code</th>\n",
       "      <th>3_variable_label</th>\n",
       "      <th>3_variable_attribute_code</th>\n",
       "      <th>3_variable_attribute_label</th>\n",
       "      <th>value</th>\n",
       "      <th>value_unit</th>\n",
       "      <th>value_variable_code</th>\n",
       "      <th>value_variable_label</th>\n",
       "      <th>value_q</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>130625214065</td>\n",
       "      <td>Züsedom</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>120</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>130535312003</td>\n",
       "      <td>Altkalen</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>337</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010615153056</td>\n",
       "      <td>Kremperheide</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>1037</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>031515407033</td>\n",
       "      <td>Ummern</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>588</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>033560005005</td>\n",
       "      <td>Lilienthal</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>7875</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2944</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>130560072072</td>\n",
       "      <td>Waren (Müritz), Stadt</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>10695</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2945</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010575747010</td>\n",
       "      <td>Boksee</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>181</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2946</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>130605023093</td>\n",
       "      <td>Gallin-Kuppentin</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>244</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2947</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>130525222004</td>\n",
       "      <td>Bartow</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>240</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2948</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010565616045</td>\n",
       "      <td>Seestermühe</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>406</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2949 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     statistics_code statistics_label time_code time_label        time  \\\n",
       "0              5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "1              5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "2              5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "3              5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "4              5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "...              ...              ...       ...        ...         ...   \n",
       "2944           5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "2945           5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "2946           5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "2947           5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "2948           5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "\n",
       "     1_variable_code 1_variable_label 1_variable_attribute_code  \\\n",
       "0             GEOGM1        Gemeinden              130625214065   \n",
       "1             GEOGM1        Gemeinden              130535312003   \n",
       "2             GEOGM1        Gemeinden              010615153056   \n",
       "3             GEOGM1        Gemeinden              031515407033   \n",
       "4             GEOGM1        Gemeinden              033560005005   \n",
       "...              ...              ...                       ...   \n",
       "2944          GEOGM1        Gemeinden              130560072072   \n",
       "2945          GEOGM1        Gemeinden              010575747010   \n",
       "2946          GEOGM1        Gemeinden              130605023093   \n",
       "2947          GEOGM1        Gemeinden              130525222004   \n",
       "2948          GEOGM1        Gemeinden              010565616045   \n",
       "\n",
       "     1_variable_attribute_label 2_variable_code  ...  \\\n",
       "0                       Züsedom          HSHGR2  ...   \n",
       "1                      Altkalen          HSHGR2  ...   \n",
       "2                  Kremperheide          HSHGR2  ...   \n",
       "3                        Ummern          HSHGR2  ...   \n",
       "4                    Lilienthal          HSHGR2  ...   \n",
       "...                         ...             ...  ...   \n",
       "2944      Waren (Müritz), Stadt          HSHGR2  ...   \n",
       "2945                     Boksee          HSHGR2  ...   \n",
       "2946           Gallin-Kuppentin          HSHGR2  ...   \n",
       "2947                     Bartow          HSHGR2  ...   \n",
       "2948                Seestermühe          HSHGR2  ...   \n",
       "\n",
       "     2_variable_attribute_label  3_variable_code  \\\n",
       "0                     Insgesamt           WHGFL3   \n",
       "1                     Insgesamt           WHGFL3   \n",
       "2                     Insgesamt           WHGFL3   \n",
       "3                     Insgesamt           WHGFL3   \n",
       "4                     Insgesamt           WHGFL3   \n",
       "...                         ...              ...   \n",
       "2944                  Insgesamt           WHGFL3   \n",
       "2945                  Insgesamt           WHGFL3   \n",
       "2946                  Insgesamt           WHGFL3   \n",
       "2947                  Insgesamt           WHGFL3   \n",
       "2948                  Insgesamt           WHGFL3   \n",
       "\n",
       "                           3_variable_label 3_variable_attribute_code  \\\n",
       "0     Fläche der Wohnung (20 m²-Intervalle)                       NaN   \n",
       "1     Fläche der Wohnung (20 m²-Intervalle)                       NaN   \n",
       "2     Fläche der Wohnung (20 m²-Intervalle)                       NaN   \n",
       "3     Fläche der Wohnung (20 m²-Intervalle)                       NaN   \n",
       "4     Fläche der Wohnung (20 m²-Intervalle)                       NaN   \n",
       "...                                     ...                       ...   \n",
       "2944  Fläche der Wohnung (20 m²-Intervalle)                       NaN   \n",
       "2945  Fläche der Wohnung (20 m²-Intervalle)                       NaN   \n",
       "2946  Fläche der Wohnung (20 m²-Intervalle)                       NaN   \n",
       "2947  Fläche der Wohnung (20 m²-Intervalle)                       NaN   \n",
       "2948  Fläche der Wohnung (20 m²-Intervalle)                       NaN   \n",
       "\n",
       "     3_variable_attribute_label  value value_unit  value_variable_code  \\\n",
       "0                     Insgesamt    120     Anzahl               HSH002   \n",
       "1                     Insgesamt    337     Anzahl               HSH002   \n",
       "2                     Insgesamt   1037     Anzahl               HSH002   \n",
       "3                     Insgesamt    588     Anzahl               HSH002   \n",
       "4                     Insgesamt   7875     Anzahl               HSH002   \n",
       "...                         ...    ...        ...                  ...   \n",
       "2944                  Insgesamt  10695     Anzahl               HSH002   \n",
       "2945                  Insgesamt    181     Anzahl               HSH002   \n",
       "2946                  Insgesamt    244     Anzahl               HSH002   \n",
       "2947                  Insgesamt    240     Anzahl               HSH002   \n",
       "2948                  Insgesamt    406     Anzahl               HSH002   \n",
       "\n",
       "     value_variable_label value_q  \n",
       "0               Haushalte       e  \n",
       "1               Haushalte       e  \n",
       "2               Haushalte       e  \n",
       "3               Haushalte       e  \n",
       "4               Haushalte       e  \n",
       "...                   ...     ...  \n",
       "2944            Haushalte       e  \n",
       "2945            Haushalte       e  \n",
       "2946            Haushalte       e  \n",
       "2947            Haushalte       e  \n",
       "2948            Haushalte       e  \n",
       "\n",
       "[2949 rows x 22 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "myTable#[\"2_variable_code\"].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Use classifying variable/key pairs to refine the table, e.g. Single Households only that occupy the largest floor space "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "download/5000H-2005_de_flat_HSHGR2_PERSON01_WHGFL3_WFL200BXXX.zip is ready to use\n"
     ]
    }
   ],
   "source": [
    "# pruned table for a specific research question\n",
    "myTable = tab2reuse(\"5000H-2005\", \"HSHGR2\", \"PERSON01\", \"WHGFL3\", \"WFL200BXXX\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>statistics_code</th>\n",
       "      <th>statistics_label</th>\n",
       "      <th>time_code</th>\n",
       "      <th>time_label</th>\n",
       "      <th>time</th>\n",
       "      <th>1_variable_code</th>\n",
       "      <th>1_variable_label</th>\n",
       "      <th>1_variable_attribute_code</th>\n",
       "      <th>1_variable_attribute_label</th>\n",
       "      <th>2_variable_code</th>\n",
       "      <th>...</th>\n",
       "      <th>2_variable_attribute_label</th>\n",
       "      <th>3_variable_code</th>\n",
       "      <th>3_variable_label</th>\n",
       "      <th>3_variable_attribute_code</th>\n",
       "      <th>3_variable_attribute_label</th>\n",
       "      <th>value</th>\n",
       "      <th>value_unit</th>\n",
       "      <th>value_variable_code</th>\n",
       "      <th>value_variable_label</th>\n",
       "      <th>value_q</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>130625214064</td>\n",
       "      <td>Zerrenthin</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>1 Person</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>48.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010515163012</td>\n",
       "      <td>Buchholz (Kreis Dithmarschen)</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>1 Person</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>WFL200BXXX</td>\n",
       "      <td>200 m² und mehr</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010615168021</td>\n",
       "      <td>Christinenthal</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>WFL200BXXX</td>\n",
       "      <td>200 m² und mehr</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>130625214065</td>\n",
       "      <td>Züsedom</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>120.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>033595404014</td>\n",
       "      <td>Düdenbüttel</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>WFL200BXXX</td>\n",
       "      <td>200 m² und mehr</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11791</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010545489017</td>\n",
       "      <td>Braderup</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>WFL200BXXX</td>\n",
       "      <td>200 m² und mehr</td>\n",
       "      <td>32.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11792</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>130585828069</td>\n",
       "      <td>Metelsdorf</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>WFL200BXXX</td>\n",
       "      <td>200 m² und mehr</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11793</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>032565409013</td>\n",
       "      <td>Hilgermissen</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>1 Person</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>WFL200BXXX</td>\n",
       "      <td>200 m² und mehr</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11794</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>034560025025</td>\n",
       "      <td>Wietmarschen</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>WFL200BXXX</td>\n",
       "      <td>200 m² und mehr</td>\n",
       "      <td>392.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11795</th>\n",
       "      <td>5000H</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>130555521078</td>\n",
       "      <td>Woldegk, Stadt</td>\n",
       "      <td>HSHGR2</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>WHGFL3</td>\n",
       "      <td>Fläche der Wohnung (20 m²-Intervalle)</td>\n",
       "      <td>WFL200BXXX</td>\n",
       "      <td>200 m² und mehr</td>\n",
       "      <td>29.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>HSH002</td>\n",
       "      <td>Haushalte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11796 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      statistics_code statistics_label time_code time_label        time  \\\n",
       "0               5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "1               5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "2               5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "3               5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "4               5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "...               ...              ...       ...        ...         ...   \n",
       "11791           5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "11792           5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "11793           5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "11794           5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "11795           5000H        Haushalte      STAG   Stichtag  2011-05-09   \n",
       "\n",
       "      1_variable_code 1_variable_label 1_variable_attribute_code  \\\n",
       "0              GEOGM1        Gemeinden              130625214064   \n",
       "1              GEOGM1        Gemeinden              010515163012   \n",
       "2              GEOGM1        Gemeinden              010615168021   \n",
       "3              GEOGM1        Gemeinden              130625214065   \n",
       "4              GEOGM1        Gemeinden              033595404014   \n",
       "...               ...              ...                       ...   \n",
       "11791          GEOGM1        Gemeinden              010545489017   \n",
       "11792          GEOGM1        Gemeinden              130585828069   \n",
       "11793          GEOGM1        Gemeinden              032565409013   \n",
       "11794          GEOGM1        Gemeinden              034560025025   \n",
       "11795          GEOGM1        Gemeinden              130555521078   \n",
       "\n",
       "          1_variable_attribute_label 2_variable_code  ...  \\\n",
       "0                         Zerrenthin          HSHGR2  ...   \n",
       "1      Buchholz (Kreis Dithmarschen)          HSHGR2  ...   \n",
       "2                     Christinenthal          HSHGR2  ...   \n",
       "3                            Züsedom          HSHGR2  ...   \n",
       "4                        Düdenbüttel          HSHGR2  ...   \n",
       "...                              ...             ...  ...   \n",
       "11791                       Braderup          HSHGR2  ...   \n",
       "11792                     Metelsdorf          HSHGR2  ...   \n",
       "11793                   Hilgermissen          HSHGR2  ...   \n",
       "11794                   Wietmarschen          HSHGR2  ...   \n",
       "11795                 Woldegk, Stadt          HSHGR2  ...   \n",
       "\n",
       "      2_variable_attribute_label 3_variable_code  \\\n",
       "0                       1 Person          WHGFL3   \n",
       "1                       1 Person          WHGFL3   \n",
       "2                      Insgesamt          WHGFL3   \n",
       "3                      Insgesamt          WHGFL3   \n",
       "4                      Insgesamt          WHGFL3   \n",
       "...                          ...             ...   \n",
       "11791                  Insgesamt          WHGFL3   \n",
       "11792                  Insgesamt          WHGFL3   \n",
       "11793                   1 Person          WHGFL3   \n",
       "11794                  Insgesamt          WHGFL3   \n",
       "11795                  Insgesamt          WHGFL3   \n",
       "\n",
       "                            3_variable_label 3_variable_attribute_code  \\\n",
       "0      Fläche der Wohnung (20 m²-Intervalle)                       NaN   \n",
       "1      Fläche der Wohnung (20 m²-Intervalle)                WFL200BXXX   \n",
       "2      Fläche der Wohnung (20 m²-Intervalle)                WFL200BXXX   \n",
       "3      Fläche der Wohnung (20 m²-Intervalle)                       NaN   \n",
       "4      Fläche der Wohnung (20 m²-Intervalle)                WFL200BXXX   \n",
       "...                                      ...                       ...   \n",
       "11791  Fläche der Wohnung (20 m²-Intervalle)                WFL200BXXX   \n",
       "11792  Fläche der Wohnung (20 m²-Intervalle)                WFL200BXXX   \n",
       "11793  Fläche der Wohnung (20 m²-Intervalle)                WFL200BXXX   \n",
       "11794  Fläche der Wohnung (20 m²-Intervalle)                WFL200BXXX   \n",
       "11795  Fläche der Wohnung (20 m²-Intervalle)                WFL200BXXX   \n",
       "\n",
       "      3_variable_attribute_label  value value_unit  value_variable_code  \\\n",
       "0                      Insgesamt   48.0     Anzahl               HSH002   \n",
       "1                200 m² und mehr    3.0     Anzahl               HSH002   \n",
       "2                200 m² und mehr    3.0     Anzahl               HSH002   \n",
       "3                      Insgesamt  120.0     Anzahl               HSH002   \n",
       "4                200 m² und mehr   24.0     Anzahl               HSH002   \n",
       "...                          ...    ...        ...                  ...   \n",
       "11791            200 m² und mehr   32.0     Anzahl               HSH002   \n",
       "11792            200 m² und mehr    6.0     Anzahl               HSH002   \n",
       "11793            200 m² und mehr    7.0     Anzahl               HSH002   \n",
       "11794            200 m² und mehr  392.0     Anzahl               HSH002   \n",
       "11795            200 m² und mehr   29.0     Anzahl               HSH002   \n",
       "\n",
       "      value_variable_label value_q  \n",
       "0                Haushalte       e  \n",
       "1                Haushalte       e  \n",
       "2                Haushalte       e  \n",
       "3                Haushalte       e  \n",
       "4                Haushalte       e  \n",
       "...                    ...     ...  \n",
       "11791            Haushalte       e  \n",
       "11792            Haushalte       e  \n",
       "11793            Haushalte       e  \n",
       "11794            Haushalte       e  \n",
       "11795            Haushalte       e  \n",
       "\n",
       "[11796 rows x 22 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "myTable"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Example Table with Sample Data: 2000S-2029\n",
    "Personen: Höchster beruflicher Abschluss (ausführlich) - Art der Wohnungsnutzung/Gebäudetyp (Bauweise)/Gebäudetyp (Größe)  \n",
    "https://ergebnisse2011.zensus2022.de/datenbank/online/table/2000S-2029"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2000S-2029_de_flat.csv\n",
      "download/2000S-2029_de_flat_BILBA1_ABSCH-X_GEBTP2_GEB-EIN-FREI.zip is ready to use\n"
     ]
    }
   ],
   "source": [
    "# Personen \"Ohne oder noch kein Schulabschluss\", die in freistehenden Einfamilienhäusern wohnen\n",
    "myTable = tab2reuse(\"2000S-2029\", \"BILBA1\", \"ABSCH-X\", \"GEBTP2\", \"GEB-EIN-FREI\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "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>statistics_code</th>\n",
       "      <th>statistics_label</th>\n",
       "      <th>time_code</th>\n",
       "      <th>time_label</th>\n",
       "      <th>time</th>\n",
       "      <th>1_variable_code</th>\n",
       "      <th>1_variable_label</th>\n",
       "      <th>1_variable_attribute_code</th>\n",
       "      <th>1_variable_attribute_label</th>\n",
       "      <th>2_variable_code</th>\n",
       "      <th>...</th>\n",
       "      <th>2_variable_attribute_label</th>\n",
       "      <th>3_variable_code</th>\n",
       "      <th>3_variable_label</th>\n",
       "      <th>3_variable_attribute_code</th>\n",
       "      <th>3_variable_attribute_label</th>\n",
       "      <th>value</th>\n",
       "      <th>value_unit</th>\n",
       "      <th>value_variable_code</th>\n",
       "      <th>value_variable_label</th>\n",
       "      <th>value_q</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2000S</td>\n",
       "      <td>Bevölkerung: Bildung, Erwerb, Migration</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM3</td>\n",
       "      <td>Gemeinden mit mindestens 10 000 Einwohnern</td>\n",
       "      <td>010560041041</td>\n",
       "      <td>Quickborn, Stadt</td>\n",
       "      <td>BILBA1</td>\n",
       "      <td>...</td>\n",
       "      <td>Ohne Abschluss</td>\n",
       "      <td>GEBTP2</td>\n",
       "      <td>Gebäudetyp (Größe)</td>\n",
       "      <td>GEB-EIN-FREI</td>\n",
       "      <td>Freistehendes Einfamilienhaus</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS009</td>\n",
       "      <td>Personen ab 15 Jahren</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2000S</td>\n",
       "      <td>Bevölkerung: Bildung, Erwerb, Migration</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM3</td>\n",
       "      <td>Gemeinden mit mindestens 10 000 Einwohnern</td>\n",
       "      <td>010560050050</td>\n",
       "      <td>Wedel, Stadt</td>\n",
       "      <td>BILBA1</td>\n",
       "      <td>...</td>\n",
       "      <td>Ohne Abschluss</td>\n",
       "      <td>GEBTP2</td>\n",
       "      <td>Gebäudetyp (Größe)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>6450.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS009</td>\n",
       "      <td>Personen ab 15 Jahren</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2000S</td>\n",
       "      <td>Bevölkerung: Bildung, Erwerb, Migration</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM3</td>\n",
       "      <td>Gemeinden mit mindestens 10 000 Einwohnern</td>\n",
       "      <td>034590012012</td>\n",
       "      <td>Bissendorf</td>\n",
       "      <td>BILBA1</td>\n",
       "      <td>...</td>\n",
       "      <td>Ohne Abschluss</td>\n",
       "      <td>GEBTP2</td>\n",
       "      <td>Gebäudetyp (Größe)</td>\n",
       "      <td>GEB-EIN-FREI</td>\n",
       "      <td>Freistehendes Einfamilienhaus</td>\n",
       "      <td>1070.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS009</td>\n",
       "      <td>Personen ab 15 Jahren</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2000S</td>\n",
       "      <td>Bevölkerung: Bildung, Erwerb, Migration</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM3</td>\n",
       "      <td>Gemeinden mit mindestens 10 000 Einwohnern</td>\n",
       "      <td>031020000000</td>\n",
       "      <td>Salzgitter, Stadt</td>\n",
       "      <td>BILBA1</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>GEBTP2</td>\n",
       "      <td>Gebäudetyp (Größe)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>83710.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS009</td>\n",
       "      <td>Personen ab 15 Jahren</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2000S</td>\n",
       "      <td>Bevölkerung: Bildung, Erwerb, Migration</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM3</td>\n",
       "      <td>Gemeinden mit mindestens 10 000 Einwohnern</td>\n",
       "      <td>034610007007</td>\n",
       "      <td>Nordenham, Stadt</td>\n",
       "      <td>BILBA1</td>\n",
       "      <td>...</td>\n",
       "      <td>Ohne Abschluss</td>\n",
       "      <td>GEBTP2</td>\n",
       "      <td>Gebäudetyp (Größe)</td>\n",
       "      <td>GEB-EIN-FREI</td>\n",
       "      <td>Freistehendes Einfamilienhaus</td>\n",
       "      <td>2310.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS009</td>\n",
       "      <td>Personen ab 15 Jahren</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1131</th>\n",
       "      <td>2000S</td>\n",
       "      <td>Bevölkerung: Bildung, Erwerb, Migration</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM3</td>\n",
       "      <td>Gemeinden mit mindestens 10 000 Einwohnern</td>\n",
       "      <td>034550026026</td>\n",
       "      <td>Varel, Stadt</td>\n",
       "      <td>BILBA1</td>\n",
       "      <td>...</td>\n",
       "      <td>Ohne Abschluss</td>\n",
       "      <td>GEBTP2</td>\n",
       "      <td>Gebäudetyp (Größe)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>6090.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS009</td>\n",
       "      <td>Personen ab 15 Jahren</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1132</th>\n",
       "      <td>2000S</td>\n",
       "      <td>Bevölkerung: Bildung, Erwerb, Migration</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM3</td>\n",
       "      <td>Gemeinden mit mindestens 10 000 Einwohnern</td>\n",
       "      <td>034590033033</td>\n",
       "      <td>Wallenhorst</td>\n",
       "      <td>BILBA1</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>GEBTP2</td>\n",
       "      <td>Gebäudetyp (Größe)</td>\n",
       "      <td>GEB-EIN-FREI</td>\n",
       "      <td>Freistehendes Einfamilienhaus</td>\n",
       "      <td>6780.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS009</td>\n",
       "      <td>Personen ab 15 Jahren</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1133</th>\n",
       "      <td>2000S</td>\n",
       "      <td>Bevölkerung: Bildung, Erwerb, Migration</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM3</td>\n",
       "      <td>Gemeinden mit mindestens 10 000 Einwohnern</td>\n",
       "      <td>130050000000</td>\n",
       "      <td>Stralsund, Hansestadt</td>\n",
       "      <td>BILBA1</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>GEBTP2</td>\n",
       "      <td>Gebäudetyp (Größe)</td>\n",
       "      <td>GEB-EIN-FREI</td>\n",
       "      <td>Freistehendes Einfamilienhaus</td>\n",
       "      <td>4660.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS009</td>\n",
       "      <td>Personen ab 15 Jahren</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1134</th>\n",
       "      <td>2000S</td>\n",
       "      <td>Bevölkerung: Bildung, Erwerb, Migration</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM3</td>\n",
       "      <td>Gemeinden mit mindestens 10 000 Einwohnern</td>\n",
       "      <td>130550050050</td>\n",
       "      <td>Neustrelitz, Stadt</td>\n",
       "      <td>BILBA1</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>GEBTP2</td>\n",
       "      <td>Gebäudetyp (Größe)</td>\n",
       "      <td>GEB-EIN-FREI</td>\n",
       "      <td>Freistehendes Einfamilienhaus</td>\n",
       "      <td>2220.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS009</td>\n",
       "      <td>Personen ab 15 Jahren</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1135</th>\n",
       "      <td>2000S</td>\n",
       "      <td>Bevölkerung: Bildung, Erwerb, Migration</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM3</td>\n",
       "      <td>Gemeinden mit mindestens 10 000 Einwohnern</td>\n",
       "      <td>033575408057</td>\n",
       "      <td>Zeven, Stadt</td>\n",
       "      <td>BILBA1</td>\n",
       "      <td>...</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>GEBTP2</td>\n",
       "      <td>Gebäudetyp (Größe)</td>\n",
       "      <td>GEB-EIN-FREI</td>\n",
       "      <td>Freistehendes Einfamilienhaus</td>\n",
       "      <td>4920.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS009</td>\n",
       "      <td>Personen ab 15 Jahren</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1136 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     statistics_code                         statistics_label time_code  \\\n",
       "0              2000S  Bevölkerung: Bildung, Erwerb, Migration      STAG   \n",
       "1              2000S  Bevölkerung: Bildung, Erwerb, Migration      STAG   \n",
       "2              2000S  Bevölkerung: Bildung, Erwerb, Migration      STAG   \n",
       "3              2000S  Bevölkerung: Bildung, Erwerb, Migration      STAG   \n",
       "4              2000S  Bevölkerung: Bildung, Erwerb, Migration      STAG   \n",
       "...              ...                                      ...       ...   \n",
       "1131           2000S  Bevölkerung: Bildung, Erwerb, Migration      STAG   \n",
       "1132           2000S  Bevölkerung: Bildung, Erwerb, Migration      STAG   \n",
       "1133           2000S  Bevölkerung: Bildung, Erwerb, Migration      STAG   \n",
       "1134           2000S  Bevölkerung: Bildung, Erwerb, Migration      STAG   \n",
       "1135           2000S  Bevölkerung: Bildung, Erwerb, Migration      STAG   \n",
       "\n",
       "     time_label        time 1_variable_code  \\\n",
       "0      Stichtag  2011-05-09          GEOGM3   \n",
       "1      Stichtag  2011-05-09          GEOGM3   \n",
       "2      Stichtag  2011-05-09          GEOGM3   \n",
       "3      Stichtag  2011-05-09          GEOGM3   \n",
       "4      Stichtag  2011-05-09          GEOGM3   \n",
       "...         ...         ...             ...   \n",
       "1131   Stichtag  2011-05-09          GEOGM3   \n",
       "1132   Stichtag  2011-05-09          GEOGM3   \n",
       "1133   Stichtag  2011-05-09          GEOGM3   \n",
       "1134   Stichtag  2011-05-09          GEOGM3   \n",
       "1135   Stichtag  2011-05-09          GEOGM3   \n",
       "\n",
       "                                1_variable_label 1_variable_attribute_code  \\\n",
       "0     Gemeinden mit mindestens 10 000 Einwohnern              010560041041   \n",
       "1     Gemeinden mit mindestens 10 000 Einwohnern              010560050050   \n",
       "2     Gemeinden mit mindestens 10 000 Einwohnern              034590012012   \n",
       "3     Gemeinden mit mindestens 10 000 Einwohnern              031020000000   \n",
       "4     Gemeinden mit mindestens 10 000 Einwohnern              034610007007   \n",
       "...                                          ...                       ...   \n",
       "1131  Gemeinden mit mindestens 10 000 Einwohnern              034550026026   \n",
       "1132  Gemeinden mit mindestens 10 000 Einwohnern              034590033033   \n",
       "1133  Gemeinden mit mindestens 10 000 Einwohnern              130050000000   \n",
       "1134  Gemeinden mit mindestens 10 000 Einwohnern              130550050050   \n",
       "1135  Gemeinden mit mindestens 10 000 Einwohnern              033575408057   \n",
       "\n",
       "     1_variable_attribute_label 2_variable_code  ...  \\\n",
       "0              Quickborn, Stadt          BILBA1  ...   \n",
       "1                  Wedel, Stadt          BILBA1  ...   \n",
       "2                    Bissendorf          BILBA1  ...   \n",
       "3             Salzgitter, Stadt          BILBA1  ...   \n",
       "4              Nordenham, Stadt          BILBA1  ...   \n",
       "...                         ...             ...  ...   \n",
       "1131               Varel, Stadt          BILBA1  ...   \n",
       "1132                Wallenhorst          BILBA1  ...   \n",
       "1133      Stralsund, Hansestadt          BILBA1  ...   \n",
       "1134         Neustrelitz, Stadt          BILBA1  ...   \n",
       "1135               Zeven, Stadt          BILBA1  ...   \n",
       "\n",
       "     2_variable_attribute_label 3_variable_code    3_variable_label  \\\n",
       "0                Ohne Abschluss          GEBTP2  Gebäudetyp (Größe)   \n",
       "1                Ohne Abschluss          GEBTP2  Gebäudetyp (Größe)   \n",
       "2                Ohne Abschluss          GEBTP2  Gebäudetyp (Größe)   \n",
       "3                     Insgesamt          GEBTP2  Gebäudetyp (Größe)   \n",
       "4                Ohne Abschluss          GEBTP2  Gebäudetyp (Größe)   \n",
       "...                         ...             ...                 ...   \n",
       "1131             Ohne Abschluss          GEBTP2  Gebäudetyp (Größe)   \n",
       "1132                  Insgesamt          GEBTP2  Gebäudetyp (Größe)   \n",
       "1133                  Insgesamt          GEBTP2  Gebäudetyp (Größe)   \n",
       "1134                  Insgesamt          GEBTP2  Gebäudetyp (Größe)   \n",
       "1135                  Insgesamt          GEBTP2  Gebäudetyp (Größe)   \n",
       "\n",
       "     3_variable_attribute_code     3_variable_attribute_label    value  \\\n",
       "0                 GEB-EIN-FREI  Freistehendes Einfamilienhaus   1500.0   \n",
       "1                          NaN                      Insgesamt   6450.0   \n",
       "2                 GEB-EIN-FREI  Freistehendes Einfamilienhaus   1070.0   \n",
       "3                          NaN                      Insgesamt  83710.0   \n",
       "4                 GEB-EIN-FREI  Freistehendes Einfamilienhaus   2310.0   \n",
       "...                        ...                            ...      ...   \n",
       "1131                       NaN                      Insgesamt   6090.0   \n",
       "1132              GEB-EIN-FREI  Freistehendes Einfamilienhaus   6780.0   \n",
       "1133              GEB-EIN-FREI  Freistehendes Einfamilienhaus   4660.0   \n",
       "1134              GEB-EIN-FREI  Freistehendes Einfamilienhaus   2220.0   \n",
       "1135              GEB-EIN-FREI  Freistehendes Einfamilienhaus   4920.0   \n",
       "\n",
       "     value_unit  value_variable_code   value_variable_label value_q  \n",
       "0        Anzahl               PRS009  Personen ab 15 Jahren       e  \n",
       "1        Anzahl               PRS009  Personen ab 15 Jahren       e  \n",
       "2        Anzahl               PRS009  Personen ab 15 Jahren       e  \n",
       "3        Anzahl               PRS009  Personen ab 15 Jahren       e  \n",
       "4        Anzahl               PRS009  Personen ab 15 Jahren       e  \n",
       "...         ...                  ...                    ...     ...  \n",
       "1131     Anzahl               PRS009  Personen ab 15 Jahren       e  \n",
       "1132     Anzahl               PRS009  Personen ab 15 Jahren       e  \n",
       "1133     Anzahl               PRS009  Personen ab 15 Jahren       e  \n",
       "1134     Anzahl               PRS009  Personen ab 15 Jahren       e  \n",
       "1135     Anzahl               PRS009  Personen ab 15 Jahren       e  \n",
       "\n",
       "[1136 rows x 22 columns]"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "myTable"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Example Table with Percentages: 1000A-1009\n",
    "Personen: ...  \n",
    "https://ergebnisse2011.zensus2022.de/datenbank/online/table/1000A-1009"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1000A-1009_de_flat.csv\n",
      "download/1000A-1009_de_flat_FAMST1_VERWITWET__.zip is ready to use\n"
     ]
    }
   ],
   "source": [
    "# Personen\n",
    "myTable = tab2reuse(\"1000A-1009\", \"FAMST1\", \"VERWITWET\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "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>statistics_code</th>\n",
       "      <th>statistics_label</th>\n",
       "      <th>time_code</th>\n",
       "      <th>time_label</th>\n",
       "      <th>time</th>\n",
       "      <th>1_variable_code</th>\n",
       "      <th>1_variable_label</th>\n",
       "      <th>1_variable_attribute_code</th>\n",
       "      <th>1_variable_attribute_label</th>\n",
       "      <th>2_variable_code</th>\n",
       "      <th>2_variable_label</th>\n",
       "      <th>2_variable_attribute_code</th>\n",
       "      <th>2_variable_attribute_label</th>\n",
       "      <th>value</th>\n",
       "      <th>value_unit</th>\n",
       "      <th>value_variable_code</th>\n",
       "      <th>value_variable_label</th>\n",
       "      <th>value_q</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010585864147</td>\n",
       "      <td>Schülp b. Nortorf</td>\n",
       "      <td>FAMST1</td>\n",
       "      <td>Familienstand (ausführlich)</td>\n",
       "      <td>VERWITWET</td>\n",
       "      <td>Verwitwet</td>\n",
       "      <td>6.6</td>\n",
       "      <td>%</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010585864147</td>\n",
       "      <td>Schülp b. Nortorf</td>\n",
       "      <td>FAMST1</td>\n",
       "      <td>Familienstand (ausführlich)</td>\n",
       "      <td>VERWITWET</td>\n",
       "      <td>Verwitwet</td>\n",
       "      <td>52.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>031545403025</td>\n",
       "      <td>Warberg</td>\n",
       "      <td>FAMST1</td>\n",
       "      <td>Familienstand (ausführlich)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>100.0</td>\n",
       "      <td>%</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>031545403025</td>\n",
       "      <td>Warberg</td>\n",
       "      <td>FAMST1</td>\n",
       "      <td>Familienstand (ausführlich)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>890.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010595990109</td>\n",
       "      <td>Esgrus</td>\n",
       "      <td>FAMST1</td>\n",
       "      <td>Familienstand (ausführlich)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>100.0</td>\n",
       "      <td>%</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11795</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>033515404018</td>\n",
       "      <td>Nienhagen (Landkreis Celle)</td>\n",
       "      <td>FAMST1</td>\n",
       "      <td>Familienstand (ausführlich)</td>\n",
       "      <td>VERWITWET</td>\n",
       "      <td>Verwitwet</td>\n",
       "      <td>423.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11796</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEODL1</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>DG</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>FAMST1</td>\n",
       "      <td>Familienstand (ausführlich)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>100.0</td>\n",
       "      <td>%</td>\n",
       "      <td>PRS001</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11797</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEODL1</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>DG</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>FAMST1</td>\n",
       "      <td>Familienstand (ausführlich)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>80219695.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS001</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11798</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEODL1</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>DG</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>FAMST1</td>\n",
       "      <td>Familienstand (ausführlich)</td>\n",
       "      <td>VERWITWET</td>\n",
       "      <td>Verwitwet</td>\n",
       "      <td>7.1</td>\n",
       "      <td>%</td>\n",
       "      <td>PRS001</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11799</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEODL1</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>DG</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>FAMST1</td>\n",
       "      <td>Familienstand (ausführlich)</td>\n",
       "      <td>VERWITWET</td>\n",
       "      <td>Verwitwet</td>\n",
       "      <td>5733360.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS001</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11800 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      statistics_code     statistics_label time_code time_label        time  \\\n",
       "0               1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "1               1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "2               1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "3               1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "4               1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "...               ...                  ...       ...        ...         ...   \n",
       "11795           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "11796           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "11797           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "11798           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "11799           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "\n",
       "      1_variable_code 1_variable_label 1_variable_attribute_code  \\\n",
       "0              GEOGM1        Gemeinden              010585864147   \n",
       "1              GEOGM1        Gemeinden              010585864147   \n",
       "2              GEOGM1        Gemeinden              031545403025   \n",
       "3              GEOGM1        Gemeinden              031545403025   \n",
       "4              GEOGM1        Gemeinden              010595990109   \n",
       "...               ...              ...                       ...   \n",
       "11795          GEOGM1        Gemeinden              033515404018   \n",
       "11796          GEODL1      Deutschland                        DG   \n",
       "11797          GEODL1      Deutschland                        DG   \n",
       "11798          GEODL1      Deutschland                        DG   \n",
       "11799          GEODL1      Deutschland                        DG   \n",
       "\n",
       "        1_variable_attribute_label 2_variable_code  \\\n",
       "0                Schülp b. Nortorf          FAMST1   \n",
       "1                Schülp b. Nortorf          FAMST1   \n",
       "2                          Warberg          FAMST1   \n",
       "3                          Warberg          FAMST1   \n",
       "4                           Esgrus          FAMST1   \n",
       "...                            ...             ...   \n",
       "11795  Nienhagen (Landkreis Celle)          FAMST1   \n",
       "11796                  Deutschland          FAMST1   \n",
       "11797                  Deutschland          FAMST1   \n",
       "11798                  Deutschland          FAMST1   \n",
       "11799                  Deutschland          FAMST1   \n",
       "\n",
       "                  2_variable_label 2_variable_attribute_code  \\\n",
       "0      Familienstand (ausführlich)                 VERWITWET   \n",
       "1      Familienstand (ausführlich)                 VERWITWET   \n",
       "2      Familienstand (ausführlich)                       NaN   \n",
       "3      Familienstand (ausführlich)                       NaN   \n",
       "4      Familienstand (ausführlich)                       NaN   \n",
       "...                            ...                       ...   \n",
       "11795  Familienstand (ausführlich)                 VERWITWET   \n",
       "11796  Familienstand (ausführlich)                       NaN   \n",
       "11797  Familienstand (ausführlich)                       NaN   \n",
       "11798  Familienstand (ausführlich)                 VERWITWET   \n",
       "11799  Familienstand (ausführlich)                 VERWITWET   \n",
       "\n",
       "      2_variable_attribute_label       value value_unit value_variable_code  \\\n",
       "0                      Verwitwet         6.6          %              PRS018   \n",
       "1                      Verwitwet        52.0     Anzahl              PRS018   \n",
       "2                      Insgesamt       100.0          %              PRS018   \n",
       "3                      Insgesamt       890.0     Anzahl              PRS018   \n",
       "4                      Insgesamt       100.0          %              PRS018   \n",
       "...                          ...         ...        ...                 ...   \n",
       "11795                  Verwitwet       423.0     Anzahl              PRS018   \n",
       "11796                  Insgesamt       100.0          %              PRS001   \n",
       "11797                  Insgesamt  80219695.0     Anzahl              PRS001   \n",
       "11798                  Verwitwet         7.1          %              PRS001   \n",
       "11799                  Verwitwet   5733360.0     Anzahl              PRS001   \n",
       "\n",
       "      value_variable_label value_q  \n",
       "0                 Personen       e  \n",
       "1                 Personen       e  \n",
       "2                 Personen       e  \n",
       "3                 Personen       e  \n",
       "4                 Personen       e  \n",
       "...                    ...     ...  \n",
       "11795             Personen       e  \n",
       "11796             Personen       e  \n",
       "11797             Personen       e  \n",
       "11798             Personen       e  \n",
       "11799             Personen       e  \n",
       "\n",
       "[11800 rows x 18 columns]"
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "myTable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "download/1000A-0001_de_flat____.zip is ready to use\n"
     ]
    }
   ],
   "source": [
    "# Fläche qkm\n",
    "myTable = tab2reuse(\"1000A-0001\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "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>statistics_code</th>\n",
       "      <th>statistics_label</th>\n",
       "      <th>time_code</th>\n",
       "      <th>time_label</th>\n",
       "      <th>time</th>\n",
       "      <th>1_variable_code</th>\n",
       "      <th>1_variable_label</th>\n",
       "      <th>1_variable_attribute_code</th>\n",
       "      <th>1_variable_attribute_label</th>\n",
       "      <th>value</th>\n",
       "      <th>value_unit</th>\n",
       "      <th>value_variable_code</th>\n",
       "      <th>value_variable_label</th>\n",
       "      <th>value_q</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>033545403021</td>\n",
       "      <td>Schnackenburg, Stadt</td>\n",
       "      <td>25.00</td>\n",
       "      <td>Ew/qkm</td>\n",
       "      <td>PRS017</td>\n",
       "      <td>Bevölkerungsdichte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>033545403021</td>\n",
       "      <td>Schnackenburg, Stadt</td>\n",
       "      <td>23.70</td>\n",
       "      <td>qkm</td>\n",
       "      <td>FLC001</td>\n",
       "      <td>Fläche</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>033545403021</td>\n",
       "      <td>Schnackenburg, Stadt</td>\n",
       "      <td>592.00</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010545489109</td>\n",
       "      <td>Risum-Lindholm</td>\n",
       "      <td>100.00</td>\n",
       "      <td>Ew/qkm</td>\n",
       "      <td>PRS017</td>\n",
       "      <td>Bevölkerungsdichte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010545489109</td>\n",
       "      <td>Risum-Lindholm</td>\n",
       "      <td>36.03</td>\n",
       "      <td>qkm</td>\n",
       "      <td>FLC001</td>\n",
       "      <td>Fläche</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8842</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010585864011</td>\n",
       "      <td>Bargstedt (Kreis Rendsburg-Eckernförde)</td>\n",
       "      <td>25.32</td>\n",
       "      <td>qkm</td>\n",
       "      <td>FLC001</td>\n",
       "      <td>Fläche</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8843</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010585864011</td>\n",
       "      <td>Bargstedt (Kreis Rendsburg-Eckernförde)</td>\n",
       "      <td>729.00</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8844</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>033575405050</td>\n",
       "      <td>Vierden</td>\n",
       "      <td>37.00</td>\n",
       "      <td>Ew/qkm</td>\n",
       "      <td>PRS017</td>\n",
       "      <td>Bevölkerungsdichte</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8845</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>033575405050</td>\n",
       "      <td>Vierden</td>\n",
       "      <td>21.30</td>\n",
       "      <td>qkm</td>\n",
       "      <td>FLC001</td>\n",
       "      <td>Fläche</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8846</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>033575405050</td>\n",
       "      <td>Vierden</td>\n",
       "      <td>792.00</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8847 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     statistics_code     statistics_label time_code time_label        time  \\\n",
       "0              1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "1              1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "2              1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "3              1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "4              1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "...              ...                  ...       ...        ...         ...   \n",
       "8842           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "8843           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "8844           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "8845           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "8846           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "\n",
       "     1_variable_code 1_variable_label 1_variable_attribute_code  \\\n",
       "0             GEOGM1        Gemeinden              033545403021   \n",
       "1             GEOGM1        Gemeinden              033545403021   \n",
       "2             GEOGM1        Gemeinden              033545403021   \n",
       "3             GEOGM1        Gemeinden              010545489109   \n",
       "4             GEOGM1        Gemeinden              010545489109   \n",
       "...              ...              ...                       ...   \n",
       "8842          GEOGM1        Gemeinden              010585864011   \n",
       "8843          GEOGM1        Gemeinden              010585864011   \n",
       "8844          GEOGM1        Gemeinden              033575405050   \n",
       "8845          GEOGM1        Gemeinden              033575405050   \n",
       "8846          GEOGM1        Gemeinden              033575405050   \n",
       "\n",
       "                   1_variable_attribute_label   value value_unit  \\\n",
       "0                        Schnackenburg, Stadt   25.00     Ew/qkm   \n",
       "1                        Schnackenburg, Stadt   23.70        qkm   \n",
       "2                        Schnackenburg, Stadt  592.00     Anzahl   \n",
       "3                              Risum-Lindholm  100.00     Ew/qkm   \n",
       "4                              Risum-Lindholm   36.03        qkm   \n",
       "...                                       ...     ...        ...   \n",
       "8842  Bargstedt (Kreis Rendsburg-Eckernförde)   25.32        qkm   \n",
       "8843  Bargstedt (Kreis Rendsburg-Eckernförde)  729.00     Anzahl   \n",
       "8844                                  Vierden   37.00     Ew/qkm   \n",
       "8845                                  Vierden   21.30        qkm   \n",
       "8846                                  Vierden  792.00     Anzahl   \n",
       "\n",
       "     value_variable_code value_variable_label value_q  \n",
       "0                 PRS017   Bevölkerungsdichte       e  \n",
       "1                 FLC001               Fläche       e  \n",
       "2                 PRS018             Personen       e  \n",
       "3                 PRS017   Bevölkerungsdichte       e  \n",
       "4                 FLC001               Fläche       e  \n",
       "...                  ...                  ...     ...  \n",
       "8842              FLC001               Fläche       e  \n",
       "8843              PRS018             Personen       e  \n",
       "8844              PRS017   Bevölkerungsdichte       e  \n",
       "8845              FLC001               Fläche       e  \n",
       "8846              PRS018             Personen       e  \n",
       "\n",
       "[8847 rows x 14 columns]"
      ]
     },
     "execution_count": 122,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "myTable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "... will fetch from database, thank you for your patience ...\n",
      "2024-02-05 19:10:38 1000A-1001_de_flat download complete\n",
      "download/1000A-1001_de_flat____.zip is ready to use\n"
     ]
    }
   ],
   "source": [
    "# scratch\n",
    "myTable = tab2reuse(\"1000A-1001\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "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>statistics_code</th>\n",
       "      <th>statistics_label</th>\n",
       "      <th>time_code</th>\n",
       "      <th>time_label</th>\n",
       "      <th>time</th>\n",
       "      <th>1_variable_code</th>\n",
       "      <th>1_variable_label</th>\n",
       "      <th>1_variable_attribute_code</th>\n",
       "      <th>1_variable_attribute_label</th>\n",
       "      <th>2_variable_code</th>\n",
       "      <th>2_variable_label</th>\n",
       "      <th>2_variable_attribute_code</th>\n",
       "      <th>2_variable_attribute_label</th>\n",
       "      <th>value</th>\n",
       "      <th>value_unit</th>\n",
       "      <th>value_variable_code</th>\n",
       "      <th>value_variable_label</th>\n",
       "      <th>value_q</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010600039039</td>\n",
       "      <td>Henstedt-Ulzburg</td>\n",
       "      <td>ALTGR2</td>\n",
       "      <td>Alter (10er-Jahresgruppen)</td>\n",
       "      <td>ALT020B029</td>\n",
       "      <td>20 bis 29 Jahre</td>\n",
       "      <td>9.3</td>\n",
       "      <td>%</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>010600039039</td>\n",
       "      <td>Henstedt-Ulzburg</td>\n",
       "      <td>ALTGR2</td>\n",
       "      <td>Alter (10er-Jahresgruppen)</td>\n",
       "      <td>ALT020B029</td>\n",
       "      <td>20 bis 29 Jahre</td>\n",
       "      <td>2472.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>034625402001</td>\n",
       "      <td>Blomberg</td>\n",
       "      <td>ALTGR2</td>\n",
       "      <td>Alter (10er-Jahresgruppen)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>100.0</td>\n",
       "      <td>%</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>034625402001</td>\n",
       "      <td>Blomberg</td>\n",
       "      <td>ALTGR2</td>\n",
       "      <td>Alter (10er-Jahresgruppen)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Insgesamt</td>\n",
       "      <td>1656.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEOGM1</td>\n",
       "      <td>Gemeinden</td>\n",
       "      <td>032410012012</td>\n",
       "      <td>Neustadt am Rübenberge, Stadt</td>\n",
       "      <td>ALTGR2</td>\n",
       "      <td>Alter (10er-Jahresgruppen)</td>\n",
       "      <td>ALT030B039</td>\n",
       "      <td>30 bis 39 Jahre</td>\n",
       "      <td>10.4</td>\n",
       "      <td>%</td>\n",
       "      <td>PRS018</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58995</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEODL1</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>DG</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>ALTGR2</td>\n",
       "      <td>Alter (10er-Jahresgruppen)</td>\n",
       "      <td>ALT080BXXX</td>\n",
       "      <td>80 Jahre und älter</td>\n",
       "      <td>4213248.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS001</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58996</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEODL1</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>DG</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>ALTGR2</td>\n",
       "      <td>Alter (10er-Jahresgruppen)</td>\n",
       "      <td>ALT020B029</td>\n",
       "      <td>20 bis 29 Jahre</td>\n",
       "      <td>12.1</td>\n",
       "      <td>%</td>\n",
       "      <td>PRS001</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58997</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEODL1</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>DG</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>ALTGR2</td>\n",
       "      <td>Alter (10er-Jahresgruppen)</td>\n",
       "      <td>ALT020B029</td>\n",
       "      <td>20 bis 29 Jahre</td>\n",
       "      <td>9708174.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS001</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58998</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEODL1</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>DG</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>ALTGR2</td>\n",
       "      <td>Alter (10er-Jahresgruppen)</td>\n",
       "      <td>ALT050B059</td>\n",
       "      <td>50 bis 59 Jahre</td>\n",
       "      <td>14.5</td>\n",
       "      <td>%</td>\n",
       "      <td>PRS001</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58999</th>\n",
       "      <td>1000A</td>\n",
       "      <td>Bevölkerung kompakt</td>\n",
       "      <td>STAG</td>\n",
       "      <td>Stichtag</td>\n",
       "      <td>2011-05-09</td>\n",
       "      <td>GEODL1</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>DG</td>\n",
       "      <td>Deutschland</td>\n",
       "      <td>ALTGR2</td>\n",
       "      <td>Alter (10er-Jahresgruppen)</td>\n",
       "      <td>ALT050B059</td>\n",
       "      <td>50 bis 59 Jahre</td>\n",
       "      <td>11625744.0</td>\n",
       "      <td>Anzahl</td>\n",
       "      <td>PRS001</td>\n",
       "      <td>Personen</td>\n",
       "      <td>e</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>59000 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      statistics_code     statistics_label time_code time_label        time  \\\n",
       "0               1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "1               1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "2               1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "3               1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "4               1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "...               ...                  ...       ...        ...         ...   \n",
       "58995           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "58996           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "58997           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "58998           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "58999           1000A  Bevölkerung kompakt      STAG   Stichtag  2011-05-09   \n",
       "\n",
       "      1_variable_code 1_variable_label 1_variable_attribute_code  \\\n",
       "0              GEOGM1        Gemeinden              010600039039   \n",
       "1              GEOGM1        Gemeinden              010600039039   \n",
       "2              GEOGM1        Gemeinden              034625402001   \n",
       "3              GEOGM1        Gemeinden              034625402001   \n",
       "4              GEOGM1        Gemeinden              032410012012   \n",
       "...               ...              ...                       ...   \n",
       "58995          GEODL1      Deutschland                        DG   \n",
       "58996          GEODL1      Deutschland                        DG   \n",
       "58997          GEODL1      Deutschland                        DG   \n",
       "58998          GEODL1      Deutschland                        DG   \n",
       "58999          GEODL1      Deutschland                        DG   \n",
       "\n",
       "          1_variable_attribute_label 2_variable_code  \\\n",
       "0                   Henstedt-Ulzburg          ALTGR2   \n",
       "1                   Henstedt-Ulzburg          ALTGR2   \n",
       "2                           Blomberg          ALTGR2   \n",
       "3                           Blomberg          ALTGR2   \n",
       "4      Neustadt am Rübenberge, Stadt          ALTGR2   \n",
       "...                              ...             ...   \n",
       "58995                    Deutschland          ALTGR2   \n",
       "58996                    Deutschland          ALTGR2   \n",
       "58997                    Deutschland          ALTGR2   \n",
       "58998                    Deutschland          ALTGR2   \n",
       "58999                    Deutschland          ALTGR2   \n",
       "\n",
       "                 2_variable_label 2_variable_attribute_code  \\\n",
       "0      Alter (10er-Jahresgruppen)                ALT020B029   \n",
       "1      Alter (10er-Jahresgruppen)                ALT020B029   \n",
       "2      Alter (10er-Jahresgruppen)                       NaN   \n",
       "3      Alter (10er-Jahresgruppen)                       NaN   \n",
       "4      Alter (10er-Jahresgruppen)                ALT030B039   \n",
       "...                           ...                       ...   \n",
       "58995  Alter (10er-Jahresgruppen)                ALT080BXXX   \n",
       "58996  Alter (10er-Jahresgruppen)                ALT020B029   \n",
       "58997  Alter (10er-Jahresgruppen)                ALT020B029   \n",
       "58998  Alter (10er-Jahresgruppen)                ALT050B059   \n",
       "58999  Alter (10er-Jahresgruppen)                ALT050B059   \n",
       "\n",
       "      2_variable_attribute_label       value value_unit value_variable_code  \\\n",
       "0                20 bis 29 Jahre         9.3          %              PRS018   \n",
       "1                20 bis 29 Jahre      2472.0     Anzahl              PRS018   \n",
       "2                      Insgesamt       100.0          %              PRS018   \n",
       "3                      Insgesamt      1656.0     Anzahl              PRS018   \n",
       "4                30 bis 39 Jahre        10.4          %              PRS018   \n",
       "...                          ...         ...        ...                 ...   \n",
       "58995         80 Jahre und älter   4213248.0     Anzahl              PRS001   \n",
       "58996            20 bis 29 Jahre        12.1          %              PRS001   \n",
       "58997            20 bis 29 Jahre   9708174.0     Anzahl              PRS001   \n",
       "58998            50 bis 59 Jahre        14.5          %              PRS001   \n",
       "58999            50 bis 59 Jahre  11625744.0     Anzahl              PRS001   \n",
       "\n",
       "      value_variable_label value_q  \n",
       "0                 Personen       e  \n",
       "1                 Personen       e  \n",
       "2                 Personen       e  \n",
       "3                 Personen       e  \n",
       "4                 Personen       e  \n",
       "...                    ...     ...  \n",
       "58995             Personen       e  \n",
       "58996             Personen       e  \n",
       "58997             Personen       e  \n",
       "58998             Personen       e  \n",
       "58999             Personen       e  \n",
       "\n",
       "[59000 rows x 18 columns]"
      ]
     },
     "execution_count": 124,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "myTable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.12.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}