Naive Bayes Classifier With Excel - Build a Spam Filter!

[@DaveOnData]

👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 kzbin.info/www/bejne/rnq7qqCXl955f68 💥 Learning R programming is easy for Excel users! 💥 📺 kzbin.info/www/bejne/g3_TpKygiNqFaJI

[@timepassp9042]

Very Nice and Simple explanation. Appreciate your effort

[@DaveOnData]

Thank you for taking the time to leave this comment! The kind words are appreciated.

[@leandrovrabelo]

Hi David, i've being watching your videos related to Excel and after a time I noticed one thing: This Machine Learning world uses a lot of fancy words and people try to show that what they are doing is really hard. As millions of people uses Excel in their jobs in a daily matter, you are making these "complex" things with fancy names a lot easier for us. thanks!!!!

[@DaveOnData]

Thank you so much for this feedback, I take it as high praise! My mission is to empower ANY professional to develop valuable data analysis skills. I'm hoping your comment is validation that I'm making progress in my mission.

[@leandrovrabelo]

Once I saw the math notation of a naive Bayes formula and I got scared! I tried to understand what people were explaining and I had a hard time haha, watching this video made things SO EASY! The recommender system too! Please keep creating content like this, I'm pretty sure that a lot of people have more familiarity with Excel than other tools! I'll try to learn R just because you suggested!

[@DaveOnData]

Duly noted! Have more Excel-based data mining and analytics content planned.

[@dopamining6932]

Massively underrated channel. Top notch stuff!

[@DaveOnData]

Wow! Thank you so much for this feedback. Very much appreciated.

[@박대건-p4g]

Great lesson and example!!!!!!!!!!!❤

[@DaveOnData]

Thank you for the feedback. I am happy you enjoyed the tutorial!

[@PillsLifestyleReviews]

This was an amazing breakdown Dave. Thank you so much!

[@RaulMartinez-ln8zq]

Great GREAT video! Thank you David for creating one of the videos I have seen in KZbin!

[@ahmedel-sayed8744]

HI THANKS for your great video .... how can download excel file?

[@mohamedriswan2991]

Good lesson 😍

[@DaveOnData]

Thank you, glad you liked the tutorial!

[@Pinenamy542]

I loved your video on naive Bayes. I'm wondering if/how the spreadsheet could be made even more automated. For example, is there a way to have Excel do the word counts in each of the text phrases?

[@DaveOnData]

Great question! The representation to which you are referring is known as a "document-term matrix." To my knowledge, creating one of these in Excel would require custom coding (e.g., VBA). A far easier solution for Excel users would be to learn how to do this in R. Check out this video on my channel on how learning R programming is easy for Excel users: kzbin.info/www/bejne/g3_TpKygiNqFaJI

[@mohamed.montaser]

other question, beside the known sentiment analysis methods, can this method used for sentiment analysis

[@DaveOnData]

The short answer is yes, provided you have a labeled training set.

[@mohamed.montaser]

@@DaveOnData i hope you make a video about sentiment analysis because i don't understand how words are weighted and based on what

[@mohamed.montaser]

can you make a video about sentiment analysis

[@DaveOnData]

Great idea, I will add it to my list!

[@mohamed.montaser]

at first how was the data labeled ham or spam and based on what .. was it manual labeling?

[@DaveOnData]

Check out the following link. To my reading, it looks like they were manually labeled: www.kaggle.com/uciml/sms-spam-collection-dataset

[@tauketea]

Dear, teacher, hello, I couldn't find any links to social media, I'm strong believer in one chance possiblity at times, so could you provide me with some work, even entry, I Will do my best with all that I'v got. Thanks, for considering, you motivate me a lot

[@DaveOnData]

Unfortunately, as of right now, I am a business of one person and do not have any work opportunities. Feel free to follow me on LinkedIn as I am active on that social media platform: www.linkedin.com/in/davelanger/

[@IBMSystemsEngineer]

Dave, I have to admit, this did not work well for me. I followed all the formulas. I took one of the priors, a short sentence which is HAM, and used that same sentence, as a test, word for word, and its calculated result is SPAM.