- Course Overview
-
Learning Objectives 00:02:04
- Getting Started
-
Python FOR Excel vs. Python IN Excel 00:02:40
-
Initialization and Anaconda Distribution 00:02:25
-
The Execution Model 00:02:33
-
What Cannot vs. Can be Done in Python in Excel 00:03:04
- ML Experiment: Iris Flower Dataset
-
Step 1: The Data and the Learning Problem 00:16:33
-
Step 2: Set up our ML Experiment 00:09:24
-
Step 3.1: Feature Exploration – Pairplot 00:11:11
-
Step 3.2: Feature Exploration – Dimension Reduction (PCA) 00:17:51
-
Step 4.1: Classification – Decision Boundary 00:20:40
-
Step 4.2: Classification – Confusion Matrix 00:10:31
- Conclusion
-
What's next? 00:00:56
-
End of Course Survey
Machine Learning with Python in Excel
Explore the full potential of ML in Python within Excel workbooks.
In this hands-on course, you’ll learn how to use the new Python in Excel integration to create simple machine learning experiments. We will dive into some of the most common steps of machine learning analyses (e.g., data partitioning and feature analysis) in a live-coding environment. During this course, you’ll work on coding examples, one cell at a time, in order to follow along easily even if you are not completely familiar with Python programming. More experienced Python users can similarly benefit from this interactive course, as we will emphasize how to translate common Python tasks to an Excel workbook, and how to make the best use of this new computing platform.
To get the most out of this course, we recommend getting access to the Python in Excel integration. This will enable you to actively participate in the hands-on exercises on your own machine. For more information, click here.
By the end of this hands-on course, you’ll understand:
- How to use the new Python in Excel feature, and how it works
- How to use some of the most popular data science and machine learning Python libraries directly in Excel
- Basics of a machine learning experiment
- How to organize your Excel workbook for data analysis
And you’ll be able to:
- Load, manipulate, and handle data in Excel using Python
- Generate plots with Python directly in Excel
- Create a full machine learning experiment with Python in Excel
This training is for you because…
- You’re an Excel user wishing to explore how the new Python in Excel feature works, and what is its potential.
- You work with Python and would like to better understand how the new Python in Excel integration works.
- You wish to gain an understanding of what it takes to be an Excel Data Scientist, combining your knowledge of Excel and Python.
Prerequisites
- Essential: Basic understanding of how programming works
- Essential: Familiarity with Python code and the Excel environment
- Optional: General understanding of machine learning
Recommended preparation
- To follow along, it is recommended you have access to Python in Excel features on Windows. (Python features not yet available on Mac.)
Recommended follow-up
About the instructor
Valerio Maggio is a researcher and data scientist advocate at Anaconda. He is also an open-source contributor and an active member of the Python community. Over the last 12 years, he has contributed to and volunteered at many international conferences and community meetups like PyCon Italy, PyData, EuroPython, and EuroSciPy.
Questions? Issues? Contact [email protected].