We are conducting a Systematic Literature Review and we would like to know how to merge the different results in a unique database as to easily recognise duplicates. Merging excel files seems not to be an immediate procedure.
Matteo, have you tried to import your results into a reference manager (i.e., EndNote or Mendeley)? Those softwares provide specific customizable identification of duplicate records.
Dear Arthur,
thank you a lot for your reply! I’ll try as soon as possible, so I can give you a feedback.
EndNote is the best software to do this, you can group the references together or segregate them, you can also perform title and abstract screening, referencing, searches and so on so forth, its worth a try and its very user friendly....
Thank you Theophilus! In fact, Mendeley loses some data within the import-export; I’ll try with Endonte.
For your purpose of systematic literature review, you can use Bibliometrix, R package. You could merge the Wos and Scopus searches, but you should do a data cleaning procedure. I suggest to export the resulting dataframe to Excel and order by DOI to find duplicates.
Matteo Cristofaro , hi ! Can you give some feedback about which software: Mendeley or EndNote did you prefer to merge the data and later on execute your SLR ? Thanx !
Roberto Antonio Martins can I please ask you how did you manage to do that in Bibliometrix? I would like to integrate publications from WOS and Scopus for analyzing them through Biblioshiny
Canio Forliano I suggest my video https://youtu.be/QGFp6rf3hME. I speak in Portuguese, but I believe the automatic translation works.
Roberto Antonio Martins Thank you so much! I will take a look at the video
- Badges
- Science topic