Machine Learning with Microsoft Excel? Yes, PLEASE!

Analyzing data using machine learning is a killer scenario for Python in Excel. In this video, I demonstrate how to train a machine learning model and interpret the patterns it finds in the data.
Python in Excel is a game-changer for professionals who want to delight stakeholders with insights that are just not possible with out-of-the-box Microsoft Excel features.
Analyzing data using machine learning is just one powerful example.
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoffee.com/DaveOnData
--------------------------------------------------------------------------------------------
VIDEO CHAPTERS
--------------------------------------------------------------------------------------------
00:00 Intro
01:24 The Data
04:40 Training the ML Model
13:18 Interpreting the ML Model
15:45 Evaluating the ML Model
19:18 Wrap-up
--------------------------------------------------------------------------------------------
FREE MACHINE LEARNING CRASH COURSES
--------------------------------------------------------------------------------------------
If you're ready to see what Python in Excel skills make possible, be sure to check out my FREE on-demand machine learning crash courses!
Here's what you get with any of these courses:
1️⃣ On-Demand: Watch the course when it fits your schedule
2️⃣ PDF of all slides
3️⃣ All Python code as a Jupyter Notebook
4️⃣ All data so you can experiment
5️⃣ Resources to continue your learning.
Machine learning with Python in Excel. You've got this if you want it:
💻 Decision Trees with Python:
bit.ly/DecisionTreesWithPython
💻 Tuning Decision Trees with Python:
bit.ly/TuningDecisionTreesWit...
💻 Logistic Regression with Python:
bit.ly/LogisticRegressionWith...
💻 Cluster Analysis with Python:
bit.ly/ClusterAnalysisWithPython
--------------------------------------------------------------------------------------------
GET THE MICROSOFT EXCEL WORKBOOK
--------------------------------------------------------------------------------------------
Here's the link to the GitHub for my Python in Excel video workbooks:
github.com/DaveOnData/PythonI...
NOTE - You have to have access to Python in Excel to run the code!
#pythoninexcel #pythonexcel #pythonforexcel

[@DaveOnData]

Stuck waiting on Microsoft to give you access to Python in Excel? Don't wait! Watch my KZbin video on how to get started NOW: kzbin.info/www/bejne/Zpq5ZXmqpbiln7s

[@michaelt312]

I also have a confession to make. Today is a crazy busy day. I'm playing the video with my headphones plugged in to help the algorithm. Based on your quality this far, I'm sure this video is awesome. Looking forward to watching and learning.

[@DaveOnData]

Thank you so much for your continued support for the channel! It is much appreciated.

[@Belakavadi]

Awesome David. Thanks for the tutorial.

[@DaveOnData]

You are welcome! Next week's video will be on cluster analysis using Python in Excel. Stay tuned.

[@vincentf.2317]

Just what I was looking for. Thank you!

[@DaveOnData]

Excellent! You may enjoy my video tomorrow as well. It demonstrates performing a cluster analysis using Python in Excel.

[@kristoferbrown8007]

Dave, this is a homerun of a video. It clearly demonstrates a wholistic view of the capabilities of Python in Excel for predictive analytics. To me, it looks as good if not better than in a Jupyter Notebook, and even more digestible for the masses. Well done! I look forward to more deep dive content in the future, so I hope it is on your roadmap!

[@DaveOnData]

Wow! Thank you for the kind words, they are much appreciated. Yes, I will be shifting gears to more examples of using Python in Excel for data science. Next week's video will be on building a spam filter using Naive Bayes for text analytics.

[@kristoferbrown8007]

@@DaveOnData this is quite timely! I have a boatload of textual data that needs categorizing. Naive Bayes might be a great starting point. Looking forward to it!

[@DaveOnData]

@kristoferbrown8007 - Then you will like the video after that even more! It will cover clustering text documents.

[@audrabloom3164]

Wish there was python in excel when I was learning! This is great start for anyone looking for branch more into data science from the comfort zone of excel 😅

[@DaveOnData]

Well-said! Quite a few of my Excel videos (e.g., my K-means video) are kinda pointless now that Python in Excel is available.

[@brendamartinezgomez2297]

Awesome

[@DaveOnData]

Glad you enjoyed the tutorial!

This is great thanks! Is there a way you can output the model accuracies in the cell itself instead of the diagnostics tab?

[@DaveOnData]

Great question! There are many ways to accomplish this. For example, creating a DataFrame that you output to the worksheet.

[@ceylonroadceylonroad]

Hi Dave, which version of Excel are you using in this video? thanks

[@MCdat123]

Hi - awesome learning , grateful if you can share the excel file with the python code regards

[@DaveOnData]

@MCdat123 - I've added a GitHub repo link to the video description where you can get the Excel workbook file.

[@DinoAMAntunes]

Hi David, This data set where can i find it, to folow along. Tks in advance

[@DaveOnData]

You can find the Adult dataset here: archive.ics.uci.edu/dataset/2/adult

[@MyAudioPipe]

hallo. new to this. is there some way to joust get the math done i excel over to Pyton on a easy way ? doing some Ballistic stuff and and it have been nice to run a Program Instead of excel :P

[@DaveOnData]

@MyAudioPipe - If I understand your question correctly, a Jupyter Notebook might be better. Check out my Python Crash Course series: kzbin.info/aero/PLTJTBoU5HOCTIWI3m7PUaeaP5VY3M1a1s

[@Moshie71]

Great post! I fired up excel (On-line & local) and can’t see the ‘PY’ function - am I missing something…

[@DaveOnData]

Glad you enjoyed the content! Python in Excel is in Public Preview. You need to request access from Microsoft. Check out this article for more information: support.microsoft.com/en-us/office/get-started-with-python-in-excel-a33fbcbe-065b-41d3-82cf-23d05397f53d

[@DaveOnData]

BTW - If you want to get started now while you wait for access, check out this video on my KZbin channel: 📺 kzbin.info/www/bejne/Zpq5ZXmqpbiln7s

[@learning_with_irving4266]

So...what does that tell us? It automates classifying ?

[@DaveOnData]

Analyzing data with machine learning models can provide many insights. For example, discovering which features (i.e., columns) in the data are most associated with an outcome of interest.

[@learning_with_irving4266]

@DaveOnData right but for this particular example, it creates a classification tree based on their features, how would that be used? For instance if we take that dataset, it would tell us which of those people are more likely to have a higher income?

[@DaveOnData]

Correct and which combinations of features are important for making accurate predictions regarding income level.

[@learning_with_irving4266]

@DaveOnData Thank you sir 🙏