Use the popular Pandas library for data manipulation and analysis to read data from two files and join them into a single dataset.

Pandas makes it easy to quickly load, manipulate, align, merge, and even visualize data tables directly in Python.

Microsoft is integrating Python into its Excel app. A public preview is available for Microsoft 365 subscribers now and all the Python code runs on the Microsoft Cloud.