Machine Learning with Microsoft Excel? Yes, PLEASE!

[@DaveOnData]

Save 20% off my machine learning online courses using code KZbin ⬇ Cluster Analysis with Python online course: bit.ly/ClusterAnalysisWithPythonCourse My "Intro to Machine Learning" online course: bit.ly/TDWIIntroToML

[@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.

[@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.

[@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.

[@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.

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.

[@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.

[@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

[@ceylonroadceylonroad]

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

[@DaveOnData]

Microsoft 365 on Windows at the time of the recording.

[@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

[@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.

[@et34n1ty]

Hey i have a question. Im currently redo some products like printers that i recompose the data titles, short description and assemble it into Google Sheet. i DO THE WORK MANUALLY and i've try ML with Google Sheet but the missing titles they compose is the same title. I tell all the column but i dont know how to resolve it. Is there a email i can show you the data i ve and if the module Google ML can be trained for this purpose? thanks.

[@DaveOnData]

Apologies, I don't do anything with Google Sheets.

[@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

[@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

[@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 🙏

[@canalaprendehuawei231]

Awesome

[@DaveOnData]

Glad you enjoyed the tutorial!

[@djardar]

How about time series data? Isn’t that what all the rage is about these days?

[@DaveOnData]

Forecasting has always been the rage. 🤣 As it turns out, combining decision tree-baeed ML with statistical models provides improved forecasting.

[@djardar]

@@DaveOnData Alright! 👍😁 So random forest and the like then? What if there are lagged effects?