Data science is THE BEST use case for Python in Excel! Want to have more impact at work? Do you have text data? Use Python in Excel to analyze it! Text data is in Word docs, customer service chats, notes fields in IT systems. Text data is everywhere in every organization. With Python in Excel, you can now harvest the value hidden in your text data. I will use the Naïve Bayes machine learning technique with text documents in this video. Naïve Bayes is commonly used in text analytics to classify documents. A real-world scenario where Naïve Bayes has been successfully used for years is classifying emails and text messages as illegitimate (i.e., spam) or legitimate (i.e., ham). ☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData -------------------------------------------------------------------------------------------- VIDEO CHAPTERS -------------------------------------------------------------------------------------------- 00:00 Intro 01:42 Tokenization 05:31 Document Vectors 06:40 The Naïve Bayes Algorithm 10:50 The Math of Naïve Bayes 18:10 Training the Naïve Bayes Model in Excel 24:46 Testing the Naïve Bayes Model in Excel 28:06 What’s Next? -------------------------------------------------------------------------------------------- FREE MACHINE LEARNING CRASH COURSES -------------------------------------------------------------------------------------------- If you're ready to see what Python in Excel skills make possible, be sure to check out my FREE on-demand machine learning crash courses! Here's what you get with any of these courses: 1️⃣ On-Demand: Watch the course when it fits your schedule 2️⃣ PDF of all slides 3️⃣ All Python code as a Jupyter Notebook 4️⃣ All data so you can experiment 5️⃣ Resources to continue your learning. Machine learning with Python in Excel. You've got this if you want it: 💻 Decision Trees with Python: https://bit.ly/DecisionTreesWithPython 💻 Tuning Decision Trees with Python: https://bit.ly/TuningDecisionTreesWithPython 💻 Logistic Regression with Python: https://bit.ly/LogisticRegressionWithPython 💻 Cluster Analysis with Python: https://bit.ly/ClusterAnalysisWithPython -------------------------------------------------------------------------------------------- GET THE MICROSOFT EXCEL WORKBOOK -------------------------------------------------------------------------------------------- Here's the link to the GitHub for my Python in Excel video workbooks: https://github.com/DaveOnData/PythonInExcelYouTube NOTE - You have to have access to Python in Excel to run the code! #pythoninexcel #pythonexcel #pythonforexcel #pythoninexcel #python excel #python in excel #python for excel #pythonforexcel #pythonexcel #naive bayes #text analytics #naive bayes algorithm #naive bayes classifier #spam filter #spam filtering #naive bayes excel #python

Data science is the top use case for Python in Excel! However, a fundamental question remains - can you do real data science with Python in Excel? I have tested Python in Excel's scalability with various real-world data science scenarios and report my findings in this video. ☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData -------------------------------------------------------------------------------------------- VIDEO CHAPTERS -------------------------------------------------------------------------------------------- 00:00 Intro 01:36 Datasets 04:46 Visual Data Analysis 07:48 Cluster Analysis 11:11 Decision Tree ML Models 14:40 Random Forest ML Models 17:21 The Verdict -------------------------------------------------------------------------------------------- FREE MACHINE LEARNING CRASH COURSES -------------------------------------------------------------------------------------------- If you're ready to see what Python in Excel skills make possible, be sure to check out my FREE on-demand machine learning crash courses! Here's what you get with any of these courses: 1️⃣ On-Demand: Watch the course when it fits your schedule 2️⃣ PDF of all slides 3️⃣ All Python code as a Jupyter Notebook 4️⃣ All data so you can experiment 5️⃣ Resources to continue your learning. Machine learning with Python in Excel. You've got this if you want it: 💻 Decision Trees with Python: https://bit.ly/DecisionTreesWithPython 💻 Tuning Decision Trees with Python: https://bit.ly/TuningDecisionTreesWithPython 💻 Logistic Regression with Python: https://bit.ly/LogisticRegressionWithPython 💻 Cluster Analysis with Python: https://bit.ly/ClusterAnalysisWithPython #pythoninexcel #pythonexcel #pythonforexcel #pythoninexcel #python excel #python in excel #python for excel #pythonforexcel #pythonexcel

