44 lines
1.8 KiB
Python
44 lines
1.8 KiB
Python
import csv
|
|
import re
|
|
import sys
|
|
sys.stdout.reconfigure(encoding='utf-8')
|
|
|
|
scimago_data = {}
|
|
with open(r'd:\Website\Life OS\Oppurtunity\Google Scholar Data\Assets\scimagojr 2025.csv', 'r', encoding='utf-8-sig') as f:
|
|
reader = csv.DictReader(f, delimiter=';')
|
|
for row in reader:
|
|
title = row['Title'].strip().lower()
|
|
scimago_data[title] = {
|
|
'Title': row['Title'],
|
|
'Quartile': row.get('SJR Best Quartile', ''),
|
|
'H-index': row.get('H index', ''),
|
|
'SJR': row.get('SJR', ''),
|
|
'Categories': row.get('Categories', ''),
|
|
'Areas': row.get('Areas', ''),
|
|
'Country': row.get('Country', '')
|
|
}
|
|
|
|
with open(r'd:\Website\Life OS\Oppurtunity\Google Scholar Data\river_erosion_papers.csv', 'r', encoding='utf-8') as f:
|
|
reader = csv.DictReader(f)
|
|
for row in reader:
|
|
journal_scholar = row.get('Journal/Venue (Scholar)', '').strip()
|
|
search_name = journal_scholar.strip('… ').lower()
|
|
|
|
match = scimago_data.get(search_name)
|
|
|
|
if not match:
|
|
for sjr_title, sjr_info in scimago_data.items():
|
|
if search_name == sjr_title or (len(search_name) > 8 and search_name in sjr_title):
|
|
match = sjr_info
|
|
break
|
|
|
|
print(f"Paper: {row.get('Title', '')[:40]}...")
|
|
print(f"Journal from Scholar: {journal_scholar}")
|
|
if match:
|
|
print(f" [MATCHED AS]: {match['Title']}")
|
|
print(f" -> Quartile: {match['Quartile']} | H-index: {match['H-index']} | SJR: {match['SJR']} | Country: {match['Country']}")
|
|
print(f" -> Areas: {match['Areas']}")
|
|
else:
|
|
print(" [NOT FOUND] in SCImago")
|
|
print('-'*60)
|