{ "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
creatordateidnuctitletrove_url
0Kelly, F. S. (Frederick Septimus), 1881-19161893-192610201266ANLMusic manuscriptshttps://trove.nla.gov.au/work/10201266
11863-192510544890ANLCollection of promissory notes from remote are...https://trove.nla.gov.au/work/10544890
2Gugeri, Peter Anthony, 1845-19301863-191014022030WLBGugeri family papershttps://trove.nla.gov.au/work/14022030
3Kruse, Johann Secundus, 1859-19271870-192714952244ANLPapers of Johann Krusehttps://trove.nla.gov.au/work/14952244
4Freycinet, Rose Marie de, d. 18321802-1927152218670ANLDocuments relating to Louis and Rose de Freycinethttps://trove.nla.gov.au/work/152218670
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
creatordateidnuctitletrove_urlinstitution
0Kelly, F. S. (Frederick Septimus), 1881-19161893-192610201266ANLMusic manuscriptshttps://trove.nla.gov.au/work/10201266National Library of Australia.
11863-192510544890ANLCollection of promissory notes from remote are...https://trove.nla.gov.au/work/10544890National Library of Australia.
2Kruse, Johann Secundus, 1859-19271870-192714952244ANLPapers of Johann Krusehttps://trove.nla.gov.au/work/14952244National Library of Australia.
3Freycinet, Rose Marie de, d. 18321802-1927152218670ANLDocuments relating to Louis and Rose de Freycinethttps://trove.nla.gov.au/work/152218670National Library of Australia.
4Dickens, Charles, 1812-18701869168122181ANLCheque written by Charles Dickenshttps://trove.nla.gov.au/work/168122181National Library of Australia.
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nucinstitutioncount
0QSAQueensland State Archives.2965
1TSLLibraries Tasmania.2112
2ANLNational Library of Australia.1781
3VSLState Library Victoria.1642
4WLBState Library of Western Australia.779
5QBCL:BIBrisbane City Council Library Service. Brisban...709
6NSLState Library of NSW.643
7QSLState Library of Queensland.630
8SSLState Library of South Australia.375
9QUThe University of Queensland. University of Qu...268
10VUMAThe University of Melbourne. University of Mel...237
11SFUFlinders University. Flinders University Centr...226
12SAUSAusStage.220
13QU:IRThe University of Queensland. University of Qu...169
14AIASAustralian Institute of Aboriginal and Torres ...133
15VRHSRoyal Historical Society of Victoria. Royal Hi...128
16NUThe University of Sydney. University of Sydney...101
17NMUS:EPowerhouse Museum. Exhibitions and Programs.96
18ZZZLocation unknown.96
19NMTC:SMMoore Theological College. Moore Theological C...93
20AAWMAustralian War Memorial. Research Centre.93
21VNMU:IMuseums Victoria. Museums Victoria Collections.75
22VPROPublic Record Office Victoria. Victorian Archi...72
23NMMU:CAustralian National Maritime Museum. Collection.66
24AMOA:CNational Museum of Australia. National Museum ...58
25SRGSRoyal Geographical Society of South Australia....58
26SUSA:AUniversity of South Australia. University of S...52
27NWU:DCUniversity of Wollongong. University of Wollon...49
28VUThe University of Melbourne. The University of...41
29NNPLNewcastle Region Libraries. Newcastle Region L...40
30NMQU:MAMacquarie University. Macquarie University Med...33
31APLSLibraries ACT.25
32SMUSouth Australian Museum. SA Museum Library.25
33VMOUMonash University. Monash University Library.24
34AAARNational Archives of Australia. National Archi...22
35VDUDeakin University. Deakin University Library.21
36NNCU:AUniversity of Newcastle Library.20
37XNLSLibrary & Archives NT.20
38NCPRoyal Australasian College of Physicians. Hist...19
39VTATTatura Historical Society. Tatura Irrigation &...19
40NRHSRoyal Australian Historical Society. RAHS Libr...18
41SUAUniversity of Adelaide. Barr Smith Library.18
42QCQUCentral Queensland University. Rockhampton Cam...17
43NMMUAustralian National Maritime Museum. Vaughan E...15
44NNEAUniversity of New England and Regional Archives.14
45VGHRGeelong Heritage Centre.11
46VU:QUniversity of Melbourne - Residential College....11
47ADFAAcademy Library, UNSW Canberra.11
48NJHSAustralian Jewish Historical Society Inc. Aust...10
49NSWAArt Gallery of New South Wales. Edmund and Joa...9
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
creatordateidnuctitletrove_urlinstitution
6541892-190910918152ANLFederation - Australiahttps://trove.nla.gov.au/work/10918152National Library of Australia.
7521947159853683ANLCommunist influence in Teachers Federationhttps://trove.nla.gov.au/work/159853683National Library of Australia.
1140Barton, Edmund Sir, 1849-19201897-189823733819ANLLetter and handbills relating to Australian fe...https://trove.nla.gov.au/work/23733819National Library of Australia.
1298189927029040ANLSynopsis of the Commonwealth Bill : approved b...https://trove.nla.gov.au/work/27029040National Library of Australia.
13121890-189128833077ANLThe federation movement, and proceedings of th...https://trove.nla.gov.au/work/28833077National Library of Australia.
13131895-190128833285ANLThe Australian federation movement from a Sout...https://trove.nla.gov.au/work/28833285National Library of Australia.
16831895-19015891330ANLThe Australian federation movement from a Sout...https://trove.nla.gov.au/work/5891330National Library of Australia.
1696Henry, John, 1834-191218996050113ANL[Comments of the honourable John Henry dealing...https://trove.nla.gov.au/work/6050113National Library of Australia.
20591900191699908WLBRecords of Australian Federation of Friends of...https://trove.nla.gov.au/work/191699908State Library of Western Australia.
47741928200344170QSLWaterside Workers Federation Cutting Bookhttps://trove.nla.gov.au/work/200344170State Library of Queensland.
63951898-1901157372346TSLFederation League of Northern Tasmania NG2368 ...https://trove.nla.gov.au/work/157372346Libraries Tasmania.
67191917157373022TSLNational Federation League - Derby Branch NG14...https://trove.nla.gov.au/work/157373022Libraries Tasmania.
88161901197248968VDUFederation Day photograph albumhttps://trove.nla.gov.au/work/197248968Deakin University. Deakin University Library.
93181902206859905VUMAFEDERATED WOOL AND BASIL WORKERS FEDERATION, V...https://trove.nla.gov.au/work/206859905The University of Melbourne. University of Mel...
\n", "
" ], "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": [ "Download CSV file" ], "text/plain": [ "" ] }, "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", " 'Download CSV file'.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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
creatordateidnuctitletrove_urlinstitution
28Barton, Edmund, Sir, 1849-19201827-194027034442ANLPapers of Sir Edmund Bartonhttps://trove.nla.gov.au/work/27034442National Library of Australia.
161Barton, Edmund, Sir, 1849-19201827-194014890081ANLPapers of Sir Edmund Bartonhttps://trove.nla.gov.au/work/14890081National Library of Australia.
237Barton, Edmund Sir, 1849-1920190221003348ANLCorrespondence between Edmund Barton and Capta...https://trove.nla.gov.au/work/21003348National Library of Australia.
938Paterson, A. B. (Andrew Barton), 1864-19411905-196920843868ANLMaterial relating to Waltzing Matildahttps://trove.nla.gov.au/work/20843868National Library of Australia.
1008Barton, Edmund Sir, 1849-19201887-194721730412ANLLetters, papers, billhttps://trove.nla.gov.au/work/21730412National Library of Australia.
1140Barton, Edmund Sir, 1849-19201897-189823733819ANLLetter and handbills relating to Australian fe...https://trove.nla.gov.au/work/23733819National Library of Australia.
1218Barton, Edmund Sir, 1849-1920190124351962ANLSpeech delivered by Barton at the opening of F...https://trove.nla.gov.au/work/24351962National Library of Australia.
1291Barton, G. B. (George Burnett), 1836-19011800-189924904338ANLManuscriptshttps://trove.nla.gov.au/work/24904338National Library of Australia.
1396Paterson, A. B. (Andrew Barton), 1864-1941189634380059ANLLetter : Sydney to Thos. Whitby, Blackheathhttps://trove.nla.gov.au/work/34380059National Library of Australia.
1412Barton, Edmund Sir, 1849-1920190134392819ANLLettershttps://trove.nla.gov.au/work/34392819National Library of Australia.
1443Paterson, A. B. (Andrew Barton), 1864-1941193934444414ANLLetter : Sydney, to Lawrence Henry Coppinghttps://trove.nla.gov.au/work/34444414National Library of Australia.
1473Hack, John Barton, 1805-18841820-188434692159ANLFamily papershttps://trove.nla.gov.au/work/34692159National Library of Australia.
1581Paterson, A. B. (Andrew Barton), 1864-19411859-189634892978ANLEarly Australian letters and booklethttps://trove.nla.gov.au/work/34892978National Library of Australia.
1609Barton, Edmund Sir, 1849-1920190335097888ANLLetter : to Isaac Isaacshttps://trove.nla.gov.au/work/35097888National Library of Australia.
1710Barton, Edmund, Sir, 1849-192019026116810ANL[Address, to welcome Sir Edmund Barton, Ottawa]https://trove.nla.gov.au/work/6116810National Library of Australia.
1726Barton, Edmund, Sir, 1849-192019026148440ANL[Document of congratulation from British Fair ...https://trove.nla.gov.au/work/6148440National Library of Australia.
1741Paterson, A. B. (Andrew Barton), 1864-19411900-19156466365ANLThere's another bloody horse fell down [by] A....https://trove.nla.gov.au/work/6466365National Library of Australia.
1759Paterson, A. B. (Andrew Barton), 1864-19411915-19208651892ANLLettershttps://trove.nla.gov.au/work/8651892National Library of Australia.
1762Paterson, A. B. (Andrew Barton), 1864-194118968994780ANLLetter of A.B. Patersonhttps://trove.nla.gov.au/work/8994780National Library of Australia.
2870Barton, Edmund, Sir, 1849-192032034635VSLPapershttps://trove.nla.gov.au/work/32034635State Library Victoria.
5249Barton, Newton, 1870-19351894-1895203843366QSLNewton Barton Diaryhttps://trove.nla.gov.au/work/203843366State Library of Queensland.
5567Paterson, A. B. (Andrew Barton), 1864-1941199235083238NSLThe man from ironbark / A.B. Paterson ; [calli...https://trove.nla.gov.au/work/35083238State Library of NSW.
5921Barton, G. B. (George Burnett), 1836-1901189035932172NSLThe life and speeches of William Charles Wentw...https://trove.nla.gov.au/work/35932172State Library of NSW.
5979Brady, Alfred Barton, 1856-19321893231806214QUDrawings of the new Victoria Bridge, Brisbanehttps://trove.nla.gov.au/work/231806214The University of Queensland. University of Qu...
6121Barton, Edmund, Sir, 1849-1920190136300223QULetter : Milson's Point, N.S.W. to A.S. Cowleyhttps://trove.nla.gov.au/work/36300223The University of Queensland. University of Qu...
\n", "
" ], "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": [ "Download CSV file" ], "text/plain": [ "" ] }, "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", " 'Download CSV file'.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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
creatordateidnuctitletrove_urlinstitution
0Kelly, F. S. (Frederick Septimus), 1881-19161893-192610201266ANLMusic manuscriptshttps://trove.nla.gov.au/work/10201266National Library of Australia.
11863-192510544890ANLCollection of promissory notes from remote are...https://trove.nla.gov.au/work/10544890National Library of Australia.
2Kruse, Johann Secundus, 1859-19271870-192714952244ANLPapers of Johann Krusehttps://trove.nla.gov.au/work/14952244National Library of Australia.
3Freycinet, Rose Marie de, d. 18321802-1927152218670ANLDocuments relating to Louis and Rose de Freycinethttps://trove.nla.gov.au/work/152218670National Library of Australia.
4Dickens, Charles, 1812-18701869168122181ANLCheque written by Charles Dickenshttps://trove.nla.gov.au/work/168122181National Library of Australia.
........................
1776Hodder, Edwin, 1837-190418629924046ANLThe Junior Clerk, a Tale of City Lifehttps://trove.nla.gov.au/work/9924046National Library of Australia.
1777Eden, Charles H. (Charles Henry), 1839-190018759924065ANLRalph Somerville, or, a Midshipman's Adventure...https://trove.nla.gov.au/work/9924065National Library of Australia.
1778Beechey, Frederick William, 1796-185618569924073ANLBiographyhttps://trove.nla.gov.au/work/9924073National Library of Australia.
1779Farrer, William, 1845-19061901-19029946088ANLField bookhttps://trove.nla.gov.au/work/9946088National Library of Australia.
1780Cawley, John, fl. 18341834-18359959583ANLLetters and printed statementhttps://trove.nla.gov.au/work/9959583National Library of Australia.
\n", "

1781 rows × 7 columns

\n", "
" ], "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": [ "Download CSV file" ], "text/plain": [ "" ] }, "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", " 'Download CSV file'.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 }