How to Install Python in Excel (PowerQuery & DataFrames)

In this video, we're going to show you how to install Python for Excel, and then use PowerQuery and DataFrames to create a simple model. This video is perfect if you're new to Python and Excel, or if you just need a refresher on how to use these tools.
By the end of this video, you'll be able to install Python for Excel, create a simple dataframe, and use PowerQuery to interact with your data. This video is perfect for anyone who wants to learn more about Python and Excel together!

[@mpfiesty]

You're a legend, sir. Could you make a tutorial on data cleaning and analytics in Excel using Python? Or pulling and processing data from Excel using Python in VS Code and bringing it back into Excel for reporting, maybe intertwining DAX in the data model? I haven't come across a good tutorial for Python in Excel, so I hope this is something you're interested in.

[@analyticswithadam]

Lots more on the way thanks for the ideas 💡

[@AdamGrant-vr3ty]

Hi Grace, Using Powerquery to store and pivot the data as connections should speed it up

[@GraceZhang-oo5sf]

The functionality of this dataframe is indeed powerful. However, when I have multiple sheets in a workbook and create different pivot tables in each sheet using the dataframe format, the computation becomes very slow. When I create different pivot tables in more than three sheets within a workbook (using the dataframe), my Excel often crashes. Do you have any suggestions on this? Is it because the storage space on the cloud is limited? Or is it that the algorithms I've written involve heavy computations, leading to slow performance? Thank you very much

[@arindambhattacharya8127]

I dont see Microsoft 365 Insider

[@onwaybusiness]

looks like cannot be used for personal account?

[@analyticswithadam]

I have one license on an office 365 E5 account..

[@onwaybusiness]

@@analyticswithadam any method to share? thanks.