03_02_zutaten_analysis_cloud.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# [Chefkoch.de](http://www.chefkoch.de/) Maturaarbeit 2017/18\n",
    "------\n",
    "\n",
    "## Ziel: \n",
    "### Kurze Analyse der Zutaten von 316'755 Rezepten mit dem [APRIORI](https://en.wikipedia.org/wiki/Apriori_algorithm) Algorithmus (Teil 3.1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: mlxtend in /usr/local/lib/python3.5/dist-packages\n",
      "Requirement already satisfied: matplotlib>=1.5.1 in /usr/local/lib/python3.5/dist-packages (from mlxtend)\n",
      "Requirement already satisfied: numpy>=1.10.4 in /usr/local/lib/python3.5/dist-packages (from mlxtend)\n",
      "Requirement already satisfied: setuptools in /usr/local/lib/python3.5/dist-packages (from mlxtend)\n",
      "Requirement already satisfied: pandas>=0.17.1 in /usr/local/lib/python3.5/dist-packages (from mlxtend)\n",
      "Requirement already satisfied: scipy>=0.17 in /usr/local/lib/python3.5/dist-packages (from mlxtend)\n",
      "Requirement already satisfied: scikit-learn>=0.18 in /usr/local/lib/python3.5/dist-packages (from mlxtend)\n",
      "Requirement already satisfied: six>=1.10 in /usr/local/lib/python3.5/dist-packages (from matplotlib>=1.5.1->mlxtend)\n",
      "Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.1 in /usr/local/lib/python3.5/dist-packages (from matplotlib>=1.5.1->mlxtend)\n",
      "Requirement already satisfied: python-dateutil>=2.0 in /usr/local/lib/python3.5/dist-packages (from matplotlib>=1.5.1->mlxtend)\n",
      "Requirement already satisfied: cycler>=0.10 in /usr/local/lib/python3.5/dist-packages (from matplotlib>=1.5.1->mlxtend)\n",
      "Requirement already satisfied: pytz in /usr/local/lib/python3.5/dist-packages (from matplotlib>=1.5.1->mlxtend)\n"
     ]
    }
   ],
   "source": [
    "!pip install mlxtend"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from mlxtend.frequent_patterns import apriori\n",
    "from mlxtend.preprocessing import OnehotTransactions\n",
    "import pandas as pd\n",
    "import csv\n",
    "import re"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Die Zutaten sind in der Datei *recipe_details_merged.csv* gespeichert. Als erstens holt man die Zutaten in eine Liste"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_list_of_ingredients():\n",
    "    recipe_links = []\n",
    "    chef_file = '/input/recipe_details_merged.csv'\n",
    "    with open(chef_file, 'r', encoding='utf-8') as f:\n",
    "        chefkoch = csv.reader(f)\n",
    "        for row in chefkoch:\n",
    "            try:\n",
    "                recipe_links.append(row[-2])\n",
    "            except:\n",
    "                print('MISSED')\n",
    "                continue \n",
    "    return(recipe_links)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "zutaten = []\n",
    "for zutat in get_list_of_ingredients()[1:]:\n",
    "    zzz = zutat.split(',')\n",
    "    z_liste = []\n",
    "    for zz in zzz:\n",
    "        z = zz.split('@')\n",
    "        z_liste.append(z[-1])\n",
    "    zutaten.append(z_liste)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Die Liste *zutaten* hat für jedes Rezept nun eine Liste der Zutaten"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[['Cachaca', 'Zucker', 'Limette', 'Eis'], ['Wodka', 'Gin', 'Rum', 'Rum', 'Likör', 'Likör', 'Ananassaft', 'Grapefruitsaft', 'Zitronensaft', 'Grenadine', 'Guaranapulver', 'Pitahaya', 'Karambolenscheibe', 'Orange'], ['Tofu', 'Batate', 'Palmfett', 'Öl ', 'Zwiebel', 'Knoblauch', 'Tabasco', 'Erdnüsse', 'Zitrone', 'Tomatenmark', 'Sojasauce', 'Rohrzucker', 'Honig', 'Koriander'], ['Basilikum', 'Zitrone', 'Avocado', 'Schmand', 'Sahne', 'Salz und Pfeffer']]\n"
     ]
    }
   ],
   "source": [
    "print(zutaten[:4])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Insgesamt teilen sich alle Rezepte 3'248'846 Zutaten"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3248846\n"
     ]
    }
   ],
   "source": [
    "count = 0\n",
    "for i in zutaten:\n",
    "    count += len(i)\n",
    "print(count)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "seen = set()\n",
    "uniq = []\n",
    "duplicates = []\n",
    "for x in zutaten:\n",
    "    for zutat in x:\n",
    "        if zutat not in seen:\n",
    "            uniq.append(zutat)\n",
    "            seen.add(zutat)\n",
    "        else: duplicates.append(zutat)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Von diesen 3'248'846 Zutaten sind 63'588 verschieden"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "63588\n",
      "3185258\n"
     ]
    }
   ],
   "source": [
    "print(len(uniq))\n",
    "print(len(duplicates))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In der Zutatenliste entfernt man alles ausser Buchstaben"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# remove everything but letters\n",
    "clean_zutaten = []\n",
    "regex = re.compile(r'[^A-Za-zäöüßéàèêëïùâîûç]+', re.IGNORECASE)\n",
    "\n",
    "def get_n_statistic(zutat_name):\n",
    "    count_ = 0\n",
    "    for zutatliste in zutaten:\n",
    "        temp = []\n",
    "        for zutat in zutatliste:\n",
    "            new_name = regex.sub(' ', zutat)\n",
    "            if new_name.strip().lower().startswith(zutat_name):\n",
    "                count_ += 1\n",
    "                seperat = new_name.split(' und ')\n",
    "                temp.append(seperat[0])\n",
    "                temp.append(seperat[1])\n",
    "                continue\n",
    "            if len(new_name) > 1: temp.append(new_name)\n",
    "        clean_zutaten.append(temp)\n",
    "    print('Count von {} ist {}'.format(zutat_name, count_))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Count von salz und pfeffer ist 94786\n"
     ]
    }
   ],
   "source": [
    "get_n_statistic('salz und pfeffer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "316755"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(clean_zutaten)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Der Apriori Algorithmus braucht schlichtwegs zu viel RAM (>20GB) deshalb nehme ich einen zwölftel von allen Zutaten. EDIT: Das Script wurde in der Cloud neu berechnet mit sarker Hardware und 56GB RAM"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "sub_clean_zutaten = clean_zutaten[80000:160000] # 80'000 subset"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Entferne leere Einträge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_clean_zutaten = sorted(sub_clean_zutaten)[:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[[' EL',\n",
       "  'Butter',\n",
       "  'Zwiebel',\n",
       "  'Pilze Waldpilze',\n",
       "  'Kochschinken',\n",
       "  'Sahne',\n",
       "  'Pulver ',\n",
       "  'Salz',\n",
       "  'Pfeffer',\n",
       "  'Petersilie'],\n",
       " [' EL', 'Haferflocken', 'Milch', 'Salz', 'Zucker'],\n",
       " [' EL', 'Honig', 'Wein', 'Kartoffel ', 'Öl', 'Butter', 'Salz', 'Pfeffer'],\n",
       " [' EL',\n",
       " ...]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_clean_zutaten"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Umwandlung der Zutaten in ein one-hot encoded Pandas DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 19min 42s, sys: 6.09 s, total: 19min 48s\n",
      "Wall time: 19min 46s\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "oht = OnehotTransactions()\n",
    "oht_ary = oht.fit(all_clean_zutaten).transform(all_clean_zutaten)\n",
    "df = pd.DataFrame(oht_ary, columns=oht.columns_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>Aal</th>\n",
       "      <th>Aal</th>\n",
       "      <th>Aal Filet</th>\n",
       "      <th>Aal oder Räucherforelle</th>\n",
       "      <th>Aceto balsamico</th>\n",
       "      <th>Aceto balsamico</th>\n",
       "      <th>Aceto balsamico bianco</th>\n",
       "      <th>Aceto balsamico di Modena</th>\n",
       "      <th>Aceto balsamico oder Balsamico rosso</th>\n",
       "      <th>Aceto balsamico oder Granatapfel bzw Himbeeressig</th>\n",
       "      <th>...</th>\n",
       "      <th>Öl zum Frittieren oder Butterschmalz</th>\n",
       "      <th>Öl zum Frittieren oder kg Butterschmalz oder Palmin</th>\n",
       "      <th>Öl zum Grillen</th>\n",
       "      <th>Öl zum Herausbacken</th>\n",
       "      <th>Öl zum Konservieren</th>\n",
       "      <th>Öl zum Marinieren</th>\n",
       "      <th>Öl zum Rösten</th>\n",
       "      <th>Öl zum Würzen</th>\n",
       "      <th>Öl zumFrittieren</th>\n",
       "      <th>Überraschungsei</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 19724 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Aal  Aal   Aal Filet   Aal oder Räucherforelle  Aceto balsamico  \\\n",
       "0    0     0           0                        0                0   \n",
       "1    0     0           0                        0                0   \n",
       "2    0     0           0                        0                0   \n",
       "3    0     0           0                        0                0   \n",
       "4    0     0           0                        0                0   \n",
       "5    0     0           0                        0                0   \n",
       "6    0     0           0                        0                0   \n",
       "7    0     0           0                        0                0   \n",
       "8    0     0           0                        0                0   \n",
       "9    0     0           0                        0                0   \n",
       "\n",
       "   Aceto balsamico   Aceto balsamico bianco  Aceto balsamico di Modena  \\\n",
       "0                 0                       0                          0   \n",
       "1                 0                       0                          0   \n",
       "2                 0                       0                          0   \n",
       "3                 0                       0                          0   \n",
       "4                 0                       0                          0   \n",
       "5                 0                       0                          0   \n",
       "6                 0                       0                          0   \n",
       "7                 0                       0                          0   \n",
       "8                 0                       0                          0   \n",
       "9                 0                       0                          0   \n",
       "\n",
       "   Aceto balsamico oder Balsamico rosso  \\\n",
       "0                                     0   \n",
       "1                                     0   \n",
       "2                                     0   \n",
       "3                                     0   \n",
       "4                                     0   \n",
       "5                                     0   \n",
       "6                                     0   \n",
       "7                                     0   \n",
       "8                                     0   \n",
       "9                                     0   \n",
       "\n",
       "   Aceto balsamico oder Granatapfel bzw Himbeeressig       ...         \\\n",
       "0                                                  0       ...          \n",
       "1                                                  0       ...          \n",
       "2                                                  0       ...          \n",
       "3                                                  0       ...          \n",
       "4                                                  0       ...          \n",
       "5                                                  0       ...          \n",
       "6                                                  0       ...          \n",
       "7                                                  0       ...          \n",
       "8                                                  0       ...          \n",
       "9                                                  0       ...          \n",
       "\n",
       "   Öl zum Frittieren oder Butterschmalz  \\\n",
       "0                                     0   \n",
       "1                                     0   \n",
       "2                                     0   \n",
       "3                                     0   \n",
       "4                                     0   \n",
       "5                                     0   \n",
       "6                                     0   \n",
       "7                                     0   \n",
       "8                                     0   \n",
       "9                                     0   \n",
       "\n",
       "   Öl zum Frittieren oder kg Butterschmalz oder Palmin  Öl zum Grillen  \\\n",
       "0                                                  0                 0   \n",
       "1                                                  0                 0   \n",
       "2                                                  0                 0   \n",
       "3                                                  0                 0   \n",
       "4                                                  0                 0   \n",
       "5                                                  0                 0   \n",
       "6                                                  0                 0   \n",
       "7                                                  0                 0   \n",
       "8                                                  0                 0   \n",
       "9                                                  0                 0   \n",
       "\n",
       "   Öl zum Herausbacken  Öl zum Konservieren  Öl zum Marinieren  Öl zum Rösten  \\\n",
       "0                    0                    0                  0              0   \n",
       "1                    0                    0                  0              0   \n",
       "2                    0                    0                  0              0   \n",
       "3                    0                    0                  0              0   \n",
       "4                    0                    0                  0              0   \n",
       "5                    0                    0                  0              0   \n",
       "6                    0                    0                  0              0   \n",
       "7                    0                    0                  0              0   \n",
       "8                    0                    0                  0              0   \n",
       "9                    0                    0                  0              0   \n",
       "\n",
       "   Öl zum Würzen   Öl zumFrittieren  Überraschungsei  \n",
       "0               0                 0                0  \n",
       "1               0                 0                0  \n",
       "2               0                 0                0  \n",
       "3               0                 0                0  \n",
       "4               0                 0                0  \n",
       "5               0                 0                0  \n",
       "6               0                 0                0  \n",
       "7               0                 0                0  \n",
       "8               0                 0                0  \n",
       "9               0                 0                0  \n",
       "\n",
       "[10 rows x 19724 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(df.columns[[0, 1]], axis=1, inplace=True) # drop EL and TL\n",
    "df.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Apriori liefert ein DataFrame in welchem man sieht, welche Zutaten in Kombinationen mit anderen Zutaten wie oft insgesamt vorkommen. Zum Beispiel: \n",
    "- 57.8 Prozent in allen Rezepten kommt Salz vor.\n",
    "- 39.8 Prozent in allen Rezepten kommt Salz **und** Pfeffer vor."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 2min 39s, sys: 52 ms, total: 2min 39s\n",
      "Wall time: 2min 39s\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "frequent_ingr = apriori(df, min_support=0.04, use_colnames=True)\n",
    "frequent_ingr['length'] = frequent_ingr['itemsets'].apply(lambda x: len(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>support</th>\n",
       "      <th>itemsets</th>\n",
       "      <th>length</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0.601187</td>\n",
       "      <td>[Salz]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0.432675</td>\n",
       "      <td>[Pfeffer]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>0.402075</td>\n",
       "      <td>[Pfeffer, Salz]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>0.357837</td>\n",
       "      <td>[Zucker]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.301750</td>\n",
       "      <td>[Ei]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.273625</td>\n",
       "      <td>[Mehl]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.272175</td>\n",
       "      <td>[Butter]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>0.269962</td>\n",
       "      <td>[Zwiebel]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>0.227850</td>\n",
       "      <td>[Salz, Zwiebel]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>0.205400</td>\n",
       "      <td>[Pfeffer, Zwiebel]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>0.194013</td>\n",
       "      <td>[Pfeffer, Salz, Zwiebel]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>0.185262</td>\n",
       "      <td>[Ei, Mehl]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>0.177787</td>\n",
       "      <td>[Ei, Zucker]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>0.177575</td>\n",
       "      <td>[Mehl, Zucker]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>0.169300</td>\n",
       "      <td>[Ei, Salz]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>0.167313</td>\n",
       "      <td>[Öl]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>0.166475</td>\n",
       "      <td>[Butter, Salz]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>0.164038</td>\n",
       "      <td>[Salz, Zucker]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>0.155725</td>\n",
       "      <td>[Mehl, Salz]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.154463</td>\n",
       "      <td>[Milch]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>0.148163</td>\n",
       "      <td>[Butter, Mehl]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>0.142600</td>\n",
       "      <td>[Butter, Zucker]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>0.139237</td>\n",
       "      <td>[Ei, Mehl, Zucker]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.138162</td>\n",
       "      <td>[Backpulver]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0.137462</td>\n",
       "      <td>[Sahne]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>0.136600</td>\n",
       "      <td>[Butter, Ei]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>0.134725</td>\n",
       "      <td>[Wasser]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0.132763</td>\n",
       "      <td>[Olivenöl]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>0.130000</td>\n",
       "      <td>[Salz, Öl]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.126450</td>\n",
       "      <td>[Knoblauchzehe]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>0.043388</td>\n",
       "      <td>[Ei, Salz, Zwiebel]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>0.043312</td>\n",
       "      <td>[Salz, Tomatenmark]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>0.043300</td>\n",
       "      <td>[Milch, Pfeffer]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>0.043200</td>\n",
       "      <td>[Backpulver, Ei, Salz]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.042662</td>\n",
       "      <td>[Basilikum]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>0.042388</td>\n",
       "      <td>[Paprikapulver, Salz, Zwiebel]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.042112</td>\n",
       "      <td>[Honig]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>0.042063</td>\n",
       "      <td>[Ei, Sahne]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>0.042050</td>\n",
       "      <td>[Zucker, Zwiebel]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>0.042037</td>\n",
       "      <td>[Backpulver, Ei, Mehl, Vanillezucker, Zucker]</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>0.041962</td>\n",
       "      <td>[Kartoffel, Zwiebel]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>0.041938</td>\n",
       "      <td>[Salz, Zitrone]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>0.041837</td>\n",
       "      <td>[Olivenöl, Pfeffer, Salz, Zwiebel]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>0.041725</td>\n",
       "      <td>[Butter, Pfeffer, Zwiebel]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>0.041600</td>\n",
       "      <td>[Zimt, Zucker]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>0.041462</td>\n",
       "      <td>[Butter, Puderzucker]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>0.041450</td>\n",
       "      <td>[Eigelb, Zucker]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>0.041350</td>\n",
       "      <td>[Milch, Salz, Zucker]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>0.041337</td>\n",
       "      <td>[Milch, Pfeffer, Salz]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>0.041275</td>\n",
       "      <td>[Backpulver, Salz, Zucker]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>0.041212</td>\n",
       "      <td>[Butter, Mehl, Vanillezucker]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0.041087</td>\n",
       "      <td>[Thymian]</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>0.041025</td>\n",
       "      <td>[Paprikaschote, Salz, Zwiebel]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>0.040975</td>\n",
       "      <td>[Petersilie, Pfeffer, Zwiebel]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>0.040863</td>\n",
       "      <td>[Mehl, Zwiebel]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>0.040625</td>\n",
       "      <td>[Backpulver, Milch]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>0.040475</td>\n",
       "      <td>[Knoblauchzehe, Olivenöl, Salz]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>0.040438</td>\n",
       "      <td>[Wasser, Zwiebel]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>0.040225</td>\n",
       "      <td>[Käse, Pfeffer]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>0.040100</td>\n",
       "      <td>[Butter, Pfeffer, Salz, Zwiebel]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>225 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      support                                       itemsets  length\n",
       "24   0.601187                                         [Salz]       1\n",
       "21   0.432675                                      [Pfeffer]       1\n",
       "107  0.402075                                [Pfeffer, Salz]       2\n",
       "35   0.357837                                       [Zucker]       1\n",
       "4    0.301750                                           [Ei]       1\n",
       "13   0.273625                                         [Mehl]       1\n",
       "2    0.272175                                       [Butter]       1\n",
       "36   0.269962                                      [Zwiebel]       1\n",
       "122  0.227850                                [Salz, Zwiebel]       2\n",
       "111  0.205400                             [Pfeffer, Zwiebel]       2\n",
       "198  0.194013                       [Pfeffer, Salz, Zwiebel]       3\n",
       "55   0.185262                                     [Ei, Mehl]       2\n",
       "62   0.177787                                   [Ei, Zucker]       2\n",
       "86   0.177575                                 [Mehl, Zucker]       2\n",
       "60   0.169300                                     [Ei, Salz]       2\n",
       "37   0.167313                                           [Öl]       1\n",
       "51   0.166475                                 [Butter, Salz]       2\n",
       "121  0.164038                                 [Salz, Zucker]       2\n",
       "83   0.155725                                   [Mehl, Salz]       2\n",
       "14   0.154463                                        [Milch]       1\n",
       "46   0.148163                                 [Butter, Mehl]       2\n",
       "53   0.142600                               [Butter, Zucker]       2\n",
       "162  0.139237                             [Ei, Mehl, Zucker]       3\n",
       "0    0.138162                                   [Backpulver]       1\n",
       "23   0.137462                                        [Sahne]       1\n",
       "45   0.136600                                   [Butter, Ei]       2\n",
       "31   0.134725                                       [Wasser]       1\n",
       "17   0.132763                                     [Olivenöl]       1\n",
       "123  0.130000                                     [Salz, Öl]       2\n",
       "10   0.126450                                [Knoblauchzehe]       1\n",
       "..        ...                                            ...     ...\n",
       "167  0.043388                            [Ei, Salz, Zwiebel]       3\n",
       "117  0.043312                            [Salz, Tomatenmark]       2\n",
       "89   0.043300                               [Milch, Pfeffer]       2\n",
       "136  0.043200                         [Backpulver, Ei, Salz]       3\n",
       "1    0.042662                                    [Basilikum]       1\n",
       "188  0.042388                 [Paprikapulver, Salz, Zwiebel]       3\n",
       "7    0.042112                                        [Honig]       1\n",
       "59   0.042063                                    [Ei, Sahne]       2\n",
       "129  0.042050                              [Zucker, Zwiebel]       2\n",
       "224  0.042037  [Backpulver, Ei, Mehl, Vanillezucker, Zucker]       5\n",
       "71   0.041962                           [Kartoffel, Zwiebel]       2\n",
       "119  0.041938                                [Salz, Zitrone]       2\n",
       "220  0.041837             [Olivenöl, Pfeffer, Salz, Zwiebel]       4\n",
       "155  0.041725                     [Butter, Pfeffer, Zwiebel]       3\n",
       "128  0.041600                                 [Zimt, Zucker]       2\n",
       "49   0.041462                          [Butter, Puderzucker]       2\n",
       "65   0.041450                               [Eigelb, Zucker]       2\n",
       "182  0.041350                          [Milch, Salz, Zucker]       3\n",
       "181  0.041337                         [Milch, Pfeffer, Salz]       3\n",
       "142  0.041275                     [Backpulver, Salz, Zucker]       3\n",
       "150  0.041212                  [Butter, Mehl, Vanillezucker]       3\n",
       "27   0.041087                                      [Thymian]       1\n",
       "190  0.041025                 [Paprikaschote, Salz, Zwiebel]       3\n",
       "192  0.040975                 [Petersilie, Pfeffer, Zwiebel]       3\n",
       "87   0.040863                                [Mehl, Zwiebel]       2\n",
       "41   0.040625                            [Backpulver, Milch]       2\n",
       "172  0.040475                [Knoblauchzehe, Olivenöl, Salz]       3\n",
       "127  0.040438                              [Wasser, Zwiebel]       2\n",
       "78   0.040225                                [Käse, Pfeffer]       2\n",
       "215  0.040100               [Butter, Pfeffer, Salz, Zwiebel]       4\n",
       "\n",
       "[225 rows x 3 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frequent_ingr.sort_values(by='support', ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Welche Tuples von Zutaten kommen am meisten vor ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>support</th>\n",
       "      <th>itemsets</th>\n",
       "      <th>length</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>0.402075</td>\n",
       "      <td>[Pfeffer, Salz]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>0.227850</td>\n",
       "      <td>[Salz, Zwiebel]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>0.205400</td>\n",
       "      <td>[Pfeffer, Zwiebel]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>0.185262</td>\n",
       "      <td>[Ei, Mehl]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>0.177787</td>\n",
       "      <td>[Ei, Zucker]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>0.177575</td>\n",
       "      <td>[Mehl, Zucker]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>0.169300</td>\n",
       "      <td>[Ei, Salz]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>0.166475</td>\n",
       "      <td>[Butter, Salz]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>0.164038</td>\n",
       "      <td>[Salz, Zucker]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>0.155725</td>\n",
       "      <td>[Mehl, Salz]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>0.148163</td>\n",
       "      <td>[Butter, Mehl]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>0.142600</td>\n",
       "      <td>[Butter, Zucker]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>0.136600</td>\n",
       "      <td>[Butter, Ei]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>0.130000</td>\n",
       "      <td>[Salz, Öl]</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      support            itemsets  length\n",
       "107  0.402075     [Pfeffer, Salz]       2\n",
       "122  0.227850     [Salz, Zwiebel]       2\n",
       "111  0.205400  [Pfeffer, Zwiebel]       2\n",
       "55   0.185262          [Ei, Mehl]       2\n",
       "62   0.177787        [Ei, Zucker]       2\n",
       "86   0.177575      [Mehl, Zucker]       2\n",
       "60   0.169300          [Ei, Salz]       2\n",
       "51   0.166475      [Butter, Salz]       2\n",
       "121  0.164038      [Salz, Zucker]       2\n",
       "83   0.155725        [Mehl, Salz]       2\n",
       "46   0.148163      [Butter, Mehl]       2\n",
       "53   0.142600    [Butter, Zucker]       2\n",
       "45   0.136600        [Butter, Ei]       2\n",
       "123  0.130000          [Salz, Öl]       2"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frequent_ingr[(frequent_ingr['length'] == 2) & (frequent_ingr['support'] >= 0.125)].sort_values(by='support', ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Welche Triplets von Zutaten kommen am meisten vor ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>support</th>\n",
       "      <th>itemsets</th>\n",
       "      <th>length</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>0.194013</td>\n",
       "      <td>[Pfeffer, Salz, Zwiebel]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>0.139237</td>\n",
       "      <td>[Ei, Mehl, Zucker]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>0.106625</td>\n",
       "      <td>[Backpulver, Mehl, Zucker]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>0.106338</td>\n",
       "      <td>[Backpulver, Ei, Zucker]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>0.105288</td>\n",
       "      <td>[Backpulver, Ei, Mehl]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>0.105038</td>\n",
       "      <td>[Butter, Mehl, Zucker]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>0.103663</td>\n",
       "      <td>[Butter, Ei, Mehl]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>0.100050</td>\n",
       "      <td>[Pfeffer, Salz, Öl]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>0.098350</td>\n",
       "      <td>[Butter, Ei, Zucker]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>0.092575</td>\n",
       "      <td>[Ei, Mehl, Salz]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>0.092012</td>\n",
       "      <td>[Olivenöl, Pfeffer, Salz]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>0.089125</td>\n",
       "      <td>[Knoblauchzehe, Pfeffer, Salz]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>0.087138</td>\n",
       "      <td>[Butter, Pfeffer, Salz]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>0.082925</td>\n",
       "      <td>[Butter, Mehl, Salz]</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      support                        itemsets  length\n",
       "198  0.194013        [Pfeffer, Salz, Zwiebel]       3\n",
       "162  0.139237              [Ei, Mehl, Zucker]       3\n",
       "141  0.106625      [Backpulver, Mehl, Zucker]       3\n",
       "138  0.106338        [Backpulver, Ei, Zucker]       3\n",
       "135  0.105288          [Backpulver, Ei, Mehl]       3\n",
       "151  0.105038          [Butter, Mehl, Zucker]       3\n",
       "144  0.103663              [Butter, Ei, Mehl]       3\n",
       "199  0.100050             [Pfeffer, Salz, Öl]       3\n",
       "147  0.098350            [Butter, Ei, Zucker]       3\n",
       "160  0.092575                [Ei, Mehl, Salz]       3\n",
       "184  0.092012       [Olivenöl, Pfeffer, Salz]       3\n",
       "173  0.089125  [Knoblauchzehe, Pfeffer, Salz]       3\n",
       "154  0.087138         [Butter, Pfeffer, Salz]       3\n",
       "149  0.082925            [Butter, Mehl, Salz]       3"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frequent_ingr[(frequent_ingr['length'] == 3) & (frequent_ingr['support'] >= 0.08)].sort_values(by='support', ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Quadruplets ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>support</th>\n",
       "      <th>itemsets</th>\n",
       "      <th>length</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>0.095275</td>\n",
       "      <td>[Backpulver, Ei, Mehl, Zucker]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>0.083488</td>\n",
       "      <td>[Butter, Ei, Mehl, Zucker]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>0.059638</td>\n",
       "      <td>[Backpulver, Butter, Mehl, Zucker]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>0.059112</td>\n",
       "      <td>[Backpulver, Butter, Ei, Zucker]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>0.058463</td>\n",
       "      <td>[Backpulver, Butter, Ei, Mehl]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>0.057225</td>\n",
       "      <td>[Ei, Mehl, Salz, Zucker]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>0.056250</td>\n",
       "      <td>[Pfeffer, Salz, Zwiebel, Öl]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>0.053475</td>\n",
       "      <td>[Ei, Mehl, Vanillezucker, Zucker]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>0.052625</td>\n",
       "      <td>[Butter, Ei, Mehl, Salz]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>0.051025</td>\n",
       "      <td>[Knoblauchzehe, Pfeffer, Salz, Zwiebel]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>0.049500</td>\n",
       "      <td>[Butter, Mehl, Salz, Zucker]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>0.046913</td>\n",
       "      <td>[Pfeffer, Salz, Tomate, Zwiebel]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>0.046613</td>\n",
       "      <td>[Backpulver, Ei, Vanillezucker, Zucker]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>0.046488</td>\n",
       "      <td>[Backpulver, Mehl, Vanillezucker, Zucker]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>0.045525</td>\n",
       "      <td>[Ei, Mehl, Milch, Zucker]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>0.044612</td>\n",
       "      <td>[Backpulver, Ei, Mehl, Vanillezucker]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>0.043725</td>\n",
       "      <td>[Butter, Ei, Salz, Zucker]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>0.041837</td>\n",
       "      <td>[Olivenöl, Pfeffer, Salz, Zwiebel]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>0.040100</td>\n",
       "      <td>[Butter, Pfeffer, Salz, Zwiebel]</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      support                                   itemsets  length\n",
       "208  0.095275             [Backpulver, Ei, Mehl, Zucker]       4\n",
       "212  0.083488                 [Butter, Ei, Mehl, Zucker]       4\n",
       "206  0.059638         [Backpulver, Butter, Mehl, Zucker]       4\n",
       "205  0.059112           [Backpulver, Butter, Ei, Zucker]       4\n",
       "204  0.058463             [Backpulver, Butter, Ei, Mehl]       4\n",
       "217  0.057225                   [Ei, Mehl, Salz, Zucker]       4\n",
       "222  0.056250               [Pfeffer, Salz, Zwiebel, Öl]       4\n",
       "218  0.053475          [Ei, Mehl, Vanillezucker, Zucker]       4\n",
       "211  0.052625                   [Butter, Ei, Mehl, Salz]       4\n",
       "219  0.051025    [Knoblauchzehe, Pfeffer, Salz, Zwiebel]       4\n",
       "214  0.049500               [Butter, Mehl, Salz, Zucker]       4\n",
       "221  0.046913           [Pfeffer, Salz, Tomate, Zwiebel]       4\n",
       "209  0.046613    [Backpulver, Ei, Vanillezucker, Zucker]       4\n",
       "210  0.046488  [Backpulver, Mehl, Vanillezucker, Zucker]       4\n",
       "216  0.045525                  [Ei, Mehl, Milch, Zucker]       4\n",
       "207  0.044612      [Backpulver, Ei, Mehl, Vanillezucker]       4\n",
       "213  0.043725                 [Butter, Ei, Salz, Zucker]       4\n",
       "220  0.041837         [Olivenöl, Pfeffer, Salz, Zwiebel]       4\n",
       "215  0.040100           [Butter, Pfeffer, Salz, Zwiebel]       4"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frequent_ingr[(frequent_ingr['length'] == 4) & (frequent_ingr['support'] >= 0.04)].sort_values(by='support', ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Quintuplets ??"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>support</th>\n",
       "      <th>itemsets</th>\n",
       "      <th>length</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>0.053937</td>\n",
       "      <td>[Backpulver, Butter, Ei, Mehl, Zucker]</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>0.042037</td>\n",
       "      <td>[Backpulver, Ei, Mehl, Vanillezucker, Zucker]</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      support                                       itemsets  length\n",
       "223  0.053937         [Backpulver, Butter, Ei, Mehl, Zucker]       5\n",
       "224  0.042037  [Backpulver, Ei, Mehl, Vanillezucker, Zucker]       5"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frequent_ingr[(frequent_ingr['length'] == 5) & (frequent_ingr['support'] >= 0.04)].sort_values(by='support', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}