Save 20% off my machine learning online courses using code RUclips ⬇ Cluster Analysis with Python online course: bit.ly/ClusterAnalysisWithPythonCourse My "Intro to Machine Learning" online course: bit.ly/TDWIIntroToML
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.
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!
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.
@@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!
Stuck waiting on Microsoft to give you access to Python in Excel? Don't wait! Watch my RUclips video on how to get started NOW: ruclips.net/video/0iV4FtpSriY/видео.html
10 месяцев назад+1
This is great thanks! Is there a way you can output the model accuracies in the cell itself instead of the diagnostics tab?
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 😅
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
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.
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
@MyAudioPipe - If I understand your question correctly, a Jupyter Notebook might be better. Check out my Python Crash Course series: ruclips.net/p/PLTJTBoU5HOCTIWI3m7PUaeaP5VY3M1a1s
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.
@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?
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Save 20% off my machine learning online courses using code RUclips ⬇
Cluster Analysis with Python online course:
bit.ly/ClusterAnalysisWithPythonCourse
My "Intro to Machine Learning" online course:
bit.ly/TDWIIntroToML
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.
Thank you so much for your continued support for the channel! It is much appreciated.
Just what I was looking for. Thank you!
Excellent! You may enjoy my video tomorrow as well. It demonstrates performing a cluster analysis using Python in Excel.
Awesome David. Thanks for the tutorial.
You are welcome! Next week's video will be on cluster analysis using Python in Excel. Stay tuned.
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!
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.
@@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!
@kristoferbrown8007 - Then you will like the video after that even more! It will cover clustering text documents.
Stuck waiting on Microsoft to give you access to Python in Excel? Don't wait! Watch my RUclips video on how to get started NOW: ruclips.net/video/0iV4FtpSriY/видео.html
This is great thanks! Is there a way you can output the model accuracies in the cell itself instead of the diagnostics tab?
Great question! There are many ways to accomplish this. For example, creating a DataFrame that you output to the worksheet.
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 😅
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.
Hi David, This data set where can i find it, to folow along. Tks in advance
You can find the Adult dataset here:
archive.ics.uci.edu/dataset/2/adult
Hi Dave, which version of Excel are you using in this video? thanks
Microsoft 365 on Windows at the time of the recording.
Hi - awesome learning , grateful if you can share the excel file with the python code
regards
@MCdat123 - I've added a GitHub repo link to the video description where you can get the Excel workbook file.
Great post! I fired up excel (On-line & local) and can’t see the ‘PY’ function - am I missing something…
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
BTW - If you want to get started now while you wait for access, check out this video on my RUclips channel:
📺 ruclips.net/video/0iV4FtpSriY/видео.html
Awesome
Glad you enjoyed the tutorial!
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.
Apologies, I don't do anything with Google Sheets.
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
@MyAudioPipe - If I understand your question correctly, a Jupyter Notebook might be better. Check out my Python Crash Course series: ruclips.net/p/PLTJTBoU5HOCTIWI3m7PUaeaP5VY3M1a1s
So...what does that tell us? It automates classifying ?
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.
@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?
Correct and which combinations of features are important for making accurate predictions regarding income level.
@DaveOnData Thank you sir 🙏
How about time series data? Isn’t that what all the rage is about these days?
Forecasting has always been the rage. 🤣
As it turns out, combining decision tree-baeed ML with statistical models provides improved forecasting.
@@DaveOnData Alright! 👍😁 So random forest and the like then? What if there are lagged effects?