Machine Learning with Python in Excel: Best of Both Worlds? (full tutorial!)

preview_player
Показать описание
Learn to combine Excel’s hands-on nature with Python’s machine learning capabilities to get the best of both worlds with Python in Excel.

In this demo, you’ll learn how to fit, interpret, and visualize a K-Means Clustering model in an Excel workbook with less than 15 lines of Python code.

Along the way, you’ll use Python in Excel to:
✔️ View column distributions using pair plots
✔️ Scale data using normalization
✔️ Find the right number of clusters using inertia plots
✔️ Fit a K-Means clustering model
✔️ Interpret the cluster centers
✔️ Visualize the clusters to share your insights
…all in less than 20 minutes!

🔗 Helpful links:

👉 Full Unsupervised Learning course:

👉 Follow us on LinkedIn:


⏱️ Timestamps:
00:00 - Intro
00:15 - Excel + Python
00:45 - Marvel Movie Dataset
00:56 - Step 1: Start with a question
01:11 - Step 2: Select the right method
01:34 - Step 3: Select the right features
03:24 - Step 4: Scale the data
05:54 - Step 5: Find the right number of clusters
09:13 - Step 6: Fit the model
10:11 - Step 7: Interpret the cluster centers
12:33 - Step 8: Share your insights
15:35 - Resources and next steps

Maven Analytics is an award-winning online platform for data professionals to learn new skills, showcase their work, and connect with peers around the world.

We've helped more than 1,000,000 students build job-ready data & AI skills, master tools like Excel, SQL, Power BI, Tableau and Python, and build the foundations for successful careers.

  1. Maven Analytics
  2. python in excel
  3. python excel
  4. excel
  5. machine learning
  6. python
Рекомендации по теме
Python Machine Learning 0:49:43

Python Machine Learning Tutorial (Data Science)

Machine Learning Explained 0:02:35

Machine Learning Explained in 100 Seconds

Machine Learning Full 11:55:00

Machine Learning Full Course 2025 | Machine Learning Tutorial For Beginners | Simplilearn

Build your first 0:30:57

Build your first machine learning model in Python

Machine Learning | 0:07:52

Machine Learning | What Is Machine Learning? | Introduction To Machine Learning | 2024 | Simplilearn

Machine Learning With 9:58:08

Machine Learning With Python Full Course 2023 | Machine Learning Tutorial for Beginners| Simplilearn

TensorFlow in 100 0:02:39

TensorFlow in 100 Seconds

Machine Learning for 0:01:00

Machine Learning for Facial Recognition in Python in 60 Seconds #shorts

03 : 🚀 1:01:00

03 : 🚀 Decision Tree Algorithm l Master Machine Learning Algorithm From Scratch | No Scikit-Learn....

Machine Learning with 10:36:31

Machine Learning with Python | Machine Learning Tutorial for Beginners | Machine Learning Tutorial

Machine Learning Python 0:10:20

Machine Learning Python - Come creare Intelligenza Artificiale Python in modo semplice! Scikit Learn

Scikit-learn Crash Course 2:09:22

Scikit-learn Crash Course - Machine Learning Library for Python

Python for Beginners 1:00:06

Python for Beginners - Learn Coding with Python in 1 Hour

Tensorflow Tutorial for 0:11:33

Tensorflow Tutorial for Python in 10 Minutes

But what is 0:18:40

But what is a neural network? | Deep learning chapter 1

Machine Learning Tutorial 0:06:51

Machine Learning Tutorial Python -1: What is Machine Learning?

Deep Learning with 0:20:34

Deep Learning with Python, TensorFlow, and Keras tutorial

Scikit-Learn Course - 2:54:25

Scikit-Learn Course - Machine Learning in Python Tutorial

Machine Learning Projects 0:06:58

Machine Learning Projects for Beginners (Datasets Included)

How I'd Learn 0:10:18

How I'd Learn AI in 2025 (If I could start over)

Make Your First 0:16:37

Make Your First AI in 15 Minutes with Python

FORMATION PYTHON MACHINE 0:08:30

FORMATION PYTHON MACHINE LEARNING (2020) (1/30)

Real-World Python Machine 1:40:49

Real-World Python Machine Learning Tutorial w/ Scikit Learn (sklearn basics, NLP, classifiers, etc)

Deep Learning | 0:05:52

Deep Learning | What is Deep Learning? | Deep Learning Tutorial For Beginners | 2023 | Simplilearn

Комментарии
Автор

It was so easy to follow your tutorial even for a begginner like me. Thanks!

safakbulut
Автор

Brilliant video Enrique 😊 I can see you are getting quite comfortable with unsupervised learning now 👏👏👏 I will certainly give it a go
!

ewad
Автор

Brilliant - thanks a lot for this. I'm showing it to friends. It all worked first time on my Home Office 365 product.
I'm guessing my limited knowledge of Python can be extended a great deal with Co-Pilot installed direct in Excel. For the meantime I guess I'll be using chatGPT and Claude and cutting and pasting a lot.
2 things I had to work out for myself.
1. The Python code is executed in the cells in order (top left to right, and then going down the page logically).
So my placing the Python cells all over the place created a lot of errors till I worked that out.
2. I start off with a limited amount of Premium compute time a day. All those errors took me past that. But good news - they came right up with an invitation to the free Preview of Python in Excel which for now gives me more compute time.

antique-bsbb
Автор

Using python for data analisys in excel is awsome

jaedonbigbrain
Автор

Super! Could you please re-share the Downloadable project file? the link does not work

NFET
Автор

Project file can not download. Please check. By the way, the tutorial is good, easy to catch up with me.

ERXVietNam
Автор

Would i need to install python to excel before doing this project

emmanuelsarpong