Naive Bayes Classifier With Excel - Build a Spam Filter!

Поделиться
HTML-код
  • Опубликовано: 13 янв 2025

Комментарии • 28

  • @DaveOnData
    @DaveOnData  3 года назад +1

    👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
    📺 ruclips.net/video/xIXymabyFIM/видео.html
    💥 Learning R programming is easy for Excel users! 💥
    📺 ruclips.net/video/MNpsyjSuR20/видео.html

  • @timepassp9042
    @timepassp9042 4 месяца назад +1

    Very Nice and Simple explanation. Appreciate your effort

    • @DaveOnData
      @DaveOnData  3 месяца назад

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

  • @박대건-p4g
    @박대건-p4g 6 месяцев назад +1

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

    • @DaveOnData
      @DaveOnData  6 месяцев назад

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

  • @dopamining6932
    @dopamining6932 3 года назад +3

    Massively underrated channel. Top notch stuff!

    • @DaveOnData
      @DaveOnData  3 года назад +2

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

  • @leandrovrabelo
    @leandrovrabelo 3 года назад +2

    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
      @DaveOnData  3 года назад +3

      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
      @leandrovrabelo 3 года назад +1

      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
      @DaveOnData  3 года назад +2

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

  • @RaulMartinez-ln8zq
    @RaulMartinez-ln8zq 2 года назад

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

  • @PillsLifestyleReviews
    @PillsLifestyleReviews Год назад

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

  • @Pinenamy542
    @Pinenamy542 3 года назад +1

    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
      @DaveOnData  3 года назад +1

      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: ruclips.net/video/MNpsyjSuR20/видео.html

  • @mohamedriswan2991
    @mohamedriswan2991 3 года назад +1

    Good lesson 😍

    • @DaveOnData
      @DaveOnData  3 года назад +1

      Thank you, glad you liked the tutorial!

  • @mohamed.montaser
    @mohamed.montaser 3 года назад +1

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

    • @DaveOnData
      @DaveOnData  3 года назад +1

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

    • @mohamed.montaser
      @mohamed.montaser 3 года назад +1

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

  • @ahmedel-sayed8744
    @ahmedel-sayed8744 3 месяца назад

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

  • @mohamed.montaser
    @mohamed.montaser 3 года назад +1

    can you make a video about sentiment analysis

    • @DaveOnData
      @DaveOnData  3 года назад +2

      Great idea, I will add it to my list!

  • @mohamed.montaser
    @mohamed.montaser 3 года назад +1

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

    • @DaveOnData
      @DaveOnData  3 года назад +1

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

  • @tauketea
    @tauketea 3 года назад +1

    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
      @DaveOnData  3 года назад +1

      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
    @IBMSystemsEngineer 2 года назад

    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.