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

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:

👉 Downloadable project file: https://bit.ly/4h8mNWk

👉 Full Unsupervised Learning course:
Maven Analytics: https://bit.ly/4eLsOX6
Udemy: https://bit.ly/3Y4y1lT

👉 10-Week Immersive Programs: https://bit.ly/3AceEzc

👉 Follow us on LinkedIn:
Enrique: https://www.linkedin.com/in/enrique-ruiz-tapia/
Maven Analytics: https://www.linkedin.com/company/maven-analytics

⏱️ 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.

Start learning and build your FREE portfolio at http://www.mavenanalytics.io/