Runeberg


In [1]:
from everything import *
from dasem.runeberg import Runeberg

In [2]:
runeberg = Runeberg()

In [3]:
catalogue = runeberg.catalogue()

In [4]:
catalogue.ix[catalogue.language == 'dk', :].head(15)


Out[4]:
author author_id book_id language title type year
21 Alexander von Humboldt humboale eurasrus dk A. v. Humboldts Reiser i det Europæiske og Asi... Book 1856
27 Hans Christian Ørsted orstehan aanden dk Aanden i Naturen Book 1850
29 Karl Gjellerup gjelleka aanderotid dk Aander og Tider. Et Rekviem over Charles Darwin Book 1882
30 Frederik Dreier dreiefre aandetroen dk Aandetroen og Den frie Tænkning Book 1852
31 Emil Aarestrup aarestru aarestrups dk Aarestrups samlede digte Book 1913
40 Adam Bremensis adambrem adamafbrem dk Adam af Bremen om Menigheden i Norden under Er... Book 1862
41 Gustav Wied wiedgust adelgejs dk Adel, Gejstlighed, Borger og Bonde Book 1897
76 Christian Frederik Emil Horneman hornechr aladdinev dk Aladdin. Eventyr-Opera i 4e Akter Music 1893
86 Jens Zetlitz zetlijen alkoran dk Alkoran d. e. Capitlernes Bog for 1806 Book 1806
99 Thomas Hansen Erslew ersletho almiforf dk Almindeligt Forfatter-Lexicon for Kongeriget D... Book 1843-1868
129 berggreen dk Andreas Peter Berggreen. Et Mindeskrift Book 1895
143 annordoldk dk Annaler for nordisk oldkyndighed (og historie) Periodical 1836-1863
144 Ellen Key ellenkey acleffler dk Anne Charlotte Leffler. Hertuginde af Cajanello Book 1893
167 antiqdk dk Antiquarisk tidsskrift / udg. af det Kongelige... Periodical 1845-1864
186 anf dk Arkiv for/för nordisk filologi Periodical 1882

In [5]:
query = """
SELECT ?author ?authorLabel ?runeberg WHERE {
  ?author wdt:P3154 ?runeberg .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da". }  
} 
"""
service = sparql.Service('https://query.wikidata.org/sparql', method="GET")
response = service.query(query)
wikidata = pd.DataFrame(response.fetchall(), columns=response.variables)

In [6]:
wikidata.head()


Out[6]:
author authorLabel runeberg
0 http://www.wikidata.org/entity/Q991 Fjodor Dostojevskij dostofjo
1 http://www.wikidata.org/entity/Q5679 Lord Byron byrongeo
2 http://www.wikidata.org/entity/Q211039 Jeppe Aakjær aakjajep
3 http://www.wikidata.org/entity/Q347953 Steen Steensen Blicher blicher
4 http://www.wikidata.org/entity/Q331893 N.F.S. Grundtvig grundtvg

In [7]:
wikidata.runeberg = wikidata.runeberg.astype(str)
wikidata.author = wikidata.author.astype(str)
wikidata.authorLabel = wikidata.authorLabel.astype(unicode)
wikidata.rename(columns={'runeberg': 'author_id'}, inplace=True)
wikidata.head()


Out[7]:
author authorLabel author_id
0 http://www.wikidata.org/entity/Q991 Fjodor Dostojevskij dostofjo
1 http://www.wikidata.org/entity/Q5679 Lord Byron byrongeo
2 http://www.wikidata.org/entity/Q211039 Jeppe Aakjær aakjajep
3 http://www.wikidata.org/entity/Q347953 Steen Steensen Blicher blicher
4 http://www.wikidata.org/entity/Q331893 N.F.S. Grundtvig grundtvg

In [8]:
def aggregator(elements):
    return u",".join(set(elements))

catalogue_authors = catalogue.groupby('author_id', as_index=False).agg(aggregator)

In [9]:
catalogue_authors.head()


