Continuing this short series about the new Python in Excel feature, I look at how we can use Power Query connections to populate pandas DataFrames and some gotchas to consider while doing so.
At the end, an example of some slightly more advanced calculations we can now do in Excel thanks to Python.
If you like this content, please like, comment, subscribe and share.
Enjoy!