Hi everyone, I am trying to understand if I can automatize a very boring task, and I am not finding anything that can work just yet.
I have a list of scientific paper in an excel file. This file contains a lot of information such as doi (so link to the paper), title, author list etc.
I also have the PDF file of all papers in the list.
I want to have an output file in excel format with these columns:
Author name Affiliation (not present in the starting file, it needs to be extracted from the PDF or from the website reachable with the doi) Country (from the affiliation) Title of the paper Doi
I would then like to sort by author name and remove double names (with the same affiliation) addi