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"
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
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.
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 @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
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).