{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import gspread\n", "import pandas as pd\n", "from oauth2client.service_account import ServiceAccountCredentials\n", "import datetime\n", "import numpy as np" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": true }, "outputs": [], "source": [ "scope = ['https://spreadsheets.google.com/feeds']" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": true }, "outputs": [], "source": [ "credentials = ServiceAccountCredentials.from_json_keyfile_name('secrets/dissertation.json', scope)" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": true }, "outputs": [], "source": [ "gc = gspread.authorize(credentials)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": true }, "outputs": [], "source": [ "sheets = ['YB1883', 'YB1885', 'YB1890', 'YB1894', \n", " 'YB1905', 'YB1910', 'YB1915', 'YB1920']" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": true }, "outputs": [], "source": [ "def read_in_sheet(sheet):\n", " dts = gc.open(sheet).sheet1\n", " frame = pd.DataFrame(dts.get_all_records())\n", " return(frame)" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": true }, "outputs": [], "source": [ "df = pd.DataFrame()" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": true }, "outputs": [], "source": [ "for sheet in sheets:\n", " frame = read_in_sheet(sheet)\n", " df = df.append(frame, ignore_index=True)" ] }, { "cell_type": "code", "execution_count": 9, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
conferencegendergroupinstitution-namelastnamelocationnameorganizationpagepositionposition-informationprefixregionsuffixyearbook-year
0Generalmboard of trusteesEducational SocietyButlerBattle Creek, MIGeo. I.7trusteeMichigan1883
1Generalmboard of trusteesEducational SocietyHaskellSouth Lancaster, MAS.N.7trusteeMichigan1883
2Generalmboard of trusteesEducational SocietyHenryBattle Creek, MIA.R.7trusteeMichigan1883
3Generalmboard of trusteesEducational SocietyKelloggBattle Creek, MIJ.H.7trusteeMichiganM.D.1883
4Generalmboard of trusteesEducational SocietyKelloggBattle Creek, MIH.W.7trusteeMichigan1883
5Generalmboard of trusteesEducational SocietyOyenBattle Creek, MIA.B.7trusteeMichigan1883
6Generalmboard of trusteesEducational SocietySisleyBattle Creek, MIW.C.7trusteeMichigan1883
7Generalmboard of directorsHealth Reform InstituteFargoGreenville, MIJ.7directorMichigan1883
8Generalmboard of directorsHealth Reform InstituteHallBattle Creek, MIW.H.7directorMichigan1883
9Generalmboard of directorsHealth Reform InstituteHallBattle Creek, MIL.M.7directorMichigan1883
10Generalmboard of directorsHealth Reform InstituteHaskellSouth Lancaster, MAS.N.7directorMichigan1883
11Generalmboard of directorsHealth Reform InstituteHenryBattle Creek, MIA.R.7directorMichigan1883
12Generalmboard of directorsHealth Reform InstituteKelloggBattle Creek, MIJ.H.7directorMichiganM.D.1883
13Generalmboard of directorsHealth Reform InstituteMurphyBattle Creek, MIG.H.7directorMichigan1883
14GeneralmPacific Seventh-day Adventist Publishing Assoc...GlennOakland, CAW.N.7auditor1883
15GeneralmdirectorPacific Seventh-day Adventist Publishing Assoc...HaskellSouth Lancaster, MAS.N.7director1883
16GeneralmdirectorPacific Seventh-day Adventist Publishing Assoc...IsraelOakland, CAM.C.7director1883
17GeneralmdirectorPacific Seventh-day Adventist Publishing Assoc...JonesOakland, CAC.H.7director1883
18GeneralmdirectorPacific Seventh-day Adventist Publishing Assoc...MorrisonHealdsburg, CAJ.7director1883
19GeneralmdirectorPacific Seventh-day Adventist Publishing Assoc...WhiteOakland, CAW.C.7director1883
20Generalmpublishing committeePacific Seventh-day Adventist Publishing Assoc...HaskellSouth Lancaster, MAS.N.7committee member1883
21Generalmpublishing committeePacific Seventh-day Adventist Publishing Assoc...WaggonerOakland, CAJ.H.7committee member1883
22Generalmpublishing committeePacific Seventh-day Adventist Publishing Assoc...WhiteOakland, CAW.C.7committee member1883
23GeneralmPacific Seventh-day Adventist Publishing Assoc...HaskellSouth Lancaster, MAS.N.7president1883
24GeneralmPacific Seventh-day Adventist Publishing Assoc...VickeryOakland, CAW.K.7secretary1883
25GeneralmPacific Seventh-day Adventist Publishing Assoc...WhiteOakland, CAW.C.7vice president1883
26GeneralmSeventh-day Adventist Publishing AssociationSisleyBattle Creek, MIW.C.6auditorMichigan1883
27Generalmpublishing committeeSeventh-day Adventist Publishing AssociationAmadonBattle Creek, MIG.W.6committee memberMichigan1883
28Generalmpublishing committeeSeventh-day Adventist Publishing AssociationButlerBattle Creek, MIGeo. I.6committee memberMichigan1883
29Generalmpublishing committeeSeventh-day Adventist Publishing AssociationSmithBattle Creek, MIU.6committee memberMichigan1883
................................................
15053board of trusteesLoma Linda SanitariumMartinW.F.265, 227trusteeCalifornia1920
15054board of trusteesLoma Linda SanitariumReaserG.W.265, 227trusteeCalifornia1920
15055board of trusteesLoma Linda SanitariumRisleyE.H.265, 227trusteeCalifornia1920
15056board of trusteesLoma Linda SanitariumBowenL.M.265, 227trusteeCalifornia1920
15057board of trusteesLoma Linda SanitariumMcElhanyJ.L.265, 227trusteeCalifornia1920
15058board of trusteesLoma Linda SanitariumEvansNewton265, 227trusteeCalifornia1920
15059board of trusteesLoma Linda SanitariumVollmerH.W.265, 227trusteeCalifornia1920
15060board of trusteesLoma Linda SanitariumMaganP.T.265, 227trusteeCalifornia1920
15061board of trusteesLoma Linda SanitariumWeirJ.J.265, 227trusteeCalifornia1920
15062board of trusteesLoma Linda SanitariumChristianJ.W.265, 227trusteeCalifornia1920
15063officers of the boardLoma Linda SanitariumEvansNewton265, 227vice presidentCalifornia1920
15064officersSt. Helena SanitariumRiceHelen N.California Medical Missionary and Benevolent A...267-268lady head nurseMissCaliforniaR.N.1920
15065officersSt. Helena SanitariumRiceHelen N.California Medical Missionary and Benevolent A...267-268secretarytraining-schoolMissCaliforniaR.N.1920
15066Columbia Unionexecutive committeeBoothA.S.39, 40committee member1920
15067Columbia Unionexecutive committeeHarterR.E.39, 41committee member1920
15068Columbia Unionexecutive committeeParsonsD.A.39, 42committee member1920
15069Columbia Unionexecutive committeeMoffetW.C.39, 44committee member1920
15070Columbia Unionexecutive committeeLelandJ.A.39, 47committee member1920
15071Columbia Unionexecutive committeeLindsayR.S.39, 48committee member1920
15072Columbia Unionexecutive committeeWestbrookT.B.39, 49committee member1920
15073Columbia Unionexecutive committeeShawFred48-49committee memberWest Pennsylvania1920
15074Lake Unionexecutive committeeClarkA.J.54, 55committee member1920
15075Lake Unionexecutive committeeWestworthWm. A.54, 57committee member1920
15076Lake Unionexecutive committeeHoldenW.H.54, 59committee member1920
15077Lake Unionexecutive committeeWiestC.S.54, 60committee member1920
15078Lake Unionexecutive committeeNetheryR.J.54, 62committee member1920
15079Lake Unionexecutive committeeIrwinJ.J.54, 63committee member1920
15080Lake Unionexecutive committeeBristolE.A.54, 64committee member1920
15081Lake Unionexecutive committeePiperJ.F.54, 66committee member1920
15082Pacific Unionexecutive committeeAdamsW.M.95-96committee memberSouthern California1920
\n", "

15083 rows × 15 columns

\n", "
" ], "text/plain": [ " conference gender group \\\n", "0 General m board of trustees \n", "1 General m board of trustees \n", "2 General m board of trustees \n", "3 General m board of trustees \n", "4 General m board of trustees \n", "5 General m board of trustees \n", "6 General m board of trustees \n", "7 General m board of directors \n", "8 General m board of directors \n", "9 General m board of directors \n", "10 General m board of directors \n", "11 General m board of directors \n", "12 General m board of directors \n", "13 General m board of directors \n", "14 General m \n", "15 General m director \n", "16 General m director \n", "17 General m director \n", "18 General m director \n", "19 General m director \n", "20 General m publishing committee \n", "21 General m publishing committee \n", "22 General m publishing committee \n", "23 General m \n", "24 General m \n", "25 General m \n", "26 General m \n", "27 General m publishing committee \n", "28 General m publishing committee \n", "29 General m publishing committee \n", "... ... ... ... \n", "15053 board of trustees \n", "15054 board of trustees \n", "15055 board of trustees \n", "15056 board of trustees \n", "15057 board of trustees \n", "15058 board of trustees \n", "15059 board of trustees \n", "15060 board of trustees \n", "15061 board of trustees \n", "15062 board of trustees \n", "15063 officers of the board \n", "15064 officers \n", "15065 officers \n", "15066 Columbia Union executive committee \n", "15067 Columbia Union executive committee \n", "15068 Columbia Union executive committee \n", "15069 Columbia Union executive committee \n", "15070 Columbia Union executive committee \n", "15071 Columbia Union executive committee \n", "15072 Columbia Union executive committee \n", "15073 Columbia Union executive committee \n", "15074 Lake Union executive committee \n", "15075 Lake Union executive committee \n", "15076 Lake Union executive committee \n", "15077 Lake Union executive committee \n", "15078 Lake Union executive committee \n", "15079 Lake Union executive committee \n", "15080 Lake Union executive committee \n", "15081 Lake Union executive committee \n", "15082 Pacific Union executive committee \n", "\n", " institution-name lastname \\\n", "0 Educational Society Butler \n", "1 Educational Society Haskell \n", "2 Educational Society Henry \n", "3 Educational Society Kellogg \n", "4 Educational Society Kellogg \n", "5 Educational Society Oyen \n", "6 Educational Society Sisley \n", "7 Health Reform Institute Fargo \n", "8 Health Reform Institute Hall \n", "9 Health Reform Institute Hall \n", "10 Health Reform Institute Haskell \n", "11 Health Reform Institute Henry \n", "12 Health Reform Institute Kellogg \n", "13 Health Reform Institute Murphy \n", "14 Pacific Seventh-day Adventist Publishing Assoc... Glenn \n", "15 Pacific Seventh-day Adventist Publishing Assoc... Haskell \n", "16 Pacific Seventh-day Adventist Publishing Assoc... Israel \n", "17 Pacific Seventh-day Adventist Publishing Assoc... Jones \n", "18 Pacific Seventh-day Adventist Publishing Assoc... Morrison \n", "19 Pacific Seventh-day Adventist Publishing Assoc... White \n", "20 Pacific Seventh-day Adventist Publishing Assoc... Haskell \n", "21 Pacific Seventh-day Adventist Publishing Assoc... Waggoner \n", "22 Pacific Seventh-day Adventist Publishing Assoc... White \n", "23 Pacific Seventh-day Adventist Publishing Assoc... Haskell \n", "24 Pacific Seventh-day Adventist Publishing Assoc... Vickery \n", "25 Pacific Seventh-day Adventist Publishing Assoc... White \n", "26 Seventh-day Adventist Publishing Association Sisley \n", "27 Seventh-day Adventist Publishing Association Amadon \n", "28 Seventh-day Adventist Publishing Association Butler \n", "29 Seventh-day Adventist Publishing Association Smith \n", "... ... ... \n", "15053 Loma Linda Sanitarium Martin \n", "15054 Loma Linda Sanitarium Reaser \n", "15055 Loma Linda Sanitarium Risley \n", "15056 Loma Linda Sanitarium Bowen \n", "15057 Loma Linda Sanitarium McElhany \n", "15058 Loma Linda Sanitarium Evans \n", "15059 Loma Linda Sanitarium Vollmer \n", "15060 Loma Linda Sanitarium Magan \n", "15061 Loma Linda Sanitarium Weir \n", "15062 Loma Linda Sanitarium Christian \n", "15063 Loma Linda Sanitarium Evans \n", "15064 St. Helena Sanitarium Rice \n", "15065 St. Helena Sanitarium Rice \n", "15066 Booth \n", "15067 Harter \n", "15068 Parsons \n", "15069 Moffet \n", "15070 Leland \n", "15071 Lindsay \n", "15072 Westbrook \n", "15073 Shaw \n", "15074 Clark \n", "15075 Westworth \n", "15076 Holden \n", "15077 Wiest \n", "15078 Nethery \n", "15079 Irwin \n", "15080 Bristol \n", "15081 Piper \n", "15082 Adams \n", "\n", " location name \\\n", "0 Battle Creek, MI Geo. I. \n", "1 South Lancaster, MA S.N. \n", "2 Battle Creek, MI A.R. \n", "3 Battle Creek, MI J.H. \n", "4 Battle Creek, MI H.W. \n", "5 Battle Creek, MI A.B. \n", "6 Battle Creek, MI W.C. \n", "7 Greenville, MI J. \n", "8 Battle Creek, MI W.H. \n", "9 Battle Creek, MI L.M. \n", "10 South Lancaster, MA S.N. \n", "11 Battle Creek, MI A.R. \n", "12 Battle Creek, MI J.H. \n", "13 Battle Creek, MI G.H. \n", "14 Oakland, CA W.N. \n", "15 South Lancaster, MA S.N. \n", "16 Oakland, CA M.C. \n", "17 Oakland, CA C.H. \n", "18 Healdsburg, CA J. \n", "19 Oakland, CA W.C. \n", "20 South Lancaster, MA S.N. \n", "21 Oakland, CA J.H. \n", "22 Oakland, CA W.C. \n", "23 South Lancaster, MA S.N. \n", "24 Oakland, CA W.K. \n", "25 Oakland, CA W.C. \n", "26 Battle Creek, MI W.C. \n", "27 Battle Creek, MI G.W. \n", "28 Battle Creek, MI Geo. I. \n", "29 Battle Creek, MI U. \n", "... ... ... \n", "15053 W.F. \n", "15054 G.W. \n", "15055 E.H. \n", "15056 L.M. \n", "15057 J.L. \n", "15058 Newton \n", "15059 H.W. \n", "15060 P.T. \n", "15061 J.J. \n", "15062 J.W. \n", "15063 Newton \n", "15064 Helen N. \n", "15065 Helen N. \n", "15066 A.S. \n", "15067 R.E. \n", "15068 D.A. \n", "15069 W.C. \n", "15070 J.A. \n", "15071 R.S. \n", "15072 T.B. \n", "15073 Fred \n", "15074 A.J. \n", "15075 Wm. A. \n", "15076 W.H. \n", "15077 C.S. \n", "15078 R.J. \n", "15079 J.J. \n", "15080 E.A. \n", "15081 J.F. \n", "15082 W.M. \n", "\n", " organization page \\\n", "0 7 \n", "1 7 \n", "2 7 \n", "3 7 \n", "4 7 \n", "5 7 \n", "6 7 \n", "7 7 \n", "8 7 \n", "9 7 \n", "10 7 \n", "11 7 \n", "12 7 \n", "13 7 \n", "14 7 \n", "15 7 \n", "16 7 \n", "17 7 \n", "18 7 \n", "19 7 \n", "20 7 \n", "21 7 \n", "22 7 \n", "23 7 \n", "24 7 \n", "25 7 \n", "26 6 \n", "27 6 \n", "28 6 \n", "29 6 \n", "... ... ... \n", "15053 265, 227 \n", "15054 265, 227 \n", "15055 265, 227 \n", "15056 265, 227 \n", "15057 265, 227 \n", "15058 265, 227 \n", "15059 265, 227 \n", "15060 265, 227 \n", "15061 265, 227 \n", "15062 265, 227 \n", "15063 265, 227 \n", "15064 California Medical Missionary and Benevolent A... 267-268 \n", "15065 California Medical Missionary and Benevolent A... 267-268 \n", "15066 39, 40 \n", "15067 39, 41 \n", "15068 39, 42 \n", "15069 39, 44 \n", "15070 39, 47 \n", "15071 39, 48 \n", "15072 39, 49 \n", "15073 48-49 \n", "15074 54, 55 \n", "15075 54, 57 \n", "15076 54, 59 \n", "15077 54, 60 \n", "15078 54, 62 \n", "15079 54, 63 \n", "15080 54, 64 \n", "15081 54, 66 \n", "15082 95-96 \n", "\n", " position position-information prefix region \\\n", "0 trustee Michigan \n", "1 trustee Michigan \n", "2 trustee Michigan \n", "3 trustee Michigan \n", "4 trustee Michigan \n", "5 trustee Michigan \n", "6 trustee Michigan \n", "7 director Michigan \n", "8 director Michigan \n", "9 director Michigan \n", "10 director Michigan \n", "11 director Michigan \n", "12 director Michigan \n", "13 director Michigan \n", "14 auditor \n", "15 director \n", "16 director \n", "17 director \n", "18 director \n", "19 director \n", "20 committee member \n", "21 committee member \n", "22 committee member \n", "23 president \n", "24 secretary \n", "25 vice president \n", "26 auditor Michigan \n", "27 committee member Michigan \n", "28 committee member Michigan \n", "29 committee member Michigan \n", "... ... ... ... ... \n", "15053 trustee California \n", "15054 trustee California \n", "15055 trustee California \n", "15056 trustee California \n", "15057 trustee California \n", "15058 trustee California \n", "15059 trustee California \n", "15060 trustee California \n", "15061 trustee California \n", "15062 trustee California \n", "15063 vice president California \n", "15064 lady head nurse Miss California \n", "15065 secretary training-school Miss California \n", "15066 committee member \n", "15067 committee member \n", "15068 committee member \n", "15069 committee member \n", "15070 committee member \n", "15071 committee member \n", "15072 committee member \n", "15073 committee member West Pennsylvania \n", "15074 committee member \n", "15075 committee member \n", "15076 committee member \n", "15077 committee member \n", "15078 committee member \n", "15079 committee member \n", "15080 committee member \n", "15081 committee member \n", "15082 committee member Southern California \n", "\n", " suffix yearbook-year \n", "0 1883 \n", "1 1883 \n", "2 1883 \n", "3 M.D. 1883 \n", "4 1883 \n", "5 1883 \n", "6 1883 \n", "7 1883 \n", "8 1883 \n", "9 1883 \n", "10 1883 \n", "11 1883 \n", "12 M.D. 1883 \n", "13 1883 \n", "14 1883 \n", "15 1883 \n", "16 1883 \n", "17 1883 \n", "18 1883 \n", "19 1883 \n", "20 1883 \n", "21 1883 \n", "22 1883 \n", "23 1883 \n", "24 1883 \n", "25 1883 \n", "26 1883 \n", "27 1883 \n", "28 1883 \n", "29 1883 \n", "... ... ... \n", "15053 1920 \n", "15054 1920 \n", "15055 1920 \n", "15056 1920 \n", "15057 1920 \n", "15058 1920 \n", "15059 1920 \n", "15060 1920 \n", "15061 1920 \n", "15062 1920 \n", "15063 1920 \n", "15064 R.N. 1920 \n", "15065 R.N. 1920 \n", "15066 1920 \n", "15067 1920 \n", "15068 1920 \n", "15069 1920 \n", "15070 1920 \n", "15071 1920 \n", "15072 1920 \n", "15073 1920 \n", "15074 1920 \n", "15075 1920 \n", "15076 1920 \n", "15077 1920 \n", "15078 1920 \n", "15079 1920 \n", "15080 1920 \n", "15081 1920 \n", "15082 1920 \n", "\n", "[15083 rows x 15 columns]" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": true }, "outputs": [], "source": [ "last_names = df['lastname']" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "collapsed": true }, "outputs": [], "source": [ "last_names_df = last_names.str.rsplit(' ', expand=True)" ] }, { "cell_type": "code", "execution_count": 12, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
0123
0ButlerNoneNoneNone
1HaskellNoneNoneNone
2HenryNoneNoneNone
3KelloggNoneNoneNone
4KelloggNoneNoneNone
5OyenNoneNoneNone
6SisleyNoneNoneNone
7FargoNoneNoneNone
8HallNoneNoneNone
9HallNoneNoneNone
10HaskellNoneNoneNone
11HenryNoneNoneNone
12KelloggNoneNoneNone
13MurphyNoneNoneNone
14GlennNoneNoneNone
15HaskellNoneNoneNone
16IsraelNoneNoneNone
17JonesNoneNoneNone
18MorrisonNoneNoneNone
19WhiteNoneNoneNone
20HaskellNoneNoneNone
21WaggonerNoneNoneNone
22WhiteNoneNoneNone
23HaskellNoneNoneNone
24VickeryNoneNoneNone
25WhiteNoneNoneNone
26SisleyNoneNoneNone
27AmadonNoneNoneNone
28ButlerNoneNoneNone
29SmithNoneNoneNone
...............
15053MartinNoneNoneNone
15054ReaserNoneNoneNone
15055RisleyNoneNoneNone
15056BowenNoneNoneNone
15057McElhanyNoneNoneNone
15058EvansNoneNoneNone
15059VollmerNoneNoneNone
15060MaganNoneNoneNone
15061WeirNoneNoneNone
15062ChristianNoneNoneNone
15063EvansNoneNoneNone
15064RiceNoneNoneNone
15065RiceNoneNoneNone
15066BoothNoneNoneNone
15067HarterNoneNoneNone
15068ParsonsNoneNoneNone
15069MoffetNoneNoneNone
15070LelandNoneNoneNone
15071LindsayNoneNoneNone
15072WestbrookNoneNoneNone
15073ShawNoneNoneNone
15074ClarkNoneNoneNone
15075WestworthNoneNoneNone
15076HoldenNoneNoneNone
15077WiestNoneNoneNone
15078NetheryNoneNoneNone
15079IrwinNoneNoneNone
15080BristolNoneNoneNone
15081PiperNoneNoneNone
15082AdamsNoneNoneNone
\n", "

15083 rows × 4 columns

\n", "
" ], "text/plain": [ " 0 1 2 3\n", "0 Butler None None None\n", "1 Haskell None None None\n", "2 Henry None None None\n", "3 Kellogg None None None\n", "4 Kellogg None None None\n", "5 Oyen None None None\n", "6 Sisley None None None\n", "7 Fargo None None None\n", "8 Hall None None None\n", "9 Hall None None None\n", "10 Haskell None None None\n", "11 Henry None None None\n", "12 Kellogg None None None\n", "13 Murphy None None None\n", "14 Glenn None None None\n", "15 Haskell None None None\n", "16 Israel None None None\n", "17 Jones None None None\n", "18 Morrison None None None\n", "19 White None None None\n", "20 Haskell None None None\n", "21 Waggoner None None None\n", "22 White None None None\n", "23 Haskell None None None\n", "24 Vickery None None None\n", "25 White None None None\n", "26 Sisley None None None\n", "27 Amadon None None None\n", "28 Butler None None None\n", "29 Smith None None None\n", "... ... ... ... ...\n", "15053 Martin None None None\n", "15054 Reaser None None None\n", "15055 Risley None None None\n", "15056 Bowen None None None\n", "15057 McElhany None None None\n", "15058 Evans None None None\n", "15059 Vollmer None None None\n", "15060 Magan None None None\n", "15061 Weir None None None\n", "15062 Christian None None None\n", "15063 Evans None None None\n", "15064 Rice None None None\n", "15065 Rice None None None\n", "15066 Booth None None None\n", "15067 Harter None None None\n", "15068 Parsons None None None\n", "15069 Moffet None None None\n", "15070 Leland None None None\n", "15071 Lindsay None None None\n", "15072 Westbrook None None None\n", "15073 Shaw None None None\n", "15074 Clark None None None\n", "15075 Westworth None None None\n", "15076 Holden None None None\n", "15077 Wiest None None None\n", "15078 Nethery None None None\n", "15079 Irwin None None None\n", "15080 Bristol None None None\n", "15081 Piper None None None\n", "15082 Adams None None None\n", "\n", "[15083 rows x 4 columns]" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "last_names_df" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "collapsed": true }, "outputs": [], "source": [ "def df_to_list(df):\n", " headers = list(df.columns.values)\n", " list_out = []\n", " for header in headers:\n", " df[header].str.strip()\n", " col = df[header].tolist()\n", " for each in col:\n", " if str(each).isalpha() and len(str(each)) > 2:\n", " list_out.append(each)\n", " else:\n", " pass\n", " return(list_out) " ] }, { "cell_type": "code", "execution_count": 14, "metadata": { "collapsed": true }, "outputs": [], "source": [ "last_names_split = df_to_list(last_names_df)" ] }, { "cell_type": "code", "execution_count": 15, "metadata": { "collapsed": true }, "outputs": [], "source": [ "out_dir = '/Users/jeriwieringa/Dissertation/drafts/data/word-lists/'" ] }, { "cell_type": "code", "execution_count": 16, "metadata": { "collapsed": true }, "outputs": [], "source": [ "with open(\"{}{}-SDA-last-names.txt\".format(out_dir,str(datetime.date.today())), \"w\") as f:\n", " for name in last_names_split:\n", " f.write(\"{}\\n\".format(name))" ] }, { "cell_type": "code", "execution_count": 17, "metadata": { "collapsed": true }, "outputs": [], "source": [ "df2 = df" ] }, { "cell_type": "code", "execution_count": 18, "metadata": { "collapsed": true }, "outputs": [], "source": [ "def drop_empty_rows(df, header):\n", " df[header].replace('', np.nan, inplace=True)\n", " df.dropna(subset=[header], inplace=True)\n", " return(df)" ] }, { "cell_type": "code", "execution_count": 19, "metadata": { "collapsed": true }, "outputs": [], "source": [ "df2 = drop_empty_rows(df2, 'location')" ] }, { "cell_type": "code", "execution_count": 20, "metadata": { "collapsed": true }, "outputs": [], "source": [ "places = df2['location']" ] }, { "cell_type": "code", "execution_count": 21, "metadata": { "collapsed": true }, "outputs": [], "source": [ "places = places.str.replace(' ', ',')" ] }, { "cell_type": "code", "execution_count": 22, "metadata": { "collapsed": true }, "outputs": [], "source": [ "df3 = places.str.split(',', expand=True)" ] }, { "cell_type": "code", "execution_count": 23, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
0123456789101112131415
0BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
1SouthLancasterMANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
2BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
3BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
4BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
5BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
6BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
7GreenvilleMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
8BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
9BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
10SouthLancasterMANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
11BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
12BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
13BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
14OaklandCANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
15SouthLancasterMANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
16OaklandCANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
17OaklandCANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
18HealdsburgCANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
19OaklandCANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
20SouthLancasterMANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
21OaklandCANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
22OaklandCANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
23SouthLancasterMANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
24OaklandCANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
25OaklandCANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
26BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
27BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
28BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
29BattleCreekMINoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
...................................................
136971302HardingSt.NashvilleTNNoneNoneNoneNoneNoneNoneNoneNoneNone
136981051MississippiBlvd.MemphisTNNoneNoneNoneNoneNoneNoneNoneNoneNone
13699736SaffransSt.MemphisTNNoneNoneNoneNoneNoneNoneNoneNoneNone
13700AshlandCityTNNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
13701901BuchananSt.NashvilleTNNoneNoneNoneNoneNoneNoneNoneNoneNone
13702LeachTNNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
13703Route1BurnsTNNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
13704Route3GoodlettsvilleTNNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
137052310SiefriedSt.NashvilleTNNoneNoneNoneNoneNoneNoneNoneNoneNone
137062119Twenty-fourthAve.NorthNashvilleTNNoneNoneNoneNoneNoneNoneNone
13712BonAquaTNNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
13713JacksonTNNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
13714NashvilleTNNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
13715994MississippiBlvd.MemphisTNNoneNoneNoneNoneNoneNoneNoneNoneNone
13716322JacksonBldg.NashvilleTNNoneNoneNoneNoneNoneNoneNoneNoneNone
13717322JacksonBldg.NashvilleTNNoneNoneNoneNoneNoneNoneNoneNoneNone
13718322JacksonBldg.NashvilleTNNoneNoneNoneNoneNoneNoneNoneNoneNone
137192111EvelynAve.MemphisTNNoneNoneNoneNoneNoneNoneNoneNoneNone
137201900Twenty-FourthAve.NorthNashvilleTNNoneNoneNoneNoneNoneNoneNone
13721666NorthDunlapSt.MemphisTNNoneNoneNoneNoneNoneNoneNoneNone
137222315SeifriedSt.NashvilleTNNoneNoneNoneNoneNoneNoneNoneNoneNone
13723322JacksonBldg.NashvilleTNNoneNoneNoneNoneNoneNoneNoneNoneNone
13724322JacksonBldg.NashvilleTNNoneNoneNoneNoneNoneNoneNoneNoneNone
13725Twenty-fourthandNewBridgeRoadNorthNashvilleTNNoneNoneNoneNoneNone
13726PaducahKYNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
15017JamaicaNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
15019Box146GlendaleCANoneNoneNoneNoneNoneNoneNoneNoneNoneNone
15020CollegeViewNENoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
150212718ThirdAve.SouthMinneapolisMNNoneNoneNoneNoneNoneNoneNone
15022CollegePlaceWANoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
\n", "

6467 rows × 16 columns

\n", "
" ], "text/plain": [ " 0 1 2 3 4 \\\n", "0 Battle Creek MI None \n", "1 South Lancaster MA None \n", "2 Battle Creek MI None \n", "3 Battle Creek MI None \n", "4 Battle Creek MI None \n", "5 Battle Creek MI None \n", "6 Battle Creek MI None \n", "7 Greenville MI None None \n", "8 Battle Creek MI None \n", "9 Battle Creek MI None \n", "10 South Lancaster MA None \n", "11 Battle Creek MI None \n", "12 Battle Creek MI None \n", "13 Battle Creek MI None \n", "14 Oakland CA None None \n", "15 South Lancaster MA None \n", "16 Oakland CA None None \n", "17 Oakland CA None None \n", "18 Healdsburg CA None None \n", "19 Oakland CA None None \n", "20 South Lancaster MA None \n", "21 Oakland CA None None \n", "22 Oakland CA None None \n", "23 South Lancaster MA None \n", "24 Oakland CA None None \n", "25 Oakland CA None None \n", "26 Battle Creek MI None \n", "27 Battle Creek MI None \n", "28 Battle Creek MI None \n", "29 Battle Creek MI None \n", "... ... ... ... ... ... \n", "13697 1302 Harding St. Nashville \n", "13698 1051 Mississippi Blvd. Memphis \n", "13699 736 Saffrans St. Memphis \n", "13700 Ashland City TN None \n", "13701 901 Buchanan St. Nashville \n", "13702 Leach TN None None \n", "13703 Route 1 Burns \n", "13704 Route 3 Goodlettsville \n", "13705 2310 Siefried St. Nashville \n", "13706 2119 Twenty-fourth Ave. North \n", "13712 Bon Aqua TN None \n", "13713 Jackson TN None None \n", "13714 Nashville TN None None \n", "13715 994 Mississippi Blvd. Memphis \n", "13716 322 Jackson Bldg. Nashville \n", "13717 322 Jackson Bldg. Nashville \n", "13718 322 Jackson Bldg. Nashville \n", "13719 2111 Evelyn Ave. Memphis \n", "13720 1900 Twenty-Fourth Ave. North \n", "13721 666 North Dunlap St. \n", "13722 2315 Seifried St. Nashville \n", "13723 322 Jackson Bldg. Nashville \n", "13724 322 Jackson Bldg. Nashville \n", "13725 Twenty-fourth and New Bridge Road \n", "13726 Paducah KY None None \n", "15017 Jamaica None None None None \n", "15019 Box 146 Glendale \n", "15020 College View NE None \n", "15021 2718 Third Ave. South \n", "15022 College Place WA None \n", "\n", " 5 6 7 8 9 10 11 12 13 \\\n", "0 None None None None None None None None None \n", "1 None None None None None None None None None \n", "2 None None None None None None None None None \n", "3 None None None None None None None None None \n", "4 None None None None None None None None None \n", "5 None None None None None None None None None \n", "6 None None None None None None None None None \n", "7 None None None None None None None None None \n", "8 None None None None None None None None None \n", "9 None None None None None None None None None \n", "10 None None None None None None None None None \n", "11 None None None None None None None None None \n", "12 None None None None None None None None None \n", "13 None None None None None None None None None \n", "14 None None None None None None None None None \n", "15 None None None None None None None None None \n", "16 None None None None None None None None None \n", "17 None None None None None None None None None \n", "18 None None None None None None None None None \n", "19 None None None None None None None None None \n", "20 None None None None None None None None None \n", "21 None None None None None None None None None \n", "22 None None None None None None None None None \n", "23 None None None None None None None None None \n", "24 None None None None None None None None None \n", "25 None None None None None None None None None \n", "26 None None None None None None None None None \n", "27 None None None None None None None None None \n", "28 None None None None None None None None None \n", "29 None None None None None None None None None \n", "... ... ... ... ... ... ... ... ... ... \n", "13697 TN None None None None None None None \n", "13698 TN None None None None None None None \n", "13699 TN None None None None None None None \n", "13700 None None None None None None None None None \n", "13701 TN None None None None None None None \n", "13702 None None None None None None None None None \n", "13703 TN None None None None None None None None \n", "13704 TN None None None None None None None None \n", "13705 TN None None None None None None None \n", "13706 Nashville TN None None None None None \n", "13712 None None None None None None None None None \n", "13713 None None None None None None None None None \n", "13714 None None None None None None None None None \n", "13715 TN None None None None None None None \n", "13716 TN None None None None None None None \n", "13717 TN None None None None None None None \n", "13718 TN None None None None None None None \n", "13719 TN None None None None None None None \n", "13720 Nashville TN None None None None None \n", "13721 Memphis TN None None None None None None \n", "13722 TN None None None None None None None \n", "13723 TN None None None None None None None \n", "13724 TN None None None None None None None \n", "13725 North Nashville TN None None None \n", "13726 None None None None None None None None None \n", "15017 None None None None None None None None None \n", "15019 CA None None None None None None None None \n", "15020 None None None None None None None None None \n", "15021 Minneapolis MN None None None None None \n", "15022 None None None None None None None None None \n", "\n", " 14 15 \n", "0 None None \n", "1 None None \n", "2 None None \n", "3 None None \n", "4 None None \n", "5 None None \n", "6 None None \n", "7 None None \n", "8 None None \n", "9 None None \n", "10 None None \n", "11 None None \n", "12 None None \n", "13 None None \n", "14 None None \n", "15 None None \n", "16 None None \n", "17 None None \n", "18 None None \n", "19 None None \n", "20 None None \n", "21 None None \n", "22 None None \n", "23 None None \n", "24 None None \n", "25 None None \n", "26 None None \n", "27 None None \n", "28 None None \n", "29 None None \n", "... ... ... \n", "13697 None None \n", "13698 None None \n", "13699 None None \n", "13700 None None \n", "13701 None None \n", "13702 None None \n", "13703 None None \n", "13704 None None \n", "13705 None None \n", "13706 None None \n", "13712 None None \n", "13713 None None \n", "13714 None None \n", "13715 None None \n", "13716 None None \n", "13717 None None \n", "13718 None None \n", "13719 None None \n", "13720 None None \n", "13721 None None \n", "13722 None None \n", "13723 None None \n", "13724 None None \n", "13725 None None \n", "13726 None None \n", "15017 None None \n", "15019 None None \n", "15020 None None \n", "15021 None None \n", "15022 None None \n", "\n", "[6467 rows x 16 columns]" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df3" ] }, { "cell_type": "code", "execution_count": 24, "metadata": { "collapsed": true }, "outputs": [], "source": [ "places_split = df_to_list(df3)" ] }, { "cell_type": "code", "execution_count": 25, "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/plain": [ "['Gray',\n", " 'Oroville',\n", " 'Shreveport',\n", " 'Sāo',\n", " 'Alto',\n", " 'Central',\n", " 'Castlereagh',\n", " 'Warrenton',\n", " 'Alexandria',\n", " 'Cannelton',\n", " 'Hydro',\n", " 'National',\n", " 'Ladysmith',\n", " 'Sylvan',\n", " 'Vaughn',\n", " 'Fish',\n", " 'Watts',\n", " 'Elgin',\n", " 'Cheng',\n", " 'Winslow',\n", " 'Junction',\n", " 'Zone',\n", " 'Logan',\n", " 'Edenville',\n", " 'Watertown',\n", " 'Lincoln',\n", " 'Kilmarnock',\n", " 'Whalan',\n", " 'Corydon',\n", " 'Danville',\n", " 'Newark',\n", " 'Fox',\n", " 'Omer',\n", " 'Springboro',\n", " 'British',\n", " 'Copenhagan',\n", " 'Ave',\n", " 'Walnut',\n", " 'Trade',\n", " 'Beach',\n", " 'Asbury',\n", " 'Fancher',\n", " 'Rileyville',\n", " 'Muscoda',\n", " 'Moorestown',\n", " 'Whipple',\n", " 'Vaud',\n", " 'Roaring',\n", " 'Antonio',\n", " 'Royal']" ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "list(set(places_split))[:50]" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "80237" ] }, "execution_count": 26, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(places_split)" ] }, { "cell_type": "code", "execution_count": 27, "metadata": { "collapsed": true }, "outputs": [], "source": [ "with open(\"{}{}-SDA-place-names.txt\".format(out_dir,str(datetime.date.today())), \"w\") as f:\n", " for place in list(set(places_split)):\n", " f.write(\"{}\\n\".format(place))" ] }, { "cell_type": "code", "execution_count": 28, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "{'commit_hash': '5c9c918',\n", " 'commit_source': 'installation',\n", " 'default_encoding': 'UTF-8',\n", " 'ipython_path': '/Users/jeriwieringa/miniconda3/envs/dissertation2/lib/python3.5/site-packages/IPython',\n", " 'ipython_version': '5.1.0',\n", " 'os_name': 'posix',\n", " 'platform': 'Darwin-16.1.0-x86_64-i386-64bit',\n", " 'sys_executable': '/Users/jeriwieringa/miniconda3/envs/dissertation2/bin/python',\n", " 'sys_platform': 'darwin',\n", " 'sys_version': '3.5.2 |Continuum Analytics, Inc.| (default, Jul 2 2016, '\n", " '17:52:12) \\n'\n", " '[GCC 4.2.1 Compatible Apple LLVM 4.2 (clang-425.0.28)]'}\n", "anaconda-client==1.5.5\n", "appnope==0.1.0\n", "argh==0.26.1\n", "blinker==1.4\n", "bokeh==0.12.3\n", "boto==2.43.0\n", "bz2file==0.98\n", "chest==0.2.3\n", "cloudpickle==0.2.1\n", "clyent==1.2.2\n", "dask==0.12.0\n", "datashader==0.4.0\n", "datashape==0.5.2\n", "decorator==4.0.10\n", "docutils==0.12\n", "doit==0.29.0\n", "gensim==0.12.4\n", "Ghost.py==0.2.3\n", "ghp-import2==1.0.1\n", "gspread==0.4.1\n", "HeapDict==1.0.0\n", "httplib2==0.9.2\n", "husl==4.0.3\n", "ipykernel==4.5.2\n", "ipython==5.1.0\n", "ipython-genutils==0.1.0\n", "ipywidgets==5.2.2\n", "Jinja2==2.8\n", "jsonschema==2.5.1\n", "jupyter==1.0.0\n", "jupyter-client==4.4.0\n", "jupyter-console==5.0.0\n", "jupyter-core==4.2.1\n", "llvmlite==0.14.0\n", "locket==0.2.0\n", "Logbook==1.0.0\n", "lxml==3.5.0\n", "MacFSEvents==0.7\n", "Mako==1.0.4\n", "Markdown==2.6.7\n", "MarkupSafe==0.23\n", "mistune==0.7.3\n", "multipledispatch==0.4.9\n", "natsort==4.0.4\n", "nb-anacondacloud==1.2.0\n", "nb-conda==2.0.0\n", "nb-conda-kernels==2.0.0\n", "nb-config-manager==0.1.3\n", "nbbrowserpdf==0.2.1\n", "nbconvert==4.2.0\n", "nbformat==4.2.0\n", "nbpresent==3.0.2\n", "networkx==1.11\n", "Nikola==7.7.7\n", "nltk==3.2.1\n", "notebook==4.2.3\n", "numba==0.29.0\n", "numpy==1.11.2\n", "oauth2client==4.0.0\n", "odo==0.5.0\n", "pandas==0.19.1\n", "partd==0.3.6\n", "path.py==0.0.0\n", "pathtools==0.1.2\n", "pexpect==4.0.1\n", "pickleshare==0.7.4\n", "Pillow==3.4.2\n", "prompt-toolkit==1.0.9\n", "ptyprocess==0.5.1\n", "pyasn1==0.1.9\n", "pyasn1-modules==0.0.8\n", "pycrypto==2.6.1\n", "Pygments==2.1.3\n", "PyPDF2==1.25.1\n", "PyRSS2Gen==1.1\n", "python-dateutil==2.6.0\n", "pytz==2016.10\n", "PyYAML==3.12\n", "pyzmq==16.0.2\n", "qtconsole==4.2.1\n", "requests==2.12.3\n", "rsa==3.4.2\n", "scipy==0.18.1\n", "simplegeneric==0.8.1\n", "six==1.10.0\n", "smart-open==1.3.5\n", "terminado==0.6\n", "textblob==0.11.1\n", "toolz==0.8.1\n", "tornado==4.4.2\n", "traitlets==4.3.1\n", "Unidecode==0.4.19\n", "watchdog==0.8.3\n", "wcwidth==0.1.7\n", "webassets==0.11.1\n", "widgetsnbextension==1.2.6\n", "ws4py==0.3.4\n", "xarray==0.8.2\n", "Yapsy==1.11.223\n" ] } ], "source": [ "# %load shared_elements/system_info.py\n", "import IPython\n", "print (IPython.sys_info())\n", "!pip freeze" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] } ], "metadata": { "anaconda-cloud": {}, "kernelspec": { "display_name": "Python [conda env:dissertation2]", "language": "python", "name": "conda-env-dissertation2-py" }, "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.5.2" } }, "nbformat": 4, "nbformat_minor": 2 }