main.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Gewinner und Verlierer von Listenverbindungen"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "## import libraries\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from requests import get\n",
    "from tqdm import tqdm\n",
    "import json\n",
    "import math\n",
    "import copy"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Dateien importieren"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "## define links to bfs-ressources\n",
    "urlDict = {\n",
    "    'meta_data': 'https://www.bfs.admin.ch/bfsstatic/dam/assets/9386467/master',\n",
    "    'nr_candidates': 'https://www.bfs.admin.ch/bfsstatic/dam/assets/9386465/master',\n",
    "    'lists': 'https://www.bfs.admin.ch/bfsstatic/dam/assets/9386464/master'\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "## download data\n",
    "m = json.loads(get(urlDict['meta_data']).content.decode('utf-8-sig'))\n",
    "nr = json.loads(get(urlDict['nr_candidates']).content.decode('utf-8-sig'))\n",
    "l = json.loads(get(urlDict['lists']).content.decode('utf-8-sig'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "## extract relevant data\n",
    "nr_kandidierende = pd.DataFrame.from_dict(nr[\"kandidierende\"])\n",
    "basislisten = pd.DataFrame.from_dict(l[\"listen\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "## reformat metadata\n",
    "meta_parteien = []\n",
    "for partei in m['parteien']:\n",
    "    meta_parteien.append([partei['partei_id'],\n",
    "                          partei['partei_bezeichnung_kurz'][0]['text'],\n",
    "                          partei['partei_bezeichnung_kurz'][1]['text'],\n",
    "                          partei['partei_bezeichnung'][0]['text'],\n",
    "                          partei['partei_bezeichnung'][1]['text']])\n",
    "    \n",
    "meta_parteien = pd.DataFrame(meta_parteien,\n",
    "                             columns=['partei_id',\n",
    "                                      'partei_bezeichnung_kurz_de',\n",
    "                                      'partei_bezeichnung_kurz_fr',\n",
    "                                      'partei_bezeichnung_de',\n",
    "                                      'partei_bezeichnung_fr'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "## create random party_ids for \"übrige\"\n",
    "for i, row in basislisten[(basislisten.partei_id == 35)].iterrows():\n",
    "    basislisten.loc[i, 'partei_id'] = i + 35"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "## create deepcopy of list\n",
    "listen = copy.deepcopy(basislisten)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Funktionen für spätere Berechnungen definieren"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "## function to distribute mandates and remaining seats on given Level\n",
    "def calc_dist(df, verteilungszahl, sitze): # df: level1 indicator, level2 indicator, number of votes\n",
    "    result = []\n",
    "    \n",
    "    # save rows without level2\n",
    "    for i, row in df[df.iloc[:,1] == \" \"].iterrows():\n",
    "        result.append([row[0], row[2], True, False, 1])\n",
    "    \n",
    "    # save rows with level2 (each level2 summed up as 1 row)\n",
    "    for lv in df[df.iloc[:,1] != \" \"].iloc[:,1].unique():\n",
    "        result.append([lv, df[df.iloc[:,1] == lv].stimmen_liste.sum(), False, True, len(df[df.iloc[:,1] == lv].iloc[:,3].unique())])\n",
    "        \n",
    "    result_df = pd.DataFrame(result, columns=[\"identifier\", \"stimmen\", \"lvl1\", \"lvl2\", \"n_p\"])\n",
    "    result_df['stimmen'] = result_df['stimmen'].astype(float)\n",
    "    result_df['sitze'] = result_df['stimmen'].apply(lambda x: math.floor(x / verteilungszahl)) # calculate seats\n",
    "    \n",
    "    # in case of only 1 remaining party: assing all seats to them\n",
    "    if len(result_df) == 1:\n",
    "        result_df['sitze'] = sitze\n",
    "        \n",
    "    result_df['reststimmen'] = result_df['stimmen'].apply(lambda x: (x % verteilungszahl))\n",
    "    result_df['restmandat'] = 0\n",
    "    \n",
    "    # distribute remaining seat\n",
    "    if result_df['sitze'].sum() < sitze:\n",
    "        restmandate = sitze - result_df['sitze'].sum()\n",
    "        \n",
    "        while restmandate > 0:\n",
    "            result_df['restmandat_verteiler'] = result_df['stimmen'] / (result_df['sitze'] + 1)\n",
    "            idx = result_df.sort_values([\"restmandat_verteiler\"], ascending=False).index[0]\n",
    "            result_df.loc[idx, \"sitze\"] += 1\n",
    "            result_df.loc[idx, \"restmandat\"] += 1\n",
    "            restmandate -= 1\n",
    "    \n",
    "    # return dataframe\n",
    "    return (result_df[[\"identifier\", \"stimmen\", \"lvl1\", \"lvl2\", \"sitze\", \"reststimmen\", \"restmandat\", \"n_p\"]])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "## function to loop through all cantons and levels (Listen, Listenverbindungen, Unterlistenverbindungen) and assign seats\n",
    "def calc_seats(listenverbindungen, print_output = False):\n",
    "    lv_res = []\n",
    "    \n",
    "    # loop through cantons\n",
    "    for kanton in listenverbindungen.kanton_nummer.unique():\n",
    "        listen_kt = listenverbindungen[listenverbindungen.kanton_nummer == kanton] # subset to canton\n",
    "        kanton_name = listen_kt.kanton_bezeichnung.unique()[0] # extract name of canton\n",
    "        nr_sitze = listen_kt.anzahl_gewaehlte.sum() # total number of seats for canton\n",
    "        \n",
    "        if print_output:\n",
    "            print(\"{}: {}\".format(kanton_name, nr_sitze))\n",
    "        \n",
    "        verteilungszahl = math.ceil(listen_kt.stimmen_liste.sum() / (nr_sitze + 1)) # calc \"Verteilungszahl\" (number of votes to get a seat)\n",
    "        # only keep necessary columns and add an empty one\n",
    "        listen_kt = listen_kt[[\"anzahl_gewaehlte\", \"liste_bezeichnung\", \"liste_nummer_kanton\", \"liste_unterlistenverbindung\", \"liste_verbindung\", \"partei_id\", \"stimmen_liste\"]]\n",
    "        listen_kt[\"empty\"] = \" \"\n",
    "        \n",
    "        if print_output:\n",
    "            print(\"------------------------ {} ------------------------\".format(kanton_name))\n",
    "            \n",
    "        # analyse 1. level (use calc_dist())\n",
    "        ebene1 = calc_dist(listen_kt[[\"liste_nummer_kanton\", \"liste_verbindung\", \"stimmen_liste\", \"partei_id\"]], verteilungszahl, nr_sitze)\n",
    "        \n",
    "        if print_output:\n",
    "            print(\"Ebene 1:\")\n",
    "            print(ebene1)\n",
    "        \n",
    "        # loop through results which don't have second level links\n",
    "        for i, row in ebene1[ebene1.lvl1 == True].iterrows():\n",
    "            \n",
    "            if row['sitze'] > 0:\n",
    "                \n",
    "                if len(meta_parteien[meta_parteien.partei_id == (listen_kt[listen_kt.liste_nummer_kanton == row['identifier']].partei_id.values[0])].partei_bezeichnung_kurz_de) > 0:\n",
    "                    parteiname = meta_parteien[meta_parteien.partei_id == (listen_kt[listen_kt.liste_nummer_kanton == row['identifier']].partei_id.values[0])].partei_bezeichnung_kurz_de.values[0]\n",
    "                else:\n",
    "                    parteiname = \"übrige\"\n",
    "                \n",
    "                # append result to final list\n",
    "                lv_res.append([kanton, kanton_name, listen_kt[listen_kt.liste_nummer_kanton == row['identifier']].partei_id.values[0], parteiname, row['sitze'],  row['restmandat'], row['reststimmen'], \"Listenstimmen\", \"\", listen_kt[listen_kt.liste_nummer_kanton == row['identifier']].liste_bezeichnung.values[0], 1])\n",
    "        \n",
    "        # loop through results which have second level links\n",
    "        for i, row in ebene1[(ebene1.sitze > 0) & (ebene1.lvl2 == True)].iterrows():\n",
    "            # calc new \"Verteilungszahl\" (number of votes to get a seat based on the number of seats assigned to this group)\n",
    "            verteilungszahl = math.ceil(row['stimmen'] / (row['sitze'] + 1))\n",
    "            # analyse 2. level (use calc_dist())\n",
    "            ebene2 = calc_dist(listen_kt[listen_kt.liste_verbindung == row['identifier']][[\"liste_nummer_kanton\", \"liste_unterlistenverbindung\", \"stimmen_liste\", \"partei_id\"]], verteilungszahl, row['sitze'])\n",
    "            \n",
    "            if print_output:\n",
    "                print(\"Ebene 2:\")\n",
    "                print(ebene2)\n",
    "                \n",
    "            # loop through results which don't have third level links    \n",
    "            for j, subrow in ebene2[ebene2.lvl1 == True].iterrows():\n",
    "                \n",
    "                if subrow['sitze'] > 0:\n",
    "                    \n",
    "                    if len(meta_parteien[meta_parteien.partei_id == (listen_kt[listen_kt.liste_nummer_kanton == subrow['identifier']].partei_id.values[0])].partei_bezeichnung_kurz_de) > 0:\n",
    "                        parteiname = meta_parteien[meta_parteien.partei_id == (listen_kt[listen_kt.liste_nummer_kanton == subrow['identifier']].partei_id.values[0])].partei_bezeichnung_kurz_de.values[0]\n",
    "                    else:\n",
    "                        parteiname = \"übrige\"\n",
    "                    \n",
    "                    # append result to final list\n",
    "                    lv_res.append([kanton, kanton_name, listen_kt[listen_kt.liste_nummer_kanton == subrow['identifier']].partei_id.values[0], parteiname, subrow['sitze'],  subrow['restmandat'], subrow['reststimmen'], \"Listenverbindung\", row['identifier'], listen_kt[listen_kt.liste_nummer_kanton == subrow['identifier']].liste_bezeichnung.values[0], row['n_p']])\n",
    "            \n",
    "            # loop through results which have third level links    \n",
    "            for j, subrow in ebene2[(ebene2.sitze > 0) & (ebene2.lvl2 == True)].iterrows():\n",
    "                \n",
    "                # calc new \"Verteilungszahl\" (number of votes to get a seat based on the number of seats assigned to this group)\n",
    "                verteilungszahl = math.ceil(subrow['stimmen'] / (subrow['sitze'] + 1))\n",
    "                # analyse 3. level (use calc_dist())\n",
    "                ebene3 = calc_dist(listen_kt[listen_kt.liste_unterlistenverbindung == subrow['identifier']][[\"liste_nummer_kanton\", \"empty\", \"stimmen_liste\", \"partei_id\"]], verteilungszahl, subrow['sitze'])\n",
    "                \n",
    "                if print_output:\n",
    "                    print(\"Ebene 3:\")\n",
    "                    print(ebene3)\n",
    "                    \n",
    "                for k, subsubrow in ebene3[ebene3.lvl1 == True].iterrows():\n",
    "                    \n",
    "                    if subsubrow['sitze'] > 0:\n",
    "                        \n",
    "                        if len(meta_parteien[meta_parteien.partei_id == (listen_kt[listen_kt.liste_nummer_kanton == subsubrow['identifier']].partei_id.values[0])].partei_bezeichnung_kurz_de) > 0:\n",
    "                            parteiname = meta_parteien[meta_parteien.partei_id == (listen_kt[listen_kt.liste_nummer_kanton == subsubrow['identifier']].partei_id.values[0])].partei_bezeichnung_kurz_de.values[0]\n",
    "                        else:\n",
    "                            parteiname = \"übrige\"\n",
    "                            \n",
    "                        # append result to final list\n",
    "                        lv_res.append([kanton, kanton_name, listen_kt[listen_kt.liste_nummer_kanton == subsubrow['identifier']].partei_id.values[0], parteiname, subsubrow['sitze'],  subsubrow['restmandat'], subsubrow['reststimmen'], \"Unterlistenverbindung\", row['identifier'], listen_kt[listen_kt.liste_nummer_kanton == subsubrow['identifier']].liste_bezeichnung.values[0], row['n_p']])\n",
    "                        \n",
    "        if print_output:\n",
    "            print(\" \")\n",
    "            \n",
    "    return pd.DataFrame(lv_res, columns=[\"kanton_nummer\", \"kanton_name\", \"partei_id\", \"parteiname\", \"sitze\", \"restmandat\", \"reststimmen\", \"ebene\", \"listenverbindung_kennzeichen\", \"liste_bezeichnung\", \"anzahl_parteien\"])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {},
   "outputs": [],
   "source": [
    "# function to remove links to other lists of given party\n",
    "def del_lvs(partyid, listenverbindungen):\n",
    "    # create deep copy of dataframe\n",
    "    del_listenverbindungen = copy.deepcopy(listenverbindungen)\n",
    "    \n",
    "    #loop through cantons\n",
    "    for kt in del_listenverbindungen.kanton_nummer.unique():\n",
    "        temp = del_listenverbindungen[del_listenverbindungen.kanton_nummer == kt] #create temporary subset of df (reduced to 1 canton)\n",
    "        # get all list links where the party is part of\n",
    "        del_list = temp[(temp.partei_id == partyid)][[\"liste_verbindung\", \"partei_id\"]].groupby(\"liste_verbindung\").count().reset_index()\n",
    "        \n",
    "        # loop through listenverbindungen to delete\n",
    "        for i, row in del_list.iterrows():\n",
    "            \n",
    "            if row['liste_verbindung'] != \" \":\n",
    "                    \n",
    "                for j, subrow in temp.iterrows():\n",
    "\n",
    "                    # replace list indicator with X\n",
    "                    if ((subrow['partei_id'] == partyid) & (subrow['liste_verbindung'] == row['liste_verbindung'])):\n",
    "                        del_listenverbindungen.loc[j, 'liste_verbindung'] = \"X\"\n",
    "\n",
    "                        if del_listenverbindungen.loc[j, 'liste_unterlistenverbindung'] != \" \":\n",
    "                            del_listenverbindungen.loc[j, 'liste_unterlistenverbindung'] = \"X{}\".format(del_listenverbindungen.loc[j, 'liste_unterlistenverbindung'][1])\n",
    "\n",
    "                        #del_listenverbindungen.loc[j, 'liste_unterlistenverbindung'] = \" \"\n",
    "\n",
    "                    # replace list indicator for other memberrs of the listenverbindung with Y\n",
    "                    if ((subrow['partei_id'] != partyid) & (subrow['liste_verbindung'] == row['liste_verbindung'])):\n",
    "                        del_listenverbindungen.loc[j, 'liste_verbindung'] = \"Y\"\n",
    "\n",
    "                        #if del_listenverbindungen.loc[j, 'liste_unterlistenverbindung'] != \" \":\n",
    "                            #del_listenverbindungen.loc[j, 'liste_unterlistenverbindung'] = \"Y{}\".format(del_listenverbindungen.loc[j, 'liste_unterlistenverbindung'][1])\n",
    "                                \n",
    "    #return new information                            \n",
    "    return del_listenverbindungen"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Szenario 0\n",
    "#### Echte Resulate replizieren"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Zürich: 35\n",
      "------------------------ Zürich ------------------------\n",
      "Ebene 1:\n",
      "  identifier    stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         26    27242.0   True  False      0      27242.0           0    1\n",
      "1         12    45514.0   True  False      0      45514.0           0    1\n",
      "2         22     9540.0   True  False      0       9540.0           0    1\n",
      "3         16     1851.0   True  False      0       1851.0           0    1\n",
      "4         15     3063.0   True  False      0       3063.0           0    1\n",
      "5          D  3406885.0  False   True      8     163821.0           0    4\n",
      "6          B  4974479.0  False   True     12     109883.0           0    6\n",
      "7          A  4131563.0  False   True     10      77733.0           0    2\n",
      "8          C  1993644.0  False   True      5     372112.0           1    1\n",
      "Ebene 2:\n",
      "  identifier    stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          7   239376.0   True  False      0     239376.0           0    1\n",
      "1         D3   481814.0  False   True      1     103271.0           0    1\n",
      "2         D1  2042336.0  False   True      6     149621.0           1    1\n",
      "3         D2   643359.0  False   True      1     264816.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         27   49484.0  True  False      0      49484.0           0    1\n",
      "1          8  391797.0  True  False      1     150890.0           0    1\n",
      "2         21   40533.0  True  False      0      40533.0           0    1\n",
      "Ebene 3:\n",
      "  identifier    stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         23    41796.0  True  False      0      41796.0           0    1\n",
      "1          4  1802530.0  True  False      6      51952.0           0    1\n",
      "2         29   112490.0  True  False      0     112490.0           0    1\n",
      "3         19    85520.0  True  False      0      85520.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          5  529899.0  True  False      1     208219.0           0    1\n",
      "1         13   48833.0  True  False      0      48833.0           0    1\n",
      "2         18   27841.0  True  False      0      27841.0           0    1\n",
      "3         20   36786.0  True  False      0      36786.0           0    1\n",
      "Ebene 2:\n",
      "  identifier    stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         17    47154.0   True  False      0      47154.0           0    1\n",
      "1         11    67005.0   True  False      0      67005.0           0    1\n",
      "2         B2  2054383.0  False   True      5     141118.0           0    1\n",
      "3         B3   279860.0  False   True      0     279860.0           0    2\n",
      "4         B1  2526077.0  False   True      7     230159.0           1    1\n",
      "Ebene 3:\n",
      "  identifier    stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          9   193573.0  True  False      0     193573.0           0    1\n",
      "1         30    36252.0  True  False      0      36252.0           0    1\n",
      "2          6  1824558.0  True  False      5     112568.0           0    1\n",
      "Ebene 3:\n",
      "  identifier    stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         14   108605.0  True  False      0     108605.0           0    1\n",
      "1          2  2417472.0  True  False      7     207152.0           0    1\n",
      "Ebene 2:\n",
      "  identifier    stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         31   235022.0   True  False      0     235022.0           0    1\n",
      "1         A1  3896541.0  False   True     10     140571.0           0    1\n",
      "Ebene 3:\n",
      "  identifier    stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         32    50724.0  True  False      0      50724.0           0    1\n",
      "1          1  3775767.0  True  False     10     233457.0           0    1\n",
      "2         28    70050.0  True  False      0      70050.0           0    1\n",
      "Ebene 2:\n",
      "  identifier    stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          3  1944944.0  True  False      5     283574.0           0    1\n",
      "1         10    48700.0  True  False      0      48700.0           0    1\n",
      " \n",
      "Bern / Berne: 24\n",
      "------------------------ Bern / Berne ------------------------\n",
      "Ebene 1:\n",
      "  identifier    stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         30    61529.0   True  False      0      61529.0           0    1\n",
      "1         28     6269.0   True  False      0       6269.0           0    1\n",
      "2         34    54683.0   True  False      0      54683.0           0    1\n",
      "3          C  2605587.0  False   True      8     295496.0           1    4\n",
      "4          E   329742.0  False   True      1     329742.0           1    7\n",
      "5          B  2021118.0  False   True      6      41040.0           0    5\n",
      "6          A   689737.0  False   True      2      29711.0           0    1\n",
      "7          D  2481637.0  False   True      7     171546.0           0    2\n",
      "Ebene 2:\n",
      "  identifier    stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         24    50917.0   True  False      0      50917.0           0    1\n",
      "1         C2  1166731.0  False   True      4       8691.0           0    2\n",
      "2         C1  1387939.0  False   True      4     229899.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         14   45924.0  True  False      0      45924.0           0    1\n",
      "1         12  978537.0  True  False      4      45149.0           0    1\n",
      "2         13  142270.0  True  False      0     142270.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          5   35121.0  True  False      0      35121.0           0    1\n",
      "1          6   77922.0  True  False      0      77922.0           0    1\n",
      "2          4  505909.0  True  False      1     228321.0           0    1\n",
      "3          3  768987.0  True  False      3     213811.0           1    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         25   30200.0  True  False      0      30200.0           0    1\n",
      "1         27   30578.0  True  False      0      30578.0           0    1\n",
      "2         32    5635.0  True  False      0       5635.0           0    1\n",
      "3         26    8713.0  True  False      0       8713.0           0    1\n",
      "4         20  202288.0  True  False      1      37417.0           0    1\n",
      "5         31   40207.0  True  False      0      40207.0           0    1\n",
      "6         33   12121.0  True  False      0      12121.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         23   55410.0   True  False      0      55410.0           0    1\n",
      "1         B4  154501.0  False   True      0     154501.0           0    1\n",
      "2         B2  803181.0  False   True      3     225717.0           1    1\n",
      "3         B3  344583.0  False   True      1      55851.0           0    1\n",
      "4         B1  663443.0  False   True      2      85979.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         17  101313.0  True  False      0     101313.0           0    1\n",
      "1         16   89566.0  True  False      0      89566.0           0    1\n",
      "2         15  612302.0  True  False      3       9914.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         18  297423.0  True  False      1     125131.0           0    1\n",
      "1         19   47160.0  True  False      0      47160.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          8   74204.0  True  False      0      74204.0           0    1\n",
      "1          7  589239.0  True  False      2     146943.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          9  655801.0   True  False      2     195975.0           0    1\n",
      "1         A1   33936.0  False   True      0      33936.0           0    1\n",
      "Ebene 2:\n",
      "  identifier    stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         29     4003.0   True  False      0       4003.0           0    1\n",
      "1         D1  2477634.0  False   True      7     306199.0           0    1\n",
      "Ebene 3:\n",
      "  identifier    stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          1  2382287.0  True  False      7     214352.0           0    1\n",
      "1          2    95347.0  True  False      0      95347.0           0    1\n",
      " \n",
      "Luzern: 9\n",
      "------------------------ Luzern ------------------------\n",
      "Ebene 1:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         34    1766.0   True  False      0       1766.0           0    1\n",
      "1         10    8451.0   True  False      0       8451.0           0    1\n",
      "2          A  395687.0  False   True      3      39689.0           0    4\n",
      "3          B  293650.0  False   True      2      56318.0           0    1\n",
      "4          C  487102.0  False   True      4      12438.0           0    2\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         14    5945.0   True  False      0       5945.0           0    1\n",
      "1         A3   84227.0  False   True      1      84227.0           1    1\n",
      "2         A2  160408.0  False   True      1      61486.0           0    1\n",
      "3         A1  145107.0  False   True      1      46185.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         33   2225.0  True  False      0       2225.0           0    1\n",
      "1         15   9936.0  True  False      0       9936.0           0    1\n",
      "2          4  72066.0  True  False      1      29952.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         35    1017.0  True  False      0       1017.0           0    1\n",
      "1         17    5890.0  True  False      0       5890.0           0    1\n",
      "2        12a    3516.0  True  False      0       3516.0           0    1\n",
      "3        12b    1722.0  True  False      0       1722.0           0    1\n",
      "4         11    5894.0  True  False      0       5894.0           0    1\n",
      "5          3  142369.0  True  False      1      62165.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         32    9405.0  True  False      0       9405.0           0    1\n",
      "1          8   11963.0  True  False      0      11963.0           0    1\n",
      "2          1  123739.0  True  False      1      51185.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         31    2333.0  True  False      0       2333.0           0    1\n",
      "1         30    2818.0  True  False      0       2818.0           0    1\n",
      "2         20    2755.0  True  False      0       2755.0           0    1\n",
      "3         29    3242.0  True  False      0       3242.0           0    1\n",
      "4          7    8087.0  True  False      0       8087.0           0    1\n",
      "5         28    2948.0  True  False      0       2948.0           0    1\n",
      "6          2  271467.0  True  False      2      75699.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         C1  302480.0  False  True      3      10217.0           0    1\n",
      "1         C2  184622.0  False  True      1      87201.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         25    4791.0  True  False      0       4791.0           0    1\n",
      "1         26    4713.0  True  False      0       4713.0           0    1\n",
      "2         23    3418.0  True  False      0       3418.0           0    1\n",
      "3         24   13388.0  True  False      0      13388.0           0    1\n",
      "4         9a    6474.0  True  False      0       6474.0           0    1\n",
      "5         9b    6268.0  True  False      0       6268.0           0    1\n",
      "6          5  248219.0  True  False      3      21359.0           0    1\n",
      "7         27   15209.0  True  False      0      15209.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         22   11425.0  True  False      0      11425.0           0    1\n",
      "1         13    4092.0  True  False      0       4092.0           0    1\n",
      "2          6  169105.0  True  False      1      76794.0           0    1\n",
      " \n",
      "Uri: 1\n",
      "------------------------ Uri ------------------------\n",
      "Ebene 1:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          3   4685.0  True  False      1       4685.0           1    1\n",
      "1          1   4341.0  True  False      0       4341.0           0    1\n",
      "2         99    265.0  True  False      0        265.0           0    1\n",
      "3          2   2659.0  True  False      0       2659.0           0    1\n",
      " \n",
      "Schwyz: 4\n",
      "------------------------ Schwyz ------------------------\n",
      "Ebene 1:\n",
      "  identifier  stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          C  47103.0  False  True      1       6317.0           0    1\n",
      "1          A  48095.0  False  True      1       7309.0           0    3\n",
      "2          B  33494.0  False  True      0      33494.0           0    2\n",
      "3          D  75234.0  False  True      2      34448.0           1    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         21   1581.0  True  False      0       1581.0           0    1\n",
      "1         14    720.0  True  False      0        720.0           0    1\n",
      "2          7   2793.0  True  False      0       2793.0           0    1\n",
      "3          6  39803.0  True  False      1      16251.0           0    1\n",
      "4         19   2206.0  True  False      0       2206.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         18   1229.0  True  False      0       1229.0           0    1\n",
      "1         10   3059.0  True  False      0       3059.0           0    1\n",
      "2          9   6289.0  True  False      0       6289.0           0    1\n",
      "3          2   4544.0  True  False      0       4544.0           0    1\n",
      "4          1  29768.0  True  False      1       5720.0           0    1\n",
      "5          4   1206.0  True  False      0       1206.0           0    1\n",
      "6          3   2000.0  True  False      0       2000.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         16  72036.0  True  False      2      21880.0           0    1\n",
      "1          8   3198.0  True  False      0       3198.0           0    1\n",
      " \n",
      "Obwalden: 1\n",
      "------------------------ Obwalden ------------------------\n",
      "Ebene 1:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          2   1675.0  True  False      0       1675.0           0    1\n",
      "1          1   1683.0  True  False      0       1683.0           0    1\n",
      "2          3    424.0  True  False      0        424.0           0    1\n",
      "3          5   5412.0  True  False      1       5412.0           1    1\n",
      "4          4   5325.0  True  False      0       5325.0           0    1\n",
      " \n",
      "Nidwalden: 1\n",
      "------------------------ Nidwalden ------------------------\n",
      "Ebene 1:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          2   5383.0  True  False      0       5383.0           0    1\n",
      "1          1   9655.0  True  False      1       2136.0           0    1\n",
      " \n",
      "Glarus: 1\n",
      "------------------------ Glarus ------------------------\n",
      "Ebene 1:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         99    612.0  True  False      0        612.0           0    1\n",
      "1          3    279.0  True  False      0        279.0           0    1\n",
      "2          2   2861.0  True  False      0       2861.0           0    1\n",
      "3          1   6396.0  True  False      1       1322.0           0    1\n",
      " \n",
      "Zug: 3\n",
      "------------------------ Zug ------------------------\n",
      "Ebene 1:\n",
      "  identifier  stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          D  31271.0  False  True      1       1893.0           0    1\n",
      "1          A  34543.0  False  True      1       5165.0           0    3\n",
      "2          C   6505.0  False  True      0       6505.0           0    1\n",
      "3          B  45193.0  False  True      1      15815.0           0    2\n",
      "Ebene 2:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         23  26504.0  True  False      1      10868.0           0    1\n",
      "1         25   1468.0  True  False      0       1468.0           0    1\n",
      "2         24   3299.0  True  False      0       3299.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         10    964.0   True  False      0        964.0           0    1\n",
      "1         A2  10982.0  False   True      0      10982.0           0    1\n",
      "2         A1  22597.0  False   True      1       5325.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          5   1972.0  True  False      0       1972.0           0    1\n",
      "1          4    542.0  True  False      0        542.0           0    1\n",
      "2          1  16135.0  True  False      1       4836.0           0    1\n",
      "3          2   3000.0  True  False      0       3000.0           0    1\n",
      "4          3    948.0  True  False      0        948.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         B2  17247.0  False  True      0      17247.0           0    1\n",
      "1         B1  27946.0  False  True      1       5349.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          9   2174.0  True  False      0       2174.0           0    1\n",
      "1          8   1429.0  True  False      0       1429.0           0    1\n",
      "2          7   2917.0  True  False      0       2917.0           0    1\n",
      "3          6  21426.0  True  False      1       7453.0           0    1\n",
      " \n",
      "Fribourg / Freiburg: 7\n",
      "------------------------ Fribourg / Freiburg ------------------------\n",
      "Ebene 1:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         25    1390.0   True  False      0       1390.0           0    1\n",
      "1         24    2436.0   True  False      0       2436.0           0    1\n",
      "2         22    2162.0   True  False      0       2162.0           0    1\n",
      "3          A  148239.0  False   True      2      72842.0           1    4\n",
      "4          C  229776.0  False   True      3       3585.0           0    4\n",
      "5          D   93011.0  False   True      1      17614.0           0    1\n",
      "6          B  126157.0  False   True      1      50760.0           0    2\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         19    3933.0   True  False      0       3933.0           0    1\n",
      "1         20    4482.0   True  False      0       4482.0           0    1\n",
      "2         A1  107373.0  False   True      2       8547.0           0    1\n",
      "3         A2   32451.0  False   True      0      32451.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         13   6204.0  True  False      0       6204.0           0    1\n",
      "1         12   5205.0  True  False      0       5205.0           0    1\n",
      "2         11   5759.0  True  False      0       5759.0           0    1\n",
      "3         10   3309.0  True  False      0       3309.0           0    1\n",
      "4          1  86896.0  True  False      2      15314.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         23    6960.0   True  False      0       6960.0           0    1\n",
      "1         C1  128028.0  False   True      2      13140.0           0    1\n",
      "2         C2   94788.0  False   True      1      37344.0           0    2\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         17    1852.0  True  False      0       1852.0           0    1\n",
      "1         16    3436.0  True  False      0       3436.0           0    1\n",
      "2         15    7213.0  True  False      0       7213.0           0    1\n",
      "3         18   10410.0  True  False      0      10410.0           0    1\n",
      "4          2  105117.0  True  False      2      19765.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          7  75178.0  True  False      1      27784.0           0    1\n",
      "1          4  19610.0  True  False      0      19610.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         14   5929.0  True  False      0       5929.0           0    1\n",
      "1          3  87082.0  True  False      1      40576.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          8    4430.0   True  False      0       4430.0           0    1\n",
      "1         B1  121727.0  False   True      1      58648.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         21    5618.0  True  False      0       5618.0           0    1\n",
      "1          5  116109.0  True  False      1      55245.0           0    1\n",
      " \n",
      "Solothurn: 6\n",
      "------------------------ Solothurn ------------------------\n",
      "Ebene 1:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         29    4338.0   True  False      0       4338.0           0    1\n",
      "1         28    2855.0   True  False      0       2855.0           0    1\n",
      "2          B  114639.0  False   True      1      46951.0           0    4\n",
      "3          C  141467.0  False   True      2       6091.0           0    2\n",
      "4          D  122761.0  False   True      2      55073.0           1    1\n",
      "5          A   87751.0  False   True      1      20063.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         27   5683.0   True  False      0       5683.0           0    1\n",
      "1         B3   9423.0  False   True      0       9423.0           0    1\n",
      "2         B2  32257.0  False   True      0      32257.0           0    1\n",
      "3         B1  67276.0  False   True      1       9956.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          5   4067.0  True  False      0       4067.0           0    1\n",
      "1          4   5048.0  True  False      0       5048.0           0    1\n",
      "2          3  21445.0  True  False      0      21445.0           0    1\n",
      "3          2  36716.0  True  False      1       3078.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         C2  54096.0  False  True      1       6940.0           0    1\n",
      "1         C1  87371.0  False  True      1      40215.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         23   6811.0  True  False      0       6811.0           0    1\n",
      "1         12  11015.0  True  False      0      11015.0           0    1\n",
      "2         11  36270.0  True  False      1       9222.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         18   3606.0  True  False      0       3606.0           0    1\n",
      "1         10  30451.0  True  False      0      30451.0           0    1\n",
      "2          9  44646.0  True  False      1        960.0           0    1\n",
      "3          7   3859.0  True  False      0       3859.0           0    1\n",
      "4          6   4809.0  True  False      0       4809.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         17    3651.0  True  False      0       3651.0           0    1\n",
      "1         19    3253.0  True  False      0       3253.0           0    1\n",
      "2          8   10330.0  True  False      0      10330.0           0    1\n",
      "3          1  105527.0  True  False      2      23685.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         16  26572.0  True  False      0      26572.0           0    1\n",
      "1         15  55297.0  True  False      1      11421.0           0    1\n",
      "2         14   2568.0  True  False      0       2568.0           0    1\n",
      "3         13   3314.0  True  False      0       3314.0           0    1\n",
      " \n",
      "Basel-Stadt: 5\n",
      "------------------------ Basel-Stadt ------------------------\n",
      "Ebene 1:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         41     297.0   True  False      0        297.0           0    1\n",
      "1         14    2178.0   True  False      0       2178.0           0    1\n",
      "2          B  140424.0  False   True      3       6465.0           0    4\n",
      "3          A   91173.0  False   True      2       1867.0           0    6\n",
      "4          C   33845.0  False   True      0      33845.0           0    2\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          2   1179.0   True  False      0       1179.0           0    1\n",
      "1         B2  51770.0  False   True      1      16664.0           0    2\n",
      "2         B1  87475.0  False   True      2      17263.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         42   4362.0  True  False      0       4362.0           0    1\n",
      "1         40   5644.0  True  False      0       5644.0           0    1\n",
      "2         21   5239.0  True  False      0       5239.0           0    1\n",
      "3          8  36525.0  True  False      1      10640.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         38   2611.0  True  False      0       2611.0           0    1\n",
      "1         39   1190.0  True  False      0       1190.0           0    1\n",
      "2          5  83674.0  True  False      2      25356.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         A4  41077.0  False  True      1      10686.0           0    1\n",
      "1         A3  12244.0  False  True      0      12244.0           0    1\n",
      "2         A2  21658.0  False  True      1      21658.0           1    3\n",
      "3         A1  16194.0  False  True      0      16194.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         34   1901.0  True  False      0       1901.0           0    1\n",
      "1         23   1072.0  True  False      0       1072.0           0    1\n",
      "2          3  38104.0  True  False      1      17565.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         25   1468.0  True  False      0       1468.0           0    1\n",
      "1         11    985.0  True  False      0        985.0           0    1\n",
      "2         10  13799.0  True  False      1       2970.0           0    1\n",
      "3          4   5406.0  True  False      0       5406.0           0    1\n",
      " \n",
      "Basel-Landschaft: 7\n",
      "------------------------ Basel-Landschaft ------------------------\n",
      "Ebene 1:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         13     634.0   True  False      0        634.0           0    1\n",
      "1          B  217635.0  False   True      3      12531.0           0    2\n",
      "2          C  100777.0  False   True      1      32409.0           0    4\n",
      "3          A  227896.0  False   True      3      22792.0           0    2\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         B1  119209.0  False  True      2      10391.0           0    1\n",
      "1         B2   98426.0  False  True      1      44017.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         22    2658.0  True  False      0       2658.0           0    1\n",
      "1          2  113689.0  True  False      2      34215.0           0    1\n",
      "2         23    2862.0  True  False      0       2862.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          7  87578.0  True  False      1      38365.0           0    1\n",
      "1         77   6158.0  True  False      0       6158.0           0    1\n",
      "2         70   4690.0  True  False      0       4690.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          8   6470.0   True  False      0       6470.0           0    1\n",
      "1         C3  28756.0  False   True      0      28756.0           0    1\n",
      "2         C2  46426.0  False   True      1      46426.0           1    1\n",
      "3         C1  19125.0  False   True      0      19125.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          5  37974.0  True  False      1      14761.0           0    1\n",
      "1         56   4111.0  True  False      0       4111.0           0    1\n",
      "2         55   4341.0  True  False      0       4341.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         A1   90352.0  False  True      1      33378.0           0    1\n",
      "1         A2  137544.0  False  True      2      23596.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          6   1467.0  True  False      0       1467.0           0    1\n",
      "1          1  88885.0  True  False      1      43709.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          3  131564.0  True  False      2      39868.0           0    1\n",
      "1         34    2058.0  True  False      0       2058.0           0    1\n",
      "2         33    3922.0  True  False      0       3922.0           0    1\n",
      " \n",
      "Schaffhausen: 2\n",
      "------------------------ Schaffhausen ------------------------\n",
      "Ebene 1:\n",
      "  identifier  stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          B  21900.0  False  True      1       1718.0           0    3\n",
      "1          A  25927.0  False  True      1       5745.0           0    2\n",
      "2          D   6037.0  False  True      0       6037.0           0    3\n",
      "3          C   6681.0  False  True      0       6681.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          4   1929.0   True  False      0       1929.0           0    1\n",
      "1         B2   4135.0  False   True      0       4135.0           0    1\n",
      "2         B1  15836.0  False   True      1       4886.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         14    682.0  True  False      0        682.0           0    1\n",
      "1          2  15154.0  True  False      1       7236.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          7   2041.0   True  False      0       2041.0           0    1\n",
      "1         A1  23886.0  False   True      1      10922.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         17   2061.0  True  False      0       2061.0           0    1\n",
      "1         11    413.0  True  False      0        413.0           0    1\n",
      "2          1  21412.0  True  False      1       9469.0           0    1\n",
      " \n",
      "Appenzell Ausserrhoden: 1\n",
      "------------------------ Appenzell Ausserrhoden ------------------------\n",
      "Ebene 1:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         99    329.0  True  False      0        329.0           0    1\n",
      "1          2   7561.0  True  False      0       7561.0           0    1\n",
      "2          1   7720.0  True  False      1       7720.0           1    1\n",
      " \n",
      "Appenzell Innerrhoden: 1\n",
      "------------------------ Appenzell Innerrhoden ------------------------\n",
      "Ebene 1:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         99     52.0  True  False      0         52.0           0    1\n",
      "1          4   2014.0  True  False      1       2014.0           1    1\n",
      "2          3   1446.0  True  False      0       1446.0           0    1\n",
      "3          2    493.0  True  False      0        493.0           0    1\n",
      "4          1   1642.0  True  False      0       1642.0           0    1\n",
      " \n",
      "St. Gallen: 12\n",
      "------------------------ St. Gallen ------------------------\n",
      "Ebene 1:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         11    4006.0   True  False      0       4006.0           0    1\n",
      "1         10    3407.0   True  False      0       3407.0           0    1\n",
      "2          8   12222.0   True  False      0      12222.0           0    1\n",
      "3          A  450597.0  False   True      3      83157.0           0    4\n",
      "4          B  513443.0  False   True      4      23523.0           0    2\n",
      "5          C  369808.0  False   True      3       2368.0           0    2\n",
      "6          D  238749.0  False   True      2     116269.0           1    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         12   10134.0   True  False      0      10134.0           0    1\n",
      "1          7   24907.0   True  False      0      24907.0           0    1\n",
      "2         A2  116528.0  False   True      1       3878.0           0    1\n",
      "3         A1  299028.0  False   True      2      73728.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         5b  20323.0  True  False      0      20323.0           0    1\n",
      "1         5a  96205.0  True  False      1      37941.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         2d   18702.0  True  False      0      18702.0           0    1\n",
      "1         2c   19362.0  True  False      0      19362.0           0    1\n",
      "2         2b   96959.0  True  False      1      96959.0           1    1\n",
      "3         2a  164005.0  True  False      1      64329.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          9   14768.0   True  False      0      14768.0           0    1\n",
      "1         B1  498675.0  False   True      4      87919.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         1d   18921.0  True  False      0      18921.0           0    1\n",
      "1         1c   10214.0  True  False      0      10214.0           0    1\n",
      "2         1b   14960.0  True  False      0      14960.0           0    1\n",
      "3         1a  454580.0  True  False      4      55640.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         C2  167752.0  False  True      1      75300.0           0    1\n",
      "1         C1  202056.0  False  True      2      17152.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         6c    9830.0  True  False      0       9830.0           0    1\n",
      "1         6a  131827.0  True  False      1      47951.0           0    1\n",
      "2         6b   26095.0  True  False      0      26095.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         3b   10326.0  True  False      0      10326.0           0    1\n",
      "1         3a  191730.0  True  False      2      57026.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         4d   23144.0  True  False      0      23144.0           0    1\n",
      "1         4c   16183.0  True  False      0      16183.0           0    1\n",
      "2         4b   13039.0  True  False      0      13039.0           0    1\n",
      "3         4a  186383.0  True  False      2      27217.0           0    1\n",
      " \n",
      "Graubünden / Grigioni / Grischun: 5\n",
      "------------------------ Graubünden / Grigioni / Grischun ------------------------\n",
      "Ebene 1:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          B   86607.0  False  True      1      38393.0           0    1\n",
      "1          A  113046.0  False  True      2      16618.0           0    3\n",
      "2          C   89626.0  False  True      2      41412.0           1    3\n",
      "Ebene 2:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         20   2726.0  True  False      0       2726.0           0    1\n",
      "1         19   1667.0  True  False      0       1667.0           0    1\n",
      "2         16  35353.0  True  False      0      35353.0           0    1\n",
      "3         14  45263.0  True  False      1       1959.0           0    1\n",
      "4          8   1598.0  True  False      0       1598.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         A1  39429.0  False  True      1       1747.0           0    1\n",
      "1         A3  26324.0  False  True      0      26324.0           0    1\n",
      "2         A2  47293.0  False  True      1       9611.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         18   3547.0  True  False      0       3547.0           0    1\n",
      "1         11   2369.0  True  False      0       2369.0           0    1\n",
      "2         17   2082.0  True  False      0       2082.0           0    1\n",
      "3          2  31431.0  True  False      1      11716.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         10  41927.0  True  False      1      18280.0           0    1\n",
      "1          5   2612.0  True  False      0       2612.0           0    1\n",
      "2          4   2754.0  True  False      0       2754.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          6  15958.0   True  False      0      15958.0           0    1\n",
      "1         C1  49521.0  False   True      2      19645.0           1    1\n",
      "2         C2  24147.0  False   True      0      24147.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         15   2343.0  True  False      0       2343.0           0    1\n",
      "1          9  45677.0  True  False      2      12663.0           0    1\n",
      "2          3   1501.0  True  False      0       1501.0           0    1\n",
      " \n",
      "Aargau: 16\n",
      "------------------------ Aargau ------------------------\n",
      "Ebene 1:\n",
      "  identifier    stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         15     7651.0   True  False      0       7651.0           0    1\n",
      "1          A  1417043.0  False   True      8      11891.0           0    4\n",
      "2          E    17589.0  False   True      0      17589.0           0    3\n",
      "3          B   793834.0  False   True      4      91258.0           0    3\n",
      "4          D   200405.0  False   True      1      24761.0           0    2\n",
      "5          C   549416.0  False   True      3      22484.0           0    2\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         14   41127.0   True  False      0      41127.0           0    1\n",
      "1          9   29768.0   True  False      0      29768.0           0    1\n",
      "2         A2  404732.0  False   True      2      89832.0           0    1\n",
      "3         A1  941416.0  False   True      6     154166.0           1    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         3b   18796.0  True  False      0      18796.0           0    1\n",
      "1         3a  385936.0  True  False      2     116114.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         1b   24769.0  True  False      0      24769.0           0    1\n",
      "1         1a  916647.0  True  False      6     109719.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         10   10090.0   True  False      0      10090.0           0    1\n",
      "1         B2  292070.0  False   True      1     133303.0           0    1\n",
      "2         B1  491674.0  False   True      3      15373.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         5b   34732.0  True  False      0      34732.0           0    1\n",
      "1         5a  257338.0  True  False      1     111303.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         2e   15503.0  True  False      0      15503.0           0    1\n",
      "1         2d   21432.0  True  False      0      21432.0           0    1\n",
      "2         2c   12515.0  True  False      0      12515.0           0    1\n",
      "3         2b   21732.0  True  False      0      21732.0           0    1\n",
      "4         2a  420492.0  True  False      3      51735.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         D2  108794.0  False  True      1       8591.0           0    1\n",
      "1         D1   91611.0  False  True      0      91611.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         8b  12033.0  True  False      0      12033.0           0    1\n",
      "1         8a  89736.0  True  False      1      35339.0           0    1\n",
      "2         8c   7025.0  True  False      0       7025.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         C2  253970.0  False  True      1     116616.0           0    1\n",
      "1         C1  295446.0  False  True      2      20738.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         6c   11618.0  True  False      0      11618.0           0    1\n",
      "1         6b   31050.0  True  False      0      31050.0           0    1\n",
      "2         6a  211302.0  True  False      1      84317.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         4i   10300.0  True  False      0      10300.0           0    1\n",
      "1         4h   14079.0  True  False      0      14079.0           0    1\n",
      "2         4g    5416.0  True  False      0       5416.0           0    1\n",
      "3         4f   13705.0  True  False      0      13705.0           0    1\n",
      "4         4e    6682.0  True  False      0       6682.0           0    1\n",
      "5         4d    9266.0  True  False      0       9266.0           0    1\n",
      "6         4c    6178.0  True  False      0       6178.0           0    1\n",
      "7         4b   23925.0  True  False      0      23925.0           0    1\n",
      "8         4a  205895.0  True  False      2       8931.0           0    1\n",
      " \n",
      "Thurgau: 6\n",
      "------------------------ Thurgau ------------------------\n",
      "Ebene 1:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          A  135321.0  False  True      2      12147.0           0    3\n",
      "1          C   76021.0  False  True      1      14434.0           0    3\n",
      "2          B  219767.0  False  True      3      35006.0           0    3\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         A3  54501.0  False  True      1       9394.0           0    1\n",
      "1         A1  35126.0  False  True      0      35126.0           0    1\n",
      "2         A2  45694.0  False  True      1        587.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         23   3692.0  True  False      0       3692.0           0    1\n",
      "1         17  47973.0  True  False      1      20722.0           0    1\n",
      "2          9   2836.0  True  False      0       2836.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         15   4779.0  True  False      0       4779.0           0    1\n",
      "1         14  31762.0  True  False      1       8915.0           0    1\n",
      "2         13   9153.0  True  False      0       9153.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         C2  11499.0  False  True      0      11499.0           0    1\n",
      "1         C3  54715.0  False  True      1      16704.0           0    1\n",
      "2         C1   9807.0  False  True      0       9807.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         16   3856.0  True  False      0       3856.0           0    1\n",
      "1         12  45122.0  True  False      1      17764.0           0    1\n",
      "2         11   5737.0  True  False      0       5737.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          3   12283.0   True  False      0      12283.0           0    1\n",
      "1         B1   49376.0  False   True      0      49376.0           0    1\n",
      "2         B2  158108.0  False   True      3      48224.0           1    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          5  152401.0  True  False      3      33820.0           0    1\n",
      "1          2    5707.0  True  False      0       5707.0           0    1\n",
      " \n",
      "Ticino: 8\n",
      "------------------------ Ticino ------------------------\n",
      "Ebene 1:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         23    7078.0   True  False      0       7078.0           0    1\n",
      "1         21    3463.0   True  False      0       3463.0           0    1\n",
      "2         19    5741.0   True  False      0       5741.0           0    1\n",
      "3          D    6136.0  False   True      0       6136.0           0    2\n",
      "4          A  332630.0  False   True      4      53444.0           1    3\n",
      "5          B  234252.0  False   True      2      48128.0           0    4\n",
      "6          C  248258.0  False   True      2      62134.0           0    3\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         22    8287.0   True  False      0       8287.0           0    1\n",
      "1          9  171936.0   True  False      2      38884.0           0    1\n",
      "2         A1  152407.0  False   True      2      19355.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         17    2404.0  True  False      0       2404.0           0    1\n",
      "1         13    6623.0  True  False      0       6623.0           0    1\n",
      "2          3    6568.0  True  False      0       6568.0           0    1\n",
      "3          1  136812.0  True  False      2      35206.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         B1  117828.0  False  True      1      39744.0           0    1\n",
      "1         B2  116424.0  False  True      1      38340.0           0    3\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         16    3117.0  True  False      0       3117.0           0    1\n",
      "1         15  107569.0  True  False      1      48655.0           0    1\n",
      "2          4    7142.0  True  False      0       7142.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         14   8025.0  True  False      0       8025.0           0    1\n",
      "1         12  93552.0  True  False      1      35340.0           0    1\n",
      "2         11   7896.0  True  False      0       7896.0           0    1\n",
      "3          5   6951.0  True  False      0       6951.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          8  141777.0   True  False      1      59024.0           0    1\n",
      "1         C1  106481.0  False   True      1      23728.0           0    2\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         18  85792.0  True  False      1      32551.0           0    1\n",
      "1         10   4222.0  True  False      0       4222.0           0    1\n",
      "2          7   7632.0  True  False      0       7632.0           0    1\n",
      "3          6   8835.0  True  False      0       8835.0           0    1\n",
      " \n",
      "Vaud: 19\n",
      "------------------------ Vaud ------------------------\n",
      "Ebene 1:\n",
      "  identifier    stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         23     9651.0   True  False      0       9651.0           0    1\n",
      "1         12     2435.0   True  False      0       2435.0           0    1\n",
      "2         11    16664.0   True  False      0      16664.0           0    1\n",
      "3          5    11143.0   True  False      0      11143.0           0    1\n",
      "4          A  1509841.0  False   True      9     152745.0           1    4\n",
      "5          C   150411.0  False   True      0     150411.0           0    4\n",
      "6          E   791855.0  False   True      5     113307.0           1    1\n",
      "7          D   311119.0  False   True      2     141482.0           1    2\n",
      "8          B   589612.0  False   True      3      80701.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          8   12502.0   True  False      0      12502.0           0    1\n",
      "1         A2  138031.0  False   True      0     138031.0           0    1\n",
      "2         A3  667608.0  False   True      4      63668.0           0    1\n",
      "3         A1  691700.0  False   True      5      87760.0           1    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         16  111358.0  True  False      0     111358.0           0    1\n",
      "1         14  556250.0  True  False      4      22162.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          2   36653.0  True  False      0      36653.0           0    1\n",
      "1          1  655047.0  True  False      5      78627.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         21   28315.0  True  False      0      28315.0           0    1\n",
      "1         17  692664.0  True  False      5      32784.0           0    1\n",
      "2         10   70876.0  True  False      0      70876.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         20   27054.0   True  False      0      27054.0           0    1\n",
      "1         D1  284065.0  False   True      2      76651.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         19   58826.0  True  False      0      58826.0           0    1\n",
      "1          6  225239.0  True  False      2      35861.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         13  538799.0  True  False      3      96590.0           0    1\n",
      "1          3   50813.0  True  False      0      50813.0           0    1\n",
      " \n",
      "Valais / Wallis: 8\n",
      "------------------------ Valais / Wallis ------------------------\n",
      "Ebene 1:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         31   13780.0   True  False      0      13780.0           0    1\n",
      "1          D  161204.0  False   True      1      57532.0           0    2\n",
      "2          A  248988.0  False   True      2      41644.0           0    3\n",
      "3          B  324554.0  False   True      3      13538.0           0    1\n",
      "4          C  184518.0  False   True      2      80846.0           1    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         D2   20901.0  False  True      0      20901.0           0    2\n",
      "1         D1  140303.0  False  True      1      59701.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         37    4945.0  True  False      0       4945.0           0    1\n",
      "1         36    4022.0  True  False      0       4022.0           0    1\n",
      "2         34    2877.0  True  False      0       2877.0           0    1\n",
      "3         33    2176.0  True  False      0       2176.0           0    1\n",
      "4         32  123223.0  True  False      1      53071.0           0    1\n",
      "5         35    3060.0  True  False      0       3060.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         A3    9615.0  False  True      0       9615.0           0    1\n",
      "1         A2   98794.0  False  True      1      15798.0           0    1\n",
      "2         A1  140579.0  False  True      1      57583.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         28   4897.0  True  False      0       4897.0           0    1\n",
      "1         26  14162.0  True  False      0      14162.0           0    1\n",
      "2         25  69281.0  True  False      1      19884.0           0    1\n",
      "3         27  10454.0  True  False      0      10454.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         24    2403.0  True  False      0       2403.0           0    1\n",
      "1         23   17723.0  True  False      0      17723.0           0    1\n",
      "2         12    5201.0  True  False      0       5201.0           0    1\n",
      "3         11    1999.0  True  False      0       1999.0           0    1\n",
      "4         10    1559.0  True  False      0       1559.0           0    1\n",
      "5          9    3238.0  True  False      0       3238.0           0    1\n",
      "6          7    5779.0  True  False      0       5779.0           0    1\n",
      "7          1  102677.0  True  False      1      32387.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         B1  156956.0  False  True      1      75817.0           0    1\n",
      "1         B2  167598.0  False  True      2       5320.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         22   5433.0  True  False      0       5433.0           0    1\n",
      "1         21  83221.0  True  False      1       4743.0           0    1\n",
      "2          3   5605.0  True  False      0       5605.0           0    1\n",
      "3          2  62697.0  True  False      0      62697.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          8  142635.0  True  False      2      30903.0           0    1\n",
      "1          6   12520.0  True  False      0      12520.0           0    1\n",
      "2          5    5771.0  True  False      0       5771.0           0    1\n",
      "3          4    6672.0  True  False      0       6672.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         16   7178.0   True  False      0       7178.0           0    1\n",
      "1         15   5037.0   True  False      0       5037.0           0    1\n",
      "2         C2  87146.0  False   True      1      25640.0           0    1\n",
      "3         C1  85157.0  False   True      1      23651.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         20   2664.0  True  False      0       2664.0           0    1\n",
      "1         19   2600.0  True  False      0       2600.0           0    1\n",
      "2         18   3858.0  True  False      0       3858.0           0    1\n",
      "3         17  78024.0  True  False      1      34451.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         14   6434.0  True  False      0       6434.0           0    1\n",
      "1         13  78723.0  True  False      1      36144.0           0    1\n",
      " \n",
      "Neuchâtel: 4\n",
      "------------------------ Neuchâtel ------------------------\n",
      "Ebene 1:\n",
      "  identifier  stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         39    325.0   True  False      0        325.0           0    1\n",
      "1          D  23134.0  False   True      0      23134.0           0    2\n",
      "2          C  22118.0  False   True      0      22118.0           0    1\n",
      "3          B  90099.0  False   True      3      20209.0           1    3\n",
      "4          A  39049.0  False   True      1       4104.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         B2  61035.0  False  True      2      15985.0           0    2\n",
      "1         B1  29064.0  False  True      1       6539.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0        34C   3608.0  True  False      0       3608.0           0    1\n",
      "1        34B  36357.0  True  False      1      16012.0           0    1\n",
      "2        34A  21070.0  True  False      1        725.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0        33B   3916.0  True  False      0       3916.0           0    1\n",
      "1        33A  25148.0  True  False      1      10616.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         32   4174.0  True  False      0       4174.0           0    1\n",
      "1         31  34875.0  True  False      1      15350.0           0    1\n",
      " \n",
      "Genève: 12\n",
      "------------------------ Genève ------------------------\n",
      "Ebene 1:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         20    2262.0   True  False      0       2262.0           0    1\n",
      "1          B  224673.0  False   True      2      44057.0           0    3\n",
      "2          E   85605.0  False   True      1      85605.0           1    4\n",
      "3          D  549011.0  False   True      6       7163.0           0    3\n",
      "4          A  300438.0  False   True      3      29514.0           0    2\n",
      "5          C   12004.0  False   True      0      12004.0           0    2\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         21    1312.0   True  False      0       1312.0           0    1\n",
      "1         19   63100.0   True  False      0      63100.0           0    1\n",
      "2         B1  160261.0  False   True      2      10479.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         13    6535.0  True  False      0       6535.0           0    1\n",
      "1         18    2662.0  True  False      0       2662.0           0    1\n",
      "2          1  151064.0  True  False      2      44222.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         17   8246.0   True  False      0       8246.0           0    1\n",
      "1         16  10309.0   True  False      0      10309.0           0    1\n",
      "2         26   3128.0   True  False      0       3128.0           0    1\n",
      "3         E1  63922.0  False   True      1      21119.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         27  11444.0  True  False      0      11444.0           0    1\n",
      "1         23  52478.0  True  False      1      20517.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         D3   87141.0  False  True      1       8710.0           0    1\n",
      "1         D1  288938.0  False  True      3      53645.0           0    1\n",
      "2         D2  172932.0  False  True      2      16070.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         15  12283.0  True  False      0      12283.0           0    1\n",
      "1         14  21095.0  True  False      0      21095.0           0    1\n",
      "2         11  13433.0  True  False      0      13433.0           0    1\n",
      "3         10  26696.0  True  False      1      26696.0           1    1\n",
      "4         28  13634.0  True  False      0      13634.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         12    5479.0  True  False      0       5479.0           0    1\n",
      "1          8   38302.0  True  False      0      38302.0           0    1\n",
      "2          3  245157.0  True  False      3      28452.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         22    3983.0  True  False      0       3983.0           0    1\n",
      "1          4    9796.0  True  False      0       9796.0           0    1\n",
      "2          2  159153.0  True  False      2      43865.0           0    1\n",
      "Ebene 2:\n",
      "  identifier   stimmen   lvl1  lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         A2   89965.0  False  True      1      14855.0           0    1\n",
      "1         A1  210473.0  False  True      2      60253.0           0    1\n",
      "Ebene 3:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          9   4585.0  True  False      0       4585.0           0    1\n",
      "1          7  85380.0  True  False      1      40397.0           0    1\n",
      "Ebene 3:\n",
      "  identifier   stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          6    8167.0  True  False      0       8167.0           0    1\n",
      "1          5  202306.0  True  False      2      61990.0           0    1\n",
      " \n",
      "Jura: 2\n",
      "------------------------ Jura ------------------------\n",
      "Ebene 1:\n",
      "  identifier  stimmen   lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         17    644.0   True  False      0        644.0           0    1\n",
      "1          F   7010.0  False   True      0       7010.0           0    1\n",
      "2          E   6493.0  False   True      0       6493.0           0    1\n",
      "3          D  10211.0  False   True      1      10211.0           1    1\n",
      "4          C   4320.0  False   True      0       4320.0           0    1\n",
      "5          B   4071.0  False   True      0       4071.0           0    1\n",
      "6          A  12118.0  False   True      1      12118.0           1    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0         11    627.0  True  False      0        627.0           0    1\n",
      "1         10   1602.0  True  False      0       1602.0           0    1\n",
      "2          9   7982.0  True  False      1       2876.0           0    1\n",
      "Ebene 2:\n",
      "  identifier  stimmen  lvl1   lvl2  sitze  reststimmen  restmandat  n_p\n",
      "0          2   1816.0  True  False      0       1816.0           0    1\n",
      "1          1  10302.0  True  False      1       4243.0           0    1\n",
      " \n"
     ]
    }
   ],
   "source": [
    "# replicate real result based on 'https://www.bfs.admin.ch/bfsstatic/dam/assets/9386464/master' (listen) \n",
    "lv_res_df = calc_seats(listen, print_output=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>sitze</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>parteiname</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>BDP</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVP</th>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EDU</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EVP</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FDP</th>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GLP</th>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GPS</th>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LPS</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lega</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PdA/Sol.</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SVP</th>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            sitze\n",
       "parteiname       \n",
       "BDP             3\n",
       "CVP            25\n",
       "EDU             1\n",
       "EVP             3\n",
       "FDP            28\n",
       "GLP            16\n",
       "GPS            28\n",
       "LPS             1\n",
       "Lega            1\n",
       "PdA/Sol.        2\n",
       "SP             39\n",
       "SVP            53"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# look at seat ditribution\n",
    "lv_res_df[[\"parteiname\", \"sitze\"]].groupby(\"parteiname\").sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Szenario 1\n",
    "#### Sitzzuteilung ganz ohne Listenverbindungen"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "## sum up votes by party and canton (therefore: ignore \"Listenverbindungen\")\n",
    "parteien = listen[[\"kanton_bezeichnung\", \"kanton_nummer\", \"partei_id\", \"anzahl_gewaehlte\", \"stimmen_liste\", \"listen_staerke\"]].groupby([\"kanton_bezeichnung\", \"kanton_nummer\", \"partei_id\"]).sum().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████| 26/26 [00:00<00:00, 150.68it/s]\n"
     ]
    }
   ],
   "source": [
    "## calculate number of votes for seat in parliament\n",
    "## calculations based on https://www.bk.admin.ch/dam/bk/de/dokumente/pore/Leitfaden%20f%C3%BCr%20kandidierende%20Gruppierungen.pdf.download.pdf/Leitfaden%20f%C3%BCr%20kandidierende%20Gruppierungen.pdf\n",
    "\n",
    "for kanton in tqdm(parteien.kanton_nummer.unique()):\n",
    "    verteilungszahl = math.ceil(parteien[parteien.kanton_nummer == kanton].stimmen_liste.sum() / (parteien[parteien.kanton_nummer == kanton].anzahl_gewaehlte.sum() + 1))\n",
    "    \n",
    "    for i, row in parteien[parteien['kanton_nummer'] == kanton].iterrows():\n",
    "        parteien.loc[i, \"verteilungszahl\"] = verteilungszahl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████| 253/253 [00:00<00:00, 1158.84it/s]\n"
     ]
    }
   ],
   "source": [
    "## calculate number of full mandate for each party\n",
    "for i, row in tqdm(parteien.iterrows(), total=len(parteien)):\n",
    "    parteien.loc[i, \"sitze_parteien\"] = math.floor(row['stimmen_liste'] / row['verteilungszahl'])\n",
    "    parteien.loc[i, \"reststimmen\"] = row['stimmen_liste'] % row['verteilungszahl']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "  0%|          | 0/26 [00:00<?, ?it/s]/Users/sco/miniconda3/lib/python3.7/site-packages/ipykernel_launcher.py:9: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  if __name__ == '__main__':\n",
      "100%|██████████| 26/26 [00:01<00:00, 19.81it/s]\n"
     ]
    }
   ],
   "source": [
    "## distribute remaining seats\n",
    "parteien[\"restmandate\"] = 0\n",
    "\n",
    "for kanton in tqdm(parteien.kanton_nummer.unique()):\n",
    "    restmandate = parteien[parteien[\"kanton_nummer\"] == kanton].anzahl_gewaehlte.sum() - parteien[parteien[\"kanton_nummer\"] == kanton].sitze_parteien.sum()\n",
    "    \n",
    "    while restmandate > 0:\n",
    "        temp = parteien[parteien[\"kanton_nummer\"] == kanton]\n",
    "        temp[\"verteilungrest\"] = temp['stimmen_liste'] / (temp['sitze_parteien'] + temp['restmandate'] + 1)\n",
    "        idx = temp.sort_values([\"verteilungrest\"], ascending=False).index[0]\n",
    "        parteien.loc[idx, \"restmandate\"] += 1\n",
    "        restmandate -= 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "## sum up seats\n",
    "parteien['sitze_modell'] = parteien['sitze_parteien'] + parteien['restmandate']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "## calc difference to real result\n",
    "parteien[\"sitze_diff\"] = parteien.anzahl_gewaehlte - parteien.sitze_modell"
   ]
  },
  {
   "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></th>\n",
       "      <th>sitze_modell</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>partei_bezeichnung_kurz_de</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>BDP</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVP</th>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EVP</th>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FDP</th>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GLP</th>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GPS</th>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LPS</th>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lega</th>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PdA/Sol.</th>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SP</th>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SVP</th>\n",
       "      <td>60.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            sitze_modell\n",
       "partei_bezeichnung_kurz_de              \n",
       "BDP                                  3.0\n",
       "CVP                                 23.0\n",
       "EVP                                  2.0\n",
       "FDP                                 29.0\n",
       "GLP                                 11.0\n",
       "GPS                                 30.0\n",
       "LPS                                  1.0\n",
       "Lega                                 1.0\n",
       "PdA/Sol.                             2.0\n",
       "SP                                  38.0\n",
       "SVP                                 60.0"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## look at result (new distribution)\n",
    "pd.merge(parteien[((parteien.sitze_modell != 0))],\n",
    "         meta_parteien[[\"partei_id\", \"partei_bezeichnung_kurz_de\"]],\n",
    "         on=\"partei_id\",\n",
    "         how=\"left\")[[\"partei_bezeichnung_kurz_de\", \"sitze_modell\"]].groupby(\"partei_bezeichnung_kurz_de\").sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>partei_bezeichnung_kurz_de</th>\n",
       "      <th>sitze_diff</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>FDP</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CVP</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SP</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SVP</td>\n",
       "      <td>-7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EVP</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>GPS</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>EDU</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>GLP</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  partei_bezeichnung_kurz_de  sitze_diff\n",
       "0                        FDP        -1.0\n",
       "1                        CVP         2.0\n",
       "2                         SP         1.0\n",
       "3                        SVP        -7.0\n",
       "4                        EVP         1.0\n",
       "5                        GPS        -2.0\n",
       "6                        EDU         1.0\n",
       "7                        GLP         5.0"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## look at differences to real result\n",
    "pd.merge(parteien[parteien.sitze_diff != 0][[\"partei_id\", \"sitze_diff\"]].groupby(\"partei_id\").sum().reset_index(),\n",
    "         meta_parteien[[\"partei_id\", \"partei_bezeichnung_kurz_de\"]],\n",
    "         on=\"partei_id\",\n",
    "         how=\"left\")[[\"partei_bezeichnung_kurz_de\", \"sitze_diff\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {},
   "outputs": [],
   "source": [
    "## export differences to real result\n",
    "pd.merge(parteien[parteien.sitze_diff != 0][[\"partei_id\", \"sitze_diff\"]].groupby(\"partei_id\").sum().reset_index(),\n",
    "         meta_parteien[[\"partei_id\", \"partei_bezeichnung_kurz_de\"]],\n",
    "         on=\"partei_id\",\n",
    "         how=\"left\")[[\"partei_bezeichnung_kurz_de\", \"sitze_diff\"]].to_csv(\"output/diff_keine_listenverbindungen.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>kanton_bezeichnung</th>\n",
       "      <th>kanton_nummer</th>\n",
       "      <th>partei_bezeichnung_kurz_de</th>\n",
       "      <th>partei_id</th>\n",
       "      <th>anzahl_gewaehlte</th>\n",
       "      <th>sitze_modell</th>\n",
       "      <th>restmandate</th>\n",
       "      <th>sitze_diff</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Aargau</td>\n",
       "      <td>19</td>\n",
       "      <td>EVP</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Aargau</td>\n",
       "      <td>19</td>\n",
       "      <td>GPS</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Basel-Landschaft</td>\n",
       "      <td>13</td>\n",
       "      <td>CVP</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Basel-Landschaft</td>\n",
       "      <td>13</td>\n",
       "      <td>GPS</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Basel-Stadt</td>\n",
       "      <td>12</td>\n",
       "      <td>SVP</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Basel-Stadt</td>\n",
       "      <td>12</td>\n",
       "      <td>GLP</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Bern / Berne</td>\n",
       "      <td>2</td>\n",
       "      <td>SP</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Bern / Berne</td>\n",
       "      <td>2</td>\n",
       "      <td>SVP</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Bern / Berne</td>\n",
       "      <td>2</td>\n",
       "      <td>EDU</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Bern / Berne</td>\n",
       "      <td>2</td>\n",
       "      <td>GLP</td>\n",
       "      <td>31</td>\n",
       "      <td>3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Fribourg / Freiburg</td>\n",
       "      <td>10</td>\n",
       "      <td>CVP</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Fribourg / Freiburg</td>\n",
       "      <td>10</td>\n",
       "      <td>SVP</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Genève</td>\n",
       "      <td>25</td>\n",
       "      <td>GPS</td>\n",
       "      <td>13</td>\n",
       "      <td>3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Genève</td>\n",
       "      <td>25</td>\n",
       "      <td>GLP</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Graubünden / Grigioni / Grischun</td>\n",
       "      <td>18</td>\n",
       "      <td>SP</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Graubünden / Grigioni / Grischun</td>\n",
       "      <td>18</td>\n",
       "      <td>SVP</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Luzern</td>\n",
       "      <td>3</td>\n",
       "      <td>SVP</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Luzern</td>\n",
       "      <td>3</td>\n",
       "      <td>GLP</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Thurgau</td>\n",
       "      <td>20</td>\n",
       "      <td>FDP</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Thurgau</td>\n",
       "      <td>20</td>\n",
       "      <td>GPS</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Vaud</td>\n",
       "      <td>22</td>\n",
       "      <td>SP</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Vaud</td>\n",
       "      <td>22</td>\n",
       "      <td>SVP</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Zürich</td>\n",
       "      <td>1</td>\n",
       "      <td>SVP</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Zürich</td>\n",
       "      <td>1</td>\n",
       "      <td>GLP</td>\n",
       "      <td>31</td>\n",
       "      <td>6</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  kanton_bezeichnung  kanton_nummer  \\\n",
       "0                             Aargau             19   \n",
       "1                             Aargau             19   \n",
       "2                   Basel-Landschaft             13   \n",
       "3                   Basel-Landschaft             13   \n",
       "4                        Basel-Stadt             12   \n",
       "5                        Basel-Stadt             12   \n",
       "6                       Bern / Berne              2   \n",
       "7                       Bern / Berne              2   \n",
       "8                       Bern / Berne              2   \n",
       "9                       Bern / Berne              2   \n",
       "10               Fribourg / Freiburg             10   \n",
       "11               Fribourg / Freiburg             10   \n",
       "12                            Genève             25   \n",
       "13                            Genève             25   \n",
       "14  Graubünden / Grigioni / Grischun             18   \n",
       "15  Graubünden / Grigioni / Grischun             18   \n",
       "16                            Luzern              3   \n",
       "17                            Luzern              3   \n",
       "18                           Thurgau             20   \n",
       "19                           Thurgau             20   \n",
       "20                              Vaud             22   \n",
       "21                              Vaud             22   \n",
       "22                            Zürich              1   \n",
       "23                            Zürich              1   \n",
       "\n",
       "   partei_bezeichnung_kurz_de  partei_id  anzahl_gewaehlte  sitze_modell  \\\n",
       "0                         EVP          7                 1           0.0   \n",
       "1                         GPS         13                 1           2.0   \n",
       "2                         CVP          2                 1           0.0   \n",
       "3                         GPS         13                 1           2.0   \n",
       "4                         SVP          4                 0           1.0   \n",
       "5                         GLP         31                 1           0.0   \n",
       "6                          SP          3                 4           5.0   \n",
       "7                         SVP          4                 7           8.0   \n",
       "8                         EDU         16                 1           0.0   \n",
       "9                         GLP         31                 3           2.0   \n",
       "10                        CVP          2                 2           1.0   \n",
       "11                        SVP          4                 1           2.0   \n",
       "12                        GPS         13                 3           4.0   \n",
       "13                        GLP         31                 1           0.0   \n",
       "14                         SP          3                 2           1.0   \n",
       "15                        SVP          4                 1           2.0   \n",
       "16                        SVP          4                 2           3.0   \n",
       "17                        GLP         31                 1           0.0   \n",
       "18                        FDP          1                 0           1.0   \n",
       "19                        GPS         13                 1           0.0   \n",
       "20                         SP          3                 5           4.0   \n",
       "21                        SVP          4                 3           4.0   \n",
       "22                        SVP          4                10          11.0   \n",
       "23                        GLP         31                 6           5.0   \n",
       "\n",
       "    restmandate  sitze_diff  \n",
       "0             0         1.0  \n",
       "1             1        -1.0  \n",
       "2             0         1.0  \n",
       "3             1        -1.0  \n",
       "4             1        -1.0  \n",
       "5             0         1.0  \n",
       "6             1        -1.0  \n",
       "7             1        -1.0  \n",
       "8             0         1.0  \n",
       "9             0         1.0  \n",
       "10            0         1.0  \n",
       "11            1        -1.0  \n",
       "12            1        -1.0  \n",
       "13            0         1.0  \n",
       "14            0         1.0  \n",
       "15            1        -1.0  \n",
       "16            1        -1.0  \n",
       "17            0         1.0  \n",
       "18            1        -1.0  \n",
       "19            0         1.0  \n",
       "20            0         1.0  \n",
       "21            1        -1.0  \n",
       "22            2        -1.0  \n",
       "23            0         1.0  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## look at differences to real result on cantonal level\n",
    "pd.merge(parteien[((parteien.sitze_diff != 0))],\n",
    "         meta_parteien[[\"partei_id\", \"partei_bezeichnung_kurz_de\"]],\n",
    "         on=\"partei_id\",\n",
    "         how=\"left\")[[\"kanton_bezeichnung\", \"kanton_nummer\", \"partei_bezeichnung_kurz_de\", \"partei_id\", \"anzahl_gewaehlte\", \"sitze_modell\", \"restmandate\", \"sitze_diff\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Zürich - anstelle von: Benjamin (Beni) Fischer (SVP)\n",
      "Zürich - ist gewählt: Judith Bellaïche (GLP)\n",
      "Bern / Berne - anstelle von: Corrado Pardini (SP)\n",
      "Bern / Berne - anstelle von: Lars Guggisberg (SVP)\n",
      "Bern / Berne - ist gewählt: Andreas Gafner (EDU)\n",
      "Bern / Berne - ist gewählt: Melanie Mettler (GLP)\n",
      "Luzern - anstelle von: Vroni Thalmann (SVP)\n",
      "Luzern - ist gewählt: Roland Fischer (GLP)\n",
      "Fribourg / Freiburg - ist gewählt: Marie-France Roth Pasquier (CVP)\n",
      "Fribourg / Freiburg - anstelle von: Jean-François Rime (SVP)\n",
      "Basel-Stadt - anstelle von: Sebastian Frehner (SVP)\n",
      "Basel-Stadt - ist gewählt: Katja Christ (GLP)\n",
      "Basel-Landschaft - ist gewählt: Elisabeth Schneider-Schneiter (CVP)\n",
      "Basel-Landschaft - anstelle von: Florence Brenzikofer (GPS)\n",
      "Graubünden / Grigioni / Grischun - ist gewählt: Sandra Locher Benguerel (SP)\n",
      "Graubünden / Grigioni / Grischun - anstelle von: Heinz Brand (SVP)\n",
      "Aargau - ist gewählt: Lilian Studer (EVP)\n",
      "Aargau - anstelle von: Ruth Müri (GPS)\n",
      "Thurgau - anstelle von: Hansjörg Brunner (FDP)\n",
      "Thurgau - ist gewählt: Kurt Egger (GPS)\n",
      "Vaud - ist gewählt: Brigitte Crottaz (SP)\n",
      "Vaud - anstelle von: Philippe Jobin (SVP)\n",
      "Genève - anstelle von: Pierre Eckert (GPS)\n",
      "Genève - ist gewählt: Michel Matter (GLP)\n"
     ]
    }
   ],
   "source": [
    "## find affected politicians\n",
    "affected_seats = pd.merge(parteien[parteien.sitze_diff != 0][[\"partei_id\", \"kanton_bezeichnung\", \"kanton_nummer\", \"sitze_diff\"]].groupby([\"kanton_nummer\", \"kanton_bezeichnung\", \"partei_id\"]).sum().reset_index(),\n",
    "                         meta_parteien[[\"partei_id\", \"partei_bezeichnung_kurz_de\"]],\n",
    "                         on=\"partei_id\",\n",
    "                         how=\"left\")\n",
    "\n",
    "for i, row in affected_seats.iterrows():\n",
    "    candidates = nr_kandidierende[(nr_kandidierende.kanton_nummer == row['kanton_nummer']) & (nr_kandidierende.kandidat_partei_id == row['partei_id'])].sort_values(\"stimmen_kandidat\", ascending=False)\n",
    "    for j, candidate in candidates.iterrows():\n",
    "        if candidate['flag_gewaehlt'] == False:\n",
    "            if row['sitze_diff'] == -1:\n",
    "                print(\"{} - anstelle von: {} {} ({})\".format(row['kanton_bezeichnung'], candidate['vorname'], candidate['name'], row['partei_bezeichnung_kurz_de']))\n",
    "            elif row['sitze_diff'] == 1:\n",
    "                print(\"{} - ist gewählt: {} {} ({})\".format(row['kanton_bezeichnung'], candidates.loc[last_j,'vorname'], candidates.loc[last_j,'name'], row['partei_bezeichnung_kurz_de']))\n",
    "            break\n",
    "        last_j = j"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Szenario 2\n",
    "#### Sitzverteilung falls die FDP konsequent Listenverbindungen mit der SVP eingeht (Und in die bestenden Listenverbindungen der SVP eintritt)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "# create deep copy of dataframe\n",
    "svpfdp_list = copy.deepcopy(listen)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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>kanton_bezeichnung</th>\n",
       "      <th>liste_bezeichnung</th>\n",
       "      <th>liste_unterlistenverbindung</th>\n",
       "      <th>liste_verbindung</th>\n",
       "      <th>partei_id</th>\n",
       "      <th>stimmen_liste</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Zürich</td>\n",
       "      <td>SVP Schweizerische Volkspartei, Junge</td>\n",
       "      <td>A1</td>\n",
       "      <td>A</td>\n",
       "      <td>4</td>\n",
       "      <td>50724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Zürich</td>\n",
       "      <td>SVP Schweizerische Volkspartei</td>\n",
       "      <td>A1</td>\n",
       "      <td>A</td>\n",
       "      <td>4</td>\n",
       "      <td>3775767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Zürich</td>\n",
       "      <td>FDP.Die Liberalen</td>\n",
       "      <td></td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "      <td>1944944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Zürich</td>\n",
       "      <td>SVP Schweizerische Volkspartei, 55plus</td>\n",
       "      <td>A1</td>\n",
       "      <td>A</td>\n",
       "      <td>4</td>\n",
       "      <td>70050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Zürich</td>\n",
       "      <td>Jungfreisinnige Kanton Zürich</td>\n",
       "      <td></td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "      <td>48700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   kanton_bezeichnung                       liste_bezeichnung  \\\n",
       "12             Zürich   SVP Schweizerische Volkspartei, Junge   \n",
       "18             Zürich          SVP Schweizerische Volkspartei   \n",
       "24             Zürich                       FDP.Die Liberalen   \n",
       "25             Zürich  SVP Schweizerische Volkspartei, 55plus   \n",
       "30             Zürich           Jungfreisinnige Kanton Zürich   \n",
       "\n",
       "   liste_unterlistenverbindung liste_verbindung  partei_id  stimmen_liste  \n",
       "12                          A1                A          4          50724  \n",
       "18                          A1                A          4        3775767  \n",
       "24                                            C          1        1944944  \n",
       "25                          A1                A          4          70050  \n",
       "30                                            C          1          48700  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# listenverbindung before (example)\n",
    "svpfdp_list[(svpfdp_list.kanton_nummer == 1) &\n",
    "            ((svpfdp_list.partei_id == 1) |\n",
    "             (svpfdp_list.partei_id == 4))\n",
    "           ][[\"kanton_bezeichnung\",\n",
    "              \"liste_bezeichnung\",\n",
    "              \"liste_unterlistenverbindung\",\n",
    "              \"liste_verbindung\",\n",
    "              \"partei_id\",\n",
    "              \"stimmen_liste\"]]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "# loop through cantons\n",
    "for kanton in svpfdp_list.kanton_nummer.unique():\n",
    "    # get list link of SVP\n",
    "    svp_verbindung = svpfdp_list[(svpfdp_list.kanton_nummer == kanton) & (svpfdp_list.partei_id == 4)].liste_verbindung.unique()\n",
    "    \n",
    "    if len(svp_verbindung) > 0:\n",
    "        \n",
    "        # if SVP is not part of any Listenverbindung, create one\n",
    "        if svp_verbindung[0] == ' ':\n",
    "            svp_verbindung[0] = \"X\"\n",
    "            \n",
    "        for i, row in svpfdp_list[(svpfdp_list.kanton_nummer == kanton)].iterrows():\n",
    "            \n",
    "            # add SVP to existing (or new) Listenverbindung\n",
    "            if (row['partei_id'] == 4):\n",
    "                svpfdp_list.loc[i, 'liste_verbindung'] = svp_verbindung[0]\n",
    "                svpfdp_list.loc[i, 'liste_unterlistenverbindung'] = \" \"\n",
    "            \n",
    "            # add FDP to the same Listenverbindung\n",
    "            if (row['partei_id'] == 1):\n",
    "                svpfdp_list.loc[i, 'liste_verbindung'] = svp_verbindung[0]    \n",
    "                svpfdp_list.loc[i, 'liste_unterlistenverbindung'] = \" \"   \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "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>kanton_bezeichnung</th>\n",
       "      <th>liste_bezeichnung</th>\n",
       "      <th>liste_unterlistenverbindung</th>\n",
       "      <th>liste_verbindung</th>\n",
       "      <th>partei_id</th>\n",
       "      <th>stimmen_liste</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Zürich</td>\n",
       "      <td>SVP Schweizerische Volkspartei, Junge</td>\n",
       "      <td></td>\n",
       "      <td>A</td>\n",
       "      <td>4</td>\n",
       "      <td>50724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Zürich</td>\n",
       "      <td>SVP Schweizerische Volkspartei</td>\n",
       "      <td></td>\n",
       "      <td>A</td>\n",
       "      <td>4</td>\n",
       "      <td>3775767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Zürich</td>\n",
       "      <td>FDP.Die Liberalen</td>\n",
       "      <td></td>\n",
       "      <td>A</td>\n",
       "      <td>1</td>\n",
       "      <td>1944944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Zürich</td>\n",
       "      <td>SVP Schweizerische Volkspartei, 55plus</td>\n",
       "      <td></td>\n",
       "      <td>A</td>\n",
       "      <td>4</td>\n",
       "      <td>70050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Zürich</td>\n",
       "      <td>Jungfreisinnige Kanton Zürich</td>\n",
       "      <td></td>\n",
       "      <td>A</td>\n",
       "      <td>1</td>\n",
       "      <td>48700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   kanton_bezeichnung                       liste_bezeichnung  \\\n",
       "12             Zürich   SVP Schweizerische Volkspartei, Junge   \n",
       "18             Zürich          SVP Schweizerische Volkspartei   \n",
       "24             Zürich                       FDP.Die Liberalen   \n",
       "25             Zürich  SVP Schweizerische Volkspartei, 55plus   \n",
       "30             Zürich           Jungfreisinnige Kanton Zürich   \n",
       "\n",
       "   liste_unterlistenverbindung liste_verbindung  partei_id  stimmen_liste  \n",
       "12                                            A          4          50724  \n",
       "18                                            A          4        3775767  \n",
       "24                                            A          1        1944944  \n",
       "25                                            A          4          70050  \n",
       "30                                            A          1          48700  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# listenverbindung after (example)\n",
    "svpfdp_list[(svpfdp_list.kanton_nummer == 1) &\n",
    "            ((svpfdp_list.partei_id == 1) |\n",
    "             (svpfdp_list.partei_id == 4))\n",
    "           ][[\"kanton_bezeichnung\",\n",
    "              \"liste_bezeichnung\",\n",
    "              \"liste_unterlistenverbindung\",\n",
    "              \"liste_verbindung\",\n",
    "              \"partei_id\",\n",
    "              \"stimmen_liste\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "# calculate new distribution using calc_seats()\n",
    "svpfdp_listenverbindungen_res = calc_seats(svpfdp_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "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>parteiname</th>\n",
       "      <th>sitze</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDP</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CVP</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>EDU</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EVP</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FDP</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>GLP</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>GPS</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>LPS</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Lega</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PdA/Sol.</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>SP</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>SVP</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   parteiname  sitze\n",
       "0         BDP      3\n",
       "1         CVP     22\n",
       "2         EDU      1\n",
       "3         EVP      3\n",
       "4         FDP     28\n",
       "5         GLP     14\n",
       "6         GPS     28\n",
       "7         LPS      1\n",
       "8        Lega      2\n",
       "9    PdA/Sol.      2\n",
       "10         SP     38\n",
       "11        SVP     58"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# look at new seat distribution\n",
    "svpfdp_listenverbindungen_res[[\"parteiname\", \"sitze\"]].groupby([\"parteiname\"]).sum().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "# save new seat distribution to csv\n",
    "svpfdp_listenverbindungen_res[[\"parteiname\", \"sitze\"]].groupby([\"parteiname\"]).sum().reset_index().to_csv(\"output/svpfdp_listenverbindung.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Szenario 3\n",
    "Sitzverteilung falls die Grünen keine Listenverbindungen mit der SP eingingen"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "# create deep copy of dataframe\n",
    "gpssp_list = copy.deepcopy(listen)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "# loop through cantons\n",
    "for kanton in gpssp_list.kanton_nummer.unique():\n",
    "    # get listenverbindung where SP is part of\n",
    "    sp_verbindung = gpssp_list[(gpssp_list.kanton_nummer == kanton) & (gpssp_list.partei_id == 3)].liste_verbindung.unique()\n",
    "    \n",
    "    if len(sp_verbindung) > 0:\n",
    "        \n",
    "        if sp_verbindung[0] != ' ':\n",
    "            \n",
    "            for i, row in gpssp_list[(gpssp_list.kanton_nummer == kanton)].iterrows():\n",
    "                \n",
    "                if (row['partei_id'] == 13):\n",
    "                    \n",
    "                    # if GPS is part of the same Listenverbindung. move them to a new one -> X\n",
    "                    if (row['liste_verbindung'] == sp_verbindung[0]):\n",
    "                        gpssp_list.loc[i, 'liste_verbindung'] = 'X'\n",
    "                        gpssp_list.loc[i, 'liste_unterlistenverbindung'] = ' '\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "# calculate new distribution using calc_seats()\n",
    "spgps_listenverbindungen_res = calc_seats(gpssp_list, print_output = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "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>parteiname</th>\n",
       "      <th>sitze</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDP</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CVP</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>EDU</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EVP</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FDP</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>GLP</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>GPS</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>LPS</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Lega</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PdA/Sol.</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>SP</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>SVP</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   parteiname  sitze\n",
       "0         BDP      3\n",
       "1         CVP     27\n",
       "2         EDU      1\n",
       "3         EVP      3\n",
       "4         FDP     29\n",
       "5         GLP     16\n",
       "6         GPS     25\n",
       "7         LPS      1\n",
       "8        Lega      1\n",
       "9    PdA/Sol.      2\n",
       "10         SP     37\n",
       "11        SVP     55"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# look at new seat distribution\n",
    "spgps_listenverbindungen_res[[\"parteiname\", \"sitze\"]].groupby([\"parteiname\"]).sum().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {},
   "outputs": [],
   "source": [
    "spgps_listenverbindungen_res[[\"parteiname\", \"sitze\"]].groupby([\"parteiname\"]).sum().reset_index().to_csv(\"output/spgps_listenverbindung.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## ------ weitere Szenarien ------"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Szenario FDP und CVP konsequent zusammen\n",
    "Sitzverteilung falls die FDP und CVP konsequent Listenverbindungen eingingen (FDP wird Teil der CVP-Listen)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "fdpcvp_list = copy.deepcopy(listen)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "for kanton in fdpcvp_list.kanton_nummer.unique():\n",
    "    cvp_verbindung = fdpcvp_list[(fdpcvp_list.kanton_nummer == kanton) & (fdpcvp_list.partei_id == 2)].liste_verbindung.unique()\n",
    "    \n",
    "    if len(cvp_verbindung) > 0:\n",
    "        \n",
    "        if cvp_verbindung[0] == ' ':\n",
    "            cvp_verbindung[0] = \"X\"\n",
    "            \n",
    "        for i, row in fdpcvp_list[(fdpcvp_list.kanton_nummer == kanton)].iterrows():\n",
    "            \n",
    "            if (row['partei_id'] == 2):\n",
    "                fdpcvp_list.loc[i, 'liste_verbindung'] = cvp_verbindung[0]\n",
    "                fdpcvp_list.loc[i, 'liste_unterlistenverbindung'] = ' '\n",
    "                \n",
    "            if (row['partei_id'] == 1):\n",
    "                fdpcvp_list.loc[i, 'liste_verbindung'] = cvp_verbindung[0]\n",
    "                fdpcvp_list.loc[i, 'liste_unterlistenverbindung'] = ' '  \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "fdpcvp_listenverbindungen_res = calc_seats(fdpcvp_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "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>parteiname</th>\n",
       "      <th>sitze</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDP</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CVP</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>EDU</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EVP</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FDP</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>GLP</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>GPS</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>LPS</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Lega</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PdA/Sol.</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>SP</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>SVP</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   parteiname  sitze\n",
       "0         BDP      3\n",
       "1         CVP     23\n",
       "2         EDU      1\n",
       "3         EVP      3\n",
       "4         FDP     35\n",
       "5         GLP     16\n",
       "6         GPS     28\n",
       "7         LPS      1\n",
       "8        Lega      1\n",
       "9    PdA/Sol.      2\n",
       "10         SP     38\n",
       "11        SVP     49"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fdpcvp_listenverbindungen_res[[\"parteiname\", \"sitze\"]].groupby([\"parteiname\"]).sum().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {},
   "outputs": [],
   "source": [
    "fdpcvp_listenverbindungen_res[[\"parteiname\", \"sitze\"]].groupby([\"parteiname\"]).sum().reset_index().to_csv(\"output/fdpcvp_listenverbindung.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Szenario keine Mitte-Listenverbindung\n",
    "Sitzverteilung falls die 4 Mitte keine Listenverbindungen einginge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "mitte_list = copy.deepcopy(listen)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Zürich\n",
      "Bern / Berne\n",
      "Fribourg / Freiburg\n",
      "Solothurn\n",
      "Basel-Stadt\n",
      "Basel-Landschaft\n",
      "St. Gallen\n"
     ]
    }
   ],
   "source": [
    "for kanton in mitte_list.kanton_nummer.unique():\n",
    "    mitte_verbindung = mitte_list[(mitte_list.kanton_nummer == kanton) & (mitte_list.partei_id == 7)].liste_verbindung.unique()\n",
    "    \n",
    "    if len(mitte_verbindung) > 0:\n",
    "        \n",
    "        if mitte_verbindung[0] != ' ':\n",
    "            party_list = mitte_list[(mitte_list.kanton_nummer == kanton) & (mitte_list.liste_verbindung == mitte_verbindung[0])].partei_id.unique()\n",
    "            \n",
    "            if ((7 in party_list) & (2 in party_list) & (32 in party_list) & (31 in party_list)):\n",
    "                print(mitte_list[mitte_list.kanton_nummer == kanton].kanton_bezeichnung.unique()[0])\n",
    "                \n",
    "                for i, row in mitte_list[(mitte_list.kanton_nummer == kanton)].iterrows():\n",
    "                    \n",
    "                    if (row['partei_id'] == 7):\n",
    "                        mitte_list.loc[i, 'liste_verbindung'] = 'X'\n",
    "                        mitte_list.loc[i, 'liste_unterlistenverbindung'] = ' '\n",
    "                        \n",
    "                    if (row['partei_id'] == 2):\n",
    "                        mitte_list.loc[i, 'liste_verbindung'] = 'Y'\n",
    "                        mitte_list.loc[i, 'liste_unterlistenverbindung'] = ' '\n",
    "                        \n",
    "                    if (row['partei_id'] == 32):\n",
    "                        mitte_list.loc[i, 'liste_verbindung'] = 'Z'\n",
    "                        mitte_list.loc[i, 'liste_unterlistenverbindung'] = ' '\n",
    "                        \n",
    "                    if (row['partei_id'] == 31):\n",
    "                        mitte_list.loc[i, 'liste_verbindung'] = 'W'\n",
    "                        mitte_list.loc[i, 'liste_unterlistenverbindung'] = ' '\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [],
   "source": [
    "mitte_listenverbindungen_res = calc_seats(mitte_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "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>parteiname</th>\n",
       "      <th>sitze</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDP</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CVP</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>EDU</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EVP</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FDP</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>GLP</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>GPS</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>LPS</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Lega</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PdA/Sol.</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>SP</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>SVP</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   parteiname  sitze\n",
       "0         BDP      3\n",
       "1         CVP     23\n",
       "2         EDU      1\n",
       "3         EVP      3\n",
       "4         FDP     28\n",
       "5         GLP     13\n",
       "6         GPS     29\n",
       "7         LPS      1\n",
       "8        Lega      1\n",
       "9    PdA/Sol.      2\n",
       "10         SP     40\n",
       "11        SVP     56"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mitte_listenverbindungen_res[[\"parteiname\", \"sitze\"]].groupby([\"parteiname\"]).sum().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [],
   "source": [
    "mitte_listenverbindungen_res[[\"parteiname\", \"sitze\"]].groupby([\"parteiname\"]).sum().reset_index().to_csv(\"output/ohne_mitteallianz_listenverbindung.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Szenario FDP\n",
    "Sitzverteilung falls die FDP keine Listenverbindungen eingeht"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [],
   "source": [
    "fdp_listenverbindungen = del_lvs(1, basislisten)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [],
   "source": [
    "fdp_listenverbindungen_res = calc_seats(fdp_listenverbindungen)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "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>parteiname</th>\n",
       "      <th>sitze</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDP</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CVP</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>EDU</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EVP</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FDP</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>GLP</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>GPS</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>LPS</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Lega</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PdA/Sol.</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>SP</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>SVP</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   parteiname  sitze\n",
       "0         BDP      3\n",
       "1         CVP     24\n",
       "2         EDU      1\n",
       "3         EVP      3\n",
       "4         FDP     27\n",
       "5         GLP     16\n",
       "6         GPS     28\n",
       "7         LPS      1\n",
       "8        Lega      2\n",
       "9    PdA/Sol.      2\n",
       "10         SP     39\n",
       "11        SVP     54"
      ]
     },
     "execution_count": 104,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fdp_listenverbindungen_res[[\"parteiname\", \"sitze\"]].groupby([\"parteiname\"]).sum().reset_index()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Szenario EDU\n",
    "Sitzverteilung falls die EDU keine Listenverbindungen eingeht"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [],
   "source": [
    "edu_listenverbindungen = del_lvs(16, listen)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [],
   "source": [
    "edu_listenverbindungen_res = calc_seats(edu_listenverbindungen)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "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>parteiname</th>\n",
       "      <th>sitze</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDP</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CVP</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>EVP</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FDP</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GLP</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>GPS</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>LPS</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Lega</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>PdA/Sol.</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SP</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>SVP</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   parteiname  sitze\n",
       "0         BDP      3\n",
       "1         CVP     25\n",
       "2         EVP      3\n",
       "3         FDP     28\n",
       "4         GLP     16\n",
       "5         GPS     28\n",
       "6         LPS      1\n",
       "7        Lega      1\n",
       "8    PdA/Sol.      2\n",
       "9          SP     39\n",
       "10        SVP     54"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "edu_listenverbindungen_res[[\"parteiname\", \"sitze\"]].groupby([\"parteiname\"]).sum().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "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>parteiname</th>\n",
       "      <th>sitze</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDP</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>EVP</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>FDP</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GLP</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GPS</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SP</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SVP</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  parteiname  sitze\n",
       "0        BDP      2\n",
       "1        EVP      1\n",
       "2        FDP      2\n",
       "3        GLP      3\n",
       "4        GPS      4\n",
       "5         SP      4\n",
       "6        SVP      8"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "edu_listenverbindungen_res[edu_listenverbindungen_res.kanton_nummer == 2][[\"parteiname\", \"sitze\"]].groupby([\"parteiname\"]).sum().reset_index()"
   ]
  },
  {
   "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.7.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}