Sterbefaelle_Destatis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "xlsFileUrl = \"https://www.destatis.de/DE/Themen/Gesellschaft-Umwelt/Bevoelkerung/Sterbefaelle-Lebenserwartung/Tabellen/sonderauswertung-sterbefaelle.xlsx?__blob=publicationFile\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Sterbefälle Bundesländer nach Kalenderwochen - Jahresangaben in Excel Tabellenblatt beachten\n",
    "sterbefaelle = pd.read_excel(xlsFileUrl, \"BL_2016_2022_KW_AG_Ins\", skiprows=8)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Sterbefälle Deutschland nach Kalenderwochen - Jahresangaben in Excel Tabellenblatt beachten\n",
    "sterbefaelleD = pd.read_excel(xlsFileUrl, \"D_2016_2022_KW_AG_Ins\" ,skiprows=8)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "sterbefaelleInsgesamt = sterbefaelle[sterbefaelle[\"unter … Jahren\"]==\"Insgesamt\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "sterbefaelleDInsgesamt = sterbefaelleD[sterbefaelleD[\"unter … Jahren\"]==\"Insgesamt\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "sterbefaelleInsg = sterbefaelleInsgesamt.drop(columns=[\"unter … Jahren\",\"Nr.\"]).replace({\"Baden-Württemberg\" : \"BW\",\"Bayern\" : \"BY\",\"Berlin\" : \"BE\",\"Brandenburg\" : \"BB\",\"Bremen\" : \"HB\",\"Hamburg\" : \"HH\",\"Hessen\" : \"HE\",\"Mecklenburg-Vorpommern\" : \"MV\",\"Niedersachsen\" : \"NI\",\"Nordrhein-Westfalen\" : \"NW\",\"Rheinland-Pfalz\" : \"RP\",\"Saarland\" : \"SL\",\"Sachsen\" : \"SN\",\"Sachsen-Anhalt\" : \"ST\",\"Schleswig-Holstein\" : \"SH\",\"Thüringen\" : \"TH\"})"
   ]
  },
  {
   "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>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>...</th>\n",
       "      <th>44</th>\n",
       "      <th>45</th>\n",
       "      <th>46</th>\n",
       "      <th>47</th>\n",
       "      <th>48</th>\n",
       "      <th>49</th>\n",
       "      <th>50</th>\n",
       "      <th>51</th>\n",
       "      <th>52</th>\n",
       "      <th>53</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021</td>\n",
       "      <td>SH</td>\n",
       "      <td>804</td>\n",
       "      <td>794</td>\n",
       "      <td>850</td>\n",
       "      <td>826</td>\n",
       "      <td>778</td>\n",
       "      <td>797</td>\n",
       "      <td>819</td>\n",
       "      <td>677</td>\n",
       "      <td>...</td>\n",
       "      <td>711</td>\n",
       "      <td>705</td>\n",
       "      <td>700</td>\n",
       "      <td>732</td>\n",
       "      <td>770</td>\n",
       "      <td>832</td>\n",
       "      <td>728</td>\n",
       "      <td>786</td>\n",
       "      <td>782</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2021</td>\n",
       "      <td>HH</td>\n",
       "      <td>451</td>\n",
       "      <td>437</td>\n",
       "      <td>463</td>\n",
       "      <td>396</td>\n",
       "      <td>416</td>\n",
       "      <td>363</td>\n",
       "      <td>405</td>\n",
       "      <td>347</td>\n",
       "      <td>...</td>\n",
       "      <td>371</td>\n",
       "      <td>370</td>\n",
       "      <td>378</td>\n",
       "      <td>389</td>\n",
       "      <td>396</td>\n",
       "      <td>400</td>\n",
       "      <td>332</td>\n",
       "      <td>369</td>\n",
       "      <td>400</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2021</td>\n",
       "      <td>NI</td>\n",
       "      <td>2164</td>\n",
       "      <td>2092</td>\n",
       "      <td>2167</td>\n",
       "      <td>2165</td>\n",
       "      <td>2179</td>\n",
       "      <td>2133</td>\n",
       "      <td>2061</td>\n",
       "      <td>1946</td>\n",
       "      <td>...</td>\n",
       "      <td>1931</td>\n",
       "      <td>2049</td>\n",
       "      <td>2142</td>\n",
       "      <td>2081</td>\n",
       "      <td>2163</td>\n",
       "      <td>2187</td>\n",
       "      <td>2113</td>\n",
       "      <td>2055</td>\n",
       "      <td>2117</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2021</td>\n",
       "      <td>HB</td>\n",
       "      <td>181</td>\n",
       "      <td>158</td>\n",
       "      <td>156</td>\n",
       "      <td>148</td>\n",
       "      <td>183</td>\n",
       "      <td>166</td>\n",
       "      <td>165</td>\n",
       "      <td>159</td>\n",
       "      <td>...</td>\n",
       "      <td>150</td>\n",
       "      <td>148</td>\n",
       "      <td>185</td>\n",
       "      <td>175</td>\n",
       "      <td>172</td>\n",
       "      <td>173</td>\n",
       "      <td>166</td>\n",
       "      <td>190</td>\n",
       "      <td>195</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2021</td>\n",
       "      <td>NW</td>\n",
       "      <td>4879</td>\n",
       "      <td>5006</td>\n",
       "      <td>4941</td>\n",
       "      <td>4753</td>\n",
       "      <td>4551</td>\n",
       "      <td>4443</td>\n",
       "      <td>4411</td>\n",
       "      <td>4192</td>\n",
       "      <td>...</td>\n",
       "      <td>4294</td>\n",
       "      <td>4274</td>\n",
       "      <td>4526</td>\n",
       "      <td>4621</td>\n",
       "      <td>5009</td>\n",
       "      <td>4958</td>\n",
       "      <td>4725</td>\n",
       "      <td>4767</td>\n",
       "      <td>4616</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>2016</td>\n",
       "      <td>BB</td>\n",
       "      <td>665</td>\n",
       "      <td>638</td>\n",
       "      <td>649</td>\n",
       "      <td>616</td>\n",
       "      <td>621</td>\n",
       "      <td>659</td>\n",
       "      <td>629</td>\n",
       "      <td>672</td>\n",
       "      <td>...</td>\n",
       "      <td>550</td>\n",
       "      <td>607</td>\n",
       "      <td>563</td>\n",
       "      <td>567</td>\n",
       "      <td>613</td>\n",
       "      <td>627</td>\n",
       "      <td>642</td>\n",
       "      <td>635</td>\n",
       "      <td>637</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>2016</td>\n",
       "      <td>MV</td>\n",
       "      <td>487</td>\n",
       "      <td>461</td>\n",
       "      <td>415</td>\n",
       "      <td>434</td>\n",
       "      <td>439</td>\n",
       "      <td>402</td>\n",
       "      <td>441</td>\n",
       "      <td>434</td>\n",
       "      <td>...</td>\n",
       "      <td>387</td>\n",
       "      <td>352</td>\n",
       "      <td>403</td>\n",
       "      <td>374</td>\n",
       "      <td>403</td>\n",
       "      <td>409</td>\n",
       "      <td>420</td>\n",
       "      <td>430</td>\n",
       "      <td>413</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>2016</td>\n",
       "      <td>SN</td>\n",
       "      <td>1034</td>\n",
       "      <td>1059</td>\n",
       "      <td>1123</td>\n",
       "      <td>1166</td>\n",
       "      <td>1114</td>\n",
       "      <td>1097</td>\n",
       "      <td>1053</td>\n",
       "      <td>1104</td>\n",
       "      <td>...</td>\n",
       "      <td>993</td>\n",
       "      <td>1079</td>\n",
       "      <td>1084</td>\n",
       "      <td>1037</td>\n",
       "      <td>1030</td>\n",
       "      <td>1118</td>\n",
       "      <td>1158</td>\n",
       "      <td>1137</td>\n",
       "      <td>1219</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470</th>\n",
       "      <td>2016</td>\n",
       "      <td>ST</td>\n",
       "      <td>658</td>\n",
       "      <td>650</td>\n",
       "      <td>616</td>\n",
       "      <td>601</td>\n",
       "      <td>635</td>\n",
       "      <td>601</td>\n",
       "      <td>627</td>\n",
       "      <td>700</td>\n",
       "      <td>...</td>\n",
       "      <td>552</td>\n",
       "      <td>607</td>\n",
       "      <td>628</td>\n",
       "      <td>598</td>\n",
       "      <td>651</td>\n",
       "      <td>603</td>\n",
       "      <td>629</td>\n",
       "      <td>680</td>\n",
       "      <td>661</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>2016</td>\n",
       "      <td>TH</td>\n",
       "      <td>568</td>\n",
       "      <td>551</td>\n",
       "      <td>593</td>\n",
       "      <td>624</td>\n",
       "      <td>617</td>\n",
       "      <td>546</td>\n",
       "      <td>629</td>\n",
       "      <td>611</td>\n",
       "      <td>...</td>\n",
       "      <td>571</td>\n",
       "      <td>550</td>\n",
       "      <td>541</td>\n",
       "      <td>579</td>\n",
       "      <td>614</td>\n",
       "      <td>588</td>\n",
       "      <td>599</td>\n",
       "      <td>618</td>\n",
       "      <td>603</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>96 rows × 55 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 1 Unnamed: 2     1     2     3     4     5     6     7     8  \\\n",
       "0          2021         SH   804   794   850   826   778   797   819   677   \n",
       "5          2021         HH   451   437   463   396   416   363   405   347   \n",
       "10         2021         NI  2164  2092  2167  2165  2179  2133  2061  1946   \n",
       "15         2021         HB   181   158   156   148   183   166   165   159   \n",
       "20         2021         NW  4879  5006  4941  4753  4551  4443  4411  4192   \n",
       "..          ...        ...   ...   ...   ...   ...   ...   ...   ...   ...   \n",
       "455        2016         BB   665   638   649   616   621   659   629   672   \n",
       "460        2016         MV   487   461   415   434   439   402   441   434   \n",
       "465        2016         SN  1034  1059  1123  1166  1114  1097  1053  1104   \n",
       "470        2016         ST   658   650   616   601   635   601   627   700   \n",
       "475        2016         TH   568   551   593   624   617   546   629   611   \n",
       "\n",
       "     ...    44    45    46    47    48    49    50    51    52  53  \n",
       "0    ...   711   705   700   732   770   832   728   786   782  X   \n",
       "5    ...   371   370   378   389   396   400   332   369   400  X   \n",
       "10   ...  1931  2049  2142  2081  2163  2187  2113  2055  2117  X   \n",
       "15   ...   150   148   185   175   172   173   166   190   195  X   \n",
       "20   ...  4294  4274  4526  4621  5009  4958  4725  4767  4616  X   \n",
       "..   ...   ...   ...   ...   ...   ...   ...   ...   ...   ...  ..  \n",
       "455  ...   550   607   563   567   613   627   642   635   637  X   \n",
       "460  ...   387   352   403   374   403   409   420   430   413  X   \n",
       "465  ...   993  1079  1084  1037  1030  1118  1158  1137  1219  X   \n",
       "470  ...   552   607   628   598   651   603   629   680   661  X   \n",
       "475  ...   571   550   541   579   614   588   599   618   603  X   \n",
       "\n",
       "[96 rows x 55 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sterbefaelleInsg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "sterbefaelleDInsg = sterbefaelleDInsgesamt.drop(columns=[\"Nr.\"]).rename(columns={\"unter … Jahren\": \"Unnamed: 2\"}).replace({\"Insgesamt\" : \"DE\"})"
   ]
  },
  {
   "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>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>...</th>\n",
       "      <th>44</th>\n",
       "      <th>45</th>\n",
       "      <th>46</th>\n",
       "      <th>47</th>\n",
       "      <th>48</th>\n",
       "      <th>49</th>\n",
       "      <th>50</th>\n",
       "      <th>51</th>\n",
       "      <th>52</th>\n",
       "      <th>53</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022</td>\n",
       "      <td>DE</td>\n",
       "      <td>20430</td>\n",
       "      <td>19532</td>\n",
       "      <td>19537</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2021</td>\n",
       "      <td>DE</td>\n",
       "      <td>24844</td>\n",
       "      <td>24501</td>\n",
       "      <td>24077</td>\n",
       "      <td>22645.0</td>\n",
       "      <td>21736.0</td>\n",
       "      <td>20932.0</td>\n",
       "      <td>20469.0</td>\n",
       "      <td>18950.0</td>\n",
       "      <td>...</td>\n",
       "      <td>20226.0</td>\n",
       "      <td>20930.0</td>\n",
       "      <td>22144.0</td>\n",
       "      <td>23042.0</td>\n",
       "      <td>23968.0</td>\n",
       "      <td>23755.0</td>\n",
       "      <td>22685.0</td>\n",
       "      <td>22272.0</td>\n",
       "      <td>21856.0</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2020</td>\n",
       "      <td>DE</td>\n",
       "      <td>18883</td>\n",
       "      <td>19408</td>\n",
       "      <td>18953</td>\n",
       "      <td>18827.0</td>\n",
       "      <td>19774.0</td>\n",
       "      <td>19038.0</td>\n",
       "      <td>19648.0</td>\n",
       "      <td>18953.0</td>\n",
       "      <td>...</td>\n",
       "      <td>18584.0</td>\n",
       "      <td>19007.0</td>\n",
       "      <td>19727.0</td>\n",
       "      <td>20182.0</td>\n",
       "      <td>21304.0</td>\n",
       "      <td>22604.0</td>\n",
       "      <td>24003.0</td>\n",
       "      <td>24724.0</td>\n",
       "      <td>25554.0</td>\n",
       "      <td>25497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2019</td>\n",
       "      <td>DE</td>\n",
       "      <td>18686</td>\n",
       "      <td>19170</td>\n",
       "      <td>19163</td>\n",
       "      <td>19505.0</td>\n",
       "      <td>19812.0</td>\n",
       "      <td>19981.0</td>\n",
       "      <td>20150.0</td>\n",
       "      <td>20349.0</td>\n",
       "      <td>...</td>\n",
       "      <td>17488.0</td>\n",
       "      <td>17859.0</td>\n",
       "      <td>18242.0</td>\n",
       "      <td>18535.0</td>\n",
       "      <td>18581.0</td>\n",
       "      <td>19143.0</td>\n",
       "      <td>19101.0</td>\n",
       "      <td>19062.0</td>\n",
       "      <td>18204.0</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>2018</td>\n",
       "      <td>DE</td>\n",
       "      <td>19342</td>\n",
       "      <td>18770</td>\n",
       "      <td>19187</td>\n",
       "      <td>19171.0</td>\n",
       "      <td>19558.0</td>\n",
       "      <td>20086.0</td>\n",
       "      <td>21254.0</td>\n",
       "      <td>22888.0</td>\n",
       "      <td>...</td>\n",
       "      <td>16895.0</td>\n",
       "      <td>17604.0</td>\n",
       "      <td>16842.0</td>\n",
       "      <td>17785.0</td>\n",
       "      <td>18091.0</td>\n",
       "      <td>18342.0</td>\n",
       "      <td>17943.0</td>\n",
       "      <td>18990.0</td>\n",
       "      <td>17954.0</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>2017</td>\n",
       "      <td>DE</td>\n",
       "      <td>20918</td>\n",
       "      <td>22070</td>\n",
       "      <td>21236</td>\n",
       "      <td>22083.0</td>\n",
       "      <td>23640.0</td>\n",
       "      <td>22744.0</td>\n",
       "      <td>22683.0</td>\n",
       "      <td>22266.0</td>\n",
       "      <td>...</td>\n",
       "      <td>16762.0</td>\n",
       "      <td>17371.0</td>\n",
       "      <td>17594.0</td>\n",
       "      <td>17676.0</td>\n",
       "      <td>17877.0</td>\n",
       "      <td>18295.0</td>\n",
       "      <td>18504.0</td>\n",
       "      <td>18500.0</td>\n",
       "      <td>18652.0</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>2016</td>\n",
       "      <td>DE</td>\n",
       "      <td>18467</td>\n",
       "      <td>18439</td>\n",
       "      <td>18627</td>\n",
       "      <td>18707.0</td>\n",
       "      <td>18493.0</td>\n",
       "      <td>18541.0</td>\n",
       "      <td>18483.0</td>\n",
       "      <td>18475.0</td>\n",
       "      <td>...</td>\n",
       "      <td>17580.0</td>\n",
       "      <td>17782.0</td>\n",
       "      <td>18591.0</td>\n",
       "      <td>17911.0</td>\n",
       "      <td>18146.0</td>\n",
       "      <td>18793.0</td>\n",
       "      <td>18885.0</td>\n",
       "      <td>19376.0</td>\n",
       "      <td>19744.0</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7 rows × 55 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 1 Unnamed: 2      1      2      3        4        5        6  \\\n",
       "0         2022         DE  20430  19532  19537      NaN      NaN      NaN   \n",
       "16        2021         DE  24844  24501  24077  22645.0  21736.0  20932.0   \n",
       "32        2020         DE  18883  19408  18953  18827.0  19774.0  19038.0   \n",
       "48        2019         DE  18686  19170  19163  19505.0  19812.0  19981.0   \n",
       "64        2018         DE  19342  18770  19187  19171.0  19558.0  20086.0   \n",
       "80        2017         DE  20918  22070  21236  22083.0  23640.0  22744.0   \n",
       "96        2016         DE  18467  18439  18627  18707.0  18493.0  18541.0   \n",
       "\n",
       "          7        8  ...       44       45       46       47       48  \\\n",
       "0       NaN      NaN  ...      NaN      NaN      NaN      NaN      NaN   \n",
       "16  20469.0  18950.0  ...  20226.0  20930.0  22144.0  23042.0  23968.0   \n",
       "32  19648.0  18953.0  ...  18584.0  19007.0  19727.0  20182.0  21304.0   \n",
       "48  20150.0  20349.0  ...  17488.0  17859.0  18242.0  18535.0  18581.0   \n",
       "64  21254.0  22888.0  ...  16895.0  17604.0  16842.0  17785.0  18091.0   \n",
       "80  22683.0  22266.0  ...  16762.0  17371.0  17594.0  17676.0  17877.0   \n",
       "96  18483.0  18475.0  ...  17580.0  17782.0  18591.0  17911.0  18146.0   \n",
       "\n",
       "         49       50       51       52     53  \n",
       "0       NaN      NaN      NaN      NaN    NaN  \n",
       "16  23755.0  22685.0  22272.0  21856.0     X   \n",
       "32  22604.0  24003.0  24724.0  25554.0  25497  \n",
       "48  19143.0  19101.0  19062.0  18204.0     X   \n",
       "64  18342.0  17943.0  18990.0  17954.0     X   \n",
       "80  18295.0  18504.0  18500.0  18652.0     X   \n",
       "96  18793.0  18885.0  19376.0  19744.0     X   \n",
       "\n",
       "[7 rows x 55 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sterbefaelleDInsg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "sterbefaelleInsg=sterbefaelleInsg.append(sterbefaelleDInsg)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "sterbefaelleInsg[\"weekNr\"] = sterbefaelleInsg[\"Unnamed: 2\"] + sterbefaelleInsg[\"Unnamed: 1\"].astype(str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>...</th>\n",
       "      <th>45</th>\n",
       "      <th>46</th>\n",
       "      <th>47</th>\n",
       "      <th>48</th>\n",
       "      <th>49</th>\n",
       "      <th>50</th>\n",
       "      <th>51</th>\n",
       "      <th>52</th>\n",
       "      <th>53</th>\n",
       "      <th>weekNr</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021</td>\n",
       "      <td>SH</td>\n",
       "      <td>804</td>\n",
       "      <td>794</td>\n",
       "      <td>850</td>\n",
       "      <td>826.0</td>\n",
       "      <td>778.0</td>\n",
       "      <td>797.0</td>\n",
       "      <td>819.0</td>\n",
       "      <td>677.0</td>\n",
       "      <td>...</td>\n",
       "      <td>705.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>732.0</td>\n",
       "      <td>770.0</td>\n",
       "      <td>832.0</td>\n",
       "      <td>728.0</td>\n",
       "      <td>786.0</td>\n",
       "      <td>782.0</td>\n",
       "      <td>X</td>\n",
       "      <td>SH2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2021</td>\n",
       "      <td>HH</td>\n",
       "      <td>451</td>\n",
       "      <td>437</td>\n",
       "      <td>463</td>\n",
       "      <td>396.0</td>\n",
       "      <td>416.0</td>\n",
       "      <td>363.0</td>\n",
       "      <td>405.0</td>\n",
       "      <td>347.0</td>\n",
       "      <td>...</td>\n",
       "      <td>370.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>389.0</td>\n",
       "      <td>396.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>332.0</td>\n",
       "      <td>369.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>X</td>\n",
       "      <td>HH2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2021</td>\n",
       "      <td>NI</td>\n",
       "      <td>2164</td>\n",
       "      <td>2092</td>\n",
       "      <td>2167</td>\n",
       "      <td>2165.0</td>\n",
       "      <td>2179.0</td>\n",
       "      <td>2133.0</td>\n",
       "      <td>2061.0</td>\n",
       "      <td>1946.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2049.0</td>\n",
       "      <td>2142.0</td>\n",
       "      <td>2081.0</td>\n",
       "      <td>2163.0</td>\n",
       "      <td>2187.0</td>\n",
       "      <td>2113.0</td>\n",
       "      <td>2055.0</td>\n",
       "      <td>2117.0</td>\n",
       "      <td>X</td>\n",
       "      <td>NI2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2021</td>\n",
       "      <td>HB</td>\n",
       "      <td>181</td>\n",
       "      <td>158</td>\n",
       "      <td>156</td>\n",
       "      <td>148.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>166.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>159.0</td>\n",
       "      <td>...</td>\n",
       "      <td>148.0</td>\n",
       "      <td>185.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>166.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>195.0</td>\n",
       "      <td>X</td>\n",
       "      <td>HB2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2021</td>\n",
       "      <td>NW</td>\n",
       "      <td>4879</td>\n",
       "      <td>5006</td>\n",
       "      <td>4941</td>\n",
       "      <td>4753.0</td>\n",
       "      <td>4551.0</td>\n",
       "      <td>4443.0</td>\n",
       "      <td>4411.0</td>\n",
       "      <td>4192.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4274.0</td>\n",
       "      <td>4526.0</td>\n",
       "      <td>4621.0</td>\n",
       "      <td>5009.0</td>\n",
       "      <td>4958.0</td>\n",
       "      <td>4725.0</td>\n",
       "      <td>4767.0</td>\n",
       "      <td>4616.0</td>\n",
       "      <td>X</td>\n",
       "      <td>NW2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2020</td>\n",
       "      <td>DE</td>\n",
       "      <td>18883</td>\n",
       "      <td>19408</td>\n",
       "      <td>18953</td>\n",
       "      <td>18827.0</td>\n",
       "      <td>19774.0</td>\n",
       "      <td>19038.0</td>\n",
       "      <td>19648.0</td>\n",
       "      <td>18953.0</td>\n",
       "      <td>...</td>\n",
       "      <td>19007.0</td>\n",
       "      <td>19727.0</td>\n",
       "      <td>20182.0</td>\n",
       "      <td>21304.0</td>\n",
       "      <td>22604.0</td>\n",
       "      <td>24003.0</td>\n",
       "      <td>24724.0</td>\n",
       "      <td>25554.0</td>\n",
       "      <td>25497</td>\n",
       "      <td>DE2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2019</td>\n",
       "      <td>DE</td>\n",
       "      <td>18686</td>\n",
       "      <td>19170</td>\n",
       "      <td>19163</td>\n",
       "      <td>19505.0</td>\n",
       "      <td>19812.0</td>\n",
       "      <td>19981.0</td>\n",
       "      <td>20150.0</td>\n",
       "      <td>20349.0</td>\n",
       "      <td>...</td>\n",
       "      <td>17859.0</td>\n",
       "      <td>18242.0</td>\n",
       "      <td>18535.0</td>\n",
       "      <td>18581.0</td>\n",
       "      <td>19143.0</td>\n",
       "      <td>19101.0</td>\n",
       "      <td>19062.0</td>\n",
       "      <td>18204.0</td>\n",
       "      <td>X</td>\n",
       "      <td>DE2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>2018</td>\n",
       "      <td>DE</td>\n",
       "      <td>19342</td>\n",
       "      <td>18770</td>\n",
       "      <td>19187</td>\n",
       "      <td>19171.0</td>\n",
       "      <td>19558.0</td>\n",
       "      <td>20086.0</td>\n",
       "      <td>21254.0</td>\n",
       "      <td>22888.0</td>\n",
       "      <td>...</td>\n",
       "      <td>17604.0</td>\n",
       "      <td>16842.0</td>\n",
       "      <td>17785.0</td>\n",
       "      <td>18091.0</td>\n",
       "      <td>18342.0</td>\n",
       "      <td>17943.0</td>\n",
       "      <td>18990.0</td>\n",
       "      <td>17954.0</td>\n",
       "      <td>X</td>\n",
       "      <td>DE2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>2017</td>\n",
       "      <td>DE</td>\n",
       "      <td>20918</td>\n",
       "      <td>22070</td>\n",
       "      <td>21236</td>\n",
       "      <td>22083.0</td>\n",
       "      <td>23640.0</td>\n",
       "      <td>22744.0</td>\n",
       "      <td>22683.0</td>\n",
       "      <td>22266.0</td>\n",
       "      <td>...</td>\n",
       "      <td>17371.0</td>\n",
       "      <td>17594.0</td>\n",
       "      <td>17676.0</td>\n",
       "      <td>17877.0</td>\n",
       "      <td>18295.0</td>\n",
       "      <td>18504.0</td>\n",
       "      <td>18500.0</td>\n",
       "      <td>18652.0</td>\n",
       "      <td>X</td>\n",
       "      <td>DE2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>2016</td>\n",
       "      <td>DE</td>\n",
       "      <td>18467</td>\n",
       "      <td>18439</td>\n",
       "      <td>18627</td>\n",
       "      <td>18707.0</td>\n",
       "      <td>18493.0</td>\n",
       "      <td>18541.0</td>\n",
       "      <td>18483.0</td>\n",
       "      <td>18475.0</td>\n",
       "      <td>...</td>\n",
       "      <td>17782.0</td>\n",
       "      <td>18591.0</td>\n",
       "      <td>17911.0</td>\n",
       "      <td>18146.0</td>\n",
       "      <td>18793.0</td>\n",
       "      <td>18885.0</td>\n",
       "      <td>19376.0</td>\n",
       "      <td>19744.0</td>\n",
       "      <td>X</td>\n",
       "      <td>DE2016</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>103 rows × 56 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 1 Unnamed: 2      1      2      3        4        5        6  \\\n",
       "0         2021         SH    804    794    850    826.0    778.0    797.0   \n",
       "5         2021         HH    451    437    463    396.0    416.0    363.0   \n",
       "10        2021         NI   2164   2092   2167   2165.0   2179.0   2133.0   \n",
       "15        2021         HB    181    158    156    148.0    183.0    166.0   \n",
       "20        2021         NW   4879   5006   4941   4753.0   4551.0   4443.0   \n",
       "..         ...        ...    ...    ...    ...      ...      ...      ...   \n",
       "32        2020         DE  18883  19408  18953  18827.0  19774.0  19038.0   \n",
       "48        2019         DE  18686  19170  19163  19505.0  19812.0  19981.0   \n",
       "64        2018         DE  19342  18770  19187  19171.0  19558.0  20086.0   \n",
       "80        2017         DE  20918  22070  21236  22083.0  23640.0  22744.0   \n",
       "96        2016         DE  18467  18439  18627  18707.0  18493.0  18541.0   \n",
       "\n",
       "          7        8  ...       45       46       47       48       49  \\\n",
       "0     819.0    677.0  ...    705.0    700.0    732.0    770.0    832.0   \n",
       "5     405.0    347.0  ...    370.0    378.0    389.0    396.0    400.0   \n",
       "10   2061.0   1946.0  ...   2049.0   2142.0   2081.0   2163.0   2187.0   \n",
       "15    165.0    159.0  ...    148.0    185.0    175.0    172.0    173.0   \n",
       "20   4411.0   4192.0  ...   4274.0   4526.0   4621.0   5009.0   4958.0   \n",
       "..      ...      ...  ...      ...      ...      ...      ...      ...   \n",
       "32  19648.0  18953.0  ...  19007.0  19727.0  20182.0  21304.0  22604.0   \n",
       "48  20150.0  20349.0  ...  17859.0  18242.0  18535.0  18581.0  19143.0   \n",
       "64  21254.0  22888.0  ...  17604.0  16842.0  17785.0  18091.0  18342.0   \n",
       "80  22683.0  22266.0  ...  17371.0  17594.0  17676.0  17877.0  18295.0   \n",
       "96  18483.0  18475.0  ...  17782.0  18591.0  17911.0  18146.0  18793.0   \n",
       "\n",
       "         50       51       52     53  weekNr  \n",
       "0     728.0    786.0    782.0     X   SH2021  \n",
       "5     332.0    369.0    400.0     X   HH2021  \n",
       "10   2113.0   2055.0   2117.0     X   NI2021  \n",
       "15    166.0    190.0    195.0     X   HB2021  \n",
       "20   4725.0   4767.0   4616.0     X   NW2021  \n",
       "..      ...      ...      ...    ...     ...  \n",
       "32  24003.0  24724.0  25554.0  25497  DE2020  \n",
       "48  19101.0  19062.0  18204.0     X   DE2019  \n",
       "64  17943.0  18990.0  17954.0     X   DE2018  \n",
       "80  18504.0  18500.0  18652.0     X   DE2017  \n",
       "96  18885.0  19376.0  19744.0     X   DE2016  \n",
       "\n",
       "[103 rows x 56 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sterbefaelleInsg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# transpose output for d3js usage, create useful column names\n",
    "output = sterbefaelleInsg.drop(columns=[\"Unnamed: 2\",\"Unnamed: 1\"]).set_index(\"weekNr\").T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>weekNr</th>\n",
       "      <th>SH2021</th>\n",
       "      <th>HH2021</th>\n",
       "      <th>NI2021</th>\n",
       "      <th>HB2021</th>\n",
       "      <th>NW2021</th>\n",
       "      <th>HE2021</th>\n",
       "      <th>RP2021</th>\n",
       "      <th>BW2021</th>\n",
       "      <th>BY2021</th>\n",
       "      <th>SL2021</th>\n",
       "      <th>...</th>\n",
       "      <th>SN2016</th>\n",
       "      <th>ST2016</th>\n",
       "      <th>TH2016</th>\n",
       "      <th>DE2022</th>\n",
       "      <th>DE2021</th>\n",
       "      <th>DE2020</th>\n",
       "      <th>DE2019</th>\n",
       "      <th>DE2018</th>\n",
       "      <th>DE2017</th>\n",
       "      <th>DE2016</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>804</td>\n",
       "      <td>451</td>\n",
       "      <td>2164</td>\n",
       "      <td>181</td>\n",
       "      <td>4879</td>\n",
       "      <td>1861</td>\n",
       "      <td>1177</td>\n",
       "      <td>2772</td>\n",
       "      <td>3612</td>\n",
       "      <td>355</td>\n",
       "      <td>...</td>\n",
       "      <td>1034</td>\n",
       "      <td>658</td>\n",
       "      <td>568</td>\n",
       "      <td>20430</td>\n",
       "      <td>24844</td>\n",
       "      <td>18883</td>\n",
       "      <td>18686</td>\n",
       "      <td>19342</td>\n",
       "      <td>20918</td>\n",
       "      <td>18467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>794</td>\n",
       "      <td>437</td>\n",
       "      <td>2092</td>\n",
       "      <td>158</td>\n",
       "      <td>5006</td>\n",
       "      <td>1807</td>\n",
       "      <td>1223</td>\n",
       "      <td>2773</td>\n",
       "      <td>3599</td>\n",
       "      <td>298</td>\n",
       "      <td>...</td>\n",
       "      <td>1059</td>\n",
       "      <td>650</td>\n",
       "      <td>551</td>\n",
       "      <td>19532</td>\n",
       "      <td>24501</td>\n",
       "      <td>19408</td>\n",
       "      <td>19170</td>\n",
       "      <td>18770</td>\n",
       "      <td>22070</td>\n",
       "      <td>18439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>850</td>\n",
       "      <td>463</td>\n",
       "      <td>2167</td>\n",
       "      <td>156</td>\n",
       "      <td>4941</td>\n",
       "      <td>1739</td>\n",
       "      <td>1212</td>\n",
       "      <td>2751</td>\n",
       "      <td>3440</td>\n",
       "      <td>333</td>\n",
       "      <td>...</td>\n",
       "      <td>1123</td>\n",
       "      <td>616</td>\n",
       "      <td>593</td>\n",
       "      <td>19537</td>\n",
       "      <td>24077</td>\n",
       "      <td>18953</td>\n",
       "      <td>19163</td>\n",
       "      <td>19187</td>\n",
       "      <td>21236</td>\n",
       "      <td>18627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>826</td>\n",
       "      <td>396</td>\n",
       "      <td>2165</td>\n",
       "      <td>148</td>\n",
       "      <td>4753</td>\n",
       "      <td>1679</td>\n",
       "      <td>1120</td>\n",
       "      <td>2533</td>\n",
       "      <td>3195</td>\n",
       "      <td>274</td>\n",
       "      <td>...</td>\n",
       "      <td>1166</td>\n",
       "      <td>601</td>\n",
       "      <td>624</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22645</td>\n",
       "      <td>18827</td>\n",
       "      <td>19505</td>\n",
       "      <td>19171</td>\n",
       "      <td>22083</td>\n",
       "      <td>18707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>778</td>\n",
       "      <td>416</td>\n",
       "      <td>2179</td>\n",
       "      <td>183</td>\n",
       "      <td>4551</td>\n",
       "      <td>1539</td>\n",
       "      <td>1024</td>\n",
       "      <td>2381</td>\n",
       "      <td>3061</td>\n",
       "      <td>318</td>\n",
       "      <td>...</td>\n",
       "      <td>1114</td>\n",
       "      <td>635</td>\n",
       "      <td>617</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21736</td>\n",
       "      <td>19774</td>\n",
       "      <td>19812</td>\n",
       "      <td>19558</td>\n",
       "      <td>23640</td>\n",
       "      <td>18493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>797</td>\n",
       "      <td>363</td>\n",
       "      <td>2133</td>\n",
       "      <td>166</td>\n",
       "      <td>4443</td>\n",
       "      <td>1505</td>\n",
       "      <td>995</td>\n",
       "      <td>2290</td>\n",
       "      <td>2903</td>\n",
       "      <td>301</td>\n",
       "      <td>...</td>\n",
       "      <td>1097</td>\n",
       "      <td>601</td>\n",
       "      <td>546</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20932</td>\n",
       "      <td>19038</td>\n",
       "      <td>19981</td>\n",
       "      <td>20086</td>\n",
       "      <td>22744</td>\n",
       "      <td>18541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>819</td>\n",
       "      <td>405</td>\n",
       "      <td>2061</td>\n",
       "      <td>165</td>\n",
       "      <td>4411</td>\n",
       "      <td>1499</td>\n",
       "      <td>966</td>\n",
       "      <td>2241</td>\n",
       "      <td>2917</td>\n",
       "      <td>322</td>\n",
       "      <td>...</td>\n",
       "      <td>1053</td>\n",
       "      <td>627</td>\n",
       "      <td>629</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20469</td>\n",
       "      <td>19648</td>\n",
       "      <td>20150</td>\n",
       "      <td>21254</td>\n",
       "      <td>22683</td>\n",
       "      <td>18483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>677</td>\n",
       "      <td>347</td>\n",
       "      <td>1946</td>\n",
       "      <td>159</td>\n",
       "      <td>4192</td>\n",
       "      <td>1366</td>\n",
       "      <td>889</td>\n",
       "      <td>2124</td>\n",
       "      <td>2586</td>\n",
       "      <td>298</td>\n",
       "      <td>...</td>\n",
       "      <td>1104</td>\n",
       "      <td>700</td>\n",
       "      <td>611</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18950</td>\n",
       "      <td>18953</td>\n",
       "      <td>20349</td>\n",
       "      <td>22888</td>\n",
       "      <td>22266</td>\n",
       "      <td>18475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>675</td>\n",
       "      <td>353</td>\n",
       "      <td>1827</td>\n",
       "      <td>155</td>\n",
       "      <td>4080</td>\n",
       "      <td>1303</td>\n",
       "      <td>863</td>\n",
       "      <td>2087</td>\n",
       "      <td>2558</td>\n",
       "      <td>251</td>\n",
       "      <td>...</td>\n",
       "      <td>1087</td>\n",
       "      <td>672</td>\n",
       "      <td>563</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18437</td>\n",
       "      <td>19505</td>\n",
       "      <td>20790</td>\n",
       "      <td>25535</td>\n",
       "      <td>20930</td>\n",
       "      <td>18926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>714</td>\n",
       "      <td>362</td>\n",
       "      <td>1884</td>\n",
       "      <td>145</td>\n",
       "      <td>4034</td>\n",
       "      <td>1324</td>\n",
       "      <td>878</td>\n",
       "      <td>2057</td>\n",
       "      <td>2694</td>\n",
       "      <td>245</td>\n",
       "      <td>...</td>\n",
       "      <td>1098</td>\n",
       "      <td>653</td>\n",
       "      <td>629</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18607</td>\n",
       "      <td>19667</td>\n",
       "      <td>20453</td>\n",
       "      <td>26777</td>\n",
       "      <td>19102</td>\n",
       "      <td>18888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>735</td>\n",
       "      <td>326</td>\n",
       "      <td>1907</td>\n",
       "      <td>155</td>\n",
       "      <td>3855</td>\n",
       "      <td>1292</td>\n",
       "      <td>939</td>\n",
       "      <td>2033</td>\n",
       "      <td>2669</td>\n",
       "      <td>247</td>\n",
       "      <td>...</td>\n",
       "      <td>1084</td>\n",
       "      <td>676</td>\n",
       "      <td>604</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18335</td>\n",
       "      <td>19849</td>\n",
       "      <td>19795</td>\n",
       "      <td>24385</td>\n",
       "      <td>18665</td>\n",
       "      <td>18971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>653</td>\n",
       "      <td>333</td>\n",
       "      <td>1779</td>\n",
       "      <td>169</td>\n",
       "      <td>4066</td>\n",
       "      <td>1316</td>\n",
       "      <td>858</td>\n",
       "      <td>2129</td>\n",
       "      <td>2635</td>\n",
       "      <td>243</td>\n",
       "      <td>...</td>\n",
       "      <td>1082</td>\n",
       "      <td>703</td>\n",
       "      <td>550</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18391</td>\n",
       "      <td>19722</td>\n",
       "      <td>19016</td>\n",
       "      <td>22777</td>\n",
       "      <td>17640</td>\n",
       "      <td>18826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>670</td>\n",
       "      <td>338</td>\n",
       "      <td>1797</td>\n",
       "      <td>136</td>\n",
       "      <td>3996</td>\n",
       "      <td>1313</td>\n",
       "      <td>905</td>\n",
       "      <td>2067</td>\n",
       "      <td>2730</td>\n",
       "      <td>267</td>\n",
       "      <td>...</td>\n",
       "      <td>1079</td>\n",
       "      <td>655</td>\n",
       "      <td>549</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18493</td>\n",
       "      <td>19678</td>\n",
       "      <td>18562</td>\n",
       "      <td>20906</td>\n",
       "      <td>17731</td>\n",
       "      <td>18617</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>677</td>\n",
       "      <td>310</td>\n",
       "      <td>1846</td>\n",
       "      <td>167</td>\n",
       "      <td>4071</td>\n",
       "      <td>1326</td>\n",
       "      <td>917</td>\n",
       "      <td>2237</td>\n",
       "      <td>2595</td>\n",
       "      <td>231</td>\n",
       "      <td>...</td>\n",
       "      <td>1067</td>\n",
       "      <td>627</td>\n",
       "      <td>575</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18820</td>\n",
       "      <td>20662</td>\n",
       "      <td>18671</td>\n",
       "      <td>20038</td>\n",
       "      <td>17028</td>\n",
       "      <td>18244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>706</td>\n",
       "      <td>346</td>\n",
       "      <td>1818</td>\n",
       "      <td>167</td>\n",
       "      <td>4150</td>\n",
       "      <td>1390</td>\n",
       "      <td>937</td>\n",
       "      <td>2189</td>\n",
       "      <td>2662</td>\n",
       "      <td>268</td>\n",
       "      <td>...</td>\n",
       "      <td>1045</td>\n",
       "      <td>599</td>\n",
       "      <td>536</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19062</td>\n",
       "      <td>20502</td>\n",
       "      <td>17852</td>\n",
       "      <td>19165</td>\n",
       "      <td>16901</td>\n",
       "      <td>17712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>696</td>\n",
       "      <td>357</td>\n",
       "      <td>1872</td>\n",
       "      <td>155</td>\n",
       "      <td>4201</td>\n",
       "      <td>1338</td>\n",
       "      <td>938</td>\n",
       "      <td>2187</td>\n",
       "      <td>2774</td>\n",
       "      <td>238</td>\n",
       "      <td>...</td>\n",
       "      <td>991</td>\n",
       "      <td>584</td>\n",
       "      <td>503</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19241</td>\n",
       "      <td>19261</td>\n",
       "      <td>18089</td>\n",
       "      <td>17992</td>\n",
       "      <td>16637</td>\n",
       "      <td>16775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>674</td>\n",
       "      <td>341</td>\n",
       "      <td>1883</td>\n",
       "      <td>172</td>\n",
       "      <td>4197</td>\n",
       "      <td>1418</td>\n",
       "      <td>961</td>\n",
       "      <td>2336</td>\n",
       "      <td>2778</td>\n",
       "      <td>247</td>\n",
       "      <td>...</td>\n",
       "      <td>985</td>\n",
       "      <td>627</td>\n",
       "      <td>518</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19507</td>\n",
       "      <td>18557</td>\n",
       "      <td>17894</td>\n",
       "      <td>17093</td>\n",
       "      <td>17634</td>\n",
       "      <td>17053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>710</td>\n",
       "      <td>353</td>\n",
       "      <td>1896</td>\n",
       "      <td>150</td>\n",
       "      <td>4322</td>\n",
       "      <td>1374</td>\n",
       "      <td>975</td>\n",
       "      <td>2209</td>\n",
       "      <td>2732</td>\n",
       "      <td>265</td>\n",
       "      <td>...</td>\n",
       "      <td>1005</td>\n",
       "      <td>604</td>\n",
       "      <td>549</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19308</td>\n",
       "      <td>17920</td>\n",
       "      <td>17090</td>\n",
       "      <td>16789</td>\n",
       "      <td>17129</td>\n",
       "      <td>16901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>641</td>\n",
       "      <td>334</td>\n",
       "      <td>1790</td>\n",
       "      <td>135</td>\n",
       "      <td>4127</td>\n",
       "      <td>1311</td>\n",
       "      <td>891</td>\n",
       "      <td>2180</td>\n",
       "      <td>2643</td>\n",
       "      <td>250</td>\n",
       "      <td>...</td>\n",
       "      <td>1014</td>\n",
       "      <td>659</td>\n",
       "      <td>503</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18589</td>\n",
       "      <td>17651</td>\n",
       "      <td>17118</td>\n",
       "      <td>17226</td>\n",
       "      <td>17343</td>\n",
       "      <td>17629</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>665</td>\n",
       "      <td>316</td>\n",
       "      <td>1766</td>\n",
       "      <td>145</td>\n",
       "      <td>3884</td>\n",
       "      <td>1250</td>\n",
       "      <td>884</td>\n",
       "      <td>2109</td>\n",
       "      <td>2515</td>\n",
       "      <td>250</td>\n",
       "      <td>...</td>\n",
       "      <td>970</td>\n",
       "      <td>565</td>\n",
       "      <td>522</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17787</td>\n",
       "      <td>17001</td>\n",
       "      <td>17315</td>\n",
       "      <td>16488</td>\n",
       "      <td>17079</td>\n",
       "      <td>16601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>687</td>\n",
       "      <td>321</td>\n",
       "      <td>1721</td>\n",
       "      <td>128</td>\n",
       "      <td>3760</td>\n",
       "      <td>1202</td>\n",
       "      <td>875</td>\n",
       "      <td>2017</td>\n",
       "      <td>2435</td>\n",
       "      <td>217</td>\n",
       "      <td>...</td>\n",
       "      <td>963</td>\n",
       "      <td>598</td>\n",
       "      <td>507</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17158</td>\n",
       "      <td>17163</td>\n",
       "      <td>17080</td>\n",
       "      <td>16513</td>\n",
       "      <td>16451</td>\n",
       "      <td>16286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>664</td>\n",
       "      <td>361</td>\n",
       "      <td>1934</td>\n",
       "      <td>154</td>\n",
       "      <td>3906</td>\n",
       "      <td>1289</td>\n",
       "      <td>910</td>\n",
       "      <td>2157</td>\n",
       "      <td>2491</td>\n",
       "      <td>266</td>\n",
       "      <td>...</td>\n",
       "      <td>905</td>\n",
       "      <td>572</td>\n",
       "      <td>555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18162</td>\n",
       "      <td>16776</td>\n",
       "      <td>16921</td>\n",
       "      <td>17039</td>\n",
       "      <td>16902</td>\n",
       "      <td>16346</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>641</td>\n",
       "      <td>362</td>\n",
       "      <td>1744</td>\n",
       "      <td>151</td>\n",
       "      <td>3840</td>\n",
       "      <td>1241</td>\n",
       "      <td>797</td>\n",
       "      <td>2071</td>\n",
       "      <td>2372</td>\n",
       "      <td>272</td>\n",
       "      <td>...</td>\n",
       "      <td>890</td>\n",
       "      <td>509</td>\n",
       "      <td>482</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17408</td>\n",
       "      <td>17262</td>\n",
       "      <td>17491</td>\n",
       "      <td>16714</td>\n",
       "      <td>15846</td>\n",
       "      <td>15799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>738</td>\n",
       "      <td>384</td>\n",
       "      <td>1967</td>\n",
       "      <td>134</td>\n",
       "      <td>4233</td>\n",
       "      <td>1369</td>\n",
       "      <td>1007</td>\n",
       "      <td>2232</td>\n",
       "      <td>2577</td>\n",
       "      <td>289</td>\n",
       "      <td>...</td>\n",
       "      <td>898</td>\n",
       "      <td>520</td>\n",
       "      <td>483</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19043</td>\n",
       "      <td>16601</td>\n",
       "      <td>16484</td>\n",
       "      <td>15582</td>\n",
       "      <td>16087</td>\n",
       "      <td>15717</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>606</td>\n",
       "      <td>318</td>\n",
       "      <td>1685</td>\n",
       "      <td>148</td>\n",
       "      <td>3796</td>\n",
       "      <td>1197</td>\n",
       "      <td>828</td>\n",
       "      <td>2017</td>\n",
       "      <td>2504</td>\n",
       "      <td>217</td>\n",
       "      <td>...</td>\n",
       "      <td>989</td>\n",
       "      <td>640</td>\n",
       "      <td>533</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17179</td>\n",
       "      <td>16401</td>\n",
       "      <td>16639</td>\n",
       "      <td>15843</td>\n",
       "      <td>16819</td>\n",
       "      <td>16910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>649</td>\n",
       "      <td>361</td>\n",
       "      <td>1708</td>\n",
       "      <td>153</td>\n",
       "      <td>3773</td>\n",
       "      <td>1218</td>\n",
       "      <td>851</td>\n",
       "      <td>1935</td>\n",
       "      <td>2365</td>\n",
       "      <td>227</td>\n",
       "      <td>...</td>\n",
       "      <td>944</td>\n",
       "      <td>542</td>\n",
       "      <td>495</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16983</td>\n",
       "      <td>17293</td>\n",
       "      <td>17918</td>\n",
       "      <td>16569</td>\n",
       "      <td>16076</td>\n",
       "      <td>15699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>641</td>\n",
       "      <td>292</td>\n",
       "      <td>1758</td>\n",
       "      <td>164</td>\n",
       "      <td>3728</td>\n",
       "      <td>1152</td>\n",
       "      <td>851</td>\n",
       "      <td>1977</td>\n",
       "      <td>2456</td>\n",
       "      <td>239</td>\n",
       "      <td>...</td>\n",
       "      <td>948</td>\n",
       "      <td>566</td>\n",
       "      <td>477</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16949</td>\n",
       "      <td>16457</td>\n",
       "      <td>16552</td>\n",
       "      <td>16622</td>\n",
       "      <td>16424</td>\n",
       "      <td>16229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>664</td>\n",
       "      <td>343</td>\n",
       "      <td>1783</td>\n",
       "      <td>140</td>\n",
       "      <td>3866</td>\n",
       "      <td>1283</td>\n",
       "      <td>1029</td>\n",
       "      <td>1991</td>\n",
       "      <td>2381</td>\n",
       "      <td>232</td>\n",
       "      <td>...</td>\n",
       "      <td>947</td>\n",
       "      <td>578</td>\n",
       "      <td>502</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17616</td>\n",
       "      <td>16142</td>\n",
       "      <td>16319</td>\n",
       "      <td>16070</td>\n",
       "      <td>15603</td>\n",
       "      <td>16172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>603</td>\n",
       "      <td>336</td>\n",
       "      <td>1755</td>\n",
       "      <td>138</td>\n",
       "      <td>3826</td>\n",
       "      <td>1321</td>\n",
       "      <td>936</td>\n",
       "      <td>2140</td>\n",
       "      <td>2516</td>\n",
       "      <td>256</td>\n",
       "      <td>...</td>\n",
       "      <td>971</td>\n",
       "      <td>603</td>\n",
       "      <td>470</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17571</td>\n",
       "      <td>16537</td>\n",
       "      <td>16856</td>\n",
       "      <td>16702</td>\n",
       "      <td>16589</td>\n",
       "      <td>16985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>654</td>\n",
       "      <td>352</td>\n",
       "      <td>1756</td>\n",
       "      <td>130</td>\n",
       "      <td>3758</td>\n",
       "      <td>1216</td>\n",
       "      <td>867</td>\n",
       "      <td>1994</td>\n",
       "      <td>2475</td>\n",
       "      <td>234</td>\n",
       "      <td>...</td>\n",
       "      <td>1040</td>\n",
       "      <td>599</td>\n",
       "      <td>503</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17199</td>\n",
       "      <td>16887</td>\n",
       "      <td>19630</td>\n",
       "      <td>18340</td>\n",
       "      <td>16058</td>\n",
       "      <td>16157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>658</td>\n",
       "      <td>336</td>\n",
       "      <td>1709</td>\n",
       "      <td>131</td>\n",
       "      <td>3769</td>\n",
       "      <td>1171</td>\n",
       "      <td>866</td>\n",
       "      <td>1942</td>\n",
       "      <td>2412</td>\n",
       "      <td>235</td>\n",
       "      <td>...</td>\n",
       "      <td>886</td>\n",
       "      <td>554</td>\n",
       "      <td>449</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16987</td>\n",
       "      <td>17433</td>\n",
       "      <td>17034</td>\n",
       "      <td>20371</td>\n",
       "      <td>16494</td>\n",
       "      <td>15439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>660</td>\n",
       "      <td>341</td>\n",
       "      <td>1795</td>\n",
       "      <td>172</td>\n",
       "      <td>3827</td>\n",
       "      <td>1196</td>\n",
       "      <td>986</td>\n",
       "      <td>2025</td>\n",
       "      <td>2543</td>\n",
       "      <td>250</td>\n",
       "      <td>...</td>\n",
       "      <td>918</td>\n",
       "      <td>498</td>\n",
       "      <td>462</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17527</td>\n",
       "      <td>17470</td>\n",
       "      <td>16540</td>\n",
       "      <td>18478</td>\n",
       "      <td>15784</td>\n",
       "      <td>15487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>647</td>\n",
       "      <td>333</td>\n",
       "      <td>1738</td>\n",
       "      <td>146</td>\n",
       "      <td>3862</td>\n",
       "      <td>1225</td>\n",
       "      <td>880</td>\n",
       "      <td>2049</td>\n",
       "      <td>2482</td>\n",
       "      <td>264</td>\n",
       "      <td>...</td>\n",
       "      <td>899</td>\n",
       "      <td>524</td>\n",
       "      <td>501</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17436</td>\n",
       "      <td>19720</td>\n",
       "      <td>15934</td>\n",
       "      <td>16890</td>\n",
       "      <td>16148</td>\n",
       "      <td>16258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>653</td>\n",
       "      <td>350</td>\n",
       "      <td>1775</td>\n",
       "      <td>148</td>\n",
       "      <td>3820</td>\n",
       "      <td>1197</td>\n",
       "      <td>831</td>\n",
       "      <td>2024</td>\n",
       "      <td>2369</td>\n",
       "      <td>256</td>\n",
       "      <td>...</td>\n",
       "      <td>978</td>\n",
       "      <td>598</td>\n",
       "      <td>533</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17150</td>\n",
       "      <td>17559</td>\n",
       "      <td>16263</td>\n",
       "      <td>16612</td>\n",
       "      <td>15880</td>\n",
       "      <td>17147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>613</td>\n",
       "      <td>358</td>\n",
       "      <td>1764</td>\n",
       "      <td>129</td>\n",
       "      <td>3839</td>\n",
       "      <td>1258</td>\n",
       "      <td>888</td>\n",
       "      <td>2007</td>\n",
       "      <td>2480</td>\n",
       "      <td>251</td>\n",
       "      <td>...</td>\n",
       "      <td>978</td>\n",
       "      <td>580</td>\n",
       "      <td>450</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17324</td>\n",
       "      <td>16656</td>\n",
       "      <td>17637</td>\n",
       "      <td>16000</td>\n",
       "      <td>16064</td>\n",
       "      <td>16101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>682</td>\n",
       "      <td>378</td>\n",
       "      <td>1945</td>\n",
       "      <td>162</td>\n",
       "      <td>4241</td>\n",
       "      <td>1297</td>\n",
       "      <td>958</td>\n",
       "      <td>2162</td>\n",
       "      <td>2717</td>\n",
       "      <td>283</td>\n",
       "      <td>...</td>\n",
       "      <td>954</td>\n",
       "      <td>563</td>\n",
       "      <td>526</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18811</td>\n",
       "      <td>16789</td>\n",
       "      <td>15988</td>\n",
       "      <td>16390</td>\n",
       "      <td>15706</td>\n",
       "      <td>16116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>639</td>\n",
       "      <td>369</td>\n",
       "      <td>1842</td>\n",
       "      <td>156</td>\n",
       "      <td>3973</td>\n",
       "      <td>1282</td>\n",
       "      <td>913</td>\n",
       "      <td>2128</td>\n",
       "      <td>2545</td>\n",
       "      <td>252</td>\n",
       "      <td>...</td>\n",
       "      <td>975</td>\n",
       "      <td>551</td>\n",
       "      <td>516</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17999</td>\n",
       "      <td>17155</td>\n",
       "      <td>16303</td>\n",
       "      <td>16292</td>\n",
       "      <td>16146</td>\n",
       "      <td>16372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>663</td>\n",
       "      <td>317</td>\n",
       "      <td>1855</td>\n",
       "      <td>127</td>\n",
       "      <td>4017</td>\n",
       "      <td>1251</td>\n",
       "      <td>922</td>\n",
       "      <td>2160</td>\n",
       "      <td>2584</td>\n",
       "      <td>256</td>\n",
       "      <td>...</td>\n",
       "      <td>895</td>\n",
       "      <td>512</td>\n",
       "      <td>509</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18087</td>\n",
       "      <td>17555</td>\n",
       "      <td>16500</td>\n",
       "      <td>16651</td>\n",
       "      <td>16505</td>\n",
       "      <td>15606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>679</td>\n",
       "      <td>359</td>\n",
       "      <td>1807</td>\n",
       "      <td>168</td>\n",
       "      <td>3959</td>\n",
       "      <td>1268</td>\n",
       "      <td>931</td>\n",
       "      <td>2085</td>\n",
       "      <td>2623</td>\n",
       "      <td>233</td>\n",
       "      <td>...</td>\n",
       "      <td>970</td>\n",
       "      <td>574</td>\n",
       "      <td>504</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18059</td>\n",
       "      <td>17446</td>\n",
       "      <td>17402</td>\n",
       "      <td>15969</td>\n",
       "      <td>16747</td>\n",
       "      <td>16336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>688</td>\n",
       "      <td>336</td>\n",
       "      <td>1808</td>\n",
       "      <td>152</td>\n",
       "      <td>3990</td>\n",
       "      <td>1285</td>\n",
       "      <td>976</td>\n",
       "      <td>2132</td>\n",
       "      <td>2654</td>\n",
       "      <td>272</td>\n",
       "      <td>...</td>\n",
       "      <td>989</td>\n",
       "      <td>548</td>\n",
       "      <td>510</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18137</td>\n",
       "      <td>17614</td>\n",
       "      <td>16899</td>\n",
       "      <td>16622</td>\n",
       "      <td>16664</td>\n",
       "      <td>16352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>698</td>\n",
       "      <td>319</td>\n",
       "      <td>1832</td>\n",
       "      <td>141</td>\n",
       "      <td>4059</td>\n",
       "      <td>1263</td>\n",
       "      <td>964</td>\n",
       "      <td>2323</td>\n",
       "      <td>2790</td>\n",
       "      <td>279</td>\n",
       "      <td>...</td>\n",
       "      <td>981</td>\n",
       "      <td>578</td>\n",
       "      <td>511</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18861</td>\n",
       "      <td>17501</td>\n",
       "      <td>17666</td>\n",
       "      <td>16993</td>\n",
       "      <td>17470</td>\n",
       "      <td>17427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>709</td>\n",
       "      <td>350</td>\n",
       "      <td>1926</td>\n",
       "      <td>153</td>\n",
       "      <td>4195</td>\n",
       "      <td>1386</td>\n",
       "      <td>946</td>\n",
       "      <td>2410</td>\n",
       "      <td>2914</td>\n",
       "      <td>277</td>\n",
       "      <td>...</td>\n",
       "      <td>961</td>\n",
       "      <td>603</td>\n",
       "      <td>589</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19704</td>\n",
       "      <td>17754</td>\n",
       "      <td>17713</td>\n",
       "      <td>16552</td>\n",
       "      <td>17139</td>\n",
       "      <td>17599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>768</td>\n",
       "      <td>376</td>\n",
       "      <td>1983</td>\n",
       "      <td>144</td>\n",
       "      <td>4325</td>\n",
       "      <td>1349</td>\n",
       "      <td>991</td>\n",
       "      <td>2468</td>\n",
       "      <td>2981</td>\n",
       "      <td>295</td>\n",
       "      <td>...</td>\n",
       "      <td>1065</td>\n",
       "      <td>564</td>\n",
       "      <td>521</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20183</td>\n",
       "      <td>18588</td>\n",
       "      <td>17327</td>\n",
       "      <td>16608</td>\n",
       "      <td>17059</td>\n",
       "      <td>17586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>711</td>\n",
       "      <td>371</td>\n",
       "      <td>1931</td>\n",
       "      <td>150</td>\n",
       "      <td>4294</td>\n",
       "      <td>1456</td>\n",
       "      <td>985</td>\n",
       "      <td>2408</td>\n",
       "      <td>3079</td>\n",
       "      <td>266</td>\n",
       "      <td>...</td>\n",
       "      <td>993</td>\n",
       "      <td>552</td>\n",
       "      <td>571</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20226</td>\n",
       "      <td>18584</td>\n",
       "      <td>17488</td>\n",
       "      <td>16895</td>\n",
       "      <td>16762</td>\n",
       "      <td>17580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>705</td>\n",
       "      <td>370</td>\n",
       "      <td>2049</td>\n",
       "      <td>148</td>\n",
       "      <td>4274</td>\n",
       "      <td>1468</td>\n",
       "      <td>1069</td>\n",
       "      <td>2464</td>\n",
       "      <td>3322</td>\n",
       "      <td>306</td>\n",
       "      <td>...</td>\n",
       "      <td>1079</td>\n",
       "      <td>607</td>\n",
       "      <td>550</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20930</td>\n",
       "      <td>19007</td>\n",
       "      <td>17859</td>\n",
       "      <td>17604</td>\n",
       "      <td>17371</td>\n",
       "      <td>17782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>700</td>\n",
       "      <td>378</td>\n",
       "      <td>2142</td>\n",
       "      <td>185</td>\n",
       "      <td>4526</td>\n",
       "      <td>1590</td>\n",
       "      <td>1019</td>\n",
       "      <td>2616</td>\n",
       "      <td>3443</td>\n",
       "      <td>326</td>\n",
       "      <td>...</td>\n",
       "      <td>1084</td>\n",
       "      <td>628</td>\n",
       "      <td>541</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22144</td>\n",
       "      <td>19727</td>\n",
       "      <td>18242</td>\n",
       "      <td>16842</td>\n",
       "      <td>17594</td>\n",
       "      <td>18591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>732</td>\n",
       "      <td>389</td>\n",
       "      <td>2081</td>\n",
       "      <td>175</td>\n",
       "      <td>4621</td>\n",
       "      <td>1576</td>\n",
       "      <td>1073</td>\n",
       "      <td>2749</td>\n",
       "      <td>3688</td>\n",
       "      <td>328</td>\n",
       "      <td>...</td>\n",
       "      <td>1037</td>\n",
       "      <td>598</td>\n",
       "      <td>579</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23042</td>\n",
       "      <td>20182</td>\n",
       "      <td>18535</td>\n",
       "      <td>17785</td>\n",
       "      <td>17676</td>\n",
       "      <td>17911</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>770</td>\n",
       "      <td>396</td>\n",
       "      <td>2163</td>\n",
       "      <td>172</td>\n",
       "      <td>5009</td>\n",
       "      <td>1628</td>\n",
       "      <td>1129</td>\n",
       "      <td>2808</td>\n",
       "      <td>3713</td>\n",
       "      <td>307</td>\n",
       "      <td>...</td>\n",
       "      <td>1030</td>\n",
       "      <td>651</td>\n",
       "      <td>614</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23968</td>\n",
       "      <td>21304</td>\n",
       "      <td>18581</td>\n",
       "      <td>18091</td>\n",
       "      <td>17877</td>\n",
       "      <td>18146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>832</td>\n",
       "      <td>400</td>\n",
       "      <td>2187</td>\n",
       "      <td>173</td>\n",
       "      <td>4958</td>\n",
       "      <td>1552</td>\n",
       "      <td>1064</td>\n",
       "      <td>2790</td>\n",
       "      <td>3560</td>\n",
       "      <td>343</td>\n",
       "      <td>...</td>\n",
       "      <td>1118</td>\n",
       "      <td>603</td>\n",
       "      <td>588</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23755</td>\n",
       "      <td>22604</td>\n",
       "      <td>19143</td>\n",
       "      <td>18342</td>\n",
       "      <td>18295</td>\n",
       "      <td>18793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>728</td>\n",
       "      <td>332</td>\n",
       "      <td>2113</td>\n",
       "      <td>166</td>\n",
       "      <td>4725</td>\n",
       "      <td>1531</td>\n",
       "      <td>1118</td>\n",
       "      <td>2717</td>\n",
       "      <td>3306</td>\n",
       "      <td>310</td>\n",
       "      <td>...</td>\n",
       "      <td>1158</td>\n",
       "      <td>629</td>\n",
       "      <td>599</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22685</td>\n",
       "      <td>24003</td>\n",
       "      <td>19101</td>\n",
       "      <td>17943</td>\n",
       "      <td>18504</td>\n",
       "      <td>18885</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>786</td>\n",
       "      <td>369</td>\n",
       "      <td>2055</td>\n",
       "      <td>190</td>\n",
       "      <td>4767</td>\n",
       "      <td>1491</td>\n",
       "      <td>1098</td>\n",
       "      <td>2651</td>\n",
       "      <td>3242</td>\n",
       "      <td>325</td>\n",
       "      <td>...</td>\n",
       "      <td>1137</td>\n",
       "      <td>680</td>\n",
       "      <td>618</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22272</td>\n",
       "      <td>24724</td>\n",
       "      <td>19062</td>\n",
       "      <td>18990</td>\n",
       "      <td>18500</td>\n",
       "      <td>19376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>782</td>\n",
       "      <td>400</td>\n",
       "      <td>2117</td>\n",
       "      <td>195</td>\n",
       "      <td>4616</td>\n",
       "      <td>1457</td>\n",
       "      <td>1082</td>\n",
       "      <td>2556</td>\n",
       "      <td>3041</td>\n",
       "      <td>324</td>\n",
       "      <td>...</td>\n",
       "      <td>1219</td>\n",
       "      <td>661</td>\n",
       "      <td>603</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21856</td>\n",
       "      <td>25554</td>\n",
       "      <td>18204</td>\n",
       "      <td>17954</td>\n",
       "      <td>18652</td>\n",
       "      <td>19744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "      <td>...</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "      <td>NaN</td>\n",
       "      <td>X</td>\n",
       "      <td>25497</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>53 rows × 103 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "weekNr SH2021 HH2021 NI2021 HB2021 NW2021 HE2021 RP2021 BW2021 BY2021 SL2021  \\\n",
       "1         804    451   2164    181   4879   1861   1177   2772   3612    355   \n",
       "2         794    437   2092    158   5006   1807   1223   2773   3599    298   \n",
       "3         850    463   2167    156   4941   1739   1212   2751   3440    333   \n",
       "4         826    396   2165    148   4753   1679   1120   2533   3195    274   \n",
       "5         778    416   2179    183   4551   1539   1024   2381   3061    318   \n",
       "6         797    363   2133    166   4443   1505    995   2290   2903    301   \n",
       "7         819    405   2061    165   4411   1499    966   2241   2917    322   \n",
       "8         677    347   1946    159   4192   1366    889   2124   2586    298   \n",
       "9         675    353   1827    155   4080   1303    863   2087   2558    251   \n",
       "10        714    362   1884    145   4034   1324    878   2057   2694    245   \n",
       "11        735    326   1907    155   3855   1292    939   2033   2669    247   \n",
       "12        653    333   1779    169   4066   1316    858   2129   2635    243   \n",
       "13        670    338   1797    136   3996   1313    905   2067   2730    267   \n",
       "14        677    310   1846    167   4071   1326    917   2237   2595    231   \n",
       "15        706    346   1818    167   4150   1390    937   2189   2662    268   \n",
       "16        696    357   1872    155   4201   1338    938   2187   2774    238   \n",
       "17        674    341   1883    172   4197   1418    961   2336   2778    247   \n",
       "18        710    353   1896    150   4322   1374    975   2209   2732    265   \n",
       "19        641    334   1790    135   4127   1311    891   2180   2643    250   \n",
       "20        665    316   1766    145   3884   1250    884   2109   2515    250   \n",
       "21        687    321   1721    128   3760   1202    875   2017   2435    217   \n",
       "22        664    361   1934    154   3906   1289    910   2157   2491    266   \n",
       "23        641    362   1744    151   3840   1241    797   2071   2372    272   \n",
       "24        738    384   1967    134   4233   1369   1007   2232   2577    289   \n",
       "25        606    318   1685    148   3796   1197    828   2017   2504    217   \n",
       "26        649    361   1708    153   3773   1218    851   1935   2365    227   \n",
       "27        641    292   1758    164   3728   1152    851   1977   2456    239   \n",
       "28        664    343   1783    140   3866   1283   1029   1991   2381    232   \n",
       "29        603    336   1755    138   3826   1321    936   2140   2516    256   \n",
       "30        654    352   1756    130   3758   1216    867   1994   2475    234   \n",
       "31        658    336   1709    131   3769   1171    866   1942   2412    235   \n",
       "32        660    341   1795    172   3827   1196    986   2025   2543    250   \n",
       "33        647    333   1738    146   3862   1225    880   2049   2482    264   \n",
       "34        653    350   1775    148   3820   1197    831   2024   2369    256   \n",
       "35        613    358   1764    129   3839   1258    888   2007   2480    251   \n",
       "36        682    378   1945    162   4241   1297    958   2162   2717    283   \n",
       "37        639    369   1842    156   3973   1282    913   2128   2545    252   \n",
       "38        663    317   1855    127   4017   1251    922   2160   2584    256   \n",
       "39        679    359   1807    168   3959   1268    931   2085   2623    233   \n",
       "40        688    336   1808    152   3990   1285    976   2132   2654    272   \n",
       "41        698    319   1832    141   4059   1263    964   2323   2790    279   \n",
       "42        709    350   1926    153   4195   1386    946   2410   2914    277   \n",
       "43        768    376   1983    144   4325   1349    991   2468   2981    295   \n",
       "44        711    371   1931    150   4294   1456    985   2408   3079    266   \n",
       "45        705    370   2049    148   4274   1468   1069   2464   3322    306   \n",
       "46        700    378   2142    185   4526   1590   1019   2616   3443    326   \n",
       "47        732    389   2081    175   4621   1576   1073   2749   3688    328   \n",
       "48        770    396   2163    172   5009   1628   1129   2808   3713    307   \n",
       "49        832    400   2187    173   4958   1552   1064   2790   3560    343   \n",
       "50        728    332   2113    166   4725   1531   1118   2717   3306    310   \n",
       "51        786    369   2055    190   4767   1491   1098   2651   3242    325   \n",
       "52        782    400   2117    195   4616   1457   1082   2556   3041    324   \n",
       "53         X      X      X      X      X      X      X      X      X      X    \n",
       "\n",
       "weekNr  ... SN2016 ST2016 TH2016 DE2022 DE2021 DE2020 DE2019 DE2018 DE2017  \\\n",
       "1       ...   1034    658    568  20430  24844  18883  18686  19342  20918   \n",
       "2       ...   1059    650    551  19532  24501  19408  19170  18770  22070   \n",
       "3       ...   1123    616    593  19537  24077  18953  19163  19187  21236   \n",
       "4       ...   1166    601    624    NaN  22645  18827  19505  19171  22083   \n",
       "5       ...   1114    635    617    NaN  21736  19774  19812  19558  23640   \n",
       "6       ...   1097    601    546    NaN  20932  19038  19981  20086  22744   \n",
       "7       ...   1053    627    629    NaN  20469  19648  20150  21254  22683   \n",
       "8       ...   1104    700    611    NaN  18950  18953  20349  22888  22266   \n",
       "9       ...   1087    672    563    NaN  18437  19505  20790  25535  20930   \n",
       "10      ...   1098    653    629    NaN  18607  19667  20453  26777  19102   \n",
       "11      ...   1084    676    604    NaN  18335  19849  19795  24385  18665   \n",
       "12      ...   1082    703    550    NaN  18391  19722  19016  22777  17640   \n",
       "13      ...   1079    655    549    NaN  18493  19678  18562  20906  17731   \n",
       "14      ...   1067    627    575    NaN  18820  20662  18671  20038  17028   \n",
       "15      ...   1045    599    536    NaN  19062  20502  17852  19165  16901   \n",
       "16      ...    991    584    503    NaN  19241  19261  18089  17992  16637   \n",
       "17      ...    985    627    518    NaN  19507  18557  17894  17093  17634   \n",
       "18      ...   1005    604    549    NaN  19308  17920  17090  16789  17129   \n",
       "19      ...   1014    659    503    NaN  18589  17651  17118  17226  17343   \n",
       "20      ...    970    565    522    NaN  17787  17001  17315  16488  17079   \n",
       "21      ...    963    598    507    NaN  17158  17163  17080  16513  16451   \n",
       "22      ...    905    572    555    NaN  18162  16776  16921  17039  16902   \n",
       "23      ...    890    509    482    NaN  17408  17262  17491  16714  15846   \n",
       "24      ...    898    520    483    NaN  19043  16601  16484  15582  16087   \n",
       "25      ...    989    640    533    NaN  17179  16401  16639  15843  16819   \n",
       "26      ...    944    542    495    NaN  16983  17293  17918  16569  16076   \n",
       "27      ...    948    566    477    NaN  16949  16457  16552  16622  16424   \n",
       "28      ...    947    578    502    NaN  17616  16142  16319  16070  15603   \n",
       "29      ...    971    603    470    NaN  17571  16537  16856  16702  16589   \n",
       "30      ...   1040    599    503    NaN  17199  16887  19630  18340  16058   \n",
       "31      ...    886    554    449    NaN  16987  17433  17034  20371  16494   \n",
       "32      ...    918    498    462    NaN  17527  17470  16540  18478  15784   \n",
       "33      ...    899    524    501    NaN  17436  19720  15934  16890  16148   \n",
       "34      ...    978    598    533    NaN  17150  17559  16263  16612  15880   \n",
       "35      ...    978    580    450    NaN  17324  16656  17637  16000  16064   \n",
       "36      ...    954    563    526    NaN  18811  16789  15988  16390  15706   \n",
       "37      ...    975    551    516    NaN  17999  17155  16303  16292  16146   \n",
       "38      ...    895    512    509    NaN  18087  17555  16500  16651  16505   \n",
       "39      ...    970    574    504    NaN  18059  17446  17402  15969  16747   \n",
       "40      ...    989    548    510    NaN  18137  17614  16899  16622  16664   \n",
       "41      ...    981    578    511    NaN  18861  17501  17666  16993  17470   \n",
       "42      ...    961    603    589    NaN  19704  17754  17713  16552  17139   \n",
       "43      ...   1065    564    521    NaN  20183  18588  17327  16608  17059   \n",
       "44      ...    993    552    571    NaN  20226  18584  17488  16895  16762   \n",
       "45      ...   1079    607    550    NaN  20930  19007  17859  17604  17371   \n",
       "46      ...   1084    628    541    NaN  22144  19727  18242  16842  17594   \n",
       "47      ...   1037    598    579    NaN  23042  20182  18535  17785  17676   \n",
       "48      ...   1030    651    614    NaN  23968  21304  18581  18091  17877   \n",
       "49      ...   1118    603    588    NaN  23755  22604  19143  18342  18295   \n",
       "50      ...   1158    629    599    NaN  22685  24003  19101  17943  18504   \n",
       "51      ...   1137    680    618    NaN  22272  24724  19062  18990  18500   \n",
       "52      ...   1219    661    603    NaN  21856  25554  18204  17954  18652   \n",
       "53      ...     X      X      X     NaN     X   25497     X      X      X    \n",
       "\n",
       "weekNr DE2016  \n",
       "1       18467  \n",
       "2       18439  \n",
       "3       18627  \n",
       "4       18707  \n",
       "5       18493  \n",
       "6       18541  \n",
       "7       18483  \n",
       "8       18475  \n",
       "9       18926  \n",
       "10      18888  \n",
       "11      18971  \n",
       "12      18826  \n",
       "13      18617  \n",
       "14      18244  \n",
       "15      17712  \n",
       "16      16775  \n",
       "17      17053  \n",
       "18      16901  \n",
       "19      17629  \n",
       "20      16601  \n",
       "21      16286  \n",
       "22      16346  \n",
       "23      15799  \n",
       "24      15717  \n",
       "25      16910  \n",
       "26      15699  \n",
       "27      16229  \n",
       "28      16172  \n",
       "29      16985  \n",
       "30      16157  \n",
       "31      15439  \n",
       "32      15487  \n",
       "33      16258  \n",
       "34      17147  \n",
       "35      16101  \n",
       "36      16116  \n",
       "37      16372  \n",
       "38      15606  \n",
       "39      16336  \n",
       "40      16352  \n",
       "41      17427  \n",
       "42      17599  \n",
       "43      17586  \n",
       "44      17580  \n",
       "45      17782  \n",
       "46      18591  \n",
       "47      17911  \n",
       "48      18146  \n",
       "49      18793  \n",
       "50      18885  \n",
       "51      19376  \n",
       "52      19744  \n",
       "53         X   \n",
       "\n",
       "[53 rows x 103 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# save as csv for use in a d3js graph, you may want to archive this by date\n",
    "output.to_csv(\"overall_mortality_weekly_germany_states.csv\",index_label=\"weekNr\",float_format='%.0f')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}