In 2024, using Python in Excel for data wrangling isn't a great idea. Surprised? All will be clear when you consider how Python in Excel works behind the scenes. Data wrangling is one of the most important tasks in analytics. Estimates are 60-80% of the time required for analytics projects (especially advanced analytics projects) is spent on acquiring, filtering, cleaning, combining, enriching, and transforming data. As a hands-on analytics professional, I can tell you this is no exaggeration! Trust me. You want to use the best technology for your data wrangling. ☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData -------------------------------------------------------------------------------------------- VIDEO CHAPTERS -------------------------------------------------------------------------------------------- 00:00 Intro 01:04 Python in Excel Architecture 02:49 Data Wrangling Options 05:52 Python in Excel Wrangling Exceptions 07:36 Python in Excel’s Future -------------------------------------------------------------------------------------------- FREE MACHINE LEARNING CRASH COURSES -------------------------------------------------------------------------------------------- If you're ready to see what Python in Excel skills make possible, be sure to check out my FREE on-demand machine learning crash courses! Here's what you get with any of these courses: 1️⃣ On-Demand: Watch the course when it fits your schedule 2️⃣ PDF of all slides 3️⃣ All Python code as a Jupyter Notebook 4️⃣ All data so you can experiment 5️⃣ Resources to continue your learning. Machine learning with Python in Excel. You've got this if you want it: 💻 Decision Trees with Python: https://bit.ly/DecisionTreesWithPython 💻 Tuning Decision Trees with Python: https://bit.ly/TuningDecisionTreesWithPython 💻 Logistic Regression with Python: https://bit.ly/LogisticRegressionWithPython 💻 Cluster Analysis with Python: https://bit.ly/ClusterAnalysisWithPython #pythoninexcel #pythonexcel #pythonforexcel #pythoninexcel #python excel #python in excel #python for excel #pythonforexcel #pythonexcel

As powerful as Microsoft Excel charts are, they can't do everything. Enter the power of Python in Excel for data visualization! Building your visual data analysis skills is a great place to start if you want to have more impact at work using data. The combination of Excel charts and Python in Excel is like chocolate and peanut butter - better together. Check out what Python in Excel makes possible - you won't regret it! ☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData -------------------------------------------------------------------------------------------- VIDEO CHAPTERS -------------------------------------------------------------------------------------------- 00:00 Intro 01:05 Faceting Data Visualizations 01:47 Faceted Histograms 04:31 Faceted Bar Charts 05:56 Faceted Scatter Plots 07:27 Faceted Strip Plots 08:19 Violin Plots 09:13 Faceted Violin Plots -------------------------------------------------------------------------------------------- MY EDA TUTORIAL SERIES ON YOUTUBE -------------------------------------------------------------------------------------------- My 7-part tutorial series will teach you exploratory data analysis (EDA) with Excel. Here's the playlist link: https://www.youtube.com/playlist?list=PLTJTBoU5HOCRFQhfU1gg2ciNpS_evWKR7 -------------------------------------------------------------------------------------------- VIOLIN PLOT TUTORIAL -------------------------------------------------------------------------------------------- Here's a link to good tutorial on how to read violin plots: https://mode.com/blog/violin-plot-examples #pythoninexcel #pythonexcel #pythonforexcel #pythoninexcel #python excel #python in excel #python for excel #pythonforexcel #pythonexcel #excel charts #excel data visualization #python data visualization

Using machine learning to analyze your data is THE single best use case for Python in Excel! In this video, I cover the 5 must-have machine learning techniques for Python in Excel. While I’ve been teaching professionals machine learning skills for years, I was never more excited than when I was introduced to the Python in Excel feature in August 2023. Python in Excel is a game-changer. It makes it ridiculously easy for professionals like you to build machine learning skills that are actually useful in the real world. Are you ready to have more impact at work using data? ☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData -------------------------------------------------------------------------------------------- VIDEO CHAPTERS -------------------------------------------------------------------------------------------- 00:00 Into 00:58 Types of Machine Learning 03:24 Decision Trees 05:08 Random Forests 07:53 K-Means Clustering 11:11 Logistic Regression 13:15 Linear Regression -------------------------------------------------------------------------------------------- FREE MACHINE LEARNING CRASH COURSES -------------------------------------------------------------------------------------------- If you're ready to see what Python in Excel skills make possible, be sure to check out my FREE on-demand machine learning crash courses! Here's what you get with any of these courses: 1️⃣ On-Demand: Watch the course when it fits your schedule 2️⃣ PDF of all slides 3️⃣ All Python code as a Jupyter Notebook 4️⃣ All data so you can experiment 5️⃣ Resources to continue your learning. Machine learning with Python in Excel. You've got this if you want it: 💻 Decision Trees with Python: https://bit.ly/DecisionTreesWithPython 💻 Tuning Decision Trees with Python: https://bit.ly/TuningDecisionTreesWithPython 💻 Logistic Regression with Python: https://bit.ly/LogisticRegressionWithPython 💻 Cluster Analysis with Python: https://bit.ly/ClusterAnalysisWithPython #pythoninexcel #pythonexcel #pythonforexcel #pythoninexcel #python excel #python in excel #python for excel #pythonforexcel #pythonexcel #machine learning #python machine learning #machine learning excel #python in excel machine learning

