Python Code Designed for Subject Translation for SciFree's Journal Search Tool (JST)

<p>SciFree's Journal Search Tool (JST) enables researchers and authors to seach for journals that are part of University Libraries' Open Access agreements. The tool indicates the corresponding Article Processing Charge (APC) waiver or discount associated with each journal. Users may search by journal title, publisher, ISSN, or subject terms. Because subject terms were only offered in English, it has been considered to provide them in French to accomodate uOttawa's francophone research community.</p>
<p>The Subject Translation Code written in Python has been designed and developped to translate English subject terms into French directly within the journal lists (as .xslx files). Additionally, when there is no subject term in the Excel files, the script would enrich them while using Scopus API and then translate the terms into French. Scopus, a scientific abstract and citation database, provides the corresponding subject term associated with the journal's ISSN. Because the code is using both DeepL and Scopus, corresponding API keys would need to be requested by each administrator and added within the Python code. Once the code has processed the journals lists, the latter are then ingested and uploaded in SciFree's Journal Search Tool (JST). The result is twofold: better discoverability for journals and increased search capabilities for end-users</p>
<p>
Instructions are provided in the ReadMe file. An Excel file template is also provided.</p>