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

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://drive.google.com/drive/folders/1WGDRIzcq0nqqErNOmM4DBjoMl-G2hvCb?usp=sharing 👉 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/