Out[9]:
author_id author book_id language title type year
0 trefinska,stud1840,stud1845,nordutid,univhus,v... fr,dk,no,ee,is,de,p>,it,us,fi,se,fo Vetenskapen och livet,Boken om Stockholm i ord... Music,Book,Administrative,Periodical ,1853-1857,1903-1931,1857,1900-1913,1772-1773,...
1 aakjajep Jeppe Aakjær regnebraet dk Mit Regnebræt En Selvbibliografi Book 1919
2 aalljaco Jacob Aall norge-1815 no Erindringer som Bidrag til Norges Historie fra... Book 1844
3 aaloelev Ülev Aaloe svet1979 se Svensk-estnisk ordbok : Rootsi-eesti sõnaraamat Book 1979
4 aarestru Emil Aarestrup efterladte,eenrum,aarestrups dk Efterladte Digter,Naar jeg i eenrum færdes,Aar... Book ,1913,1863

In [10]:
merged = pd.merge(catalogue_authors, wikidata, on='author_id', how='outer', suffixes=('_runeberg', '_wikidata'))
merged.ix[:, ['author_id', 'author_runeberg', 'authorLabel', 'author_wikidata']]


Out[10]:
author_id author_runeberg authorLabel author_wikidata
0 NaN NaN
1 aakjajep Jeppe Aakjær Jeppe Aakjær http://www.wikidata.org/entity/Q211039
2 aalljaco Jacob Aall NaN NaN
3 aaloelev Ülev Aaloe NaN NaN
4 aarestru Emil Aarestrup Emil Aarestrup http://www.wikidata.org/entity/Q350408
5 aaseniva Ivar Aasen NaN NaN
6 aasvehaa Haakon Aasvejen NaN NaN
7 abergjon Jon Olof Åberg NaN NaN
8 aberssim Simon Aberstén NaN NaN
9 abrahsel Selma Abrahamsson NaN NaN
10 aclanart Arthur Dyke Acland NaN NaN
11 adambrem Adam Bremensis Adam af Bremen http://www.wikidata.org/entity/Q109244
12 adelbott Ottilia Adelborg NaN NaN
13 adlergot Gottfrid Adlerz NaN NaN
14 adlergus Gustav Magnus Adlercreutz NaN NaN
15 adlerspc Carl August Adlersparre NaN NaN
16 adlerss2 Sophie Adlersparre NaN NaN
17 aelferik Erik Petter Älf NaN NaN
18 agardhca Carl Adolph Agardh NaN NaN
19 aggerpau Pauline Aggersborg Pauline Kristine Aggersborg http://www.wikidata.org/entity/Q28867605
20 agnesvon Agnes von Krusenstjerna Agnes von Krusenstjerna http://www.wikidata.org/entity/Q239386
21 agrellal Alfhild Agrell NaN NaN
22 agrellj Johan Joachim Agrell NaN NaN
23 agrelsig Sigurd Agrell NaN NaN
24 ahlenabr Abraham Ahlén NaN NaN
25 ahlfvfre Fredrik Elias Ahlfvengren NaN NaN
26 ahlmgust Gustaf Ahlm NaN NaN
27 ahlstrol Olof Åhlström NaN NaN
28 ahnfarvi Arvid Ahnfelt NaN NaN
29 ahnfpaul Paul Ahnfelt NaN NaN
... ... ... ... ...
1620 norbepeu NaN Q27996926 http://www.wikidata.org/entity/Q27996926
1621 kingotho NaN Thomas Kingo http://www.wikidata.org/entity/Q348827
1622 hostrujc NaN Jens Christian Hostrup http://www.wikidata.org/entity/Q563347
1623 bergveri NaN Erik Bergvall http://www.wikidata.org/entity/Q1353863
1624 kumliakk NaN Akke Kumlien http://www.wikidata.org/entity/Q4701360
1625 lyttkivb NaN Ivar Adolf Lyttkens http://www.wikidata.org/entity/Q5969086
1626 mollevim NaN Vilhelm Møller http://www.wikidata.org/entity/Q12341040
1627 cedersig NaN Sigvard Cederroth http://www.wikidata.org/entity/Q27436606
1628 lundbeng NaN Q27983631 http://www.wikidata.org/entity/Q27983631
1629 lindgras NaN Astrid Lindgren http://www.wikidata.org/entity/Q55767
1630 bregemar NaN Marie Bregendahl http://www.wikidata.org/entity/Q292980
1631 schansop NaN Sophus Schandorph http://www.wikidata.org/entity/Q321499
1632 nermatur NaN Ture Nerman http://www.wikidata.org/entity/Q538109
1633 sandbein NaN Inger Sandberg http://www.wikidata.org/entity/Q4569492
1634 lyttkiva NaN Ivar Lyttkens http://www.wikidata.org/entity/Q5969081
1635 jonsslud NaN Ludvig Jönsson http://www.wikidata.org/entity/Q6141019
1636 hansemad NaN Mads Hansen http://www.wikidata.org/entity/Q20669452
1637 kristofe NaN Christoffer af Bayern http://www.wikidata.org/entity/Q58056
1638 hmartins NaN Harry Martinson http://www.wikidata.org/entity/Q132695
1639 johnsoey NaN Eyvind Johnson http://www.wikidata.org/entity/Q131326
1640 bergmabo NaN Bo Bergman http://www.wikidata.org/entity/Q887342
1641 tunstrom NaN Göran Tunström http://www.wikidata.org/entity/Q968708
1642 heilmger NaN Gerhard Heilmann http://www.wikidata.org/entity/Q4993449
1643 lyttkyng NaN Yngve Lyttkens http://www.wikidata.org/entity/Q5969092
1644 thaartho NaN Thomas Thaarup http://www.wikidata.org/entity/Q6210244
1645 behrejac NaN Jacob Behrend http://www.wikidata.org/entity/Q23008444
1646 glucksam NaN Andreas Melchior Glückstad http://www.wikidata.org/entity/Q23010411
1647 simonshc NaN Hans Caspar Simonsen http://www.wikidata.org/entity/Q23005536
1648 lonegtor NaN Torsten Lönegren http://www.wikidata.org/entity/Q27983648
1649 macfihar NaN Q5970672 http://www.wikidata.org/entity/Q5970672