Using SQL or Power Query is the best way to get high-quality data for your Python in Excel analyses. However, choosing which is best isn't straightforward. In this video, I discuss choosing between SQL or Power Query based on your situation. ☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData -------------------------------------------------------------------------------------------- VIDEO CHAPTERS -------------------------------------------------------------------------------------------- 00:00 Intro 01:03 Power Query Introduction 06:09 SQL Introduction 11:00 Power Query Pros & Cons 14:22 SQL Pros & Cons 18:15 Which You Should Use -------------------------------------------------------------------------------------------- MY FAVORITE POWER QUERY BOOK -------------------------------------------------------------------------------------------- https://www.amazon.com/Collect-Combine-Transform-Business-Skills/dp/1509307958/ -------------------------------------------------------------------------------------------- MY SQL FOR EXCEL USERS TUTORIAL SERIES -------------------------------------------------------------------------------------------- Part 1 - Overview: https://youtu.be/g1h-9VSjawY Part 2 - Basic Tables: https://youtu.be/otzlxjKCJ38 Part 3 - Basic Filters: https://youtu.be/CLAESLlHjgk #pythoninexcel #pythonexcel #pythonforexcel #pythoninexcel #python excel #python in excel #python for excel #pythonforexcel #pythonexcel #power query #excel power query #python vs power query #python or power query

Don't waste time! Learning Python in Excel or VBA should match your career goals. Python in Excel and VBA are powerful but address very different scenarios for Microsoft Excel users. In this video, I discuss choosing the right option to achieve your goals. ☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData -------------------------------------------------------------------------------------------- VIDEO CHAPTERS -------------------------------------------------------------------------------------------- 00:00 Intro 00:37 VBA Overview 04:16 Python in Excel Overview 07:33 The Question is Answered -------------------------------------------------------------------------------------------- FREE MACHINE LEARNING CRASH COURSES -------------------------------------------------------------------------------------------- If you're ready to see what Python in Excel skills make possible, be sure to check out my FREE on-demand machine learning crash courses! Here's what you get with any of these courses: 1️⃣ On-Demand: Watch the course when it fits your schedule 2️⃣ PDF of all slides 3️⃣ All Python code as a Jupyter Notebook 4️⃣ All data so you can experiment 5️⃣ Resources to continue your learning. Machine learning with Python in Excel. You've got this if you want it: 💻 Decision Trees with Python: https://bit.ly/DecisionTreesWithPython 💻 Tuning Decision Trees with Python: https://bit.ly/TuningDecisionTreesWithPython 💻 Logistic Regression with Python: https://bit.ly/LogisticRegressionWithPython 💻 Cluster Analysis with Python: https://bit.ly/ClusterAnalysisWithPython #pythoninexcel #pythonexcel #pythonforexcel #pythoninexcel #python excel #python in excel #python for excel #pythonforexcel #pythonexcel #excel vba #vba #python vs vba #python or vba

Power Query and Python in Excel are like chocolate and peanut butter - better together! Skills with Power Query are a must in 2024 if you want to supercharge your analytics. The combination of Power Query and Python makes Excel a complete technology stack for doing data science. For example, sourcing 300,000 rows from a database so that you can craft new and powerful insights using Python in Excel. ☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData -------------------------------------------------------------------------------------------- VIDEO CHAPTERS -------------------------------------------------------------------------------------------- 00:00 Intro 01:22 Sizing the Data 05:59 Loading All the Data 08:54 Visualize the Data with a Count Plot 10:20 Visualize the Data with Histograms -------------------------------------------------------------------------------------------- FREE MACHINE LEARNING CRASH COURSES -------------------------------------------------------------------------------------------- If you're ready to see what Python in Excel skills make possible, be sure to check out my FREE on-demand machine learning crash courses! Here's what you get with any of these courses: 1️⃣ On-Demand: Watch the course when it fits your schedule 2️⃣ PDF of all slides 3️⃣ All Python code as a Jupyter Notebook 4️⃣ All data so you can experiment 5️⃣ Resources to continue your learning. Machine learning with Python in Excel. You've got this if you want it: 💻 Decision Trees with Python: https://bit.ly/DecisionTreesWithPython 💻 Tuning Decision Trees with Python: https://bit.ly/TuningDecisionTreesWithPython 💻 Logistic Regression with Python: https://bit.ly/LogisticRegressionWithPython 💻 Cluster Analysis with Python: https://bit.ly/ClusterAnalysisWithPython #pythoninexcel #pythonexcel #pythonforexcel #pythoninexcel #python excel #python in excel #python for excel #pythonforexcel #pythonexcel #power query #excel power query

