anbieter-daten.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ökostromrecherche\n",
    "\n",
    "Dieses Dokument präsentiert die Datensätze/ Listen mit (Öko-)Stromanbietern, die in die Recherche und den Datensatz eingeflossen sind.\n",
    "\n",
    "**Wichtig**: Uns interessieren die Anbieter selbst und nicht die Tarife/ Stromprodukte."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Allgemeine Stromanbieterlisten\n",
    "\n",
    "Listen von Behörden und Vegleichsportalen schlüsseln nicht immer nach Ökostrom(tarif|produkt)anbieter auf. Was bleibt sind sehr allgemeine Listen von Stromanbietern.\n",
    "\n",
    "### Bundesnetzagentur\n",
    "\n",
    "- Datenquelle: [Stromversorgerliste vom 1.8.2019](https://www.bundesnetzagentur.de/SharedDocs/Downloads/DE/Sachgebiete/Energie/Unternehmen_Institutionen/HandelundVertrieb/LieferantenAnzeige/StromVersorgerListe_pdf.pdf?__blob=publicationFile&v=7)\n",
    "- PDF mit [Tabula](https://tabula.technology/) gescrapt, in Open Refine gesäubert\n",
    "- [Rohdatensatz](raw_data/StromVersorgerListe_Bundesnetzagentur.scraped.csv)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "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>Firmenname</th>\n",
       "      <th>Anmerkung zur Lieferantentätigkeit</th>\n",
       "      <th>Firmenanschrift</th>\n",
       "      <th>PLZ</th>\n",
       "      <th>Firmenort</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1&amp;1 Energy GmbH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elgendorfer Straße 57</td>\n",
       "      <td>56410</td>\n",
       "      <td>Montabaur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>17er Oberlandenergie GmbH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Viehmarktplatz 1</td>\n",
       "      <td>82418</td>\n",
       "      <td>Murnau</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>24/7 Energie &amp; Kommunikation GmbH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Meeboldstraße 1</td>\n",
       "      <td>89522</td>\n",
       "      <td>Heidenheim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>365 AG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aachener Straße 1253</td>\n",
       "      <td>50858</td>\n",
       "      <td>Köln</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A&amp;A Stromallianz Solutions GmbH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zehdenicker Str. 19</td>\n",
       "      <td>10119</td>\n",
       "      <td>Berlin</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          Firmenname Anmerkung zur Lieferantentätigkeit  \\\n",
       "0                    1&1 Energy GmbH                                NaN   \n",
       "1          17er Oberlandenergie GmbH                                NaN   \n",
       "2  24/7 Energie & Kommunikation GmbH                                NaN   \n",
       "3                             365 AG                                NaN   \n",
       "4    A&A Stromallianz Solutions GmbH                                NaN   \n",
       "\n",
       "         Firmenanschrift    PLZ   Firmenort  \n",
       "0  Elgendorfer Straße 57  56410   Montabaur  \n",
       "1       Viehmarktplatz 1  82418      Murnau  \n",
       "2        Meeboldstraße 1  89522  Heidenheim  \n",
       "3   Aachener Straße 1253  50858        Köln  \n",
       "4    Zehdenicker Str. 19  10119      Berlin  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"cleaned_data/StromVersorgerListe_Bundesnetzagentur-cleaned-2019-08-07.csv\")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "len(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Verivox\n",
    "\n",
    "- Datenquelle: [Liste aller berücksichtigten Stromanbieter](https://www.verivox.de/power/carriers.aspx?fl=all)\n",
    "- Als PDF gespeichert, mit Tabula gescrapt am 7.8.2019, mit Open Refine gesäubert\n",
    "- [Rohdatensatz](raw_data/verivox-alle-anbieter-scraped-2019-08-07.csv)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1147\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123energie - eine Marke der Pfalzwerke AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>17er Oberlandenergie GmbH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>24/7 Energie und Kommunikation GmbH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4hundred GmbH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Abens-Donau Energie GmbH</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        name\n",
       "0  123energie - eine Marke der Pfalzwerke AG\n",
       "1                  17er Oberlandenergie GmbH\n",
       "2        24/7 Energie und Kommunikation GmbH\n",
       "3                              4hundred GmbH\n",
       "4                   Abens-Donau Energie GmbH"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"cleaned_data/verivox-alle-anbieter-cleaned-2019-08-19.csv\")\n",
    "print(len(df))\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Check24\n",
    "\n",
    "- Datenquelle: [Liste aller berücksichtigten Stromanbieter](https://www.check24.de/strom-gas/energieanbieter/?f_type=chip&f_prop=listed&f_value=yes)\n",
    "- Als PDF gespeichert, mit Tabula gescrapt, mit Open Refine gesäubert, 7.8.2019\n",
    "- [Rohdatensatz](\"raw_data/check24-alle-anbieter-scaped-2019-08-07.csv\"), musste nicht bearbeitet werden"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1075\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17er Oberlandenergie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>24/7 Energie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Abens-Donau Energie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Abita</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AggerEnergie</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   name\n",
       "0  17er Oberlandenergie\n",
       "1          24/7 Energie\n",
       "2   Abens-Donau Energie\n",
       "3                 Abita\n",
       "4          AggerEnergie"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"raw_data/check24-alle-anbieter-scaped-2019-08-07.csv\")\n",
    "print(len(df))\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Listen mit Ökostromanbietern\n",
    "\n",
    "Manche Listen benennen explizit Ökostrom(tarif|produkt)anbieter. Obwohl hier unterschiedliche Definitionen anfallen, sind das unsere ersten Einschränkungen.\n",
    "\n",
    "### Stromauskunft.de\n",
    "- Datenquelle: [Liste der Ökostromanbieter](https://www.stromauskunft.de/oekostrom/oekostrom-anbieter/)\n",
    "- Als PDF gespeichert, mit Tabula gescrapt am 8.8.2019, in Open Refine gesäubert\n",
    "- [Rohdatensatz](\"raw_data/stromauskunftde-oekostrom-scraped-2019-08-08.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "715\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Stromanbieter</th>\n",
       "      <th>Adresse 1</th>\n",
       "      <th>PLZ</th>\n",
       "      <th>Stadt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>RheinEnergie AG</td>\n",
       "      <td>Parkgürtel 24</td>\n",
       "      <td>50823</td>\n",
       "      <td>Köln</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>WSW Energie &amp; Wasser AG</td>\n",
       "      <td>Bromberger Str. 39 - 41</td>\n",
       "      <td>42281</td>\n",
       "      <td>Wuppertal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>enercity AG</td>\n",
       "      <td>Ihmeplatz 2</td>\n",
       "      <td>30449</td>\n",
       "      <td>Hannover</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Elektrizitätswerke Schönau Vertriebs GmbH</td>\n",
       "      <td>Friedrichstraße 53/55</td>\n",
       "      <td>79677</td>\n",
       "      <td>Schönau/Schw.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Stadtwerke Leipzig GmbH</td>\n",
       "      <td>Eutritzscher Str. 17-19</td>\n",
       "      <td>04105</td>\n",
       "      <td>Leipzig</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               Stromanbieter                Adresse 1    PLZ  \\\n",
       "0                            RheinEnergie AG            Parkgürtel 24  50823   \n",
       "1                    WSW Energie & Wasser AG  Bromberger Str. 39 - 41  42281   \n",
       "2                                enercity AG              Ihmeplatz 2  30449   \n",
       "3  Elektrizitätswerke Schönau Vertriebs GmbH    Friedrichstraße 53/55  79677   \n",
       "4                    Stadtwerke Leipzig GmbH  Eutritzscher Str. 17-19  04105   \n",
       "\n",
       "           Stadt  \n",
       "0           Köln  \n",
       "1      Wuppertal  \n",
       "2       Hannover  \n",
       "3  Schönau/Schw.  \n",
       "4        Leipzig  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"cleaned_data/Stromauskunftde-oekostrom-cleaned-2019-08-08.csv\")\n",
    "print(len(df))\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- Stromauskunft führt neben der Ökostromtarifliste auch eine Liste \"echter\" Ökostromanbieter\n",
    "- Datenquelle: [Liste echter Ökostromanbieter](https://www.stromauskunft.de/oekostrom/echter-oekostrom/)\n",
    "- Als PDF gespeichert, mit Tabula gescrapt am 8.8.2019, in Open Refine gesäubert"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "18\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Anbieter</th>\n",
       "      <th>Label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Baywa</td>\n",
       "      <td>Ok-Power</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bürgerinitiative Umweltschutz</td>\n",
       "      <td>Grüner Strom Gold</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bürgerwerke</td>\n",
       "      <td>Grüner Strom Gold</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Heidelberger Solidarstromer</td>\n",
       "      <td>EcoTopTen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ökostromer Edingen-Neckarhausen</td>\n",
       "      <td>EcoTopTen</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Anbieter              Label\n",
       "0                             Baywa           Ok-Power\n",
       "1     Bürgerinitiative Umweltschutz  Grüner Strom Gold\n",
       "2                       Bürgerwerke  Grüner Strom Gold\n",
       "3       Heidelberger Solidarstromer          EcoTopTen\n",
       "4  Ökostromer Edingen-Neckarhausen           EcoTopTen"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"cleaned_data/stromauskunftde-reine-oekostrom-cleaned-2019-08-06.csv\")\n",
    "print(len(df))\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### EcoTopTen\n",
    "- Datenquelle: [Liste der verglichenen Ökostromanbieter](https://www.ecotopten.de/oekostromtarife/xls?attach=panel_pane_5)\n",
    "- Download als [XLS](raw_data/ecotopten_oekostrom_download-2019-08-12.xls), converted to CSV, in Open Refine gesäubert"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "30\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Hersteller</th>\n",
       "      <th>Modell</th>\n",
       "      <th>Tarifbeispiel</th>\n",
       "      <th>Varianz Tarif</th>\n",
       "      <th>Mindestvertragslaufzeit (Monate)</th>\n",
       "      <th>Kündigungsfrist (Wochen)</th>\n",
       "      <th>Preisgarantie bis</th>\n",
       "      <th>Zertifikat</th>\n",
       "      <th>Stromquellen</th>\n",
       "      <th>Grundpreis (€/Monat)</th>\n",
       "      <th>...</th>\n",
       "      <th>Column 119</th>\n",
       "      <th>Column 120</th>\n",
       "      <th>Column 121</th>\n",
       "      <th>Column 122</th>\n",
       "      <th>Column 123</th>\n",
       "      <th>Column 124</th>\n",
       "      <th>Column 125</th>\n",
       "      <th>Column 126</th>\n",
       "      <th>Column 127</th>\n",
       "      <th>Column 128</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123energie</td>\n",
       "      <td>123ökostrom Premium</td>\n",
       "      <td>Ludwigshafen</td>\n",
       "      <td>PLZ-abhängig</td>\n",
       "      <td>12.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2 Jahre</td>\n",
       "      <td>OK-Power-Label</td>\n",
       "      <td>100%REG</td>\n",
       "      <td>10,71</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BayWa Ökoenergie GmbH</td>\n",
       "      <td>BayWa Ökostrom 12 /24</td>\n",
       "      <td>Ludwigshafen</td>\n",
       "      <td>PLZ-abhängig</td>\n",
       "      <td>12 bzw. 24, danach monatlich kündbar</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12 Monate / 24 Monate</td>\n",
       "      <td>OK-Power-Label PLUS</td>\n",
       "      <td>100%REG</td>\n",
       "      <td>8,73</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BayWa r.e. Green Energy Products GmbH</td>\n",
       "      <td>BayWa r.e.mix flow</td>\n",
       "      <td>Ludwigshafen</td>\n",
       "      <td>PLZ-abhängig</td>\n",
       "      <td>12.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1 Jahr</td>\n",
       "      <td>OK-Power-Label PLUS</td>\n",
       "      <td>100%REG</td>\n",
       "      <td>8,73</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BS ENERGY Braunschweiger Versorgungs-AG &amp; Co. KG</td>\n",
       "      <td>BS|Naturstrom Gold</td>\n",
       "      <td>Köln</td>\n",
       "      <td>PLZ-abhängig</td>\n",
       "      <td>12.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>_</td>\n",
       "      <td>Grüner Strom Label</td>\n",
       "      <td>100% REG</td>\n",
       "      <td>6,50</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bürgerinitiative Umweltschutz e.V.</td>\n",
       "      <td>Naturstrom ÖkostromPool</td>\n",
       "      <td>bundesweit</td>\n",
       "      <td>bundesweit einheitlich</td>\n",
       "      <td>keine</td>\n",
       "      <td>4.0</td>\n",
       "      <td>bis 31.12.2018</td>\n",
       "      <td>Grüner Strom Label</td>\n",
       "      <td>100% REG</td>\n",
       "      <td>8,90</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 128 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         Hersteller                   Modell  \\\n",
       "0                                        123energie      123ökostrom Premium   \n",
       "1                             BayWa Ökoenergie GmbH    BayWa Ökostrom 12 /24   \n",
       "2             BayWa r.e. Green Energy Products GmbH       BayWa r.e.mix flow   \n",
       "3  BS ENERGY Braunschweiger Versorgungs-AG & Co. KG       BS|Naturstrom Gold   \n",
       "4                Bürgerinitiative Umweltschutz e.V.  Naturstrom ÖkostromPool   \n",
       "\n",
       "  Tarifbeispiel           Varianz Tarif      Mindestvertragslaufzeit (Monate)  \\\n",
       "0  Ludwigshafen            PLZ-abhängig                                  12.0   \n",
       "1  Ludwigshafen            PLZ-abhängig  12 bzw. 24, danach monatlich kündbar   \n",
       "2  Ludwigshafen            PLZ-abhängig                                  12.0   \n",
       "3          Köln            PLZ-abhängig                                  12.0   \n",
       "4    bundesweit  bundesweit einheitlich                                 keine   \n",
       "\n",
       "   Kündigungsfrist (Wochen)      Preisgarantie bis           Zertifikat  \\\n",
       "0                       6.0                2 Jahre       OK-Power-Label   \n",
       "1                       4.0  12 Monate / 24 Monate  OK-Power-Label PLUS   \n",
       "2                       4.0                 1 Jahr  OK-Power-Label PLUS   \n",
       "3                       4.0                      _   Grüner Strom Label   \n",
       "4                       4.0         bis 31.12.2018   Grüner Strom Label   \n",
       "\n",
       "  Stromquellen Grundpreis (€/Monat)     ...     Column 119  Column 120  \\\n",
       "0      100%REG                10,71     ...            NaN         NaN   \n",
       "1      100%REG                 8,73     ...            NaN         NaN   \n",
       "2      100%REG                 8,73     ...            NaN         NaN   \n",
       "3     100% REG                 6,50     ...            NaN         NaN   \n",
       "4     100% REG                 8,90     ...            NaN         NaN   \n",
       "\n",
       "  Column 121  Column 122  Column 123  Column 124  Column 125  Column 126  \\\n",
       "0        NaN         NaN         NaN         NaN         NaN         NaN   \n",
       "1        NaN         NaN         NaN         NaN         NaN         NaN   \n",
       "2        NaN         NaN         NaN         NaN         NaN         NaN   \n",
       "3        NaN         NaN         NaN         NaN         NaN         NaN   \n",
       "4        NaN         NaN         NaN         NaN         NaN         NaN   \n",
       "\n",
       "   Column 127  Column 128  \n",
       "0         NaN         NaN  \n",
       "1         NaN         NaN  \n",
       "2         NaN         NaN  \n",
       "3         NaN         NaN  \n",
       "4         NaN         NaN  \n",
       "\n",
       "[5 rows x 128 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"cleaned_data/ecotopten_oekostrom_cleaned-2019-08-19.csv\")\n",
    "print(len(df))\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Ökotest \n",
    "- Datenquelle: [Liste der getesteten Ökostromanbieter](https://www.oekotest.de/bauen-wohnen/Oeko-Strom-im-Test-Das-sind-die-besten-Anbieter_111510_1.html)\n",
    "- Stand 12.12.2018\n",
    "- mit [Pythonscript](scripts/scraper-oekotest.py) von der Website gescrapt\n",
    "- [Rohdatensatz](\"raw_data/oekotest-strom-scraped-2019-08-12.tsv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "34\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Anbieter</th>\n",
       "      <th>Produkt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Pfalzwerke</td>\n",
       "      <td>123 Ökostrom Premium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BayWa Ökoenergie</td>\n",
       "      <td>BayWa Ökostrom 12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Solidarische Ökonomie Bremen</td>\n",
       "      <td>Bremer SolidarStrom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BS-Energy - Braunschweiger Versorgungsgesellsc...</td>\n",
       "      <td>BS Naturstrom Gold</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bürgerwerke</td>\n",
       "      <td>Bürgerstrom</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            Anbieter               Produkt\n",
       "0                                         Pfalzwerke  123 Ökostrom Premium\n",
       "1                                   BayWa Ökoenergie     BayWa Ökostrom 12\n",
       "2                       Solidarische Ökonomie Bremen   Bremer SolidarStrom\n",
       "3  BS-Energy - Braunschweiger Versorgungsgesellsc...    BS Naturstrom Gold\n",
       "4                                        Bürgerwerke           Bürgerstrom"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"cleaned_data/oekotest-strom-cleaned-2019-08-19.csv\")\n",
    "print(len(df))\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Utopia.de\n",
    "- Datenquelle: [Bestenliste](https://utopia.de/bestenlisten/die-besten-oekostrom-anbieter/)\n",
    "- Stand 09.07.2019\n",
    "- als PDF gespeichert, mit Tabula gescrapt, mit Open Refine gesäubert\n",
    "- [Rohdatensatz](\"raw_data/utopia-bestenliste.de.ods\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "16\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Siegel/Empfehlungen*</th>\n",
       "      <th>Column 8</th>\n",
       "      <th>Column 9</th>\n",
       "      <th>Column 10</th>\n",
       "      <th>Column 11</th>\n",
       "      <th>Column 12</th>\n",
       "      <th>Column 13</th>\n",
       "      <th>Column 14</th>\n",
       "      <th>Column 15</th>\n",
       "      <th>Column 16</th>\n",
       "      <th>Column 17</th>\n",
       "      <th>Column 18</th>\n",
       "      <th>Column 19</th>\n",
       "      <th>Column 20</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BayWa Ökoenergie</td>\n",
       "      <td>EcoTopTen, Grüner Strom, ok power plus, Öko-Test</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bremer SolidarStrom</td>\n",
       "      <td>EcoTopTen, TÜV Nord, Öko-Test</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Die Bürgerwerke</td>\n",
       "      <td>EcoTopTen, Grüner Strom, TÜV Nord, Utopia, Öko...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Entega</td>\n",
       "      <td>EcoTopTen, ok power, TÜV Nord</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Enspire</td>\n",
       "      <td>EcoTopTen, Grüner Storm, Öko-Test</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Name                               Siegel/Empfehlungen*  \\\n",
       "0     BayWa Ökoenergie   EcoTopTen, Grüner Strom, ok power plus, Öko-Test   \n",
       "1  Bremer SolidarStrom                      EcoTopTen, TÜV Nord, Öko-Test   \n",
       "2      Die Bürgerwerke  EcoTopTen, Grüner Strom, TÜV Nord, Utopia, Öko...   \n",
       "3               Entega                      EcoTopTen, ok power, TÜV Nord   \n",
       "4              Enspire                  EcoTopTen, Grüner Storm, Öko-Test   \n",
       "\n",
       "   Column 8  Column 9  Column 10  Column 11  Column 12  Column 13  Column 14  \\\n",
       "0       NaN       NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "1       NaN       NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "2       NaN       NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "3       NaN       NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "4       NaN       NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "\n",
       "   Column 15  Column 16  Column 17  Column 18  Column 19  Column 20  \n",
       "0        NaN        NaN        NaN        NaN        NaN        NaN  \n",
       "1        NaN        NaN        NaN        NaN        NaN        NaN  \n",
       "2        NaN        NaN        NaN        NaN        NaN        NaN  \n",
       "3        NaN        NaN        NaN        NaN        NaN        NaN  \n",
       "4        NaN        NaN        NaN        NaN        NaN        NaN  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"cleaned_data/utopia-bestenliste-cleaned-2019-08-19.csv\")\n",
    "print(len(df))\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Ökostromlabel\n",
    "\n",
    "Für viele andere Übersichten und Listen bilden die Ökostromlabels selbst eine wichtige Grundlage.\n",
    "\n",
    "### OK Power\n",
    "\n",
    "- Datenquelle: [Liste OK Power Anbieterübersicht](https://www.ok-power.de/fuer-strom-kunden/anbieter-uebersicht.html)\n",
    "- Mit [Pythonscript](scripts/scraper-okpower.py) gescrapt, mit Open Refine gesäubert 30.07.2019\n",
    "- [Rohdatensatz](\"raw_data/okpower-label-scraped-2019-07-30.tsv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "75\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Anbieter</th>\n",
       "      <th>Tarif</th>\n",
       "      <th>Adresse</th>\n",
       "      <th>Telefon</th>\n",
       "      <th>Website</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Albwerk GmbH &amp; Co. KG</td>\n",
       "      <td>AlblineAqua</td>\n",
       "      <td>Eybstraße 98-102 - 73312 Geislingen</td>\n",
       "      <td>Tel. 07331 / 209-600</td>\n",
       "      <td>www.albwerk.de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ASEW Energie und Umwelt Service GmbH &amp; Co. KG</td>\n",
       "      <td>watergreen+</td>\n",
       "      <td>Eupener Str. 74 - 50933 Köln</td>\n",
       "      <td>Tel. 0221 / 931819-18</td>\n",
       "      <td>www.asew.de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AVIA AG</td>\n",
       "      <td>AVIA Strom Öko</td>\n",
       "      <td>Grillparzerstr. 8 - 81675 München</td>\n",
       "      <td>Tel. 089 / 455045–0</td>\n",
       "      <td>www.avia.de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AVU Aktiengesellschaft für Versorgungs-Unterne...</td>\n",
       "      <td>Grünstrom</td>\n",
       "      <td>An der Drehbank 18 - 58285 Gevelsberg</td>\n",
       "      <td>Tel. 02332 / 73605</td>\n",
       "      <td>www.avu.de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>badenova AG &amp; Co. KG</td>\n",
       "      <td>business öko (100/plus)</td>\n",
       "      <td>Tullastr. 61 - 79108 Freiburg</td>\n",
       "      <td>Tel. 08002 / 83 84 85</td>\n",
       "      <td>www.badenova.de</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            Anbieter                    Tarif  \\\n",
       "0                              Albwerk GmbH & Co. KG              AlblineAqua   \n",
       "1      ASEW Energie und Umwelt Service GmbH & Co. KG              watergreen+   \n",
       "2                                            AVIA AG           AVIA Strom Öko   \n",
       "3  AVU Aktiengesellschaft für Versorgungs-Unterne...                Grünstrom   \n",
       "4                               badenova AG & Co. KG  business öko (100/plus)   \n",
       "\n",
       "                                 Adresse                Telefon  \\\n",
       "0    Eybstraße 98-102 - 73312 Geislingen   Tel. 07331 / 209-600   \n",
       "1           Eupener Str. 74 - 50933 Köln  Tel. 0221 / 931819-18   \n",
       "2      Grillparzerstr. 8 - 81675 München    Tel. 089 / 455045–0   \n",
       "3  An der Drehbank 18 - 58285 Gevelsberg     Tel. 02332 / 73605   \n",
       "4          Tullastr. 61 - 79108 Freiburg  Tel. 08002 / 83 84 85   \n",
       "\n",
       "           Website  \n",
       "0   www.albwerk.de  \n",
       "1      www.asew.de  \n",
       "2      www.avia.de  \n",
       "3       www.avu.de  \n",
       "4  www.badenova.de  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"cleaned_data/okpower-cleaned-2019-07-30.csv\")\n",
    "print(len(df))\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Grüner Strom\n",
    "- Datenquelle: []()\n",
    "- Mit [Pythonscript](scripts/scraper-gruenstrom.py) gescrapt, mit Open Refine gesäubert 30.07.2019\n",
    "- [Rohdatensatz](\"raw_data/gruenstrom-scraped-2019-07-30.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Anbieter</th>\n",
       "      <th>Tarif</th>\n",
       "      <th>Verfügbarkeit</th>\n",
       "      <th>Telefon</th>\n",
       "      <th>Website</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Agger Energie GmbH</td>\n",
       "      <td>AggerStrom NATUR AggerStrom REGIO natur</td>\n",
       "      <td>regional</td>\n",
       "      <td>02261 30030</td>\n",
       "      <td>www.aggerenergie.de/de/privatkunden/strom.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BS|ENERGY Braunschweiger Versorgungs-AG &amp; Co.KG</td>\n",
       "      <td>BS|Naturstrom Gold</td>\n",
       "      <td>bundesweit</td>\n",
       "      <td>0531 3830</td>\n",
       "      <td>www.bs-energy.de/privatkunden/produkte/strom/b...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bürgerwerke eG</td>\n",
       "      <td>Bürgerstrom</td>\n",
       "      <td>bundesweit</td>\n",
       "      <td>06221 3928920</td>\n",
       "      <td>https://buergerwerke.de/strom-beziehen/unser-s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Elektrizitätsgenossenschaft Dirmstein eG</td>\n",
       "      <td>strom fix natur / strom fix natur plus</td>\n",
       "      <td>regional</td>\n",
       "      <td>06233 6020</td>\n",
       "      <td>www.egdirmstein.de/strom/naturstrom.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Elektrizitätsversorgung Rheinzabern</td>\n",
       "      <td>Naturstrom</td>\n",
       "      <td>regional</td>\n",
       "      <td>07272 750820</td>\n",
       "      <td>www.evu-rheinzabern.de/stromversorgung/vertrae...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          Anbieter  \\\n",
       "0                               Agger Energie GmbH   \n",
       "1  BS|ENERGY Braunschweiger Versorgungs-AG & Co.KG   \n",
       "2                                   Bürgerwerke eG   \n",
       "3         Elektrizitätsgenossenschaft Dirmstein eG   \n",
       "4              Elektrizitätsversorgung Rheinzabern   \n",
       "\n",
       "                                     Tarif Verfügbarkeit        Telefon  \\\n",
       "0  AggerStrom NATUR AggerStrom REGIO natur      regional    02261 30030   \n",
       "1                       BS|Naturstrom Gold    bundesweit      0531 3830   \n",
       "2                              Bürgerstrom    bundesweit  06221 3928920   \n",
       "3   strom fix natur / strom fix natur plus      regional     06233 6020   \n",
       "4                               Naturstrom      regional   07272 750820   \n",
       "\n",
       "                                             Website  \n",
       "0     www.aggerenergie.de/de/privatkunden/strom.html  \n",
       "1  www.bs-energy.de/privatkunden/produkte/strom/b...  \n",
       "2  https://buergerwerke.de/strom-beziehen/unser-s...  \n",
       "3           www.egdirmstein.de/strom/naturstrom.html  \n",
       "4  www.evu-rheinzabern.de/stromversorgung/vertrae...  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"cleaned_data/gruenstrom-cleaned-2019-07-30.csv\")\n",
    "print(len(df))\n",
    "df.head()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}