get_contributors_totals_zone_format.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "51b39a59-63dc-48de-9b16-d2dac24f7727",
   "metadata": {},
   "source": [
    "# Get the number of records from each contributor by zone and format\n",
    "\n",
    "In [another notebook](get_contributors.ipynb) I saved a flat list of Trove's metadata contributors. This notebook uses that list to find out the number of records contributed by each organisation, aggregated by zone and format, and does a little exploration of the data.\n",
    "\n",
    "The code in this notebook is used to create weekly harvests of data about Trove contributors which are saved [in this repository](https://github.com/wragge/trove-contributor-totals).\n",
    "\n",
    "The method used is straightforward:\n",
    "\n",
    "- loop through the list of contributors\n",
    "- using the query pattern `nuc:\"[contributor NUC]\"` search all zones for items from that contributor\n",
    "- add the `facet=format` parameter to the search to get facets by item format\n",
    "- process the results by zone and facet to get totals from each contributor"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "465fb822-404d-4937-ad19-06f2f0b215e6",
   "metadata": {},
   "source": [
    "## Set things up"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "94b0f8d1-71ce-4db2-87ed-651d30e5f021",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import datetime\n",
    "import os\n",
    "import time\n",
    "\n",
    "import pandas as pd\n",
    "import requests\n",
    "from requests.adapters import HTTPAdapter\n",
    "from requests.packages.urllib3.util.retry import Retry\n",
    "from tqdm.auto import tqdm\n",
    "\n",
    "# Create a session that will automatically retry on server errors\n",
    "s = requests.Session()\n",
    "retries = Retry(total=5, backoff_factor=1, status_forcelist=[502, 503, 504])\n",
    "s.mount(\"http://\", HTTPAdapter(max_retries=retries))\n",
    "s.mount(\"https://\", HTTPAdapter(max_retries=retries))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "9d18b077-a187-4d22-b71d-824211aa2b34",
   "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": 11,
   "id": "526a22c6-4474-4387-8972-b5396e6b6259",
   "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": "markdown",
   "id": "1900c684-f877-4f72-83e7-1498f9c0896a",
   "metadata": {},
   "source": [
    "## Define some functions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "e84b5f11-4688-43a1-b6dc-c6d08c469a0a",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "def get_children(facet_type, term):\n",
    "    \"\"\"\n",
    "    Get child terms of the current facet term.\n",
    "    \"\"\"\n",
    "    facets = []\n",
    "    for child_term in term[\"term\"]:\n",
    "        facets += get_term(facet_type, child_term)\n",
    "    return facets\n",
    "\n",
    "\n",
    "def get_term(facet_type, term):\n",
    "    \"\"\"\n",
    "    Gets details of an individual facet term as well as any child terms.\n",
    "    Return a list of facet terms\n",
    "    \"\"\"\n",
    "    facets = []\n",
    "    facets.append({facet_type: term[\"search\"], \"total\": int(term[\"count\"])})\n",
    "    if \"term\" in term:\n",
    "        facets += get_children(facet_type, term)\n",
    "    return facets\n",
    "\n",
    "\n",
    "def get_facet_values(zone, facet_type):\n",
    "    \"\"\"\n",
    "    Get all of the terms for a particular from the given zone.\n",
    "    \"\"\"\n",
    "    facet_values = []\n",
    "    # If there are no facet values you might either get and empty string or no facets at all\n",
    "    if \"facets\" in zone and zone[\"facets\"]:\n",
    "        # If there are multiple facets then facets will be a list, otherwise a dict\n",
    "        if isinstance(zone[\"facets\"][\"facet\"], list):\n",
    "            facets = zone[\"facets\"][\"facet\"]\n",
    "        else:\n",
    "            facets = [zone[\"facets\"][\"facet\"]]\n",
    "        for facet in facets:\n",
    "            if facet[\"name\"] == facet_type:\n",
    "                for term in facet[\"term\"]:\n",
    "                    facet_values += get_term(facet_type, term)\n",
    "    return facet_values\n",
    "\n",
    "\n",
    "def get_contrib_totals():\n",
    "    params = {\n",
    "        \"zone\": \"article,book,collection,map,music,people,picture\",\n",
    "        \"facet\": \"format\",\n",
    "        \"encoding\": \"json\",\n",
    "        \"n\": 0,\n",
    "        \"key\": API_KEY,\n",
    "    }\n",
    "    contributors = pd.read_csv(\n",
    "        \"https://raw.githubusercontent.com/wragge/trove-contributor-totals/main/data/trove-contributors.csv\"\n",
    "    ).to_dict(\"records\")\n",
    "    totals = []\n",
    "    formats = []\n",
    "    for contrib in tqdm(contributors):\n",
    "        if nuc := contrib[\"nuc\"]:\n",
    "            params[\"q\"] = f'nuc:\"{nuc}\"'\n",
    "            response = s.get(\"https://api.trove.nla.gov.au/v2/result\", params=params)\n",
    "            data = response.json()\n",
    "            for zone in data[\"response\"][\"zone\"]:\n",
    "                totals.append(\n",
    "                    {\n",
    "                        \"nuc\": nuc,\n",
    "                        \"name\": contrib[\"name\"],\n",
    "                        \"zone\": zone[\"name\"],\n",
    "                        \"total\": zone[\"records\"][\"total\"],\n",
    "                    }\n",
    "                )\n",
    "                facets = get_facet_values(zone, \"format\")\n",
    "                for facet in facets:\n",
    "                    facet.update(\n",
    "                        {\"nuc\": nuc, \"name\": contrib[\"name\"], \"zone\": zone[\"name\"]}\n",
    "                    )\n",
    "                    formats.append(facet)\n",
    "            time.sleep(0.2)\n",
    "    return totals, formats"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "abfd1a81-5fda-4a9c-8a30-694bf1d42dfe",
   "metadata": {},
   "source": [
    "Harvest the data."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ae875e0e-634b-47b4-8801-d5a0f1cd0c96",
   "metadata": {
    "tags": [
     "nbval-skip"
    ]
   },
   "outputs": [],
   "source": [
    "totals, formats = get_contrib_totals()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8979d542-ae14-4e28-a79d-31d94c9daf80",
   "metadata": {},
   "source": [
    "Convert the harvested data to dataframes."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "db554674-36c9-451a-8b5a-1a407e0fd9c6",
   "metadata": {
    "tags": [
     "nbval-skip"
    ]
   },
   "outputs": [],
   "source": [
    "df_totals = pd.DataFrame(totals)\n",
    "df_formats = pd.DataFrame(formats)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "50d0d9f6-9721-43f4-9a92-f8ac5dd18536",
   "metadata": {
    "tags": [
     "nbval-skip"
    ]
   },
   "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>name</th>\n",
       "      <th>zone</th>\n",
       "      <th>total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>VPWLH</td>\n",
       "      <td>4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.</td>\n",
       "      <td>people</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>VPWLH</td>\n",
       "      <td>4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.</td>\n",
       "      <td>map</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>VPWLH</td>\n",
       "      <td>4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.</td>\n",
       "      <td>music</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>VPWLH</td>\n",
       "      <td>4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.</td>\n",
       "      <td>article</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>VPWLH</td>\n",
       "      <td>4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.</td>\n",
       "      <td>collection</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     nuc                                                                 name  \\\n",
       "0  VPWLH  4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.   \n",
       "1  VPWLH  4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.   \n",
       "2  VPWLH  4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.   \n",
       "3  VPWLH  4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.   \n",
       "4  VPWLH  4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.   \n",
       "\n",
       "         zone  total  \n",
       "0      people      0  \n",
       "1         map      0  \n",
       "2       music      0  \n",
       "3     article      3  \n",
       "4  collection     22  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_totals.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "1d3ccfbe-1cf6-4b4a-8c15-b0a8a9cdec19",
   "metadata": {
    "tags": [
     "nbval-skip"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>nuc</th>\n",
       "      <th>zone</th>\n",
       "      <th>format</th>\n",
       "      <th>total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.</td>\n",
       "      <td>VPWLH</td>\n",
       "      <td>article</td>\n",
       "      <td>Article</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.</td>\n",
       "      <td>VPWLH</td>\n",
       "      <td>article</td>\n",
       "      <td>Article/Other article</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.</td>\n",
       "      <td>VPWLH</td>\n",
       "      <td>article</td>\n",
       "      <td>Article/Report</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.</td>\n",
       "      <td>VPWLH</td>\n",
       "      <td>article</td>\n",
       "      <td>Periodical</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.</td>\n",
       "      <td>VPWLH</td>\n",
       "      <td>article</td>\n",
       "      <td>Periodical/Journal, magazine, other</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                  name    nuc  \\\n",
       "0  4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.  VPWLH   \n",
       "1  4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.  VPWLH   \n",
       "2  4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.  VPWLH   \n",
       "3  4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.  VPWLH   \n",
       "4  4th/19th Prince of Wales'  Light Horse Regiment Unit. History Room.  VPWLH   \n",
       "\n",
       "      zone                               format  total  \n",
       "0  article                              Article      2  \n",
       "1  article                Article/Other article      1  \n",
       "2  article                       Article/Report      1  \n",
       "3  article                           Periodical      1  \n",
       "4  article  Periodical/Journal, magazine, other      1  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_formats.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7f412d8a-b463-458d-8786-880d78437cec",
   "metadata": {},
   "source": [
    "Save the harvested data as CSV files."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "126fa363-4125-4c24-a848-85c40beab1e7",
   "metadata": {
    "tags": [
     "nbval-skip"
    ]
   },
   "outputs": [],
   "source": [
    "df_totals[[\"nuc\", \"name\", \"zone\", \"total\"]].to_csv(\n",
    "    f\"trove-contributors-zones-{datetime.datetime.now().strftime('%Y%m%d')}.csv\",\n",
    "    index=False,\n",
    ")\n",
    "\n",
    "df_formats[[\"nuc\", \"name\", \"zone\", \"format\", \"total\"]].to_csv(\n",
    "    f\"trove-contributors-formats-{datetime.datetime.now().strftime('%Y%m%d')}.csv\",\n",
    "    index=False,\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c3881838-a642-4c99-8547-d11d6e9d3768",
   "metadata": {},
   "source": [
    "## Top contributors by zone\n",
    "\n",
    "Let's do a little exploration of the data. First we'll set some Pandas defaults, and make sure the data is loaded."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "45a6d1c9-a158-41d3-a176-11e7128695e5",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "pd.set_option(\"display.max_colwidth\", None)\n",
    "pd.set_option(\"styler.format.thousands\", \",\")\n",
    "\n",
    "# If you haven't created a fresh harvest above, you can load the most recent weekly harvest\n",
    "try:\n",
    "    # Make sure totals are ints\n",
    "    df_totals[\"total\"] = df_totals[\"total\"].astype(\"Int64\")\n",
    "    df_formats[\"total\"] = df_formats[\"total\"].astype(\"Int64\")\n",
    "except NameError:\n",
    "    df_totals = pd.read_csv(\n",
    "        \"https://raw.githubusercontent.com/wragge/trove-contributor-totals/main/data/trove-contributors-zones.csv\"\n",
    "    )\n",
    "    df_formats = pd.read_csv(\n",
    "        \"https://raw.githubusercontent.com/wragge/trove-contributor-totals/main/data/trove-contributors-formats.csv\"\n",
    "    )"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "062f79f1-ca1c-4152-b7fe-5edfc33bbfc8",
   "metadata": {},
   "source": [
    "By grouping the totals data, we can find who has contributed the most records by zone."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "6c97264c-36bf-4fa5-a968-aa7a9e6593c9",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_0fc9e_row0_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 51.7%, transparent 51.7%);\n",
       "}\n",
       "#T_0fc9e_row1_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 24.4%, transparent 24.4%);\n",
       "}\n",
       "#T_0fc9e_row2_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 12.1%, transparent 12.1%);\n",
       "}\n",
       "#T_0fc9e_row3_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 10.9%, transparent 10.9%);\n",
       "}\n",
       "#T_0fc9e_row4_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 7.8%, transparent 7.8%);\n",
       "}\n",
       "#T_0fc9e_row5_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 100.0%, transparent 100.0%);\n",
       "}\n",
       "#T_0fc9e_row6_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 44.6%, transparent 44.6%);\n",
       "}\n",
       "#T_0fc9e_row7_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 43.5%, transparent 43.5%);\n",
       "}\n",
       "#T_0fc9e_row8_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 43.1%, transparent 43.1%);\n",
       "}\n",
       "#T_0fc9e_row9_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 41.8%, transparent 41.8%);\n",
       "}\n",
       "#T_0fc9e_row10_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 87.2%, transparent 87.2%);\n",
       "}\n",
       "#T_0fc9e_row11_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 14.8%, transparent 14.8%);\n",
       "}\n",
       "#T_0fc9e_row12_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 7.0%, transparent 7.0%);\n",
       "}\n",
       "#T_0fc9e_row13_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 5.2%, transparent 5.2%);\n",
       "}\n",
       "#T_0fc9e_row14_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 4.1%, transparent 4.1%);\n",
       "}\n",
       "#T_0fc9e_row15_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 3.4%, transparent 3.4%);\n",
       "}\n",
       "#T_0fc9e_row16_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 1.5%, transparent 1.5%);\n",
       "}\n",
       "#T_0fc9e_row17_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 1.2%, transparent 1.2%);\n",
       "}\n",
       "#T_0fc9e_row18_col2, #T_0fc9e_row19_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 0.3%, transparent 0.3%);\n",
       "}\n",
       "#T_0fc9e_row20_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 12.6%, transparent 12.6%);\n",
       "}\n",
       "#T_0fc9e_row21_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 5.8%, transparent 5.8%);\n",
       "}\n",
       "#T_0fc9e_row22_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 5.6%, transparent 5.6%);\n",
       "}\n",
       "#T_0fc9e_row23_col2, #T_0fc9e_row25_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 5.0%, transparent 5.0%);\n",
       "}\n",
       "#T_0fc9e_row24_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 3.8%, transparent 3.8%);\n",
       "}\n",
       "#T_0fc9e_row26_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 1.6%, transparent 1.6%);\n",
       "}\n",
       "#T_0fc9e_row27_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 1.4%, transparent 1.4%);\n",
       "}\n",
       "#T_0fc9e_row28_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 0.7%, transparent 0.7%);\n",
       "}\n",
       "#T_0fc9e_row29_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 0.5%, transparent 0.5%);\n",
       "}\n",
       "#T_0fc9e_row30_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 16.5%, transparent 16.5%);\n",
       "}\n",
       "#T_0fc9e_row31_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 14.7%, transparent 14.7%);\n",
       "}\n",
       "#T_0fc9e_row32_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 14.4%, transparent 14.4%);\n",
       "}\n",
       "#T_0fc9e_row33_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 8.3%, transparent 8.3%);\n",
       "}\n",
       "#T_0fc9e_row34_col2 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 7.1%, transparent 7.1%);\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_0fc9e\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank\" >&nbsp;</th>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_0fc9e_level0_col0\" class=\"col_heading level0 col0\" >nuc</th>\n",
       "      <th id=\"T_0fc9e_level0_col1\" class=\"col_heading level0 col1\" >name</th>\n",
       "      <th id=\"T_0fc9e_level0_col2\" class=\"col_heading level0 col2\" >total</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th class=\"index_name level0\" >zone</th>\n",
       "      <th class=\"index_name level1\" >&nbsp;</th>\n",
       "      <th class=\"blank col0\" >&nbsp;</th>\n",
       "      <th class=\"blank col1\" >&nbsp;</th>\n",
       "      <th class=\"blank col2\" >&nbsp;</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level0_row0\" class=\"row_heading level0 row0\" rowspan=\"5\">article</th>\n",
       "      <th id=\"T_0fc9e_level1_row0\" class=\"row_heading level1 row0\" >0</th>\n",
       "      <td id=\"T_0fc9e_row0_col0\" class=\"data row0 col0\" >ANL:DL</td>\n",
       "      <td id=\"T_0fc9e_row0_col1\" class=\"data row0 col1\" >Trove Digital Library.</td>\n",
       "      <td id=\"T_0fc9e_row0_col2\" class=\"data row0 col2\" >1,804,128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row1\" class=\"row_heading level1 row1\" >1</th>\n",
       "      <td id=\"T_0fc9e_row1_col0\" class=\"data row1 col0\" >ANL</td>\n",
       "      <td id=\"T_0fc9e_row1_col1\" class=\"data row1 col1\" >National Library of Australia.</td>\n",
       "      <td id=\"T_0fc9e_row1_col2\" class=\"data row1 col2\" >852,604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row2\" class=\"row_heading level1 row2\" >2</th>\n",
       "      <td id=\"T_0fc9e_row2_col0\" class=\"data row2 col0\" >QU:IR</td>\n",
       "      <td id=\"T_0fc9e_row2_col1\" class=\"data row2 col1\" >The University of Queensland. University of Queensland Library. University of Queensland: Institutional Repository.</td>\n",
       "      <td id=\"T_0fc9e_row2_col2\" class=\"data row2 col2\" >421,583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row3\" class=\"row_heading level1 row3\" >3</th>\n",
       "      <td id=\"T_0fc9e_row3_col0\" class=\"data row3 col0\" >APAR:PR</td>\n",
       "      <td id=\"T_0fc9e_row3_col1\" class=\"data row3 col1\" >Parliament of  Australia. Parliamentary Library. Press Releases Database.</td>\n",
       "      <td id=\"T_0fc9e_row3_col2\" class=\"data row3 col2\" >380,935</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row4\" class=\"row_heading level1 row4\" >4</th>\n",
       "      <td id=\"T_0fc9e_row4_col0\" class=\"data row4 col0\" >VSL</td>\n",
       "      <td id=\"T_0fc9e_row4_col1\" class=\"data row4 col1\" >State Library Victoria.</td>\n",
       "      <td id=\"T_0fc9e_row4_col2\" class=\"data row4 col2\" >273,336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level0_row5\" class=\"row_heading level0 row5\" rowspan=\"5\">book</th>\n",
       "      <th id=\"T_0fc9e_level1_row5\" class=\"row_heading level1 row5\" >0</th>\n",
       "      <td id=\"T_0fc9e_row5_col0\" class=\"data row5 col0\" >ANL</td>\n",
       "      <td id=\"T_0fc9e_row5_col1\" class=\"data row5 col1\" >National Library of Australia.</td>\n",
       "      <td id=\"T_0fc9e_row5_col2\" class=\"data row5 col2\" >3,488,973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row6\" class=\"row_heading level1 row6\" >1</th>\n",
       "      <td id=\"T_0fc9e_row6_col0\" class=\"data row6 col0\" >QU</td>\n",
       "      <td id=\"T_0fc9e_row6_col1\" class=\"data row6 col1\" >The University of Queensland. University of Queensland Library.</td>\n",
       "      <td id=\"T_0fc9e_row6_col2\" class=\"data row6 col2\" >1,557,222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row7\" class=\"row_heading level1 row7\" >2</th>\n",
       "      <td id=\"T_0fc9e_row7_col0\" class=\"data row7 col0\" >VLU</td>\n",
       "      <td id=\"T_0fc9e_row7_col1\" class=\"data row7 col1\" >La Trobe University. La Trobe University Library.</td>\n",
       "      <td id=\"T_0fc9e_row7_col2\" class=\"data row7 col2\" >1,518,937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row8\" class=\"row_heading level1 row8\" >3</th>\n",
       "      <td id=\"T_0fc9e_row8_col0\" class=\"data row8 col0\" >VSL</td>\n",
       "      <td id=\"T_0fc9e_row8_col1\" class=\"data row8 col1\" >State Library Victoria.</td>\n",
       "      <td id=\"T_0fc9e_row8_col2\" class=\"data row8 col2\" >1,503,395</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row9\" class=\"row_heading level1 row9\" >4</th>\n",
       "      <td id=\"T_0fc9e_row9_col0\" class=\"data row9 col0\" >VU</td>\n",
       "      <td id=\"T_0fc9e_row9_col1\" class=\"data row9 col1\" >The University of Melbourne. The University of Melbourne Library.</td>\n",
       "      <td id=\"T_0fc9e_row9_col2\" class=\"data row9 col2\" >1,459,231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level0_row10\" class=\"row_heading level0 row10\" rowspan=\"5\">collection</th>\n",
       "      <th id=\"T_0fc9e_level1_row10\" class=\"row_heading level1 row10\" >0</th>\n",
       "      <td id=\"T_0fc9e_row10_col0\" class=\"data row10 col0\" >QSA</td>\n",
       "      <td id=\"T_0fc9e_row10_col1\" class=\"data row10 col1\" >Queensland State Archives.</td>\n",
       "      <td id=\"T_0fc9e_row10_col2\" class=\"data row10 col2\" >3,043,694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row11\" class=\"row_heading level1 row11\" >1</th>\n",
       "      <td id=\"T_0fc9e_row11_col0\" class=\"data row11 col0\" >NSCA</td>\n",
       "      <td id=\"T_0fc9e_row11_col1\" class=\"data row11 col1\" >City of Sydney Archives.</td>\n",
       "      <td id=\"T_0fc9e_row11_col2\" class=\"data row11 col2\" >517,023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row12\" class=\"row_heading level1 row12\" >2</th>\n",
       "      <td id=\"T_0fc9e_row12_col0\" class=\"data row12 col0\" >NPAR:PR</td>\n",
       "      <td id=\"T_0fc9e_row12_col1\" class=\"data row12 col1\" >Parliament of New South Wales. NSW Parliamentary Library Press Releases.</td>\n",
       "      <td id=\"T_0fc9e_row12_col2\" class=\"data row12 col2\" >244,083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row13\" class=\"row_heading level1 row13\" >3</th>\n",
       "      <td id=\"T_0fc9e_row13_col0\" class=\"data row13 col0\" >VUMA</td>\n",
       "      <td id=\"T_0fc9e_row13_col1\" class=\"data row13 col1\" >The University of Melbourne. University of Melbourne Archives.</td>\n",
       "      <td id=\"T_0fc9e_row13_col2\" class=\"data row13 col2\" >182,226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row14\" class=\"row_heading level1 row14\" >4</th>\n",
       "      <td id=\"T_0fc9e_row14_col0\" class=\"data row14 col0\" >NSL</td>\n",
       "      <td id=\"T_0fc9e_row14_col1\" class=\"data row14 col1\" >State Library of NSW.</td>\n",
       "      <td id=\"T_0fc9e_row14_col2\" class=\"data row14 col2\" >144,348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level0_row15\" class=\"row_heading level0 row15\" rowspan=\"5\">map</th>\n",
       "      <th id=\"T_0fc9e_level1_row15\" class=\"row_heading level1 row15\" >0</th>\n",
       "      <td id=\"T_0fc9e_row15_col0\" class=\"data row15 col0\" >ANL</td>\n",
       "      <td id=\"T_0fc9e_row15_col1\" class=\"data row15 col1\" >National Library of Australia.</td>\n",
       "      <td id=\"T_0fc9e_row15_col2\" class=\"data row15 col2\" >118,057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row16\" class=\"row_heading level1 row16\" >1</th>\n",
       "      <td id=\"T_0fc9e_row16_col0\" class=\"data row16 col0\" >VSL</td>\n",
       "      <td id=\"T_0fc9e_row16_col1\" class=\"data row16 col1\" >State Library Victoria.</td>\n",
       "      <td id=\"T_0fc9e_row16_col2\" class=\"data row16 col2\" >52,287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row17\" class=\"row_heading level1 row17\" >2</th>\n",
       "      <td id=\"T_0fc9e_row17_col0\" class=\"data row17 col0\" >NSL</td>\n",
       "      <td id=\"T_0fc9e_row17_col1\" class=\"data row17 col1\" >State Library of NSW.</td>\n",
       "      <td id=\"T_0fc9e_row17_col2\" class=\"data row17 col2\" >40,406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row18\" class=\"row_heading level1 row18\" >3</th>\n",
       "      <td id=\"T_0fc9e_row18_col0\" class=\"data row18 col0\" >VU</td>\n",
       "      <td id=\"T_0fc9e_row18_col1\" class=\"data row18 col1\" >The University of Melbourne. The University of Melbourne Library.</td>\n",
       "      <td id=\"T_0fc9e_row18_col2\" class=\"data row18 col2\" >11,390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row19\" class=\"row_heading level1 row19\" >4</th>\n",
       "      <td id=\"T_0fc9e_row19_col0\" class=\"data row19 col0\" >ANL:DL</td>\n",
       "      <td id=\"T_0fc9e_row19_col1\" class=\"data row19 col1\" >Trove Digital Library.</td>\n",
       "      <td id=\"T_0fc9e_row19_col2\" class=\"data row19 col2\" >10,643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level0_row20\" class=\"row_heading level0 row20\" rowspan=\"5\">music</th>\n",
       "      <th id=\"T_0fc9e_level1_row20\" class=\"row_heading level1 row20\" >0</th>\n",
       "      <td id=\"T_0fc9e_row20_col0\" class=\"data row20 col0\" >ABC:RN</td>\n",
       "      <td id=\"T_0fc9e_row20_col1\" class=\"data row20 col1\" >Australian Broadcasting Corporation. ABC Radio National.</td>\n",
       "      <td id=\"T_0fc9e_row20_col2\" class=\"data row20 col2\" >438,838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row21\" class=\"row_heading level1 row21\" >1</th>\n",
       "      <td id=\"T_0fc9e_row21_col0\" class=\"data row21 col0\" >ANL</td>\n",
       "      <td id=\"T_0fc9e_row21_col1\" class=\"data row21 col1\" >National Library of Australia.</td>\n",
       "      <td id=\"T_0fc9e_row21_col2\" class=\"data row21 col2\" >202,005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row22\" class=\"row_heading level1 row22\" >2</th>\n",
       "      <td id=\"T_0fc9e_row22_col0\" class=\"data row22 col0\" >WCX</td>\n",
       "      <td id=\"T_0fc9e_row22_col1\" class=\"data row22 col1\" >Edith Cowan University. Edith Cowan University Library.</td>\n",
       "      <td id=\"T_0fc9e_row22_col2\" class=\"data row22 col2\" >195,144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row23\" class=\"row_heading level1 row23\" >3</th>\n",
       "      <td id=\"T_0fc9e_row23_col0\" class=\"data row23 col0\" >WLB</td>\n",
       "      <td id=\"T_0fc9e_row23_col1\" class=\"data row23 col1\" >State Library of Western Australia.</td>\n",
       "      <td id=\"T_0fc9e_row23_col2\" class=\"data row23 col2\" >174,136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row24\" class=\"row_heading level1 row24\" >4</th>\n",
       "      <td id=\"T_0fc9e_row24_col0\" class=\"data row24 col0\" >QU</td>\n",
       "      <td id=\"T_0fc9e_row24_col1\" class=\"data row24 col1\" >The University of Queensland. University of Queensland Library.</td>\n",
       "      <td id=\"T_0fc9e_row24_col2\" class=\"data row24 col2\" >134,099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level0_row25\" class=\"row_heading level0 row25\" rowspan=\"5\">people</th>\n",
       "      <th id=\"T_0fc9e_level1_row25\" class=\"row_heading level1 row25\" >0</th>\n",
       "      <td id=\"T_0fc9e_row25_col0\" class=\"data row25 col0\" >SAUS</td>\n",
       "      <td id=\"T_0fc9e_row25_col1\" class=\"data row25 col1\" >AusStage.</td>\n",
       "      <td id=\"T_0fc9e_row25_col2\" class=\"data row25 col2\" >174,821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row26\" class=\"row_heading level1 row26\" >1</th>\n",
       "      <td id=\"T_0fc9e_row26_col0\" class=\"data row26 col0\" >QPRO</td>\n",
       "      <td id=\"T_0fc9e_row26_col1\" class=\"data row26 col1\" >Griffith University. The Prosecution Project .</td>\n",
       "      <td id=\"T_0fc9e_row26_col2\" class=\"data row26 col2\" >57,243</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row27\" class=\"row_heading level1 row27\" >2</th>\n",
       "      <td id=\"T_0fc9e_row27_col0\" class=\"data row27 col0\" >AIAS</td>\n",
       "      <td id=\"T_0fc9e_row27_col1\" class=\"data row27 col1\" >Australian Institute of Aboriginal and Torres Strait Islander Studies. AIATSIS Collections.</td>\n",
       "      <td id=\"T_0fc9e_row27_col2\" class=\"data row27 col2\" >48,444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row28\" class=\"row_heading level1 row28\" >3</th>\n",
       "      <td id=\"T_0fc9e_row28_col0\" class=\"data row28 col0\" >YORCID</td>\n",
       "      <td id=\"T_0fc9e_row28_col1\" class=\"data row28 col1\" >ORCID.</td>\n",
       "      <td id=\"T_0fc9e_row28_col2\" class=\"data row28 col2\" >25,019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row29\" class=\"row_heading level1 row29\" >4</th>\n",
       "      <td id=\"T_0fc9e_row29_col0\" class=\"data row29 col0\" >NUN:DAAO</td>\n",
       "      <td id=\"T_0fc9e_row29_col1\" class=\"data row29 col1\" >UNSW Sydney. Design & Art Australia Online.</td>\n",
       "      <td id=\"T_0fc9e_row29_col2\" class=\"data row29 col2\" >17,022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level0_row30\" class=\"row_heading level0 row30\" rowspan=\"5\">picture</th>\n",
       "      <th id=\"T_0fc9e_level1_row30\" class=\"row_heading level1 row30\" >0</th>\n",
       "      <td id=\"T_0fc9e_row30_col0\" class=\"data row30 col0\" >AAAR:PS</td>\n",
       "      <td id=\"T_0fc9e_row30_col1\" class=\"data row30 col1\" >National Archives of Australia. PhotoSearch.</td>\n",
       "      <td id=\"T_0fc9e_row30_col2\" class=\"data row30 col2\" >575,356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row31\" class=\"row_heading level1 row31\" >1</th>\n",
       "      <td id=\"T_0fc9e_row31_col0\" class=\"data row31 col0\" >YUF</td>\n",
       "      <td id=\"T_0fc9e_row31_col1\" class=\"data row31 col1\" >Flickr.</td>\n",
       "      <td id=\"T_0fc9e_row31_col2\" class=\"data row31 col2\" >511,236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row32\" class=\"row_heading level1 row32\" >2</th>\n",
       "      <td id=\"T_0fc9e_row32_col0\" class=\"data row32 col0\" >NSL</td>\n",
       "      <td id=\"T_0fc9e_row32_col1\" class=\"data row32 col1\" >State Library of NSW.</td>\n",
       "      <td id=\"T_0fc9e_row32_col2\" class=\"data row32 col2\" >501,795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row33\" class=\"row_heading level1 row33\" >3</th>\n",
       "      <td id=\"T_0fc9e_row33_col0\" class=\"data row33 col0\" >AAWM</td>\n",
       "      <td id=\"T_0fc9e_row33_col1\" class=\"data row33 col1\" >Australian War Memorial. Research Centre.</td>\n",
       "      <td id=\"T_0fc9e_row33_col2\" class=\"data row33 col2\" >291,122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_0fc9e_level1_row34\" class=\"row_heading level1 row34\" >4</th>\n",
       "      <td id=\"T_0fc9e_row34_col0\" class=\"data row34 col0\" >ANL</td>\n",
       "      <td id=\"T_0fc9e_row34_col1\" class=\"data row34 col1\" >National Library of Australia.</td>\n",
       "      <td id=\"T_0fc9e_row34_col2\" class=\"data row34 col2\" >248,369</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f86142af520>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Group by zone\n",
    "df_totals.groupby(\"zone\").apply(\n",
    "    # This operates on each group's dataframe, reordering, sorting, and displaying the top 5\n",
    "    lambda x: x[[\"nuc\", \"name\", \"total\"]]\n",
    "    .sort_values(by=\"total\", ascending=False)\n",
    "    .reset_index(drop=True)\n",
    "    .head(5)\n",
    "    # Display the totals as a bar chart\n",
    ").style.format({\"total\": \"{:,.0f}\"}).bar(subset=\"total\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e052650f-872d-4bf1-8ed9-1a186088d9da",
   "metadata": {},
   "source": [
    "## Explore an individual zone"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7f0bdef5-a89d-46b8-a0db-ee5614f8f925",
   "metadata": {},
   "source": [
    "To make it easier to look at the make-up of each zone, we can add a `%` column to the dataframe that shows the proportion each source has contributed. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ae404f98-04f9-48f4-8da3-a6d9d5d14528",
   "metadata": {},
   "outputs": [],
   "source": [
    "# This nifty one-liner to get percentages by group was found here: https://stackoverflow.com/a/57359372\n",
    "df_totals[\"%\"] = (\n",
    "    100 * df_totals[\"total\"] / df_totals.groupby(\"zone\")[\"total\"].transform(\"sum\")\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a308500d-5a7f-4b95-b6a8-32bde1e8a470",
   "metadata": {},
   "source": [
    "Let's have a look at the `collection` zone that includes archives, manuscripts, and other unpublished materials.\n",
    "\n",
    "How many different contributors provide records to the `collection` zone?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "dd6f7067-fbc4-4245-81f4-1126b8550916",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "784"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_totals.loc[(df_totals[\"zone\"] == \"collection\") & (df_totals[\"total\"] > 0)][\n",
    "    \"nuc\"\n",
    "].nunique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d4ce385a-6682-4ba1-9ca5-4a51f8eb4616",
   "metadata": {},
   "source": [
    "Let's list the top twenty contributors to the `collection` zone."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "f0ad733b-390a-4b91-a696-9ea41f23e8e2",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_7138e_row0_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 100.0%, transparent 100.0%);\n",
       "}\n",
       "#T_7138e_row1_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 17.0%, transparent 17.0%);\n",
       "}\n",
       "#T_7138e_row2_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 8.0%, transparent 8.0%);\n",
       "}\n",
       "#T_7138e_row3_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 6.0%, transparent 6.0%);\n",
       "}\n",
       "#T_7138e_row4_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 4.7%, transparent 4.7%);\n",
       "}\n",
       "#T_7138e_row5_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 3.7%, transparent 3.7%);\n",
       "}\n",
       "#T_7138e_row6_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 3.1%, transparent 3.1%);\n",
       "}\n",
       "#T_7138e_row7_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 2.1%, transparent 2.1%);\n",
       "}\n",
       "#T_7138e_row8_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 1.1%, transparent 1.1%);\n",
       "}\n",
       "#T_7138e_row9_col4, #T_7138e_row10_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 1.0%, transparent 1.0%);\n",
       "}\n",
       "#T_7138e_row11_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 0.7%, transparent 0.7%);\n",
       "}\n",
       "#T_7138e_row12_col4, #T_7138e_row13_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 0.6%, transparent 0.6%);\n",
       "}\n",
       "#T_7138e_row14_col4, #T_7138e_row15_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 0.5%, transparent 0.5%);\n",
       "}\n",
       "#T_7138e_row16_col4, #T_7138e_row17_col4, #T_7138e_row18_col4, #T_7138e_row19_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 0.4%, transparent 0.4%);\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_7138e\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th id=\"T_7138e_level0_col0\" class=\"col_heading level0 col0\" >nuc</th>\n",
       "      <th id=\"T_7138e_level0_col1\" class=\"col_heading level0 col1\" >name</th>\n",
       "      <th id=\"T_7138e_level0_col2\" class=\"col_heading level0 col2\" >zone</th>\n",
       "      <th id=\"T_7138e_level0_col3\" class=\"col_heading level0 col3\" >total</th>\n",
       "      <th id=\"T_7138e_level0_col4\" class=\"col_heading level0 col4\" >%</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row0_col0\" class=\"data row0 col0\" >QSA</td>\n",
       "      <td id=\"T_7138e_row0_col1\" class=\"data row0 col1\" >Queensland State Archives.</td>\n",
       "      <td id=\"T_7138e_row0_col2\" class=\"data row0 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row0_col3\" class=\"data row0 col3\" >3,043,694</td>\n",
       "      <td id=\"T_7138e_row0_col4\" class=\"data row0 col4\" >62.655373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row1_col0\" class=\"data row1 col0\" >NSCA</td>\n",
       "      <td id=\"T_7138e_row1_col1\" class=\"data row1 col1\" >City of Sydney Archives.</td>\n",
       "      <td id=\"T_7138e_row1_col2\" class=\"data row1 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row1_col3\" class=\"data row1 col3\" >517,023</td>\n",
       "      <td id=\"T_7138e_row1_col4\" class=\"data row1 col4\" >10.643077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row2_col0\" class=\"data row2 col0\" >NPAR:PR</td>\n",
       "      <td id=\"T_7138e_row2_col1\" class=\"data row2 col1\" >Parliament of New South Wales. NSW Parliamentary Library Press Releases.</td>\n",
       "      <td id=\"T_7138e_row2_col2\" class=\"data row2 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row2_col3\" class=\"data row2 col3\" >244,083</td>\n",
       "      <td id=\"T_7138e_row2_col4\" class=\"data row2 col4\" >5.024523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row3_col0\" class=\"data row3 col0\" >VUMA</td>\n",
       "      <td id=\"T_7138e_row3_col1\" class=\"data row3 col1\" >The University of Melbourne. University of Melbourne Archives.</td>\n",
       "      <td id=\"T_7138e_row3_col2\" class=\"data row3 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row3_col3\" class=\"data row3 col3\" >182,226</td>\n",
       "      <td id=\"T_7138e_row3_col4\" class=\"data row3 col4\" >3.751178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row4_col0\" class=\"data row4 col0\" >NSL</td>\n",
       "      <td id=\"T_7138e_row4_col1\" class=\"data row4 col1\" >State Library of NSW.</td>\n",
       "      <td id=\"T_7138e_row4_col2\" class=\"data row4 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row4_col3\" class=\"data row4 col3\" >144,348</td>\n",
       "      <td id=\"T_7138e_row4_col4\" class=\"data row4 col4\" >2.971448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row5_col0\" class=\"data row5 col0\" >ANL:AJCP</td>\n",
       "      <td id=\"T_7138e_row5_col1\" class=\"data row5 col1\" >Australian Joint Copying Project.</td>\n",
       "      <td id=\"T_7138e_row5_col2\" class=\"data row5 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row5_col3\" class=\"data row5 col3\" >113,185</td>\n",
       "      <td id=\"T_7138e_row5_col4\" class=\"data row5 col4\" >2.329948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row6_col0\" class=\"data row6 col0\" >ANL</td>\n",
       "      <td id=\"T_7138e_row6_col1\" class=\"data row6 col1\" >National Library of Australia.</td>\n",
       "      <td id=\"T_7138e_row6_col2\" class=\"data row6 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row6_col3\" class=\"data row6 col3\" >93,073</td>\n",
       "      <td id=\"T_7138e_row6_col4\" class=\"data row6 col4\" >1.915936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row7_col0\" class=\"data row7 col0\" >VSL</td>\n",
       "      <td id=\"T_7138e_row7_col1\" class=\"data row7 col1\" >State Library Victoria.</td>\n",
       "      <td id=\"T_7138e_row7_col2\" class=\"data row7 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row7_col3\" class=\"data row7 col3\" >63,248</td>\n",
       "      <td id=\"T_7138e_row7_col4\" class=\"data row7 col4\" >1.301979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row8_col0\" class=\"data row8 col0\" >ANL:DL</td>\n",
       "      <td id=\"T_7138e_row8_col1\" class=\"data row8 col1\" >Trove Digital Library.</td>\n",
       "      <td id=\"T_7138e_row8_col2\" class=\"data row8 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row8_col3\" class=\"data row8 col3\" >32,218</td>\n",
       "      <td id=\"T_7138e_row8_col4\" class=\"data row8 col4\" >0.663217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row9_col0\" class=\"data row9 col0\" >VRHS</td>\n",
       "      <td id=\"T_7138e_row9_col1\" class=\"data row9 col1\" >Royal Historical Society of Victoria. Royal Historical Society of Victoria.</td>\n",
       "      <td id=\"T_7138e_row9_col2\" class=\"data row9 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row9_col3\" class=\"data row9 col3\" >30,588</td>\n",
       "      <td id=\"T_7138e_row9_col4\" class=\"data row9 col4\" >0.629663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row10_col0\" class=\"data row10 col0\" >SFU</td>\n",
       "      <td id=\"T_7138e_row10_col1\" class=\"data row10 col1\" >Flinders University. Flinders University Central Library.</td>\n",
       "      <td id=\"T_7138e_row10_col2\" class=\"data row10 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row10_col3\" class=\"data row10 col3\" >30,051</td>\n",
       "      <td id=\"T_7138e_row10_col4\" class=\"data row10 col4\" >0.618609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row11_col0\" class=\"data row11 col0\" >AAS:FA</td>\n",
       "      <td id=\"T_7138e_row11_col1\" class=\"data row11 col1\" >Australian Academy of Science. Fenner Archives.</td>\n",
       "      <td id=\"T_7138e_row11_col2\" class=\"data row11 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row11_col3\" class=\"data row11 col3\" >20,037</td>\n",
       "      <td id=\"T_7138e_row11_col4\" class=\"data row11 col4\" >0.412468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row12_col0\" class=\"data row12 col0\" >VNG</td>\n",
       "      <td id=\"T_7138e_row12_col1\" class=\"data row12 col1\" >National Gallery of Victoria. The Shaw Research Library.</td>\n",
       "      <td id=\"T_7138e_row12_col2\" class=\"data row12 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row12_col3\" class=\"data row12 col3\" >17,751</td>\n",
       "      <td id=\"T_7138e_row12_col4\" class=\"data row12 col4\" >0.365410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row13_col0\" class=\"data row13 col0\" >NMMU:C</td>\n",
       "      <td id=\"T_7138e_row13_col1\" class=\"data row13 col1\" >Australian National Maritime Museum. Collection.</td>\n",
       "      <td id=\"T_7138e_row13_col2\" class=\"data row13 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row13_col3\" class=\"data row13 col3\" >17,230</td>\n",
       "      <td id=\"T_7138e_row13_col4\" class=\"data row13 col4\" >0.354685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row14_col0\" class=\"data row14 col0\" >VPRO</td>\n",
       "      <td id=\"T_7138e_row14_col1\" class=\"data row14 col1\" >Public Record Office Victoria. Victorian Archives Centre.</td>\n",
       "      <td id=\"T_7138e_row14_col2\" class=\"data row14 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row14_col3\" class=\"data row14 col3\" >16,139</td>\n",
       "      <td id=\"T_7138e_row14_col4\" class=\"data row14 col4\" >0.332226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row15_col0\" class=\"data row15 col0\" >SSL</td>\n",
       "      <td id=\"T_7138e_row15_col1\" class=\"data row15 col1\" >State Library of South Australia.</td>\n",
       "      <td id=\"T_7138e_row15_col2\" class=\"data row15 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row15_col3\" class=\"data row15 col3\" >14,440</td>\n",
       "      <td id=\"T_7138e_row15_col4\" class=\"data row15 col4\" >0.297252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row16_col0\" class=\"data row16 col0\" >QSL</td>\n",
       "      <td id=\"T_7138e_row16_col1\" class=\"data row16 col1\" >State Library of Queensland.</td>\n",
       "      <td id=\"T_7138e_row16_col2\" class=\"data row16 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row16_col3\" class=\"data row16 col3\" >12,743</td>\n",
       "      <td id=\"T_7138e_row16_col4\" class=\"data row16 col4\" >0.262319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row17_col0\" class=\"data row17 col0\" >SUSA:A</td>\n",
       "      <td id=\"T_7138e_row17_col1\" class=\"data row17 col1\" >University of South Australia. University of South Australia Library. University of South Australia Archives.</td>\n",
       "      <td id=\"T_7138e_row17_col2\" class=\"data row17 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row17_col3\" class=\"data row17 col3\" >12,182</td>\n",
       "      <td id=\"T_7138e_row17_col4\" class=\"data row17 col4\" >0.250770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row18_col0\" class=\"data row18 col0\" >NSWA</td>\n",
       "      <td id=\"T_7138e_row18_col1\" class=\"data row18 col1\" >Art Gallery of New South Wales. Edmund and Joanna Capon Research Library and Archive.</td>\n",
       "      <td id=\"T_7138e_row18_col2\" class=\"data row18 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row18_col3\" class=\"data row18 col3\" >10,819</td>\n",
       "      <td id=\"T_7138e_row18_col4\" class=\"data row18 col4\" >0.222712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_7138e_row19_col0\" class=\"data row19 col0\" >SAUS</td>\n",
       "      <td id=\"T_7138e_row19_col1\" class=\"data row19 col1\" >AusStage.</td>\n",
       "      <td id=\"T_7138e_row19_col2\" class=\"data row19 col2\" >collection</td>\n",
       "      <td id=\"T_7138e_row19_col3\" class=\"data row19 col3\" >10,694</td>\n",
       "      <td id=\"T_7138e_row19_col4\" class=\"data row19 col4\" >0.220139</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f85bfa66f80>"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_totals.loc[df_totals[\"zone\"] == \"collection\"].sort_values(\n",
    "    by=\"total\", ascending=False\n",
    ").head(20).style.format({\"total\": \"{:,.0f}\"}).bar(subset=\"%\").hide(axis=\"index\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c760a646-58ba-4797-b3bc-a01ec6c9e01c",
   "metadata": {},
   "source": [
    "## Theses from institutional repositories\n",
    "\n",
    "We can use the formats dataset to drill down further. The NUC symbols of institutional repositories generally end in ':IR', so we look to see how many theses are being contributed by institutional repositories in Australian universities."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "fcdbaa9c-73b8-462a-b44a-bab9bddc8439",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_04867_row0_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 100.0%, transparent 100.0%);\n",
       "}\n",
       "#T_04867_row1_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 87.8%, transparent 87.8%);\n",
       "}\n",
       "#T_04867_row2_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 72.8%, transparent 72.8%);\n",
       "}\n",
       "#T_04867_row3_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 58.6%, transparent 58.6%);\n",
       "}\n",
       "#T_04867_row4_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 50.5%, transparent 50.5%);\n",
       "}\n",
       "#T_04867_row5_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 48.5%, transparent 48.5%);\n",
       "}\n",
       "#T_04867_row6_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 31.1%, transparent 31.1%);\n",
       "}\n",
       "#T_04867_row7_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 19.6%, transparent 19.6%);\n",
       "}\n",
       "#T_04867_row8_col4, #T_04867_row9_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 18.5%, transparent 18.5%);\n",
       "}\n",
       "#T_04867_row10_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 18.2%, transparent 18.2%);\n",
       "}\n",
       "#T_04867_row11_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 17.9%, transparent 17.9%);\n",
       "}\n",
       "#T_04867_row12_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 17.4%, transparent 17.4%);\n",
       "}\n",
       "#T_04867_row13_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 16.9%, transparent 16.9%);\n",
       "}\n",
       "#T_04867_row14_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 16.7%, transparent 16.7%);\n",
       "}\n",
       "#T_04867_row15_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 16.1%, transparent 16.1%);\n",
       "}\n",
       "#T_04867_row16_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 13.2%, transparent 13.2%);\n",
       "}\n",
       "#T_04867_row17_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 12.2%, transparent 12.2%);\n",
       "}\n",
       "#T_04867_row18_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 11.9%, transparent 11.9%);\n",
       "}\n",
       "#T_04867_row19_col4, #T_04867_row20_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 10.2%, transparent 10.2%);\n",
       "}\n",
       "#T_04867_row21_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 9.7%, transparent 9.7%);\n",
       "}\n",
       "#T_04867_row22_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 9.0%, transparent 9.0%);\n",
       "}\n",
       "#T_04867_row23_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 7.6%, transparent 7.6%);\n",
       "}\n",
       "#T_04867_row24_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 7.4%, transparent 7.4%);\n",
       "}\n",
       "#T_04867_row25_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 4.9%, transparent 4.9%);\n",
       "}\n",
       "#T_04867_row26_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 3.7%, transparent 3.7%);\n",
       "}\n",
       "#T_04867_row27_col4, #T_04867_row28_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 2.8%, transparent 2.8%);\n",
       "}\n",
       "#T_04867_row29_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 0.2%, transparent 0.2%);\n",
       "}\n",
       "#T_04867_row30_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 0.1%, transparent 0.1%);\n",
       "}\n",
       "#T_04867_row31_col4, #T_04867_row32_col4 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, #d65f5f 0.0%, transparent 0.0%);\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_04867\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th id=\"T_04867_level0_col0\" class=\"col_heading level0 col0\" >name</th>\n",
       "      <th id=\"T_04867_level0_col1\" class=\"col_heading level0 col1\" >nuc</th>\n",
       "      <th id=\"T_04867_level0_col2\" class=\"col_heading level0 col2\" >zone</th>\n",
       "      <th id=\"T_04867_level0_col3\" class=\"col_heading level0 col3\" >format</th>\n",
       "      <th id=\"T_04867_level0_col4\" class=\"col_heading level0 col4\" >total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row0_col0\" class=\"data row0 col0\" >The University of Queensland. University of Queensland Library. University of Queensland: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row0_col1\" class=\"data row0 col1\" >QU:IR</td>\n",
       "      <td id=\"T_04867_row0_col2\" class=\"data row0 col2\" >book</td>\n",
       "      <td id=\"T_04867_row0_col3\" class=\"data row0 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row0_col4\" class=\"data row0 col4\" >26,037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row1_col0\" class=\"data row1 col0\" >UNSW Sydney. UNSW Library. University of New South Wales: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row1_col1\" class=\"data row1 col1\" >NUN:IR</td>\n",
       "      <td id=\"T_04867_row1_col2\" class=\"data row1 col2\" >book</td>\n",
       "      <td id=\"T_04867_row1_col3\" class=\"data row1 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row1_col4\" class=\"data row1 col4\" >22,851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row2_col0\" class=\"data row2 col0\" >The University of Melbourne. The University of Melbourne Library. University of Melbourne: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row2_col1\" class=\"data row2 col1\" >VU:IR</td>\n",
       "      <td id=\"T_04867_row2_col2\" class=\"data row2 col2\" >book</td>\n",
       "      <td id=\"T_04867_row2_col3\" class=\"data row2 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row2_col4\" class=\"data row2 col4\" >18,955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row3_col0\" class=\"data row3 col0\" >Australian National University. Australian National University Library. Australian National University: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row3_col1\" class=\"data row3 col1\" >ANU:IR</td>\n",
       "      <td id=\"T_04867_row3_col2\" class=\"data row3 col2\" >book</td>\n",
       "      <td id=\"T_04867_row3_col3\" class=\"data row3 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row3_col4\" class=\"data row3 col4\" >15,254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row4_col0\" class=\"data row4 col0\" >The University of Sydney. University of Sydney Library. University of Sydney: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row4_col1\" class=\"data row4 col1\" >NU:IR</td>\n",
       "      <td id=\"T_04867_row4_col2\" class=\"data row4 col2\" >book</td>\n",
       "      <td id=\"T_04867_row4_col3\" class=\"data row4 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row4_col4\" class=\"data row4 col4\" >13,159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row5_col0\" class=\"data row5 col0\" >University of Adelaide. University of Adelaide: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row5_col1\" class=\"data row5 col1\" >SUA:IR</td>\n",
       "      <td id=\"T_04867_row5_col2\" class=\"data row5 col2\" >book</td>\n",
       "      <td id=\"T_04867_row5_col3\" class=\"data row5 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row5_col4\" class=\"data row5 col4\" >12,625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row6_col0\" class=\"data row6 col0\" >Queensland University of Technology. Queensland University of Technology: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row6_col1\" class=\"data row6 col1\" >QUT:IR</td>\n",
       "      <td id=\"T_04867_row6_col2\" class=\"data row6 col2\" >book</td>\n",
       "      <td id=\"T_04867_row6_col3\" class=\"data row6 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row6_col4\" class=\"data row6 col4\" >8,097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row7_col0\" class=\"data row7 col0\" >University of South Australia. University of South Australia Library. University of South Australia: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row7_col1\" class=\"data row7 col1\" >SUSA:IR</td>\n",
       "      <td id=\"T_04867_row7_col2\" class=\"data row7 col2\" >book</td>\n",
       "      <td id=\"T_04867_row7_col3\" class=\"data row7 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row7_col4\" class=\"data row7 col4\" >5,091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row8_col0\" class=\"data row8 col0\" >Macquarie University. Macquarie University Library. Macquarie University Library: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row8_col1\" class=\"data row8 col1\" >NMQU:IR</td>\n",
       "      <td id=\"T_04867_row8_col2\" class=\"data row8 col2\" >book</td>\n",
       "      <td id=\"T_04867_row8_col3\" class=\"data row8 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row8_col4\" class=\"data row8 col4\" >4,827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row9_col0\" class=\"data row9 col0\" >RMIT University. RMIT University Library. RMIT Research Repository.</td>\n",
       "      <td id=\"T_04867_row9_col1\" class=\"data row9 col1\" >VIT:IR</td>\n",
       "      <td id=\"T_04867_row9_col2\" class=\"data row9 col2\" >book</td>\n",
       "      <td id=\"T_04867_row9_col3\" class=\"data row9 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row9_col4\" class=\"data row9 col4\" >4,807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row10_col0\" class=\"data row10 col0\" >Griffith University. Griffith University Library. Griffith Research Online.</td>\n",
       "      <td id=\"T_04867_row10_col1\" class=\"data row10 col1\" >QGU:IR</td>\n",
       "      <td id=\"T_04867_row10_col2\" class=\"data row10 col2\" >book</td>\n",
       "      <td id=\"T_04867_row10_col3\" class=\"data row10 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row10_col4\" class=\"data row10 col4\" >4,734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row11_col0\" class=\"data row11 col0\" >Curtin University. Curtin University Library. Curtin University: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row11_col1\" class=\"data row11 col1\" >WCU:IR</td>\n",
       "      <td id=\"T_04867_row11_col2\" class=\"data row11 col2\" >book</td>\n",
       "      <td id=\"T_04867_row11_col3\" class=\"data row11 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row11_col4\" class=\"data row11 col4\" >4,654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row12_col0\" class=\"data row12 col0\" >Murdoch University. Murdoch University Library. Murdoch University: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row12_col1\" class=\"data row12 col1\" >WMDU:IR</td>\n",
       "      <td id=\"T_04867_row12_col2\" class=\"data row12 col2\" >book</td>\n",
       "      <td id=\"T_04867_row12_col3\" class=\"data row12 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row12_col4\" class=\"data row12 col4\" >4,537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row13_col0\" class=\"data row13 col0\" >University of Technology Sydney. University Library. University of Technology Sydney: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row13_col1\" class=\"data row13 col1\" >NTSM:IR</td>\n",
       "      <td id=\"T_04867_row13_col2\" class=\"data row13 col2\" >book</td>\n",
       "      <td id=\"T_04867_row13_col3\" class=\"data row13 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row13_col4\" class=\"data row13 col4\" >4,408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row14_col0\" class=\"data row14 col0\" >Deakin University. Deakin University Library. Deakin University: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row14_col1\" class=\"data row14 col1\" >VDU:IR</td>\n",
       "      <td id=\"T_04867_row14_col2\" class=\"data row14 col2\" >book</td>\n",
       "      <td id=\"T_04867_row14_col3\" class=\"data row14 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row14_col4\" class=\"data row14 col4\" >4,355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row15_col0\" class=\"data row15 col0\" >Edith Cowan University. Edith Cowan University Library. Edith Cowan University: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row15_col1\" class=\"data row15 col1\" >WCX:IR</td>\n",
       "      <td id=\"T_04867_row15_col2\" class=\"data row15 col2\" >book</td>\n",
       "      <td id=\"T_04867_row15_col3\" class=\"data row15 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row15_col4\" class=\"data row15 col4\" >4,195</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row16_col0\" class=\"data row16 col0\" >University of Newcastle Library. NOVA. The University of Newcastle Open Access repository.</td>\n",
       "      <td id=\"T_04867_row16_col1\" class=\"data row16 col1\" >NNCU:IR</td>\n",
       "      <td id=\"T_04867_row16_col2\" class=\"data row16 col2\" >book</td>\n",
       "      <td id=\"T_04867_row16_col3\" class=\"data row16 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row16_col4\" class=\"data row16 col4\" >3,446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row17_col0\" class=\"data row17 col0\" >Western Sydney University. Library. Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row17_col1\" class=\"data row17 col1\" >NUWS:IR</td>\n",
       "      <td id=\"T_04867_row17_col2\" class=\"data row17 col2\" >book</td>\n",
       "      <td id=\"T_04867_row17_col3\" class=\"data row17 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row17_col4\" class=\"data row17 col4\" >3,176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row18_col0\" class=\"data row18 col0\" >University of Southern Queensland. USQ Library. University of Southern Queensland: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row18_col1\" class=\"data row18 col1\" >QUSQ:IR</td>\n",
       "      <td id=\"T_04867_row18_col2\" class=\"data row18 col2\" >book</td>\n",
       "      <td id=\"T_04867_row18_col3\" class=\"data row18 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row18_col4\" class=\"data row18 col4\" >3,109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row19_col0\" class=\"data row19 col0\" >Swinburne University of Technology. Swinburne Library. Swinburne University: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row19_col1\" class=\"data row19 col1\" >VSWT:IR</td>\n",
       "      <td id=\"T_04867_row19_col2\" class=\"data row19 col2\" >book</td>\n",
       "      <td id=\"T_04867_row19_col3\" class=\"data row19 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row19_col4\" class=\"data row19 col4\" >2,668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row20_col0\" class=\"data row20 col0\" >University of Wollongong. University of Wollongong Library. University of Wollongong: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row20_col1\" class=\"data row20 col1\" >NWU:IR</td>\n",
       "      <td id=\"T_04867_row20_col2\" class=\"data row20 col2\" >book</td>\n",
       "      <td id=\"T_04867_row20_col3\" class=\"data row20 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row20_col4\" class=\"data row20 col4\" >2,645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row21_col0\" class=\"data row21 col0\" >Victoria University. Victoria University Library. Victoria University: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row21_col1\" class=\"data row21 col1\" >VVUT:IR</td>\n",
       "      <td id=\"T_04867_row21_col2\" class=\"data row21 col2\" >book</td>\n",
       "      <td id=\"T_04867_row21_col3\" class=\"data row21 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row21_col4\" class=\"data row21 col4\" >2,534</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row22_col0\" class=\"data row22 col0\" >James Cook University. Eddie Koiki Mabo Library. Townsville Campus Library: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row22_col1\" class=\"data row22 col1\" >QJCU:IR</td>\n",
       "      <td id=\"T_04867_row22_col2\" class=\"data row22 col2\" >book</td>\n",
       "      <td id=\"T_04867_row22_col3\" class=\"data row22 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row22_col4\" class=\"data row22 col4\" >2,335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row23_col0\" class=\"data row23 col0\" >University of Tasmania. Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row23_col1\" class=\"data row23 col1\" >TU:IR</td>\n",
       "      <td id=\"T_04867_row23_col2\" class=\"data row23 col2\" >book</td>\n",
       "      <td id=\"T_04867_row23_col3\" class=\"data row23 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row23_col4\" class=\"data row23 col4\" >1,980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row24_col0\" class=\"data row24 col0\" >University of New England. Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row24_col1\" class=\"data row24 col1\" >NUNE:IR</td>\n",
       "      <td id=\"T_04867_row24_col2\" class=\"data row24 col2\" >book</td>\n",
       "      <td id=\"T_04867_row24_col3\" class=\"data row24 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row24_col4\" class=\"data row24 col4\" >1,916</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row25_col0\" class=\"data row25 col0\" >Charles Sturt University. CSU Research Output.</td>\n",
       "      <td id=\"T_04867_row25_col1\" class=\"data row25 col1\" >NCSU:IR</td>\n",
       "      <td id=\"T_04867_row25_col2\" class=\"data row25 col2\" >book</td>\n",
       "      <td id=\"T_04867_row25_col3\" class=\"data row25 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row25_col4\" class=\"data row25 col4\" >1,268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row26_col0\" class=\"data row26 col0\" >Central Queensland University. Rockhampton Campus Library. Central Queensland University: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row26_col1\" class=\"data row26 col1\" >QCQU:IR</td>\n",
       "      <td id=\"T_04867_row26_col2\" class=\"data row26 col2\" >book</td>\n",
       "      <td id=\"T_04867_row26_col3\" class=\"data row26 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row26_col4\" class=\"data row26 col4\" >971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row27_col0\" class=\"data row27 col0\" >Southern Cross University. University Library Lismore. Southern Cross University: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row27_col1\" class=\"data row27 col1\" >NSCU:IR</td>\n",
       "      <td id=\"T_04867_row27_col2\" class=\"data row27 col2\" >book</td>\n",
       "      <td id=\"T_04867_row27_col3\" class=\"data row27 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row27_col4\" class=\"data row27 col4\" >732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row28_col0\" class=\"data row28 col0\" >Federation University Australia Library. Federation Research Online.</td>\n",
       "      <td id=\"T_04867_row28_col1\" class=\"data row28 col1\" >VFED:IR</td>\n",
       "      <td id=\"T_04867_row28_col2\" class=\"data row28 col2\" >book</td>\n",
       "      <td id=\"T_04867_row28_col3\" class=\"data row28 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row28_col4\" class=\"data row28 col4\" >732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row29_col0\" class=\"data row29 col0\" >University of Notre Dame Australia. St Teresa's Library. University of Notre Dame Australia: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row29_col1\" class=\"data row29 col1\" >WUND:IR</td>\n",
       "      <td id=\"T_04867_row29_col2\" class=\"data row29 col2\" >book</td>\n",
       "      <td id=\"T_04867_row29_col3\" class=\"data row29 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row29_col4\" class=\"data row29 col4\" >41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row30_col0\" class=\"data row30 col0\" >Bond University. John and Alison Kearney Library . Bond University Library: Institutional Repository.</td>\n",
       "      <td id=\"T_04867_row30_col1\" class=\"data row30 col1\" >QBON:IR</td>\n",
       "      <td id=\"T_04867_row30_col2\" class=\"data row30 col2\" >book</td>\n",
       "      <td id=\"T_04867_row30_col3\" class=\"data row30 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row30_col4\" class=\"data row30 col4\" >14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row31_col0\" class=\"data row31 col0\" >Flinders University. Flinders University Central Library. Flinders University: Institutional Repository .</td>\n",
       "      <td id=\"T_04867_row31_col1\" class=\"data row31 col1\" >SFU:IR</td>\n",
       "      <td id=\"T_04867_row31_col2\" class=\"data row31 col2\" >book</td>\n",
       "      <td id=\"T_04867_row31_col3\" class=\"data row31 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row31_col4\" class=\"data row31 col4\" >11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_04867_row32_col0\" class=\"data row32 col0\" >University of Canberra. University of Canberra Research Repository.</td>\n",
       "      <td id=\"T_04867_row32_col1\" class=\"data row32 col1\" >AUC:IR</td>\n",
       "      <td id=\"T_04867_row32_col2\" class=\"data row32 col2\" >book</td>\n",
       "      <td id=\"T_04867_row32_col3\" class=\"data row32 col3\" >Thesis</td>\n",
       "      <td id=\"T_04867_row32_col4\" class=\"data row32 col4\" >9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f861427bd00>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_formats = df_formats[[\"name\", \"nuc\", \"zone\", \"format\", \"total\"]]\n",
    "df_formats.loc[\n",
    "    # Filter by format 'Thesis'\n",
    "    (df_formats[\"format\"] == \"Thesis\")\n",
    "    # Only universities\n",
    "    & (df_formats[\"name\"].str.contains(\"University\"))\n",
    "    # Only institutional repositories\n",
    "    & (df_formats[\"nuc\"].str.endswith(\":IR\"))\n",
    "].sort_values(by=\"total\", ascending=False).style.format({\"total\": \"{:,.0f}\"}).bar(\n",
    "    subset=\"total\"\n",
    ").hide(\n",
    "    axis=\"index\"\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cf72c550-cf2c-4d0a-9253-853d28d06642",
   "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": 5
}