1650 rows × 4 columns


In [11]:
# How many authors in Danish?
merged.ix[merged.language=='dk', :].shape[0]


Out[11]:
120

In [12]:
danish_merged = merged.ix[merged.language=='dk', ['author_id', 'author_runeberg', 'authorLabel', 'author_wikidata']]
pd.set_option('display.max_rows', len(danish_merged))
danish_merged


Out[12]:
author_id author_runeberg authorLabel author_wikidata
1 aakjajep Jeppe Aakjær Jeppe Aakjær http://www.wikidata.org/entity/Q211039
4 aarestru Emil Aarestrup Emil Aarestrup http://www.wikidata.org/entity/Q350408
11 adambrem Adam Bremensis Adam af Bremen http://www.wikidata.org/entity/Q109244
19 aggerpau Pauline Aggersborg Pauline Kristine Aggersborg http://www.wikidata.org/entity/Q28867605
60 anderant Anton Andersen Anton Andersen http://www.wikidata.org/entity/Q26839026
79 ankjaer Stefan Ankjær Stefan Ankjær http://www.wikidata.org/entity/Q12337029
109 bajerfre Fredrik Bajer Fredrik Bajer http://www.wikidata.org/entity/Q191016
119 baudisop Sophus Bauditz Sophus Bauditz http://www.wikidata.org/entity/Q5567266
120 becketyg Tyge Becker Tyge Becker http://www.wikidata.org/entity/Q5568339
138 berggand Andreas Peter Berggreen Andreas Peter Berggreen http://www.wikidata.org/entity/Q499921
143 berghrud Rudolph Bergh Rudolph Bergh http://www.wikidata.org/entity/Q3090761
154 beringhc H. C. Bering Liisberg Bering Liisberg http://www.wikidata.org/entity/Q2269856
170 blicher Steen Steensen Blicher Steen Steensen Blicher http://www.wikidata.org/entity/Q347953
180 boeckchr Christopher Boeck Christopher Boeck http://www.wikidata.org/entity/Q5580423
182 bogherik Erik Bøgh Erik Bøgh http://www.wikidata.org/entity/Q3363323
183 boghnico Nicolaj Bøgh Nicolai Bøgh http://www.wikidata.org/entity/Q5600314
196 bothludv Ludvig Frederik Both Ludvig Both http://www.wikidata.org/entity/Q12325030
200 bournant Anton August Bournonville August Bournonville http://www.wikidata.org/entity/Q448812
203 brandcar Edvard Brandes Edvard Brandes http://www.wikidata.org/entity/Q347582
216 brickcar Carl Frederik Bricka Carl Frederik Bricka http://www.wikidata.org/entity/Q3357388
224 brorshan Hans Adolph Brorson Hans Adolph Brorson http://www.wikidata.org/entity/Q348003
270 christif Christian 8 Christian 8. http://www.wikidata.org/entity/Q157781
325 dreiefre Frederik Dreier Frederik Dreier http://www.wikidata.org/entity/Q1453103
333 dyrlufol Folmer Dyrlund Folmer Dyrlund http://www.wikidata.org/entity/Q19958411
362 elviusof Sofus Elvius Sofus Elvius http://www.wikidata.org/entity/Q12336307
367 engellau Laurids Engelstoft Laurids Engelstoft http://www.wikidata.org/entity/Q1800486
381 ersletho Thomas Hansen Erslew Thomas Hansen Erslew http://www.wikidata.org/entity/Q5718484
386 ewaldjoh Johannes Ewald Johannes Ewald http://www.wikidata.org/entity/Q553844
410 fibigjoh Johannes Henrik Tauber Fibiger Johannes Fibiger http://www.wikidata.org/entity/Q5729636
411 fibigmar Margrethe Fibiger Margrethe Fibiger http://www.wikidata.org/entity/Q26838558
464 geffraug Auguste Geffroy Auguste Geffroy http://www.wikidata.org/entity/Q563439
477 gjelleka Karl Gjellerup Karl Gjellerup http://www.wikidata.org/entity/Q131487
478 glasejos Joseph Glæser Joseph Glæser http://www.wikidata.org/entity/Q4994082
485 goldstho Thora Goldschmidt Thora Goldschmidt http://www.wikidata.org/entity/Q28867672
503 grimmjac Jacob Grimm Jacob Grimm http://www.wikidata.org/entity/Q6701
507 grundfre Frederik Lange Grundtvig Frederik Lange Grundtvig http://www.wikidata.org/entity/Q5773765
508 grundtvg N. F. S. Grundtvig N.F.S. Grundtvig http://www.wikidata.org/entity/Q331893
509 guaunval Valtýr Guðmundsson Valtýr Guðmundsson http://www.wikidata.org/entity/Q5775274
541 hamerrob Robert Hamerling Robert Hamerling http://www.wikidata.org/entity/Q79088
550 hammemas Martin Hammerich Martin Hammerich http://www.wikidata.org/entity/Q1903967
552 hansegoe Godfred Hansen Godfred Hansen http://www.wikidata.org/entity/Q12314080
553 hansegus Gustav Hansen Gustav Hansen http://www.wikidata.org/entity/Q28867666
562 hartmjoh Johann Peter Emilius Hartmann J.P.E. Hartmann http://www.wikidata.org/entity/Q507807
568 hauchcar Carsten Hauch Carsten Hauch http://www.wikidata.org/entity/Q688529
585 heibejoh Johan Ludvig Heiberg Johan Ludvig Heiberg http://www.wikidata.org/entity/Q402274
586 heibejoi Johanne Luise Heiberg Johanne Luise Heiberg http://www.wikidata.org/entity/Q272246
598 helwegl L. Helweg NaN NaN
600 hemminie Niels Hemmingsen Niels Hemmingsen http://www.wikidata.org/entity/Q665031
614 hiorthan Hans Rudolf Hiort-Lorenzen H.R. Hiort-Lorenzen http://www.wikidata.org/entity/Q5806573
627 hoffdhar Harald Høffding Harald Høffding http://www.wikidata.org/entity/Q703531
654 holsthao Hans Peter Holst Hans Peter Holst http://www.wikidata.org/entity/Q1581692
662 hovgaand Andreas Peter Hovgaard Andreas Peter Hovgaard http://www.wikidata.org/entity/Q5814641
670 humboale Alexander von Humboldt Alexander von Humboldt http://www.wikidata.org/entity/Q6694
671 hundrfer Ferdinand Emil Hundrup F.E. Hundrup http://www.wikidata.org/entity/Q12310837
684 ipsenpet Alfred Ipsen Alfred Ipsen http://www.wikidata.org/entity/Q12300997
690 jacobsjp J. P. Jacobsen J.P. Jacobsen http://www.wikidata.org/entity/Q370246
705 jensoand Andrew Jenson Andrew Jenson http://www.wikidata.org/entity/Q3631823
725 jorgenad A. D. Jørgensen Adolph Ditlev Jørgensen http://www.wikidata.org/entity/Q1960781
730 jungehec Hector Jungersen Hector F.E. Jungersen http://www.wikidata.org/entity/Q4534527
731 kaalunhv H. V. Kaalund H.V. Kaalund http://www.wikidata.org/entity/Q2362214
753 kennager George Kennan George Kennan http://www.wikidata.org/entity/Q1507714
765 kierkega Søren Kierkegaard Søren Kierkegaard http://www.wikidata.org/entity/Q6512
785 knigsjoh Johannes Peter Frederik Kønigsfeldt Johannes Peter Frederik Kønigsfeldt http://www.wikidata.org/entity/Q18176346
788 knudsjoh Johannes Knudsen Johannes Knudsen http://www.wikidata.org/entity/Q26839035
799 korolvla Vladimir Korolenko Vladimir Korolenko http://www.wikidata.org/entity/Q335064
833 langeolb Olaf Lange Olaf Lange http://www.wikidata.org/entity/Q28867652
836 larsetho Thøger Larsen Thøger Larsen http://www.wikidata.org/entity/Q323530
861 leoposve Svend Leopold Svend Leopold http://www.wikidata.org/entity/Q7800550
863 lermomic Michail Lermontov Michail J. Lermontov http://www.wikidata.org/entity/Q46599
877 liebefre Frederik Ludvig Liebenberg F.L. Liebenberg http://www.wikidata.org/entity/Q4994170
922 longfhen Henry Wadsworth Longfellow Henry Wadsworth Longfellow http://www.wikidata.org/entity/Q152513
997 molbechr Christian Molbech Christian Molbech http://www.wikidata.org/entity/Q3364467
999 mollenie Niels Møller Niels Møller http://www.wikidata.org/entity/Q12328860
1002 moltkeri Erik Moltke Erik Moltke http://www.wikidata.org/entity/Q3427586
1012 mortekar Karl Andreas Mortensen Karl Andreas Mortensen http://www.wikidata.org/entity/Q28867633
1027 nelsshar Haraldur Níelsson Haraldur Níelsson http://www.wikidata.org/entity/Q16427076
1033 nielscat Carl Nielsen Carl Nielsen http://www.wikidata.org/entity/Q205139
1068 notovnic Nicolas Notovitch Nicolas Notovitch http://www.wikidata.org/entity/Q2669366
1073 nyeruras Rasmus Nyerup Rasmus Nyerup http://www.wikidata.org/entity/Q3365201
1097 orstehan Hans Christian Ørsted H.C. Ørsted http://www.wikidata.org/entity/Q44412
1102 ostervil Vilhelm Østergaard Vilhelm Østergaard http://www.wikidata.org/entity/Q2674172
1111 paijkcar Carl Wilhelm Paijkull Carl Wilhelm Paijkull http://www.wikidata.org/entity/Q6159373
1120 panumhor Hortense Panum Hortense Panum http://www.wikidata.org/entity/Q4971830
1128 pederchr Christiern Pedersen Christiern Pedersen http://www.wikidata.org/entity/Q219010
1132 peschand Andreas Peschcke Køedt Andreas Peschcke Køedt http://www.wikidata.org/entity/Q3018102
1134 petercle Clemens Petersen Clemens Petersen http://www.wikidata.org/entity/Q5131269
1144 plougcar Carl Ploug Carl Ploug http://www.wikidata.org/entity/Q347860
1157 rambaalf Alfred Rambaud Alfred Nicolas Rambaud http://www.wikidata.org/entity/Q163159
1164 rasmuvim Vilhelm Rasmussen Vilhelm Rasmussen http://www.wikidata.org/entity/Q16650181
1170 reinhchr Christian Emanuel Frits Reinhardt Christian Emanuel Fritz Reinhardt http://www.wikidata.org/entity/Q28867627
1183 richachr Christian Richardt Christian Richardt http://www.wikidata.org/entity/Q1081576
1197 romniels Niels Christian Rom N.C. Rom http://www.wikidata.org/entity/Q12328158
1209 rosenpal Palle Rosenkrantz Palle Rosenkrantz http://www.wikidata.org/entity/Q4575420
1215 rostrsof Sofie Rostrup Sofie Rostrup http://www.wikidata.org/entity/Q4975658
1250 saxo Saxo Grammaticus Saxo Grammaticus http://www.wikidata.org/entity/Q106837
1275 schwaath Athalia Schwartz Athalia Schwartz http://www.wikidata.org/entity/Q4977650
1276 schwaher Herman Heinrich Louis Schwanenflügel Herman Heinrich Louis Schwanenflügel http://www.wikidata.org/entity/Q12316589
1310 skjoljoh Johan Skjoldborg Johan Skjoldborg http://www.wikidata.org/entity/Q1490327
1328 sorencth C. Th. Sørensen C.Th. Sørensen http://www.wikidata.org/entity/Q26838242
1349 steenjap Japetus Steenstrup Japetus Steenstrup http://www.wikidata.org/entity/Q701104
1350 steenjoh Johannes Steenstrup Johannes Steenstrup http://www.wikidata.org/entity/Q6187907
1364 stockvig Viggo Stockfleth H.V. Stockfleth http://www.wikidata.org/entity/Q16063899
1376 strunado Adolph Strunk Adolph Strunk http://www.wikidata.org/entity/Q12300596
1377 strupjoh Johannes Østrup Johannes Østrup http://www.wikidata.org/entity/Q6258275
1422 thomsaug August Thomsen Carl August Thomsen http://www.wikidata.org/entity/Q27204521
1431 thrigsre Søren Bloch Thrige Søren Bloch Thrige http://www.wikidata.org/entity/Q12338494
1452 torvetor Tormod Torvesen Thormod Torfæus http://www.wikidata.org/entity/Q335614
1454 trapjp J. P. Trap J.P. Trap http://www.wikidata.org/entity/Q6214839
1455 troeltrf Tr. Fr. Troels-Lund Troels Troels-Lund http://www.wikidata.org/entity/Q3358346
1476 vahljens Jens Vahl Jens Vahl http://www.wikidata.org/entity/Q6221045
1482 vedelval Valdemar Vedel Valdemar Vedel http://www.wikidata.org/entity/Q3434171
1496 wadgusta Gustav Ludvig Wad Gustav Ludvig Wad http://www.wikidata.org/entity/Q761036
1547 weysecri Cristoph Ernst Frederik Weyse C.E.F. Weyse http://www.wikidata.org/entity/Q707924
1556 widmakar Karen Widman Karen Widman http://www.wikidata.org/entity/Q26838176
1559 wiedgust Gustav Wied Gustav Wied http://www.wikidata.org/entity/Q1556531
1572 winkefre Fr. Winkel Horn Fr. Winkel Horn http://www.wikidata.org/entity/Q3076966
1574 winthchr Christian Winther Christian Winther http://www.wikidata.org/entity/Q981722
1583 worsaaej Jens Jacob Asmussen Worsaae J.J.A. Worsaae http://www.wikidata.org/entity/Q962271
1594 zahlevil Vilhelmine Zahle Vilhelmine Zahle http://www.wikidata.org/entity/Q16065291
1595 zeilathe Theodor Zeilau Theodor Zeilau http://www.wikidata.org/entity/Q12343090

In [ ]: