Exploring-unpublished-works-entering-public-domain.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Exploring unpublished works that might be entering the public domain on 1 January 2019\n",
    "\n",
    "For more information on the data and how it was harvested see [Finding unpublished works entering the public domain](Finding-unpublished-works-entering-public-domain.ipynb)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import os\n",
    "\n",
    "import pandas as pd\n",
    "import requests\n",
    "from IPython.display import HTML, display"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "%%capture\n",
    "# Load variables from the .env file if it exists\n",
    "# Use %%capture to suppress messages\n",
    "%load_ext dotenv\n",
    "%dotenv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "# Insert your Trove API key\n",
    "API_KEY = \"YOUR API KEY\"\n",
    "\n",
    "if os.getenv(\"TROVE_API_KEY\"):\n",
    "    API_KEY = os.getenv(\"TROVE_API_KEY\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "tags": []
   },
   "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>creator</th>\n",
       "      <th>date</th>\n",
       "      <th>id</th>\n",
       "      <th>nuc</th>\n",
       "      <th>title</th>\n",
       "      <th>trove_url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Kelly, F. S. (Frederick Septimus), 1881-1916</td>\n",
       "      <td>1893-1926</td>\n",
       "      <td>10201266</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Music manuscripts</td>\n",
       "      <td>https://trove.nla.gov.au/work/10201266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td>1863-1925</td>\n",
       "      <td>10544890</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Collection of promissory notes from remote are...</td>\n",
       "      <td>https://trove.nla.gov.au/work/10544890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gugeri, Peter Anthony, 1845-1930</td>\n",
       "      <td>1863-1910</td>\n",
       "      <td>14022030</td>\n",
       "      <td>WLB</td>\n",
       "      <td>Gugeri family papers</td>\n",
       "      <td>https://trove.nla.gov.au/work/14022030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kruse, Johann Secundus, 1859-1927</td>\n",
       "      <td>1870-1927</td>\n",
       "      <td>14952244</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Papers of Johann Kruse</td>\n",
       "      <td>https://trove.nla.gov.au/work/14952244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Freycinet, Rose Marie de, d. 1832</td>\n",
       "      <td>1802-1927</td>\n",
       "      <td>152218670</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Documents relating to Louis and Rose de Freycinet</td>\n",
       "      <td>https://trove.nla.gov.au/work/152218670</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        creator       date         id  nuc  \\\n",
       "0  Kelly, F. S. (Frederick Septimus), 1881-1916  1893-1926   10201266  ANL   \n",
       "1                                                1863-1925   10544890  ANL   \n",
       "2              Gugeri, Peter Anthony, 1845-1930  1863-1910   14022030  WLB   \n",
       "3             Kruse, Johann Secundus, 1859-1927  1870-1927   14952244  ANL   \n",
       "4             Freycinet, Rose Marie de, d. 1832  1802-1927  152218670  ANL   \n",
       "\n",
       "                                               title  \\\n",
       "0                                  Music manuscripts   \n",
       "1  Collection of promissory notes from remote are...   \n",
       "2                               Gugeri family papers   \n",
       "3                             Papers of Johann Kruse   \n",
       "4  Documents relating to Louis and Rose de Freycinet   \n",
       "\n",
       "                                 trove_url  \n",
       "0   https://trove.nla.gov.au/work/10201266  \n",
       "1   https://trove.nla.gov.au/work/10544890  \n",
       "2   https://trove.nla.gov.au/work/14022030  \n",
       "3   https://trove.nla.gov.au/work/14952244  \n",
       "4  https://trove.nla.gov.au/work/152218670  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"unpublished_works_entering_pd_20181006.csv\", keep_default_na=False)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Add institution names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "nuc_list = list(df[\"nuc\"].unique())\n",
    "nucs = []\n",
    "api_url = \"http://api.trove.nla.gov.au/v2/contributor/{}/\"\n",
    "\n",
    "params = {\"encoding\": \"json\", \"key\": API_KEY}\n",
    "\n",
    "for nuc in nuc_list:\n",
    "    if nuc:\n",
    "        response = requests.get(api_url.format(nuc), params=params)\n",
    "        data = response.json()\n",
    "        name = data[\"contributor\"][\"name\"]\n",
    "        nucs.append({\"nuc\": nuc, \"institution\": name})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "tags": []
   },
   "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>creator</th>\n",
       "      <th>date</th>\n",
       "      <th>id</th>\n",
       "      <th>nuc</th>\n",
       "      <th>title</th>\n",
       "      <th>trove_url</th>\n",
       "      <th>institution</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Kelly, F. S. (Frederick Septimus), 1881-1916</td>\n",
       "      <td>1893-1926</td>\n",
       "      <td>10201266</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Music manuscripts</td>\n",
       "      <td>https://trove.nla.gov.au/work/10201266</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td>1863-1925</td>\n",
       "      <td>10544890</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Collection of promissory notes from remote are...</td>\n",
       "      <td>https://trove.nla.gov.au/work/10544890</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Kruse, Johann Secundus, 1859-1927</td>\n",
       "      <td>1870-1927</td>\n",
       "      <td>14952244</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Papers of Johann Kruse</td>\n",
       "      <td>https://trove.nla.gov.au/work/14952244</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Freycinet, Rose Marie de, d. 1832</td>\n",
       "      <td>1802-1927</td>\n",
       "      <td>152218670</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Documents relating to Louis and Rose de Freycinet</td>\n",
       "      <td>https://trove.nla.gov.au/work/152218670</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Dickens, Charles, 1812-1870</td>\n",
       "      <td>1869</td>\n",
       "      <td>168122181</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Cheque written by Charles Dickens</td>\n",
       "      <td>https://trove.nla.gov.au/work/168122181</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        creator       date         id  nuc  \\\n",
       "0  Kelly, F. S. (Frederick Septimus), 1881-1916  1893-1926   10201266  ANL   \n",
       "1                                                1863-1925   10544890  ANL   \n",
       "2             Kruse, Johann Secundus, 1859-1927  1870-1927   14952244  ANL   \n",
       "3             Freycinet, Rose Marie de, d. 1832  1802-1927  152218670  ANL   \n",
       "4                   Dickens, Charles, 1812-1870       1869  168122181  ANL   \n",
       "\n",
       "                                               title  \\\n",
       "0                                  Music manuscripts   \n",
       "1  Collection of promissory notes from remote are...   \n",
       "2                             Papers of Johann Kruse   \n",
       "3  Documents relating to Louis and Rose de Freycinet   \n",
       "4                  Cheque written by Charles Dickens   \n",
       "\n",
       "                                 trove_url                     institution  \n",
       "0   https://trove.nla.gov.au/work/10201266  National Library of Australia.  \n",
       "1   https://trove.nla.gov.au/work/10544890  National Library of Australia.  \n",
       "2   https://trove.nla.gov.au/work/14952244  National Library of Australia.  \n",
       "3  https://trove.nla.gov.au/work/152218670  National Library of Australia.  \n",
       "4  https://trove.nla.gov.au/work/168122181  National Library of Australia.  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nucs_df = pd.DataFrame(nucs)\n",
    "df_new = pd.merge(df, nucs_df, on=\"nuc\")\n",
    "df_new.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Top 50 institutions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "tags": []
   },
   "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>nuc</th>\n",
       "      <th>institution</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>QSA</td>\n",
       "      <td>Queensland State Archives.</td>\n",
       "      <td>2965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TSL</td>\n",
       "      <td>Libraries Tasmania.</td>\n",
       "      <td>2112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ANL</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "      <td>1781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>VSL</td>\n",
       "      <td>State Library Victoria.</td>\n",
       "      <td>1642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>WLB</td>\n",
       "      <td>State Library of Western Australia.</td>\n",
       "      <td>779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>QBCL:BI</td>\n",
       "      <td>Brisbane City Council Library Service. Brisban...</td>\n",
       "      <td>709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NSL</td>\n",
       "      <td>State Library of NSW.</td>\n",
       "      <td>643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>QSL</td>\n",
       "      <td>State Library of Queensland.</td>\n",
       "      <td>630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SSL</td>\n",
       "      <td>State Library of South Australia.</td>\n",
       "      <td>375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>QU</td>\n",
       "      <td>The University of Queensland. University of Qu...</td>\n",
       "      <td>268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>VUMA</td>\n",
       "      <td>The University of Melbourne. University of Mel...</td>\n",
       "      <td>237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>SFU</td>\n",
       "      <td>Flinders University. Flinders University Centr...</td>\n",
       "      <td>226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>SAUS</td>\n",
       "      <td>AusStage.</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>QU:IR</td>\n",
       "      <td>The University of Queensland. University of Qu...</td>\n",
       "      <td>169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>AIAS</td>\n",
       "      <td>Australian Institute of Aboriginal and Torres ...</td>\n",
       "      <td>133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>VRHS</td>\n",
       "      <td>Royal Historical Society of Victoria. Royal Hi...</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>NU</td>\n",
       "      <td>The University of Sydney. University of Sydney...</td>\n",
       "      <td>101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>NMUS:E</td>\n",
       "      <td>Powerhouse Museum. Exhibitions and  Programs.</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>ZZZ</td>\n",
       "      <td>Location unknown.</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NMTC:SM</td>\n",
       "      <td>Moore Theological College. Moore Theological C...</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>AAWM</td>\n",
       "      <td>Australian War Memorial. Research Centre.</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>VNMU:I</td>\n",
       "      <td>Museums Victoria. Museums Victoria Collections.</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>VPRO</td>\n",
       "      <td>Public Record Office Victoria. Victorian Archi...</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NMMU:C</td>\n",
       "      <td>Australian National Maritime Museum. Collection.</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>AMOA:C</td>\n",
       "      <td>National Museum of Australia. National Museum ...</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>SRGS</td>\n",
       "      <td>Royal Geographical Society of South Australia....</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>SUSA:A</td>\n",
       "      <td>University of South Australia. University of S...</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>NWU:DC</td>\n",
       "      <td>University of Wollongong. University of Wollon...</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>VU</td>\n",
       "      <td>The University of Melbourne. The University of...</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>NNPL</td>\n",
       "      <td>Newcastle Region Libraries. Newcastle Region L...</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>NMQU:MA</td>\n",
       "      <td>Macquarie University. Macquarie University Med...</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>APLS</td>\n",
       "      <td>Libraries ACT.</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>SMU</td>\n",
       "      <td>South Australian Museum. SA Museum Library.</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>VMOU</td>\n",
       "      <td>Monash University. Monash University Library.</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>AAAR</td>\n",
       "      <td>National Archives of Australia. National Archi...</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>VDU</td>\n",
       "      <td>Deakin University. Deakin University Library.</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>NNCU:A</td>\n",
       "      <td>University of Newcastle Library.</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>XNLS</td>\n",
       "      <td>Library &amp; Archives NT.</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>NCP</td>\n",
       "      <td>Royal Australasian College of Physicians. Hist...</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>VTAT</td>\n",
       "      <td>Tatura Historical Society. Tatura Irrigation &amp;...</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>NRHS</td>\n",
       "      <td>Royal Australian Historical Society. RAHS Libr...</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>SUA</td>\n",
       "      <td>University of Adelaide. Barr Smith Library.</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>QCQU</td>\n",
       "      <td>Central Queensland University. Rockhampton Cam...</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>NMMU</td>\n",
       "      <td>Australian National Maritime Museum. Vaughan E...</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>NNEA</td>\n",
       "      <td>University of New England and Regional Archives.</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>VGHR</td>\n",
       "      <td>Geelong Heritage Centre.</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>VU:Q</td>\n",
       "      <td>University of Melbourne - Residential College....</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>ADFA</td>\n",
       "      <td>Academy Library, UNSW Canberra.</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>NJHS</td>\n",
       "      <td>Australian Jewish Historical Society Inc. Aust...</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>NSWA</td>\n",
       "      <td>Art Gallery of New South Wales. Edmund and Joa...</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        nuc                                        institution  count\n",
       "0       QSA                         Queensland State Archives.   2965\n",
       "1       TSL                                Libraries Tasmania.   2112\n",
       "2       ANL                     National Library of Australia.   1781\n",
       "3       VSL                            State Library Victoria.   1642\n",
       "4       WLB                State Library of Western Australia.    779\n",
       "5   QBCL:BI  Brisbane City Council Library Service. Brisban...    709\n",
       "6       NSL                              State Library of NSW.    643\n",
       "7       QSL                       State Library of Queensland.    630\n",
       "8       SSL                  State Library of South Australia.    375\n",
       "9        QU  The University of Queensland. University of Qu...    268\n",
       "10     VUMA  The University of Melbourne. University of Mel...    237\n",
       "11      SFU  Flinders University. Flinders University Centr...    226\n",
       "12     SAUS                                          AusStage.    220\n",
       "13    QU:IR  The University of Queensland. University of Qu...    169\n",
       "14     AIAS  Australian Institute of Aboriginal and Torres ...    133\n",
       "15     VRHS  Royal Historical Society of Victoria. Royal Hi...    128\n",
       "16       NU  The University of Sydney. University of Sydney...    101\n",
       "17   NMUS:E      Powerhouse Museum. Exhibitions and  Programs.     96\n",
       "18      ZZZ                                  Location unknown.     96\n",
       "19  NMTC:SM  Moore Theological College. Moore Theological C...     93\n",
       "20     AAWM          Australian War Memorial. Research Centre.     93\n",
       "21   VNMU:I    Museums Victoria. Museums Victoria Collections.     75\n",
       "22     VPRO  Public Record Office Victoria. Victorian Archi...     72\n",
       "23   NMMU:C   Australian National Maritime Museum. Collection.     66\n",
       "24   AMOA:C  National Museum of Australia. National Museum ...     58\n",
       "25     SRGS  Royal Geographical Society of South Australia....     58\n",
       "26   SUSA:A  University of South Australia. University of S...     52\n",
       "27   NWU:DC  University of Wollongong. University of Wollon...     49\n",
       "28       VU  The University of Melbourne. The University of...     41\n",
       "29     NNPL  Newcastle Region Libraries. Newcastle Region L...     40\n",
       "30  NMQU:MA  Macquarie University. Macquarie University Med...     33\n",
       "31     APLS                                     Libraries ACT.     25\n",
       "32      SMU        South Australian Museum. SA Museum Library.     25\n",
       "33     VMOU      Monash University. Monash University Library.     24\n",
       "34     AAAR  National Archives of Australia. National Archi...     22\n",
       "35      VDU      Deakin University. Deakin University Library.     21\n",
       "36   NNCU:A                   University of Newcastle Library.     20\n",
       "37     XNLS                             Library & Archives NT.     20\n",
       "38      NCP  Royal Australasian College of Physicians. Hist...     19\n",
       "39     VTAT  Tatura Historical Society. Tatura Irrigation &...     19\n",
       "40     NRHS  Royal Australian Historical Society. RAHS Libr...     18\n",
       "41      SUA        University of Adelaide. Barr Smith Library.     18\n",
       "42     QCQU  Central Queensland University. Rockhampton Cam...     17\n",
       "43     NMMU  Australian National Maritime Museum. Vaughan E...     15\n",
       "44     NNEA   University of New England and Regional Archives.     14\n",
       "45     VGHR                           Geelong Heritage Centre.     11\n",
       "46     VU:Q  University of Melbourne - Residential College....     11\n",
       "47     ADFA                    Academy Library, UNSW Canberra.     11\n",
       "48     NJHS  Australian Jewish Historical Society Inc. Aust...     10\n",
       "49     NSWA  Art Gallery of New South Wales. Edmund and Joa...      9"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "institutions = (\n",
    "    df_new.groupby([\"nuc\", \"institution\"])\n",
    "    .size()\n",
    "    .sort_values(ascending=False)\n",
    "    .to_frame()\n",
    "    .reset_index()\n",
    ")\n",
    "institutions.columns = [\"nuc\", \"institution\", \"count\"]\n",
    "institutions[:50]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "tags": []
   },
   "source": [
    "## Filter by title keyword"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "tags": []
   },
   "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>creator</th>\n",
       "      <th>date</th>\n",
       "      <th>id</th>\n",
       "      <th>nuc</th>\n",
       "      <th>title</th>\n",
       "      <th>trove_url</th>\n",
       "      <th>institution</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>654</th>\n",
       "      <td></td>\n",
       "      <td>1892-1909</td>\n",
       "      <td>10918152</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Federation - Australia</td>\n",
       "      <td>https://trove.nla.gov.au/work/10918152</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td></td>\n",
       "      <td>1947</td>\n",
       "      <td>159853683</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Communist influence in Teachers Federation</td>\n",
       "      <td>https://trove.nla.gov.au/work/159853683</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1140</th>\n",
       "      <td>Barton, Edmund Sir, 1849-1920</td>\n",
       "      <td>1897-1898</td>\n",
       "      <td>23733819</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Letter and handbills relating to Australian fe...</td>\n",
       "      <td>https://trove.nla.gov.au/work/23733819</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1298</th>\n",
       "      <td></td>\n",
       "      <td>1899</td>\n",
       "      <td>27029040</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Synopsis of the Commonwealth Bill : approved b...</td>\n",
       "      <td>https://trove.nla.gov.au/work/27029040</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1312</th>\n",
       "      <td></td>\n",
       "      <td>1890-1891</td>\n",
       "      <td>28833077</td>\n",
       "      <td>ANL</td>\n",
       "      <td>The federation movement, and proceedings of th...</td>\n",
       "      <td>https://trove.nla.gov.au/work/28833077</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1313</th>\n",
       "      <td></td>\n",
       "      <td>1895-1901</td>\n",
       "      <td>28833285</td>\n",
       "      <td>ANL</td>\n",
       "      <td>The Australian federation movement from a Sout...</td>\n",
       "      <td>https://trove.nla.gov.au/work/28833285</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1683</th>\n",
       "      <td></td>\n",
       "      <td>1895-1901</td>\n",
       "      <td>5891330</td>\n",
       "      <td>ANL</td>\n",
       "      <td>The Australian federation movement from a Sout...</td>\n",
       "      <td>https://trove.nla.gov.au/work/5891330</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1696</th>\n",
       "      <td>Henry, John, 1834-1912</td>\n",
       "      <td>1899</td>\n",
       "      <td>6050113</td>\n",
       "      <td>ANL</td>\n",
       "      <td>[Comments of the honourable John Henry dealing...</td>\n",
       "      <td>https://trove.nla.gov.au/work/6050113</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2059</th>\n",
       "      <td></td>\n",
       "      <td>1900</td>\n",
       "      <td>191699908</td>\n",
       "      <td>WLB</td>\n",
       "      <td>Records of Australian Federation of Friends of...</td>\n",
       "      <td>https://trove.nla.gov.au/work/191699908</td>\n",
       "      <td>State Library of Western Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4774</th>\n",
       "      <td></td>\n",
       "      <td>1928</td>\n",
       "      <td>200344170</td>\n",
       "      <td>QSL</td>\n",
       "      <td>Waterside Workers Federation Cutting Book</td>\n",
       "      <td>https://trove.nla.gov.au/work/200344170</td>\n",
       "      <td>State Library of Queensland.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6395</th>\n",
       "      <td></td>\n",
       "      <td>1898-1901</td>\n",
       "      <td>157372346</td>\n",
       "      <td>TSL</td>\n",
       "      <td>Federation League of Northern Tasmania NG2368 ...</td>\n",
       "      <td>https://trove.nla.gov.au/work/157372346</td>\n",
       "      <td>Libraries Tasmania.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6719</th>\n",
       "      <td></td>\n",
       "      <td>1917</td>\n",
       "      <td>157373022</td>\n",
       "      <td>TSL</td>\n",
       "      <td>National Federation League - Derby Branch NG14...</td>\n",
       "      <td>https://trove.nla.gov.au/work/157373022</td>\n",
       "      <td>Libraries Tasmania.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8816</th>\n",
       "      <td></td>\n",
       "      <td>1901</td>\n",
       "      <td>197248968</td>\n",
       "      <td>VDU</td>\n",
       "      <td>Federation Day photograph album</td>\n",
       "      <td>https://trove.nla.gov.au/work/197248968</td>\n",
       "      <td>Deakin University. Deakin University Library.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9318</th>\n",
       "      <td></td>\n",
       "      <td>1902</td>\n",
       "      <td>206859905</td>\n",
       "      <td>VUMA</td>\n",
       "      <td>FEDERATED WOOL AND BASIL WORKERS FEDERATION, V...</td>\n",
       "      <td>https://trove.nla.gov.au/work/206859905</td>\n",
       "      <td>The University of Melbourne. University of Mel...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            creator       date         id   nuc  \\\n",
       "654                                  1892-1909   10918152   ANL   \n",
       "752                                       1947  159853683   ANL   \n",
       "1140  Barton, Edmund Sir, 1849-1920  1897-1898   23733819   ANL   \n",
       "1298                                      1899   27029040   ANL   \n",
       "1312                                 1890-1891   28833077   ANL   \n",
       "1313                                 1895-1901   28833285   ANL   \n",
       "1683                                 1895-1901    5891330   ANL   \n",
       "1696         Henry, John, 1834-1912       1899    6050113   ANL   \n",
       "2059                                      1900  191699908   WLB   \n",
       "4774                                      1928  200344170   QSL   \n",
       "6395                                 1898-1901  157372346   TSL   \n",
       "6719                                      1917  157373022   TSL   \n",
       "8816                                      1901  197248968   VDU   \n",
       "9318                                      1902  206859905  VUMA   \n",
       "\n",
       "                                                  title  \\\n",
       "654                              Federation - Australia   \n",
       "752          Communist influence in Teachers Federation   \n",
       "1140  Letter and handbills relating to Australian fe...   \n",
       "1298  Synopsis of the Commonwealth Bill : approved b...   \n",
       "1312  The federation movement, and proceedings of th...   \n",
       "1313  The Australian federation movement from a Sout...   \n",
       "1683  The Australian federation movement from a Sout...   \n",
       "1696  [Comments of the honourable John Henry dealing...   \n",
       "2059  Records of Australian Federation of Friends of...   \n",
       "4774          Waterside Workers Federation Cutting Book   \n",
       "6395  Federation League of Northern Tasmania NG2368 ...   \n",
       "6719  National Federation League - Derby Branch NG14...   \n",
       "8816                    Federation Day photograph album   \n",
       "9318  FEDERATED WOOL AND BASIL WORKERS FEDERATION, V...   \n",
       "\n",
       "                                    trove_url  \\\n",
       "654    https://trove.nla.gov.au/work/10918152   \n",
       "752   https://trove.nla.gov.au/work/159853683   \n",
       "1140   https://trove.nla.gov.au/work/23733819   \n",
       "1298   https://trove.nla.gov.au/work/27029040   \n",
       "1312   https://trove.nla.gov.au/work/28833077   \n",
       "1313   https://trove.nla.gov.au/work/28833285   \n",
       "1683    https://trove.nla.gov.au/work/5891330   \n",
       "1696    https://trove.nla.gov.au/work/6050113   \n",
       "2059  https://trove.nla.gov.au/work/191699908   \n",
       "4774  https://trove.nla.gov.au/work/200344170   \n",
       "6395  https://trove.nla.gov.au/work/157372346   \n",
       "6719  https://trove.nla.gov.au/work/157373022   \n",
       "8816  https://trove.nla.gov.au/work/197248968   \n",
       "9318  https://trove.nla.gov.au/work/206859905   \n",
       "\n",
       "                                            institution  \n",
       "654                      National Library of Australia.  \n",
       "752                      National Library of Australia.  \n",
       "1140                     National Library of Australia.  \n",
       "1298                     National Library of Australia.  \n",
       "1312                     National Library of Australia.  \n",
       "1313                     National Library of Australia.  \n",
       "1683                     National Library of Australia.  \n",
       "1696                     National Library of Australia.  \n",
       "2059                State Library of Western Australia.  \n",
       "4774                       State Library of Queensland.  \n",
       "6395                                Libraries Tasmania.  \n",
       "6719                                Libraries Tasmania.  \n",
       "8816      Deakin University. Deakin University Library.  \n",
       "9318  The University of Melbourne. University of Mel...  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "title_kw = \"federation\"  # Edit to add your own keyword!\n",
    "filtered_title = df_new.loc[\n",
    "    df_new[\"title\"].str.contains(title_kw, case=False, na=False)\n",
    "]\n",
    "filtered_title"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {
    "tags": [
     "nbval-skip"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<a target=\"_blank\" href=\"filtered_title_federation.csv\">Download CSV file</a>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Save filtered results as a CSV file\n",
    "filtered_title.to_csv(\"filtered_title_{}.csv\".format(title_kw), index=False)\n",
    "# Make a download link\n",
    "display(\n",
    "    HTML(\n",
    "        '<a target=\"_blank\" href=\"{}\">Download CSV file</a>'.format(\n",
    "            \"filtered_title_{}.csv\".format(title_kw)\n",
    "        )\n",
    "    )\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Filter by creator name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "tags": []
   },
   "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>creator</th>\n",
       "      <th>date</th>\n",
       "      <th>id</th>\n",
       "      <th>nuc</th>\n",
       "      <th>title</th>\n",
       "      <th>trove_url</th>\n",
       "      <th>institution</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Barton, Edmund, Sir, 1849-1920</td>\n",
       "      <td>1827-1940</td>\n",
       "      <td>27034442</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Papers of Sir Edmund Barton</td>\n",
       "      <td>https://trove.nla.gov.au/work/27034442</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>Barton, Edmund, Sir, 1849-1920</td>\n",
       "      <td>1827-1940</td>\n",
       "      <td>14890081</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Papers of Sir Edmund Barton</td>\n",
       "      <td>https://trove.nla.gov.au/work/14890081</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>Barton, Edmund Sir, 1849-1920</td>\n",
       "      <td>1902</td>\n",
       "      <td>21003348</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Correspondence between Edmund Barton and Capta...</td>\n",
       "      <td>https://trove.nla.gov.au/work/21003348</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>938</th>\n",
       "      <td>Paterson, A. B. (Andrew Barton), 1864-1941</td>\n",
       "      <td>1905-1969</td>\n",
       "      <td>20843868</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Material relating to Waltzing Matilda</td>\n",
       "      <td>https://trove.nla.gov.au/work/20843868</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1008</th>\n",
       "      <td>Barton, Edmund Sir, 1849-1920</td>\n",
       "      <td>1887-1947</td>\n",
       "      <td>21730412</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Letters, papers, bill</td>\n",
       "      <td>https://trove.nla.gov.au/work/21730412</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1140</th>\n",
       "      <td>Barton, Edmund Sir, 1849-1920</td>\n",
       "      <td>1897-1898</td>\n",
       "      <td>23733819</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Letter and handbills relating to Australian fe...</td>\n",
       "      <td>https://trove.nla.gov.au/work/23733819</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1218</th>\n",
       "      <td>Barton, Edmund Sir, 1849-1920</td>\n",
       "      <td>1901</td>\n",
       "      <td>24351962</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Speech delivered by Barton at the opening of F...</td>\n",
       "      <td>https://trove.nla.gov.au/work/24351962</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1291</th>\n",
       "      <td>Barton, G. B. (George Burnett), 1836-1901</td>\n",
       "      <td>1800-1899</td>\n",
       "      <td>24904338</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Manuscripts</td>\n",
       "      <td>https://trove.nla.gov.au/work/24904338</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1396</th>\n",
       "      <td>Paterson, A. B. (Andrew Barton), 1864-1941</td>\n",
       "      <td>1896</td>\n",
       "      <td>34380059</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Letter : Sydney to Thos. Whitby, Blackheath</td>\n",
       "      <td>https://trove.nla.gov.au/work/34380059</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1412</th>\n",
       "      <td>Barton, Edmund Sir, 1849-1920</td>\n",
       "      <td>1901</td>\n",
       "      <td>34392819</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Letters</td>\n",
       "      <td>https://trove.nla.gov.au/work/34392819</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1443</th>\n",
       "      <td>Paterson, A. B. (Andrew Barton), 1864-1941</td>\n",
       "      <td>1939</td>\n",
       "      <td>34444414</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Letter : Sydney, to Lawrence Henry Copping</td>\n",
       "      <td>https://trove.nla.gov.au/work/34444414</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1473</th>\n",
       "      <td>Hack, John Barton, 1805-1884</td>\n",
       "      <td>1820-1884</td>\n",
       "      <td>34692159</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Family papers</td>\n",
       "      <td>https://trove.nla.gov.au/work/34692159</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1581</th>\n",
       "      <td>Paterson, A. B. (Andrew Barton), 1864-1941</td>\n",
       "      <td>1859-1896</td>\n",
       "      <td>34892978</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Early Australian letters and booklet</td>\n",
       "      <td>https://trove.nla.gov.au/work/34892978</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1609</th>\n",
       "      <td>Barton, Edmund Sir, 1849-1920</td>\n",
       "      <td>1903</td>\n",
       "      <td>35097888</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Letter : to Isaac Isaacs</td>\n",
       "      <td>https://trove.nla.gov.au/work/35097888</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1710</th>\n",
       "      <td>Barton, Edmund, Sir, 1849-1920</td>\n",
       "      <td>1902</td>\n",
       "      <td>6116810</td>\n",
       "      <td>ANL</td>\n",
       "      <td>[Address, to welcome Sir Edmund Barton, Ottawa]</td>\n",
       "      <td>https://trove.nla.gov.au/work/6116810</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1726</th>\n",
       "      <td>Barton, Edmund, Sir, 1849-1920</td>\n",
       "      <td>1902</td>\n",
       "      <td>6148440</td>\n",
       "      <td>ANL</td>\n",
       "      <td>[Document of congratulation from British Fair ...</td>\n",
       "      <td>https://trove.nla.gov.au/work/6148440</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1741</th>\n",
       "      <td>Paterson, A. B. (Andrew Barton), 1864-1941</td>\n",
       "      <td>1900-1915</td>\n",
       "      <td>6466365</td>\n",
       "      <td>ANL</td>\n",
       "      <td>There's another bloody horse fell down [by] A....</td>\n",
       "      <td>https://trove.nla.gov.au/work/6466365</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1759</th>\n",
       "      <td>Paterson, A. B. (Andrew Barton), 1864-1941</td>\n",
       "      <td>1915-1920</td>\n",
       "      <td>8651892</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Letters</td>\n",
       "      <td>https://trove.nla.gov.au/work/8651892</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1762</th>\n",
       "      <td>Paterson, A. B. (Andrew Barton), 1864-1941</td>\n",
       "      <td>1896</td>\n",
       "      <td>8994780</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Letter of A.B. Paterson</td>\n",
       "      <td>https://trove.nla.gov.au/work/8994780</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2870</th>\n",
       "      <td>Barton, Edmund, Sir, 1849-1920</td>\n",
       "      <td></td>\n",
       "      <td>32034635</td>\n",
       "      <td>VSL</td>\n",
       "      <td>Papers</td>\n",
       "      <td>https://trove.nla.gov.au/work/32034635</td>\n",
       "      <td>State Library Victoria.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5249</th>\n",
       "      <td>Barton, Newton, 1870-1935</td>\n",
       "      <td>1894-1895</td>\n",
       "      <td>203843366</td>\n",
       "      <td>QSL</td>\n",
       "      <td>Newton Barton Diary</td>\n",
       "      <td>https://trove.nla.gov.au/work/203843366</td>\n",
       "      <td>State Library of Queensland.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5567</th>\n",
       "      <td>Paterson, A. B. (Andrew Barton), 1864-1941</td>\n",
       "      <td>1992</td>\n",
       "      <td>35083238</td>\n",
       "      <td>NSL</td>\n",
       "      <td>The man from ironbark / A.B. Paterson ; [calli...</td>\n",
       "      <td>https://trove.nla.gov.au/work/35083238</td>\n",
       "      <td>State Library of NSW.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5921</th>\n",
       "      <td>Barton, G. B. (George Burnett), 1836-1901</td>\n",
       "      <td>1890</td>\n",
       "      <td>35932172</td>\n",
       "      <td>NSL</td>\n",
       "      <td>The life and speeches of William Charles Wentw...</td>\n",
       "      <td>https://trove.nla.gov.au/work/35932172</td>\n",
       "      <td>State Library of NSW.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5979</th>\n",
       "      <td>Brady, Alfred Barton, 1856-1932</td>\n",
       "      <td>1893</td>\n",
       "      <td>231806214</td>\n",
       "      <td>QU</td>\n",
       "      <td>Drawings of the new Victoria Bridge, Brisbane</td>\n",
       "      <td>https://trove.nla.gov.au/work/231806214</td>\n",
       "      <td>The University of Queensland. University of Qu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6121</th>\n",
       "      <td>Barton, Edmund, Sir, 1849-1920</td>\n",
       "      <td>1901</td>\n",
       "      <td>36300223</td>\n",
       "      <td>QU</td>\n",
       "      <td>Letter : Milson's Point, N.S.W. to A.S. Cowley</td>\n",
       "      <td>https://trove.nla.gov.au/work/36300223</td>\n",
       "      <td>The University of Queensland. University of Qu...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         creator       date         id  nuc  \\\n",
       "28                Barton, Edmund, Sir, 1849-1920  1827-1940   27034442  ANL   \n",
       "161               Barton, Edmund, Sir, 1849-1920  1827-1940   14890081  ANL   \n",
       "237                Barton, Edmund Sir, 1849-1920       1902   21003348  ANL   \n",
       "938   Paterson, A. B. (Andrew Barton), 1864-1941  1905-1969   20843868  ANL   \n",
       "1008               Barton, Edmund Sir, 1849-1920  1887-1947   21730412  ANL   \n",
       "1140               Barton, Edmund Sir, 1849-1920  1897-1898   23733819  ANL   \n",
       "1218               Barton, Edmund Sir, 1849-1920       1901   24351962  ANL   \n",
       "1291   Barton, G. B. (George Burnett), 1836-1901  1800-1899   24904338  ANL   \n",
       "1396  Paterson, A. B. (Andrew Barton), 1864-1941       1896   34380059  ANL   \n",
       "1412               Barton, Edmund Sir, 1849-1920       1901   34392819  ANL   \n",
       "1443  Paterson, A. B. (Andrew Barton), 1864-1941       1939   34444414  ANL   \n",
       "1473                Hack, John Barton, 1805-1884  1820-1884   34692159  ANL   \n",
       "1581  Paterson, A. B. (Andrew Barton), 1864-1941  1859-1896   34892978  ANL   \n",
       "1609               Barton, Edmund Sir, 1849-1920       1903   35097888  ANL   \n",
       "1710              Barton, Edmund, Sir, 1849-1920       1902    6116810  ANL   \n",
       "1726              Barton, Edmund, Sir, 1849-1920       1902    6148440  ANL   \n",
       "1741  Paterson, A. B. (Andrew Barton), 1864-1941  1900-1915    6466365  ANL   \n",
       "1759  Paterson, A. B. (Andrew Barton), 1864-1941  1915-1920    8651892  ANL   \n",
       "1762  Paterson, A. B. (Andrew Barton), 1864-1941       1896    8994780  ANL   \n",
       "2870              Barton, Edmund, Sir, 1849-1920              32034635  VSL   \n",
       "5249                   Barton, Newton, 1870-1935  1894-1895  203843366  QSL   \n",
       "5567  Paterson, A. B. (Andrew Barton), 1864-1941       1992   35083238  NSL   \n",
       "5921   Barton, G. B. (George Burnett), 1836-1901       1890   35932172  NSL   \n",
       "5979             Brady, Alfred Barton, 1856-1932       1893  231806214   QU   \n",
       "6121              Barton, Edmund, Sir, 1849-1920       1901   36300223   QU   \n",
       "\n",
       "                                                  title  \\\n",
       "28                          Papers of Sir Edmund Barton   \n",
       "161                         Papers of Sir Edmund Barton   \n",
       "237   Correspondence between Edmund Barton and Capta...   \n",
       "938               Material relating to Waltzing Matilda   \n",
       "1008                              Letters, papers, bill   \n",
       "1140  Letter and handbills relating to Australian fe...   \n",
       "1218  Speech delivered by Barton at the opening of F...   \n",
       "1291                                        Manuscripts   \n",
       "1396        Letter : Sydney to Thos. Whitby, Blackheath   \n",
       "1412                                            Letters   \n",
       "1443         Letter : Sydney, to Lawrence Henry Copping   \n",
       "1473                                      Family papers   \n",
       "1581               Early Australian letters and booklet   \n",
       "1609                           Letter : to Isaac Isaacs   \n",
       "1710    [Address, to welcome Sir Edmund Barton, Ottawa]   \n",
       "1726  [Document of congratulation from British Fair ...   \n",
       "1741  There's another bloody horse fell down [by] A....   \n",
       "1759                                            Letters   \n",
       "1762                            Letter of A.B. Paterson   \n",
       "2870                                             Papers   \n",
       "5249                                Newton Barton Diary   \n",
       "5567  The man from ironbark / A.B. Paterson ; [calli...   \n",
       "5921  The life and speeches of William Charles Wentw...   \n",
       "5979      Drawings of the new Victoria Bridge, Brisbane   \n",
       "6121     Letter : Milson's Point, N.S.W. to A.S. Cowley   \n",
       "\n",
       "                                    trove_url  \\\n",
       "28     https://trove.nla.gov.au/work/27034442   \n",
       "161    https://trove.nla.gov.au/work/14890081   \n",
       "237    https://trove.nla.gov.au/work/21003348   \n",
       "938    https://trove.nla.gov.au/work/20843868   \n",
       "1008   https://trove.nla.gov.au/work/21730412   \n",
       "1140   https://trove.nla.gov.au/work/23733819   \n",
       "1218   https://trove.nla.gov.au/work/24351962   \n",
       "1291   https://trove.nla.gov.au/work/24904338   \n",
       "1396   https://trove.nla.gov.au/work/34380059   \n",
       "1412   https://trove.nla.gov.au/work/34392819   \n",
       "1443   https://trove.nla.gov.au/work/34444414   \n",
       "1473   https://trove.nla.gov.au/work/34692159   \n",
       "1581   https://trove.nla.gov.au/work/34892978   \n",
       "1609   https://trove.nla.gov.au/work/35097888   \n",
       "1710    https://trove.nla.gov.au/work/6116810   \n",
       "1726    https://trove.nla.gov.au/work/6148440   \n",
       "1741    https://trove.nla.gov.au/work/6466365   \n",
       "1759    https://trove.nla.gov.au/work/8651892   \n",
       "1762    https://trove.nla.gov.au/work/8994780   \n",
       "2870   https://trove.nla.gov.au/work/32034635   \n",
       "5249  https://trove.nla.gov.au/work/203843366   \n",
       "5567   https://trove.nla.gov.au/work/35083238   \n",
       "5921   https://trove.nla.gov.au/work/35932172   \n",
       "5979  https://trove.nla.gov.au/work/231806214   \n",
       "6121   https://trove.nla.gov.au/work/36300223   \n",
       "\n",
       "                                            institution  \n",
       "28                       National Library of Australia.  \n",
       "161                      National Library of Australia.  \n",
       "237                      National Library of Australia.  \n",
       "938                      National Library of Australia.  \n",
       "1008                     National Library of Australia.  \n",
       "1140                     National Library of Australia.  \n",
       "1218                     National Library of Australia.  \n",
       "1291                     National Library of Australia.  \n",
       "1396                     National Library of Australia.  \n",
       "1412                     National Library of Australia.  \n",
       "1443                     National Library of Australia.  \n",
       "1473                     National Library of Australia.  \n",
       "1581                     National Library of Australia.  \n",
       "1609                     National Library of Australia.  \n",
       "1710                     National Library of Australia.  \n",
       "1726                     National Library of Australia.  \n",
       "1741                     National Library of Australia.  \n",
       "1759                     National Library of Australia.  \n",
       "1762                     National Library of Australia.  \n",
       "2870                            State Library Victoria.  \n",
       "5249                       State Library of Queensland.  \n",
       "5567                              State Library of NSW.  \n",
       "5921                              State Library of NSW.  \n",
       "5979  The University of Queensland. University of Qu...  \n",
       "6121  The University of Queensland. University of Qu...  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "creator_kw = \"barton\"  # Edit to add your own name!\n",
    "filtered_creator = df_new.loc[\n",
    "    df_new[\"creator\"].str.contains(creator_kw, case=False, na=False)\n",
    "]\n",
    "filtered_creator"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {
    "tags": [
     "nbval-skip"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<a target=\"_blank\" href=\"filtered_creator_barton.csv\">Download CSV file</a>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Save filtered results as a CSV file\n",
    "filtered_creator.to_csv(\"filtered_creator_{}.csv\".format(creator_kw), index=False)\n",
    "# Make a download link\n",
    "display(\n",
    "    HTML(\n",
    "        '<a target=\"_blank\" href=\"{}\">Download CSV file</a>'.format(\n",
    "            \"filtered_creator_{}.csv\".format(creator_kw)\n",
    "        )\n",
    "    )\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Filter by institution (nuc)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "tags": []
   },
   "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>creator</th>\n",
       "      <th>date</th>\n",
       "      <th>id</th>\n",
       "      <th>nuc</th>\n",
       "      <th>title</th>\n",
       "      <th>trove_url</th>\n",
       "      <th>institution</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Kelly, F. S. (Frederick Septimus), 1881-1916</td>\n",
       "      <td>1893-1926</td>\n",
       "      <td>10201266</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Music manuscripts</td>\n",
       "      <td>https://trove.nla.gov.au/work/10201266</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td>1863-1925</td>\n",
       "      <td>10544890</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Collection of promissory notes from remote are...</td>\n",
       "      <td>https://trove.nla.gov.au/work/10544890</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Kruse, Johann Secundus, 1859-1927</td>\n",
       "      <td>1870-1927</td>\n",
       "      <td>14952244</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Papers of Johann Kruse</td>\n",
       "      <td>https://trove.nla.gov.au/work/14952244</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Freycinet, Rose Marie de, d. 1832</td>\n",
       "      <td>1802-1927</td>\n",
       "      <td>152218670</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Documents relating to Louis and Rose de Freycinet</td>\n",
       "      <td>https://trove.nla.gov.au/work/152218670</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Dickens, Charles, 1812-1870</td>\n",
       "      <td>1869</td>\n",
       "      <td>168122181</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Cheque written by Charles Dickens</td>\n",
       "      <td>https://trove.nla.gov.au/work/168122181</td>\n",
       "      <td>National Library of Australia.</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1776</th>\n",
       "      <td>Hodder, Edwin, 1837-1904</td>\n",
       "      <td>1862</td>\n",
       "      <td>9924046</td>\n",
       "      <td>ANL</td>\n",
       "      <td>The Junior Clerk, a Tale of City Life</td>\n",
       "      <td>https://trove.nla.gov.au/work/9924046</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1777</th>\n",
       "      <td>Eden, Charles H. (Charles Henry), 1839-1900</td>\n",
       "      <td>1875</td>\n",
       "      <td>9924065</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Ralph Somerville, or, a Midshipman's Adventure...</td>\n",
       "      <td>https://trove.nla.gov.au/work/9924065</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1778</th>\n",
       "      <td>Beechey, Frederick William, 1796-1856</td>\n",
       "      <td>1856</td>\n",
       "      <td>9924073</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Biography</td>\n",
       "      <td>https://trove.nla.gov.au/work/9924073</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1779</th>\n",
       "      <td>Farrer, William, 1845-1906</td>\n",
       "      <td>1901-1902</td>\n",
       "      <td>9946088</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Field book</td>\n",
       "      <td>https://trove.nla.gov.au/work/9946088</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1780</th>\n",
       "      <td>Cawley, John, fl. 1834</td>\n",
       "      <td>1834-1835</td>\n",
       "      <td>9959583</td>\n",
       "      <td>ANL</td>\n",
       "      <td>Letters and printed statement</td>\n",
       "      <td>https://trove.nla.gov.au/work/9959583</td>\n",
       "      <td>National Library of Australia.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1781 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           creator       date         id  nuc  \\\n",
       "0     Kelly, F. S. (Frederick Septimus), 1881-1916  1893-1926   10201266  ANL   \n",
       "1                                                   1863-1925   10544890  ANL   \n",
       "2                Kruse, Johann Secundus, 1859-1927  1870-1927   14952244  ANL   \n",
       "3                Freycinet, Rose Marie de, d. 1832  1802-1927  152218670  ANL   \n",
       "4                      Dickens, Charles, 1812-1870       1869  168122181  ANL   \n",
       "...                                            ...        ...        ...  ...   \n",
       "1776                      Hodder, Edwin, 1837-1904       1862    9924046  ANL   \n",
       "1777   Eden, Charles H. (Charles Henry), 1839-1900       1875    9924065  ANL   \n",
       "1778         Beechey, Frederick William, 1796-1856       1856    9924073  ANL   \n",
       "1779                    Farrer, William, 1845-1906  1901-1902    9946088  ANL   \n",
       "1780                        Cawley, John, fl. 1834  1834-1835    9959583  ANL   \n",
       "\n",
       "                                                  title  \\\n",
       "0                                     Music manuscripts   \n",
       "1     Collection of promissory notes from remote are...   \n",
       "2                                Papers of Johann Kruse   \n",
       "3     Documents relating to Louis and Rose de Freycinet   \n",
       "4                     Cheque written by Charles Dickens   \n",
       "...                                                 ...   \n",
       "1776              The Junior Clerk, a Tale of City Life   \n",
       "1777  Ralph Somerville, or, a Midshipman's Adventure...   \n",
       "1778                                          Biography   \n",
       "1779                                         Field book   \n",
       "1780                      Letters and printed statement   \n",
       "\n",
       "                                    trove_url                     institution  \n",
       "0      https://trove.nla.gov.au/work/10201266  National Library of Australia.  \n",
       "1      https://trove.nla.gov.au/work/10544890  National Library of Australia.  \n",
       "2      https://trove.nla.gov.au/work/14952244  National Library of Australia.  \n",
       "3     https://trove.nla.gov.au/work/152218670  National Library of Australia.  \n",
       "4     https://trove.nla.gov.au/work/168122181  National Library of Australia.  \n",
       "...                                       ...                             ...  \n",
       "1776    https://trove.nla.gov.au/work/9924046  National Library of Australia.  \n",
       "1777    https://trove.nla.gov.au/work/9924065  National Library of Australia.  \n",
       "1778    https://trove.nla.gov.au/work/9924073  National Library of Australia.  \n",
       "1779    https://trove.nla.gov.au/work/9946088  National Library of Australia.  \n",
       "1780    https://trove.nla.gov.au/work/9959583  National Library of Australia.  \n",
       "\n",
       "[1781 rows x 7 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nuc = \"ANL\"  # Edit to add your own nuc!\n",
    "filtered_nuc = df_new.loc[df_new[\"nuc\"] == nuc]\n",
    "filtered_nuc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {
    "tags": [
     "nbval-skip"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<a target=\"_blank\" href=\"filtered_nuc_ANL.csv\">Download CSV file</a>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Save filtered results as a CSV file\n",
    "filtered_nuc.to_csv(\"filtered_nuc_{}.csv\".format(nuc), index=False)\n",
    "# Make a download link\n",
    "display(\n",
    "    HTML(\n",
    "        '<a target=\"_blank\" href=\"{}\">Download CSV file</a>'.format(\n",
    "            \"filtered_nuc_{}.csv\".format(nuc)\n",
    "        )\n",
    "    )\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "----\n",
    "\n",
    "Created by [Tim Sherratt](https://timsherratt.org/) for the [GLAM Workbench](https://glam-workbench.net/). Support this project by becoming a [GitHub sponsor](https://github.com/sponsors/wragge)."
   ]
  }
 ],
 "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.10.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}