Hi Rafael Thanks for a wonderful tutorial. It was really awesome. The best part of this post is the two tips. Two thumbs up!!! I would suggest an alternate way to remove duplicates from excel sheet. 1. Select the column in which you want to find duplicates. 2. Go to the "Data" tab in the Excel ribbon. 3. Click on the "Remove Duplicates" button in the "Data Tools" group. 4. A dialog box will appear with the column(s) selected for duplicate removal. Make sure the correct column is selected. Also make sure you expand the selection to select all columns in the excel sheet. 5. Click the "OK" button. Excel will remove any duplicate values from the selected column, and you will be left with only unique values. In my case, I was able to remove 20 duplicates from an initial 3439 rows!! After that Biblioshiny worked without the "duplicate row.names are not allowed" error. So again a big big thanks for your guidance. Keep up the good work!!!
Thanks! Because WoS only generates a maximum of 500 entries per datafile if you export full record and references, sometimes you end with more than one exported file from WoS. The convert2df code you kindly shared here seems to work for one file at a time and I had two, so I first used an editor (BibDesk) to merge the two .bib files into one, and then used your convert2df code. Everything worked just fine, thanks!
Hi Rafael, Many thanks for the wonderful video. I want to add some more records (not identified by Scopus or WoS) to the final merged Excel file. Is there an easy way of adding them?
thank you, when i try to use bibtex-tidy, i got: There's a problem with the bibtex Syntax Error on line 31606 column 14 The entry key cannot contain whitespace. how could I correct this?
Thanks for this video! After successfully merging a WOS and SCOPUS database and removing a large number of duplicates, I still receive the error message "double row names". Any ideas?
Hello Thank you very much for the video. I am getting the following error. I wonder what I should do? I would really appreciate if you can help Error in mergeDbSources(wos, scopus_1, scopus_2, remove.duplicated = T): could not find function "mergeDbSources"
Good morning, first of all thank you very much because thanks to your video I was able to merge and generate a single database in wos and scopus. The only thing is that I am getting an error in Biblioshin and the graphic "Countries' Collaboration World Map" is this normal? I have followed your advice to manually remove duplicates that were left in excel generated but that graph still does not work for me, thanks in advance.
Could we read IEEE bib file. I used convert2df with dbsource = "scopus", and I got an error: Missing fields: AU DE ID C1 CR Error in data.frame(..., check.names = FALSE) : arguments imply differing number of rows: 0, 55
Hi @Rafael, The method you tell work well, but i need information, I have downloaded file from scopus and WOS by clicking contain all information. when i have merged file and opened it with bibliometrix then i am getting error "Number of cited references" and Cited references completely missing. Can you help me in this
I am receiving this error despite selecting all fields in Scopus_ Missing fields: AU DE ID C1 CR Error in data.frame(..., check.names = FALSE) : arguments imply differing number of rows: 0, 2583 How to resolve it?
Hi Claudia, I believe there is no widespread method for merging these three specific bases. You may need to develop a specific code to combine them. However, I think it doesn't make much sense since Scopus encompasses (with title, abstract and other metadata) most of the articles present in Science Direct (where the full texts are available).
Hi Rafael
Thanks for a wonderful tutorial. It was really awesome. The best part of this post is the two tips. Two thumbs up!!!
I would suggest an alternate way to remove duplicates from excel sheet.
1. Select the column in which you want to find duplicates.
2. Go to the "Data" tab in the Excel ribbon.
3. Click on the "Remove Duplicates" button in the "Data Tools" group.
4. A dialog box will appear with the column(s) selected for duplicate removal. Make sure the correct column is selected. Also make sure you expand the selection to select all columns in the excel sheet.
5. Click the "OK" button.
Excel will remove any duplicate values from the selected column, and you will be left with only unique values.
In my case, I was able to remove 20 duplicates from an initial 3439 rows!!
After that Biblioshiny worked without the "duplicate row.names are not allowed" error.
So again a big big thanks for your guidance. Keep up the good work!!!
Thanks!
Because WoS only generates a maximum of 500 entries per datafile if you export full record and references, sometimes you end with more than one exported file from WoS. The convert2df code you kindly shared here seems to work for one file at a time and I had two, so I first used an editor (BibDesk) to merge the two .bib files into one, and then used your convert2df code. Everything worked just fine, thanks!
You just saved my life bro, thanks! Se for BR: valeu!
thanks rafael! i tried many other tutorials, but this was the only that worked
Thank you so much for providing such a clear solution
Thank you Rafael!!! super helpful
Crystally clear! You saved my life, my friend.
I am trying to merge the Scopus and Dimensions databases, is this the same procedure? Thank you very much.
thank you , Rafael, however, the combined excel file had an "na" error and so I was unable to use it in rstudio or vosviewer.
Hi Rafael, Many thanks for the wonderful video. I want to add some more records (not identified by Scopus or WoS) to the final merged Excel file. Is there an easy way of adding them?
same question
Very clear and straigth to the point. Muito obrigado pela grande ajuda, Rafael!
thank you, when i try to use bibtex-tidy, i got: There's a problem with the bibtex
Syntax Error on line 31606 column 14
The entry key cannot contain whitespace. how could I correct this?
Thanks for this video! After successfully merging a WOS and SCOPUS database and removing a large number of duplicates, I still receive the error message "double row names". Any ideas?
Hi, I have the same problem, did you manage to solve it?
I am also having the same problem.
Check the tips in the description.
Sir After merging i get the data in capital letters only and also space between them also disturbed. Please help.
Hello
Thank you very much for the video.
I am getting the following error.
I wonder what I should do?
I would really appreciate if you can help
Error in mergeDbSources(wos, scopus_1, scopus_2, remove.duplicated = T):
could not find function "mergeDbSources"
Hello, can help me to get publications from WoS?
Good morning, first of all thank you very much because thanks to your video I was able to merge and generate a single database in wos and scopus. The only thing is that I am getting an error in Biblioshin and the graphic "Countries' Collaboration World Map" is this normal? I have followed your advice to manually remove duplicates that were left in excel generated but that graph still does not work for me, thanks in advance.
Could we read IEEE bib file. I used convert2df with dbsource = "scopus", and I got an error:
Missing fields: AU DE ID C1 CR
Error in data.frame(..., check.names = FALSE) :
arguments imply differing number of rows: 0, 55
Thank you very much. I'll try
What If I want to merge it to a bib file instead of a xlsx file ?
Thank you so much, Rafael Queiroz. It's very obvious and helpful for me in carrying on MSc dissertation.
the coding part is confusing. can you simplify the process more?
Hi @Rafael,
The method you tell work well, but i need information, I have downloaded file from scopus and WOS by clicking contain all information. when i have merged file and opened it with bibliometrix then i am getting error "Number of cited references" and Cited references completely missing. Can you help me in this
Same problem
I am receiving this error despite selecting all fields in Scopus_
Missing fields: AU DE ID C1 CR
Error in data.frame(..., check.names = FALSE) :
arguments imply differing number of rows: 0, 2583
How to resolve it?
same problem
Thank you!
How to merge PubMed and WoS data?
Is it possible to download high-resolution or vectorial images from the Biblioshiny interface?
Yes, you can set the dpi up to 600 in some exports.
❤
thanks! it is possible to merge a Wos, Scopus and Science direct databases to upload it to bibliometrix?
Hi Claudia,
I believe there is no widespread method for merging these three specific bases. You may need to develop a specific code to combine them. However, I think it doesn't make much sense since Scopus encompasses (with title, abstract and other metadata) most of the articles present in Science Direct (where the full texts are available).
Is it possible to share this code?
perfact🤩🤩
Hi
Can I use it in vosviewer?
Is there a way to get a list of the removed duplicates? thank you for the video!
Hi, I have the same problem, did you manage to solve it?
@@victorcarlosarruda any slotutions please !!!
thank you so much
Hi
Am getting error while running the code
Hey John Paul, I am also getting the error. Did you find the solution? It would of much help if you share it with me.
@@NehaR.Scholar0123Commerce currently am doing with 1 database
Thanks man