This video is taken from my courseĀ Python in Excel
Check out the Course
This video is taken from my courseĀ Python in Excel
Check out the Course

Python in Excel Demo: Creating a DataFrame from External Data using Power Query

Ā 

Use Power Query to connect to external data, and then Excel's new Python integration to create DataFrames from it, for onward calculation and analysis.