local electricity mix in Switzerland/Obtain local electricity mix from Stromkennzeichnung.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Introduction"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- This script is used to get the local electricity mixes (based on garantee of origin) given the data published on [Stromkennzeichnung](https://www.strom.ch/de/service/stromkennzeichnung) in Aug 2019\n",
    "- Since the website above was restructured, the script below may not work with current version of the website, thus a pkl file saved in Aug 2019 is provided, while the script shows how the data was originally obatined using [BeautifulSoup](https://www.crummy.com/software/BeautifulSoup/bs4/doc/).\n",
    "- The data contains the % electricity mix by technology for 487 utility providers/entities in 26 Cantons in Switzerland in 2018. The percentages for each utility providers/entities can be added up to be 100%.\n",
    "\n",
    "For any questions, please contact Xiaojin Zhang xiaojin.zhang@psi.ch"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "from bs4 import BeautifulSoup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_kantons=[\"ZH\",\"BE\",\"LU\", \"UR\", \"SZ\", \"OW\", \"NW\", \"GL\", \"ZG\", \"FR\", \"SO\", \"BS\", \"BL\", \"SH\", \"AR\", \"AI\", \"SG\", \"GR\", \"AG\", \"TG\", \"TI\", \"VD\", \"VS\", \"NE\", \"GE\", \"JU\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "26"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(all_kantons)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "results_2018={}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "for kanton in all_kantons:\n",
    "    url='https://www.stromkennzeichnung.ch/de/suche/pcanton/'+kanton+'.html'\n",
    "    data_per_kanton=requests.get(url)\n",
    "    data_per_kanton_soup=BeautifulSoup(data_per_kanton.text, 'html.parser')\n",
    "    data_per_kanton=data_per_kanton_soup.find_all('div', attrs={'class':'row hoverEffect'})\n",
    "    records = {}\n",
    "    for each_supplier in data_per_kanton:\n",
    "        supplier = each_supplier.find('a').text[4:-3]\n",
    "        if each_supplier.find('i') is not None:\n",
    "            elec_type = 'N.A'\n",
    "            pct = 'N.A'\n",
    "        else:\n",
    "            supplies={}\n",
    "            for elec_supply in each_supplier.find_all('div', attrs={'class':'bar'}):\n",
    "                elec_type = elec_supply[\"onmouseover\"][13:].split(\",\")[0].split(\"_\")[0]\n",
    "                pct = elec_supply[\"onmouseover\"][13:].split(\",\")[1].split(\"%\")[0][2:]\n",
    "                supplies.update({elec_type: pct})\n",
    "            records[supplier]=supplies\n",
    "    results_2018[kanton]=records"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "results_2018=pd.DataFrame.from_dict({(i,j): results_2018[i][j] \n",
    "                           for i in results_2018.keys() \n",
    "                           for j in results_2018[i].keys()},\n",
    "                       orient='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></th>\n",
       "      <th>Wasserkraft</th>\n",
       "      <th>Kernenergie</th>\n",
       "      <th>Nicht überprüfbare Energieträger</th>\n",
       "      <th>Geförderter Strom</th>\n",
       "      <th>Erdgas</th>\n",
       "      <th>Erdöl</th>\n",
       "      <th>Kohle</th>\n",
       "      <th>Sonnenenergie</th>\n",
       "      <th>Windenergie</th>\n",
       "      <th>Abfälle</th>\n",
       "      <th>Biomasse</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kanton</th>\n",
       "      <th>Supplier</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">AG</th>\n",
       "      <th>AEW Energie AG</th>\n",
       "      <td>66.92</td>\n",
       "      <td>26.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.82</td>\n",
       "      <td>0.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EFA Energie Freiamt AG</th>\n",
       "      <td>71.70</td>\n",
       "      <td>22.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ELEKTRA Rudolfstetten-Friedlisberg AG (ERF)</th>\n",
       "      <td>93.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EV Gebenstorf AG</th>\n",
       "      <td>33.80</td>\n",
       "      <td>59.45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EV Zeiningen</th>\n",
       "      <td>90.57</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.83</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EW Oftringen AG</th>\n",
       "      <td>71.09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.33</td>\n",
       "      <td>16.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EW Rothrist AG</th>\n",
       "      <td>37.30</td>\n",
       "      <td>45.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.60</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EW Staufen</th>\n",
       "      <td>93.90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.38</td>\n",
       "      <td>0.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EWK Energie AG</th>\n",
       "      <td>76.10</td>\n",
       "      <td>18.30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EWS Energie AG</th>\n",
       "      <td>77.30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.90</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Einwohnergemeinde Oberwil-Lieli c/o Elektra Oberwil-Lieli</th>\n",
       "      <td>1.40</td>\n",
       "      <td>92.90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra - Genossenschaft Baldingen</th>\n",
       "      <td>57.57</td>\n",
       "      <td>36.52</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Besenbüren</th>\n",
       "      <td>90.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.80</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Böttstein</th>\n",
       "      <td>1.96</td>\n",
       "      <td>92.23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Eggenwil</th>\n",
       "      <td>NaN</td>\n",
       "      <td>94.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Geltwil</th>\n",
       "      <td>91.51</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.89</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Genossenschaft Abtwil</th>\n",
       "      <td>89.05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Genossenschaft Auw</th>\n",
       "      <td>80.54</td>\n",
       "      <td>13.15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Genossenschaft Kaiserstuhl   c/o Elektrizitäts-Genossenschaft Siggenthal</th>\n",
       "      <td>94.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Genossenschaft Leibstadt</th>\n",
       "      <td>17.50</td>\n",
       "      <td>76.90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Genossenschaft Oberlunkhofen</th>\n",
       "      <td>94.15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0.02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Genossenschaft Rietheim   c/o Elektrizitäts-Genossenschaft Siggenthal</th>\n",
       "      <td>37.20</td>\n",
       "      <td>55.90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Genossenschaft Schneisingen</th>\n",
       "      <td>93.70</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Mettauertal und Umgebung</th>\n",
       "      <td>47.82</td>\n",
       "      <td>46.58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Remetschwil Genossenschaft</th>\n",
       "      <td>93.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.60</td>\n",
       "      <td>0.10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Sins</th>\n",
       "      <td>43.29</td>\n",
       "      <td>43.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.79</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Sisseln</th>\n",
       "      <td>66.90</td>\n",
       "      <td>27.50</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Unterlunkhofen</th>\n",
       "      <td>NaN</td>\n",
       "      <td>94.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Widen Betriebs AG</th>\n",
       "      <td>NaN</td>\n",
       "      <td>94.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektra Zufikon</th>\n",
       "      <td>22.80</td>\n",
       "      <td>69.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZG</th>\n",
       "      <th>Ägerital Energie Genossenschaft</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>94.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"29\" valign=\"top\">ZH</th>\n",
       "      <th>EGW Weiach Elektrizitätsgenossenschaft</th>\n",
       "      <td>94.38</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EW Wald AG</th>\n",
       "      <td>57.92</td>\n",
       "      <td>25.17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.55</td>\n",
       "      <td>7.76</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektrizitätsgenossenschaft Bubikon</th>\n",
       "      <td>93.50</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.70</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektrizitätsgenossenschaft Otelfingen</th>\n",
       "      <td>94.10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektrizitätsgenossenschaft Rümikon EGR (ZH)</th>\n",
       "      <td>90.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektrizitätsversorgung Benken (ZH)</th>\n",
       "      <td>93.70</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.70</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektrizitätswerk Andelfingen c/o Gemeinde Andelfingen</th>\n",
       "      <td>94.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektrizitätswerk Fehraltorf</th>\n",
       "      <td>65.10</td>\n",
       "      <td>28.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.70</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektrizitätswerk Fällanden</th>\n",
       "      <td>94.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>0.23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektrizitätswerk Herrliberg</th>\n",
       "      <td>93.80</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektrizitätswerk Rümlang Genossenschaft</th>\n",
       "      <td>93.90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.50</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektrizitätswerk der Gemeinde Lindau</th>\n",
       "      <td>94.27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elektrizitätswerke des Kantons Zürich (EKZ)</th>\n",
       "      <td>82.62</td>\n",
       "      <td>1.01</td>\n",
       "      <td>10.46</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Energie Uetikon AG c/o Energie und Wasser Meilen AG</th>\n",
       "      <td>70.69</td>\n",
       "      <td>17.69</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.97</td>\n",
       "      <td>5.05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Energie Uster AG</th>\n",
       "      <td>92.12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gemeindewerke Horgen</th>\n",
       "      <td>88.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.90</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gemeindewerke Pfäffikon</th>\n",
       "      <td>94.24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gemeindewerke Stäfa</th>\n",
       "      <td>71.60</td>\n",
       "      <td>22.26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Genossenschaft Elektrizitätswerk Räterschen EWR</th>\n",
       "      <td>92.63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.85</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Genossenschaft Licht- und Kraftwerke Glattfelden</th>\n",
       "      <td>94.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Industrielle Betriebe Kloten AG</th>\n",
       "      <td>38.20</td>\n",
       "      <td>37.00</td>\n",
       "      <td>18.69</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Infrastruktur Männedorf - Elektrizitätswerk</th>\n",
       "      <td>64.30</td>\n",
       "      <td>26.10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.30</td>\n",
       "      <td>3.70</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Infrastruktur Zürichsee AG</th>\n",
       "      <td>81.10</td>\n",
       "      <td>7.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.10</td>\n",
       "      <td>5.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lieferantenmix Schweiz 2017</th>\n",
       "      <td>60.45</td>\n",
       "      <td>15.08</td>\n",
       "      <td>16.10</td>\n",
       "      <td>5.2</td>\n",
       "      <td>0.38</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.02</td>\n",
       "      <td>0.69</td>\n",
       "      <td>0.79</td>\n",
       "      <td>0.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Politische Gemeinde Oberglatt ZH, Elektrizitätsversorgung</th>\n",
       "      <td>93.70</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.70</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Stadtwerke Wetzikon</th>\n",
       "      <td>85.00</td>\n",
       "      <td>9.30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Werke Wangen-Brüttisellen</th>\n",
       "      <td>94.09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Werke am Zürichsee AG</th>\n",
       "      <td>73.30</td>\n",
       "      <td>19.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ewz Elektrizitätswerk der Stadt Zürich</th>\n",
       "      <td>82.20</td>\n",
       "      <td>7.80</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.40</td>\n",
       "      <td>2.60</td>\n",
       "      <td>0.90</td>\n",
       "      <td>0.50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>487 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                           Wasserkraft  \\\n",
       "Kanton Supplier                                                          \n",
       "AG     AEW Energie AG                                            66.92   \n",
       "       EFA Energie Freiamt AG                                    71.70   \n",
       "       ELEKTRA Rudolfstetten-Friedlisberg AG (ERF)               93.40   \n",
       "       EV Gebenstorf AG                                          33.80   \n",
       "       EV Zeiningen                                              90.57   \n",
       "       EW Oftringen AG                                           71.09   \n",
       "       EW Rothrist AG                                            37.30   \n",
       "       EW Staufen                                                93.90   \n",
       "       EWK Energie AG                                            76.10   \n",
       "       EWS Energie AG                                            77.30   \n",
       "       Einwohnergemeinde Oberwil-Lieli c/o Elektra Obe...         1.40   \n",
       "       Elektra - Genossenschaft Baldingen                        57.57   \n",
       "       Elektra Besenbüren                                        90.60   \n",
       "       Elektra Böttstein                                          1.96   \n",
       "       Elektra Eggenwil                                            NaN   \n",
       "       Elektra Geltwil                                           91.51   \n",
       "       Elektra Genossenschaft Abtwil                             89.05   \n",
       "       Elektra Genossenschaft Auw                                80.54   \n",
       "       Elektra Genossenschaft Kaiserstuhl   c/o Elektr...        94.40   \n",
       "       Elektra Genossenschaft Leibstadt                          17.50   \n",
       "       Elektra Genossenschaft Oberlunkhofen                      94.15   \n",
       "       Elektra Genossenschaft Rietheim   c/o Elektrizi...        37.20   \n",
       "       Elektra Genossenschaft Schneisingen                       93.70   \n",
       "       Elektra Mettauertal und Umgebung                          47.82   \n",
       "       Elektra Remetschwil Genossenschaft                        93.60   \n",
       "       Elektra Sins                                              43.29   \n",
       "       Elektra Sisseln                                           66.90   \n",
       "       Elektra Unterlunkhofen                                      NaN   \n",
       "       Elektra Widen Betriebs AG                                   NaN   \n",
       "       Elektra Zufikon                                           22.80   \n",
       "...                                                                ...   \n",
       "ZG     Ägerital Energie Genossenschaft                             NaN   \n",
       "ZH     EGW Weiach Elektrizitätsgenossenschaft                    94.38   \n",
       "       EW Wald AG                                                57.92   \n",
       "       Elektrizitätsgenossenschaft Bubikon                       93.50   \n",
       "       Elektrizitätsgenossenschaft Otelfingen                    94.10   \n",
       "       Elektrizitätsgenossenschaft Rümikon EGR (ZH)              90.40   \n",
       "       Elektrizitätsversorgung Benken (ZH)                       93.70   \n",
       "       Elektrizitätswerk Andelfingen c/o Gemeinde Ande...        94.21   \n",
       "       Elektrizitätswerk Fehraltorf                              65.10   \n",
       "       Elektrizitätswerk Fällanden                               94.03   \n",
       "       Elektrizitätswerk Herrliberg                              93.80   \n",
       "       Elektrizitätswerk Rümlang Genossenschaft                  93.90   \n",
       "       Elektrizitätswerk der Gemeinde Lindau                     94.27   \n",
       "       Elektrizitätswerke des Kantons Zürich (EKZ)               82.62   \n",
       "       Energie Uetikon AG c/o Energie und Wasser Meile...        70.69   \n",
       "       Energie Uster AG                                          92.12   \n",
       "       Gemeindewerke Horgen                                      88.40   \n",
       "       Gemeindewerke Pfäffikon                                   94.24   \n",
       "       Gemeindewerke Stäfa                                       71.60   \n",
       "       Genossenschaft Elektrizitätswerk Räterschen EWR           92.63   \n",
       "       Genossenschaft Licht- und Kraftwerke Glattfelden          94.04   \n",
       "       Industrielle Betriebe Kloten AG                           38.20   \n",
       "       Infrastruktur Männedorf - Elektrizitätswerk               64.30   \n",
       "       Infrastruktur Zürichsee AG                                81.10   \n",
       "       Lieferantenmix Schweiz 2017                               60.45   \n",
       "       Politische Gemeinde Oberglatt ZH, Elektrizitäts...        93.70   \n",
       "       Stadtwerke Wetzikon                                       85.00   \n",
       "       Werke Wangen-Brüttisellen                                 94.09   \n",
       "       Werke am Zürichsee AG                                     73.30   \n",
       "       ewz Elektrizitätswerk der Stadt Zürich                    82.20   \n",
       "\n",
       "                                                           Kernenergie  \\\n",
       "Kanton Supplier                                                          \n",
       "AG     AEW Energie AG                                            26.40   \n",
       "       EFA Energie Freiamt AG                                    22.60   \n",
       "       ELEKTRA Rudolfstetten-Friedlisberg AG (ERF)                 NaN   \n",
       "       EV Gebenstorf AG                                          59.45   \n",
       "       EV Zeiningen                                                NaN   \n",
       "       EW Oftringen AG                                             NaN   \n",
       "       EW Rothrist AG                                            45.40   \n",
       "       EW Staufen                                                  NaN   \n",
       "       EWK Energie AG                                            18.30   \n",
       "       EWS Energie AG                                              NaN   \n",
       "       Einwohnergemeinde Oberwil-Lieli c/o Elektra Obe...        92.90   \n",
       "       Elektra - Genossenschaft Baldingen                        36.52   \n",
       "       Elektra Besenbüren                                          NaN   \n",
       "       Elektra Böttstein                                         92.23   \n",
       "       Elektra Eggenwil                                          94.40   \n",
       "       Elektra Geltwil                                             NaN   \n",
       "       Elektra Genossenschaft Abtwil                               NaN   \n",
       "       Elektra Genossenschaft Auw                                13.15   \n",
       "       Elektra Genossenschaft Kaiserstuhl   c/o Elektr...          NaN   \n",
       "       Elektra Genossenschaft Leibstadt                          76.90   \n",
       "       Elektra Genossenschaft Oberlunkhofen                        NaN   \n",
       "       Elektra Genossenschaft Rietheim   c/o Elektrizi...        55.90   \n",
       "       Elektra Genossenschaft Schneisingen                         NaN   \n",
       "       Elektra Mettauertal und Umgebung                          46.58   \n",
       "       Elektra Remetschwil Genossenschaft                          NaN   \n",
       "       Elektra Sins                                              43.29   \n",
       "       Elektra Sisseln                                           27.50   \n",
       "       Elektra Unterlunkhofen                                    94.40   \n",
       "       Elektra Widen Betriebs AG                                 94.40   \n",
       "       Elektra Zufikon                                           69.60   \n",
       "...                                                                ...   \n",
       "ZG     Ägerital Energie Genossenschaft                             NaN   \n",
       "ZH     EGW Weiach Elektrizitätsgenossenschaft                      NaN   \n",
       "       EW Wald AG                                                25.17   \n",
       "       Elektrizitätsgenossenschaft Bubikon                         NaN   \n",
       "       Elektrizitätsgenossenschaft Otelfingen                      NaN   \n",
       "       Elektrizitätsgenossenschaft Rümikon EGR (ZH)                NaN   \n",
       "       Elektrizitätsversorgung Benken (ZH)                         NaN   \n",
       "       Elektrizitätswerk Andelfingen c/o Gemeinde Ande...          NaN   \n",
       "       Elektrizitätswerk Fehraltorf                              28.60   \n",
       "       Elektrizitätswerk Fällanden                                 NaN   \n",
       "       Elektrizitätswerk Herrliberg                                NaN   \n",
       "       Elektrizitätswerk Rümlang Genossenschaft                    NaN   \n",
       "       Elektrizitätswerk der Gemeinde Lindau                       NaN   \n",
       "       Elektrizitätswerke des Kantons Zürich (EKZ)                1.01   \n",
       "       Energie Uetikon AG c/o Energie und Wasser Meile...        17.69   \n",
       "       Energie Uster AG                                            NaN   \n",
       "       Gemeindewerke Horgen                                        NaN   \n",
       "       Gemeindewerke Pfäffikon                                     NaN   \n",
       "       Gemeindewerke Stäfa                                       22.26   \n",
       "       Genossenschaft Elektrizitätswerk Räterschen EWR             NaN   \n",
       "       Genossenschaft Licht- und Kraftwerke Glattfelden            NaN   \n",
       "       Industrielle Betriebe Kloten AG                           37.00   \n",
       "       Infrastruktur Männedorf - Elektrizitätswerk               26.10   \n",
       "       Infrastruktur Zürichsee AG                                 7.60   \n",
       "       Lieferantenmix Schweiz 2017                               15.08   \n",
       "       Politische Gemeinde Oberglatt ZH, Elektrizitäts...          NaN   \n",
       "       Stadtwerke Wetzikon                                        9.30   \n",
       "       Werke Wangen-Brüttisellen                                   NaN   \n",
       "       Werke am Zürichsee AG                                     19.40   \n",
       "       ewz Elektrizitätswerk der Stadt Zürich                     7.80   \n",
       "\n",
       "                                                           Nicht überprüfbare Energieträger  \\\n",
       "Kanton Supplier                                                                               \n",
       "AG     AEW Energie AG                                                                   NaN   \n",
       "       EFA Energie Freiamt AG                                                           NaN   \n",
       "       ELEKTRA Rudolfstetten-Friedlisberg AG (ERF)                                      NaN   \n",
       "       EV Gebenstorf AG                                                                 NaN   \n",
       "       EV Zeiningen                                                                     NaN   \n",
       "       EW Oftringen AG                                                                  NaN   \n",
       "       EW Rothrist AG                                                                   NaN   \n",
       "       EW Staufen                                                                       NaN   \n",
       "       EWK Energie AG                                                                   NaN   \n",
       "       EWS Energie AG                                                                 15.90   \n",
       "       Einwohnergemeinde Oberwil-Lieli c/o Elektra Obe...                               NaN   \n",
       "       Elektra - Genossenschaft Baldingen                                               NaN   \n",
       "       Elektra Besenbüren                                                               NaN   \n",
       "       Elektra Böttstein                                                                NaN   \n",
       "       Elektra Eggenwil                                                                 NaN   \n",
       "       Elektra Geltwil                                                                  NaN   \n",
       "       Elektra Genossenschaft Abtwil                                                    NaN   \n",
       "       Elektra Genossenschaft Auw                                                       NaN   \n",
       "       Elektra Genossenschaft Kaiserstuhl   c/o Elektr...                               NaN   \n",
       "       Elektra Genossenschaft Leibstadt                                                 NaN   \n",
       "       Elektra Genossenschaft Oberlunkhofen                                             NaN   \n",
       "       Elektra Genossenschaft Rietheim   c/o Elektrizi...                               NaN   \n",
       "       Elektra Genossenschaft Schneisingen                                              NaN   \n",
       "       Elektra Mettauertal und Umgebung                                                 NaN   \n",
       "       Elektra Remetschwil Genossenschaft                                               NaN   \n",
       "       Elektra Sins                                                                     NaN   \n",
       "       Elektra Sisseln                                                                  NaN   \n",
       "       Elektra Unterlunkhofen                                                           NaN   \n",
       "       Elektra Widen Betriebs AG                                                        NaN   \n",
       "       Elektra Zufikon                                                                  NaN   \n",
       "...                                                                                     ...   \n",
       "ZG     Ägerital Energie Genossenschaft                                                  NaN   \n",
       "ZH     EGW Weiach Elektrizitätsgenossenschaft                                           NaN   \n",
       "       EW Wald AG                                                                       NaN   \n",
       "       Elektrizitätsgenossenschaft Bubikon                                              NaN   \n",
       "       Elektrizitätsgenossenschaft Otelfingen                                           NaN   \n",
       "       Elektrizitätsgenossenschaft Rümikon EGR (ZH)                                     NaN   \n",
       "       Elektrizitätsversorgung Benken (ZH)                                              NaN   \n",
       "       Elektrizitätswerk Andelfingen c/o Gemeinde Ande...                               NaN   \n",
       "       Elektrizitätswerk Fehraltorf                                                     NaN   \n",
       "       Elektrizitätswerk Fällanden                                                      NaN   \n",
       "       Elektrizitätswerk Herrliberg                                                     NaN   \n",
       "       Elektrizitätswerk Rümlang Genossenschaft                                         NaN   \n",
       "       Elektrizitätswerk der Gemeinde Lindau                                            NaN   \n",
       "       Elektrizitätswerke des Kantons Zürich (EKZ)                                    10.46   \n",
       "       Energie Uetikon AG c/o Energie und Wasser Meile...                               NaN   \n",
       "       Energie Uster AG                                                                 NaN   \n",
       "       Gemeindewerke Horgen                                                             NaN   \n",
       "       Gemeindewerke Pfäffikon                                                          NaN   \n",
       "       Gemeindewerke Stäfa                                                              NaN   \n",
       "       Genossenschaft Elektrizitätswerk Räterschen EWR                                  NaN   \n",
       "       Genossenschaft Licht- und Kraftwerke Glattfelden                                 NaN   \n",
       "       Industrielle Betriebe Kloten AG                                                18.69   \n",
       "       Infrastruktur Männedorf - Elektrizitätswerk                                      NaN   \n",
       "       Infrastruktur Zürichsee AG                                                       NaN   \n",
       "       Lieferantenmix Schweiz 2017                                                    16.10   \n",
       "       Politische Gemeinde Oberglatt ZH, Elektrizitäts...                               NaN   \n",
       "       Stadtwerke Wetzikon                                                              NaN   \n",
       "       Werke Wangen-Brüttisellen                                                        NaN   \n",
       "       Werke am Zürichsee AG                                                            NaN   \n",
       "       ewz Elektrizitätswerk der Stadt Zürich                                           NaN   \n",
       "\n",
       "                                                           Geförderter Strom  \\\n",
       "Kanton Supplier                                                                \n",
       "AG     AEW Energie AG                                                    5.6   \n",
       "       EFA Energie Freiamt AG                                            5.6   \n",
       "       ELEKTRA Rudolfstetten-Friedlisberg AG (ERF)                       5.6   \n",
       "       EV Gebenstorf AG                                                  5.6   \n",
       "       EV Zeiningen                                                      5.6   \n",
       "       EW Oftringen AG                                                   5.6   \n",
       "       EW Rothrist AG                                                    5.6   \n",
       "       EW Staufen                                                        5.6   \n",
       "       EWK Energie AG                                                    5.6   \n",
       "       EWS Energie AG                                                    5.6   \n",
       "       Einwohnergemeinde Oberwil-Lieli c/o Elektra Obe...                5.6   \n",
       "       Elektra - Genossenschaft Baldingen                                5.6   \n",
       "       Elektra Besenbüren                                                5.6   \n",
       "       Elektra Böttstein                                                 5.6   \n",
       "       Elektra Eggenwil                                                  5.6   \n",
       "       Elektra Geltwil                                                   5.6   \n",
       "       Elektra Genossenschaft Abtwil                                     5.6   \n",
       "       Elektra Genossenschaft Auw                                        5.6   \n",
       "       Elektra Genossenschaft Kaiserstuhl   c/o Elektr...                5.6   \n",
       "       Elektra Genossenschaft Leibstadt                                  5.6   \n",
       "       Elektra Genossenschaft Oberlunkhofen                              5.6   \n",
       "       Elektra Genossenschaft Rietheim   c/o Elektrizi...                5.6   \n",
       "       Elektra Genossenschaft Schneisingen                               5.6   \n",
       "       Elektra Mettauertal und Umgebung                                  5.6   \n",
       "       Elektra Remetschwil Genossenschaft                                5.6   \n",
       "       Elektra Sins                                                      5.6   \n",
       "       Elektra Sisseln                                                   5.6   \n",
       "       Elektra Unterlunkhofen                                            5.6   \n",
       "       Elektra Widen Betriebs AG                                         5.6   \n",
       "       Elektra Zufikon                                                   5.6   \n",
       "...                                                                      ...   \n",
       "ZG     Ägerital Energie Genossenschaft                                   5.6   \n",
       "ZH     EGW Weiach Elektrizitätsgenossenschaft                            5.6   \n",
       "       EW Wald AG                                                        5.6   \n",
       "       Elektrizitätsgenossenschaft Bubikon                               5.6   \n",
       "       Elektrizitätsgenossenschaft Otelfingen                            5.6   \n",
       "       Elektrizitätsgenossenschaft Rümikon EGR (ZH)                      5.6   \n",
       "       Elektrizitätsversorgung Benken (ZH)                               5.6   \n",
       "       Elektrizitätswerk Andelfingen c/o Gemeinde Ande...                5.6   \n",
       "       Elektrizitätswerk Fehraltorf                                      5.6   \n",
       "       Elektrizitätswerk Fällanden                                       5.6   \n",
       "       Elektrizitätswerk Herrliberg                                      5.6   \n",
       "       Elektrizitätswerk Rümlang Genossenschaft                          5.6   \n",
       "       Elektrizitätswerk der Gemeinde Lindau                             5.6   \n",
       "       Elektrizitätswerke des Kantons Zürich (EKZ)                       5.6   \n",
       "       Energie Uetikon AG c/o Energie und Wasser Meile...                5.6   \n",
       "       Energie Uster AG                                                  5.6   \n",
       "       Gemeindewerke Horgen                                              5.6   \n",
       "       Gemeindewerke Pfäffikon                                           5.6   \n",
       "       Gemeindewerke Stäfa                                               5.6   \n",
       "       Genossenschaft Elektrizitätswerk Räterschen EWR                   5.6   \n",
       "       Genossenschaft Licht- und Kraftwerke Glattfelden                  5.6   \n",
       "       Industrielle Betriebe Kloten AG                                   5.6   \n",
       "       Infrastruktur Männedorf - Elektrizitätswerk                       5.6   \n",
       "       Infrastruktur Zürichsee AG                                        5.6   \n",
       "       Lieferantenmix Schweiz 2017                                       5.2   \n",
       "       Politische Gemeinde Oberglatt ZH, Elektrizitäts...                5.6   \n",
       "       Stadtwerke Wetzikon                                               5.6   \n",
       "       Werke Wangen-Brüttisellen                                         5.6   \n",
       "       Werke am Zürichsee AG                                             5.6   \n",
       "       ewz Elektrizitätswerk der Stadt Zürich                            5.6   \n",
       "\n",
       "                                                           Erdgas  Erdöl  \\\n",
       "Kanton Supplier                                                            \n",
       "AG     AEW Energie AG                                         NaN    NaN   \n",
       "       EFA Energie Freiamt AG                                 NaN    NaN   \n",
       "       ELEKTRA Rudolfstetten-Friedlisberg AG (ERF)            NaN    NaN   \n",
       "       EV Gebenstorf AG                                       NaN    NaN   \n",
       "       EV Zeiningen                                           NaN    NaN   \n",
       "       EW Oftringen AG                                        NaN    NaN   \n",
       "       EW Rothrist AG                                         NaN    NaN   \n",
       "       EW Staufen                                             NaN    NaN   \n",
       "       EWK Energie AG                                         NaN    NaN   \n",
       "       EWS Energie AG                                         NaN    NaN   \n",
       "       Einwohnergemeinde Oberwil-Lieli c/o Elektra Obe...     NaN    NaN   \n",
       "       Elektra - Genossenschaft Baldingen                     NaN    NaN   \n",
       "       Elektra Besenbüren                                     NaN    NaN   \n",
       "       Elektra Böttstein                                      NaN    NaN   \n",
       "       Elektra Eggenwil                                       NaN    NaN   \n",
       "       Elektra Geltwil                                        NaN    NaN   \n",
       "       Elektra Genossenschaft Abtwil                          NaN    NaN   \n",
       "       Elektra Genossenschaft Auw                             NaN    NaN   \n",
       "       Elektra Genossenschaft Kaiserstuhl   c/o Elektr...     NaN    NaN   \n",
       "       Elektra Genossenschaft Leibstadt                       NaN    NaN   \n",
       "       Elektra Genossenschaft Oberlunkhofen                   NaN    NaN   \n",
       "       Elektra Genossenschaft Rietheim   c/o Elektrizi...     NaN    NaN   \n",
       "       Elektra Genossenschaft Schneisingen                    NaN    NaN   \n",
       "       Elektra Mettauertal und Umgebung                       NaN    NaN   \n",
       "       Elektra Remetschwil Genossenschaft                     NaN    NaN   \n",
       "       Elektra Sins                                           NaN   6.03   \n",
       "       Elektra Sisseln                                        NaN    NaN   \n",
       "       Elektra Unterlunkhofen                                 NaN    NaN   \n",
       "       Elektra Widen Betriebs AG                              NaN    NaN   \n",
       "       Elektra Zufikon                                        NaN    NaN   \n",
       "...                                                           ...    ...   \n",
       "ZG     Ägerital Energie Genossenschaft                        NaN    NaN   \n",
       "ZH     EGW Weiach Elektrizitätsgenossenschaft                 NaN    NaN   \n",
       "       EW Wald AG                                             NaN    NaN   \n",
       "       Elektrizitätsgenossenschaft Bubikon                    NaN    NaN   \n",
       "       Elektrizitätsgenossenschaft Otelfingen                 NaN    NaN   \n",
       "       Elektrizitätsgenossenschaft Rümikon EGR (ZH)           NaN    NaN   \n",
       "       Elektrizitätsversorgung Benken (ZH)                    NaN    NaN   \n",
       "       Elektrizitätswerk Andelfingen c/o Gemeinde Ande...     NaN    NaN   \n",
       "       Elektrizitätswerk Fehraltorf                           NaN    NaN   \n",
       "       Elektrizitätswerk Fällanden                           0.23    NaN   \n",
       "       Elektrizitätswerk Herrliberg                           NaN    NaN   \n",
       "       Elektrizitätswerk Rümlang Genossenschaft               NaN    NaN   \n",
       "       Elektrizitätswerk der Gemeinde Lindau                  NaN    NaN   \n",
       "       Elektrizitätswerke des Kantons Zürich (EKZ)            NaN    NaN   \n",
       "       Energie Uetikon AG c/o Energie und Wasser Meile...     NaN    NaN   \n",
       "       Energie Uster AG                                       NaN    NaN   \n",
       "       Gemeindewerke Horgen                                   NaN    NaN   \n",
       "       Gemeindewerke Pfäffikon                                NaN    NaN   \n",
       "       Gemeindewerke Stäfa                                    NaN    NaN   \n",
       "       Genossenschaft Elektrizitätswerk Räterschen EWR        NaN    NaN   \n",
       "       Genossenschaft Licht- und Kraftwerke Glattfelden       NaN    NaN   \n",
       "       Industrielle Betriebe Kloten AG                        NaN    NaN   \n",
       "       Infrastruktur Männedorf - Elektrizitätswerk            NaN    NaN   \n",
       "       Infrastruktur Zürichsee AG                             NaN    NaN   \n",
       "       Lieferantenmix Schweiz 2017                           0.38    NaN   \n",
       "       Politische Gemeinde Oberglatt ZH, Elektrizitäts...     NaN    NaN   \n",
       "       Stadtwerke Wetzikon                                    NaN    NaN   \n",
       "       Werke Wangen-Brüttisellen                              NaN    NaN   \n",
       "       Werke am Zürichsee AG                                  NaN    NaN   \n",
       "       ewz Elektrizitätswerk der Stadt Zürich                 NaN    NaN   \n",
       "\n",
       "                                                           Kohle  \\\n",
       "Kanton Supplier                                                    \n",
       "AG     AEW Energie AG                                        NaN   \n",
       "       EFA Energie Freiamt AG                                NaN   \n",
       "       ELEKTRA Rudolfstetten-Friedlisberg AG (ERF)           NaN   \n",
       "       EV Gebenstorf AG                                      NaN   \n",
       "       EV Zeiningen                                          NaN   \n",
       "       EW Oftringen AG                                       NaN   \n",
       "       EW Rothrist AG                                        NaN   \n",
       "       EW Staufen                                            NaN   \n",
       "       EWK Energie AG                                        NaN   \n",
       "       EWS Energie AG                                        NaN   \n",
       "       Einwohnergemeinde Oberwil-Lieli c/o Elektra Obe...    NaN   \n",
       "       Elektra - Genossenschaft Baldingen                    NaN   \n",
       "       Elektra Besenbüren                                    NaN   \n",
       "       Elektra Böttstein                                     NaN   \n",
       "       Elektra Eggenwil                                      NaN   \n",
       "       Elektra Geltwil                                       NaN   \n",
       "       Elektra Genossenschaft Abtwil                         NaN   \n",
       "       Elektra Genossenschaft Auw                            NaN   \n",
       "       Elektra Genossenschaft Kaiserstuhl   c/o Elektr...    NaN   \n",
       "       Elektra Genossenschaft Leibstadt                      NaN   \n",
       "       Elektra Genossenschaft Oberlunkhofen                  NaN   \n",
       "       Elektra Genossenschaft Rietheim   c/o Elektrizi...    NaN   \n",
       "       Elektra Genossenschaft Schneisingen                   NaN   \n",
       "       Elektra Mettauertal und Umgebung                      NaN   \n",
       "       Elektra Remetschwil Genossenschaft                    NaN   \n",
       "       Elektra Sins                                          NaN   \n",
       "       Elektra Sisseln                                       NaN   \n",
       "       Elektra Unterlunkhofen                                NaN   \n",
       "       Elektra Widen Betriebs AG                             NaN   \n",
       "       Elektra Zufikon                                       NaN   \n",
       "...                                                          ...   \n",
       "ZG     Ägerital Energie Genossenschaft                       NaN   \n",
       "ZH     EGW Weiach Elektrizitätsgenossenschaft                NaN   \n",
       "       EW Wald AG                                            NaN   \n",
       "       Elektrizitätsgenossenschaft Bubikon                   NaN   \n",
       "       Elektrizitätsgenossenschaft Otelfingen                NaN   \n",
       "       Elektrizitätsgenossenschaft Rümikon EGR (ZH)          NaN   \n",
       "       Elektrizitätsversorgung Benken (ZH)                   NaN   \n",
       "       Elektrizitätswerk Andelfingen c/o Gemeinde Ande...    NaN   \n",
       "       Elektrizitätswerk Fehraltorf                          NaN   \n",
       "       Elektrizitätswerk Fällanden                           NaN   \n",
       "       Elektrizitätswerk Herrliberg                          NaN   \n",
       "       Elektrizitätswerk Rümlang Genossenschaft              NaN   \n",
       "       Elektrizitätswerk der Gemeinde Lindau                 NaN   \n",
       "       Elektrizitätswerke des Kantons Zürich (EKZ)           NaN   \n",
       "       Energie Uetikon AG c/o Energie und Wasser Meile...    NaN   \n",
       "       Energie Uster AG                                      NaN   \n",
       "       Gemeindewerke Horgen                                  NaN   \n",
       "       Gemeindewerke Pfäffikon                               NaN   \n",
       "       Gemeindewerke Stäfa                                   NaN   \n",
       "       Genossenschaft Elektrizitätswerk Räterschen EWR       NaN   \n",
       "       Genossenschaft Licht- und Kraftwerke Glattfelden      NaN   \n",
       "       Industrielle Betriebe Kloten AG                       NaN   \n",
       "       Infrastruktur Männedorf - Elektrizitätswerk           NaN   \n",
       "       Infrastruktur Zürichsee AG                            NaN   \n",
       "       Lieferantenmix Schweiz 2017                           NaN   \n",
       "       Politische Gemeinde Oberglatt ZH, Elektrizitäts...    NaN   \n",
       "       Stadtwerke Wetzikon                                   NaN   \n",
       "       Werke Wangen-Brüttisellen                             NaN   \n",
       "       Werke am Zürichsee AG                                 NaN   \n",
       "       ewz Elektrizitätswerk der Stadt Zürich                NaN   \n",
       "\n",
       "                                                           Sonnenenergie  \\\n",
       "Kanton Supplier                                                            \n",
       "AG     AEW Energie AG                                               0.82   \n",
       "       EFA Energie Freiamt AG                                       0.10   \n",
       "       ELEKTRA Rudolfstetten-Friedlisberg AG (ERF)                  1.00   \n",
       "       EV Gebenstorf AG                                             1.15   \n",
       "       EV Zeiningen                                                 3.83   \n",
       "       EW Oftringen AG                                              0.03   \n",
       "       EW Rothrist AG                                               0.10   \n",
       "       EW Staufen                                                   0.38   \n",
       "       EWK Energie AG                                                NaN   \n",
       "       EWS Energie AG                                               1.20   \n",
       "       Einwohnergemeinde Oberwil-Lieli c/o Elektra Obe...           0.10   \n",
       "       Elektra - Genossenschaft Baldingen                           0.25   \n",
       "       Elektra Besenbüren                                           3.80   \n",
       "       Elektra Böttstein                                            0.17   \n",
       "       Elektra Eggenwil                                              NaN   \n",
       "       Elektra Geltwil                                              2.89   \n",
       "       Elektra Genossenschaft Abtwil                                5.35   \n",
       "       Elektra Genossenschaft Auw                                   0.64   \n",
       "       Elektra Genossenschaft Kaiserstuhl   c/o Elektr...            NaN   \n",
       "       Elektra Genossenschaft Leibstadt                              NaN   \n",
       "       Elektra Genossenschaft Oberlunkhofen                         0.19   \n",
       "       Elektra Genossenschaft Rietheim   c/o Elektrizi...           1.30   \n",
       "       Elektra Genossenschaft Schneisingen                          0.50   \n",
       "       Elektra Mettauertal und Umgebung                              NaN   \n",
       "       Elektra Remetschwil Genossenschaft                           0.60   \n",
       "       Elektra Sins                                                 1.79   \n",
       "       Elektra Sisseln                                               NaN   \n",
       "       Elektra Unterlunkhofen                                        NaN   \n",
       "       Elektra Widen Betriebs AG                                     NaN   \n",
       "       Elektra Zufikon                                              2.00   \n",
       "...                                                                  ...   \n",
       "ZG     Ägerital Energie Genossenschaft                             94.40   \n",
       "ZH     EGW Weiach Elektrizitätsgenossenschaft                       0.01   \n",
       "       EW Wald AG                                                   2.55   \n",
       "       Elektrizitätsgenossenschaft Bubikon                          0.70   \n",
       "       Elektrizitätsgenossenschaft Otelfingen                       0.25   \n",
       "       Elektrizitätsgenossenschaft Rümikon EGR (ZH)                 3.90   \n",
       "       Elektrizitätsversorgung Benken (ZH)                          0.70   \n",
       "       Elektrizitätswerk Andelfingen c/o Gemeinde Ande...           0.01   \n",
       "       Elektrizitätswerk Fehraltorf                                 0.70   \n",
       "       Elektrizitätswerk Fällanden                                  0.14   \n",
       "       Elektrizitätswerk Herrliberg                                 0.60   \n",
       "       Elektrizitätswerk Rümlang Genossenschaft                     0.50   \n",
       "       Elektrizitätswerk der Gemeinde Lindau                        0.08   \n",
       "       Elektrizitätswerke des Kantons Zürich (EKZ)                  0.22   \n",
       "       Energie Uetikon AG c/o Energie und Wasser Meile...           0.97   \n",
       "       Energie Uster AG                                             2.28   \n",
       "       Gemeindewerke Horgen                                         0.10   \n",
       "       Gemeindewerke Pfäffikon                                      0.13   \n",
       "       Gemeindewerke Stäfa                                          0.50   \n",
       "       Genossenschaft Elektrizitätswerk Räterschen EWR              0.85   \n",
       "       Genossenschaft Licht- und Kraftwerke Glattfelden             0.21   \n",
       "       Industrielle Betriebe Kloten AG                              0.20   \n",
       "       Infrastruktur Männedorf - Elektrizitätswerk                  0.30   \n",
       "       Infrastruktur Zürichsee AG                                   0.10   \n",
       "       Lieferantenmix Schweiz 2017                                  1.02   \n",
       "       Politische Gemeinde Oberglatt ZH, Elektrizitäts...           0.70   \n",
       "       Stadtwerke Wetzikon                                          0.10   \n",
       "       Werke Wangen-Brüttisellen                                    0.16   \n",
       "       Werke am Zürichsee AG                                        0.20   \n",
       "       ewz Elektrizitätswerk der Stadt Zürich                       0.40   \n",
       "\n",
       "                                                           Windenergie  \\\n",
       "Kanton Supplier                                                          \n",
       "AG     AEW Energie AG                                             0.04   \n",
       "       EFA Energie Freiamt AG                                      NaN   \n",
       "       ELEKTRA Rudolfstetten-Friedlisberg AG (ERF)                 NaN   \n",
       "       EV Gebenstorf AG                                            NaN   \n",
       "       EV Zeiningen                                                NaN   \n",
       "       EW Oftringen AG                                             NaN   \n",
       "       EW Rothrist AG                                              NaN   \n",
       "       EW Staufen                                                 0.03   \n",
       "       EWK Energie AG                                              NaN   \n",
       "       EWS Energie AG                                              NaN   \n",
       "       Einwohnergemeinde Oberwil-Lieli c/o Elektra Obe...          NaN   \n",
       "       Elektra - Genossenschaft Baldingen                          NaN   \n",
       "       Elektra Besenbüren                                          NaN   \n",
       "       Elektra Böttstein                                           NaN   \n",
       "       Elektra Eggenwil                                            NaN   \n",
       "       Elektra Geltwil                                             NaN   \n",
       "       Elektra Genossenschaft Abtwil                               NaN   \n",
       "       Elektra Genossenschaft Auw                                 0.02   \n",
       "       Elektra Genossenschaft Kaiserstuhl   c/o Elektr...          NaN   \n",
       "       Elektra Genossenschaft Leibstadt                            NaN   \n",
       "       Elektra Genossenschaft Oberlunkhofen                       0.02   \n",
       "       Elektra Genossenschaft Rietheim   c/o Elektrizi...          NaN   \n",
       "       Elektra Genossenschaft Schneisingen                        0.10   \n",
       "       Elektra Mettauertal und Umgebung                            NaN   \n",
       "       Elektra Remetschwil Genossenschaft                         0.10   \n",
       "       Elektra Sins                                                NaN   \n",
       "       Elektra Sisseln                                             NaN   \n",
       "       Elektra Unterlunkhofen                                      NaN   \n",
       "       Elektra Widen Betriebs AG                                   NaN   \n",
       "       Elektra Zufikon                                             NaN   \n",
       "...                                                                ...   \n",
       "ZG     Ägerital Energie Genossenschaft                             NaN   \n",
       "ZH     EGW Weiach Elektrizitätsgenossenschaft                      NaN   \n",
       "       EW Wald AG                                                 7.76   \n",
       "       Elektrizitätsgenossenschaft Bubikon                         NaN   \n",
       "       Elektrizitätsgenossenschaft Otelfingen                      NaN   \n",
       "       Elektrizitätsgenossenschaft Rümikon EGR (ZH)                NaN   \n",
       "       Elektrizitätsversorgung Benken (ZH)                         NaN   \n",
       "       Elektrizitätswerk Andelfingen c/o Gemeinde Ande...          NaN   \n",
       "       Elektrizitätswerk Fehraltorf                                NaN   \n",
       "       Elektrizitätswerk Fällanden                                 NaN   \n",
       "       Elektrizitätswerk Herrliberg                                NaN   \n",
       "       Elektrizitätswerk Rümlang Genossenschaft                    NaN   \n",
       "       Elektrizitätswerk der Gemeinde Lindau                       NaN   \n",
       "       Elektrizitätswerke des Kantons Zürich (EKZ)                 NaN   \n",
       "       Energie Uetikon AG c/o Energie und Wasser Meile...         5.05   \n",
       "       Energie Uster AG                                            NaN   \n",
       "       Gemeindewerke Horgen                                        NaN   \n",
       "       Gemeindewerke Pfäffikon                                     NaN   \n",
       "       Gemeindewerke Stäfa                                        0.04   \n",
       "       Genossenschaft Elektrizitätswerk Räterschen EWR             NaN   \n",
       "       Genossenschaft Licht- und Kraftwerke Glattfelden            NaN   \n",
       "       Industrielle Betriebe Kloten AG                            0.03   \n",
       "       Infrastruktur Männedorf - Elektrizitätswerk                3.70   \n",
       "       Infrastruktur Zürichsee AG                                 5.60   \n",
       "       Lieferantenmix Schweiz 2017                                0.69   \n",
       "       Politische Gemeinde Oberglatt ZH, Elektrizitäts...          NaN   \n",
       "       Stadtwerke Wetzikon                                         NaN   \n",
       "       Werke Wangen-Brüttisellen                                   NaN   \n",
       "       Werke am Zürichsee AG                                       NaN   \n",
       "       ewz Elektrizitätswerk der Stadt Zürich                     2.60   \n",
       "\n",
       "                                                           Abfälle  Biomasse  \n",
       "Kanton Supplier                                                               \n",
       "AG     AEW Energie AG                                          NaN      0.22  \n",
       "       EFA Energie Freiamt AG                                  NaN       NaN  \n",
       "       ELEKTRA Rudolfstetten-Friedlisberg AG (ERF)             NaN       NaN  \n",
       "       EV Gebenstorf AG                                        NaN       NaN  \n",
       "       EV Zeiningen                                            NaN       NaN  \n",
       "       EW Oftringen AG                                        6.33     16.95  \n",
       "       EW Rothrist AG                                        11.60       NaN  \n",
       "       EW Staufen                                              NaN      0.09  \n",
       "       EWK Energie AG                                          NaN       NaN  \n",
       "       EWS Energie AG                                          NaN       NaN  \n",
       "       Einwohnergemeinde Oberwil-Lieli c/o Elektra Obe...      NaN       NaN  \n",
       "       Elektra - Genossenschaft Baldingen                      NaN      0.06  \n",
       "       Elektra Besenbüren                                      NaN       NaN  \n",
       "       Elektra Böttstein                                       NaN      0.04  \n",
       "       Elektra Eggenwil                                        NaN       NaN  \n",
       "       Elektra Geltwil                                         NaN       NaN  \n",
       "       Elektra Genossenschaft Abtwil                           NaN       NaN  \n",
       "       Elektra Genossenschaft Auw                              NaN      0.05  \n",
       "       Elektra Genossenschaft Kaiserstuhl   c/o Elektr...      NaN       NaN  \n",
       "       Elektra Genossenschaft Leibstadt                        NaN       NaN  \n",
       "       Elektra Genossenschaft Oberlunkhofen                    NaN      0.04  \n",
       "       Elektra Genossenschaft Rietheim   c/o Elektrizi...      NaN       NaN  \n",
       "       Elektra Genossenschaft Schneisingen                     NaN      0.10  \n",
       "       Elektra Mettauertal und Umgebung                        NaN       NaN  \n",
       "       Elektra Remetschwil Genossenschaft                      NaN      0.10  \n",
       "       Elektra Sins                                            NaN       NaN  \n",
       "       Elektra Sisseln                                         NaN       NaN  \n",
       "       Elektra Unterlunkhofen                                  NaN       NaN  \n",
       "       Elektra Widen Betriebs AG                               NaN       NaN  \n",
       "       Elektra Zufikon                                         NaN       NaN  \n",
       "...                                                            ...       ...  \n",
       "ZG     Ägerital Energie Genossenschaft                         NaN       NaN  \n",
       "ZH     EGW Weiach Elektrizitätsgenossenschaft                  NaN      0.01  \n",
       "       EW Wald AG                                             0.50      0.50  \n",
       "       Elektrizitätsgenossenschaft Bubikon                     NaN      0.20  \n",
       "       Elektrizitätsgenossenschaft Otelfingen                  NaN      0.05  \n",
       "       Elektrizitätsgenossenschaft Rümikon EGR (ZH)            NaN      0.10  \n",
       "       Elektrizitätsversorgung Benken (ZH)                     NaN       NaN  \n",
       "       Elektrizitätswerk Andelfingen c/o Gemeinde Ande...      NaN      0.18  \n",
       "       Elektrizitätswerk Fehraltorf                            NaN       NaN  \n",
       "       Elektrizitätswerk Fällanden                             NaN       NaN  \n",
       "       Elektrizitätswerk Herrliberg                            NaN       NaN  \n",
       "       Elektrizitätswerk Rümlang Genossenschaft                NaN       NaN  \n",
       "       Elektrizitätswerk der Gemeinde Lindau                   NaN      0.05  \n",
       "       Elektrizitätswerke des Kantons Zürich (EKZ)             NaN      0.09  \n",
       "       Energie Uetikon AG c/o Energie und Wasser Meile...      NaN       NaN  \n",
       "       Energie Uster AG                                        NaN       NaN  \n",
       "       Gemeindewerke Horgen                                   5.90       NaN  \n",
       "       Gemeindewerke Pfäffikon                                 NaN      0.03  \n",
       "       Gemeindewerke Stäfa                                     NaN       NaN  \n",
       "       Genossenschaft Elektrizitätswerk Räterschen EWR         NaN      0.92  \n",
       "       Genossenschaft Licht- und Kraftwerke Glattfelden        NaN      0.15  \n",
       "       Industrielle Betriebe Kloten AG                         NaN      0.28  \n",
       "       Infrastruktur Männedorf - Elektrizitätswerk             NaN       NaN  \n",
       "       Infrastruktur Zürichsee AG                              NaN       NaN  \n",
       "       Lieferantenmix Schweiz 2017                            0.79      0.29  \n",
       "       Politische Gemeinde Oberglatt ZH, Elektrizitäts...      NaN       NaN  \n",
       "       Stadtwerke Wetzikon                                     NaN       NaN  \n",
       "       Werke Wangen-Brüttisellen                               NaN      0.15  \n",
       "       Werke am Zürichsee AG                                   NaN      1.50  \n",
       "       ewz Elektrizitätswerk der Stadt Zürich                 0.90      0.50  \n",
       "\n",
       "[487 rows x 11 columns]"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results_2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "results_2018.index.names=\"Kanton\",\"Supplier\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [],
   "source": [
    "cols=['Wasserkraft', \n",
    "      'Kernenergie', \n",
    "      'Nicht überprüfbare Energieträger', \n",
    "      'Geförderter Strom', \n",
    "      'Erdgas', 'Erdöl', 'Kohle', \n",
    "      'Sonnenenergie', 'Windenergie','Abfälle', 'Biomasse'#, 'Geothermie'\n",
    "     ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [],
   "source": [
    "results_2018=results_2018[cols]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "487"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(results_2018)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [],
   "source": [
    "for column in results_2018.columns:\n",
    "    results_2018[column] = results_2018[column].astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {},
   "outputs": [],
   "source": [
    "results_2018=results_2018.unstack(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {},
   "outputs": [],
   "source": [
    "results_2018.index = results_2018.index.map(lambda x: x.rstrip())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "metadata": {},
   "outputs": [],
   "source": [
    "results_2018=results_2018.stack(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [],
   "source": [
    "results_2018=pd.DataFrame.swaplevel(results_2018).sort_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [],
   "source": [
    "results_2018.to_pickle(\"results_2018_stromkennzeichnung.pkl\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [],
   "source": [
    "results_2018 = pd.read_pickle(\"results_2018_stromkennzeichnung.pkl\")"
   ]
  }
 ],
 "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.3"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}