liste-komplett.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import time"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Komplette Liste\n",
    "Zuerst füllen wir die Anbieter aus, die keine 100%-gen Ökostromanbieter sind. \n",
    "Diese scheitern bereits an RoWo Kiterium A. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "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>RoWo Liste</th>\n",
       "      <th>Erneuerbare Energien 2</th>\n",
       "      <th>RoWo-Kriterien</th>\n",
       "      <th>A</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123energie - Eine Marke der Pfalzwerke AG</td>\n",
       "      <td>True</td>\n",
       "      <td>5.80%</td>\n",
       "      <td>A</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>17er Oberlandenergie GmbH</td>\n",
       "      <td>True</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>24/7 Energie und Kommunikation GmbH</td>\n",
       "      <td>True</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>A</td>\n",
       "      <td>x</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4hundred GmbH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Abens-Donau Energie GmbH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.21%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Firmenname RoWo Liste  \\\n",
       "0  123energie - Eine Marke der Pfalzwerke AG       True   \n",
       "1                  17er Oberlandenergie GmbH       True   \n",
       "2        24/7 Energie und Kommunikation GmbH       True   \n",
       "3                              4hundred GmbH        NaN   \n",
       "4                   Abens-Donau Energie GmbH        NaN   \n",
       "\n",
       "  Erneuerbare Energien 2 RoWo-Kriterien    A  \n",
       "0                  5.80%              A  NaN  \n",
       "1                  0.00%              D  NaN  \n",
       "2                  0.00%              A    x  \n",
       "3                100.00%            NaN  NaN  \n",
       "4                  0.21%            NaN  NaN  "
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged = pd.read_csv(\"lichtblick/Lichtblick-RoWo-merged-20190826-cleaned.csv\")\n",
    "merged[['Firmenname', 'RoWo Liste', 'Erneuerbare Energien 2','RoWo-Kriterien', 'A']].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "570\n",
      "49\n"
     ]
    }
   ],
   "source": [
    "print(len(merged.loc[merged['RoWo-Kriterien'] == 'A']))\n",
    "\n",
    "merged.loc[merged['Erneuerbare Energien 2'] != \"100.00%\", 'RoWo-Kriterien'] = 'A'\n",
    "merged.loc[merged['Erneuerbare Energien 2'] != \"100.00%\", 'A'] = 'x'\n",
    "merged.loc[merged['Erneuerbare Energien 2'] != \"100.00%\", 'RoWo Liste'] = True\n",
    "\n",
    "print(len(merged.loc[merged['RoWo Liste'] != True]))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Dann wird germergt!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1171, 38)\n",
      "(1202, 15)\n",
      "(1278, 52)\n",
      "Write to csv\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>Lichtblick Liste</th>\n",
       "      <th>RoWo Liste</th>\n",
       "      <th>Firmenname</th>\n",
       "      <th>Stromkennzeichnung Atom</th>\n",
       "      <th>Kohle</th>\n",
       "      <th>Erdgas</th>\n",
       "      <th>sonst. Fossil</th>\n",
       "      <th>EEG Strom</th>\n",
       "      <th>Erneuerbare Energien</th>\n",
       "      <th>Check</th>\n",
       "      <th>...</th>\n",
       "      <th>Ökotest</th>\n",
       "      <th>EcoTopTen</th>\n",
       "      <th>Utopia</th>\n",
       "      <th>Stromauskunft echter Oekostrom</th>\n",
       "      <th>Telefon</th>\n",
       "      <th>Website</th>\n",
       "      <th>Verfügbarkeit</th>\n",
       "      <th>Firmenanschrift</th>\n",
       "      <th>PLZ_y</th>\n",
       "      <th>Firmenort</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>123energie - Eine Marke der Pfalzwerke AG</td>\n",
       "      <td>12.00%</td>\n",
       "      <td>41.00%</td>\n",
       "      <td>11.00%</td>\n",
       "      <td>1.00%</td>\n",
       "      <td>31.00%</td>\n",
       "      <td>4.00%</td>\n",
       "      <td>100.00%</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>True</td>\n",
       "      <td>True</td>\n",
       "      <td>17er Oberlandenergie GmbH</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>0.00%</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>Viehmarktplatz 1</td>\n",
       "      <td>82418</td>\n",
       "      <td>Murnau am Staffelsee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>24/7 Energie und Kommunikation GmbH</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>0.00%</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>Meeboldstraße 1</td>\n",
       "      <td>89522</td>\n",
       "      <td>Heidenheim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4hundred GmbH</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>47.00%</td>\n",
       "      <td>53.00%</td>\n",
       "      <td>100.00%</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>True</td>\n",
       "      <td>True</td>\n",
       "      <td>Abens-Donau Energie GmbH</td>\n",
       "      <td>10.70%</td>\n",
       "      <td>27.20%</td>\n",
       "      <td>7.80%</td>\n",
       "      <td>1.30%</td>\n",
       "      <td>52.90%</td>\n",
       "      <td>0.10%</td>\n",
       "      <td>100.00%</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 × 52 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Lichtblick Liste RoWo Liste                                 Firmenname  \\\n",
       "0             True       True  123energie - Eine Marke der Pfalzwerke AG   \n",
       "1             True       True                  17er Oberlandenergie GmbH   \n",
       "2             True       True        24/7 Energie und Kommunikation GmbH   \n",
       "3             True        NaN                              4hundred GmbH   \n",
       "4             True       True                   Abens-Donau Energie GmbH   \n",
       "\n",
       "  Stromkennzeichnung Atom   Kohle  Erdgas sonst. Fossil EEG Strom  \\\n",
       "0                  12.00%  41.00%  11.00%         1.00%    31.00%   \n",
       "1                     NaN     NaN     NaN           NaN       NaN   \n",
       "2                     NaN     NaN     NaN           NaN       NaN   \n",
       "3                   0.00%   0.00%   0.00%         0.00%    47.00%   \n",
       "4                  10.70%  27.20%   7.80%         1.30%    52.90%   \n",
       "\n",
       "  Erneuerbare Energien    Check          ...          Ökotest EcoTopTen  \\\n",
       "0                4.00%  100.00%          ...              NaN       NaN   \n",
       "1                  NaN    0.00%          ...              NaN       NaN   \n",
       "2                  NaN    0.00%          ...              NaN       NaN   \n",
       "3               53.00%  100.00%          ...              NaN       NaN   \n",
       "4                0.10%  100.00%          ...              NaN       NaN   \n",
       "\n",
       "  Utopia Stromauskunft echter Oekostrom Telefon Website Verfügbarkeit  \\\n",
       "0    NaN                            NaN     NaN     NaN           NaN   \n",
       "1    NaN                            NaN     NaN     NaN           NaN   \n",
       "2    NaN                            NaN     NaN     NaN           NaN   \n",
       "3    NaN                            NaN     NaN     NaN           NaN   \n",
       "4    NaN                            NaN     NaN     NaN           NaN   \n",
       "\n",
       "    Firmenanschrift  PLZ_y             Firmenort  \n",
       "0               NaN    NaN                   NaN  \n",
       "1  Viehmarktplatz 1  82418  Murnau am Staffelsee  \n",
       "2   Meeboldstraße 1  89522            Heidenheim  \n",
       "3               NaN    NaN                   NaN  \n",
       "4               NaN    NaN                   NaN  \n",
       "\n",
       "[5 rows x 52 columns]"
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "oeko_list = pd.read_csv(\"merged_data/oeko_list_large-20190826-cleaned.csv\")\n",
    "oeko_list\n",
    "\n",
    "list_ = pd.merge(merged,\n",
    "               oeko_list,\n",
    "               on=\"Firmenname\",\n",
    "               how=\"outer\")\n",
    "\n",
    "print(merged.shape)\n",
    "print(oeko_list.shape)\n",
    "print(list_.shape)\n",
    "\n",
    "print(\"Write to csv\")\n",
    "list_.to_csv(\"liste-komplett-{}.csv\".format(time.strftime(\"%Y%m%d-%H%M%S\")))\n",
    "\n",
    "list_.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Jetzt haben wir wirklich alles zusammen!\n",
    "Noch einmal in Open Refine checken, ob noch Doppelungen drin sind und dann, fertig."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1218, 32)\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>Lichtblick Liste</th>\n",
       "      <th>RoWo Liste</th>\n",
       "      <th>Andere Liste</th>\n",
       "      <th>Firmenname</th>\n",
       "      <th>Erneuerbare Energien 2</th>\n",
       "      <th>Kennzeichnung Link</th>\n",
       "      <th>Anmerkungen</th>\n",
       "      <th>Adresse</th>\n",
       "      <th>PLZ</th>\n",
       "      <th>Stadt</th>\n",
       "      <th>...</th>\n",
       "      <th>Bemerkung</th>\n",
       "      <th>Grüner Strom</th>\n",
       "      <th>OK Power</th>\n",
       "      <th>Stromauskunft</th>\n",
       "      <th>Verivox</th>\n",
       "      <th>Ökotest</th>\n",
       "      <th>EcoTopTen</th>\n",
       "      <th>Utopia</th>\n",
       "      <th>Stromauskunft echter Oekostrom</th>\n",
       "      <th>Telefon</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>123energie - Eine Marke der Pfalzwerke AG</td>\n",
       "      <td>5.80%</td>\n",
       "      <td>https://www.123energie.de/service/462.php</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kurfürstenstraße 29</td>\n",
       "      <td>67061</td>\n",
       "      <td>Ludwigshafen</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0621 570573123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17er Oberlandenergie GmbH</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>https://17er.com/die-17er/service/stromkennzei...</td>\n",
       "      <td>nicht vorhanden</td>\n",
       "      <td>Viehmarktplatz 1</td>\n",
       "      <td>82418</td>\n",
       "      <td>Murnau am Staffelsee</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>True</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>True</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24/7 Energie und Kommunikation GmbH</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>https://www.elissa.de/produkte-elissa/elissa-s...</td>\n",
       "      <td>nicht aktuell</td>\n",
       "      <td>Meeboldstraße 1</td>\n",
       "      <td>89522</td>\n",
       "      <td>Heidenheim</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>True</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>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4hundred GmbH</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>https://www.4hundred.com/stromkennzeichnung/</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</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>True</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abens-Donau Energie GmbH</td>\n",
       "      <td>0.21%</td>\n",
       "      <td>https://www.abens-donau-energie.de/strom-fuer-...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</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 × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Lichtblick Liste RoWo Liste Andere Liste  \\\n",
       "0             True       True          NaN   \n",
       "1             True       True          NaN   \n",
       "2             True       True          NaN   \n",
       "3             True        NaN          NaN   \n",
       "4             True       True          NaN   \n",
       "\n",
       "                                  Firmenname Erneuerbare Energien 2  \\\n",
       "0  123energie - Eine Marke der Pfalzwerke AG                  5.80%   \n",
       "1                  17er Oberlandenergie GmbH                  0.00%   \n",
       "2        24/7 Energie und Kommunikation GmbH                  0.00%   \n",
       "3                              4hundred GmbH                100.00%   \n",
       "4                   Abens-Donau Energie GmbH                  0.21%   \n",
       "\n",
       "                                  Kennzeichnung Link      Anmerkungen  \\\n",
       "0          https://www.123energie.de/service/462.php              NaN   \n",
       "1  https://17er.com/die-17er/service/stromkennzei...  nicht vorhanden   \n",
       "2  https://www.elissa.de/produkte-elissa/elissa-s...    nicht aktuell   \n",
       "3       https://www.4hundred.com/stromkennzeichnung/              NaN   \n",
       "4  https://www.abens-donau-energie.de/strom-fuer-...              NaN   \n",
       "\n",
       "               Adresse    PLZ                 Stadt       ...       Bemerkung  \\\n",
       "0  Kurfürstenstraße 29  67061          Ludwigshafen       ...             NaN   \n",
       "1     Viehmarktplatz 1  82418  Murnau am Staffelsee       ...             NaN   \n",
       "2      Meeboldstraße 1  89522            Heidenheim       ...             NaN   \n",
       "3                  NaN    NaN                   NaN       ...             NaN   \n",
       "4                  NaN    NaN                   NaN       ...             NaN   \n",
       "\n",
       "  Grüner Strom OK Power Stromauskunft Verivox Ökotest EcoTopTen Utopia  \\\n",
       "0          NaN     True          True    True    True      True    NaN   \n",
       "1          NaN      NaN          True    True     NaN       NaN    NaN   \n",
       "2          NaN      NaN          True    True     NaN       NaN    NaN   \n",
       "3          NaN      NaN           NaN    True     NaN       NaN    NaN   \n",
       "4          NaN      NaN           NaN    True     NaN       NaN    NaN   \n",
       "\n",
       "   Stromauskunft echter Oekostrom         Telefon  \n",
       "0                             NaN  0621 570573123  \n",
       "1                             NaN             NaN  \n",
       "2                             NaN             NaN  \n",
       "3                             NaN             NaN  \n",
       "4                             NaN             NaN  \n",
       "\n",
       "[5 rows x 32 columns]"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "complete = pd.read_csv(\"liste-komplett-20190827-cleaned.csv\")\n",
    "print(complete.shape)\n",
    "complete.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
}