Save 20% off my machine learning online courses using code TH-cam ⬇ The BEST place for you to start is with my "Intro to Machine Learning" online course: bit.ly/TDWIIntroToML COMING SOON - Cluster Analysis with Python
Dave, you delivered as promised! I cannot wait for the upcoming clustering video, as the main challenge we have is applying labels to projects by evaluating a product description or similar field. The same could be done with value props, etc. Understanding which buckets these projects fall into would be extremely helpful when trying to understand relationships. Thanks again!
@kristoferbrown8007 - Excellent! You will likely enjoy my next video, then. The video will cover TF-IDF for text clustering, but not how k-means works. If it would be helpful for your, I have a free crash course on k-means clustering: bit.ly/ClusterAnalysisWithPython
Dear David thank you for highly educating videos that allow all of us to take a new look at Microsoft Excel and find some of its less known features. I have a question about this video: Should the code work on non-English non-Latin texts? I get errors that relate to English specific issues (lower case staff) and was wondering if this analysis with Python in Excel can go beyond English. Thanks again for great videos.
@MaozRosenthal - The default support for non-English text is rudimentary using scikit-learn classes. I've asked Microsoft to prioritize adding the NLTK to Python in Excel to get more options. You may find the following Stack Overflow article of interest: stackoverflow.com/questions/61394233/is-countvectorizer-in-sklearn-only-meant-for-english
Thanks for the video David. My question is how do I deploy the model to be used in excel ?So for example I have built a stock predictor model, I want to be able to share this model with a colleague so they can use the model. Can I send them the excel file with a "Dashboard" sheet where they would just enter a single set of the variables(features like High, Low, Open, Close, Volume etc) and have an output cell display the predicted value ?
@andrewvanderpallen155 - If I understand your question correctly, this scenario would be supported if the colleague can access Python in Excel (e.g., they have the subscription add-on). The current word from Microsoft is Python in Excel outputs (e.g., visualizations), which colleagues can view without Python in Excel but cannot run Python formulas.
@@DaveOnData Thanks for your answer. The colleague cannot access Python in Excel yet. I was thinking since the model would be kind of a finished product they wouldn’t need python to use it but I was wrong.
Save 20% off my machine learning online courses using code TH-cam ⬇
The BEST place for you to start is with my "Intro to Machine Learning" online course:
bit.ly/TDWIIntroToML
COMING SOON - Cluster Analysis with Python
Dave, you delivered as promised! I cannot wait for the upcoming clustering video, as the main challenge we have is applying labels to projects by evaluating a product description or similar field. The same could be done with value props, etc. Understanding which buckets these projects fall into would be extremely helpful when trying to understand relationships. Thanks again!
@kristoferbrown8007 - Excellent! You will likely enjoy my next video, then. The video will cover TF-IDF for text clustering, but not how k-means works. If it would be helpful for your, I have a free crash course on k-means clustering: bit.ly/ClusterAnalysisWithPython
Ok, I see a video from you. Giddy.
I see Bayes in the title. Giddy and elated.
Thank you! I hope many professionals are excited about what Python in Excel brings to the table.
Dear David thank you for highly educating videos that allow all of us to take a new look at Microsoft Excel and find some of its less known features. I have a question about this video: Should the code work on non-English non-Latin texts? I get errors that relate to English specific issues (lower case staff) and was wondering if this analysis with Python in Excel can go beyond English. Thanks again for great videos.
@MaozRosenthal - The default support for non-English text is rudimentary using scikit-learn classes. I've asked Microsoft to prioritize adding the NLTK to Python in Excel to get more options. You may find the following Stack Overflow article of interest:
stackoverflow.com/questions/61394233/is-countvectorizer-in-sklearn-only-meant-for-english
Thanks for the video David. My question is how do I deploy the model to be used in excel ?So for example I have built a stock predictor model, I want to be able to share this model with a colleague so they can use the model. Can I send them the excel file with a "Dashboard" sheet where they would just enter a single set of the variables(features like High, Low, Open, Close, Volume etc) and have an output cell display the predicted value ?
@andrewvanderpallen155 - If I understand your question correctly, this scenario would be supported if the colleague can access Python in Excel (e.g., they have the subscription add-on).
The current word from Microsoft is Python in Excel outputs (e.g., visualizations), which colleagues can view without Python in Excel but cannot run Python formulas.
@@DaveOnData Thanks for your answer. The colleague cannot access Python in Excel yet. I was thinking since the model would be kind of a finished product they wouldn’t need python to use it but I was wrong.