recipe-generator.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Recipe generator\n",
    "\n",
    "In this notebook we use [TextBlob](https://textblob.readthedocs.io/en/dev/) to extract nouns, verbs, and sentences from the OCRd text of a 19th century cookery book. We try to clean things up a bit, using regular expressions to discard likely OCR errors. Then we recombine the various parts in random combinations to create delicious recipes for all occasions. Enjoy!\n",
    "\n",
    "Inspired by [*Australian Plain Cookery by a Practical Cook*](https://nla.gov.au/nla.obj-579917051), 1882."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "from textblob import TextBlob\n",
    "import re\n",
    "import random\n",
    "import pandas as pd\n",
    "from IPython.display import display, HTML\n",
    "import nltk\n",
    "nltk.download('stopwords')\n",
    "nltk.download('punkt')\n",
    "nltk.download('averaged_perceptron_tagger')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# The Cloudstor URL links to the repository of OCRd text from Trove digitised books\n",
    "CLOUDSTOR_URL = 'https://cloudstor.aarnet.edu.au/plus/s/ugiw3gdijSKaoTL'\n",
    "# File name of the cookery book\n",
    "text_file = 'australian-plain-cookery-by-a-practical-cook-nla.obj-579917051.txt'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "First we procure a recipe book."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Download the text of the book\n",
    "response = requests.get(f'{CLOUDSTOR_URL}/download?files={text_file}')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Then we slice and dice the words to create a new TextBlob."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a TextBlob using the text\n",
    "blob = TextBlob(response.text)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Carefully we remove the nouns and the verbs, discarding any that are spoiled."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Get the verbs filtering out short words and those including non-alpha characters.\n",
    "# 'VBD' is the part of speech tag for a past tense verb\n",
    "verbs = [w.title() for w, t in blob.tags if t == 'VBD' and len(w) > 3 and w.isalpha()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Get the nouns filtering out short words and those including non-alpha characters.\n",
    "# NNP is the POS tag for proper nouns\n",
    "nouns = [w.title() for w, t in blob.tags if t.startswith('NNP') and len(w) > 3 and w.isalpha()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now it is necessary to prepare the sentences. First extract them from the blob. Discard any that seem ill-formed."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Get the sentences from the blob\n",
    "# Uses a regexp to exclude those that include anything other than standard letters, numbers, and punctuation.\n",
    "sentences = [str(s).replace('\\n', ' ') for s in blob.sentences if re.match(r'^[a-zA-Z\\s\\-,\\.;0-9\\'&\\(\\):]*$', str(s))]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The sentences now need to be divided, to separate out the titles, which are recognised by their case."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Titles in this cookbook are in uppercase, so we can separate them out from the rest of the sentences.\n",
    "titles = [s for s in sentences if s.strip('.').isupper()]\n",
    "sentences = [s for s in sentences if not s.strip('.').isupper()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now we are ready to start cooking!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "def recipe_maker(num=5):\n",
    "    html = ''\n",
    "    # Get a random title\n",
    "    title = random.choice(titles)\n",
    "    html = f'<h4>{title}</h4>'\n",
    "    html += '<h5>Ingredients:</h5>'\n",
    "    html += '<ol>'\n",
    "    for n in range(1, num + 1):\n",
    "        # Make a random selection from the nouns & verbs\n",
    "        html += f'<li>{random.choice(verbs)} {random.choice(nouns)}</li>'\n",
    "    html += '</ol>'\n",
    "    html += '<h5>Method:</h5>'\n",
    "    # Get random sentences and combine\n",
    "    html += f'<p>{\" \".join(random.sample(sentences, num))}</p>'\n",
    "    display(HTML(html))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<h4>BREAKFAST ROLLS, PLAIN.</h4><h5>Ingredients:</h5><ol><li>Beat Arrowroot</li><li>Added Wipe</li><li>Buttered Boil</li><li>Dipped Made</li><li>Stew Melt</li><li>Peeled Plain</li></ol><h5>Method:</h5><p>In carving a large fish, as here engraved, cut thin slices, as from A to B, and help with it pieces of the belly, in the direction marked from C to D ; the best flavoured is the upper or thick part. Take two pounds of fat bacon, and a pound and a half of beef suet. When you put in the vegetables, cover all closely, and do not use for at least six weeks. Lay in cold water, and when it boils simmer for eight or ten minutes. Add one onion, three sage leaves, some whole pepper, and a little salt in three pints of water. Edge and cover with short crust, and ornament the edges.</p>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "recipe_maker(6)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## What's next?\n",
    "\n",
    "There's a [full list of the POS (Part of Speech) tags](https://www.geeksforgeeks.org/python-part-of-speech-tagging-using-textblob/) here if you'd like to play with different combinations.\n",
    "\n",
    "Perhaps we could add some more cookbooks? Let's load details of all the digitised books in Trove that include the word 'cookery' in the title."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('https://raw.githubusercontent.com/GLAM-Workbench/trove-books/master/trove_digitised_books_with_ocr.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>title</th>\n",
       "      <th>url</th>\n",
       "      <th>contributors</th>\n",
       "      <th>date</th>\n",
       "      <th>fulltext_url</th>\n",
       "      <th>trove_id</th>\n",
       "      <th>language</th>\n",
       "      <th>rights</th>\n",
       "      <th>pages</th>\n",
       "      <th>form</th>\n",
       "      <th>volume</th>\n",
       "      <th>parent</th>\n",
       "      <th>children</th>\n",
       "      <th>text_downloaded</th>\n",
       "      <th>text_file</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1888</th>\n",
       "      <td>The Kingswood cookery book / by H. F. Wicken</td>\n",
       "      <td>https://trove.nla.gov.au/work/12721516</td>\n",
       "      <td>Wicken, H</td>\n",
       "      <td>1885-1950</td>\n",
       "      <td>https://nla.gov.au/nla.obj-43987239</td>\n",
       "      <td>nla.obj-43987239</td>\n",
       "      <td>English</td>\n",
       "      <td>Out of Copyright|http://rightsstatements.org/v...</td>\n",
       "      <td>278</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>the-kingswood-cookery-book-by-h-f-wicken-nla.o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2582</th>\n",
       "      <td>Electric cookery book : being an indispensable...</td>\n",
       "      <td>https://trove.nla.gov.au/work/16383834</td>\n",
       "      <td>State Electricity Commission of Victoria</td>\n",
       "      <td>1940-1949</td>\n",
       "      <td>http://nla.gov.au/nla.obj-52836472</td>\n",
       "      <td>nla.obj-52836472</td>\n",
       "      <td>English</td>\n",
       "      <td>No known copyright restrictions|http://rightss...</td>\n",
       "      <td>73</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>electric-cookery-book-being-an-indispensable-h...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2654</th>\n",
       "      <td>The English and Australian cookery book : cook...</td>\n",
       "      <td>https://trove.nla.gov.au/work/16551115</td>\n",
       "      <td>Abbott, Edward, 1801-1869</td>\n",
       "      <td>1864-2014</td>\n",
       "      <td>https://nla.gov.au/nla.obj-9562000</td>\n",
       "      <td>nla.obj-9562000</td>\n",
       "      <td>English</td>\n",
       "      <td>Out of Copyright|http://rightsstatements.org/v...</td>\n",
       "      <td>356</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>the-english-and-australian-cookery-book-cooker...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4431</th>\n",
       "      <td>Australian plain cookery / by a Practical Cook...</td>\n",
       "      <td>https://trove.nla.gov.au/work/18493439</td>\n",
       "      <td>Old housekeeper</td>\n",
       "      <td>1882-1897</td>\n",
       "      <td>http://nla.gov.au/nla.obj-579917051</td>\n",
       "      <td>nla.obj-579917051</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>148</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>australian-plain-cookery-by-a-practical-cook-r...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7688</th>\n",
       "      <td>The Armidale Red Cross cookery book of tested ...</td>\n",
       "      <td>https://trove.nla.gov.au/work/20631441</td>\n",
       "      <td>Australian Red Cross Society. Armidale Branch</td>\n",
       "      <td>1920</td>\n",
       "      <td>https://nla.gov.au/nla.obj-52792201</td>\n",
       "      <td>nla.obj-52792201</td>\n",
       "      <td>English</td>\n",
       "      <td>Out of Copyright|http://rightsstatements.org/v...</td>\n",
       "      <td>82</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>the-armidale-red-cross-cookery-book-of-tested-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8173</th>\n",
       "      <td>The Kandy Koola cookery book and housewife's c...</td>\n",
       "      <td>https://trove.nla.gov.au/work/21067450</td>\n",
       "      <td>Kandy Koola Tea</td>\n",
       "      <td>1898</td>\n",
       "      <td>https://nla.gov.au/nla.obj-2409723409</td>\n",
       "      <td>nla.obj-2409723409</td>\n",
       "      <td>English</td>\n",
       "      <td>Out of Copyright|http://rightsstatements.org/v...</td>\n",
       "      <td>76</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>the-kandy-koola-cookery-book-and-housewife-s-c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8491</th>\n",
       "      <td>The Hawkesbury and Shoalhaven calendar, cultur...</td>\n",
       "      <td>https://trove.nla.gov.au/work/21309432</td>\n",
       "      <td>Woodhill &amp; Co</td>\n",
       "      <td>1905</td>\n",
       "      <td>http://nla.gov.au/nla.obj-28658844</td>\n",
       "      <td>nla.obj-28658844</td>\n",
       "      <td>English</td>\n",
       "      <td>Out of Copyright|http://rightsstatements.org/v...</td>\n",
       "      <td>200</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>the-hawkesbury-and-shoalhaven-calendar-cultura...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9457</th>\n",
       "      <td>Hebrew cookery / by an Australian</td>\n",
       "      <td>https://trove.nla.gov.au/work/22242397</td>\n",
       "      <td>Australian</td>\n",
       "      <td>1867</td>\n",
       "      <td>http://nla.gov.au/nla.obj-52864954</td>\n",
       "      <td>nla.obj-52864954</td>\n",
       "      <td>English</td>\n",
       "      <td>No known copyright restrictions|http://rightss...</td>\n",
       "      <td>25</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>hebrew-cookery-by-an-australian-nla.obj-528649...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9472</th>\n",
       "      <td>Recipes given by Mrs. Wicken at cookery class,...</td>\n",
       "      <td>https://trove.nla.gov.au/work/22249810</td>\n",
       "      <td>Wicken, H</td>\n",
       "      <td>1888</td>\n",
       "      <td>http://nla.gov.au/nla.obj-533356312</td>\n",
       "      <td>nla.obj-533356312</td>\n",
       "      <td>English</td>\n",
       "      <td>Out of Copyright|http://rightsstatements.org/v...</td>\n",
       "      <td>16</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>recipes-given-by-mrs-wicken-at-cookery-class-w...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13145</th>\n",
       "      <td>Southland Red Cross cookery book, 1916</td>\n",
       "      <td>https://trove.nla.gov.au/work/237279068</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1916</td>\n",
       "      <td>https://nla.gov.au/nla.obj-49498371</td>\n",
       "      <td>nla.obj-49498371</td>\n",
       "      <td>English</td>\n",
       "      <td>Out of Copyright|http://rightsstatements.org/v...</td>\n",
       "      <td>187</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>southland-red-cross-cookery-book-1916-nla.obj-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19740</th>\n",
       "      <td>Barossa cookery book : 400 tried recipes</td>\n",
       "      <td>https://trove.nla.gov.au/work/237367083</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1917</td>\n",
       "      <td>https://nla.gov.au/nla.obj-497806529</td>\n",
       "      <td>nla.obj-497806529</td>\n",
       "      <td>English</td>\n",
       "      <td>No known copyright restrictions|http://rightss...</td>\n",
       "      <td>60</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>barossa-cookery-book-400-tried-recipes-nla.obj...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19823</th>\n",
       "      <td>Australian plain cookery / by a practical cook</td>\n",
       "      <td>https://trove.nla.gov.au/work/237367586</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1882</td>\n",
       "      <td>https://nla.gov.au/nla.obj-579917051</td>\n",
       "      <td>nla.obj-579917051</td>\n",
       "      <td>English</td>\n",
       "      <td>Out of Copyright|http://rightsstatements.org/v...</td>\n",
       "      <td>148</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>australian-plain-cookery-by-a-practical-cook-n...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22262</th>\n",
       "      <td>The Australian women's weekly cookery book : p...</td>\n",
       "      <td>https://trove.nla.gov.au/work/237539542</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1948</td>\n",
       "      <td>https://nla.gov.au/nla.obj-2122602128</td>\n",
       "      <td>nla.obj-2122602128</td>\n",
       "      <td>English</td>\n",
       "      <td>No known copyright restrictions|http://rightss...</td>\n",
       "      <td>68</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>the-australian-women-s-weekly-cookery-book-pri...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29983</th>\n",
       "      <td>The Banner cookery book : over 300 tested recipes</td>\n",
       "      <td>https://trove.nla.gov.au/work/24494136</td>\n",
       "      <td>Dimboola Bush Nursing Hospital</td>\n",
       "      <td>1953</td>\n",
       "      <td>https://nla.gov.au/nla.obj-43445961</td>\n",
       "      <td>nla.obj-43445961</td>\n",
       "      <td>English</td>\n",
       "      <td>Out of Copyright|http://rightsstatements.org/v...</td>\n",
       "      <td>48</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>the-banner-cookery-book-over-300-tested-recipe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30410</th>\n",
       "      <td>The War chest cookery book</td>\n",
       "      <td>https://trove.nla.gov.au/work/26653596</td>\n",
       "      <td>Citizens' War Chest Fund (N.S.W.)</td>\n",
       "      <td>1917</td>\n",
       "      <td>https://nla.gov.au/nla.obj-37545603</td>\n",
       "      <td>nla.obj-37545603</td>\n",
       "      <td>English</td>\n",
       "      <td>Out of Copyright|http://rightsstatements.org/v...</td>\n",
       "      <td>156</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>the-war-chest-cookery-book-nla.obj-37545603.txt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30637</th>\n",
       "      <td>Southland Red Cross cookery book, 1916</td>\n",
       "      <td>https://trove.nla.gov.au/work/26863907</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1916</td>\n",
       "      <td>http://nla.gov.au/nla.obj-49498371</td>\n",
       "      <td>nla.obj-49498371</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>187</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>southland-red-cross-cookery-book-1916-nla.obj-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32264</th>\n",
       "      <td>Flinders Island : souvenir : cookery book</td>\n",
       "      <td>https://trove.nla.gov.au/work/35649557</td>\n",
       "      <td>Country Women's Association in Tasmania. Flind...</td>\n",
       "      <td>1946</td>\n",
       "      <td>https://nla.gov.au/nla.obj-2531663107</td>\n",
       "      <td>nla.obj-2531663107</td>\n",
       "      <td>English</td>\n",
       "      <td>No known copyright restrictions|http://rightss...</td>\n",
       "      <td>84</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>flinders-island-souvenir-cookery-book-nla.obj-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32955</th>\n",
       "      <td>Barossa cookery book : 400 tried recipes</td>\n",
       "      <td>https://trove.nla.gov.au/work/6619781</td>\n",
       "      <td>Tanunda Australia Day Celebrations Committee (...</td>\n",
       "      <td>1917</td>\n",
       "      <td>http://nla.gov.au/nla.obj-497806529</td>\n",
       "      <td>nla.obj-497806529</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>barossa-cookery-book-400-tried-recipes-nla.obj...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32963</th>\n",
       "      <td>\"Caroona\" cookery book : over 240 favourite re...</td>\n",
       "      <td>https://trove.nla.gov.au/work/6663148</td>\n",
       "      <td>North Coast Methodist Homes for the Aged. Lism...</td>\n",
       "      <td>1900</td>\n",
       "      <td>http://nla.gov.au/nla.obj-52837739</td>\n",
       "      <td>nla.obj-52837739</td>\n",
       "      <td>English</td>\n",
       "      <td>No known copyright restrictions|http://rightss...</td>\n",
       "      <td>54</td>\n",
       "      <td>Book</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>caroona-cookery-book-over-240-favourite-recipe...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   title  \\\n",
       "1888        The Kingswood cookery book / by H. F. Wicken   \n",
       "2582   Electric cookery book : being an indispensable...   \n",
       "2654   The English and Australian cookery book : cook...   \n",
       "4431   Australian plain cookery / by a Practical Cook...   \n",
       "7688   The Armidale Red Cross cookery book of tested ...   \n",
       "8173   The Kandy Koola cookery book and housewife's c...   \n",
       "8491   The Hawkesbury and Shoalhaven calendar, cultur...   \n",
       "9457                   Hebrew cookery / by an Australian   \n",
       "9472   Recipes given by Mrs. Wicken at cookery class,...   \n",
       "13145             Southland Red Cross cookery book, 1916   \n",
       "19740           Barossa cookery book : 400 tried recipes   \n",
       "19823     Australian plain cookery / by a practical cook   \n",
       "22262  The Australian women's weekly cookery book : p...   \n",
       "29983  The Banner cookery book : over 300 tested recipes   \n",
       "30410                         The War chest cookery book   \n",
       "30637             Southland Red Cross cookery book, 1916   \n",
       "32264          Flinders Island : souvenir : cookery book   \n",
       "32955           Barossa cookery book : 400 tried recipes   \n",
       "32963  \"Caroona\" cookery book : over 240 favourite re...   \n",
       "\n",
       "                                           url  \\\n",
       "1888    https://trove.nla.gov.au/work/12721516   \n",
       "2582    https://trove.nla.gov.au/work/16383834   \n",
       "2654    https://trove.nla.gov.au/work/16551115   \n",
       "4431    https://trove.nla.gov.au/work/18493439   \n",
       "7688    https://trove.nla.gov.au/work/20631441   \n",
       "8173    https://trove.nla.gov.au/work/21067450   \n",
       "8491    https://trove.nla.gov.au/work/21309432   \n",
       "9457    https://trove.nla.gov.au/work/22242397   \n",
       "9472    https://trove.nla.gov.au/work/22249810   \n",
       "13145  https://trove.nla.gov.au/work/237279068   \n",
       "19740  https://trove.nla.gov.au/work/237367083   \n",
       "19823  https://trove.nla.gov.au/work/237367586   \n",
       "22262  https://trove.nla.gov.au/work/237539542   \n",
       "29983   https://trove.nla.gov.au/work/24494136   \n",
       "30410   https://trove.nla.gov.au/work/26653596   \n",
       "30637   https://trove.nla.gov.au/work/26863907   \n",
       "32264   https://trove.nla.gov.au/work/35649557   \n",
       "32955    https://trove.nla.gov.au/work/6619781   \n",
       "32963    https://trove.nla.gov.au/work/6663148   \n",
       "\n",
       "                                            contributors       date  \\\n",
       "1888                                           Wicken, H  1885-1950   \n",
       "2582            State Electricity Commission of Victoria  1940-1949   \n",
       "2654                           Abbott, Edward, 1801-1869  1864-2014   \n",
       "4431                                     Old housekeeper  1882-1897   \n",
       "7688       Australian Red Cross Society. Armidale Branch       1920   \n",
       "8173                                     Kandy Koola Tea       1898   \n",
       "8491                                       Woodhill & Co       1905   \n",
       "9457                                          Australian       1867   \n",
       "9472                                           Wicken, H       1888   \n",
       "13145                                                NaN       1916   \n",
       "19740                                                NaN       1917   \n",
       "19823                                                NaN       1882   \n",
       "22262                                                NaN       1948   \n",
       "29983                     Dimboola Bush Nursing Hospital       1953   \n",
       "30410                  Citizens' War Chest Fund (N.S.W.)       1917   \n",
       "30637                                                NaN       1916   \n",
       "32264  Country Women's Association in Tasmania. Flind...       1946   \n",
       "32955  Tanunda Australia Day Celebrations Committee (...       1917   \n",
       "32963  North Coast Methodist Homes for the Aged. Lism...       1900   \n",
       "\n",
       "                                fulltext_url            trove_id language  \\\n",
       "1888     https://nla.gov.au/nla.obj-43987239    nla.obj-43987239  English   \n",
       "2582      http://nla.gov.au/nla.obj-52836472    nla.obj-52836472  English   \n",
       "2654      https://nla.gov.au/nla.obj-9562000     nla.obj-9562000  English   \n",
       "4431     http://nla.gov.au/nla.obj-579917051   nla.obj-579917051      NaN   \n",
       "7688     https://nla.gov.au/nla.obj-52792201    nla.obj-52792201  English   \n",
       "8173   https://nla.gov.au/nla.obj-2409723409  nla.obj-2409723409  English   \n",
       "8491      http://nla.gov.au/nla.obj-28658844    nla.obj-28658844  English   \n",
       "9457      http://nla.gov.au/nla.obj-52864954    nla.obj-52864954  English   \n",
       "9472     http://nla.gov.au/nla.obj-533356312   nla.obj-533356312  English   \n",
       "13145    https://nla.gov.au/nla.obj-49498371    nla.obj-49498371  English   \n",
       "19740   https://nla.gov.au/nla.obj-497806529   nla.obj-497806529  English   \n",
       "19823   https://nla.gov.au/nla.obj-579917051   nla.obj-579917051  English   \n",
       "22262  https://nla.gov.au/nla.obj-2122602128  nla.obj-2122602128  English   \n",
       "29983    https://nla.gov.au/nla.obj-43445961    nla.obj-43445961  English   \n",
       "30410    https://nla.gov.au/nla.obj-37545603    nla.obj-37545603  English   \n",
       "30637     http://nla.gov.au/nla.obj-49498371    nla.obj-49498371      NaN   \n",
       "32264  https://nla.gov.au/nla.obj-2531663107  nla.obj-2531663107  English   \n",
       "32955    http://nla.gov.au/nla.obj-497806529   nla.obj-497806529      NaN   \n",
       "32963     http://nla.gov.au/nla.obj-52837739    nla.obj-52837739  English   \n",
       "\n",
       "                                                  rights  pages  form  volume  \\\n",
       "1888   Out of Copyright|http://rightsstatements.org/v...    278  Book     NaN   \n",
       "2582   No known copyright restrictions|http://rightss...     73  Book     NaN   \n",
       "2654   Out of Copyright|http://rightsstatements.org/v...    356  Book     NaN   \n",
       "4431                                                 NaN    148  Book     NaN   \n",
       "7688   Out of Copyright|http://rightsstatements.org/v...     82  Book     NaN   \n",
       "8173   Out of Copyright|http://rightsstatements.org/v...     76  Book     NaN   \n",
       "8491   Out of Copyright|http://rightsstatements.org/v...    200  Book     NaN   \n",
       "9457   No known copyright restrictions|http://rightss...     25  Book     NaN   \n",
       "9472   Out of Copyright|http://rightsstatements.org/v...     16  Book     NaN   \n",
       "13145  Out of Copyright|http://rightsstatements.org/v...    187  Book     NaN   \n",
       "19740  No known copyright restrictions|http://rightss...     60  Book     NaN   \n",
       "19823  Out of Copyright|http://rightsstatements.org/v...    148  Book     NaN   \n",
       "22262  No known copyright restrictions|http://rightss...     68  Book     NaN   \n",
       "29983  Out of Copyright|http://rightsstatements.org/v...     48  Book     NaN   \n",
       "30410  Out of Copyright|http://rightsstatements.org/v...    156  Book     NaN   \n",
       "30637                                                NaN    187  Book     NaN   \n",
       "32264  No known copyright restrictions|http://rightss...     84  Book     NaN   \n",
       "32955                                                NaN     60  Book     NaN   \n",
       "32963  No known copyright restrictions|http://rightss...     54  Book     NaN   \n",
       "\n",
       "      parent children  text_downloaded  \\\n",
       "1888     NaN      NaN             True   \n",
       "2582     NaN      NaN             True   \n",
       "2654     NaN      NaN             True   \n",
       "4431     NaN      NaN             True   \n",
       "7688     NaN      NaN             True   \n",
       "8173     NaN      NaN             True   \n",
       "8491     NaN      NaN             True   \n",
       "9457     NaN      NaN             True   \n",
       "9472     NaN      NaN             True   \n",
       "13145    NaN      NaN             True   \n",
       "19740    NaN      NaN             True   \n",
       "19823    NaN      NaN             True   \n",
       "22262    NaN      NaN             True   \n",
       "29983    NaN      NaN             True   \n",
       "30410    NaN      NaN             True   \n",
       "30637    NaN      NaN             True   \n",
       "32264    NaN      NaN             True   \n",
       "32955    NaN      NaN             True   \n",
       "32963    NaN      NaN             True   \n",
       "\n",
       "                                               text_file  \n",
       "1888   the-kingswood-cookery-book-by-h-f-wicken-nla.o...  \n",
       "2582   electric-cookery-book-being-an-indispensable-h...  \n",
       "2654   the-english-and-australian-cookery-book-cooker...  \n",
       "4431   australian-plain-cookery-by-a-practical-cook-r...  \n",
       "7688   the-armidale-red-cross-cookery-book-of-tested-...  \n",
       "8173   the-kandy-koola-cookery-book-and-housewife-s-c...  \n",
       "8491   the-hawkesbury-and-shoalhaven-calendar-cultura...  \n",
       "9457   hebrew-cookery-by-an-australian-nla.obj-528649...  \n",
       "9472   recipes-given-by-mrs-wicken-at-cookery-class-w...  \n",
       "13145  southland-red-cross-cookery-book-1916-nla.obj-...  \n",
       "19740  barossa-cookery-book-400-tried-recipes-nla.obj...  \n",
       "19823  australian-plain-cookery-by-a-practical-cook-n...  \n",
       "22262  the-australian-women-s-weekly-cookery-book-pri...  \n",
       "29983  the-banner-cookery-book-over-300-tested-recipe...  \n",
       "30410    the-war-chest-cookery-book-nla.obj-37545603.txt  \n",
       "30637  southland-red-cross-cookery-book-1916-nla.obj-...  \n",
       "32264  flinders-island-souvenir-cookery-book-nla.obj-...  \n",
       "32955  barossa-cookery-book-400-tried-recipes-nla.obj...  \n",
       "32963  caroona-cookery-book-over-240-favourite-recipe...  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[(df['title'].str.contains('cookery')) & (df['text_downloaded'] == True)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To use a different one of these as the source for our recipe generator, just copy the index value, and then get the name of the `text_file`. Like this:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'the-kandy-koola-cookery-book-and-housewife-s-compa-nla.obj-2409723409.txt'"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[8173]['text_file']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Copy and paste the file name into the `text_file` value at the top of this notebook, and then re-run the cells."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "How might we combine ingredients from **all** of these cook books?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "----\n",
    "\n",
    "Created by [Tim Sherratt](https://timsherratt.org) for the [GLAM Workbench](https://glam-workbench.github.io/)."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}