How to merge Scopus and Web of Science (WoS) databases to use on Bibliometrix or Mendeley

Описание: This video shows two approaches to merging Scopus and Web of Science (WoS) databases. The first one generates an xlsx file without duplicates to be loaded on Bibliometrix. The second is simpler and generates a bib file without duplicates to be uploaded on Mendeley (or any other repository that manages bib files).

0:00 Introduction
0:23 Downloading R and RStudio
0:51 Exporting bib file from Scopus
2:15 Exporting bib file from Web of Science (WoS)
3:53 Merging bib files to generate an xlsx file using RStudio
7:02 Uploading xlsx file in Biblioshiny (Bibliometrix's interface)
9:56 Merging bib files to generate a bib file using BibTex Tidy
12:27 Acknowledgment

Link to download R: https://cran.r-project.org/
Link to download RStudio: https://www.rstudio.com/products/rstu...
Link to BibTex Tidy: https://flamingtempura.github.io/bibt...

Code to be used in RStudio to generate a xlsx file without duplicates:

install.packages("bibliometrix") # if you don't have it installed
setwd("/home/rafael/merge-scopus-wos/bib")
library(bibliometrix)
S = convert2df("scopus.bib", dbsource = "scopus", format = "bibtex")
W = convert2df("wos.bib", dbsource = "isi", format = "bibtex")
Database = mergeDbSources(S, W, remove.duplicated = TRUE)
dim(Database)
install.packages("openxlsx") # if you don't have it installed
library(openxlsx)
write.xlsx(Database, file = "database.xlsx")

Tip 1: When using Bibliometrix, some graphics may not be generated due to "duplicate row.names are not allowed" error. It occurs when the last column (SR) of the xlsx database file contains non-unique values. This can happen if the mergeDbSources method in the R code fails to eliminate some duplicates (because titles of the same work sometimes present subtle differences and therefore are not eliminated).

To prevent this issue, you should edit the xlsx file after it's created by following these steps:

1. Remove any duplicate values in the DOI column (DI).
2. Remove any duplicate values in the SR column.
3. Ensure that the SR column has no missing values.

An easy way to accomplish these steps is to use a color filter in Excel. Go to Home - Conditional Formatting - Highlight Cells Rules - Duplicate Values and apply the filter to the DI column, and later to the SR column. Then, manually delete any duplicate rows that are highlighted in the filtered view. By following these steps, you can avoid the "duplicate row.names are not allowed" error and ensure that your Bibliometrix analysis runs smoothly.

Tip 2: When merging the bib files with Bibtex Tidy, choose to merge only based on "Matching DOIs". Using "Matching Keys" may delete different works of the same authors just because they share the same key.