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/