How to Merge Scopus and Web of Science Data into One Excel File Using Power Query

Are you tired of manually merging data from multiple sources like Scopus and Web of Science? This video will show you a streamlined way to combine your research data into a single Excel file using Microsoft Power Query.

Key Points:

Effortless Data Integration: Learn how to connect to multiple data sources and import them into Power Query.
Seamless Data Cleaning and Transformation: Discover powerful techniques to clean, transform, and shape your data.
Efficient Data Merging: Master the art of merging data based on common keys from different sources.
Customizable Data Analysis: Explore advanced techniques to analyse and visualise your merged data.

Additional Resources:

Header Mapping File: Download the header mapping file created by Dr. Imran Qureshi to easily match fields from Scopus and Web of Science:

By the end of this video, you'll be able to:

Connect to multiple data sources (Scopus, Web of Science, etc.)
Clean and transform your data effectively
Merge data based on common keys
Analyze and visualize your combined data

#powerquery #datascience #excel #researchmethods #dataanalysis #datacleaning #dataintegration #scopus #webofscience

[yasraaslam]

Thank you, sir, for the wonderful technique. Sir, does this method merge the two different databases? What about the duplication? because it's adding a file and not sorting it. If I'm wrong, kindly correct me. Thanks

[ravshaneminov]

Sir! What about reference tools like Zotero in a few seconds, merge duplicate papers?

[nupurchauhan]

But it has duplicates and we cannot use it directly in biblioshiny, what step should be taken to remove duplicates?