MyTest.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "***\n",
    "# Setup\n",
    "***"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: SPARQLWrapper==1.8.4 in /srv/paws/lib/python3.6/site-packages (from -r requirements.txt (line 1))\r\n",
      "Requirement already satisfied: rdflib>=4.0 in /srv/paws/lib/python3.6/site-packages (from SPARQLWrapper==1.8.4->-r requirements.txt (line 1))\r\n",
      "Requirement already satisfied: isodate in /srv/paws/lib/python3.6/site-packages (from rdflib>=4.0->SPARQLWrapper==1.8.4->-r requirements.txt (line 1))\r\n",
      "Requirement already satisfied: pyparsing in /srv/paws/lib/python3.6/site-packages (from rdflib>=4.0->SPARQLWrapper==1.8.4->-r requirements.txt (line 1))\r\n",
      "Requirement already satisfied: six in /srv/paws/lib/python3.6/site-packages (from isodate->rdflib>=4.0->SPARQLWrapper==1.8.4->-r requirements.txt (line 1))\r\n"
     ]
    }
   ],
   "source": [
    "!pip install -r requirements.txt\n",
    "\n",
    "import logging\n",
    "#logger = logging.getLogger()\n",
    "#logger.setLevel(logging.INFO)\n",
    "\n",
    "import pandas as pd\n",
    "import requests\n",
    "import zipfile\n",
    "import os\n",
    "import shutil\n",
    "from SPARQLWrapper import SPARQLWrapper, JSON, XML\n",
    "import logging\n",
    "\n",
    "from data_imports import *"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "***\n",
    "# Import Data\n",
    "***"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_api = import_kantonZH_api() \n",
    "df_wikidata = import_wikidata_kantonZH()\n",
    "swisstopowikidata = import_swisstopowikidata_kantonZH()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(10032, 4)\n"
     ]
    },
    {
     "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>BFS_NR</th>\n",
       "      <th>GEBIET_NAME</th>\n",
       "      <th>date</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21</td>\n",
       "      <td>Adlikon</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>707.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>131</td>\n",
       "      <td>Adliswil</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>18681.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>241</td>\n",
       "      <td>Aesch ZH</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>1555.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>Aeugst a.A.</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>1979.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>Affoltern a.A.</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>12201.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   BFS_NR     GEBIET_NAME        date  population\n",
       "0      21         Adlikon  2018-12-31       707.0\n",
       "1     131        Adliswil  2018-12-31     18681.0\n",
       "2     241        Aesch ZH  2018-12-31      1555.0\n",
       "3       1     Aeugst a.A.  2018-12-31      1979.0\n",
       "4       2  Affoltern a.A.  2018-12-31     12201.0"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(df_api.shape)\n",
    "df_api.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(815, 7)\n"
     ]
    },
    {
     "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>bfs_id</th>\n",
       "      <th>date</th>\n",
       "      <th>population</th>\n",
       "      <th>qualifier</th>\n",
       "      <th>refpublisher</th>\n",
       "      <th>refurl</th>\n",
       "      <th>wikidata_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1934</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://statistik.zh.ch/internet/justiz_innere...</td>\n",
       "      <td>Q64945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1941</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...</td>\n",
       "      <td>Q64945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>1982</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.bfs.admin.ch/bfs/de/home/statistik...</td>\n",
       "      <td>Q64945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>11276</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>NA</td>\n",
       "      <td>http://www.pxweb.bfs.admin.ch/Dialog/varval.as...</td>\n",
       "      <td>Q68290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>12080</td>\n",
       "      <td>PreferredRank</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://statistik.zh.ch/internet/justiz_innere...</td>\n",
       "      <td>Q68290</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   bfs_id        date population      qualifier  \\\n",
       "0       1  2017-01-01       1934     NormalRank   \n",
       "1       1  2017-12-31       1941     NormalRank   \n",
       "2       1  2018-12-31       1982     NormalRank   \n",
       "3       2  2012-12-31      11276     NormalRank   \n",
       "4       2  2017-01-01      12080  PreferredRank   \n",
       "\n",
       "                             refpublisher  \\\n",
       "0                                      NA   \n",
       "1  http://www.wikidata.org/entity/Q285453   \n",
       "2  http://www.wikidata.org/entity/Q285453   \n",
       "3                                      NA   \n",
       "4                                      NA   \n",
       "\n",
       "                                              refurl wikidata_id  \n",
       "0  https://statistik.zh.ch/internet/justiz_innere...      Q64945  \n",
       "1  https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...      Q64945  \n",
       "2  https://www.bfs.admin.ch/bfs/de/home/statistik...      Q64945  \n",
       "3  http://www.pxweb.bfs.admin.ch/Dialog/varval.as...      Q68290  \n",
       "4  https://statistik.zh.ch/internet/justiz_innere...      Q68290  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(df_wikidata.shape)\n",
    "df_wikidata.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(162, 3)\n"
     ]
    },
    {
     "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>Name</th>\n",
       "      <th>bfs</th>\n",
       "      <th>wikidata_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Stadel</td>\n",
       "      <td>100</td>\n",
       "      <td>Q67907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Obfelden</td>\n",
       "      <td>10</td>\n",
       "      <td>Q65942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Rüti (ZH)</td>\n",
       "      <td>118</td>\n",
       "      <td>Q69752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Seegräben</td>\n",
       "      <td>119</td>\n",
       "      <td>Q67310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ottenbach</td>\n",
       "      <td>11</td>\n",
       "      <td>Q67513</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Name  bfs wikidata_id\n",
       "0     Stadel  100      Q67907\n",
       "1   Obfelden   10      Q65942\n",
       "2  Rüti (ZH)  118      Q69752\n",
       "3  Seegräben  119      Q67310\n",
       "4  Ottenbach   11      Q67513"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(swisstopowikidata.shape)\n",
    "swisstopowikidata.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "***\n",
    "\n",
    "# Merge df_api with swisstopowikidata \n",
    "\n",
    "Aim: add wikidata qnumber to df_api \n",
    "\n",
    "Observation: Not all bfsnumbers can be linked to a qnumber. Reason: \"Gemeindefusionen\"\n",
    "        \n",
    "Decision: Only use bfsnumbers that are active today.           \n",
    "***  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(10032, 7)\n"
     ]
    },
    {
     "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>BFS_NR</th>\n",
       "      <th>GEBIET_NAME</th>\n",
       "      <th>date</th>\n",
       "      <th>population</th>\n",
       "      <th>Name</th>\n",
       "      <th>bfs</th>\n",
       "      <th>wikidata_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21</td>\n",
       "      <td>Adlikon</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>707.0</td>\n",
       "      <td>Adlikon</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Q68356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>131</td>\n",
       "      <td>Adliswil</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>18681.0</td>\n",
       "      <td>Adliswil</td>\n",
       "      <td>131.0</td>\n",
       "      <td>Q68210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>241</td>\n",
       "      <td>Aesch ZH</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>1555.0</td>\n",
       "      <td>Aesch (ZH)</td>\n",
       "      <td>241.0</td>\n",
       "      <td>Q68342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>Aeugst a.A.</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>1979.0</td>\n",
       "      <td>Aeugst am Albis</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Q64945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>Affoltern a.A.</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>12201.0</td>\n",
       "      <td>Affoltern am Albis</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Q68290</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   BFS_NR     GEBIET_NAME        date  population                Name    bfs  \\\n",
       "0      21         Adlikon  2018-12-31       707.0             Adlikon   21.0   \n",
       "1     131        Adliswil  2018-12-31     18681.0            Adliswil  131.0   \n",
       "2     241        Aesch ZH  2018-12-31      1555.0          Aesch (ZH)  241.0   \n",
       "3       1     Aeugst a.A.  2018-12-31      1979.0     Aeugst am Albis    1.0   \n",
       "4       2  Affoltern a.A.  2018-12-31     12201.0  Affoltern am Albis    2.0   \n",
       "\n",
       "  wikidata_id  \n",
       "0      Q68356  \n",
       "1      Q68210  \n",
       "2      Q68342  \n",
       "3      Q64945  \n",
       "4      Q68290  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_api_qnumber = pd.merge(df_api, swisstopowikidata, how='left', left_on=['BFS_NR'], right_on=['bfs'])\n",
    "print(df_api_qnumber.shape)\n",
    "df_api_qnumber.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(798, 7)\n",
      "[ 36  42  44 132 133 134 140 142 171 174 175 179 217 222]\n"
     ]
    },
    {
     "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>BFS_NR</th>\n",
       "      <th>GEBIET_NAME</th>\n",
       "      <th>date</th>\n",
       "      <th>population</th>\n",
       "      <th>Name</th>\n",
       "      <th>bfs</th>\n",
       "      <th>wikidata_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8024</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1973-12-31</td>\n",
       "      <td>760.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1160</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>1125.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3624</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1998-12-31</td>\n",
       "      <td>1041.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9256</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1966-12-31</td>\n",
       "      <td>850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7496</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1976-12-31</td>\n",
       "      <td>785.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3800</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1997-12-31</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>984</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>2013-12-31</td>\n",
       "      <td>1142.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7320</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1977-12-31</td>\n",
       "      <td>788.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4152</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1995-12-31</td>\n",
       "      <td>1069.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9432</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1965-12-31</td>\n",
       "      <td>831.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7144</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1978-12-31</td>\n",
       "      <td>794.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>808</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>1154.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4328</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1994-12-31</td>\n",
       "      <td>1053.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4504</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1993-12-31</td>\n",
       "      <td>1041.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6968</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1979-12-31</td>\n",
       "      <td>822.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4680</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1992-12-31</td>\n",
       "      <td>1037.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>632</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>1173.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9608</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1964-12-31</td>\n",
       "      <td>834.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7672</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1975-12-31</td>\n",
       "      <td>775.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6792</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1980-12-31</td>\n",
       "      <td>842.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3448</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1999-12-31</td>\n",
       "      <td>1048.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7848</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1974-12-31</td>\n",
       "      <td>746.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8728</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1969-12-31</td>\n",
       "      <td>826.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2040</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>2007-12-31</td>\n",
       "      <td>1069.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1864</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>2008-12-31</td>\n",
       "      <td>1075.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8552</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1970-12-31</td>\n",
       "      <td>765.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2216</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>2006-12-31</td>\n",
       "      <td>1080.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2392</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>2005-12-31</td>\n",
       "      <td>1079.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1688</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>2009-12-31</td>\n",
       "      <td>1066.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8904</th>\n",
       "      <td>36</td>\n",
       "      <td>Oberstammheim (bis 2018)</td>\n",
       "      <td>1968-12-31</td>\n",
       "      <td>819.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8689</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1969-12-31</td>\n",
       "      <td>387.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5345</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1988-12-31</td>\n",
       "      <td>398.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8337</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1971-12-31</td>\n",
       "      <td>381.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2177</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>2006-12-31</td>\n",
       "      <td>430.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2529</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>2004-12-31</td>\n",
       "      <td>420.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8513</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1970-12-31</td>\n",
       "      <td>381.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2353</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>2005-12-31</td>\n",
       "      <td>416.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3761</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1997-12-31</td>\n",
       "      <td>431.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5169</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1989-12-31</td>\n",
       "      <td>396.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>769</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>482.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1649</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>2009-12-31</td>\n",
       "      <td>432.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9041</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1967-12-31</td>\n",
       "      <td>372.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7985</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1973-12-31</td>\n",
       "      <td>386.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3057</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>2001-12-31</td>\n",
       "      <td>435.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4641</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1992-12-31</td>\n",
       "      <td>396.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5697</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1986-12-31</td>\n",
       "      <td>372.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>945</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>2013-12-31</td>\n",
       "      <td>481.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9393</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1965-12-31</td>\n",
       "      <td>425.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3585</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1998-12-31</td>\n",
       "      <td>430.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8161</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1972-12-31</td>\n",
       "      <td>383.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6929</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1979-12-31</td>\n",
       "      <td>376.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7281</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1977-12-31</td>\n",
       "      <td>386.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9217</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1966-12-31</td>\n",
       "      <td>414.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7633</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1975-12-31</td>\n",
       "      <td>385.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1297</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>2011-12-31</td>\n",
       "      <td>472.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2881</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>2002-12-31</td>\n",
       "      <td>419.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5521</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1987-12-31</td>\n",
       "      <td>382.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1473</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>2010-12-31</td>\n",
       "      <td>447.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1121</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>481.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6049</th>\n",
       "      <td>222</td>\n",
       "      <td>Hofstetten (bis 2017)</td>\n",
       "      <td>1984-12-31</td>\n",
       "      <td>372.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>798 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      BFS_NR               GEBIET_NAME        date  population Name  bfs  \\\n",
       "8024      36  Oberstammheim (bis 2018)  1973-12-31       760.0  NaN  NaN   \n",
       "1160      36  Oberstammheim (bis 2018)  2012-12-31      1125.0  NaN  NaN   \n",
       "3624      36  Oberstammheim (bis 2018)  1998-12-31      1041.0  NaN  NaN   \n",
       "9256      36  Oberstammheim (bis 2018)  1966-12-31       850.0  NaN  NaN   \n",
       "7496      36  Oberstammheim (bis 2018)  1976-12-31       785.0  NaN  NaN   \n",
       "3800      36  Oberstammheim (bis 2018)  1997-12-31      1042.0  NaN  NaN   \n",
       "984       36  Oberstammheim (bis 2018)  2013-12-31      1142.0  NaN  NaN   \n",
       "7320      36  Oberstammheim (bis 2018)  1977-12-31       788.0  NaN  NaN   \n",
       "4152      36  Oberstammheim (bis 2018)  1995-12-31      1069.0  NaN  NaN   \n",
       "9432      36  Oberstammheim (bis 2018)  1965-12-31       831.0  NaN  NaN   \n",
       "7144      36  Oberstammheim (bis 2018)  1978-12-31       794.0  NaN  NaN   \n",
       "808       36  Oberstammheim (bis 2018)  2014-12-31      1154.0  NaN  NaN   \n",
       "4328      36  Oberstammheim (bis 2018)  1994-12-31      1053.0  NaN  NaN   \n",
       "4504      36  Oberstammheim (bis 2018)  1993-12-31      1041.0  NaN  NaN   \n",
       "6968      36  Oberstammheim (bis 2018)  1979-12-31       822.0  NaN  NaN   \n",
       "4680      36  Oberstammheim (bis 2018)  1992-12-31      1037.0  NaN  NaN   \n",
       "632       36  Oberstammheim (bis 2018)  2015-12-31      1173.0  NaN  NaN   \n",
       "9608      36  Oberstammheim (bis 2018)  1964-12-31       834.0  NaN  NaN   \n",
       "7672      36  Oberstammheim (bis 2018)  1975-12-31       775.0  NaN  NaN   \n",
       "6792      36  Oberstammheim (bis 2018)  1980-12-31       842.0  NaN  NaN   \n",
       "3448      36  Oberstammheim (bis 2018)  1999-12-31      1048.0  NaN  NaN   \n",
       "7848      36  Oberstammheim (bis 2018)  1974-12-31       746.0  NaN  NaN   \n",
       "8728      36  Oberstammheim (bis 2018)  1969-12-31       826.0  NaN  NaN   \n",
       "2040      36  Oberstammheim (bis 2018)  2007-12-31      1069.0  NaN  NaN   \n",
       "1864      36  Oberstammheim (bis 2018)  2008-12-31      1075.0  NaN  NaN   \n",
       "8552      36  Oberstammheim (bis 2018)  1970-12-31       765.0  NaN  NaN   \n",
       "2216      36  Oberstammheim (bis 2018)  2006-12-31      1080.0  NaN  NaN   \n",
       "2392      36  Oberstammheim (bis 2018)  2005-12-31      1079.0  NaN  NaN   \n",
       "1688      36  Oberstammheim (bis 2018)  2009-12-31      1066.0  NaN  NaN   \n",
       "8904      36  Oberstammheim (bis 2018)  1968-12-31       819.0  NaN  NaN   \n",
       "...      ...                       ...         ...         ...  ...  ...   \n",
       "8689     222     Hofstetten (bis 2017)  1969-12-31       387.0  NaN  NaN   \n",
       "5345     222     Hofstetten (bis 2017)  1988-12-31       398.0  NaN  NaN   \n",
       "8337     222     Hofstetten (bis 2017)  1971-12-31       381.0  NaN  NaN   \n",
       "2177     222     Hofstetten (bis 2017)  2006-12-31       430.0  NaN  NaN   \n",
       "2529     222     Hofstetten (bis 2017)  2004-12-31       420.0  NaN  NaN   \n",
       "8513     222     Hofstetten (bis 2017)  1970-12-31       381.0  NaN  NaN   \n",
       "2353     222     Hofstetten (bis 2017)  2005-12-31       416.0  NaN  NaN   \n",
       "3761     222     Hofstetten (bis 2017)  1997-12-31       431.0  NaN  NaN   \n",
       "5169     222     Hofstetten (bis 2017)  1989-12-31       396.0  NaN  NaN   \n",
       "769      222     Hofstetten (bis 2017)  2014-12-31       482.0  NaN  NaN   \n",
       "1649     222     Hofstetten (bis 2017)  2009-12-31       432.0  NaN  NaN   \n",
       "9041     222     Hofstetten (bis 2017)  1967-12-31       372.0  NaN  NaN   \n",
       "7985     222     Hofstetten (bis 2017)  1973-12-31       386.0  NaN  NaN   \n",
       "3057     222     Hofstetten (bis 2017)  2001-12-31       435.0  NaN  NaN   \n",
       "4641     222     Hofstetten (bis 2017)  1992-12-31       396.0  NaN  NaN   \n",
       "5697     222     Hofstetten (bis 2017)  1986-12-31       372.0  NaN  NaN   \n",
       "945      222     Hofstetten (bis 2017)  2013-12-31       481.0  NaN  NaN   \n",
       "9393     222     Hofstetten (bis 2017)  1965-12-31       425.0  NaN  NaN   \n",
       "3585     222     Hofstetten (bis 2017)  1998-12-31       430.0  NaN  NaN   \n",
       "8161     222     Hofstetten (bis 2017)  1972-12-31       383.0  NaN  NaN   \n",
       "6929     222     Hofstetten (bis 2017)  1979-12-31       376.0  NaN  NaN   \n",
       "7281     222     Hofstetten (bis 2017)  1977-12-31       386.0  NaN  NaN   \n",
       "9217     222     Hofstetten (bis 2017)  1966-12-31       414.0  NaN  NaN   \n",
       "7633     222     Hofstetten (bis 2017)  1975-12-31       385.0  NaN  NaN   \n",
       "1297     222     Hofstetten (bis 2017)  2011-12-31       472.0  NaN  NaN   \n",
       "2881     222     Hofstetten (bis 2017)  2002-12-31       419.0  NaN  NaN   \n",
       "5521     222     Hofstetten (bis 2017)  1987-12-31       382.0  NaN  NaN   \n",
       "1473     222     Hofstetten (bis 2017)  2010-12-31       447.0  NaN  NaN   \n",
       "1121     222     Hofstetten (bis 2017)  2012-12-31       481.0  NaN  NaN   \n",
       "6049     222     Hofstetten (bis 2017)  1984-12-31       372.0  NaN  NaN   \n",
       "\n",
       "     wikidata_id  \n",
       "8024         NaN  \n",
       "1160         NaN  \n",
       "3624         NaN  \n",
       "9256         NaN  \n",
       "7496         NaN  \n",
       "3800         NaN  \n",
       "984          NaN  \n",
       "7320         NaN  \n",
       "4152         NaN  \n",
       "9432         NaN  \n",
       "7144         NaN  \n",
       "808          NaN  \n",
       "4328         NaN  \n",
       "4504         NaN  \n",
       "6968         NaN  \n",
       "4680         NaN  \n",
       "632          NaN  \n",
       "9608         NaN  \n",
       "7672         NaN  \n",
       "6792         NaN  \n",
       "3448         NaN  \n",
       "7848         NaN  \n",
       "8728         NaN  \n",
       "2040         NaN  \n",
       "1864         NaN  \n",
       "8552         NaN  \n",
       "2216         NaN  \n",
       "2392         NaN  \n",
       "1688         NaN  \n",
       "8904         NaN  \n",
       "...          ...  \n",
       "8689         NaN  \n",
       "5345         NaN  \n",
       "8337         NaN  \n",
       "2177         NaN  \n",
       "2529         NaN  \n",
       "8513         NaN  \n",
       "2353         NaN  \n",
       "3761         NaN  \n",
       "5169         NaN  \n",
       "769          NaN  \n",
       "1649         NaN  \n",
       "9041         NaN  \n",
       "7985         NaN  \n",
       "3057         NaN  \n",
       "4641         NaN  \n",
       "5697         NaN  \n",
       "945          NaN  \n",
       "9393         NaN  \n",
       "3585         NaN  \n",
       "8161         NaN  \n",
       "6929         NaN  \n",
       "7281         NaN  \n",
       "9217         NaN  \n",
       "7633         NaN  \n",
       "1297         NaN  \n",
       "2881         NaN  \n",
       "5521         NaN  \n",
       "1473         NaN  \n",
       "1121         NaN  \n",
       "6049         NaN  \n",
       "\n",
       "[798 rows x 7 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# view na in kantonZHapiANDswisstopowikidata\n",
    "df_api_qnumber_na = df_api_qnumber[df_api_qnumber.isna().any(axis=1)].sort_values(by=['BFS_NR'])\n",
    "print(df_api_qnumber_na.shape)\n",
    "print(df_api_qnumber_na.BFS_NR.unique()) # !!! Warum sind für diese keine Q Wikinr. vorhanden?)\n",
    "df_api_qnumber_na"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>BFS_NR</th>\n",
       "      <th>GEBIET_NAME</th>\n",
       "      <th>date</th>\n",
       "      <th>population</th>\n",
       "      <th>Name</th>\n",
       "      <th>bfs</th>\n",
       "      <th>wikidata_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>4961.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>4925.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>4896.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>539</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>4837.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>4718.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2013-12-31</td>\n",
       "      <td>4650.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1067</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>4569.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1243</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2011-12-31</td>\n",
       "      <td>4550.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1419</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2010-12-31</td>\n",
       "      <td>4522.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1595</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2009-12-31</td>\n",
       "      <td>4516.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1771</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2008-12-31</td>\n",
       "      <td>4523.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1947</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2007-12-31</td>\n",
       "      <td>4544.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2123</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2006-12-31</td>\n",
       "      <td>4549.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2299</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2005-12-31</td>\n",
       "      <td>4469.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2475</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2004-12-31</td>\n",
       "      <td>4555.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2651</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2003-12-31</td>\n",
       "      <td>4579.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2827</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2002-12-31</td>\n",
       "      <td>4582.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3003</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2001-12-31</td>\n",
       "      <td>4521.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3179</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>4520.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3355</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1999-12-31</td>\n",
       "      <td>4538.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3531</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1998-12-31</td>\n",
       "      <td>4585.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3707</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1997-12-31</td>\n",
       "      <td>4663.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3883</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1996-12-31</td>\n",
       "      <td>4608.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4059</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1995-12-31</td>\n",
       "      <td>4548.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4235</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1994-12-31</td>\n",
       "      <td>4445.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4411</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1993-12-31</td>\n",
       "      <td>4396.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1992-12-31</td>\n",
       "      <td>4322.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4763</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1991-12-31</td>\n",
       "      <td>4261.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4939</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1990-12-31</td>\n",
       "      <td>4155.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5115</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1989-12-31</td>\n",
       "      <td>4066.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5291</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1988-12-31</td>\n",
       "      <td>3810.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5467</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1987-12-31</td>\n",
       "      <td>3802.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5643</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1986-12-31</td>\n",
       "      <td>3763.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5819</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1985-12-31</td>\n",
       "      <td>3722.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5995</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1984-12-31</td>\n",
       "      <td>3715.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6171</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1983-12-31</td>\n",
       "      <td>3533.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6347</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1982-12-31</td>\n",
       "      <td>3570.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6523</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1981-12-31</td>\n",
       "      <td>3506.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6699</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1980-12-31</td>\n",
       "      <td>3353.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6875</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1979-12-31</td>\n",
       "      <td>3354.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7051</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1978-12-31</td>\n",
       "      <td>3332.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7227</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1977-12-31</td>\n",
       "      <td>3267.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7403</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1976-12-31</td>\n",
       "      <td>3292.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7579</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1975-12-31</td>\n",
       "      <td>3300.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7755</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1974-12-31</td>\n",
       "      <td>3331.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7931</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1973-12-31</td>\n",
       "      <td>3400.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8107</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1972-12-31</td>\n",
       "      <td>3386.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8283</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1971-12-31</td>\n",
       "      <td>3428.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8459</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1970-12-31</td>\n",
       "      <td>3474.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8635</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1969-12-31</td>\n",
       "      <td>3504.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8811</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1968-12-31</td>\n",
       "      <td>3561.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8987</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1967-12-31</td>\n",
       "      <td>3544.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9163</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1966-12-31</td>\n",
       "      <td>3559.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9339</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1965-12-31</td>\n",
       "      <td>3484.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9515</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1964-12-31</td>\n",
       "      <td>3556.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9691</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1963-12-31</td>\n",
       "      <td>3620.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9867</th>\n",
       "      <td>297</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>1962-12-31</td>\n",
       "      <td>3611.0</td>\n",
       "      <td>Bauma</td>\n",
       "      <td>297.0</td>\n",
       "      <td>Q67145</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      BFS_NR GEBIET_NAME        date  population   Name    bfs wikidata_id\n",
       "11       297       Bauma  2018-12-31      4961.0  Bauma  297.0      Q67145\n",
       "187      297       Bauma  2017-12-31      4925.0  Bauma  297.0      Q67145\n",
       "363      297       Bauma  2016-12-31      4896.0  Bauma  297.0      Q67145\n",
       "539      297       Bauma  2015-12-31      4837.0  Bauma  297.0      Q67145\n",
       "715      297       Bauma  2014-12-31      4718.0  Bauma  297.0      Q67145\n",
       "891      297       Bauma  2013-12-31      4650.0  Bauma  297.0      Q67145\n",
       "1067     297       Bauma  2012-12-31      4569.0  Bauma  297.0      Q67145\n",
       "1243     297       Bauma  2011-12-31      4550.0  Bauma  297.0      Q67145\n",
       "1419     297       Bauma  2010-12-31      4522.0  Bauma  297.0      Q67145\n",
       "1595     297       Bauma  2009-12-31      4516.0  Bauma  297.0      Q67145\n",
       "1771     297       Bauma  2008-12-31      4523.0  Bauma  297.0      Q67145\n",
       "1947     297       Bauma  2007-12-31      4544.0  Bauma  297.0      Q67145\n",
       "2123     297       Bauma  2006-12-31      4549.0  Bauma  297.0      Q67145\n",
       "2299     297       Bauma  2005-12-31      4469.0  Bauma  297.0      Q67145\n",
       "2475     297       Bauma  2004-12-31      4555.0  Bauma  297.0      Q67145\n",
       "2651     297       Bauma  2003-12-31      4579.0  Bauma  297.0      Q67145\n",
       "2827     297       Bauma  2002-12-31      4582.0  Bauma  297.0      Q67145\n",
       "3003     297       Bauma  2001-12-31      4521.0  Bauma  297.0      Q67145\n",
       "3179     297       Bauma  2000-12-31      4520.0  Bauma  297.0      Q67145\n",
       "3355     297       Bauma  1999-12-31      4538.0  Bauma  297.0      Q67145\n",
       "3531     297       Bauma  1998-12-31      4585.0  Bauma  297.0      Q67145\n",
       "3707     297       Bauma  1997-12-31      4663.0  Bauma  297.0      Q67145\n",
       "3883     297       Bauma  1996-12-31      4608.0  Bauma  297.0      Q67145\n",
       "4059     297       Bauma  1995-12-31      4548.0  Bauma  297.0      Q67145\n",
       "4235     297       Bauma  1994-12-31      4445.0  Bauma  297.0      Q67145\n",
       "4411     297       Bauma  1993-12-31      4396.0  Bauma  297.0      Q67145\n",
       "4587     297       Bauma  1992-12-31      4322.0  Bauma  297.0      Q67145\n",
       "4763     297       Bauma  1991-12-31      4261.0  Bauma  297.0      Q67145\n",
       "4939     297       Bauma  1990-12-31      4155.0  Bauma  297.0      Q67145\n",
       "5115     297       Bauma  1989-12-31      4066.0  Bauma  297.0      Q67145\n",
       "5291     297       Bauma  1988-12-31      3810.0  Bauma  297.0      Q67145\n",
       "5467     297       Bauma  1987-12-31      3802.0  Bauma  297.0      Q67145\n",
       "5643     297       Bauma  1986-12-31      3763.0  Bauma  297.0      Q67145\n",
       "5819     297       Bauma  1985-12-31      3722.0  Bauma  297.0      Q67145\n",
       "5995     297       Bauma  1984-12-31      3715.0  Bauma  297.0      Q67145\n",
       "6171     297       Bauma  1983-12-31      3533.0  Bauma  297.0      Q67145\n",
       "6347     297       Bauma  1982-12-31      3570.0  Bauma  297.0      Q67145\n",
       "6523     297       Bauma  1981-12-31      3506.0  Bauma  297.0      Q67145\n",
       "6699     297       Bauma  1980-12-31      3353.0  Bauma  297.0      Q67145\n",
       "6875     297       Bauma  1979-12-31      3354.0  Bauma  297.0      Q67145\n",
       "7051     297       Bauma  1978-12-31      3332.0  Bauma  297.0      Q67145\n",
       "7227     297       Bauma  1977-12-31      3267.0  Bauma  297.0      Q67145\n",
       "7403     297       Bauma  1976-12-31      3292.0  Bauma  297.0      Q67145\n",
       "7579     297       Bauma  1975-12-31      3300.0  Bauma  297.0      Q67145\n",
       "7755     297       Bauma  1974-12-31      3331.0  Bauma  297.0      Q67145\n",
       "7931     297       Bauma  1973-12-31      3400.0  Bauma  297.0      Q67145\n",
       "8107     297       Bauma  1972-12-31      3386.0  Bauma  297.0      Q67145\n",
       "8283     297       Bauma  1971-12-31      3428.0  Bauma  297.0      Q67145\n",
       "8459     297       Bauma  1970-12-31      3474.0  Bauma  297.0      Q67145\n",
       "8635     297       Bauma  1969-12-31      3504.0  Bauma  297.0      Q67145\n",
       "8811     297       Bauma  1968-12-31      3561.0  Bauma  297.0      Q67145\n",
       "8987     297       Bauma  1967-12-31      3544.0  Bauma  297.0      Q67145\n",
       "9163     297       Bauma  1966-12-31      3559.0  Bauma  297.0      Q67145\n",
       "9339     297       Bauma  1965-12-31      3484.0  Bauma  297.0      Q67145\n",
       "9515     297       Bauma  1964-12-31      3556.0  Bauma  297.0      Q67145\n",
       "9691     297       Bauma  1963-12-31      3620.0  Bauma  297.0      Q67145\n",
       "9867     297       Bauma  1962-12-31      3611.0  Bauma  297.0      Q67145"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_api_qnumber[df_api_qnumber['BFS_NR']==297]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>BFS_NR</th>\n",
       "      <th>GEBIET_NAME</th>\n",
       "      <th>date</th>\n",
       "      <th>population</th>\n",
       "      <th>Name</th>\n",
       "      <th>bfs</th>\n",
       "      <th>wikidata_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>716</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>4367.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2013-12-31</td>\n",
       "      <td>4297.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1068</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>4218.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1244</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2011-12-31</td>\n",
       "      <td>4199.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1420</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2010-12-31</td>\n",
       "      <td>4160.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1596</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2009-12-31</td>\n",
       "      <td>4150.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1772</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2008-12-31</td>\n",
       "      <td>4172.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1948</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2007-12-31</td>\n",
       "      <td>4191.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2124</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2006-12-31</td>\n",
       "      <td>4191.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2300</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2005-12-31</td>\n",
       "      <td>4118.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2476</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2004-12-31</td>\n",
       "      <td>4186.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2652</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2003-12-31</td>\n",
       "      <td>4213.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2828</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2002-12-31</td>\n",
       "      <td>4223.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3004</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2001-12-31</td>\n",
       "      <td>4192.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3180</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>4171.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3356</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1999-12-31</td>\n",
       "      <td>4197.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3532</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1998-12-31</td>\n",
       "      <td>4234.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3708</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1997-12-31</td>\n",
       "      <td>4308.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3884</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1996-12-31</td>\n",
       "      <td>4266.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4060</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1995-12-31</td>\n",
       "      <td>4190.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4236</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1994-12-31</td>\n",
       "      <td>4101.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4412</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1993-12-31</td>\n",
       "      <td>4053.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4588</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1992-12-31</td>\n",
       "      <td>3973.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4764</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1991-12-31</td>\n",
       "      <td>3900.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4940</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1990-12-31</td>\n",
       "      <td>3795.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5116</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1989-12-31</td>\n",
       "      <td>3708.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5292</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1988-12-31</td>\n",
       "      <td>3460.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5468</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1987-12-31</td>\n",
       "      <td>3448.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5644</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1986-12-31</td>\n",
       "      <td>3412.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5820</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1985-12-31</td>\n",
       "      <td>3390.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5996</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1984-12-31</td>\n",
       "      <td>3391.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6172</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1983-12-31</td>\n",
       "      <td>3222.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6348</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1982-12-31</td>\n",
       "      <td>3269.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6524</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1981-12-31</td>\n",
       "      <td>3194.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6700</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1980-12-31</td>\n",
       "      <td>3056.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6876</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1979-12-31</td>\n",
       "      <td>3072.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7052</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1978-12-31</td>\n",
       "      <td>3052.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7228</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1977-12-31</td>\n",
       "      <td>2987.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7404</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1976-12-31</td>\n",
       "      <td>3005.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7580</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1975-12-31</td>\n",
       "      <td>3005.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7756</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1974-12-31</td>\n",
       "      <td>3038.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7932</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1973-12-31</td>\n",
       "      <td>3106.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8108</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1972-12-31</td>\n",
       "      <td>3082.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8284</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1971-12-31</td>\n",
       "      <td>3120.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8460</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1970-12-31</td>\n",
       "      <td>3159.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8636</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1969-12-31</td>\n",
       "      <td>3215.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8812</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1968-12-31</td>\n",
       "      <td>3260.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8988</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1967-12-31</td>\n",
       "      <td>3233.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9164</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1966-12-31</td>\n",
       "      <td>3208.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9340</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1965-12-31</td>\n",
       "      <td>3103.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9516</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1964-12-31</td>\n",
       "      <td>3164.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9692</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1963-12-31</td>\n",
       "      <td>3232.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9868</th>\n",
       "      <td>171</td>\n",
       "      <td>Bauma (bis 2014)</td>\n",
       "      <td>1962-12-31</td>\n",
       "      <td>3220.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      BFS_NR       GEBIET_NAME        date  population Name  bfs wikidata_id\n",
       "12       171  Bauma (bis 2014)  2018-12-31         NaN  NaN  NaN         NaN\n",
       "188      171  Bauma (bis 2014)  2017-12-31         NaN  NaN  NaN         NaN\n",
       "364      171  Bauma (bis 2014)  2016-12-31         NaN  NaN  NaN         NaN\n",
       "540      171  Bauma (bis 2014)  2015-12-31         NaN  NaN  NaN         NaN\n",
       "716      171  Bauma (bis 2014)  2014-12-31      4367.0  NaN  NaN         NaN\n",
       "892      171  Bauma (bis 2014)  2013-12-31      4297.0  NaN  NaN         NaN\n",
       "1068     171  Bauma (bis 2014)  2012-12-31      4218.0  NaN  NaN         NaN\n",
       "1244     171  Bauma (bis 2014)  2011-12-31      4199.0  NaN  NaN         NaN\n",
       "1420     171  Bauma (bis 2014)  2010-12-31      4160.0  NaN  NaN         NaN\n",
       "1596     171  Bauma (bis 2014)  2009-12-31      4150.0  NaN  NaN         NaN\n",
       "1772     171  Bauma (bis 2014)  2008-12-31      4172.0  NaN  NaN         NaN\n",
       "1948     171  Bauma (bis 2014)  2007-12-31      4191.0  NaN  NaN         NaN\n",
       "2124     171  Bauma (bis 2014)  2006-12-31      4191.0  NaN  NaN         NaN\n",
       "2300     171  Bauma (bis 2014)  2005-12-31      4118.0  NaN  NaN         NaN\n",
       "2476     171  Bauma (bis 2014)  2004-12-31      4186.0  NaN  NaN         NaN\n",
       "2652     171  Bauma (bis 2014)  2003-12-31      4213.0  NaN  NaN         NaN\n",
       "2828     171  Bauma (bis 2014)  2002-12-31      4223.0  NaN  NaN         NaN\n",
       "3004     171  Bauma (bis 2014)  2001-12-31      4192.0  NaN  NaN         NaN\n",
       "3180     171  Bauma (bis 2014)  2000-12-31      4171.0  NaN  NaN         NaN\n",
       "3356     171  Bauma (bis 2014)  1999-12-31      4197.0  NaN  NaN         NaN\n",
       "3532     171  Bauma (bis 2014)  1998-12-31      4234.0  NaN  NaN         NaN\n",
       "3708     171  Bauma (bis 2014)  1997-12-31      4308.0  NaN  NaN         NaN\n",
       "3884     171  Bauma (bis 2014)  1996-12-31      4266.0  NaN  NaN         NaN\n",
       "4060     171  Bauma (bis 2014)  1995-12-31      4190.0  NaN  NaN         NaN\n",
       "4236     171  Bauma (bis 2014)  1994-12-31      4101.0  NaN  NaN         NaN\n",
       "4412     171  Bauma (bis 2014)  1993-12-31      4053.0  NaN  NaN         NaN\n",
       "4588     171  Bauma (bis 2014)  1992-12-31      3973.0  NaN  NaN         NaN\n",
       "4764     171  Bauma (bis 2014)  1991-12-31      3900.0  NaN  NaN         NaN\n",
       "4940     171  Bauma (bis 2014)  1990-12-31      3795.0  NaN  NaN         NaN\n",
       "5116     171  Bauma (bis 2014)  1989-12-31      3708.0  NaN  NaN         NaN\n",
       "5292     171  Bauma (bis 2014)  1988-12-31      3460.0  NaN  NaN         NaN\n",
       "5468     171  Bauma (bis 2014)  1987-12-31      3448.0  NaN  NaN         NaN\n",
       "5644     171  Bauma (bis 2014)  1986-12-31      3412.0  NaN  NaN         NaN\n",
       "5820     171  Bauma (bis 2014)  1985-12-31      3390.0  NaN  NaN         NaN\n",
       "5996     171  Bauma (bis 2014)  1984-12-31      3391.0  NaN  NaN         NaN\n",
       "6172     171  Bauma (bis 2014)  1983-12-31      3222.0  NaN  NaN         NaN\n",
       "6348     171  Bauma (bis 2014)  1982-12-31      3269.0  NaN  NaN         NaN\n",
       "6524     171  Bauma (bis 2014)  1981-12-31      3194.0  NaN  NaN         NaN\n",
       "6700     171  Bauma (bis 2014)  1980-12-31      3056.0  NaN  NaN         NaN\n",
       "6876     171  Bauma (bis 2014)  1979-12-31      3072.0  NaN  NaN         NaN\n",
       "7052     171  Bauma (bis 2014)  1978-12-31      3052.0  NaN  NaN         NaN\n",
       "7228     171  Bauma (bis 2014)  1977-12-31      2987.0  NaN  NaN         NaN\n",
       "7404     171  Bauma (bis 2014)  1976-12-31      3005.0  NaN  NaN         NaN\n",
       "7580     171  Bauma (bis 2014)  1975-12-31      3005.0  NaN  NaN         NaN\n",
       "7756     171  Bauma (bis 2014)  1974-12-31      3038.0  NaN  NaN         NaN\n",
       "7932     171  Bauma (bis 2014)  1973-12-31      3106.0  NaN  NaN         NaN\n",
       "8108     171  Bauma (bis 2014)  1972-12-31      3082.0  NaN  NaN         NaN\n",
       "8284     171  Bauma (bis 2014)  1971-12-31      3120.0  NaN  NaN         NaN\n",
       "8460     171  Bauma (bis 2014)  1970-12-31      3159.0  NaN  NaN         NaN\n",
       "8636     171  Bauma (bis 2014)  1969-12-31      3215.0  NaN  NaN         NaN\n",
       "8812     171  Bauma (bis 2014)  1968-12-31      3260.0  NaN  NaN         NaN\n",
       "8988     171  Bauma (bis 2014)  1967-12-31      3233.0  NaN  NaN         NaN\n",
       "9164     171  Bauma (bis 2014)  1966-12-31      3208.0  NaN  NaN         NaN\n",
       "9340     171  Bauma (bis 2014)  1965-12-31      3103.0  NaN  NaN         NaN\n",
       "9516     171  Bauma (bis 2014)  1964-12-31      3164.0  NaN  NaN         NaN\n",
       "9692     171  Bauma (bis 2014)  1963-12-31      3232.0  NaN  NaN         NaN\n",
       "9868     171  Bauma (bis 2014)  1962-12-31      3220.0  NaN  NaN         NaN"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_api_qnumber[df_api_qnumber['BFS_NR']==171]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>BFS_NR</th>\n",
       "      <th>GEBIET_NAME</th>\n",
       "      <th>date</th>\n",
       "      <th>population</th>\n",
       "      <th>Name</th>\n",
       "      <th>bfs</th>\n",
       "      <th>wikidata_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>844</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>351.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1020</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2013-12-31</td>\n",
       "      <td>353.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1196</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>351.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1372</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2011-12-31</td>\n",
       "      <td>351.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1548</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2010-12-31</td>\n",
       "      <td>362.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1724</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2009-12-31</td>\n",
       "      <td>366.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1900</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2008-12-31</td>\n",
       "      <td>351.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2076</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2007-12-31</td>\n",
       "      <td>353.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2252</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2006-12-31</td>\n",
       "      <td>358.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2428</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2005-12-31</td>\n",
       "      <td>351.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2604</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2004-12-31</td>\n",
       "      <td>369.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2780</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2003-12-31</td>\n",
       "      <td>366.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2956</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2002-12-31</td>\n",
       "      <td>359.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3132</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2001-12-31</td>\n",
       "      <td>329.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3308</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>349.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3484</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1999-12-31</td>\n",
       "      <td>341.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3660</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1998-12-31</td>\n",
       "      <td>351.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3836</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1997-12-31</td>\n",
       "      <td>355.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4012</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1996-12-31</td>\n",
       "      <td>342.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4188</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1995-12-31</td>\n",
       "      <td>358.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4364</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1994-12-31</td>\n",
       "      <td>344.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4540</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1993-12-31</td>\n",
       "      <td>343.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4716</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1992-12-31</td>\n",
       "      <td>349.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4892</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1991-12-31</td>\n",
       "      <td>361.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5068</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1990-12-31</td>\n",
       "      <td>360.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5244</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1989-12-31</td>\n",
       "      <td>358.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5420</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1988-12-31</td>\n",
       "      <td>350.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5596</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1987-12-31</td>\n",
       "      <td>354.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5772</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1986-12-31</td>\n",
       "      <td>351.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5948</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1985-12-31</td>\n",
       "      <td>332.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6124</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1984-12-31</td>\n",
       "      <td>324.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6300</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1983-12-31</td>\n",
       "      <td>311.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6476</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1982-12-31</td>\n",
       "      <td>301.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6652</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1981-12-31</td>\n",
       "      <td>312.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6828</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1980-12-31</td>\n",
       "      <td>297.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7004</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1979-12-31</td>\n",
       "      <td>282.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7180</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1978-12-31</td>\n",
       "      <td>280.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7356</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1977-12-31</td>\n",
       "      <td>280.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7532</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1976-12-31</td>\n",
       "      <td>287.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7708</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1975-12-31</td>\n",
       "      <td>295.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7884</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1974-12-31</td>\n",
       "      <td>293.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8060</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1973-12-31</td>\n",
       "      <td>294.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8236</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1972-12-31</td>\n",
       "      <td>304.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8412</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1971-12-31</td>\n",
       "      <td>308.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8588</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1970-12-31</td>\n",
       "      <td>315.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8764</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1969-12-31</td>\n",
       "      <td>289.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8940</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1968-12-31</td>\n",
       "      <td>301.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9116</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1967-12-31</td>\n",
       "      <td>311.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9292</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1966-12-31</td>\n",
       "      <td>351.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9468</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1965-12-31</td>\n",
       "      <td>381.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9644</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1964-12-31</td>\n",
       "      <td>392.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9820</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1963-12-31</td>\n",
       "      <td>388.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9996</th>\n",
       "      <td>179</td>\n",
       "      <td>Sternenberg (bis 2014)</td>\n",
       "      <td>1962-12-31</td>\n",
       "      <td>391.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      BFS_NR             GEBIET_NAME        date  population Name  bfs  \\\n",
       "140      179  Sternenberg (bis 2014)  2018-12-31         NaN  NaN  NaN   \n",
       "316      179  Sternenberg (bis 2014)  2017-12-31         NaN  NaN  NaN   \n",
       "492      179  Sternenberg (bis 2014)  2016-12-31         NaN  NaN  NaN   \n",
       "668      179  Sternenberg (bis 2014)  2015-12-31         NaN  NaN  NaN   \n",
       "844      179  Sternenberg (bis 2014)  2014-12-31       351.0  NaN  NaN   \n",
       "1020     179  Sternenberg (bis 2014)  2013-12-31       353.0  NaN  NaN   \n",
       "1196     179  Sternenberg (bis 2014)  2012-12-31       351.0  NaN  NaN   \n",
       "1372     179  Sternenberg (bis 2014)  2011-12-31       351.0  NaN  NaN   \n",
       "1548     179  Sternenberg (bis 2014)  2010-12-31       362.0  NaN  NaN   \n",
       "1724     179  Sternenberg (bis 2014)  2009-12-31       366.0  NaN  NaN   \n",
       "1900     179  Sternenberg (bis 2014)  2008-12-31       351.0  NaN  NaN   \n",
       "2076     179  Sternenberg (bis 2014)  2007-12-31       353.0  NaN  NaN   \n",
       "2252     179  Sternenberg (bis 2014)  2006-12-31       358.0  NaN  NaN   \n",
       "2428     179  Sternenberg (bis 2014)  2005-12-31       351.0  NaN  NaN   \n",
       "2604     179  Sternenberg (bis 2014)  2004-12-31       369.0  NaN  NaN   \n",
       "2780     179  Sternenberg (bis 2014)  2003-12-31       366.0  NaN  NaN   \n",
       "2956     179  Sternenberg (bis 2014)  2002-12-31       359.0  NaN  NaN   \n",
       "3132     179  Sternenberg (bis 2014)  2001-12-31       329.0  NaN  NaN   \n",
       "3308     179  Sternenberg (bis 2014)  2000-12-31       349.0  NaN  NaN   \n",
       "3484     179  Sternenberg (bis 2014)  1999-12-31       341.0  NaN  NaN   \n",
       "3660     179  Sternenberg (bis 2014)  1998-12-31       351.0  NaN  NaN   \n",
       "3836     179  Sternenberg (bis 2014)  1997-12-31       355.0  NaN  NaN   \n",
       "4012     179  Sternenberg (bis 2014)  1996-12-31       342.0  NaN  NaN   \n",
       "4188     179  Sternenberg (bis 2014)  1995-12-31       358.0  NaN  NaN   \n",
       "4364     179  Sternenberg (bis 2014)  1994-12-31       344.0  NaN  NaN   \n",
       "4540     179  Sternenberg (bis 2014)  1993-12-31       343.0  NaN  NaN   \n",
       "4716     179  Sternenberg (bis 2014)  1992-12-31       349.0  NaN  NaN   \n",
       "4892     179  Sternenberg (bis 2014)  1991-12-31       361.0  NaN  NaN   \n",
       "5068     179  Sternenberg (bis 2014)  1990-12-31       360.0  NaN  NaN   \n",
       "5244     179  Sternenberg (bis 2014)  1989-12-31       358.0  NaN  NaN   \n",
       "5420     179  Sternenberg (bis 2014)  1988-12-31       350.0  NaN  NaN   \n",
       "5596     179  Sternenberg (bis 2014)  1987-12-31       354.0  NaN  NaN   \n",
       "5772     179  Sternenberg (bis 2014)  1986-12-31       351.0  NaN  NaN   \n",
       "5948     179  Sternenberg (bis 2014)  1985-12-31       332.0  NaN  NaN   \n",
       "6124     179  Sternenberg (bis 2014)  1984-12-31       324.0  NaN  NaN   \n",
       "6300     179  Sternenberg (bis 2014)  1983-12-31       311.0  NaN  NaN   \n",
       "6476     179  Sternenberg (bis 2014)  1982-12-31       301.0  NaN  NaN   \n",
       "6652     179  Sternenberg (bis 2014)  1981-12-31       312.0  NaN  NaN   \n",
       "6828     179  Sternenberg (bis 2014)  1980-12-31       297.0  NaN  NaN   \n",
       "7004     179  Sternenberg (bis 2014)  1979-12-31       282.0  NaN  NaN   \n",
       "7180     179  Sternenberg (bis 2014)  1978-12-31       280.0  NaN  NaN   \n",
       "7356     179  Sternenberg (bis 2014)  1977-12-31       280.0  NaN  NaN   \n",
       "7532     179  Sternenberg (bis 2014)  1976-12-31       287.0  NaN  NaN   \n",
       "7708     179  Sternenberg (bis 2014)  1975-12-31       295.0  NaN  NaN   \n",
       "7884     179  Sternenberg (bis 2014)  1974-12-31       293.0  NaN  NaN   \n",
       "8060     179  Sternenberg (bis 2014)  1973-12-31       294.0  NaN  NaN   \n",
       "8236     179  Sternenberg (bis 2014)  1972-12-31       304.0  NaN  NaN   \n",
       "8412     179  Sternenberg (bis 2014)  1971-12-31       308.0  NaN  NaN   \n",
       "8588     179  Sternenberg (bis 2014)  1970-12-31       315.0  NaN  NaN   \n",
       "8764     179  Sternenberg (bis 2014)  1969-12-31       289.0  NaN  NaN   \n",
       "8940     179  Sternenberg (bis 2014)  1968-12-31       301.0  NaN  NaN   \n",
       "9116     179  Sternenberg (bis 2014)  1967-12-31       311.0  NaN  NaN   \n",
       "9292     179  Sternenberg (bis 2014)  1966-12-31       351.0  NaN  NaN   \n",
       "9468     179  Sternenberg (bis 2014)  1965-12-31       381.0  NaN  NaN   \n",
       "9644     179  Sternenberg (bis 2014)  1964-12-31       392.0  NaN  NaN   \n",
       "9820     179  Sternenberg (bis 2014)  1963-12-31       388.0  NaN  NaN   \n",
       "9996     179  Sternenberg (bis 2014)  1962-12-31       391.0  NaN  NaN   \n",
       "\n",
       "     wikidata_id  \n",
       "140          NaN  \n",
       "316          NaN  \n",
       "492          NaN  \n",
       "668          NaN  \n",
       "844          NaN  \n",
       "1020         NaN  \n",
       "1196         NaN  \n",
       "1372         NaN  \n",
       "1548         NaN  \n",
       "1724         NaN  \n",
       "1900         NaN  \n",
       "2076         NaN  \n",
       "2252         NaN  \n",
       "2428         NaN  \n",
       "2604         NaN  \n",
       "2780         NaN  \n",
       "2956         NaN  \n",
       "3132         NaN  \n",
       "3308         NaN  \n",
       "3484         NaN  \n",
       "3660         NaN  \n",
       "3836         NaN  \n",
       "4012         NaN  \n",
       "4188         NaN  \n",
       "4364         NaN  \n",
       "4540         NaN  \n",
       "4716         NaN  \n",
       "4892         NaN  \n",
       "5068         NaN  \n",
       "5244         NaN  \n",
       "5420         NaN  \n",
       "5596         NaN  \n",
       "5772         NaN  \n",
       "5948         NaN  \n",
       "6124         NaN  \n",
       "6300         NaN  \n",
       "6476         NaN  \n",
       "6652         NaN  \n",
       "6828         NaN  \n",
       "7004         NaN  \n",
       "7180         NaN  \n",
       "7356         NaN  \n",
       "7532         NaN  \n",
       "7708         NaN  \n",
       "7884         NaN  \n",
       "8060         NaN  \n",
       "8236         NaN  \n",
       "8412         NaN  \n",
       "8588         NaN  \n",
       "8764         NaN  \n",
       "8940         NaN  \n",
       "9116         NaN  \n",
       "9292         NaN  \n",
       "9468         NaN  \n",
       "9644         NaN  \n",
       "9820         NaN  \n",
       "9996         NaN  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_api_qnumber[df_api_qnumber['BFS_NR']==179]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(9234, 7)\n"
     ]
    },
    {
     "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>BFS_NR</th>\n",
       "      <th>GEBIET_NAME</th>\n",
       "      <th>date</th>\n",
       "      <th>population</th>\n",
       "      <th>Name</th>\n",
       "      <th>bfs</th>\n",
       "      <th>wikidata_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21</td>\n",
       "      <td>Adlikon</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>707.0</td>\n",
       "      <td>Adlikon</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Q68356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>131</td>\n",
       "      <td>Adliswil</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>18681.0</td>\n",
       "      <td>Adliswil</td>\n",
       "      <td>131.0</td>\n",
       "      <td>Q68210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>241</td>\n",
       "      <td>Aesch ZH</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>1555.0</td>\n",
       "      <td>Aesch (ZH)</td>\n",
       "      <td>241.0</td>\n",
       "      <td>Q68342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>Aeugst a.A.</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>1979.0</td>\n",
       "      <td>Aeugst am Albis</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Q64945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>Affoltern a.A.</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>12201.0</td>\n",
       "      <td>Affoltern am Albis</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Q68290</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   BFS_NR     GEBIET_NAME        date  population                Name    bfs  \\\n",
       "0      21         Adlikon  2018-12-31       707.0             Adlikon   21.0   \n",
       "1     131        Adliswil  2018-12-31     18681.0            Adliswil  131.0   \n",
       "2     241        Aesch ZH  2018-12-31      1555.0          Aesch (ZH)  241.0   \n",
       "3       1     Aeugst a.A.  2018-12-31      1979.0     Aeugst am Albis    1.0   \n",
       "4       2  Affoltern a.A.  2018-12-31     12201.0  Affoltern am Albis    2.0   \n",
       "\n",
       "  wikidata_id  \n",
       "0      Q68356  \n",
       "1      Q68210  \n",
       "2      Q68342  \n",
       "3      Q64945  \n",
       "4      Q68290  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_api_qnumber_dropna = pd.merge(df_api, swisstopowikidata, how='left', left_on=['BFS_NR'], right_on=['bfs']).dropna()\n",
    "print(df_api_qnumber_dropna.shape)\n",
    "df_api_qnumber_dropna.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "check ok\n",
      "check ok\n"
     ]
    }
   ],
   "source": [
    "# check1\n",
    "if df_api_qnumber_na.shape[0] + df_api_qnumber_dropna.shape[0] == df_api_qnumber.shape[0]:\n",
    "    print(\"check ok\")\n",
    "    \n",
    "# check2\n",
    "if len(df_api_qnumber_dropna.BFS_NR.unique()) == 162: # TODO !!! 162 should be variable !!!\n",
    "    print(\"check ok\")    "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "***\n",
    "# Merge df_api with wikidata TODO !!!! MESSY !!!\n",
    "\n",
    "\n",
    "Aim: Check population and ... ???\n",
    "\n",
    "***"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_api_qnumber_dropna['check'] = df_api_qnumber_dropna['date'].astype(str) + '---' + df_api['BFS_NR'].astype(str)\n",
    "df_wikidata['check'] = df_wikidata['date'].astype(str) + '---' + df_wikidata['bfs_id'].astype(str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['BFS_NR', 'GEBIET_NAME', 'date', 'population', 'Name', 'bfs',\n",
      "       'wikidata_id', 'check'],\n",
      "      dtype='object')\n",
      "(8871, 8)\n"
     ]
    },
    {
     "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>BFS_NR</th>\n",
       "      <th>GEBIET_NAME</th>\n",
       "      <th>date</th>\n",
       "      <th>population</th>\n",
       "      <th>Name</th>\n",
       "      <th>bfs</th>\n",
       "      <th>wikidata_id</th>\n",
       "      <th>check</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>292</td>\n",
       "      <td>Stammheim</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>2740.0</td>\n",
       "      <td>Stammheim</td>\n",
       "      <td>292.0</td>\n",
       "      <td>Q60322693</td>\n",
       "      <td>2018-12-31---292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>294</td>\n",
       "      <td>Elgg</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>4903.0</td>\n",
       "      <td>Elgg</td>\n",
       "      <td>294.0</td>\n",
       "      <td>Q67137</td>\n",
       "      <td>2017-12-31---294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>292</td>\n",
       "      <td>Stammheim</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>2741.0</td>\n",
       "      <td>Stammheim</td>\n",
       "      <td>292.0</td>\n",
       "      <td>Q60322693</td>\n",
       "      <td>2017-12-31---292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>21</td>\n",
       "      <td>Adlikon</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>662.0</td>\n",
       "      <td>Adlikon</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Q68356</td>\n",
       "      <td>2016-12-31---21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353</th>\n",
       "      <td>131</td>\n",
       "      <td>Adliswil</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>18651.0</td>\n",
       "      <td>Adliswil</td>\n",
       "      <td>131.0</td>\n",
       "      <td>Q68210</td>\n",
       "      <td>2016-12-31---131</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     BFS_NR GEBIET_NAME        date  population       Name    bfs wikidata_id  \\\n",
       "138     292   Stammheim  2018-12-31      2740.0  Stammheim  292.0   Q60322693   \n",
       "213     294        Elgg  2017-12-31      4903.0       Elgg  294.0      Q67137   \n",
       "314     292   Stammheim  2017-12-31      2741.0  Stammheim  292.0   Q60322693   \n",
       "352      21     Adlikon  2016-12-31       662.0    Adlikon   21.0      Q68356   \n",
       "353     131    Adliswil  2016-12-31     18651.0   Adliswil  131.0      Q68210   \n",
       "\n",
       "                check  \n",
       "138  2018-12-31---292  \n",
       "213  2017-12-31---294  \n",
       "314  2017-12-31---292  \n",
       "352   2016-12-31---21  \n",
       "353  2016-12-31---131  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_api_sel_f = df_api_qnumber_dropna[(df_api_qnumber_dropna['check'].isin(df_wikidata['check']) == False)]\n",
    "df_api_sel_f.to_csv(\"test.tsv\", header = True, sep='\\t')\n",
    "print(df_api_sel_f.columns)\n",
    "print(df_api_sel_f.shape)\n",
    "df_api_sel_f.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['BFS_NR', 'GEBIET_NAME', 'date', 'population', 'Name', 'bfs',\n",
      "       'wikidata_id', 'check'],\n",
      "      dtype='object')\n",
      "(363, 8)\n"
     ]
    },
    {
     "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>BFS_NR</th>\n",
       "      <th>GEBIET_NAME</th>\n",
       "      <th>date</th>\n",
       "      <th>population</th>\n",
       "      <th>Name</th>\n",
       "      <th>bfs</th>\n",
       "      <th>wikidata_id</th>\n",
       "      <th>check</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21</td>\n",
       "      <td>Adlikon</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>707.0</td>\n",
       "      <td>Adlikon</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Q68356</td>\n",
       "      <td>2018-12-31---21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>131</td>\n",
       "      <td>Adliswil</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>18681.0</td>\n",
       "      <td>Adliswil</td>\n",
       "      <td>131.0</td>\n",
       "      <td>Q68210</td>\n",
       "      <td>2018-12-31---131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>241</td>\n",
       "      <td>Aesch ZH</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>1555.0</td>\n",
       "      <td>Aesch (ZH)</td>\n",
       "      <td>241.0</td>\n",
       "      <td>Q68342</td>\n",
       "      <td>2018-12-31---241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>Aeugst a.A.</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>1979.0</td>\n",
       "      <td>Aeugst am Albis</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Q64945</td>\n",
       "      <td>2018-12-31---1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>Affoltern a.A.</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>12201.0</td>\n",
       "      <td>Affoltern am Albis</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Q68290</td>\n",
       "      <td>2018-12-31---2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   BFS_NR     GEBIET_NAME        date  population                Name    bfs  \\\n",
       "0      21         Adlikon  2018-12-31       707.0             Adlikon   21.0   \n",
       "1     131        Adliswil  2018-12-31     18681.0            Adliswil  131.0   \n",
       "2     241        Aesch ZH  2018-12-31      1555.0          Aesch (ZH)  241.0   \n",
       "3       1     Aeugst a.A.  2018-12-31      1979.0     Aeugst am Albis    1.0   \n",
       "4       2  Affoltern a.A.  2018-12-31     12201.0  Affoltern am Albis    2.0   \n",
       "\n",
       "  wikidata_id             check  \n",
       "0      Q68356   2018-12-31---21  \n",
       "1      Q68210  2018-12-31---131  \n",
       "2      Q68342  2018-12-31---241  \n",
       "3      Q64945    2018-12-31---1  \n",
       "4      Q68290    2018-12-31---2  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_api_sel_t = df_api_qnumber_dropna[(df_api_qnumber_dropna['check'].isin(df_wikidata['check']) == True)]\n",
    "print(df_api_sel_t.columns)\n",
    "print(df_api_sel_t.shape)\n",
    "df_api_sel_t.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "'check'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-28-16e79dace8b4>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf_api_wikidata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmerge\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdf_api\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdf_wikidata\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mhow\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'left'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mleft_on\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'check'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mright_on\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'check'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      2\u001b[0m \u001b[0;31m#print(df_api_wikidata.columns)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0;31m#print(df_api_wikidata.shape)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[0;31m#print(df_api_wikidata.shape)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m \u001b[0;31m#df_api_wikidata[[\"Name\", \"BFS_NR\", \"wikidata_id_y\", \"date_x\", \"date_y\", \"population_x\", \"population_y\", \"refurl\"]].sort_values(by=['BFS_NR'])\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/srv/paws/lib/python3.6/site-packages/pandas/core/reshape/merge.py\u001b[0m in \u001b[0;36mmerge\u001b[0;34m(left, right, how, on, left_on, right_on, left_index, right_index, sort, suffixes, copy, indicator, validate)\u001b[0m\n\u001b[1;32m     45\u001b[0m                          \u001b[0mright_index\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mright_index\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0msort\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0msort\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0msuffixes\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0msuffixes\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     46\u001b[0m                          \u001b[0mcopy\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mcopy\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mindicator\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mindicator\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 47\u001b[0;31m                          validate=validate)\n\u001b[0m\u001b[1;32m     48\u001b[0m     \u001b[0;32mreturn\u001b[0m \u001b[0mop\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_result\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     49\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/srv/paws/lib/python3.6/site-packages/pandas/core/reshape/merge.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, left, right, how, on, left_on, right_on, axis, left_index, right_index, sort, suffixes, copy, indicator, validate)\u001b[0m\n\u001b[1;32m    527\u001b[0m         (self.left_join_keys,\n\u001b[1;32m    528\u001b[0m          \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mright_join_keys\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 529\u001b[0;31m          self.join_names) = self._get_merge_keys()\n\u001b[0m\u001b[1;32m    530\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    531\u001b[0m         \u001b[0;31m# validate the merge keys dtypes. We may need to coerce\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/srv/paws/lib/python3.6/site-packages/pandas/core/reshape/merge.py\u001b[0m in \u001b[0;36m_get_merge_keys\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    844\u001b[0m                         \u001b[0mright_keys\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrk\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    845\u001b[0m                     \u001b[0;32mif\u001b[0m \u001b[0mlk\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 846\u001b[0;31m                         \u001b[0mleft_keys\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mleft\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_label_or_level_values\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlk\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    847\u001b[0m                         \u001b[0mjoin_names\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlk\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    848\u001b[0m                     \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/srv/paws/lib/python3.6/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36m_get_label_or_level_values\u001b[0;34m(self, key, axis)\u001b[0m\n\u001b[1;32m   1704\u001b[0m             \u001b[0mvalues\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0maxes\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0maxis\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_level_values\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_values\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1705\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1706\u001b[0;31m             \u001b[0;32mraise\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1707\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1708\u001b[0m         \u001b[0;31m# Check for duplicates\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: 'check'"
     ]
    }
   ],
   "source": [
    "df_api_wikidata = pd.merge(df_api_sel_t, df_wikidata, how='left', left_on=['check'], right_on=['check'])\n",
    "# df_api instead of df_api_sel_t ???\n",
    "print(df_api_wikidata.columns)\n",
    "print(df_api_wikidata.shape)\n",
    "print(df_api_wikidata.shape)\n",
    "df_api_wikidata[[\"Name\", \"BFS_NR\", \"wikidata_id_y\", \"date_x\", \"date_y\", \"population_x\", \"population_y\", \"refurl\"]].sort_values(by=['BFS_NR'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(23, 15)\n"
     ]
    },
    {
     "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>BFS_NR</th>\n",
       "      <th>GEBIET_NAME</th>\n",
       "      <th>date_x</th>\n",
       "      <th>population_x</th>\n",
       "      <th>Name</th>\n",
       "      <th>bfs</th>\n",
       "      <th>wikidata_id_x</th>\n",
       "      <th>check</th>\n",
       "      <th>bfs_id</th>\n",
       "      <th>date_y</th>\n",
       "      <th>population_y</th>\n",
       "      <th>qualifier</th>\n",
       "      <th>refpublisher</th>\n",
       "      <th>refurl</th>\n",
       "      <th>wikidata_id_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>102</td>\n",
       "      <td>Weiach</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1750.0</td>\n",
       "      <td>Weiach</td>\n",
       "      <td>102.0</td>\n",
       "      <td>Q70088</td>\n",
       "      <td>2017-12-31---102</td>\n",
       "      <td>102</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1750</td>\n",
       "      <td>PreferredRank</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://www.weiach.ch/page/13</td>\n",
       "      <td>Q70088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>102</td>\n",
       "      <td>Weiach</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1750.0</td>\n",
       "      <td>Weiach</td>\n",
       "      <td>102.0</td>\n",
       "      <td>Q70088</td>\n",
       "      <td>2017-12-31---102</td>\n",
       "      <td>102</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1756</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...</td>\n",
       "      <td>Q70088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>178</td>\n",
       "      <td>Russikon</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>4355.0</td>\n",
       "      <td>Russikon</td>\n",
       "      <td>178.0</td>\n",
       "      <td>Q67957</td>\n",
       "      <td>2017-12-31---178</td>\n",
       "      <td>178</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>4367</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...</td>\n",
       "      <td>Q67957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>336</th>\n",
       "      <td>181</td>\n",
       "      <td>Wila</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>Wila</td>\n",
       "      <td>181.0</td>\n",
       "      <td>Q66752</td>\n",
       "      <td>2017-12-31---181</td>\n",
       "      <td>181</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1975</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...</td>\n",
       "      <td>Q66752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>248</td>\n",
       "      <td>Uitikon</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>4239.0</td>\n",
       "      <td>Uitikon</td>\n",
       "      <td>248.0</td>\n",
       "      <td>Q66678</td>\n",
       "      <td>2017-12-31---248</td>\n",
       "      <td>248</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>4245</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...</td>\n",
       "      <td>Q66678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>295</td>\n",
       "      <td>Horgen</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>22411.0</td>\n",
       "      <td>Horgen</td>\n",
       "      <td>295.0</td>\n",
       "      <td>Q68286</td>\n",
       "      <td>2017-12-31---295</td>\n",
       "      <td>295</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>22476</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>Q68286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>32</td>\n",
       "      <td>Humlikon</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>486.0</td>\n",
       "      <td>Humlikon</td>\n",
       "      <td>32.0</td>\n",
       "      <td>Q68447</td>\n",
       "      <td>2017-12-31---32</td>\n",
       "      <td>32</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>486</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://statistik.zh.ch/internet/justiz_innere...</td>\n",
       "      <td>Q68447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>32</td>\n",
       "      <td>Humlikon</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>486.0</td>\n",
       "      <td>Humlikon</td>\n",
       "      <td>32.0</td>\n",
       "      <td>Q68447</td>\n",
       "      <td>2017-12-31---32</td>\n",
       "      <td>32</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>486</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://statistik.zh.ch/internet/justiz_innere...</td>\n",
       "      <td>Q68447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>70</td>\n",
       "      <td>Wasterkingen</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>574.0</td>\n",
       "      <td>Wasterkingen</td>\n",
       "      <td>70.0</td>\n",
       "      <td>Q67882</td>\n",
       "      <td>2017-12-31---70</td>\n",
       "      <td>70</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>574</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...</td>\n",
       "      <td>Q67882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>70</td>\n",
       "      <td>Wasterkingen</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>574.0</td>\n",
       "      <td>Wasterkingen</td>\n",
       "      <td>70.0</td>\n",
       "      <td>Q67882</td>\n",
       "      <td>2017-12-31---70</td>\n",
       "      <td>70</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>574</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://statistik.zh.ch/internet/justiz_innere...</td>\n",
       "      <td>Q67882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>334</th>\n",
       "      <td>71</td>\n",
       "      <td>Wil</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1407.0</td>\n",
       "      <td>Wil (ZH)</td>\n",
       "      <td>71.0</td>\n",
       "      <td>Q67223</td>\n",
       "      <td>2017-12-31---71</td>\n",
       "      <td>71</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1407</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...</td>\n",
       "      <td>Q67223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>333</th>\n",
       "      <td>71</td>\n",
       "      <td>Wil</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1407.0</td>\n",
       "      <td>Wil (ZH)</td>\n",
       "      <td>71.0</td>\n",
       "      <td>Q67223</td>\n",
       "      <td>2017-12-31---71</td>\n",
       "      <td>71</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1407</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://statistik.zh.ch/internet/justiz_innere...</td>\n",
       "      <td>Q67223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>93</td>\n",
       "      <td>Oberweningen</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1797.0</td>\n",
       "      <td>Oberweningen</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Q70264</td>\n",
       "      <td>2017-12-31---93</td>\n",
       "      <td>93</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1802</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...</td>\n",
       "      <td>Q70264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>98</td>\n",
       "      <td>Schleinikon</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>736.0</td>\n",
       "      <td>Schleinikon</td>\n",
       "      <td>98.0</td>\n",
       "      <td>Q67884</td>\n",
       "      <td>2017-12-31---98</td>\n",
       "      <td>98</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>736</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...</td>\n",
       "      <td>Q67884</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>178</td>\n",
       "      <td>Russikon</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>4355.0</td>\n",
       "      <td>Russikon</td>\n",
       "      <td>178.0</td>\n",
       "      <td>Q67957</td>\n",
       "      <td>2018-12-31---178</td>\n",
       "      <td>178</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>4367</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...</td>\n",
       "      <td>Q67957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>223</td>\n",
       "      <td>Neftenbach</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>5672.0</td>\n",
       "      <td>Neftenbach</td>\n",
       "      <td>223.0</td>\n",
       "      <td>Q65040</td>\n",
       "      <td>2018-12-31---223</td>\n",
       "      <td>223</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>5692</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>NA</td>\n",
       "      <td>http://www.neftenbach.ch/de/ueberunsmain/gemei...</td>\n",
       "      <td>Q65040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>41</td>\n",
       "      <td>Truttikon</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>478.0</td>\n",
       "      <td>Truttikon</td>\n",
       "      <td>41.0</td>\n",
       "      <td>Q70072</td>\n",
       "      <td>2018-12-31---41</td>\n",
       "      <td>41</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>477</td>\n",
       "      <td>PreferredRank</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://statistik.zh.ch/internet/justiz_innere...</td>\n",
       "      <td>Q70072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>41</td>\n",
       "      <td>Truttikon</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>478.0</td>\n",
       "      <td>Truttikon</td>\n",
       "      <td>41.0</td>\n",
       "      <td>Q70072</td>\n",
       "      <td>2018-12-31---41</td>\n",
       "      <td>41</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>477</td>\n",
       "      <td>PreferredRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.bfs.admin.ch/bfs/de/home/statistik...</td>\n",
       "      <td>Q70072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>57</td>\n",
       "      <td>Freienstein-Teufen</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>2367.0</td>\n",
       "      <td>Freienstein-Teufen</td>\n",
       "      <td>57.0</td>\n",
       "      <td>Q66964</td>\n",
       "      <td>2018-12-31---57</td>\n",
       "      <td>57</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>2371</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://statistik.zh.ch/internet/justiz_innere...</td>\n",
       "      <td>Q66964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>57</td>\n",
       "      <td>Freienstein-Teufen</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>2367.0</td>\n",
       "      <td>Freienstein-Teufen</td>\n",
       "      <td>57.0</td>\n",
       "      <td>Q66964</td>\n",
       "      <td>2018-12-31---57</td>\n",
       "      <td>57</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>2371</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.bfs.admin.ch/bfs/de/home/statistik...</td>\n",
       "      <td>Q66964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>87</td>\n",
       "      <td>Hüttikon</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>922.0</td>\n",
       "      <td>Hüttikon</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Q65671</td>\n",
       "      <td>2018-12-31---87</td>\n",
       "      <td>87</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>925</td>\n",
       "      <td>PreferredRank</td>\n",
       "      <td>NA</td>\n",
       "      <td>https://statistik.zh.ch/internet/justiz_innere...</td>\n",
       "      <td>Q65671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>87</td>\n",
       "      <td>Hüttikon</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>922.0</td>\n",
       "      <td>Hüttikon</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Q65671</td>\n",
       "      <td>2018-12-31---87</td>\n",
       "      <td>87</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>925</td>\n",
       "      <td>PreferredRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.bfs.admin.ch/bfs/de/home/statistik...</td>\n",
       "      <td>Q65671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>93</td>\n",
       "      <td>Oberweningen</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>1799.0</td>\n",
       "      <td>Oberweningen</td>\n",
       "      <td>93.0</td>\n",
       "      <td>Q70264</td>\n",
       "      <td>2018-12-31---93</td>\n",
       "      <td>93</td>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>1802</td>\n",
       "      <td>NormalRank</td>\n",
       "      <td>http://www.wikidata.org/entity/Q285453</td>\n",
       "      <td>https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...</td>\n",
       "      <td>Q70264</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     BFS_NR         GEBIET_NAME      date_x  population_x                Name  \\\n",
       "326     102              Weiach  2017-12-31        1750.0              Weiach   \n",
       "325     102              Weiach  2017-12-31        1750.0              Weiach   \n",
       "290     178            Russikon  2017-12-31        4355.0            Russikon   \n",
       "336     181                Wila  2017-12-31        1975.0                Wila   \n",
       "311     248             Uitikon  2017-12-31        4239.0             Uitikon   \n",
       "233     295              Horgen  2017-12-31       22411.0              Horgen   \n",
       "236      32            Humlikon  2017-12-31         486.0            Humlikon   \n",
       "237      32            Humlikon  2017-12-31         486.0            Humlikon   \n",
       "322      70        Wasterkingen  2017-12-31         574.0        Wasterkingen   \n",
       "323      70        Wasterkingen  2017-12-31         574.0        Wasterkingen   \n",
       "334      71                 Wil  2017-12-31        1407.0            Wil (ZH)   \n",
       "333      71                 Wil  2017-12-31        1407.0            Wil (ZH)   \n",
       "269      93        Oberweningen  2017-12-31        1797.0        Oberweningen   \n",
       "294      98         Schleinikon  2017-12-31         736.0         Schleinikon   \n",
       "123     178            Russikon  2018-12-31        4355.0            Russikon   \n",
       "92      223          Neftenbach  2018-12-31        5672.0          Neftenbach   \n",
       "141      41           Truttikon  2018-12-31         478.0           Truttikon   \n",
       "140      41           Truttikon  2018-12-31         478.0           Truttikon   \n",
       "49       57  Freienstein-Teufen  2018-12-31        2367.0  Freienstein-Teufen   \n",
       "48       57  Freienstein-Teufen  2018-12-31        2367.0  Freienstein-Teufen   \n",
       "71       87            Hüttikon  2018-12-31         922.0            Hüttikon   \n",
       "70       87            Hüttikon  2018-12-31         922.0            Hüttikon   \n",
       "102      93        Oberweningen  2018-12-31        1799.0        Oberweningen   \n",
       "\n",
       "       bfs wikidata_id_x             check  bfs_id      date_y population_y  \\\n",
       "326  102.0        Q70088  2017-12-31---102     102  2017-12-31         1750   \n",
       "325  102.0        Q70088  2017-12-31---102     102  2017-12-31         1756   \n",
       "290  178.0        Q67957  2017-12-31---178     178  2017-12-31         4367   \n",
       "336  181.0        Q66752  2017-12-31---181     181  2017-12-31         1975   \n",
       "311  248.0        Q66678  2017-12-31---248     248  2017-12-31         4245   \n",
       "233  295.0        Q68286  2017-12-31---295     295  2017-12-31        22476   \n",
       "236   32.0        Q68447   2017-12-31---32      32  2017-12-31          486   \n",
       "237   32.0        Q68447   2017-12-31---32      32  2017-12-31          486   \n",
       "322   70.0        Q67882   2017-12-31---70      70  2017-12-31          574   \n",
       "323   70.0        Q67882   2017-12-31---70      70  2017-12-31          574   \n",
       "334   71.0        Q67223   2017-12-31---71      71  2017-12-31         1407   \n",
       "333   71.0        Q67223   2017-12-31---71      71  2017-12-31         1407   \n",
       "269   93.0        Q70264   2017-12-31---93      93  2017-12-31         1802   \n",
       "294   98.0        Q67884   2017-12-31---98      98  2017-12-31          736   \n",
       "123  178.0        Q67957  2018-12-31---178     178  2018-12-31         4367   \n",
       "92   223.0        Q65040  2018-12-31---223     223  2018-12-31         5692   \n",
       "141   41.0        Q70072   2018-12-31---41      41  2018-12-31          477   \n",
       "140   41.0        Q70072   2018-12-31---41      41  2018-12-31          477   \n",
       "49    57.0        Q66964   2018-12-31---57      57  2018-12-31         2371   \n",
       "48    57.0        Q66964   2018-12-31---57      57  2018-12-31         2371   \n",
       "71    87.0        Q65671   2018-12-31---87      87  2018-12-31          925   \n",
       "70    87.0        Q65671   2018-12-31---87      87  2018-12-31          925   \n",
       "102   93.0        Q70264   2018-12-31---93      93  2018-12-31         1802   \n",
       "\n",
       "         qualifier                            refpublisher  \\\n",
       "326  PreferredRank                                      NA   \n",
       "325     NormalRank  http://www.wikidata.org/entity/Q285453   \n",
       "290     NormalRank  http://www.wikidata.org/entity/Q285453   \n",
       "336     NormalRank  http://www.wikidata.org/entity/Q285453   \n",
       "311     NormalRank  http://www.wikidata.org/entity/Q285453   \n",
       "233     NormalRank                                      NA   \n",
       "236     NormalRank                                      NA   \n",
       "237     NormalRank                                      NA   \n",
       "322     NormalRank  http://www.wikidata.org/entity/Q285453   \n",
       "323     NormalRank                                      NA   \n",
       "334     NormalRank  http://www.wikidata.org/entity/Q285453   \n",
       "333     NormalRank                                      NA   \n",
       "269     NormalRank  http://www.wikidata.org/entity/Q285453   \n",
       "294     NormalRank  http://www.wikidata.org/entity/Q285453   \n",
       "123     NormalRank  http://www.wikidata.org/entity/Q285453   \n",
       "92      NormalRank                                      NA   \n",
       "141  PreferredRank                                      NA   \n",
       "140  PreferredRank  http://www.wikidata.org/entity/Q285453   \n",
       "49      NormalRank                                      NA   \n",
       "48      NormalRank  http://www.wikidata.org/entity/Q285453   \n",
       "71   PreferredRank                                      NA   \n",
       "70   PreferredRank  http://www.wikidata.org/entity/Q285453   \n",
       "102     NormalRank  http://www.wikidata.org/entity/Q285453   \n",
       "\n",
       "                                                refurl wikidata_id_y  \n",
       "326                      https://www.weiach.ch/page/13        Q70088  \n",
       "325  https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...        Q70088  \n",
       "290  https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...        Q67957  \n",
       "336  https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...        Q66752  \n",
       "311  https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...        Q66678  \n",
       "233                                                 NA        Q68286  \n",
       "236  https://statistik.zh.ch/internet/justiz_innere...        Q68447  \n",
       "237  https://statistik.zh.ch/internet/justiz_innere...        Q68447  \n",
       "322  https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...        Q67882  \n",
       "323  https://statistik.zh.ch/internet/justiz_innere...        Q67882  \n",
       "334  https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...        Q67223  \n",
       "333  https://statistik.zh.ch/internet/justiz_innere...        Q67223  \n",
       "269  https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...        Q70264  \n",
       "294  https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...        Q67884  \n",
       "123  https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...        Q67957  \n",
       "92   http://www.neftenbach.ch/de/ueberunsmain/gemei...        Q65040  \n",
       "141  https://statistik.zh.ch/internet/justiz_innere...        Q70072  \n",
       "140  https://www.bfs.admin.ch/bfs/de/home/statistik...        Q70072  \n",
       "49   https://statistik.zh.ch/internet/justiz_innere...        Q66964  \n",
       "48   https://www.bfs.admin.ch/bfs/de/home/statistik...        Q66964  \n",
       "71   https://statistik.zh.ch/internet/justiz_innere...        Q65671  \n",
       "70   https://www.bfs.admin.ch/bfs/de/home/statistik...        Q65671  \n",
       "102  https://www.pxweb.bfs.admin.ch/pxweb/de/px-x-0...        Q70264  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Find rows where check is duplicated\n",
    "duplicate = df_api_wikidata[df_api_wikidata.duplicated(['check'])]\n",
    "print(duplicate.shape)\n",
    "duplicate.sort_values(by=['check'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "check ok\n"
     ]
    }
   ],
   "source": [
    "# check\n",
    "if duplicate.shape[0] + df_api_sel_t.shape[0] == df_api_wikidata.shape[0]:\n",
    "    print(\"check ok\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "161\n",
      "176\n",
      "162\n",
      "161\n"
     ]
    }
   ],
   "source": [
    "# should be 162\n",
    "print(len(df_api_wikidata.BFS_NR.unique())) # one is missing\n",
    "\n",
    "print(len(df_api.BFS_NR.unique())) #too many because of \"Gemeindefusion\"\n",
    "\n",
    "print(len(df_api_qnumber_dropna.BFS_NR.unique())) #ok\n",
    "\n",
    "print(len(df_api_sel_t.BFS_NR.unique())) # one is missing\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}