While logistic regression analysis is super useful to ANY professional, it's traditionally been a pain in Microsoft Excel. Not anymore! Python in Excel makes performing powerful logistic regression analyses easy. Just in case you're unfamiliar with logistic regression, it's a technique where you craft a predictive model where what you are trying to predict is Yes/No: Does this patient have heart disease? Should we approve this loan application? Is this credit card authorization fraudulent? Using logistic regression analysis is universal. Whether you work in healthcare, government, marketing, customer service, or finance doesn't matter. Logistic regression with Python in Excel is a great tool for having more impact at work using data. ☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData -------------------------------------------------------------------------------------------- VIDEO CHAPTERS -------------------------------------------------------------------------------------------- 00:00 Intro 01:03 The Data 02:23 Logistic Regression Using Solver 04:38 Loading the Data into Python 06:31 Wrangling the Data 08:21 The Logistic Regression Model 09:56 The Model Summary 11:49 Interpreting the Model -------------------------------------------------------------------------------------------- FREE MACHINE LEARNING CRASH COURSES -------------------------------------------------------------------------------------------- If you're ready to see what Python in Excel skills make possible, be sure to check out my FREE on-demand machine learning crash courses! Here's what you get with any of these courses: 1️⃣ On-Demand: Watch the course when it fits your schedule 2️⃣ PDF of all slides 3️⃣ All Python code as a Jupyter Notebook 4️⃣ All data so you can experiment 5️⃣ Resources to continue your learning. Machine learning with Python in Excel. You've got this if you want it: 💻 Decision Trees with Python: https://bit.ly/DecisionTreesWithPython 💻 Tuning Decision Trees with Python: https://bit.ly/TuningDecisionTreesWithPython 💻 Logistic Regression with Python: https://bit.ly/LogisticRegressionWithPython 💻 Cluster Analysis with Python: https://bit.ly/ClusterAnalysisWithPython #pythoninexcel #pythonexcel #pythonforexcel #pythoninexcel #python excel #python in excel #python for excel #pythonforexcel #pythonexcel

Python lambdas are mini-functions without names. Sound strange? Turns out you use lambdas all the time in your Python code for analytics and data science! For example, writing lambdas is common when using the mighty pandas library to clean and transform your data before analyzing it. This crash course video will introduce you to using lambdas in your Python code. After completing this crash course series, you will have the foundational Python skills to take additional analytics, data science, and machine learning courses using Python. ☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData -------------------------------------------------------------------------------------------- VIDEO CHAPTERS -------------------------------------------------------------------------------------------- 00:00 Intro 00:30 Your First Lambda 02:45 Lambdas Are Objects 05:07 Passing Lambdas to Functions -------------------------------------------------------------------------------------------- FREE DATA SCIENCE CRASH COURSES -------------------------------------------------------------------------------------------- If you're ready to see what Python skills make possible, be sure to check out my FREE on-demand data science crash courses! Here's what you get with any of these courses: 1️⃣ On-Demand: Watch the course when it fits your schedule 2️⃣ PDF of all slides 3️⃣ All Python code as a Jupyter Notebook 4️⃣ All data so you can experiment 5️⃣ Resources to continue your learning. Data science with Python. You've got this if you want it: 💻 Decision Trees with Python: https://bit.ly/DecisionTreesWithPython 💻 Tuning Decision Trees with Python: https://bit.ly/TuningDecisionTreesWithPython 💻 Logistic Regression with Python: https://bit.ly/LogisticRegressionWithPython 💻 Cluster Analysis with Python: https://bit.ly/ClusterAnalysisWithPython #pythonforbeginners #pythoncrashcourse #pythoncourse #pythonprogramming #pythontutorial #python #python #python coding #python tutorial #python crash course #python skills #python course #analytics #data science #python for beginners #python lambda #python lambdas