Fennica Authors in Kanto
Source:vignettes/articles/fennica_authors_kanto.Rmd
fennica_authors_kanto.RmdIntroduction
This document provides an example usage of the search_fennica_authors() function, which links authors from the Fennica catalog to their respective Kanto IDs in Finto’s ‘Finaf’ vocabulary. The function helps enrich metadata for bibliographic records.
suppressMessages(suppressWarnings({
if (!requireNamespace("devtools", quietly = TRUE)) {
install.packages("devtools", quiet = TRUE)
}
devtools::install_github("fennicahub/finto", quiet = TRUE)
}))After downloading the package we select the columns id,
Title, Author, Name_100a
Code_1000 Code_7000
Code_7001.
library(finna)
library(finto)
library(dplyr)
library(stringr)
data("fennica_subset",package = "finna")
fennica_subset <- tail(fennica_subset)
knitr::kable(fennica_subset,caption = "few selected fennica data")| ID | Author | Name_100a | Code_1000 | Code_7000 | Code_7001 |
|---|---|---|---|---|---|
| 000864524 | 00000cam a2200445 i 4500 | Reuter, Enzio, | (FIN11)000080453 | NA | NA |
| 000864525 | 00000cam a2200445 i 4500 | Wendt, Georg von, | (FIN11)000084103 | NA | NA |
| 000864526 | 00000cam a2200421 i 4500 | Linnaniemi, Walter L. | NA | NA | NA |
| 000864528 | 00000cam a2200925 i 4500 | NA | NA | Cronvall, Timo. | NA |
| 000864529 | 00000cam a2201177 i 4500 | Mechelin, L., | (FIN11)000090610 | NA | NA |
| 000864530 | 00000cam a2200769 i 4500 | NA | NA | Kuronen, Soili.|Kainulainen, Juhana, | (FIN11)000091625 |
We used the two main columns we used are Code_1000 and
Code_7001 which contain the asteriID digits
and extract those digits and use them to fetch information from
finto/kanto. The columns were renamed as they are originally MARC 21 format
for bibliographical data which represent fields 100/0
and 700/o So the processed output of the retrieved
finto/kanto data can be found using the provided code below. It provides
extra many columns including the profession related information.
authors_df <- finto::get_kanto(fennica_subset)
knitr::kable(authors_df, caption = "Authors Data Frame from kanto")| asteriID | uri | type | prefLabel | altLabel | hiddenLabel | broader | narrower | related | definition | scopeNote | example | historyNote | editorialNote | changeNote | profession | birthDate | deathDate | exactMatch | closeMatch | inScheme | created | modified | profession_metadata_profession_uri | profession_metadata_profession_prefLabel_en | profession_metadata_profession_prefLabel_fi | profession_metadata_profession_prefLabel_sv | profession_metadata_profession_entryTerms | profession_metadata_profession_belongsToGroup | profession_metadata_profession_broader | profession_metadata_profession_narrower | profession_metadata_profession_related | profession_metadata_profession_created | profession_metadata_profession_modified | profession_metadata_profession_closeMatch | profession_metadata_profession_source | profession_metadata_profession_downloadFormats | profession_metadata_uri | profession_labels |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 000080453 | http://urn.fi/URN:NBN:fi:au:finaf:000080453 | http://rdaregistry.info/Elements/c/C10004, skos:Concept | Reuter, Enzio, 1867-1951 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | http://urn.fi/URN:NBN:fi:au:mts:m2676 | 1867 | 1951 | NA | http://urn.fi/urn:nbn:fi:sks-kbg-006353 | http://urn.fi/URN:NBN:fi:au:finaf: | 1997-12-17 | 2023-04-20T12:31:37 | http://urn.fi/URN:NBN:fi:au:mts:m2676 | biologist | biologi | biolog | biologit, biologer, biologists | http://urn.fi/URN:NBN:fi:au:mts: | NA | NA | NA | 2018-11-01 | 2024-08-27 | http://www.yso.fi/onto/yso/p16443 | Kansallinen RDA-termi, ALLFO-term, Nationell RDA-term, YSO-termi | RDF/XML, TURTLE, JSON-LD | NA | NA |
| 000084103 | http://urn.fi/URN:NBN:fi:au:finaf:000084103 | http://rdaregistry.info/Elements/c/C10004, skos:Concept | Wendt, Georg von, 1876-1954 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | http://urn.fi/URN:NBN:fi:au:mts:m3357 | 1876 | 1954 | NA | http://urn.fi/urn:nbn:fi:sks-kbg-006521 | http://urn.fi/URN:NBN:fi:au:finaf: | 1998-05-15 | 2023-04-20T12:31:45 | http://urn.fi/URN:NBN:fi:au:mts:m3357 | physiologist | fysiologi | fysiolog | fysiologer, physiologists, fysiologit | http://urn.fi/URN:NBN:fi:au:mts: | NA | NA | NA | 2018-11-01 | 2024-08-27 | http://www.yso.fi/onto/yso/p20543 | ALLFO-term, YSO-termi, Nationell RDA-term, Kansallinen RDA-termi | RDF/XML, TURTLE, JSON-LD | NA | NA |
| NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA, NA |
| NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA, NA |
| 000090610 | http://urn.fi/URN:NBN:fi:au:finaf:000090610 | skos:Concept, http://rdaregistry.info/Elements/c/C10004 | Mechelin, L., 1839-1914 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | http://urn.fi/URN:NBN:fi:au:mts:m2311, http://urn.fi/URN:NBN:fi:au:mts:m2780 | 1839 | 1914 | NA | http://urn.fi/urn:nbn:fi:sks-kbg-003553 | http://urn.fi/URN:NBN:fi:au:finaf: | 1998-07-22 | 2023-04-20T12:29:54 | http://urn.fi/URN:NBN:fi:au:mts:m2311 | social politician | sosiaalipoliitikko | socialpolitiker | sosiaalipoliitikot, social politicians | http://urn.fi/URN:NBN:fi:au:mts: | NA | NA | NA | 2018-11-01 | 2024-08-27 | http://www.yso.fi/onto/yso/p18723 | YSO-termi, ALLFO-term, Kansallinen RDA-termi, Nationell RDA-term | RDF/XML, TURTLE, JSON-LD | NA | NA, NA |
| 000090610 | http://urn.fi/URN:NBN:fi:au:finaf:000090610 | skos:Concept, http://rdaregistry.info/Elements/c/C10004 | Mechelin, L., 1839-1914 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | http://urn.fi/URN:NBN:fi:au:mts:m2311, http://urn.fi/URN:NBN:fi:au:mts:m2780 | 1839 | 1914 | NA | http://urn.fi/urn:nbn:fi:sks-kbg-003553 | http://urn.fi/URN:NBN:fi:au:finaf: | 1998-07-22 | 2023-04-20T12:29:54 | http://urn.fi/URN:NBN:fi:au:mts:m2780 | lawyer | juristi | jurist | lakinaiset, jurister, lawyers, lakimiehet, juristit | http://urn.fi/URN:NBN:fi:au:mts: | NA | NA | NA | 2018-11-01 | 2024-08-27 | http://www.yso.fi/onto/yso/p2496 | Nationell RDA-term, ALLFO-term, Kansallinen RDA-termi, YSO-termi | RDF/XML, TURTLE, JSON-LD | NA | NA, NA |
| 000091625 | http://urn.fi/URN:NBN:fi:au:finaf:000091625 | http://rdaregistry.info/Elements/c/C10004, skos:Concept | Kainulainen, Juhana, 1788-1847 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | http://urn.fi/URN:NBN:fi:au:mts:m3061 | 1788 | 1847 | NA | NA | http://urn.fi/URN:NBN:fi:au:finaf: | 1997-10-21 | 2022-09-02T19:14:58 | http://urn.fi/URN:NBN:fi:au:mts:m3061 | rune singer | runonlaulaja | runosångare | rune singers, Karelian folk singers, runonlaulajat | http://urn.fi/URN:NBN:fi:au:mts: | http://urn.fi/URN:NBN:fi:au:mts:m2673 | NA | NA | 2018-11-01 | 2024-08-27 | http://www.yso.fi/onto/yso/p19490 | Nationell RDA-term, ALLFO-term, Kansallinen RDA-termi, YSO-termi | RDF/XML, TURTLE, JSON-LD | NA | NA |
Integrating to fennica
To integrate the processed KANTO author data with your existing Fennica dataset, you can follow these steps:
Process the KANTO Data: Use the
get_kantofunction to retrieve and process the author information from the KANTO database.Merge with Fennica Data: Combine the processed KANTO data with your Fennica dataset based on a common identifier, such as
asteriID.
Here’s how you can achieve this in R:
# Assuming fennica_subset has columns 'Code_1000' and 'Code_7001'
fennica_subset <- fennica_subset %>%
mutate(
asteriID_1000 = str_extract(Code_1000, "\\d{9}"),
asteriID_7001 = str_extract(Code_7001, "\\d{9}"),
asteriID = coalesce(asteriID_1000, asteriID_7001)
) %>%
select(-asteriID_1000, -asteriID_7001) # Remove intermediate columns if not needed
# Merge the processed KANTO data with the Fennica dataset
# Ensure 'asteriID' is the common column for merging
merged_data <- dplyr::left_join(fennica_subset, authors_df, by = "asteriID")
# View the merged dataset
knitr::kable(merged_data, caption = "Merged fennica kanto")| ID | Author | Name_100a | Code_1000 | Code_7000 | Code_7001 | asteriID | uri | type | prefLabel | altLabel | hiddenLabel | broader | narrower | related | definition | scopeNote | example | historyNote | editorialNote | changeNote | profession | birthDate | deathDate | exactMatch | closeMatch | inScheme | created | modified | profession_metadata_profession_uri | profession_metadata_profession_prefLabel_en | profession_metadata_profession_prefLabel_fi | profession_metadata_profession_prefLabel_sv | profession_metadata_profession_entryTerms | profession_metadata_profession_belongsToGroup | profession_metadata_profession_broader | profession_metadata_profession_narrower | profession_metadata_profession_related | profession_metadata_profession_created | profession_metadata_profession_modified | profession_metadata_profession_closeMatch | profession_metadata_profession_source | profession_metadata_profession_downloadFormats | profession_metadata_uri | profession_labels |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 000864524 | 00000cam a2200445 i 4500 | Reuter, Enzio, | (FIN11)000080453 | NA | NA | 000080453 | http://urn.fi/URN:NBN:fi:au:finaf:000080453 | http://rdaregistry.info/Elements/c/C10004, skos:Concept | Reuter, Enzio, 1867-1951 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | http://urn.fi/URN:NBN:fi:au:mts:m2676 | 1867 | 1951 | NA | http://urn.fi/urn:nbn:fi:sks-kbg-006353 | http://urn.fi/URN:NBN:fi:au:finaf: | 1997-12-17 | 2023-04-20T12:31:37 | http://urn.fi/URN:NBN:fi:au:mts:m2676 | biologist | biologi | biolog | biologit, biologer, biologists | http://urn.fi/URN:NBN:fi:au:mts: | NA | NA | NA | 2018-11-01 | 2024-08-27 | http://www.yso.fi/onto/yso/p16443 | Kansallinen RDA-termi, ALLFO-term, Nationell RDA-term, YSO-termi | RDF/XML, TURTLE, JSON-LD | NA | NA |
| 000864525 | 00000cam a2200445 i 4500 | Wendt, Georg von, | (FIN11)000084103 | NA | NA | 000084103 | http://urn.fi/URN:NBN:fi:au:finaf:000084103 | http://rdaregistry.info/Elements/c/C10004, skos:Concept | Wendt, Georg von, 1876-1954 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | http://urn.fi/URN:NBN:fi:au:mts:m3357 | 1876 | 1954 | NA | http://urn.fi/urn:nbn:fi:sks-kbg-006521 | http://urn.fi/URN:NBN:fi:au:finaf: | 1998-05-15 | 2023-04-20T12:31:45 | http://urn.fi/URN:NBN:fi:au:mts:m3357 | physiologist | fysiologi | fysiolog | fysiologer, physiologists, fysiologit | http://urn.fi/URN:NBN:fi:au:mts: | NA | NA | NA | 2018-11-01 | 2024-08-27 | http://www.yso.fi/onto/yso/p20543 | ALLFO-term, YSO-termi, Nationell RDA-term, Kansallinen RDA-termi | RDF/XML, TURTLE, JSON-LD | NA | NA |
| 000864526 | 00000cam a2200421 i 4500 | Linnaniemi, Walter L. | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA, NA |
| 000864526 | 00000cam a2200421 i 4500 | Linnaniemi, Walter L. | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA, NA |
| 000864528 | 00000cam a2200925 i 4500 | NA | NA | Cronvall, Timo. | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA, NA |
| 000864528 | 00000cam a2200925 i 4500 | NA | NA | Cronvall, Timo. | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA, NA |
| 000864529 | 00000cam a2201177 i 4500 | Mechelin, L., | (FIN11)000090610 | NA | NA | 000090610 | http://urn.fi/URN:NBN:fi:au:finaf:000090610 | skos:Concept, http://rdaregistry.info/Elements/c/C10004 | Mechelin, L., 1839-1914 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | http://urn.fi/URN:NBN:fi:au:mts:m2311, http://urn.fi/URN:NBN:fi:au:mts:m2780 | 1839 | 1914 | NA | http://urn.fi/urn:nbn:fi:sks-kbg-003553 | http://urn.fi/URN:NBN:fi:au:finaf: | 1998-07-22 | 2023-04-20T12:29:54 | http://urn.fi/URN:NBN:fi:au:mts:m2311 | social politician | sosiaalipoliitikko | socialpolitiker | sosiaalipoliitikot, social politicians | http://urn.fi/URN:NBN:fi:au:mts: | NA | NA | NA | 2018-11-01 | 2024-08-27 | http://www.yso.fi/onto/yso/p18723 | YSO-termi, ALLFO-term, Kansallinen RDA-termi, Nationell RDA-term | RDF/XML, TURTLE, JSON-LD | NA | NA, NA |
| 000864529 | 00000cam a2201177 i 4500 | Mechelin, L., | (FIN11)000090610 | NA | NA | 000090610 | http://urn.fi/URN:NBN:fi:au:finaf:000090610 | skos:Concept, http://rdaregistry.info/Elements/c/C10004 | Mechelin, L., 1839-1914 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | http://urn.fi/URN:NBN:fi:au:mts:m2311, http://urn.fi/URN:NBN:fi:au:mts:m2780 | 1839 | 1914 | NA | http://urn.fi/urn:nbn:fi:sks-kbg-003553 | http://urn.fi/URN:NBN:fi:au:finaf: | 1998-07-22 | 2023-04-20T12:29:54 | http://urn.fi/URN:NBN:fi:au:mts:m2780 | lawyer | juristi | jurist | lakinaiset, jurister, lawyers, lakimiehet, juristit | http://urn.fi/URN:NBN:fi:au:mts: | NA | NA | NA | 2018-11-01 | 2024-08-27 | http://www.yso.fi/onto/yso/p2496 | Nationell RDA-term, ALLFO-term, Kansallinen RDA-termi, YSO-termi | RDF/XML, TURTLE, JSON-LD | NA | NA, NA |
| 000864530 | 00000cam a2200769 i 4500 | NA | NA | Kuronen, Soili.|Kainulainen, Juhana, | (FIN11)000091625 | 000091625 | http://urn.fi/URN:NBN:fi:au:finaf:000091625 | http://rdaregistry.info/Elements/c/C10004, skos:Concept | Kainulainen, Juhana, 1788-1847 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | http://urn.fi/URN:NBN:fi:au:mts:m3061 | 1788 | 1847 | NA | NA | http://urn.fi/URN:NBN:fi:au:finaf: | 1997-10-21 | 2022-09-02T19:14:58 | http://urn.fi/URN:NBN:fi:au:mts:m3061 | rune singer | runonlaulaja | runosångare | rune singers, Karelian folk singers, runonlaulajat | http://urn.fi/URN:NBN:fi:au:mts: | http://urn.fi/URN:NBN:fi:au:mts:m2673 | NA | NA | 2018-11-01 | 2024-08-27 | http://www.yso.fi/onto/yso/p19490 | Nationell RDA-term, ALLFO-term, Kansallinen RDA-termi, YSO-termi | RDF/XML, TURTLE, JSON-LD | NA | NA |
Explanation:
Processing KANTO Data: The
get_kantofunction extractsasteriIDs from thefennica_dataand fetches corresponding RDF data from the Finto Skosmos API. It returns a cleaned tibble with the retrieved data, including profession labels.Merging Datasets: The
dplyr::left_joinfunction merges thefennica_datawith thekanto_authorsdata on theasteriIDcolumn. This ensures that all records fromfennica_dataare retained, and matching author information fromkanto_authorsis added.
Note: Ensure that both datasets have the
asteriID column formatted consistently (e.g., as character
strings) to avoid mismatches during the merge.
By following these steps, you can enrich your Fennica dataset with detailed author information from the KANTO database, facilitating more comprehensive analyses and insights.