{ "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": 2, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import requests\n", "from IPython.display import display, HTML" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "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": 3, "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": 5, "metadata": {}, "outputs": [], "source": [ "nuc_list = list(df['nuc'].unique())\n", "nucs = []\n", "api_url = 'http://api.trove.nla.gov.au/v2/contributor/{}/'\n", "\n", "params = {\n", " 'encoding': 'json',\n", " 'key': 'ADD YOUR API KEY HERE'\n", "}\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": 86, "metadata": {}, "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": 86, "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": 87, "metadata": { "scrolled": true }, "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. Brisbane Images.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
19AAWMAustralian War Memorial. Research Centre.93
20NMTC:SMMoore Theological College. Moore Theological C...93
21VNMU:IMuseum Victoria. Museum Victoria Collections.75
22VPROPublic Record Office Victoria. Victorian Archi...72
23NMMU:CAustralian National Maritime Museum. Australia...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
36XNLSNorthern Territory Library .20
37NNCU:AUniversity of Newcastle Library.20
38VTATTatura Historical Society. Tatura Irrigation &...19
39NCPRoyal Australasian College of Physicians. Hist...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
45VU:QUniversity of Melbourne - Residential College....11
46ADFAAcademy Library, UNSW Canberra.11
47VGHRGeelong Heritage Centre.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. Brisbane Images. 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 AAWM Australian War Memorial. Research Centre. 93\n", "20 NMTC:SM Moore Theological College. Moore Theological C... 93\n", "21 VNMU:I Museum Victoria. Museum Victoria Collections. 75\n", "22 VPRO Public Record Office Victoria. Victorian Archi... 72\n", "23 NMMU:C Australian National Maritime Museum. Australia... 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 XNLS Northern Territory Library . 20\n", "37 NNCU:A University of Newcastle Library. 20\n", "38 VTAT Tatura Historical Society. Tatura Irrigation &... 19\n", "39 NCP Royal Australasian College of Physicians. Hist... 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 VU:Q University of Melbourne - Residential College.... 11\n", "46 ADFA Academy Library, UNSW Canberra. 11\n", "47 VGHR Geelong Heritage Centre. 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": 87, "metadata": {}, "output_type": "execute_result" } ], "source": [ "institutions = df_new.groupby(['nuc', 'institution']).size().sort_values(ascending=False).to_frame().reset_index()\n", "institutions.columns = ['nuc', 'institution', 'count']\n", "institutions[:50]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Filter by title keyword" ] }, { "cell_type": "code", "execution_count": 96, "metadata": { "scrolled": true }, "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": 96, "metadata": {}, "output_type": "execute_result" } ], "source": [ "title_kw = 'federation' # Edit to add your own keyword!\n", "filtered_title = df_new.loc[df_new['title'].str.contains(title_kw, case=False, na=False)]\n", "filtered_title" ] }, { "cell_type": "code", "execution_count": 97, "metadata": {}, "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(HTML('Download CSV file'.format('filtered_title_{}.csv'.format(title_kw))))" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Filter by creator name" ] }, { "cell_type": "code", "execution_count": 98, "metadata": { "scrolled": true }, "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": 98, "metadata": {}, "output_type": "execute_result" } ], "source": [ "creator_kw = 'barton' # Edit to add your own name!\n", "filtered_creator = df_new.loc[df_new['creator'].str.contains(creator_kw, case=False, na=False)]\n", "filtered_creator" ] }, { "cell_type": "code", "execution_count": 100, "metadata": {}, "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(HTML('Download CSV file'.format('filtered_creator_{}.csv'.format(creator_kw))))" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Filter by institution (nuc)" ] }, { "cell_type": "code", "execution_count": 92, "metadata": { "scrolled": true }, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \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.
5Paton, John Gibson, 1824-19071858-1891179335696ANLJournal, research notes and correspondence fro...https://trove.nla.gov.au/work/179335696National Library of Australia.
6Paton, Maggie Whitecross, 1841?-19051870-1943179335711ANLJournals and correspondence from the New Hebrideshttps://trove.nla.gov.au/work/179335711National Library of Australia.
7Frazer, Charles Edward, 1880–19131910-1913193288592ANLEarly Commonwealth currency, 1910-1913https://trove.nla.gov.au/work/193288592National Library of Australia.
8Norcock, John Henry, 1809-18541835-183720308332ANLDiary of John Henry Norcockhttps://trove.nla.gov.au/work/20308332National Library of Australia.
9Nobbs, George Hunn, 1799-18841845-188620850242ANLPitcairn and Norfolk Island correspondencehttps://trove.nla.gov.au/work/20850242National Library of Australia.
10Eden, Morton Frederick, 1865-19481890-199620888178ANLDiaries of Morton Frederick Edenhttps://trove.nla.gov.au/work/20888178National Library of Australia.
11Archer, William Henry, 1825-19091847-186621080750ANLLetters of William Archerhttps://trove.nla.gov.au/work/21080750National Library of Australia.
12Gould, John, 1804-18811838-188421123716ANLPapers of John Gouldhttps://trove.nla.gov.au/work/21123716National Library of Australia.
13Watson, Thomas Greenlees, 1859-19121901-191221123799ANLPapers of Thomas Greenlees Watsonhttps://trove.nla.gov.au/work/21123799National Library of Australia.
14Wakefield, George, active 1853-18871853-188721154508ANLPapers of George Wakefieldhttps://trove.nla.gov.au/work/21154508National Library of Australia.
15Petherick, Edward Augustus, 1847-19171756-191721205250ANLPapers of Edward Augustus Petherickhttps://trove.nla.gov.au/work/21205250National Library of Australia.
16Cook, Joseph, Sir, 1860-19471919-192721888272ANLPapers of Sir Joseph Cookhttps://trove.nla.gov.au/work/21888272National Library of Australia.
17Atkins, Richard, 1745-18201791-181022119334ANLJournal of Richard Atkinshttps://trove.nla.gov.au/work/22119334National Library of Australia.
18Fawkner, John Pascoe, 1792-18691810-186922469947ANLSir John Ferguson collection of papers of John...https://trove.nla.gov.au/work/22469947National Library of Australia.
19Macpherson, Christina Rutherford, 1864-19361900-198622493150ANLPapers relating to the song \"Waltzing Matilda\"https://trove.nla.gov.au/work/22493150National Library of Australia.
20Henry, Alice, 1857-19431873-194322576237ANLPapers of Alice Henryhttps://trove.nla.gov.au/work/22576237National Library of Australia.
21Kingsford-Smith, Charles, 1897-19351917-193522587305ANLPapers of Sir Charles Kingsford-Smithhttps://trove.nla.gov.au/work/22587305National Library of Australia.
22Gullett, Henry, Sir, 1878-19401887-196122821978ANLPapers of Sir Henry and Lady Penelope Gulletthttps://trove.nla.gov.au/work/22821978National Library of Australia.
23Sandwich, John Montagu, Earl of, 1718-17921771-178423386022ANLPapers of John Montagu Sandwichhttps://trove.nla.gov.au/work/23386022National Library of Australia.
24Godber, Josiah, -18221817-182423399685ANLLetters of Josiah Godberhttps://trove.nla.gov.au/work/23399685National Library of Australia.
25Brisbane, Thomas, Sir, 1773-18601815-185823447253ANLPapers of Sir Thomas Brisbanehttps://trove.nla.gov.au/work/23447253National Library of Australia.
26Cook, James, 1728-1779176223727236ANLDescription of the sea coast of Nova Scotiahttps://trove.nla.gov.au/work/23727236National Library of Australia.
27Banks, Joseph, 1743-18201745-192327034363ANLPapers of Sir Joseph Bankshttps://trove.nla.gov.au/work/27034363National Library of Australia.
28Barton, Edmund, Sir, 1849-19201827-194027034442ANLPapers of Sir Edmund Bartonhttps://trove.nla.gov.au/work/27034442National Library of Australia.
29Richardson, Henry Handel, 1870-19461896-194627067175ANLPapers and correspondence of Henry Handel Rich...https://trove.nla.gov.au/work/27067175National Library of Australia.
........................
1751Bonwick, James, 1817-19061641-19007564724ANLTranscript copies of records mainly held in th...https://trove.nla.gov.au/work/7564724National Library of Australia.
1752Dennis, C. J. (Clarence James), 1876-193819167587881ANLA Love songhttps://trove.nla.gov.au/work/7587881National Library of Australia.
1753Griffiths, W. Scott, 1864-19291912-19507623796ANLPapers of W. Scott Griffithshttps://trove.nla.gov.au/work/7623796National Library of Australia.
1754Delisser, E.A. (Edmund Alexander), 1829-190019657810684ANLJournal of Edmund A. Delisserhttps://trove.nla.gov.au/work/7810684National Library of Australia.
1755Cory, William Johnson, 1823-18921842-18927823069ANLCorrespondencehttps://trove.nla.gov.au/work/7823069National Library of Australia.
1756Fisher, Andrew, 1862-192819088034232ANLLetterhttps://trove.nla.gov.au/work/8034232National Library of Australia.
1757Richardson, Henry Handel, 1870-19461911-19468054582ANLLetters from Henry Handel Richardson to Mary K...https://trove.nla.gov.au/work/8054582National Library of Australia.
1758McIntosh, Hugh D. (Hugh Donald), 1876-19421913-19238561663ANLJournal of Hugh D. McIntoshhttps://trove.nla.gov.au/work/8561663National Library of Australia.
1759Paterson, A. B. (Andrew Barton), 1864-19411915-19208651892ANLLettershttps://trove.nla.gov.au/work/8651892National Library of Australia.
1760Franklin, Jane Lady, 1791-18751839-18408873496ANLDiarieshttps://trove.nla.gov.au/work/8873496National Library of Australia.
1761Lawson, Henry, 1867-192219178873540ANLPapers of Henry Lawsonhttps://trove.nla.gov.au/work/8873540National Library of Australia.
1762Paterson, A. B. (Andrew Barton), 1864-194118968994780ANLLetter of A.B. Patersonhttps://trove.nla.gov.au/work/8994780National Library of Australia.
1763Berry, Alexander, 1781-18731800-18999082975ANLDelivery notehttps://trove.nla.gov.au/work/9082975National Library of Australia.
17641900-19109352802ANLMap of Tasmaniahttps://trove.nla.gov.au/work/9352802National Library of Australia.
1765Aitken, James, fl. 190119019353304ANLLetters patenthttps://trove.nla.gov.au/work/9353304National Library of Australia.
1766Egan, Michael, fl. 188818889353616ANLDocumenthttps://trove.nla.gov.au/work/9353616National Library of Australia.
1767Botterill, Joseph, d. 186818819355611ANLProbate of willhttps://trove.nla.gov.au/work/9355611National Library of Australia.
1768Lang, John Dunmore, 1799-18781877-18789401497ANLReminiscences of my life and times in Australiahttps://trove.nla.gov.au/work/9401497National Library of Australia.
1769Kenna, Francis, 1865-19321887-19099921911ANLLetter bookhttps://trove.nla.gov.au/work/9921911National Library of Australia.
1770Donaldson, Stuart Alexander Sir, 1812-18671835-18569921982ANLNotebook of Stuart Alexander Donaldsonhttps://trove.nla.gov.au/work/9921982National Library of Australia.
1771Griffith, Samuel Sir, 1845-192018629922092ANLNoteshttps://trove.nla.gov.au/work/9922092National Library of Australia.
1772Cox, George, 1871-19461911-19269922103ANLLetters and newspaper cuttingshttps://trove.nla.gov.au/work/9922103National Library of Australia.
17731821-18729922356ANLConvict documentshttps://trove.nla.gov.au/work/9922356National Library of Australia.
1774Gordon, Adam Lindsay, 1833-187018709923959ANLHunting under the Southern Crosshttps://trove.nla.gov.au/work/9923959National Library of Australia.
17751867-18729924041ANLRegister of decrees relating to New Caledoniahttps://trove.nla.gov.au/work/9924041National 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", "5 Paton, John Gibson, 1824-1907 1858-1891 179335696 ANL \n", "6 Paton, Maggie Whitecross, 1841?-1905 1870-1943 179335711 ANL \n", "7 Frazer, Charles Edward, 1880–1913 1910-1913 193288592 ANL \n", "8 Norcock, John Henry, 1809-1854 1835-1837 20308332 ANL \n", "9 Nobbs, George Hunn, 1799-1884 1845-1886 20850242 ANL \n", "10 Eden, Morton Frederick, 1865-1948 1890-1996 20888178 ANL \n", "11 Archer, William Henry, 1825-1909 1847-1866 21080750 ANL \n", "12 Gould, John, 1804-1881 1838-1884 21123716 ANL \n", "13 Watson, Thomas Greenlees, 1859-1912 1901-1912 21123799 ANL \n", "14 Wakefield, George, active 1853-1887 1853-1887 21154508 ANL \n", "15 Petherick, Edward Augustus, 1847-1917 1756-1917 21205250 ANL \n", "16 Cook, Joseph, Sir, 1860-1947 1919-1927 21888272 ANL \n", "17 Atkins, Richard, 1745-1820 1791-1810 22119334 ANL \n", "18 Fawkner, John Pascoe, 1792-1869 1810-1869 22469947 ANL \n", "19 Macpherson, Christina Rutherford, 1864-1936 1900-1986 22493150 ANL \n", "20 Henry, Alice, 1857-1943 1873-1943 22576237 ANL \n", "21 Kingsford-Smith, Charles, 1897-1935 1917-1935 22587305 ANL \n", "22 Gullett, Henry, Sir, 1878-1940 1887-1961 22821978 ANL \n", "23 Sandwich, John Montagu, Earl of, 1718-1792 1771-1784 23386022 ANL \n", "24 Godber, Josiah, -1822 1817-1824 23399685 ANL \n", "25 Brisbane, Thomas, Sir, 1773-1860 1815-1858 23447253 ANL \n", "26 Cook, James, 1728-1779 1762 23727236 ANL \n", "27 Banks, Joseph, 1743-1820 1745-1923 27034363 ANL \n", "28 Barton, Edmund, Sir, 1849-1920 1827-1940 27034442 ANL \n", "29 Richardson, Henry Handel, 1870-1946 1896-1946 27067175 ANL \n", "... ... ... ... ... \n", "1751 Bonwick, James, 1817-1906 1641-1900 7564724 ANL \n", "1752 Dennis, C. J. (Clarence James), 1876-1938 1916 7587881 ANL \n", "1753 Griffiths, W. Scott, 1864-1929 1912-1950 7623796 ANL \n", "1754 Delisser, E.A. (Edmund Alexander), 1829-1900 1965 7810684 ANL \n", "1755 Cory, William Johnson, 1823-1892 1842-1892 7823069 ANL \n", "1756 Fisher, Andrew, 1862-1928 1908 8034232 ANL \n", "1757 Richardson, Henry Handel, 1870-1946 1911-1946 8054582 ANL \n", "1758 McIntosh, Hugh D. (Hugh Donald), 1876-1942 1913-1923 8561663 ANL \n", "1759 Paterson, A. B. (Andrew Barton), 1864-1941 1915-1920 8651892 ANL \n", "1760 Franklin, Jane Lady, 1791-1875 1839-1840 8873496 ANL \n", "1761 Lawson, Henry, 1867-1922 1917 8873540 ANL \n", "1762 Paterson, A. B. (Andrew Barton), 1864-1941 1896 8994780 ANL \n", "1763 Berry, Alexander, 1781-1873 1800-1899 9082975 ANL \n", "1764 1900-1910 9352802 ANL \n", "1765 Aitken, James, fl. 1901 1901 9353304 ANL \n", "1766 Egan, Michael, fl. 1888 1888 9353616 ANL \n", "1767 Botterill, Joseph, d. 1868 1881 9355611 ANL \n", "1768 Lang, John Dunmore, 1799-1878 1877-1878 9401497 ANL \n", "1769 Kenna, Francis, 1865-1932 1887-1909 9921911 ANL \n", "1770 Donaldson, Stuart Alexander Sir, 1812-1867 1835-1856 9921982 ANL \n", "1771 Griffith, Samuel Sir, 1845-1920 1862 9922092 ANL \n", "1772 Cox, George, 1871-1946 1911-1926 9922103 ANL \n", "1773 1821-1872 9922356 ANL \n", "1774 Gordon, Adam Lindsay, 1833-1870 1870 9923959 ANL \n", "1775 1867-1872 9924041 ANL \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", "5 Journal, research notes and correspondence fro... \n", "6 Journals and correspondence from the New Hebrides \n", "7 Early Commonwealth currency, 1910-1913 \n", "8 Diary of John Henry Norcock \n", "9 Pitcairn and Norfolk Island correspondence \n", "10 Diaries of Morton Frederick Eden \n", "11 Letters of William Archer \n", "12 Papers of John Gould \n", "13 Papers of Thomas Greenlees Watson \n", "14 Papers of George Wakefield \n", "15 Papers of Edward Augustus Petherick \n", "16 Papers of Sir Joseph Cook \n", "17 Journal of Richard Atkins \n", "18 Sir John Ferguson collection of papers of John... \n", "19 Papers relating to the song \"Waltzing Matilda\" \n", "20 Papers of Alice Henry \n", "21 Papers of Sir Charles Kingsford-Smith \n", "22 Papers of Sir Henry and Lady Penelope Gullett \n", "23 Papers of John Montagu Sandwich \n", "24 Letters of Josiah Godber \n", "25 Papers of Sir Thomas Brisbane \n", "26 Description of the sea coast of Nova Scotia \n", "27 Papers of Sir Joseph Banks \n", "28 Papers of Sir Edmund Barton \n", "29 Papers and correspondence of Henry Handel Rich... \n", "... ... \n", "1751 Transcript copies of records mainly held in th... \n", "1752 A Love song \n", "1753 Papers of W. Scott Griffiths \n", "1754 Journal of Edmund A. Delisser \n", "1755 Correspondence \n", "1756 Letter \n", "1757 Letters from Henry Handel Richardson to Mary K... \n", "1758 Journal of Hugh D. McIntosh \n", "1759 Letters \n", "1760 Diaries \n", "1761 Papers of Henry Lawson \n", "1762 Letter of A.B. Paterson \n", "1763 Delivery note \n", "1764 Map of Tasmania \n", "1765 Letters patent \n", "1766 Document \n", "1767 Probate of will \n", "1768 Reminiscences of my life and times in Australia \n", "1769 Letter book \n", "1770 Notebook of Stuart Alexander Donaldson \n", "1771 Notes \n", "1772 Letters and newspaper cuttings \n", "1773 Convict documents \n", "1774 Hunting under the Southern Cross \n", "1775 Register of decrees relating to New Caledonia \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", "5 https://trove.nla.gov.au/work/179335696 National Library of Australia. \n", "6 https://trove.nla.gov.au/work/179335711 National Library of Australia. \n", "7 https://trove.nla.gov.au/work/193288592 National Library of Australia. \n", "8 https://trove.nla.gov.au/work/20308332 National Library of Australia. \n", "9 https://trove.nla.gov.au/work/20850242 National Library of Australia. \n", "10 https://trove.nla.gov.au/work/20888178 National Library of Australia. \n", "11 https://trove.nla.gov.au/work/21080750 National Library of Australia. \n", "12 https://trove.nla.gov.au/work/21123716 National Library of Australia. \n", "13 https://trove.nla.gov.au/work/21123799 National Library of Australia. \n", "14 https://trove.nla.gov.au/work/21154508 National Library of Australia. \n", "15 https://trove.nla.gov.au/work/21205250 National Library of Australia. \n", "16 https://trove.nla.gov.au/work/21888272 National Library of Australia. \n", "17 https://trove.nla.gov.au/work/22119334 National Library of Australia. \n", "18 https://trove.nla.gov.au/work/22469947 National Library of Australia. \n", "19 https://trove.nla.gov.au/work/22493150 National Library of Australia. \n", "20 https://trove.nla.gov.au/work/22576237 National Library of Australia. \n", "21 https://trove.nla.gov.au/work/22587305 National Library of Australia. \n", "22 https://trove.nla.gov.au/work/22821978 National Library of Australia. \n", "23 https://trove.nla.gov.au/work/23386022 National Library of Australia. \n", "24 https://trove.nla.gov.au/work/23399685 National Library of Australia. \n", "25 https://trove.nla.gov.au/work/23447253 National Library of Australia. \n", "26 https://trove.nla.gov.au/work/23727236 National Library of Australia. \n", "27 https://trove.nla.gov.au/work/27034363 National Library of Australia. \n", "28 https://trove.nla.gov.au/work/27034442 National Library of Australia. \n", "29 https://trove.nla.gov.au/work/27067175 National Library of Australia. \n", "... ... ... \n", "1751 https://trove.nla.gov.au/work/7564724 National Library of Australia. \n", "1752 https://trove.nla.gov.au/work/7587881 National Library of Australia. \n", "1753 https://trove.nla.gov.au/work/7623796 National Library of Australia. \n", "1754 https://trove.nla.gov.au/work/7810684 National Library of Australia. \n", "1755 https://trove.nla.gov.au/work/7823069 National Library of Australia. \n", "1756 https://trove.nla.gov.au/work/8034232 National Library of Australia. \n", "1757 https://trove.nla.gov.au/work/8054582 National Library of Australia. \n", "1758 https://trove.nla.gov.au/work/8561663 National Library of Australia. \n", "1759 https://trove.nla.gov.au/work/8651892 National Library of Australia. \n", "1760 https://trove.nla.gov.au/work/8873496 National Library of Australia. \n", "1761 https://trove.nla.gov.au/work/8873540 National Library of Australia. \n", "1762 https://trove.nla.gov.au/work/8994780 National Library of Australia. \n", "1763 https://trove.nla.gov.au/work/9082975 National Library of Australia. \n", "1764 https://trove.nla.gov.au/work/9352802 National Library of Australia. \n", "1765 https://trove.nla.gov.au/work/9353304 National Library of Australia. \n", "1766 https://trove.nla.gov.au/work/9353616 National Library of Australia. \n", "1767 https://trove.nla.gov.au/work/9355611 National Library of Australia. \n", "1768 https://trove.nla.gov.au/work/9401497 National Library of Australia. \n", "1769 https://trove.nla.gov.au/work/9921911 National Library of Australia. \n", "1770 https://trove.nla.gov.au/work/9921982 National Library of Australia. \n", "1771 https://trove.nla.gov.au/work/9922092 National Library of Australia. \n", "1772 https://trove.nla.gov.au/work/9922103 National Library of Australia. \n", "1773 https://trove.nla.gov.au/work/9922356 National Library of Australia. \n", "1774 https://trove.nla.gov.au/work/9923959 National Library of Australia. \n", "1775 https://trove.nla.gov.au/work/9924041 National Library of Australia. \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": 92, "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": {}, "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(HTML('Download CSV file'.format('filtered_nuc_{}.csv'.format(nuc))))" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "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.6.5" } }, "nbformat": 4, "nbformat_minor": 2 }