scrape-zimbabwe.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "from  util.spider import Spider"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "attrs = {\n",
    "        'name'       :  'name',\n",
    "        'ingredients':  'recipeIngredient',\n",
    "        'total_time':   'totalTime',\n",
    "        'instructions': 'recipeInstructions',\n",
    "        'servings':     'recipeYield',\n",
    "        'category':     'recipeCategory',\n",
    "        'prep_time':    'prepTime',\n",
    "        'cook_time':    'cookTime',\n",
    "}\n",
    "attrs_xpath = {\n",
    "        'name': 'normalize-space(//meta[@property=\"og:title\"]/@content)',\n",
    "        'ingredients': ['//ul[@class=\"ingredients-list\"]//text()',  '//div[@class=\"note-content\"]//ul//li//text()', ],\n",
    "        'total_time': '',\n",
    "        'instructions': ['//ul[@class=\"directions-list\"]//text()', '//ol[@class=\"instructions\"]//li//text()', '//div[contains(@class,\"entry-content\")]//ol/li//text()'],  \n",
    "        'cook_time': [ \"normalize-space(//div[span[@class='detail-item-label'] ='Cooking time']/p//text())\", 'normalize-space(//div[@class=\"box\"]/span[@class=\"time\"]//text())'],\n",
    "        'servings': [\"normalize-space(//div[span[@class='detail-item-label'] ='Servings']/p//text())\", 'normalize-space(//div[@class=\"box\"]/span[@class=\"persons\"]//text())'],\n",
    "        'prep_time': \"normalize-space(//div[span[@class='detail-item-label'] ='Prep time']/p//text())\",\n",
    "        'category':'',\n",
    "}\n",
    "listing={'items': '//div[@class=\"post-thumb\"]//a/@href', 'next': { 'next_page_str': 'page/{}/', 'type': 'url'}}\n",
    "seeds = ['https://www.zimbokitchen.com/category/meats/', 'https://www.zimbokitchen.com/category/vegetables/', 'https://www.zimbokitchen.com/category/snacks/', \n",
    "'https://www.zimbokitchen.com/category/starches/', 'https://www.zimbokitchen.com/category/soaps/traditional/', 'https://www.zimbokitchen.com/category/baking/' ]\n",
    "#available_json = {'xpath' : \"normalize-space(//script[@type='application/ld+json'][contains(text(), 'recipeIngredient')])\"}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "zimbokitchen_spider =  Spider('https://www.zimbokitchen.com', seeds=seeds,listing=listing,attrs=attrs_xpath,available_json={})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'name': 'Baked BBQ Sauce Chicken Thighs - ZimboKitchen',\n",
       " 'total_time': '',\n",
       " 'ingredients': ['2 kg chicken thighs',\n",
       "  '1 3/4 tsp salt',\n",
       "  '1 tsp onion powder flakes',\n",
       "  '1/2 tsp dried thyme',\n",
       "  '1 1/2 tsp paprika',\n",
       "  '60 ml Mr Sauce BBQ sauce',\n",
       "  '3 tbsp oil'],\n",
       " 'instructions': ['Get your ingredients together. Combine the oil, salt, paprika, thyme, and onion powder flakes in a bowl. Mix until just combined.',\n",
       "  'Put the chicken thighs in a marinating container. Pour the marinating mixture onto the chicken, and massage it evenly onto each piece. Close the container, and refrigerate for a minimum of 1 hr, up to 24hrs. ',\n",
       "  'After marinating time, preheat the oven to 180 degrees Celsius on bake. Place chicken on oven tray and bake for 40 minutes.',\n",
       "  'Remove chicken from oven, and brush half the BBQ sauce on one side of the chicken, and return to oven for 5 minutes.',\n",
       "  'After 5 minutes, remove the chicken from the oven, flip it over, and brush the other side with the remaining BBQ sauce. Return it to the oven for another 5 minutes, and the chicken is done! Enjoy!'],\n",
       " 'servings': '7 – 8 servings',\n",
       " 'category': '',\n",
       " 'prep_time': '60 min',\n",
       " 'cook_time': '40 – 45 min'}"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zimbokitchen_spider.scrape_one_item('https://www.zimbokitchen.com/baked-bbq-sauce-chicken-thighs/')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'name': 'Mr Sauce Peri-Peri Beef Short Ribs - ZimboKitchen',\n",
       " 'total_time': '',\n",
       " 'ingredients': ['2 kg Beef short ribs',\n",
       "  '\\nMr Sauce Peri Peri Marinade',\n",
       "  '\\n1 tbsp garlic, finely chopped',\n",
       "  '\\n1/2 medium onion, sliced'],\n",
       " 'instructions': ['Get your ingredients together. Put the short ribs in your marinating container/bowl. Season with salt then add the onion, garlic and the Mr Sauce Peri Peri Marinade (be as generous as you see fit and as much as you can handle heat!).',\n",
       "  'Gently massage the marinade onto each piece. Close and marinate for a minimum 2hrs up to overnight.',\n",
       "  'Braai or grill the short ribs at 180 degrees Celsius until done (about 30-40 minutes in the oven, depending on the thickness of your ribs). Enjoy!'],\n",
       " 'servings': '5-6 Servings',\n",
       " 'category': '',\n",
       " 'prep_time': '',\n",
       " 'cook_time': '~ 30 - 40 minutes'}"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test2='https://www.zimbokitchen.com/mr-sauce-peri-peri-beef-short-ribs/'\n",
    "zimbokitchen_spider.scrape_one_item(test2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'name': 'Simple Chicken and Vegetable stew - ZimboKitchen',\n",
       " 'total_time': '',\n",
       " 'ingredients': ['1 whole chicken/ chicken portions (1.5 kg)',\n",
       "  '\\n1 tsp salt',\n",
       "  '\\n1/2 tsp frshly ground black pepper',\n",
       "  '\\n1 tbsp Worcestershire Sauce',\n",
       "  '\\n1/2 tsp paprika',\n",
       "  '\\n1/2 tsp curry powder',\n",
       "  '\\n3 tbsp cooking oil',\n",
       "  '\\n1 chicken stock cube',\n",
       "  '\\n1 small onion, chopped',\n",
       "  '\\n5 cloves garlic, finely chopped',\n",
       "  '\\n1 large tomato, chopped',\n",
       "  '\\n150 ml water',\n",
       "  '\\n3 medium carrots, chopped',\n",
       "  '\\n1/4 punnet green beans, chopped',\n",
       "  '\\n1/2 punnet mushrooms ',\n",
       "  '\\n1/4 large green pepper, chopped',\n",
       "  '\\n1 tbsp cornstarch',\n",
       "  '\\n1 tbsp tomato soup powder',\n",
       "  '\\n50 ml water'],\n",
       " 'instructions': ['Get your ingredients together.',\n",
       "  'Cut your chicken into pieces. Heat oil in pan and add the chicken pieces. Season with salt, pepper, paprika and ',\n",
       "  'worcestershire',\n",
       "  ' sauce. Fry until the pieces are browned. Crumble the stock cube and add to pot, stir.',\n",
       "  'Add onions, garlic and curry powder, fry on medium-low heat for 2 min.\\xa0 Add tomatoes and close pot, let it simmer for 3-5 min.',\n",
       "  'Add water (150 ml) and simmer on low heat for 10 min.',\n",
       "  'Add your carrots, green beans, mushroom and green pepper. Combine gently, close pot and simmer for 5 min.',\n",
       "  'In a bowl, combine the cornstarch, soup powder and water (50 ml). Mix until it forms and smooth paste. Add this paste to the chicken and vegetable stew. Simmer for a further 5 min. Enjoy!'],\n",
       " 'servings': '4-5 Servings',\n",
       " 'category': '',\n",
       " 'prep_time': '',\n",
       " 'cook_time': '~ 55 min'}"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test3='https://www.zimbokitchen.com/so-simple-chicken-and-vegetable-stew/'\n",
    "zimbokitchen_spider.scrape_one_item(test3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "spider is scraping page: 1\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 2\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 3\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 4\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 5\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 6\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 7\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 8\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 9\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 10\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 11\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 12\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 13\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 14\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 15\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 16\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 17\n",
      "Cannot open the menu url, status code = 404, url= https://www.zimbokitchen.com/category/meats/page/17/\n",
      "no items found for page: https://www.zimbokitchen.com/category/meats/page/17/\n",
      "spider is scraping page: 1\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 2\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 3\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 4\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 5\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 6\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 7\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 8\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 9\n",
      "scraping - multithreaded, n items:  8\n",
      "spider is scraping page: 10\n",
      "Cannot open the menu url, status code = 404, url= https://www.zimbokitchen.com/category/vegetables/page/10/\n",
      "no items found for page: https://www.zimbokitchen.com/category/vegetables/page/10/\n",
      "spider is scraping page: 1\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 2\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 3\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 4\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 5\n",
      "Cannot open the menu url, status code = 404, url= https://www.zimbokitchen.com/category/snacks/page/5/\n",
      "no items found for page: https://www.zimbokitchen.com/category/snacks/page/5/\n",
      "spider is scraping page: 1\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 2\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 3\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 4\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 5\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 6\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 7\n",
      "scraping - multithreaded, n items:  7\n",
      "spider is scraping page: 8\n",
      "Cannot open the menu url, status code = 404, url= https://www.zimbokitchen.com/category/starches/page/8/\n",
      "no items found for page: https://www.zimbokitchen.com/category/starches/page/8/\n",
      "spider is scraping page: 1\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 2\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 3\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 4\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 5\n",
      "scraping - multithreaded, n items:  4\n",
      "spider is scraping page: 6\n",
      "Cannot open the menu url, status code = 404, url= https://www.zimbokitchen.com/category/soaps/traditional/page/6/\n",
      "no items found for page: https://www.zimbokitchen.com/category/soaps/traditional/page/6/\n",
      "spider is scraping page: 1\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 2\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 3\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 4\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 5\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 6\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 7\n",
      "scraping - multithreaded, n items:  12\n",
      "spider is scraping page: 8\n",
      "scraping - multithreaded, n items:  5\n",
      "spider is scraping page: 9\n",
      "Cannot open the menu url, status code = 404, url= https://www.zimbokitchen.com/category/baking/page/9/\n",
      "no items found for page: https://www.zimbokitchen.com/category/baking/page/9/\n"
     ]
    }
   ],
   "source": [
    "result_list = zimbokitchen_spider.start_scrape()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "564"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(result_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(result_list)"
   ]
  },
  {
   "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>name</th>\n",
       "      <th>total_time</th>\n",
       "      <th>ingredients</th>\n",
       "      <th>instructions</th>\n",
       "      <th>servings</th>\n",
       "      <th>category</th>\n",
       "      <th>prep_time</th>\n",
       "      <th>cook_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Baked Lemon, Garlic 'n Herb Kariba Bream - Zim...</td>\n",
       "      <td></td>\n",
       "      <td>[5 – 6 Medium sized Kariba Bream Fish, gutted,...</td>\n",
       "      <td>[Get your ingredients together. De-scale the f...</td>\n",
       "      <td>5 – 6</td>\n",
       "      <td></td>\n",
       "      <td>30 minutes</td>\n",
       "      <td>40 minutes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tammy's Sesame Oil Chicken - ZimboKitchen</td>\n",
       "      <td></td>\n",
       "      <td>[1 kg chicken breast, julienned, 2 tbsp fresh ...</td>\n",
       "      <td>[Get your ingredients together (P.S. To julien...</td>\n",
       "      <td>4 – 5 servings</td>\n",
       "      <td></td>\n",
       "      <td>10 min</td>\n",
       "      <td>15 -20 min</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Homemade Sweet Chilli Fish Fingers - ZimboKitchen</td>\n",
       "      <td></td>\n",
       "      <td>[500 g Fish fillets of your choice, For the Ba...</td>\n",
       "      <td>[Get your ingredients together. We begin by pr...</td>\n",
       "      <td>4 – 5</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>10 mins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Very Tasty BBQ Chicken Stew (Video). - ZimboKi...</td>\n",
       "      <td></td>\n",
       "      <td>[1.5kgs chicken portions, 1 chicken stock cube...</td>\n",
       "      <td>[]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Scrumptious Chicken Gizzards - ZimboKitchen</td>\n",
       "      <td></td>\n",
       "      <td>[500g chicken gizzards, 1 tsp salt, 3 tbsp oil...</td>\n",
       "      <td>[Get your ingredients together. Heat oil in pa...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>559</th>\n",
       "      <td>Scrumptious Vanilla cake (made with brown suga...</td>\n",
       "      <td></td>\n",
       "      <td>[200g margarine, \\n200g brown sugar, \\n400g ca...</td>\n",
       "      <td>[Get your ingredients ready.  These include; 2...</td>\n",
       "      <td>12 Servings</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>~ 45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>560</th>\n",
       "      <td>Crumpets (delicate cousin of mafatty) - ZimboK...</td>\n",
       "      <td></td>\n",
       "      <td>[1 cup milk, \\n2 eggs, \\n280g self raising flo...</td>\n",
       "      <td>[Break eggs in bowl, add oil, sugar, essence a...</td>\n",
       "      <td>12 Servings</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>~ 9 minutes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>561</th>\n",
       "      <td>How to make fresh cream frosting (whipped crea...</td>\n",
       "      <td></td>\n",
       "      <td>[500ml fresh cream, \\n3 tbsp icing sugar, \\n1 ...</td>\n",
       "      <td>[Put mixing bowl and whisk or electric hand-mi...</td>\n",
       "      <td>Two 8 Servings</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>~ 10 minutes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>562</th>\n",
       "      <td>Banana and lemon muffins - ZimboKitchen</td>\n",
       "      <td></td>\n",
       "      <td>[2 large bananas, \\n200g brown sugar , \\n200g ...</td>\n",
       "      <td>[Preheat the oven. With your ingredients ready...</td>\n",
       "      <td>12 Servings</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>~ 30 minutes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>How to make butter cream icing - ZimboKitchen</td>\n",
       "      <td></td>\n",
       "      <td>[100g margarine/butter, \\n300g  icing sugar, \\...</td>\n",
       "      <td>[Put margarine (100g) in mixing bowl. Using el...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>~ 15 minutes</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>564 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  name total_time  \\\n",
       "0    Baked Lemon, Garlic 'n Herb Kariba Bream - Zim...              \n",
       "1            Tammy's Sesame Oil Chicken - ZimboKitchen              \n",
       "2    Homemade Sweet Chilli Fish Fingers - ZimboKitchen              \n",
       "3    Very Tasty BBQ Chicken Stew (Video). - ZimboKi...              \n",
       "4          Scrumptious Chicken Gizzards - ZimboKitchen              \n",
       "..                                                 ...        ...   \n",
       "559  Scrumptious Vanilla cake (made with brown suga...              \n",
       "560  Crumpets (delicate cousin of mafatty) - ZimboK...              \n",
       "561  How to make fresh cream frosting (whipped crea...              \n",
       "562            Banana and lemon muffins - ZimboKitchen              \n",
       "563      How to make butter cream icing - ZimboKitchen              \n",
       "\n",
       "                                           ingredients  \\\n",
       "0    [5 – 6 Medium sized Kariba Bream Fish, gutted,...   \n",
       "1    [1 kg chicken breast, julienned, 2 tbsp fresh ...   \n",
       "2    [500 g Fish fillets of your choice, For the Ba...   \n",
       "3    [1.5kgs chicken portions, 1 chicken stock cube...   \n",
       "4    [500g chicken gizzards, 1 tsp salt, 3 tbsp oil...   \n",
       "..                                                 ...   \n",
       "559  [200g margarine, \\n200g brown sugar, \\n400g ca...   \n",
       "560  [1 cup milk, \\n2 eggs, \\n280g self raising flo...   \n",
       "561  [500ml fresh cream, \\n3 tbsp icing sugar, \\n1 ...   \n",
       "562  [2 large bananas, \\n200g brown sugar , \\n200g ...   \n",
       "563  [100g margarine/butter, \\n300g  icing sugar, \\...   \n",
       "\n",
       "                                          instructions        servings  \\\n",
       "0    [Get your ingredients together. De-scale the f...           5 – 6   \n",
       "1    [Get your ingredients together (P.S. To julien...  4 – 5 servings   \n",
       "2    [Get your ingredients together. We begin by pr...           4 – 5   \n",
       "3                                                   []                   \n",
       "4    [Get your ingredients together. Heat oil in pa...                   \n",
       "..                                                 ...             ...   \n",
       "559  [Get your ingredients ready.  These include; 2...     12 Servings   \n",
       "560  [Break eggs in bowl, add oil, sugar, essence a...     12 Servings   \n",
       "561  [Put mixing bowl and whisk or electric hand-mi...  Two 8 Servings   \n",
       "562  [Preheat the oven. With your ingredients ready...     12 Servings   \n",
       "563  [Put margarine (100g) in mixing bowl. Using el...                   \n",
       "\n",
       "    category   prep_time     cook_time  \n",
       "0             30 minutes    40 minutes  \n",
       "1                 10 min    15 -20 min  \n",
       "2                              10 mins  \n",
       "3                                       \n",
       "4                                       \n",
       "..       ...         ...           ...  \n",
       "559                               ~ 45  \n",
       "560                        ~ 9 minutes  \n",
       "561                       ~ 10 minutes  \n",
       "562                       ~ 30 minutes  \n",
       "563                       ~ 15 minutes  \n",
       "\n",
       "[564 rows x 8 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('data/zimbabwe/zimbabwe.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "7f97af7b90ec3405e1f66aa9bfad4ba40234615df6d29df3ef268808d6a9feec"
  },
  "kernelspec": {
   "display_name": "Python 3.9.1 ('wb-scraping': venv)",
   "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.9.1"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}