From the course: Python in Excel: Working with pandas DataFrames
About Python in Excel
From the course: Python in Excel: Working with pandas DataFrames
About Python in Excel
- [Instructor] While I'm recording this course, Python in Excel is still in preview. Right now it's only available on Windows for Microsoft 365 subscribers who are on the beta channel. It's possible though that by the time you're watching this, it will be available on macOS and the web version of Excel as well. You can always check if you have access by going to the Formulas tab and checking out if you have this Python section over here in the menu. Bear in mind that when Python in Excel becomes generally available, you might need to buy an extra subscription on top of Microsoft 365. Python in Excel runs in the cloud. What this means for you is that you will need to be connected to the internet when you run Python code in the cells. Also, a few things will likely change in the future. However, the concepts in code shouldn't be affected by this. Most likely, you will notice differences along the following lines. It could be that the display or formatting of data frames in Excel will be slightly different, especially around empty cells or how NAN values are displayed. Or the Python in Excel ribbon menu will be organized in a different way, or placed on a different ribbon tab. Also, the Python editor that I will install in one of the videos via Excel's add-in store should be available natively in the future without the need for any add-ins. Despite these changes, I'm confident that you will still be able to follow along easily.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.