👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 th-cam.com/video/xIXymabyFIM/w-d-xo.html 💥 Learning R programming is easy for Excel users! 💥 📺 th-cam.com/video/MNpsyjSuR20/w-d-xo.html
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!!!!
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.
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!
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?
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: th-cam.com/video/MNpsyjSuR20/w-d-xo.html
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
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/
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.
👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 th-cam.com/video/xIXymabyFIM/w-d-xo.html
💥 Learning R programming is easy for Excel users! 💥
📺 th-cam.com/video/MNpsyjSuR20/w-d-xo.html
Great lesson and example!!!!!!!!!!!❤
Thank you for the feedback. I am happy you enjoyed the tutorial!
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!!!!
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.
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!
Duly noted! Have more Excel-based data mining and analytics content planned.
Massively underrated channel. Top notch stuff!
Wow! Thank you so much for this feedback. Very much appreciated.
This was an amazing breakdown Dave. Thank you so much!
Great GREAT video! Thank you David for creating one of the videos I have seen in TH-cam!
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?
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: th-cam.com/video/MNpsyjSuR20/w-d-xo.html
Good lesson 😍
Thank you, glad you liked the tutorial!
can you make a video about sentiment analysis
Great idea, I will add it to my list!
at first how was the data labeled ham or spam and based on what .. was it manual labeling?
Check out the following link. To my reading, it looks like they were manually labeled:
www.kaggle.com/uciml/sms-spam-collection-dataset
other question, beside the known sentiment analysis methods, can this method used for sentiment analysis
The short answer is yes, provided you have a labeled training set.
@@DaveOnData i hope you make a video about sentiment analysis because i don't understand how words are weighted and based on what
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
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/
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.