191027_web_scraping_of_ingredients(1).ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "\"\"\"\n",
    "This Jupyter notebook was used to perform some web-scraping of recipes from an open online recipe collection \n",
    "Source-copy-right-> https://www.kochrezepte.de\n",
    "This web-scraping was used in order to get an impression about which recipe ingredients are used the most frequently\n",
    "The relative importance of food recipe items was assessed by Count statistics\n",
    "1.)For this purpose https-urllib requests were used to get the Web data of free recipes\n",
    "2.) A nested url search was performed based on the starting page https://www.kochrezepte.de/rezepte/\n",
    "3.) The xml trees were returned from the web-sites of individual pages containing recipe information\n",
    "4.) the web-page information was extracted by parsing and regex matching\n",
    "5.) The ingredients were enlisted and the statistics were visualized\n",
    "6.) These statistics were used to priorize the search for CO2 footprint information of the most relevant products \n",
    "first.\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import urllib.request\n",
    "import json\n",
    "import requests\n",
    "import re\n",
    "from collections import Counter\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "from bs4 import BeautifulSoup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "__author__: 'Christoph Hiemenz'\n",
    "__version__: 0.01\n",
    "__status__: 'exploration'\n",
    "__contact__: 'christoph.hiemenz@web.de'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "def return_ingredient_list(recipe_in):\n",
    "    match_span = re.search('ingredient-.*post type-post\"',str(recipe_in)).span()\n",
    "    ingredients = [i[1:].strip() for i in str(tmp_refs[0])[match_span[0]:match_span[1]].split('ingredient')][1:]\n",
    "    ingredients_clean = [z.split(' ')[0].split('-') for z in ingredients]\n",
    "    return ingredients_clean"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "response = requests.get('https://www.kochrezepte.de/rezept/')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "soup = BeautifulSoup(response.content, 'html.parser')\n",
    "soup.prettify()\n",
    "samples = soup.find_all(\"a\")\n",
    "samples\n",
    "data = {}\n",
    "for a in samples:\n",
    "    if a.string:\n",
    "        title = a.string.strip()\n",
    "        data[title] = a.attrs['href']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "exclude_list = ['Anbau','Rezept eingeben',\n",
    "                'Home','Diät-Tipps','Food around the world','Top news','Abendessen','Newsletter',\n",
    "                'Rezept eingeben','Rezept eingeben','Rezepte','Haben Sie Ihr Passwort vergessen?',\n",
    "                'JETZT REGISTRIEREN','DATENSCHUTZ','IMPRESSUM','AGB','Jetzt kontakt aufnehmen',\n",
    "                'Mehr infos hier']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.kochrezepte.de/magazin/weltnudeltag-die-besten-nudel-rezepte-und-fakten/\n",
      "Weltnudeltag – Die besten Nudel Rezepte und Fakten\n",
      "https://www.kochrezepte.de/magazin/paprika-rezepte/\n",
      "Knackig bunt – Paprika Rezepte und Fakten\n",
      "https://www.kochrezepte.de/magazin/fruchtige-ernte-trauben-rezepte-und-fakten/\n",
      "Fruchtige Ernte – Trauben Rezepte und Fakten\n",
      "https://www.kochrezepte.de/category/magazin/artikel/\n",
      "Artikel\n",
      "https://www.kochrezepte.de/category/chefkoche/\n",
      "Chefköche\n",
      "https://www.kochrezepte.de/category/menue-kategorien/diaet-gesundheit/\n",
      "Diät & Gesundheit\n",
      "https://www.kochrezepte.de/category/menue-kategorien/food-trends-menue-kategorien/\n",
      "Food Trends\n",
      "https://www.kochrezepte.de/category/magazin/lexikon/\n",
      "Lexikon\n",
      "https://www.kochrezepte.de/category/side-news/\n",
      "Side news\n",
      "https://www.kochrezepte.de/recipe_tag/backpulver/\n",
      "Backpulver\n",
      "https://www.kochrezepte.de/recipe_tag/basilikum/\n",
      "Basilikum\n",
      "https://www.kochrezepte.de/recipe_tag/butter/\n",
      "Butter\n",
      "https://www.kochrezepte.de/recipe_tag/butterschmalz/\n",
      "Butterschmalz\n",
      "https://www.kochrezepte.de/recipe_tag/champignons/\n",
      "Champignons\n",
      "https://www.kochrezepte.de/recipe_tag/creme-fraiche/\n",
      "Crème fraîche\n",
      "https://www.kochrezepte.de/recipe_tag/ei/\n",
      "Ei\n",
      "https://www.kochrezepte.de/recipe_tag/eier/\n",
      "Eier\n",
      "https://www.kochrezepte.de/recipe_tag/eigelb/\n",
      "Eigelb\n",
      "https://www.kochrezepte.de/recipe_tag/gemuesebruehe/\n",
      "Gemuesebrühe\n",
      "https://www.kochrezepte.de/recipe_tag/honig/\n",
      "Honig\n",
      "https://www.kochrezepte.de/recipe_tag/kartoffeln/\n",
      "Kartoffeln\n",
      "https://www.kochrezepte.de/recipe_tag/knoblauch/\n",
      "Knoblauch\n",
      "https://www.kochrezepte.de/recipe_tag/magerquark/\n",
      "Magerquark\n",
      "https://www.kochrezepte.de/recipe_tag/mehl/\n",
      "Mehl\n",
      "https://www.kochrezepte.de/recipe_tag/milch/\n",
      "Milch\n",
      "https://www.kochrezepte.de/recipe_tag/moehren/\n",
      "Möhren\n",
      "https://www.kochrezepte.de/recipe_tag/oel/\n",
      "Oel\n",
      "https://www.kochrezepte.de/recipe_tag/olivenoel/\n",
      "Olivenoel\n",
      "https://www.kochrezepte.de/recipe_tag/paprikapulver/\n",
      "Paprikapulver\n",
      "https://www.kochrezepte.de/recipe_tag/petersilie/\n",
      "Petersilie\n",
      "https://www.kochrezepte.de/recipe_tag/pfeffer/\n",
      "Pfeffer\n",
      "https://www.kochrezepte.de/recipe_tag/pfeffer-schwarz/\n",
      "Pfeffer schwarz\n",
      "https://www.kochrezepte.de/recipe_tag/pfeffer-weiss/\n",
      "Pfeffer weiß\n",
      "https://www.kochrezepte.de/recipe_tag/puderzucker/\n",
      "Puderzucker\n",
      "https://www.kochrezepte.de/recipe_tag/sahne/\n",
      "Sahne\n",
      "https://www.kochrezepte.de/recipe_tag/salz/\n",
      "Salz\n",
      "https://www.kochrezepte.de/recipe_tag/salz-pfeffer/\n",
      "Salz & Pfeffer\n",
      "https://www.kochrezepte.de/recipe_tag/schlagsahne/\n",
      "Schlagsahne\n",
      "https://www.kochrezepte.de/recipe_tag/speisestaerke/\n",
      "Speisestärke\n",
      "https://www.kochrezepte.de/recipe_tag/thymian/\n",
      "Thymian\n",
      "https://www.kochrezepte.de/recipe_tag/tomaten/\n",
      "Tomaten\n",
      "https://www.kochrezepte.de/recipe_tag/tomatenmark/\n",
      "Tomatenmark\n",
      "https://www.kochrezepte.de/recipe_tag/vanillezucker/\n",
      "Vanillezucker\n",
      "https://www.kochrezepte.de/recipe_tag/wasser/\n",
      "Wasser\n",
      "https://www.kochrezepte.de/recipe_tag/weizenmehl/\n",
      "Weizenmehl\n",
      "https://www.kochrezepte.de/recipe_tag/weisswein/\n",
      "Weißwein\n",
      "https://www.kochrezepte.de/recipe_tag/zimt/\n",
      "Zimt\n",
      "https://www.kochrezepte.de/recipe_tag/zitrone/\n",
      "Zitrone\n",
      "https://www.kochrezepte.de/recipe_tag/zitronensaft/\n",
      "Zitronensaft\n",
      "https://www.kochrezepte.de/recipe_tag/zucker/\n",
      "Zucker\n",
      "https://www.kochrezepte.de/recipe_tag/zucker-weiss/\n",
      "Zucker weiß\n",
      "https://www.kochrezepte.de/recipe_tag/zwiebel/\n",
      "Zwiebel\n",
      "https://www.kochrezepte.de/recipe_tag/zwiebeln/\n",
      "Zwiebeln\n",
      "https://www.kochrezepte.de/recipe_tag/aepfel/\n",
      "Äpfel\n",
      "https://www.kochrezepte.de/rezept/beilagen/\n",
      "Beilagen\n",
      "https://www.kochrezepte.de/rezept/diat-rezepte/\n",
      "Diät-Rezepte\n",
      "https://www.kochrezepte.de/rezept/fruhstuck/\n",
      "Frühstück\n",
      "https://www.kochrezepte.de/rezept/getrank-mit-alkohol/\n",
      "Getränk mit Alkohol\n",
      "https://www.kochrezepte.de/rezept/getrank-ohne-alkohol/\n",
      "Getränk ohne Alkohol\n",
      "https://www.kochrezepte.de/rezept/hauptspeisen/\n",
      "Hauptspeisen\n",
      "https://www.kochrezepte.de/rezept/kuchen-und-suesses-gebaeck/\n",
      "Kuchen und süßes Gebäck\n",
      "https://www.kochrezepte.de/rezept/nachspeise-suessspeise/\n",
      "Nachspeise + Süßspeise\n",
      "https://www.kochrezepte.de/rezept/salate/\n",
      "Salate\n",
      "https://www.kochrezepte.de/rezept/snacks/\n",
      "Snacks\n",
      "https://www.kochrezepte.de/rezept/suppen/\n",
      "Suppen\n",
      "https://www.kochrezepte.de/rezept/vorspeisen/\n",
      "Vorspeisen\n"
     ]
    }
   ],
   "source": [
    "ctr = -1\n",
    "collect_links = []\n",
    "for key, val in data.items():\n",
    "    ctr+=1\n",
    "    if re.search('https',str(val)) and key not in exclude_list:\n",
    "        print(val)\n",
    "        print(key)\n",
    "        try:\n",
    "            tmp_get = (key, val, requests.get(val).content)\n",
    "            soup = BeautifulSoup(tmp_get[2], 'html.parser')\n",
    "            soup.prettify()\n",
    "            samples_tmp = soup.find_all(\"a\")\n",
    "            only_recipe_links = [str(i)[re.search(r'www.kochrezepte.de/rezepte/.*/\"',str(i)).span()[0]:re.search(r'www.kochrezepte.de/rezepte/.*/\"',str(i)).span()[1]] for i in samples_tmp if re.search(r'www.kochrezepte.de/rezepte/.*/',str(i))]\n",
    "            collect_links = collect_links + only_recipe_links \n",
    "        except:\n",
    "            print('no_access')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "unique_list = list(set(collect_links))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['www.kochrezepte.de/rezepte/herzhafte-kaese-tarte/\"',\n",
       " 'www.kochrezepte.de/rezepte/spanferkelkeule/\"',\n",
       " 'www.kochrezepte.de/rezepte/gedeckte-apfeltorte/\"',\n",
       " 'www.kochrezepte.de/rezepte/leckerer-fruechte-pie-fuer-gaeste/\"',\n",
       " 'www.kochrezepte.de/rezepte/pumpkin-spice-latte/\"',\n",
       " 'www.kochrezepte.de/rezepte/weihnachtlicher-lebkuchenpudding-mit-beerenfruechten/\"',\n",
       " 'www.kochrezepte.de/rezepte/fettuccine-alfredo-mit-garnelen/\"',\n",
       " 'www.kochrezepte.de/rezepte/planters-punch/\"',\n",
       " 'www.kochrezepte.de/rezepte/gnocci-spinaci/\"',\n",
       " 'www.kochrezepte.de/rezepte/russischer-kartoffelsalat-in-20-minuten/\"',\n",
       " 'www.kochrezepte.de/rezepte/gazpacho-to-go/\"',\n",
       " 'www.kochrezepte.de/rezepte/kalter-hund-13/\"',\n",
       " 'www.kochrezepte.de/rezepte/quesadillas-selber-machen/\"',\n",
       " 'www.kochrezepte.de/rezepte/texas-rub/\"',\n",
       " 'www.kochrezepte.de/rezepte/frankfurter-grune-sose/\"',\n",
       " 'www.kochrezepte.de/rezepte/kohlrabi-gemuese/\"',\n",
       " 'www.kochrezepte.de/rezepte/nudelauflauf-avanti/\"',\n",
       " 'www.kochrezepte.de/rezepte/mango-moehren-suppe/\"',\n",
       " 'www.kochrezepte.de/rezepte/raffinierter-rinderbraten-auf-franzoesische-art/\"',\n",
       " 'www.kochrezepte.de/rezepte/putenfilet-rot-orange/\"',\n",
       " 'www.kochrezepte.de/rezepte/schokokuchen-mit-birnen/\"',\n",
       " 'www.kochrezepte.de/rezepte/apfelkuchen-mit-wein/\"',\n",
       " 'www.kochrezepte.de/rezepte/spiral-kartoffeln/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliches-ochsenschwanzragout/\"',\n",
       " 'www.kochrezepte.de/rezepte/lammpfanne-tuerkischer-abend/\"',\n",
       " 'www.kochrezepte.de/rezepte/geduensteter-kabeljau-klassisch/\"',\n",
       " 'www.kochrezepte.de/rezepte/rote-bete-veggie-burger/\"',\n",
       " 'www.kochrezepte.de/rezepte/kuerbis-gnocchi-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/crumble-mit-zwetschgen/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliches-schweinefleisch-suess-sauer/\"',\n",
       " 'www.kochrezepte.de/rezepte/deftiger-rosenkohlauflauf-einfach-schnell/\"',\n",
       " 'www.kochrezepte.de/rezepte/donuts-mit-zucker-und-zimt/\"',\n",
       " 'www.kochrezepte.de/rezepte/rindfleisch-salat-3/\"',\n",
       " 'www.kochrezepte.de/rezepte/pavlova-mit-beeren/\"',\n",
       " 'www.kochrezepte.de/rezepte/himbeer-eis-am-stiel/\"',\n",
       " 'www.kochrezepte.de/rezepte/spinatspaetzle-mit-schinken-kaese-sosse/\"',\n",
       " 'www.kochrezepte.de/rezepte/griesskloesschensuppe/\"',\n",
       " 'www.kochrezepte.de/rezepte/kraeuter-halloumi-mit-tomaten-vom-grill/\"',\n",
       " 'www.kochrezepte.de/rezepte/reisnudel-salat-mit-erdnuessen-thai-vinaigrette/\"',\n",
       " 'www.kochrezepte.de/rezepte/lemon-curd/\"',\n",
       " 'www.kochrezepte.de/rezepte/toskanischer-filet-topf/\"',\n",
       " 'www.kochrezepte.de/rezepte/kaesespaetzle-muffins/\"',\n",
       " 'www.kochrezepte.de/rezepte/hack-quark-frikadellen-mit-champignonsosse/\"',\n",
       " 'www.kochrezepte.de/rezepte/parmesan-pommes/\"',\n",
       " 'www.kochrezepte.de/rezepte/gefuellte-ofenkartoffeln-mit-kaese/\"',\n",
       " 'www.kochrezepte.de/rezepte/paprika-feta-dip/\"',\n",
       " 'www.kochrezepte.de/rezepte/nutella-erdbeer-cheesecake-ohne-backen/\"',\n",
       " 'www.kochrezepte.de/rezepte/chili-con-carne/\"',\n",
       " 'www.kochrezepte.de/rezepte/raffinierte-filetstreifen-koenigsberg/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestlicher-nudelauflauf/\"',\n",
       " 'www.kochrezepte.de/rezepte/mac-cheese-bites/\"',\n",
       " 'www.kochrezepte.de/rezepte/weissbier-tiramisu/\"',\n",
       " 'www.kochrezepte.de/rezepte/apfel-torte-mit-karamell/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestlich-italienische-maultaschen-fuer-gaeste/\"',\n",
       " 'www.kochrezepte.de/rezepte/wassermelonen-smoothie/\"',\n",
       " 'www.kochrezepte.de/rezepte/rinderroulade/\"',\n",
       " 'www.kochrezepte.de/rezepte/taquitos-mit-schwarzen-bohnen/\"',\n",
       " 'www.kochrezepte.de/rezepte/saftige-quarkbaellchen-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/zitronen-eistee/\"',\n",
       " 'www.kochrezepte.de/rezepte/ananas-mit-karamellsauce-luftiger-joghurtcreme/\"',\n",
       " 'www.kochrezepte.de/rezepte/nudelsalat-mit-grunem-spargel-pasta-nudeln/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliche-maultaschen-in-pfeffer-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/schokoladen-muffins/\"',\n",
       " 'www.kochrezepte.de/rezepte/churros-selber-machen/\"',\n",
       " 'www.kochrezepte.de/rezepte/himbeertraum-fuer-gaeste/\"',\n",
       " 'www.kochrezepte.de/rezepte/deftiges-kartoffelpfaennchen/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliche-winzerpfanne/\"',\n",
       " 'www.kochrezepte.de/rezepte/himmlische-alabama-creme/\"',\n",
       " 'www.kochrezepte.de/rezepte/orangenmarmelade/\"',\n",
       " 'www.kochrezepte.de/rezepte/brownies-mit-walnuessen/\"',\n",
       " 'www.kochrezepte.de/rezepte/pasta-alfredo/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliche-weisskrautwickerl-in-biersosse-garen-in-der-mikrowelle/\"',\n",
       " 'www.kochrezepte.de/rezepte/delikater-schwedischer-fischauflauf/\"',\n",
       " 'www.kochrezepte.de/rezepte/baerlauch-pesto-5/\"',\n",
       " 'www.kochrezepte.de/rezepte/wuerziges-porree-ragout-mit-kartoffelpuffer/\"',\n",
       " 'www.kochrezepte.de/rezepte/erdbeer-kaesekuchen-5/\"',\n",
       " 'www.kochrezepte.de/rezepte/gnocchi-carbonara/\"',\n",
       " 'www.kochrezepte.de/rezepte/deep-dish-pizza/\"',\n",
       " 'www.kochrezepte.de/rezepte/rotkohl-und-austernpilze-in-fruchtgelee/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliches-mandarinenhaehnchen/\"',\n",
       " 'www.kochrezepte.de/rezepte/exotischer-indientopf/\"',\n",
       " 'www.kochrezepte.de/rezepte/frisee-salat-france/\"',\n",
       " 'www.kochrezepte.de/rezepte/herbstlicher-birnensalat/\"',\n",
       " 'www.kochrezepte.de/rezepte/selbstgemachte-frikadellen/\"',\n",
       " 'www.kochrezepte.de/rezepte/nusskuchen-in-20-minuten/\"',\n",
       " 'www.kochrezepte.de/rezepte/pizza-mit-pfifferlingen/\"',\n",
       " 'www.kochrezepte.de/rezepte/quesadillas-mit-haehnchenbrustfilet/\"',\n",
       " 'www.kochrezepte.de/rezepte/herzwaffeln-mit-beeren/\"',\n",
       " 'www.kochrezepte.de/rezepte/spanische-haehnchenpfanne/\"',\n",
       " 'www.kochrezepte.de/rezepte/upside-down-ananas-kuchen/\"',\n",
       " 'www.kochrezepte.de/rezepte/feine-kartoffelsuppe-3/\"',\n",
       " 'www.kochrezepte.de/rezepte/suser-apfelauflauf/\"',\n",
       " 'www.kochrezepte.de/rezepte/avocado-himbeer-salat/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliche-fischsuppe-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/wuerzige-spinat-knoblauch-lasagne/\"',\n",
       " 'www.kochrezepte.de/rezepte/rohrnudeln-mit-pralinensauce-bestes-rezept/\"',\n",
       " 'www.kochrezepte.de/rezepte/parfait-im-glas-to-go/\"',\n",
       " 'www.kochrezepte.de/rezepte/fruchttoertchen/\"',\n",
       " 'www.kochrezepte.de/rezepte/selbstgemachte-burger-broetchen/\"',\n",
       " 'www.kochrezepte.de/rezepte/filetsteak/\"',\n",
       " 'www.kochrezepte.de/rezepte/erdbeer-eis-ohne-eismaschine/\"',\n",
       " 'www.kochrezepte.de/rezepte/zitronencreme/\"',\n",
       " 'www.kochrezepte.de/rezepte/pfannkuchen/\"',\n",
       " 'www.kochrezepte.de/rezepte/leckerer-kohlrabisalat-den-moegen-auch-kinder-k/\"',\n",
       " 'www.kochrezepte.de/rezepte/eierlikoer-3/\"',\n",
       " 'www.kochrezepte.de/rezepte/herzhafte-apfel-kaese-galette/\"',\n",
       " 'www.kochrezepte.de/rezepte/tequila-sunrise-schnell-zubereitet/\"',\n",
       " 'www.kochrezepte.de/rezepte/puten-geschnetzeltes-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/brezenknoedel-4/\"',\n",
       " 'www.kochrezepte.de/rezepte/tortellini-in-gemuesesosse-3/\"',\n",
       " 'www.kochrezepte.de/rezepte/brownies-mit-kirschen-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/spaghetti-mit-steinpilz-specksose/\"',\n",
       " 'www.kochrezepte.de/rezepte/scharfes-reisfleisch-khao-phat-fuer-gaeste/\"',\n",
       " 'www.kochrezepte.de/rezepte/erdbeer-basilikum-limo/\"',\n",
       " 'www.kochrezepte.de/rezepte/schnelles-pilz-puten-gulasch/\"',\n",
       " 'www.kochrezepte.de/rezepte/raffinierte-haehnchenbrust-in-soja-pfeffer-sosse-mit-mandelreis/\"',\n",
       " 'www.kochrezepte.de/rezepte/gebratene-gefluegelleber-einfach-schnell/\"',\n",
       " 'www.kochrezepte.de/rezepte/klassische-kaeseschnitzel-zum-dahinschmelzen/\"',\n",
       " 'www.kochrezepte.de/rezepte/zwetschgenkuchen-selber-machen/\"',\n",
       " 'www.kochrezepte.de/rezepte/tzaziki/\"',\n",
       " 'www.kochrezepte.de/rezepte/kartoffelsalat-ganz-einfach/\"',\n",
       " 'www.kochrezepte.de/rezepte/kartoffel-bacon-rosen/\"',\n",
       " 'www.kochrezepte.de/rezepte/dutch-baby-mit-erdbeeren/\"',\n",
       " 'www.kochrezepte.de/rezepte/fruehlingsfrikassee-mit-champignon-reis/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliche-putenschnitzel-vom-blech/\"',\n",
       " 'www.kochrezepte.de/rezepte/himmlischer-fruechtetraum-fuer-gaeste/\"',\n",
       " 'www.kochrezepte.de/rezepte/toast-hawaii/\"',\n",
       " 'www.kochrezepte.de/rezepte/leckere-vegetarische-lasagne/\"',\n",
       " 'www.kochrezepte.de/rezepte/maitorte-mit-erdbeeren-und-waldmeister/\"',\n",
       " 'www.kochrezepte.de/rezepte/tomatensalat/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliche-fleischbaellchen-in-mischgemuese/\"',\n",
       " 'www.kochrezepte.de/rezepte/raffinierte-ziegenkaese-kraeutercreme/\"',\n",
       " 'www.kochrezepte.de/rezepte/himbeer-crumble/\"',\n",
       " 'www.kochrezepte.de/rezepte/feldsalat-mit-pute-und-curry/\"',\n",
       " 'www.kochrezepte.de/rezepte/suesskartoffel-pommes-selber-machen/\"',\n",
       " 'www.kochrezepte.de/rezepte/ciabatta-in-20-minuten/\"',\n",
       " 'www.kochrezepte.de/rezepte/vegatarisches-risotto/\"',\n",
       " 'www.kochrezepte.de/rezepte/raffinierte-fraenkischer-bierkuchen/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliches-ungarisches-paprikahuhn/\"',\n",
       " 'www.kochrezepte.de/rezepte/heidelbeer-eierlikoer-torte-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/leckerer-obstsalat-fuer-diabetiker/\"',\n",
       " 'www.kochrezepte.de/rezepte/kartoffel-kaese-baellchen/\"',\n",
       " 'www.kochrezepte.de/rezepte/suesser-kaesetraum-tiramisu/\"',\n",
       " 'www.kochrezepte.de/rezepte/gemuese-weizenpfanne/\"',\n",
       " 'www.kochrezepte.de/rezepte/pretty-women/\"',\n",
       " 'www.kochrezepte.de/rezepte/feines-pilzrisotto/\"',\n",
       " 'www.kochrezepte.de/rezepte/vegetarische-spaghetti-mit-baerlauch-mandel-pesto-k/\"',\n",
       " 'www.kochrezepte.de/rezepte/mexikanische-garnelen-mit-koriander/\"',\n",
       " 'www.kochrezepte.de/rezepte/french-toast-mit-banane/\"',\n",
       " 'www.kochrezepte.de/rezepte/gnocchi-mit-gorgonzola/\"',\n",
       " 'www.kochrezepte.de/rezepte/kuerbissuppe/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliches-haehnchenbrustfilet-in-curry-apfel-mango-sosse/\"',\n",
       " 'www.kochrezepte.de/rezepte/kuerbissuppe-selber-machen/\"',\n",
       " 'www.kochrezepte.de/rezepte/turkische-pizza-lahmacun-in-30-minuten-fur-8-portionen/\"',\n",
       " 'www.kochrezepte.de/rezepte/donauwelle/\"',\n",
       " 'www.kochrezepte.de/rezepte/spargel-gratin-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/bunter-salat-mit-putenbruststreifen/\"',\n",
       " 'www.kochrezepte.de/rezepte/sachsische-kartoffelsuppe/\"',\n",
       " 'www.kochrezepte.de/rezepte/britische-cheddar-suppe-mit-klassisch-suessen-aroma/\"',\n",
       " 'www.kochrezepte.de/rezepte/wraps-mit-raeucherlachs/\"',\n",
       " 'www.kochrezepte.de/rezepte/carbonara-gugelhupf/\"',\n",
       " 'www.kochrezepte.de/rezepte/eierlikor-pfirsichtorte/\"',\n",
       " 'www.kochrezepte.de/rezepte/warmer-herbstsalat-mit-haselnuessen/\"',\n",
       " 'www.kochrezepte.de/rezepte/leberknoedelsuppe-hausgemacht/\"',\n",
       " 'www.kochrezepte.de/rezepte/guacamole/\"',\n",
       " 'www.kochrezepte.de/rezepte/chili-con-carne-23/\"',\n",
       " 'www.kochrezepte.de/rezepte/kuerbissuppe-auf-orientalische-art/\"',\n",
       " 'www.kochrezepte.de/rezepte/suesse-schlemmerei-rosinen-schmarren/\"',\n",
       " 'www.kochrezepte.de/rezepte/grossmutters-deftiger-wirsingauflauf-mit-hack-kartoffeln/\"',\n",
       " 'www.kochrezepte.de/rezepte/lauchsuppe/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestlicher-wildreis-romanesco/\"',\n",
       " 'www.kochrezepte.de/rezepte/schoko-crepes-mit-sahne/\"',\n",
       " 'www.kochrezepte.de/rezepte/feldsalat-orangen-himbeertraum/\"',\n",
       " 'www.kochrezepte.de/rezepte/erdbeer-freakshake/\"',\n",
       " 'www.kochrezepte.de/rezepte/gestreifter-kalter-hund/\"',\n",
       " 'www.kochrezepte.de/rezepte/raffinierter-walnusslikoer-aus-gruenen-nuessen/\"',\n",
       " 'www.kochrezepte.de/rezepte/delikater-obstsalat-mit-baiser-haube-vanilleeis/\"',\n",
       " 'www.kochrezepte.de/rezepte/selbstgemachte-tomatensosse/\"',\n",
       " 'www.kochrezepte.de/rezepte/salbei-schupfnudeln-mit-brechbohnen/\"',\n",
       " 'www.kochrezepte.de/rezepte/delikate-spinat-lachs-lasagne-fuer-gaeste/\"',\n",
       " 'www.kochrezepte.de/rezepte/feurio-alkoholfrei/\"',\n",
       " 'www.kochrezepte.de/rezepte/caribic-alkoholfrei/\"',\n",
       " 'www.kochrezepte.de/rezepte/holunderbluetensaft-ohne-alkohol/\"',\n",
       " 'www.kochrezepte.de/rezepte/hefezopf-in-45-minuten/\"',\n",
       " 'www.kochrezepte.de/rezepte/wassermelonen-feta-salat-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/trauben-tarte/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliches-sauerrahmdessert-fuer-gaeste/\"',\n",
       " 'www.kochrezepte.de/rezepte/jungschweinruecken-mit-ahornsirup-und-koestlichem-leipziger-allerlei/\"',\n",
       " 'www.kochrezepte.de/rezepte/erdbeersorbet/\"',\n",
       " 'www.kochrezepte.de/rezepte/kartoffel-gratin/\"',\n",
       " 'www.kochrezepte.de/rezepte/leichte-spargelcremesuppe-aus-spargelresten-k/\"',\n",
       " 'www.kochrezepte.de/rezepte/raffiniertes-butterfly-haehnchen-mit-rosmarin-focaccia/\"',\n",
       " 'www.kochrezepte.de/rezepte/rumpsteak-mit-biersosse/\"',\n",
       " 'www.kochrezepte.de/rezepte/ananas-erdbeer-kefir-alkoholfrei/\"',\n",
       " 'www.kochrezepte.de/rezepte/pide-mit-hackfleisch/\"',\n",
       " 'www.kochrezepte.de/rezepte/kase-lauch-cremesuppe/\"',\n",
       " 'www.kochrezepte.de/rezepte/ketchup-selber-machen/\"',\n",
       " 'www.kochrezepte.de/rezepte/spaghetti-arrabbiata/\"',\n",
       " 'www.kochrezepte.de/rezepte/ayran/\"',\n",
       " 'www.kochrezepte.de/rezepte/feiner-brotpudding-suessspeisen-aus-der-mikrowelle/\"',\n",
       " 'www.kochrezepte.de/rezepte/eiskaffee/\"',\n",
       " 'www.kochrezepte.de/rezepte/kindersmilie/\"',\n",
       " 'www.kochrezepte.de/rezepte/wurst-spiesse-vom-grill/\"',\n",
       " 'www.kochrezepte.de/rezepte/pina-colada-in-10-minuten-fuer-1-portionen/\"',\n",
       " 'www.kochrezepte.de/rezepte/raffinierter-nuss-dip/\"',\n",
       " 'www.kochrezepte.de/rezepte/schoko-freakshake/\"',\n",
       " 'www.kochrezepte.de/rezepte/pizzabrotchen-in-10-minuten/\"',\n",
       " 'www.kochrezepte.de/rezepte/putengeschnetzeltes-7/\"',\n",
       " 'www.kochrezepte.de/rezepte/risotto-mit-pilzen-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/jambalaya-mit-reis-ideal-fuer-gaeste/\"',\n",
       " 'www.kochrezepte.de/rezepte/feiner-fischauflauf-mit-senfrahmsosse/\"',\n",
       " 'www.kochrezepte.de/rezepte/mini-pavlova-mit-trauben/\"',\n",
       " 'www.kochrezepte.de/rezepte/quittenmarmelade/\"',\n",
       " 'www.kochrezepte.de/rezepte/pekingente-sim-so/\"',\n",
       " 'www.kochrezepte.de/rezepte/maultaschen-mit-tomatensosse-ueberbacken/\"',\n",
       " 'www.kochrezepte.de/rezepte/rosinenbrot/\"',\n",
       " 'www.kochrezepte.de/rezepte/kaiserschmarrn/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliche-foerstertorte-ideal-fuer-gaeste/\"',\n",
       " 'www.kochrezepte.de/rezepte/pancakes-mit-ahornsirup-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/knuspriges-bierbrot/\"',\n",
       " 'www.kochrezepte.de/rezepte/rosenkohltopf/\"',\n",
       " 'www.kochrezepte.de/rezepte/italienischer-nudelsalat/\"',\n",
       " 'www.kochrezepte.de/rezepte/avocadorahmsuppe/\"',\n",
       " 'www.kochrezepte.de/rezepte/panierte-haehnchen-streifen/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliche-haehnchenpfanne/\"',\n",
       " 'www.kochrezepte.de/rezepte/delikates-lachsrisotto-mit-broccoliroeschen-kaiserschoten/\"',\n",
       " 'www.kochrezepte.de/rezepte/paprikasalat-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/schwaebische-eierspaetzle-mit-schinken-sahne-sosse/\"',\n",
       " 'www.kochrezepte.de/rezepte/feuerzangenbowle-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/aus-fremden-kuechen-lasagne-bolognese/\"',\n",
       " 'www.kochrezepte.de/rezepte/cheeseburger/\"',\n",
       " 'www.kochrezepte.de/rezepte/pfifferling-pasta/\"',\n",
       " 'www.kochrezepte.de/rezepte/koestliche-apfeltaschen-einfach-schnell/\"',\n",
       " 'www.kochrezepte.de/rezepte/moehrenquiche-mit-fruehlingskraeuterquark/\"',\n",
       " 'www.kochrezepte.de/rezepte/geschnetzeltes-schweinefilet-mit-pilzen/\"',\n",
       " 'www.kochrezepte.de/rezepte/tomaten-galette/\"',\n",
       " 'www.kochrezepte.de/rezepte/pikante-fruehlingsrollen/\"',\n",
       " 'www.kochrezepte.de/rezepte/schokoladeneis-selbstgemacht/\"',\n",
       " 'www.kochrezepte.de/rezepte/tafelspitz-sommersalat/\"',\n",
       " 'www.kochrezepte.de/rezepte/flammkuchen-mit-speck-und-zwiebeln-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/pestoblume/\"',\n",
       " 'www.kochrezepte.de/rezepte/brokkolicremesuppe-ii-k/\"',\n",
       " 'www.kochrezepte.de/rezepte/zitronentarte-2/\"',\n",
       " 'www.kochrezepte.de/rezepte/zwetschgenknoedel-6/\"',\n",
       " 'www.kochrezepte.de/rezepte/moink-bbq-rub/\"',\n",
       " 'www.kochrezepte.de/rezepte/fruehlingszwiebeln-quiche/\"',\n",
       " 'www.kochrezepte.de/rezepte/gnocchi-selber-machen/\"',\n",
       " 'www.kochrezepte.de/rezepte/feines-spargelgratin-mit-haehnchenfilet/\"']"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "unique_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n",
      "no_access\n"
     ]
    }
   ],
   "source": [
    "rezept_data = []\n",
    "for rezeptlink in unique_list:\n",
    "    try:  \n",
    "        construct_link = 'https://' + rezeptlink[0:-1]\n",
    "        tmp_get = requests.get(construct_link)            \n",
    "        soup = BeautifulSoup(tmp_get.content, 'html.parser')\n",
    "        soup.prettify()  \n",
    "        tmp_refs = soup.find_all('article')        \n",
    "        for recipe_returned in tmp_refs:\n",
    "            rezept_data.append((construct_link, return_ingredient_list(recipe_returned)))\n",
    "    except:\n",
    "        print('no_access')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('https://www.kochrezepte.de/rezepte/herzhafte-kaese-tarte/',\n",
       "  [['apfelwein', 'cider'],\n",
       "   ['backpulver'],\n",
       "   ['cheddar', 'gerieben'],\n",
       "   ['eier'],\n",
       "   ['emmentaler', 'gerieben'],\n",
       "   ['fuer', 'den', 'teig'],\n",
       "   ['fuer', 'die', 'fuellung'],\n",
       "   ['lauwarmes', 'wasser'],\n",
       "   ['mehl'],\n",
       "   ['milch'],\n",
       "   ['oel'],\n",
       "   ['pfeffer'],\n",
       "   ['salz'],\n",
       "   ['zucker']]),\n",
       " ('https://www.kochrezepte.de/rezepte/leckerer-fruechte-pie-fuer-gaeste/',\n",
       "  [['eier', 'getrennt', 'gr', 'm'],\n",
       "   ['gemischte', 'beeren', 'himbeeren', 'brombeeren', 'heidelbeeren'],\n",
       "   ['kaltes', 'wasser', '1', 'el', 'fuer', 'die', 'fuellung'],\n",
       "   ['puderzucker'],\n",
       "   ['weiche', 'butter'],\n",
       "   ['weizenmehl'],\n",
       "   ['zucker']]),\n",
       " ('https://www.kochrezepte.de/rezepte/pumpkin-spice-latte/',\n",
       "  [['ahornsirup'],\n",
       "   ['espresso', 'shot'],\n",
       "   ['fuer', 'das', 'pumpkin', 'spice', 'gewuerz'],\n",
       "   ['fuer', 'ein', 'glas', 'latte'],\n",
       "   ['ingwerpulver'],\n",
       "   ['kuerbispueree',\n",
       "    'aus',\n",
       "    'der',\n",
       "    'dose',\n",
       "    'oder',\n",
       "    'frisch',\n",
       "    'aus',\n",
       "    'gekochtem',\n",
       "    'kuerbis'],\n",
       "   ['milch', 'oder', 'pflanzliche', 'alternative'],\n",
       "   ['muskat', 'gemahlen'],\n",
       "   ['nelkenpulver'],\n",
       "   ['pumpkin', 'spice', 'gewuerzmischung'],\n",
       "   ['spruehsahne'],\n",
       "   ['zimt']]),\n",
       " ('https://www.kochrezepte.de/rezepte/fettuccine-alfredo-mit-garnelen/',\n",
       "  [['butter'],\n",
       "   ['fettuccine'],\n",
       "   ['fischgewuerz'],\n",
       "   ['garnelen'],\n",
       "   ['knoblauchzehe', 'zerdrueckt'],\n",
       "   ['olivenoel'],\n",
       "   ['parmesan', 'gerieben'],\n",
       "   ['pfeffer'],\n",
       "   ['sahne'],\n",
       "   ['salz'],\n",
       "   ['zitrone'],\n",
       "   ['zitronensaft']])]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rezept_data[0:4]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['apfelwein', 'cider'],\n",
       " ['backpulver'],\n",
       " ['cheddar', 'gerieben'],\n",
       " ['eier'],\n",
       " ['emmentaler', 'gerieben'],\n",
       " ['fuer', 'den', 'teig'],\n",
       " ['fuer', 'die', 'fuellung'],\n",
       " ['lauwarmes', 'wasser'],\n",
       " ['mehl'],\n",
       " ['milch'],\n",
       " ['oel'],\n",
       " ['pfeffer'],\n",
       " ['salz'],\n",
       " ['zucker']]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rezept_data[0][1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "collect_all_ingredients = []\n",
    "for recipe_ingredients in rezept_data:\n",
    "    tmp_ingredient_list = recipe_ingredients[1]    \n",
    "    for tmp_sublist in tmp_ingredient_list:\n",
    "        collect_all_ingredients = collect_all_ingredients + tmp_sublist        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('salz', 56),\n",
       " ('pfeffer', 35),\n",
       " ('zucker', 35),\n",
       " ('fuer', 30),\n",
       " ('butter', 30),\n",
       " ('mehl', 28),\n",
       " ('eier', 24),\n",
       " ('oel', 21),\n",
       " ('gehackt', 21),\n",
       " ('die', 16),\n",
       " ('olivenoel', 15),\n",
       " ('milch', 14),\n",
       " ('sahne', 13),\n",
       " ('gewuerfelt', 13),\n",
       " ('fein', 13),\n",
       " ('gewaschen', 13),\n",
       " ('zum', 12),\n",
       " ('gerieben', 11),\n",
       " ('den', 11),\n",
       " ('parmesan', 11),\n",
       " ('vanillezucker', 11),\n",
       " ('zwiebel', 11),\n",
       " ('wasser', 10),\n",
       " ('oder', 10),\n",
       " ('paprika', 10),\n",
       " ('backpulver', 9),\n",
       " ('rote', 9),\n",
       " ('kartoffeln', 9),\n",
       " ('und', 9),\n",
       " ('frische', 9),\n",
       " ('teig', 8),\n",
       " ('puderzucker', 8),\n",
       " ('knoblauchzehe', 8),\n",
       " ('tomaten', 8),\n",
       " ('geriebener', 8),\n",
       " ('ei', 8),\n",
       " ('eigelb', 7),\n",
       " ('erdbeeren', 7),\n",
       " ('in', 7),\n",
       " ('honig', 7),\n",
       " ('fuellung', 6),\n",
       " ('weiche', 6),\n",
       " ('essig', 6),\n",
       " ('schlagsahne', 6),\n",
       " ('paprikapulver', 6),\n",
       " ('aus', 5),\n",
       " ('zimt', 5),\n",
       " ('zitrone', 5),\n",
       " ('zitronensaft', 5),\n",
       " ('frischer', 5),\n",
       " ('limette', 5),\n",
       " ('grosse', 5),\n",
       " ('knoblauchzehen', 5),\n",
       " ('petersilie', 5),\n",
       " ('scheiben', 5),\n",
       " ('gruene', 5),\n",
       " ('cheddar', 4),\n",
       " ('lauwarmes', 4),\n",
       " ('himbeeren', 4),\n",
       " ('weizenmehl', 4),\n",
       " ('dose', 4),\n",
       " ('frisch', 4),\n",
       " ('zerdrueckt', 4),\n",
       " ('kakaopulver', 4),\n",
       " ('kaese', 4),\n",
       " ('ausgepresst', 4),\n",
       " ('geschmolzene', 4),\n",
       " ('joghurt', 4),\n",
       " ('bio', 4),\n",
       " ('speck', 4),\n",
       " ('nach', 4),\n",
       " ('schokolade', 4),\n",
       " ('walnuesse', 4),\n",
       " ('hefe', 4),\n",
       " ('basilikum', 4),\n",
       " ('g', 4),\n",
       " ('beeren', 3),\n",
       " ('heidelbeeren', 3),\n",
       " ('der', 3),\n",
       " ('spruehsahne', 3),\n",
       " ('butterkekse', 3),\n",
       " ('kuvertuere', 3),\n",
       " ('geschaelt', 3),\n",
       " ('geraspelt', 3),\n",
       " ('mehlig', 3),\n",
       " ('mandeln', 3),\n",
       " ('zwetschgen', 3),\n",
       " ('frittieren', 3),\n",
       " ('trockenhefe', 3),\n",
       " ('bacon', 3),\n",
       " ('feta', 3),\n",
       " ('aufgeschlagen', 3),\n",
       " ('gouda', 3),\n",
       " ('schicht', 3),\n",
       " ('z', 3),\n",
       " ('b', 3),\n",
       " ('cashewkerne', 3),\n",
       " ('trauben', 3),\n",
       " ('weisser', 3),\n",
       " ('bunte', 3),\n",
       " ('geschnitten', 3),\n",
       " ('bestaeuben', 3),\n",
       " ('sesam', 3),\n",
       " ('muskatnuss', 3),\n",
       " ('streusel', 3),\n",
       " ('kalte', 3),\n",
       " ('zitronenabrieb', 3),\n",
       " ('knoblauchpulver', 3),\n",
       " ('kraeuter', 3),\n",
       " ('deko', 3),\n",
       " ('thymian', 3),\n",
       " ('emmentaler', 2),\n",
       " ('gemischte', 2),\n",
       " ('kaltes', 2),\n",
       " ('das', 2),\n",
       " ('pumpkin', 2),\n",
       " ('spice', 2),\n",
       " ('kuerbis', 2),\n",
       " ('muskat', 2),\n",
       " ('gelbe', 2),\n",
       " ('kokosfett', 2),\n",
       " ('koriander', 2),\n",
       " ('mais', 2),\n",
       " ('tomate', 2),\n",
       " ('birnen', 2),\n",
       " ('haferflocken', 2),\n",
       " ('beten', 2),\n",
       " ('zwiebeln', 2),\n",
       " ('zucchini', 2),\n",
       " ('kochend', 2),\n",
       " ('gemahlene', 2),\n",
       " ('eiweiss', 2),\n",
       " ('halbiert', 2),\n",
       " ('cocktailtomaten', 2),\n",
       " ('zitronen', 2),\n",
       " ('creme', 2),\n",
       " ('fraiche', 2),\n",
       " ('schnittlauch', 2),\n",
       " ('garnieren', 2),\n",
       " ('abgetropft', 2),\n",
       " ('schmand', 2),\n",
       " ('quark', 2),\n",
       " ('verquirlt', 2),\n",
       " ('mozzarella', 2),\n",
       " ('makkaroni', 2),\n",
       " ('aepfel', 2),\n",
       " ('gehackte', 2),\n",
       " ('wassermelone', 2),\n",
       " ('minze', 2),\n",
       " ('brauner', 2),\n",
       " ('rucola', 2),\n",
       " ('balsamico', 2),\n",
       " ('ziegenkaese', 2),\n",
       " ('belag', 2),\n",
       " ('pfifferlinge', 2),\n",
       " ('duennen', 2),\n",
       " ('ananas', 2),\n",
       " ('granatapfelkerne', 2),\n",
       " ('radieschen', 2),\n",
       " ('schwarzer', 2),\n",
       " ('naturjoghurt', 2),\n",
       " ('panieren', 2),\n",
       " ('semmelbroesel', 2),\n",
       " ('gemuesebruehe', 2),\n",
       " ('hackfleisch', 2),\n",
       " ('eis', 2),\n",
       " ('je', 2),\n",
       " ('geschmack', 2),\n",
       " ('getrocknete', 2),\n",
       " ('bier', 2),\n",
       " ('speisestaerke', 2),\n",
       " ('200', 2),\n",
       " ('etwas', 2),\n",
       " ('schokoraspel', 2),\n",
       " ('type', 2),\n",
       " ('apfelwein', 1),\n",
       " ('cider', 1),\n",
       " ('getrennt', 1),\n",
       " ('gr', 1),\n",
       " ('m', 1),\n",
       " ('brombeeren', 1),\n",
       " ('1', 1),\n",
       " ('el', 1),\n",
       " ('ahornsirup', 1),\n",
       " ('espresso', 1),\n",
       " ('shot', 1),\n",
       " ('gewuerz', 1),\n",
       " ('ein', 1),\n",
       " ('glas', 1),\n",
       " ('latte', 1),\n",
       " ('ingwerpulver', 1),\n",
       " ('kuerbispueree', 1),\n",
       " ('gekochtem', 1),\n",
       " ('pflanzliche', 1),\n",
       " ('alternative', 1),\n",
       " ('gemahlen', 1),\n",
       " ('nelkenpulver', 1),\n",
       " ('gewuerzmischung', 1),\n",
       " ('fettuccine', 1),\n",
       " ('fischgewuerz', 1),\n",
       " ('garnelen', 1),\n",
       " ('gurke', 1),\n",
       " ('avocados', 1),\n",
       " ('guacamole', 1),\n",
       " ('quesadillas', 1),\n",
       " ('haehnchenbrust', 1),\n",
       " ('gebraten', 1),\n",
       " ('sour', 1),\n",
       " ('cream', 1),\n",
       " ('tortilla', 1),\n",
       " ('fladen', 1),\n",
       " ('kakao', 1),\n",
       " ('zartbitterschokolade', 1),\n",
       " ('grob', 1),\n",
       " ('karotten', 1),\n",
       " ('kidney', 1),\n",
       " ('bohnen', 1),\n",
       " ('rohe', 1),\n",
       " ('tahini', 1),\n",
       " ('sesammus', 1),\n",
       " ('salbei', 1),\n",
       " ('blaetter', 1),\n",
       " ('kuerbisfleisch', 1),\n",
       " ('zimmerwarm', 1),\n",
       " ('vanilleextrakt', 1),\n",
       " ('einfetten', 1),\n",
       " ('weissweinessig', 1),\n",
       " ('griechischer', 1),\n",
       " ('rohrzucker', 1),\n",
       " ('halloumi', 1),\n",
       " ('kraeuterbutter', 1),\n",
       " ('roestzwiebeln', 1),\n",
       " ('spaetzle', 1),\n",
       " ('optional', 1),\n",
       " ('gegrillte', 1),\n",
       " ('abrieb', 1),\n",
       " ('einer', 1),\n",
       " ('frischkaese', 1),\n",
       " ('nutella', 1),\n",
       " ('paniermehl', 1),\n",
       " ('gelatine', 1),\n",
       " ('eingeweicht', 1),\n",
       " ('loeffelbiskuits', 1),\n",
       " ('mascarpone', 1),\n",
       " ('weissbier', 1),\n",
       " ('apfelsaft', 1),\n",
       " ('apfel', 1),\n",
       " ('karamell', 1),\n",
       " ('sosse', 1),\n",
       " ('sahnesteif', 1),\n",
       " ('vanille', 1),\n",
       " ('puddingpulver', 1),\n",
       " ('eiswuerfel', 1),\n",
       " ('gruener', 1),\n",
       " ('tee', 1),\n",
       " ('belieben', 1),\n",
       " ('pasta', 1),\n",
       " ('spaghetti', 1),\n",
       " ('baerlauch', 1),\n",
       " ('ganze', 1),\n",
       " ('italienischer', 1),\n",
       " ('pancetta', 1),\n",
       " ('maisgriess', 1),\n",
       " ('oregano', 1),\n",
       " ('passierte', 1),\n",
       " ('dressing', 1),\n",
       " ('parmaschinken', 1),\n",
       " ('geputzt', 1),\n",
       " ('ricotta', 1),\n",
       " ('rolle', 1),\n",
       " ('weizen', 1),\n",
       " ('maistortillas', 1),\n",
       " ('haehnchenbrustfilet', 1),\n",
       " ('ringe', 1),\n",
       " ('ananassaft', 1),\n",
       " ('geschmolzen', 1),\n",
       " ('natron', 1),\n",
       " ('avocado', 1),\n",
       " ('senf', 1),\n",
       " ('wahl', 1),\n",
       " ('knuspermuesli', 1),\n",
       " ('granola', 1),\n",
       " ('warme', 1),\n",
       " ('warmes', 1),\n",
       " ('gefroren', 1),\n",
       " ('blaetterteig', 1),\n",
       " ('camembert', 1),\n",
       " ('geriebene', 1),\n",
       " ('laugenbrezen', 1),\n",
       " ('vom', 1),\n",
       " ('vortag', 1),\n",
       " ('kirschen', 1),\n",
       " ('entsteint', 1),\n",
       " ('mineralwasser', 1),\n",
       " ('belegen', 1),\n",
       " ('ofenfeste', 1),\n",
       " ('pfannen', 1),\n",
       " ('tk', 1),\n",
       " ('suesskartoffeln', 1),\n",
       " ('hokkaido', 1),\n",
       " ('kleines', 1),\n",
       " ('stueck', 1),\n",
       " ('ingwer', 1),\n",
       " ('kokosmilch', 1),\n",
       " ('kuerbiskerne', 1),\n",
       " ('kopfsalat', 1),\n",
       " ('paprikaschoten', 1),\n",
       " ('gruen', 1),\n",
       " ('putenbrustfilet', 1),\n",
       " ('salatgurke', 1),\n",
       " ('walnussoel', 1),\n",
       " ('schinkenwuerfel', 1),\n",
       " ('babyspinat', 1),\n",
       " ('buchweizen', 1),\n",
       " ('champignons', 1),\n",
       " ('haselnuesse', 1),\n",
       " ('chilischote', 1),\n",
       " ('entkernt', 1),\n",
       " ('feinen', 1),\n",
       " ('steifen', 1),\n",
       " ('kidneybohnen', 1),\n",
       " ('abgespuelt', 1),\n",
       " ('klein', 1),\n",
       " ('tomatenmark', 1),\n",
       " ('erdbeer', 1),\n",
       " ('erdbeere', 1),\n",
       " ('3', 1),\n",
       " ('l', 1),\n",
       " ('gefrierbeutel', 1),\n",
       " ('frischhaltefolie', 1),\n",
       " ('pistazien', 1),\n",
       " ('instant', 1),\n",
       " ('espressopulver', 1),\n",
       " ('2', 1),\n",
       " ('weiss', 1),\n",
       " ('zartbitter', 1),\n",
       " ('rum', 1),\n",
       " ('aroma', 1),\n",
       " ('roehrchen', 1),\n",
       " ('vanillin', 1),\n",
       " ('vollkorn', 1),\n",
       " ('knoblauch', 1),\n",
       " ('schafskaese', 1),\n",
       " ('italienische', 1),\n",
       " ('kalt', 1),\n",
       " ('boden', 1),\n",
       " ('saure', 1),\n",
       " ('dunkles', 1),\n",
       " ('rinderbruehe', 1),\n",
       " ('rumpsteaks', 1),\n",
       " ('ca', 1),\n",
       " ('180', 1),\n",
       " ('ausserdem', 1),\n",
       " ('tomatenpaste', 1),\n",
       " ('apfelessig', 1),\n",
       " ('stueckige', 1),\n",
       " ('grillwuerste', 1),\n",
       " ('mediterrane', 1),\n",
       " ('brunch', 1),\n",
       " ('gemahlener', 1),\n",
       " ('sowie', 1),\n",
       " ('cayennepfeffer', 1),\n",
       " ('kefir', 1),\n",
       " ('donut', 1),\n",
       " ('kinder', 1),\n",
       " ('bueno', 1),\n",
       " ('kinderbueno', 1),\n",
       " ('kinderschokolade', 1),\n",
       " ('oreo', 1),\n",
       " ('oreos', 1),\n",
       " ('schoko', 1),\n",
       " ('pilze', 1),\n",
       " ('risotto', 1),\n",
       " ('reis', 1),\n",
       " ('weisswein', 1),\n",
       " ('fluessiger', 1),\n",
       " ('helles', 1),\n",
       " ('roggenmehl', 1),\n",
       " ('1150', 1),\n",
       " ('1050', 1),\n",
       " ('kokosflocken', 1),\n",
       " ('kokosmehl', 1),\n",
       " ('haehnchenbrustfilets', 1),\n",
       " ('ketchup', 1),\n",
       " ('bandnudeln', 1),\n",
       " ('gekocht', 1),\n",
       " ('schalotte', 1),\n",
       " ('zerkruemelt', 1),\n",
       " ('schalotten', 1),\n",
       " ('kekse', 1),\n",
       " ('vollmilch', 1),\n",
       " ('zartbitterschokolae', 1),\n",
       " ('zu', 1),\n",
       " ('ringen', 1),\n",
       " ('abgezogene', 1),\n",
       " ('frisches', 1),\n",
       " ('pinienkerne', 1),\n",
       " ('pizzateig', 1),\n",
       " ('fluessige', 1),\n",
       " ('weizengriess', 1),\n",
       " ('wuerfelzucker', 1),\n",
       " ('kochende', 1)]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "get_ingredient_counts = Counter(collect_all_ingredients).most_common()\n",
    "get_ingredient_counts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "get_ingredient_counts\n",
    "ingredient_frequency = pd.DataFrame({'ingredient_usage':[i[1] for i in get_ingredient_counts[:50]]})\n",
    "ingredient_frequency.index = [i[0] for i in get_ingredient_counts[:50]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Figure size 720x720 with 0 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX4AAAE1CAYAAADgRYtTAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAIABJREFUeJzt3Xm8HFWZ//HPA4QACXuCCExMGAxICCYxMLKFsEYBERCiYRMiYTGI4IiiLAEENxhQ2QMqi8IAioAsgihhcxkIOGyCCwbND4dNZJUEwvP745y6XbduVXXdvrfukv6+X6+80reqq/p0dfXTp855zilzd0REpH0s098FEBGRvqXALyLSZhT4RUTajAK/iEibUeAXEWkzCvwiIm1GgV9EpM0o8IuItBkFfhGRNrNcfxcgz4gRI3z06NH9XQwRkUFl/vz5L7j7yGbPG5CBf/To0TzwwAP9XQwRkUHFzJ6u8jw19YiItBkFfhGRNqPALyLSZgZkG7+ItOatt95i4cKFvPnmm/1dFKnRCiuswHrrrceQIUNa2l6BX2QpsnDhQlZeeWVGjx6NmfV3caQG7s6LL77IwoULGTNmTEv7UFOPyFLkzTffZM0111TQX4qZGWuuuWaPruoU+EWWMgr6S7+efsYK/CIibUZt/CJLsdHH3dyr+1vw9V17dX/SPwZ0jX/0cTd3/BORwWHLLbfs89c86KCD+NGPfgTAIYccwuOPP97SfubNm8evfvWr3izagKQav4j0qt4KnG+//TbLLdf9EHXJJZe0/Jrz5s1j+PDh/fLj1ZcGdI1fRAaf4cOHAyGITp06lb333puNNtqI/fbbD3cH4JZbbmGjjTZi66235qijjmK33XYD4OSTT+bQQw9l55135sADD2TJkiUce+yxbLbZZmy66aZcdNFFQEhpPPLII9l4443Zddddee655zpef+rUqR1zfd1+++1sscUWTJo0iX322YfXXnsNCPOBzZkzh0mTJjF+/HieeOIJFixYwIUXXsjZZ5/NhAkTuOeee3LfX/rqIv1+//73vzNlyhQmTJjAJpts0rH9EUccweTJkxk3bhxz5szp2K7oGLz++uvMnDmTzTbbjIkTJ3LDDTf08BPpSjV+EanNQw89xGOPPcY666zDVlttxX333cfkyZM57LDDuPvuuxkzZgwzZszotM38+fO59957WXHFFZk7dy6rrroq999/P4sWLWKrrbZi55135qGHHuLJJ5/kkUce4dlnn2XjjTdm5syZnfbzwgsvcNppp3HHHXcwbNgwvvGNb3DWWWdx0kknATBixAgefPBBzj//fM4880wuueQSDj/8cIYPH87nP//5br/XK6+8kmnTpnH88cezZMkS3njjDQBOP/101lhjDZYsWcIOO+zAww8/zNixYwuPwemnn87222/P9773Pf75z3+y+eabs+OOOzJs2LBul6mIAr+I1GbzzTdnvfXWA2DChAksWLCA4cOHs/7663cMPpoxYwZz587t2Gb33XdnxRVXBEKN/eGHH+6oYb/88sv88Y9/5O6772bGjBksu+yyrLPOOmy//fZdXvs3v/kNjz/+OFtttRUAixcvZosttuhYv9deewHwgQ98gOuuu67H73WzzTZj5syZvPXWW+yxxx5MmDABgGuuuYa5c+fy9ttv8/e//53HH3+cd955p/AY3H777dx4442ceeaZQBib8de//pX3ve99PS5jQoFfRGozdOjQjsfLLrssb7/9dkdzT5F0zdbdOeecc5g2bVqn59xyyy1Nc9ndnZ122omrrrqqtGxJuapabrnleOeddzpeY/HixQBMmTKFu+++m5tvvpkDDjiAY489lm222YYzzzyT+++/n9VXX52DDjqIN998s/QYuDs//vGP2XDDDSuXqbsU+EWWYgMx/XKjjTbiqaeeYsGCBYwePZqrr7668LnTpk3jggsuYPvtt2fIkCH84Q9/YN1112XKlClcdNFFHHjggTz33HPceeed7Lvvvp22/eAHP8js2bP505/+xAYbbMAbb7zBwoULGTt2bOHrrbzyyrzyyiul5R89ejTz589n+vTp3HDDDbz11lsAPP3006y77rrMmjWL119/nQcffJD3v//9DBs2jFVXXZVnn32WW2+9lalTp5Yeg2nTpnHOOedwzjnnYGY89NBDTJw4scqhrUyBX0T61Iorrsj555/Phz70IUaMGMHmm29e+NxDDjmEBQsWMGnSJNydkSNHcv3117Pnnnvyy1/+kvHjxzN27Fi23XbbLtuOHDmSSy+9lBkzZrBo0SIATjvttNLA/5GPfIS9996bG264gXPOOYdtttmmy3NmzZrFRz/6UTbffHN22GGHjiuUefPmccYZZzBkyBCGDx/O5ZdfzpgxY5g4cSLjxo1j/fXX72h2KjsGJ554IkcffTSbbrop7s7o0aO56aabqh3ciqzZZVd/mDx5sj/wwAOd8vcHYs1FZKD5/e9/36ttwXV57bXXGD58OO7O7Nmzee9738sxxxzT38XqUz09BnmftZnNd/fJzbZVOqeI9LmLL76YCRMmMG7cOF5++WUOO+yw/i5Sn+vPY6CmHhHpc8ccc8yAr+GffvrpXHvttZ2W7bPPPhx//PG9sv/+PAYK/CJLGXfXDJ294Pjjj++1IN/betpEr6YekaXICiuswIsvvtjjwCADV3IjlhVWWKHlfajGL7IUWW+99Vi4cCHPP/98fxdFapTcerFVCvwiS5EhQ4a0fDs+aR9q6hERaTMK/CIibUaBX0SkzSjwi4i0GQV+EZE2U1tWj5lNBb4CPAb8N/ABYAwwBDjclWgsItIv6qzxO/AasALwDDDJ3Y8EHgG2rvF1RUSkRJ15/Pe4+11m9i7gSkLAB3ga6DLywMwOBQ4FGDVqVI3FEhFpb7XV+N39nfjwJeBlYET8exSwMOf5c919srtPHjlyZF3FEhFpe3W28e8FTANWA74DTDKzbwNDgfPrel0RESlXW+B39+uA9B2M59X1WiIiUp3SOUVE2owCv4hIm1HgFxFpMwr8IiJtRoFfRKTNKPCLiLQZBX4RkTajwC8i0mYU+EVE2owCv4hIm1HgFxFpMwr8IiJtRoFfRKTNKPCLiLQZBX4RkTajwC8i0mYU+EVE2kzTwG9mQ6ssExGRwaFKjf/XFZeJiMggUHjPXTNbG1gXWNHMJgIWV60CrNQHZRMRkRqU3Wx9GnAQsB5wVmr5q8CXayyTiIjUqDDwu/tlwGVm9jF3/3EflklERGpUVuNP3GRm+wKj089391PrKpSIiNSnSuC/AXgZmA8sqrc4IiJStyqBfz13/1DtJRERkT5RJZ3zV2Y2vvaSiIhIn6hS498aOMjM/kJo6jHA3X3TWksmIiK1qBL4P1x7KUREpM9UCfxeeylERKTPVAn8NxOCvwErAGOAJ4FxNZZLRERq0jTwu3unjl0zmwQcVluJRESkVlVq/J24+4NmtlmV55rZMOBuYA6wIeFqYQhwuLurCUlEpB80Dfxm9rnUn8sAk4DnK+7/i8A1yXbuvp+ZHUnIFLqnm2UVEZFeUKXGv3Lq8duENv+mc/eY2Y7A44R+gVVp/Fg8TZj4Lfv8Q4FDAUaNGlWhWCIi0ooqbfynAJjZyuFPf63ivrcDhgEbA0uAl+LyUcDDOa8zF5gLMHnyZDUDiYjUpEpTzybAFcAa8e8XgE+6+6Nl27n78fH5BwEvAGPN7NvAUOD8nhVbRERaVaWpZy7wOXe/E8DMpsZlW1Z5AXe/tNXCiYhI76syV8+wJOgDuPs8QhOOiIgMQlVq/E+Z2YmE5h6A/YG/1FckERGpU5Ua/0xgJHBd/DcCOLjOQomISH2qZPW8BBzVB2UREZE+0LTGb2Y/N7PVUn+vbma31VssERGpS5WmnhHu/s/kj3gFsFZ9RRIRkTpVCfzvmFnHUFozew+aqllEZNCqktVzPHCvmd0V/55CnFpBREQGnyqduz+LUzF/kDAn/zHu/kLtJRMRkVpUmpY5Bvqbai6LiIj0gSpt/CIishRR4BcRaTOVAr+ZbW1mB8fHI81sTL3FEhGRulQZwDWHcCetL8VFQ4Af1FkoERGpT5XO3T2BicCDAO7+TLwpS78afdzNHY8XfH3X3OXZdSIiUq2pZ3G8MbpDxw3URURkkKoS+K8xs4uA1cxsFnAHcHG9xRIRkbpUGcB1ppntBLwCbAic5O4/r71kIiJSi6oDuH4OKNiLiCwFqtxs/VW6Tsr2MvAA8J/u/lQdBRMRkXpUqfGfBTwDXEmYq+cTwNrAk8D3gKl1FU5ERHpflc7dD7n7Re7+qru/4u5zgV3c/Wpg9ZrLJyIivazqfPzTzWyZ+G96ap3m5RcRGWSqBP79gAOA54Bn4+P9zWxF4MgayyYiIjWoks75FPCRgtX39m5xRESkblWyelYAPgWMA1ZIlrv7zBrLJSIiNanS1HMFIYtnGnAXsB7wap2FEhGR+lQJ/Bu4+4nA6+5+GbArML7eYomISF2qBP634v//NLNNgFWB0bWVSEREalVlANdcM1sdOAG4ERgOnFRrqUREpDZVsnouiQ/vBtavtzgiIlK3Klk9nwW+T+jQvRiYBBzn7rc32e59wGeBEcAvCPP7bAcMBY5w99d7VnQREWlFlTb+me7+CrAzsBZwMPD1Zhu5++/d/XBgOjAZ2NPdZwHXAHu1XmQREemJKm38Fv/fBfi+u/+vmVnZBh0bmu0OHAecC+wRFz9NTlaQmR0KHAowatSoKrvvtqLbNTZbJyKyNKlS459vZrcTAv9t8X6771TZubvf6O5bEqZ9SIwCFuY8d667T3b3ySNHjqyyexERaUGVGv+ngAnAU+7+hpmtSWjuKWVmUwlNOkOBW4CXzOwCYEVgdsslFhGRHqkS+LeO/29asYUHAHefB8zLLL6y8g5ERKQWVQL/sanHKwCbA/OB7WspkYiI1KpKHn+nmTnN7N+Ab9ZWIhERqVWVzt2shcAmvV0QERHpG1UGcJ1D405byxA6ev+3zkINJOk0T1Cqp4gMflXa+B9IPX4buMrd76upPCIiUrMqbfyX9UVBRESkb7TSxi8iIoOYAr+ISJtR4BcRaTNVsnomA8cD74nPN8DdfdOayyYiIjWoktXzQ8Lo3UeoODmbiIgMXFUC//PufmPtJRERkT5RJfDPMbNLCHfRWpQsdPfraiuViIjUpkrgPxjYCBhCo6nHAQV+EZFBqErgf7+7d7ljloiIDE5V0jl/Y2Yb114SERHpE1VvxPJJM/sLoY1f6ZwiIoNYlcD/odpLISIifabKJG1Pm9nWwHvd/ftmNhIYXn/RBr70lM2arllEBoumbfxmNgf4IvCluGgI8IM6CyUiIvWp0rm7J7A78DqAuz8DrFxnoUREpD5VAv9id3fiXbjMbFi9RRIRkTpVCfzXmNlFwGpmNgu4A7ik3mKJiEhdqnTunmlmOwGvABsCJ7n7z2svmYiI1KLKtMzfcPcvAj/PWSYiIoNMlaaenXKWfbi3CyIiIn2jsMZvZkcAnwbWN7OHU6tWBu6ru2AiIlKPsqaeK4Fbga8Bx6WWv+ru/6i1VCIiUpuywO/uvsDMZmdXmNkaCv4iIoNTsxr/bsB8Qg6/pdY5sH6N5Rr0iqZzSC/PrhMR6QuFgd/dd4v/j+m74oiISN2qzM7ZEjPbA9gVWAs4DxgPjCHM9XN4HA0sIiJ9rLbA7+7XA9eb2erAWcDy7r6fmR1JmOP/nrpeW0REilXJ4++pEwhTPDwf/34aWC/7JDM71MweMLMHnn/++exqERHpJYWB38zWKPvXbMcWfIOQEno/MCKuGgUszD7f3ee6+2R3nzxy5MgW346IiDRT1tSTzuYZBbwUH68G/JXQXl/mM8COwKrABsCDZvZtYChwfs+KLSIirSrL6hkDYGYXAje6+y3x7w8TAnopd/8O8J1eKqeIiPSSKm38myVBH8DdbwW2ra9IIiJSpypZPS+Y2QmE2y06sD/wYq2lEhGR2lSp8c8ARgI/Aa4n5OXPqLNQIiJSnyo3YvkH8FkzWwV4x91fq79YIiJSl6Y1fjMbb2YPAY8Aj5nZfDPbpP6iiYhIHao09VwEfM7d3+Pu7wH+E5hbb7FERKQuVQL/MHe/M/nD3ecBw2orkYiI1KpKVs9TZnYicEX8e3/gL/UVSURE6lSlxj+TkNVzHSGzZyRwcJ2FEhGR+lTJ6nkJOEpZPSIiSwdl9YiItJkqbfxJVs+dAGY2lZDVs2WN5WpLRbdrFBHpTcrqERFpM8rqERFpM1UC/0zgFEJWD8DdKKunz6kZSER6S2HgN7Mr3P0A4EB3P6oPyyQiIjUqa+P/gJm9B5hpZqt399aLIiIyMJU19VwI/AxYn3AbRkut87hcREQGmbJbL34H+I6ZXeDuR/RhmaSb1P4vIt3RNJ1TQV9EZOlSJY9fRESWIgr8IiJtpkoevwxS6bZ/6Nz+X9YvULSubH8iMnioxi8i0mYU+EVE2oyaeqRXKKVUZPBQjV9EpM0o8IuItBkFfhGRNqM2fqldK+mhSjcVqY9q/CIibaa2wG9m65vZd83sR/Hvfc3sYjO73Mx060YRkX5SW+B396fc/VOpRXu6+yzgGmCvul5XRETK9WUbv8f/nwbGZ1ea2aHAoQCjRo3qw2JJO+jt/gSRwaw/2vhHAQuzC919rrtPdvfJI0eO7IdiiYi0h9pq/Ga2JnA6MNHMvgRcb2YXACsCs+t6XRERKVdb4Hf3F4HDM4uvrOv1RESkGuXxi7SgL8cgqJ9Bepvy+EVE2owCv4hIm1FTj8gg1lfTYbT6WjIwqcYvItJmFPhFRNqMAr+ISJtRG7+I1EaprQOTavwiIm1GgV9EpM0o8IuItBm18YvIUkG3+KxONX4RkTajwC8i0mbU1CMi0ksGy6ytqvGLiLQZBX4RkTajwC8i0mYU+EVE2owCv4hIm1HgFxFpMwr8IiJtRoFfRKTNKPCLiLQZBX4RkTajwC8i0mYU+EVE2owCv4hIm1HgFxFpMwr8IiJtRoFfRKTN9NmNWMxsGHA+sBiY5+4/7KvXFhGRhr6s8e8F/MjdZwG79+HriohIirl737yQ2ZeAW939d2Z2pbvvm1l/KHBo/HND4MnU6hHACzm7LVre6rqBvr++fK12219fvtZA319fvla77a/u13qPu48seF6Du/fJP+AAYLf4+L+7ue0D3Vne6rqBvr/BXPaBvr/BXHYdi8Gzv75+raJ/fXmz9euAc81sV+Cnffi6IiKS0meB391fBw7uq9cTEZF8gyWdc243l7e6bqDvry9fq93215evNdD315ev1W776+vXytVnnbsiIjIwDJYav4iI9BIFfhGRNjMoA7+ZbdCd5XHdmvWVSGTpZmbW32WQ3jNgA7+ZjU49Xiuzeq+CzYqWA3yq4HXMzHboZtnMzCZ3Z5u43ZdTj0/JrBuW7NPM1u3GPjcxs+PM7CQzOym1fD8zOyM+np3ZZuP09qnHO5rZhWb2fTP7XjfKsKaZfdTMppvZ9My6oWb2H2Y2xcymNCt3k21yj7uZnWFm30z/a7ZNat0nS97Xf5jZuWb2vfTxKNuuyXFf28w+bmYHmtmBRa+b2abb50Us354F63ZKzkMz+0SV/UVfzNnX0UXHPa4/wMx+bGbXmtn+mXWtHIuVUv+WqbKu7PiZ2S6pf1PMbLnUunXMbLf4eEJqeR3f/c+a2cXx8Ymp5fumHn8y9dismzErqy/z+LvrZ2Z2gbt/GzgSSAeHA+MbfwVwd5/eZDnA7mb278DLhJVfiP+7mW1mZne6+zvpApjZtYADSW3H3X163GZ74IFsoVPbELdzd58el2+cOoneymz6bWBR3OeXgdll+0tt9xXgZODNzP62AJ6Lj0enyrcSsK+ZfTXu73DC8QXYA/h8Ttkws4OAnVNlSI+8/j5wFWEepqzvAb9O7fPu+P/ngLPyXqtom5Ljfm7OPmiyTbJukpn9gcZ58XjqKbOA/wO+CXyy4na5xz36L8Jx+md6YfyMhwHLA0viS3wors49L+J2txK+wwa8Clzm7tfH8o03s9+kyvdG3OxjwDPx8WTgv1P7+zKwCfmf8dYWRt8n+zsfuBqYDuwGHJI+RtEH3f1jcd/nAj9odiyalONu4O/x8bvN7CfufnqTdYXHL5b5V4Tv17aEzzqZPeB04B/ATcBM4Kj4vsu++0cDl8Tj8md3Pyoub/bd/3fgb/HxynGb2cCHzWy1eBx2AC5LlSE3ZlU1kAP/tcDf4gnzenqFu29iZkPc/a0qy6P9Sl5rK+BGM/sXqcDq7vuUbLN73o+Mu+8TaxzruvvfzGxoavnW7n4vdATgtFeBl+LjjiAetxsOvM/d7zez9TLb/S/wSM4J8HZ8nVWBtVPLzwMmAOsQTvhfp9Y9A6wI5J1MG2YCQdp8d7+qYN0D7p4XmB9190e7uQ3kHHd3f9rMPgts4u6zYq3pK2XbpNb9A9iJGGSAU1PrngVWIByPd2XKUbRd0XEHuN/db8q+ofgZnwqcEl/rP1Orc8+L6LfxfTqhYrQDcH1cN4YQvJLyzYzL/xXLtwyQbf60ks/4jHSRY7n/HitT98TPYHjHjszGAW5m2yTPz8g9Fk3Kcau7nxj3fyqwSoV1ZcfvSXc/M24zgs7n/UvEH7kcRefTKGAaoaKwa/Lk+Plu5e73FezPgRUtXH2vE5e9Qfh8H4vl+lFmm9yYVdVADvx/c/frzOxPwMXpFWb2FcKJvb+Zne3ux5Qtj/agODDMoCCwmtnxhNpHcrInJ+QUMsE95VuEGtyngO8Ah8XlewP3Wpip9AIgfYn7PDDFzM6ka+D9FqHWcj/wJTpfDSxP/glwKaFWfSHwjdS+jqSz9JfyvYSTNlk+M7VuiJltRvwRztSMVzSz2wjBMFtTPNjMdiScyOnybWdmU+P7yp64RdtA8XHvUmuqsA2EQLmZu19iZjtl1v0wlu8LwB0Vt7uU/OMO8LH43Lz3NRZYl1AbHJNaXnZebAi8O7X9H1LrTgAmuvtNZjYxtfxmQu31BsK5mfbvZrYPjc/4ltS69YAJ7n5srI0mV255QQvCuf48sH38+zk6KzsWReUYY2YHxNccAzyY2qZoXdnxczO7JG7zPOH7lfgDoQVhk8xyKD6f3iQE/k8Du2S22SpWTojvKf1+/ytucwDh+w0wkfDDkn3tRGHMqmJABn4LbdD3xv/fpnMAgvDFTk7ytyosh/LAkBtYo3e5+4ycYhYFdwiX60/Hx+lawxUW2n/XAk5MLcfdv2pm1xFqO7/PvFbZ1cBa7v4cgJmlJ2f6PWEa7KF0rhmdS6bpCJgZT+DZNJq1sl4FPkx+zXg5d5+Wt5G7b1pwFVZ44rr7pgVlgOLjXhSAyraBEAT/Lz7eBfh5at2G7v4T4Cgzy/5gFm23sbsfCB3tsr9Lva9tSt7XnLhPSAXkJufFKcDRqcfp4HoajaaKg4GH4v7uMLNHCedFtiZ+F+GKb6WcdUVNWOmg9eXU8h+RaSbN7G9bcoKnmW0NzAdGEr4n6e0+RbjKAviUuy9utq7s+Ln7l81slfDQX82su9DMrojbvZYpe9H5dFH8fx3ClXXauiW18sWE82QosB1wOfBXQivFOnS9akvKUBSzmhqQgR/INrE44ZIn/fe7LXS+rF1hebKuKDDkBlYL8wqtamYzaLRtJrWPouAO4QN5XwwWq8V9JZfKHyS0Rc4m1CQxs2+QquWZmbv7x1P7K6u1fIHQLg9wDI0v3/cI7Zdvx/eetJMfbKGTa5K7/zRVG/wy8G9JEeh6opXVjDcws+MINZSk/Td5L0VXYYUnrpntTjjpVwYWu/seqdcqOu5FAahsG2KZF8XH2ea3sbE9932EmmnpdmXtsta5rwboUut7mdBuPBT4D+LstPHH48OE2mnH1ZSZbQWsCtwZt/93d0/PaJvbVGFmPyQ0YS2K5Ukfq2cIn/FXrWvHb24Tlrv/FTgu+zqEGn+2gpGuLBQFz9WBbKBN2s+TIAih1v2F1FO2IfQ1DCUkecyM2xUdv2/S+AGzuK7j87DQzzAOWCa9XVR0Ph0e3+dwYDwhiCd+H+NB8h25PLXuTEJ/RxKDcPczzewqd/9/2WMRlTVhNTUgA7+7n2Khh30imdqHhWyfOcC+hDa1dE0svTz7C5h3OZVIB9YlqeUjgF8CQwg1kPQXNx3cV8/s71eEE2/7+JrQ6IDMa7ten3CyLE8jUHdoUutLv/aI1OMH3D1b60gktcGfEmuD7j6n4AchUVYzPjtd3Mx2RVdhZSfuh4HHga8Rmk3Sio77KoQfWafzFU7ZNhD6OI40sy1JdT7Gq82bCE2CfyZ0YDfb7tFYhkfJtMsW9f2kdPnyR1PcPS/7Zo34L6lVZ497uqnif1LL/+bueYEaSjp+KW/C6iJ+h99PcWUhN3i6e9EEjlcTvh9FUw0UJSbkHj+PyR0AZrYyXX/Yzd2L+gVzzyd374grZnZMZpudCJWARXT1gLvfnLP8AAvZWa8DIzJXwmWVwaYGZOCPziP8wt8PbEbnbJCXCUEhaz93vwDAzE4Hjk+t247Q/JE8Tv/iXkaYPXQZOp+El8UTNq8WdDyNzr3z6Ww3d18rluMC4MdJB6SHLCXM7NPJdjEonAKc4u7vmNnn0zszs1nxtdxCT/6FqdVXm9mPCR/+d1PLy9rJizquuvwgpNaV1Yyn0jkA3Z1aV3QV9jywTc6PLcCLhNrg5oR27LQTgB0Jn1X6uH8Z+Ex8/B06d+bnflYWOthvIrR7J2VN7BP//t/4995kOn7dfUrqb9z9LjN7k1DpcEI/zrOpp5Q1Oc3PfvktdJC+ZmZbkMkeij/ORecmwBXxn9G4IjkD2MzMLiKT3RaVdfwWNR2WKasslP0Yd+GhI3lHwueQNFOlr0i7JCaUHb+4/hTC53ApYT779CSSZf0d6XPwgtT+zojlWo5wNZb2O+Amz8/CKervWBv4WayUpTv8m1UGmxrIgf8V4EV3P9XMjk0tT9q+1iUnY8FC7us44J7M/pITcBihRpkO/J9y91Oh4xIw/WXoUgtKXXYSy7BdZpsVzWxU6vUSo1KP35Mp34bAemaW7dwD2DQ5GczsW8nCGLjuBZJsgY7A1aSdvKg2WJbJkK7hZm+bmdQMhwGCCe4lAAAaBElEQVQfz6xLrsL+jXh1Zo30xaHApnStsZxHuPLZn1DDTDvB3U82s2UJgejwuPxJYpYF8MfMNvvHMl5KaEY5OfU6mxDarhcTPpNJcd0VhEBSVMPc2MLNgxYAP0wFlCMIaYLJj8xvUtuUNTntFQNbEmimE4LcPwhptNC1uaSshn424QdoDULa7H6UpL1GZR2/uU2HTZRVFr5L6HfrFDybKEw3JiQmfIPOMaHZ8VuNEAu+Qtfm5btimfP6O35ION9+6O7pSsuPCX13y9JILU1MBm6IFYNOFTF33yZedZDpa3iB0NR0IuF70qGoCauqgRz4HwGWmNnNwMLU8peB/3L3dE4wZrYLoRY5G/gTmcFp7n5b6rkbph4nObZJ5k66LwHya0HN8pdPplH7TGcPLYlt3p4tH507987JrFvVzLaNj9dILT+PnI7aWN5PAh9K1qfaNj9GqH106riKy18Adsv5QcDdrwGuIUe6bTnuJ20y4YfRCT84v/BG+uLJeVc4cZtbCJkqiwlpbYnfxorA+sTOtPgZDiUELKPreIJNCM1ul9PIMkn6O05z9xPifj6b2mYnQgpnunPy1NS2F5jZhYTjfRehKZDUc0ltmyir5Sbn+DBibTE2l2zp7r+K5dsis01ZDf1rhEC/ErHZ05unvS7v7rvHfWZvj1rWdFikrLKwp7t/M2ebMmXpxienHifnfLPj9zQw3t1/YGbbZdbdRriSzTbJ4e4ft5DGur+ZTXX3ZNtDCFfJc+mcsYe7f7ToTZnZCcSKoJn9LamEuvtpZmaE9OtvZTYragKsZCAH/vGEN7sbnWvNexACYccvYLxcTdrgr46LO9q7YzA6gvDr/w7wcGrbTjm2FvKO024l1FRvo9FBWpi/HNf/GTg2sx/c/Qtm9r74OJth8CSNTtqsowlZMMnjxBGE2kWeKZ6fjXRg3OYWADNLOmOT5T8kBKzsYLZzCMc0m9aKmd1B49jelXm9A2LZjZCW+4u4fCzFVzhbE/oAfgFsmXqdpN9mZ8KV3xaE/olmYx1WAQ4i/EDvllk3xsLI0beAjVLL5wKfcfdszTcpyzcJVzG/JNQ2iV/S3xNqx0aqhm2hz+Q8YochmVpu+rPK/ADtSahpA3yEzuMufkEYcHQDqSvY+EMIsAGh2WwuoaICBdltFhIZZoS3gBGu0m5MvVZZ02GRdDPavzLrygZbFklq9Yl0U09Rx2rZ8fuZuz9uIQ00ewUzlzAYK9vnkjQh7U+ofKQrQ+lxH2unnv9NwpXkP4iVAe88RmgND/ciTyeBpAeEnUboZ0oGhJU2YVUxkAP/KsBHCTWX9HDvTxCC1E9J1ahie/xuHgeFmNmHU9scSOhATIJSurN4Y8IJn3zAM+ncTHQE4WTJ1iLLsoRyWSNbZRUzW+Sds1XKrEP4kg4l/AglNc8vEb7ISbMJwC5NToxj4j6yVzbHEN7rI+SndL5Z8EMC4ZJ5PqGdfU6yMDZFLSQ0yzmNZgkov8L5N8IV08GE7I3Eo5n/05fgZeltn3H3xfHH+uTMa11NaAJ6J72Ne8foyLyMLoBz3P1v6R3FbTYh/Ki+Quers88QgmbSx7AhoQMb6LhihfCd/EBqu3fFcjup8ywG6k8QmsKM8AN7bSxH2cDDovN2BCE4JwOZvpp5b0VpuWUKR9p6+WDLIofSaLa5Lb2ipGM19/hFB5rZlYQAvh2dfxR+5+43km8vYK67/yWzPHfcR6zwPUDjO3JyZrvV4hW60/nKLXdAGM2bsJoayIF/HiED4mEz62izdfdXzeyfhC9zMpgkuQTdllDLgJDedWt8XBbU9iF8CfcmnPBXZ9Y/6u55Hcll6YNFyrJVyuRObxA7fX5CaJZJ/zAVnhju/pSZPefud2X29RQ5VynQUdMea12H7CduJRz3S4npalHyuZxCJvOkyRXOQcDa7v6KhU76ZJu7zOxAj6lwMSgnyrKETo99I6cR2tnTFYnd3H2NuL8L6Pz530HI6EpnS3WkZqZqx+ka6x2E7JOOq6PoNkKtdO/UsUh/WZOmokV0nhfnBBo/SHNSy9OB2skEajM7xd3nxMfHe2Nqg9zstlhxupGQgjqM0LzwcGp/ZYMjixSOtG1xfxcS4gKEZr6O+bes0bE6hM6dz0XHD0LzymGE72PH68fPd4SFQYmdrkjid+EfhLRdoPFdSFWukgpNWtF3hPj6Y6FjCpVE7oCwCk1YTQ3YwO+pKQDc/eLM6qLBJCPj5aPTGNFYGtTiQdw2vSjzlLfM7OeE/oOOJg4vzl8uU5atUqZseoMuP0xekg4b5c27Uvr6NGrZeR5299+a2UI6Dz462EKKaN4I0jJn0sh+OZXO2S/jU483JaRAQnl6W9HVIxR3xEMY/Tk77q/jGJXVqN39soJVo4DvZvumqmzn7l+0MJHdB4idw/H5RdtA5z6EdC3yJOBYd3/JQiZQukP4LEJM+DkhayWdAFE2OLLIGCseadvK/l5x9ysALKSKpiXNaovc/f/ic5KxDkkzzjganesQMrZ2cPeFZpbO5iu7YnqUrv1qVeR+R6Lc/g4PA8zWJn9AWFkTVlMDNvA3UTQfylE00viOzm5UImnbHUZoX063963t7tkc5FaVZauU2c6KpzfI/WGiOB0WcuZdKdOkpo27J00M/4+QaZKWO4K0ibLsl1XM7FOx3B1NKV6e3jaPnKvH6GTyO+Ih1L6+SGhG+xah3RsAM7uKRpvyqu6+LeW2AdaPzX15k+0V2c3M3iZkpe1ISDuu4q9mdhnhRyt9PAw4L15JbZzZ5jnC8bs8p5+kbHBkkbKRtq3s7yUzS1KWOwJ4qrYf/zSP/X7NxjqsQ6NZt1M/XTzHphNi5LLuPhU6vgtzMvtsmuHU5DuS298R3+s/aGRSpVsWypqwmhqsgf9SGoNJ0r+U6cvFz1Kx3cvdk6HWSQdd2kqxZpSMuLuF1q1JaKtbgXAJ99vyp3com5ej6IepKB0WiuddKVNU026mLEW0SFn2y6dpNGF9GjqNwrT4dzao3grsZKETt9MAmqKO+OhPhCakN8ikiGY6Y5tWMtx9dzPb1fMH6pQZQ/hh+ixhBHElHkZ+DouP05McPkP4MT6LTIogoQ9siZldT9c+oC5puWWsa8pzdqRten9Vpxt4h3A+OCG7J5FNU00SEJqNdSjrp5sA/NpD6vAXMuvK0pdbMS3+IJD5fj/m7mcVbFPWhNXUoAv8ZvY14GmP86FktPSBxDY9I9Q0F2ZW30mo8Y3MbteCoimUmynruCz6YSpKh4XyqYOL5Na0Kyib7KpI2eC4S1KP9wFmeudBSHnOprgJo8z2sRzLAIvN7JpUbSzdGTupYPusZc3sGkIAu8rdb6iwzWxgqLu/YGFCsUrSVyRmlr4iuczdFwGzzewjmc1uJzSHfI2uteMuablNitAs5fkjhGkmsv10ZdZy97x7bhyZU97knCgb61DWT/dPYHkL9xHo9Pl6efpyK5ImTQitFknZPxpr9cnYjvR5ntsEWNWgC/yEtvuPWEgtc1KXRj34QJLmEKMx0Iu4z7J21O4qmkK5mbKOy6IfpqJ0WCifOrhIl5p2FV4+2VWR6YS03WUIzUPp2nvS+TWMMF8+ALFZYwmhKWmeuz+S2qasCaOs7NnAmJakD2c7Y8vslvrhuICQhlkodSWTXIk6nY9FoZIrkq3N7DQa/SDpKRKuISQKvBVfKz2Woygtt+j1S1Oe6Wblw8rnzSobmFY41qFJP91XCcfgw9nnWGPepXfIZBd1l3UeRwSdr7TKblDTahMgMAgDv7sfZI2pkoeQOjmtPJ+8zMikQyd2DvY6K59CuZmiuYTKfpjKOjQvpRvzrkRFo18LWeeJsJIxA1Xe807eeZK6tGTcwtt0vjyfScj5P5qQFZROibyPcGX0E1IplM1YmHiuaK6UdMfvY3QdqZmnrCM5zxeBye5e9UqpQ8kVyTZePPDnMXf/es6+ytJyy5Q1pXS38pHMm7U8mUqOlw9Mu5NwxZE3GrnMdEJz5nTg/XQ+36cTvgPu7lWba3N5GIOyrudPxlY2lXxLTYCJQRf4o8VJjSYTqHPzycvEmsS7U9kHVWvA3eLNBxmV+RZxLiGvPlBjHsUdmqvQmNen6rwruaNfm/giIWsiO5d9M/fHTr+k+SrdB5E0CbwJ/CS1fCFhwNExsSaXtjxhVtTXyBmJWaJwrhRKOn5LnEyjI7lp/5O7u4URpd0O/OSkh1rzgT9liQKQk5bbRFlTyqXk99PlqnDlXTTt+vLAXwjNk9PoPF9QmU0Iqa155/s5hD6f5c3sUHfPva1rFbFyNMnM8gZ3lU0l31ITYGKwBv5xFubkWY4QtHeJl31lubJFRhBOhmQKhaonRitanUP7XMLl93Vm9kSVpiIvT4dNagh5WUxFyka/FpXBzWyymf2ym81bUwm19KQjNl2+X6ZS+v4jtXw04a5EZ8Qa1NapdcvHff0fjS9SFS+El+k6VwolHb8lprn7sbHsR9N1GH4nZrY38PWY8ZEE6qpXidvQNW2z2cCf3EQBbzEtt0lTyrOEqy8n07zaoqKri+UJlYT/o2tfV5my8/1Jdz8HIDabtczLB3flvqeeNAEmBmvgv5PQzAOhQyoZYFOWK5url9vwm2lpDm13nxmvFj5JqH1t0JNCNMliKtqmI5fezPIGqBRp5RZxT3jBVAnAJy2kth5FyJBKLrVvJnRw3U/XkcDbETrr/khjAFAV/yKMuRhJY977xPY0Zmh8K93xm8dCyuEWFqYVN0JtrjTwE2rKtxKn1+imLmmb3nzgT1kGWytpuWXOppFWfBaNKUlaVTTtequffZIhuAxdB2R93MzGE2LQe83smxUSDMoUVViL3lPLTYCJQRn4i4J1k1zZgaBsKuJCsdljT8Iv+2eaPL3K/tKdU0U3eshu06m9m6414CKt3CJuWzP7GY0AlA6ovybMjf9dYjtxtAah1nQWodZ0b2rd5wg14JmEq6zs4J8iyyR9DTl9P7O8MVBoQ+98E5Q858X3cznhuFep5TabRqNMUdpm2cCfO2mMOs5qJS23zJPuPh8gpymyFUXTrrf62Zfd2L3s/t2tKKqw5t2Zq6dNgMAgDfyD2DaEWsIk4GUz28Pdr2+yDYTc5c+4e/ZmES3x8pGJRcrau8t0q3krXoGcVtIvcLeHaSdm0fmy+GZCrekyujbzfYUwUOdwd3+hG2UvalIEOC0eh3cRmjMOLtoJgLsvsDA/U+W0Oy8ZcV4mHsOfFqRtlg38uZfGZGdzM+taScstKt+1wFpmlmQGFU002B1F0663+tmX3dh9bUItfCUIV+Q9KHdZhTX35jw9bAIEFPj72m8JJ6IThs7vQLilYaHYFrwuMN4ac4P05LKyWepjkWRu8BOoXmuCbjZvpfoFfuHueZ2Ia5nZGTH/Oz1JVmEzn7t3ZxR3WlGTIoTL7e8QjuNhVNPKjJTdFo/hVGLGm3e+q1XZwJ85NG5edBqp3PsW03KLytdKxaPZPnOnXe/BZz/GiqebmEX4ofkmXccn9KbCO3PRehMgoMDf1zakMYfQWBpzlZRJbjnXm8pSH3N5Y27wiXQvLa6V5q2tgJ8W9Auk8787bmZTRzNfUZNiqqlsBCFT6AdU6Fxz902aPacX7V7wIzOVRkrrtnQezLbI44yj8dgTH7ealpsrHr91CQkLiwlTXmzeg/0VTrveA2XTTaSnX35XL7xWkaI7c/WkCRBQ4O9rp9CYQ+hUOt+Wr8jnKB6V2Kqy1MdcmauEtwgnXRXdbt7y8oFTrQw+61UxNXdZj3dfsnA3sKas/CbyvW0K+ff3Tc65vDvR/dTMfkQ439KTybWalpsrHr/0DXBarZUnCqdd74EJhOOzEqmbt0e50y/3Ni+4M1erTYBp2btASY3c/Ql3/3z894S7d7nJQ45zCYF6NKGGW6kztonRhCuJM8zs3ibPTcwkdKpOJWQfVPVbQv70jsTZEJttYGbHmdlvzeyXZpatvV1KyGq6kJD10F/SE92dXviszpJpufeg8y0Z6/AtGn0g6RlTb4v/rgOeSpZbGM8ynXATmUtJZdnEJrfJFka/9pYNzGzbmFm0UdNnlzuG0LH7CGH2zOw8Q62YRWiinEMYB5C2obv/2d2PIsx7VYvYrHoWcJaFqRl6jWr8A5yHUYmbeOeh/j11LuFH/34qDJ6Jun2VELXSvJXbkWzhpjmLaYw27o2aXavS95DNTkdQpNVpuVuRO8NpJqMr/aNaOr8/raXlljmK8ENjhPvUtqw3asA5yppzxprZ9oTxML2ScFEg985cvUGBf3Do7lD/Zv6TUGu5Pw7MqWI0xQOkyrTSvFU0cGofGsE+72Ymfek+C9NAv0Pj5j/NvAF8m9A5N6rJc3sqd4bToo5Vbz6/fytpuWUO8u7fc7cv5TbnxMrHTYQkjT8TroLrUnRnrh6z/MQJGUhi+l0yOdlcd+9R3rOFId6L3H22mZ3n7k1HEJvZxYSrhN8DdyY52HWItfyOgVPu/pW4fFzmqe7dvNdofzKzgwhXLOMIk5f9rMbXWpbGDKe3eRw5bQXzzFfYX7fPmSb7u5fQJJOkI/a036rXWGOeI2jcOyG5R3V6Ln7iuloqH2b2Xhp35ro908HcI6rxDwJePmd8K1oZQdzKVUKrigZO7c0AqfFnB7R55wnc8p6/CyHDaTZhuofa+tdSzTlJcErPcFo2z3yZlkadl7iW4imb+1syz1FerfgKwr0A+qLGnHtnrt6gwN+eWkmxPIvGQKwvU32eoVYUDZxKvnSJ/rxc7e6AtiSYJPf0zRsd2yti1sxJhA7wRYSblCf+CQy1nHnmm2hp1HmJsimb+5WH+w+/m5DuOpTO59lOhDb/jho/9VU+ahv3ocDfnloZQdzbNb4yRQOndiIE3PQXsb/a+MsmcOuiaExAjd5L+LyW0DntNclA2oXu3TO61VHnRcqmbB4ILiLc9CebeTeXMIq+O2NZWlV0Z64eU+BvT90eQUzv1/gKFQVJd7/IzFYgNFdka2J9bTFhTvaVady3dSCZS+isXUIIYl3uTUuYqrpqc08r50yZsimbB4LfufuN2YVxVPRmln9DmN5WdGeuHlPgb0+tpFj2do2vVZcQJhZLbkBdZUrpOox0949BfTfv6SEjBnwa/QnJnarSwb+qVs6ZQl4+ZXO/in0kI8zsNvKbWe4gfBdqa66z8jtz9ZgCf3tqJcWyt2t8rZrv7lXuz1ob66Ob9/RQl3suxPb0AwgDyN4h3JWq6qRxrZwzg1KFkdnpu69l7wndm2UoujNXjynwtyF3fwL4fDc369UaXw8cbOF+y9n5S/pSX968pyVefM+FD6auVM6l89QMZftr5ZwZzM4gTJcCoV8kfXXSyt3XusXK78zVYwr8UtWAqPE1S5vsozL0dUdtt8WmAiO08S+My8YBbmbb0L/9I4NB2cjsVu6+1i1efmeuHlPgl0oGSo2vjyc6G8x+A0wmtEUnc9XvTeik347wo/B8/xRtUPhVHJntdL6pD4S7r+1EuOJbbE3uvtYDrdxKthIFfhlskonOvkbjUly6WsbdZ0Cj89nDrRfXIEy/4IT78Eq+8YRMmjPITFveZPbY3tTtW8lWpdk5ZbBJT3TW01kdl2bjzGxfMzuQOAguLj+bMDnbI/Gx5FsF2J1QwXgmvaLJ7LG9Jn2PiaRfprco8MtgsyWhiWIzoDdmKl1aJYPgjM6D4F5193vc/R7CKF7JNw9Yyd0fpms7fjJqe3vKJ7YbsDRJmwwqMUNle8JdtlZy94P6t0SDi5kdSrg/wjvAL9z9wn4u0qAT58lPMqU27c1sm76iNn4ZbFYjTEewBrCgf4sy+Lj7XLreSF2651+kZo/t57K0RIFfBpuvESY6u8h1udptZnYWqUnG3L3Xc9DbQNHssYOGAr8MKu5+ePNnSYm/u7uyoXqmaPbYQUOBX6S9bB0H8r4O4O61TDmwlCuaPXbQUOeuSBsxs08TbkhuwFfdfat+LpL0A9X4RdrLG8B6hNs/ntbPZZF+ojx+kTaRuv3j/oQpL7ozLbMsRVTjF2kffXb7RxnY1MYvItJm1NQjItJmFPhFRNqMAr8sVczsV/3wmpea2d7x8SVmtnGL+5lqZlv2bulEulLnrixV3L1XAqeZLefub7fw+of04GWnAq8Bff7jJe1FNX5ZqpjZa/H/qWY2z8x+ZGZPmNkPk3vPmtkucdm9ZvYdM7spLj/ZzOaa2e3A5Wa2rJmdYWb3m9nDZnZYfJ6Z2blm9riZ3QyslXr9eWY2OT7e2cx+bWYPmtm1ZjY8Ll9gZqfE5Y+Y2UZmNppwL9djzOx38faIIrVQjV+WZhMJA5WeAe4Dtor3Mb0ImOLufzGzqzLbfADY2t3/FacwftndNzOzocB98UdhIuHm8+MJE549DnwvvRMzGwGcAOzo7q+b2RcJdww7NT7lBXefFEfSft7dDzGzC4HX3H1QTvwlg4cCvyzN/sfdkxuN/w4YTWhKecrd/xKfcxVwaGqbG939X/HxzsCmSfs9sCphSugpwFXuvgR4xsx+mfPaHwQ2JvxYACwP/Dq1/rr4/3xgr5bfoUgLFPhlabYo9XgJ4XxvNlr19dRjAz7j7relnxBHwDYbAGPAz5P73paULSmXSJ9RG7+0myeA9WObOsDHS557G3CEmQ0BMLOxZjYMuBv4ROwDeDewXc62vyE0LW0Qt13JzMY2KdurhKkURGqlwC9tJTbjfBr4mZndCzwLvFzw9EsI7fcPmtmjhL6B5YCfEO7D+gjhvr935bzO88BBwFXxhty/ofnN4X8K7KnOXambpmyQtmNmw939tZjlcx7wR3c/u7/LJdJXVOOXdjQrdvY+RuiwvaifyyPSp1TjFxFpM6rxi4i0GQV+EZE2o8AvItJmFPhFRNqMAr+ISJtR4BcRaTP/H5AlkYqRdJezAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.figure(figsize=(10,10))\n",
    "ingredient_frequency.plot.bar(fontsize=7)\n",
    "plt.xlabel('ingredient')\n",
    "plt.ylabel('food item usage count')\n",
    "plt.show()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}