scrape-nz.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import json\n",
    "import requests\n",
    "import random\n",
    "from lxml import html\n",
    "import re\n",
    "\n",
    "from  util.spider import Spider\n",
    "# from util.http_utility import get_http_headers\n",
    "# from util.user_agent import get_random_ua"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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",
    "listing={'items': '//div[contains(@class,\"fd-tile fd-recipe\")]//h2//a/@href', 'next': { 'next_page_str': '?pn={}', 'type': 'url'}}\n",
    "seeds = ['https://www.food.com/topic/new-zealand']\n",
    "available_json = {'xpath' : \"normalize-space(//script[@type='application/ld+json'][contains(text(), 'recipeIngredient')])\"}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "nz_spider =  Spider('https://www.food.com/', seeds= seeds, listing =listing,attrs= attrs, available_json=available_json)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'name': 'Fluffernutter',\n",
       " 'total_time': 'PT1M',\n",
       " 'ingredients': ['2 tablespoons marshmallow cream',\n",
       "  '2 tablespoons peanut butter (smooth or creamy)',\n",
       "  '2 slices bread'],\n",
       " 'instructions': ['Spread peanut butter onto one slice of bread, use as much as you want.\\r',\n",
       "  'Cover with Marshmallow Fluff, use as much as you want.\\r',\n",
       "  'Top with second slice of bread and enjoy!'],\n",
       " 'servings': '1 serving(s)',\n",
       " 'category': 'Lunch/Snacks',\n",
       " 'prep_time': 'PT1M',\n",
       " 'cook_time': ''}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nz_spider.scrape_one_item('https://www.food.com/recipe/fluffernutter-181487')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "spider is scraping page: 1\n",
      "scraping - multithreaded, n items:  9\n",
      "spider is scraping page: 2\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 3\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 4\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 5\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 6\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 7\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 8\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 9\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 10\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 11\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 12\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 13\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 14\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 15\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 16\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 17\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 18\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 19\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 20\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 21\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 22\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 23\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 24\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 25\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 26\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 27\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 28\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 29\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 30\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 31\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 32\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 33\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 34\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 35\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 36\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 37\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 38\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 39\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 40\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 41\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 42\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 43\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 44\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 45\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 46\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 47\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 48\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 49\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 50\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 51\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 52\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 53\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 54\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 55\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 56\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 57\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 58\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 59\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 60\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 61\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 62\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 63\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 64\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 65\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 66\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 67\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 68\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 69\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 70\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 71\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 72\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 73\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 74\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 75\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 76\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 77\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 78\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 79\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 80\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 81\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 82\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 83\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 84\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 85\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 86\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 87\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 88\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 89\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 90\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 91\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 92\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 93\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 94\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 95\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 96\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 97\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 98\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 99\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 100\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 101\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 102\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 103\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 104\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 105\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 106\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 107\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 108\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 109\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 110\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 111\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 112\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 113\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 114\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 115\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 116\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 117\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 118\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 119\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 120\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 121\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 122\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 123\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 124\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 125\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 126\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 127\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 128\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 129\n",
      "scraping - multithreaded, n items:  10\n",
      "spider is scraping page: 130\n",
      "Cannot open the menu url, status code = 410, url= https://www.food.com/topic/new-zealand?pn=130\n"
     ]
    }
   ],
   "source": [
    "result_list = nz_spider.start_scrape(max_pages=130) #max page is only 130"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "result_df = pd.DataFrame(result_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Big Fruit Salad</td>\n",
       "      <td>PT30M</td>\n",
       "      <td>[1 medium cantaloupe, 1 medium honeydew melon,...</td>\n",
       "      <td>[Cut the 2 melons in half, then scrap out the ...</td>\n",
       "      <td>8 serving(s)</td>\n",
       "      <td>Lunch/Snacks</td>\n",
       "      <td>PT30M</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Edmonds Scones</td>\n",
       "      <td>PT20M</td>\n",
       "      <td>[3 cups plain flour, 6 teaspoons baking powder...</td>\n",
       "      <td>[Sift flour, baking powder and salt into a bow...</td>\n",
       "      <td>12 serving(s)</td>\n",
       "      <td>Scones</td>\n",
       "      <td>PT10M</td>\n",
       "      <td>PT10M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Settler's Pie</td>\n",
       "      <td>PT1H10M</td>\n",
       "      <td>[1 cup flour, 4 ounces butter, 2 teaspoons vin...</td>\n",
       "      <td>[Mix the flour and butter to a sandy texture.,...</td>\n",
       "      <td>1 pie, 16-20 serving(s)</td>\n",
       "      <td>Savory Pies</td>\n",
       "      <td>PT30M</td>\n",
       "      <td>PT40M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Coconut Cream Truffles</td>\n",
       "      <td>PT2H25M</td>\n",
       "      <td>[375 g white chocolate, 150 g butter, 1/2 cup ...</td>\n",
       "      <td>[Gently melt butter and white chocolate in lar...</td>\n",
       "      <td>50 chocolates</td>\n",
       "      <td>Candy</td>\n",
       "      <td>PT25M</td>\n",
       "      <td>PT2H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Pavlova</td>\n",
       "      <td>PT1H50M</td>\n",
       "      <td>[4 egg whites, 1 teaspoon vanilla essence, 2 t...</td>\n",
       "      <td>[Beat egg whites and cornflour well with elect...</td>\n",
       "      <td>8 serving(s)</td>\n",
       "      <td>Dessert</td>\n",
       "      <td>PT20M</td>\n",
       "      <td>PT1H30M</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>1284</th>\n",
       "      <td>N Z's Best Salad Dressing</td>\n",
       "      <td>PT2M</td>\n",
       "      <td>[1 (395 g) can sweetened condensed milk, 1 cup...</td>\n",
       "      <td>[Place all ingredients into a bowl and beat we...</td>\n",
       "      <td>4 cups</td>\n",
       "      <td>Salad Dressings</td>\n",
       "      <td>PT2M</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1285</th>\n",
       "      <td>Raspberry Lavender Jam</td>\n",
       "      <td>PT35M</td>\n",
       "      <td>[3 cups fresh raspberries (you can use frozen ...</td>\n",
       "      <td>[The night before you make this jam put the ra...</td>\n",
       "      <td>750 g - approx</td>\n",
       "      <td>Raspberries</td>\n",
       "      <td>PT10M</td>\n",
       "      <td>PT25M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1286</th>\n",
       "      <td>Condensed Milk Dressing</td>\n",
       "      <td>PT2H5M</td>\n",
       "      <td>[1 (397 g) can condensed milk, 3/4 cup vinegar...</td>\n",
       "      <td>[Put approximately 3 tablespoons of condensed ...</td>\n",
       "      <td>2 cups</td>\n",
       "      <td>Salad Dressings</td>\n",
       "      <td>PT5M</td>\n",
       "      <td>PT2H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1287</th>\n",
       "      <td>Kumara Salad (sweet potato)</td>\n",
       "      <td>PT40M</td>\n",
       "      <td>[1 1/2 tablespoons oil, 2 tablespoons pineappl...</td>\n",
       "      <td>[Combine oil, pineapple and lemon juice in bow...</td>\n",
       "      <td>10 serving(s)</td>\n",
       "      <td>Pineapple</td>\n",
       "      <td>PT15M</td>\n",
       "      <td>PT25M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1288</th>\n",
       "      <td>Lemon Meringue Cheesecake</td>\n",
       "      <td>PT35M</td>\n",
       "      <td>[2 cups graham cracker crumbs or 2 cups tea bi...</td>\n",
       "      <td>[Combined biscuits and butter., Press into a 2...</td>\n",
       "      <td>10 serving(s)</td>\n",
       "      <td>Cheesecake</td>\n",
       "      <td>PT25M</td>\n",
       "      <td>PT10M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1289 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             name total_time  \\\n",
       "0                 Big Fruit Salad      PT30M   \n",
       "1                  Edmonds Scones      PT20M   \n",
       "2                   Settler's Pie    PT1H10M   \n",
       "3          Coconut Cream Truffles    PT2H25M   \n",
       "4                         Pavlova    PT1H50M   \n",
       "...                           ...        ...   \n",
       "1284    N Z's Best Salad Dressing       PT2M   \n",
       "1285       Raspberry Lavender Jam      PT35M   \n",
       "1286      Condensed Milk Dressing     PT2H5M   \n",
       "1287  Kumara Salad (sweet potato)      PT40M   \n",
       "1288    Lemon Meringue Cheesecake      PT35M   \n",
       "\n",
       "                                            ingredients  \\\n",
       "0     [1 medium cantaloupe, 1 medium honeydew melon,...   \n",
       "1     [3 cups plain flour, 6 teaspoons baking powder...   \n",
       "2     [1 cup flour, 4 ounces butter, 2 teaspoons vin...   \n",
       "3     [375 g white chocolate, 150 g butter, 1/2 cup ...   \n",
       "4     [4 egg whites, 1 teaspoon vanilla essence, 2 t...   \n",
       "...                                                 ...   \n",
       "1284  [1 (395 g) can sweetened condensed milk, 1 cup...   \n",
       "1285  [3 cups fresh raspberries (you can use frozen ...   \n",
       "1286  [1 (397 g) can condensed milk, 3/4 cup vinegar...   \n",
       "1287  [1 1/2 tablespoons oil, 2 tablespoons pineappl...   \n",
       "1288  [2 cups graham cracker crumbs or 2 cups tea bi...   \n",
       "\n",
       "                                           instructions  \\\n",
       "0     [Cut the 2 melons in half, then scrap out the ...   \n",
       "1     [Sift flour, baking powder and salt into a bow...   \n",
       "2     [Mix the flour and butter to a sandy texture.,...   \n",
       "3     [Gently melt butter and white chocolate in lar...   \n",
       "4     [Beat egg whites and cornflour well with elect...   \n",
       "...                                                 ...   \n",
       "1284  [Place all ingredients into a bowl and beat we...   \n",
       "1285  [The night before you make this jam put the ra...   \n",
       "1286  [Put approximately 3 tablespoons of condensed ...   \n",
       "1287  [Combine oil, pineapple and lemon juice in bow...   \n",
       "1288  [Combined biscuits and butter., Press into a 2...   \n",
       "\n",
       "                     servings         category prep_time cook_time  \n",
       "0                8 serving(s)     Lunch/Snacks     PT30M            \n",
       "1               12 serving(s)           Scones     PT10M     PT10M  \n",
       "2     1 pie, 16-20 serving(s)      Savory Pies     PT30M     PT40M  \n",
       "3               50 chocolates            Candy     PT25M      PT2H  \n",
       "4                8 serving(s)          Dessert     PT20M   PT1H30M  \n",
       "...                       ...              ...       ...       ...  \n",
       "1284                   4 cups  Salad Dressings      PT2M            \n",
       "1285           750 g - approx      Raspberries     PT10M     PT25M  \n",
       "1286                   2 cups  Salad Dressings      PT5M      PT2H  \n",
       "1287            10 serving(s)        Pineapple     PT15M     PT25M  \n",
       "1288            10 serving(s)       Cheesecake     PT25M     PT10M  \n",
       "\n",
       "[1289 rows x 8 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "result_df.to_csv('data/new-zealand/food_com_nz.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
}