Tools to enrich PANGAEA's institution table with ROR identifiers

Uses ROR APIs provided by ROR

IPYNB FILES

• Query_match.ipynb - code used for query matching
• Aff_match.ipynb - code used for affiliation matching
• Aff_match_num_params.ipynb - calculation of number of parameters used in affiliation matching

(Output files - not yet included)

CSV FILES

• institutions_Affil_m.csv - result of affiliation matching
• institutions_Affil_m_aff_list.csv result of affiliation matching + a column with a list of affiliation terms "aff_list"

Input CSV file contains initial columns:

• id_institution
• abbreviation
• name
• city
• contact
• country
• fax
• phone
• state
• street
• uri
• uri_semantic
• id_institution_type
• id_user_created

After matching the following columns are added:

• aROR_id: ROR_id received by affiliation matching
• Nparams: Number of parameters used for creation of affiliation string
• Aff_list: List of affiliation parameters
• chosen: API binary indicator (based on score)
• score: API matching confidence score, with values between 0 and 1 (inclusive)
• matching_type: type of matching algorithm applied
• substring: substring of the affiliation field, to which organization was matched
• ROR_name: Name from the ROR database