![David Langer](/img/default-banner.jpg)
- Видео 104
- Просмотров 1 128 996
David Langer
США
Добавлен 8 ноя 2011
I can teach you analytics and data science.
Regardless of role. Regardless of background.
Regardless of role. Regardless of background.
Decision Tree Machine Learning - A Python Crash Course
⬇️ Get the files and follow along: bit.ly/3YPv8qW
Decision trees are the BEST place to start building real-world machine learning skills.
This crash course is an intuitive introduction to decision trees and will teach you how they learn from data.
You will also learn how to use the scikit-learn library in Python to train, interpret, test, and evaluate decision tree classifier machine learning models.
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoffee.com/DaveOnData
--------------------------------------------------------------------------------------------
Splitting data for machine learning
----------------------------------------...
Decision trees are the BEST place to start building real-world machine learning skills.
This crash course is an intuitive introduction to decision trees and will teach you how they learn from data.
You will also learn how to use the scikit-learn library in Python to train, interpret, test, and evaluate decision tree classifier machine learning models.
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoffee.com/DaveOnData
--------------------------------------------------------------------------------------------
Splitting data for machine learning
----------------------------------------...
Просмотров: 300
Видео
The BEST Data Visualizations for Data Science: Python in Excel Tutorial (Free File)
Просмотров 1,7 тыс.Месяц назад
⬇️ Get the file and follow along: bit.ly/3y00CzM This tutorial video demonstrates how to create the best data visualizations for data science using the mighty plotnine library and Python in Excel. Now, more than ever, Python in Excel will empower millions of professionals to get real-world data science done - all without the hassle of a local Python installation. ☕ If you found this content use...
Python Crash Course: Part 15 - Data Visualization with plotnine
Просмотров 7612 месяца назад
This plotnine tutorial is a crash course in what you need to know to get started visualizing your data for analytics and data science! 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 m...
Python Crash Course: Part 14 - pandas Tutorial
Просмотров 1,6 тыс.2 месяца назад
Skills with pandas are an absolute requirement for doing analytics and data science with Python! This pandas tutorial is a crash course in what you need to know. 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...
Machine Learning With Random Forests: Python in Excel Tutorial (Free Files)
Просмотров 1,5 тыс.3 месяца назад
⬇️ Get the files and follow along: bit.ly/3QEoa3f My free crash course on decision trees: bit.ly/DecisionTreesWithPython My free crash course on tuning decision trees: bit.ly/TuningDecisionTreesWithPython Machine learning with the random forest algorithm is the perfect place to start your data science journey! This tutorial video will teach you how the random forest algorithm works and how to t...
Topic Modeling Text Documents With LDA: Python in Excel Tutorial (Free Files)
Просмотров 9773 месяца назад
⬇️ Get the files and follow along: bit.ly/3QlcW3q Topic modeling with Latent Dirichlet Allocation (LDA) allows you to extract information from your text documents! It doesn't matter if you have emails, SMS text messages, Customer Service chats, or free-form fields in an IT system. LDA topic modeling is useful to ANY professional. ☕ If you found this content useful and would like to support the ...
K-Means Clustering Text Documents: Python in Excel Tutorial (Free Files)
Просмотров 1,2 тыс.3 месяца назад
⬇️ Get the files and follow along: bit.ly/4aLsMg7 Your boss hands you a pile of documents and asks you to do some "data magic." What do you do? Use the k-means clustering algorithm! In this video, I will teach you a powerful technique for working with text documents using Python in Excel: 1️⃣ Preprocess your text documents using the mighty TF-IDF. 2️⃣ Cluster the documents using k-means. 3️⃣ Us...
Naive Bayes Classifiers for Text Documents: Python in Excel Tutorial (Free File)
Просмотров 1 тыс.4 месяца назад
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 te...
Can You Do Data Science With Python in Excel in 2024?
Просмотров 1,5 тыс.4 месяца назад
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: www.buymeacoffee.com/D...
Do NOT Use Python in Excel for Data Wrangling! Here's Why.
Просмотров 1,7 тыс.4 месяца назад
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,...
Does Python in Excel Replace Excel Charts?
Просмотров 1,6 тыс.4 месяца назад
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 possi...
Python in Excel Makes Machine Learning a MUST-HAVE in 2024!
Просмотров 4,6 тыс.5 месяцев назад
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...
SQL vs. Power Query - What You Should Use for Python in Excel in 2024!
Просмотров 7 тыс.5 месяцев назад
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: www.buymeacoffee.com/DaveOnData VIDEO CHAPTERS 00:00 Int...
Python in Excel vs. VBA - What You Should Learn in 2024!
Просмотров 39 тыс.5 месяцев назад
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: www.buymeacoffee.com/DaveOnData VIDEO CHA...
Python in Excel Makes Power Query a MUST-HAVE in 2024!
Просмотров 40 тыс.5 месяцев назад
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 Ex...
Solver vs. Python in Excel - Which is Best for Logisitc Regression?
Просмотров 1,9 тыс.6 месяцев назад
Solver vs. Python in Excel - Which is Best for Logisitc Regression?
Python Crash Course: Part 13 - Using Lambdas
Просмотров 6126 месяцев назад
Python Crash Course: Part 13 - Using Lambdas
Excel Users: Do This to WOW Your Leaders!
Просмотров 2,1 тыс.6 месяцев назад
Excel Users: Do This to WOW Your Leaders!
Python Crash Course: Part 12 - Writing Functions
Просмотров 6966 месяцев назад
Python Crash Course: Part 12 - Writing Functions
Finally! Powerful Cluster Analysis with Microsoft Excel is HERE!
Просмотров 2,4 тыс.6 месяцев назад
Finally! Powerful Cluster Analysis with Microsoft Excel is HERE!
Python Crash Course: Part 11 - Using List Comprehensions
Просмотров 5886 месяцев назад
Python Crash Course: Part 11 - Using List Comprehensions
Machine Learning with Microsoft Excel? Yes, PLEASE!
Просмотров 6 тыс.6 месяцев назад
Machine Learning with Microsoft Excel? Yes, PLEASE!
Python Crash Course: Part 10 - For Loops & While Loops
Просмотров 7776 месяцев назад
Python Crash Course: Part 10 - For Loops & While Loops
EXCEL USERS: Is Python in Excel Right for YOU?
Просмотров 1,9 тыс.6 месяцев назад
EXCEL USERS: Is Python in Excel Right for YOU?
Python Crash Course: Part 9 - If/Else Statements
Просмотров 6926 месяцев назад
Python Crash Course: Part 9 - If/Else Statements
Excel Users: What You NEED to Learn for Python in Excel!
Просмотров 1,9 тыс.6 месяцев назад
Excel Users: What You NEED to Learn for Python in Excel!
Python Crash Course: Part 8 - Slicing Data
Просмотров 6966 месяцев назад
Python Crash Course: Part 8 - Slicing Data
EXCEL USERS: How to Start with Python in Excel NOW!
Просмотров 3,7 тыс.6 месяцев назад
EXCEL USERS: How to Start with Python in Excel NOW!
Python Crash Course: Part 7 - Tuples and Sets Explained
Просмотров 7456 месяцев назад
Python Crash Course: Part 7 - Tuples and Sets Explained
Python Crash Course: Part 5 - Python Lists Revealed!
Просмотров 1 тыс.6 месяцев назад
Python Crash Course: Part 5 - Python Lists Revealed!
Great Job 💎💎💎
Thank you for the feedback! So glad you liked the video.
Thanks!
My pleasure! I hope you found the video useful.
Just had one question... I looked at the CSV files. And I was wondering how large the original data set is. Meaning I understand that you took data out of a larger data set to create the training set.. and I understand because you put 3,000 in. 3000 from the original data set. Is used for the learning set... Or did I not understand that aspect
The CSVs a are cleaned subset of the original dataset. You can get the original raw data here: archive.ics.uci.edu/dataset/2/adult
Very interesting and helpful. The greedy aspect I struggle with, are there alternatives that combine root nodes or is it a problem that gets solved with larger data sets?
Glad you enjoyed the video! As to your question, what aspect of greedy selection are you struggling with?
@@DaveOnData I just thought the selection of the first that met the criteria would neglect the 2nd, or more parameters that also met the criteria, so could be leaving out key criteria that could inter-relate to future nodes more effectively than the first. I think it’s more of a glaring issue with the contrived example, and probably moot in larger data samples, in which it’s intended to function.
If I understand your concern correctly, one way to think about decision trees' greedy nature is computational complexity. To keep this simple, let's think only about the tree's root node. In an ideal world, the decision tree algorithm would always pick the root note based on the single most optimal combination of dataset and hyperparameter values. However, this is computationally infeasible as the algorithm must search through every possible tree that could be learned before knowing the single best root node.
David! I really like learning with you!! your energy and humor in teaching are all that a student needs!!!! Thanksss
Woohoo! Thank you so much for the kind words, and I'm happy to hear you are finding my content useful.
It is worthless trying to use Python in my company as they would not allow IT any IDE to be installed due to compliance reasons (they block every, everything). So I got into VBA long time ago.
This is precisely why many of my clients are excited by Python in Excel - no local installation is required. Additionally, many of their IT departments are already using Azure, making Python in Excel a very attractive option for them.
I am still a student and i don't have work experience in hr field yet So, would this work with me or i must work firstly in a real jop as an hr then i can transmit
Yes! You can learn valuable data analysis techniques without a job in the field.
Thank you so much! Not only did I learn how to technically do the visualisation, but also some chart types or visualisation approaches I haven't learned so far.
Woohoo! So glad that you found the video useful.
How did I miss this video?
Well, my publishing has been very sporadic lately. FYI - I will release a long-from crash course video this week on decision trees.
@@DaveOnData, I didn't see RUclips's notification it was out. And looking forward to it. Nice to learn instead of teach. Been working with some ABSOLUTELY novice Excel users. So novice that they rate themselves as 7 or 8 in Excel skills and didn't know what a table was and only a couple of them knew about functions and formulas.
very awesome video great job bro!
Thank you! I'm glad you enjoyed the video, and I appreciate the kind words.
GREAT VIDEO!!! I have no experience with Python, but this video (along with all the others) are helping me so much in approaching Python. Very clear explanations. Thank you very much Dave for your invaluable contribution
You are most welcome! I'm stoked to hear you've found my content useful.
I see you never change the Data type. For example the "Family size". Is it ok? Thanks
I Finally mangaed to duplicate this in Power BI. Nearly broke me but I feel like I've got superpowers now :) The formula for 3 way lift however is different from the traditional formula seen elsewhere (Number of A,B, C Occurences / (Total transactions * Fraction of A occurrences * Fraction of B occurrences * Fraction of C occurrences)). This Formula used here seems to be (Number of A,B, C Occurences / (Fraction of A Occurances * Fraction of B&C Occurances). Is there a reason for this? I know this is probably TLDR :D
Hello Dave! Great video! I really liked it. I have tried to do what you showed on the video. I'm stuck at showing the model coefficients and summary in the regression. Can you please help me?
Spreadsheets can do a lot though there’s a reason Python is needed. Nice video
Your videos are so helpful
Woohoo! I'm happy to hear you're finding my content useful.
Hi Dave, I'm just starting the course and realise that I'd need to install this on the company notebook which I don't want to (need to ask for permission etc.) So I'm wondering whether you know if I would run in any limitations using Anaconda cloud notebooks? I seem to have managed to install plotnine there, so I'm hoping it will work :)
While I'm not super familiar with Anaconda cloud notebooks, I can't think of any reason why it will not work if you can install packages.
@@DaveOnData in the end they were simply Jupiter Notebooks online. I managed to do the whole course like this, also with the .csv files. Might not be something for newbies, but for someone who feels comfortable for not having identical view to yours and figuring out where to put the .csv files, it's a great alternative.
PYTHON IS NOW AVAILABLE with my excel version, and I'm not using preview version
Woohoo! Glad to hear it!
Ok...this is the first video on python that made any sense to me! Well done on your style of teaching.
Thank you for the comment! I'm glad you found the video useful.
Hi!, Do you teach certification courses in Python and on what platform?
I don't teach certification courses per se, but I do have an "Introduction to Machine Learning" online course published in partnership with TDWI: bit.ly/TDWIIntroToML
I am coming from sales&marketing background to data analytics & science & machine learning etc. Everything you share is very useful and I can say that this channel will be a bomb!
Excellent! I am so happy to hear you are finding my content useful.
Great Series!!! thanks, love your way of teaching and personallity. Very usefull course. Best Regards from Bolivia
Wow! Thank you so much for the kind words.
You clearly know your stuff, but the excel worksheet is blurry and often unreadable. So I'm having to make sense of much that you are talking about from your verbal description of what you are doing. It might as well be an audiobook instead of a video. Constructive criticism only.
Interesting. I just watched the video, and it was crystal clear. The video was recorded in 1080P.
@@DaveOnData Thank you for your input. My computer did auto adjust to 480p for some ungodly reason. So I was wrong about that part, however, the writing is still very small and I have vision problem after starring a screen to long. It would have been helpful if he would zoom in on the particular chart that his is referring rather than me having to look at all three chart while he's talking about one. I may just be old, blind, cranky, and stupid. good possibility.
I just came across your visualization book today as we are looking to create a Python visualization course at my university. This was a wonderful see!
Woohoo! I am glad to hear that you liked the video.
Here in 2024 really happy to find such amazing tutorial, Thank you Dave, God Bless you
You are most welcome! Glad you are enjoying the tutorial series.
I don't even have python in excel and I don't know why I have finished watching this video. Really nice demonstration
Wow! I take this as quite a compliment. I am happy you enjoyed the content.
Python in Excel is more like Excel in Python. Which, of course, really doesn't work. Good advanced geeky stuff, but useless in 99% of most Excel environments. As David does acknowledge. If you're serious about Excel, don't waste time on Python. For advanced Excel, that really works, Power Query is the way to go! Otherwise, you are coding Python, not Excel...
I'd like to offer this up for consideration. For years, Dr. Wayne Winston has authored books on performing advanced analytics in Excel (e.g., using the Solver). Python in Excel is a much better way to do these things.
Thank you David for your vids. Keep it going bud
You are welcome! They are a lot of work, but I do enjoy making them.
I really appreciate you showing Excel's Python. I follow a lot of Excel channels, and there's not much on it! The reason I'm writing is because several weeks ago I happened to realize the Python section was gone! I'm on the Insider Beta channel. Anyway, it didn't come up until now. I froze your video and tried to customize the Ribbon and discovered the entire Python section was hiding - well not added. If you Right Click on an empty part of the Ribbon and select Customize The Ribbon, in the left column (Choose commands from) drop down, select Main Tabs and then expand Formulas (click the >), and there is the entire Python (Preview) section! On the right side select click the > next to Formulas, click on Defined Names to indicate where the Python section should go after, and then click the [Add >>] button in the middle, and then click [OK]. Just in case anyone viewing this has the problem!
Thank you so much for sharing this! I've heard that some folks have had problems like this, and I'm glad to see you found a resolution.
Am here in 2024 learning. I really appreciate this resources. Thank you Dave. Stay healthy and I wish you happy data sleuthing.
Thank you! I'm glad to hear you are enjoying my content.
Can we cluster text with this method too?
You can cluster text documents using k-means, but the data must be preprocessed first. Check out my Python in Excel videos to learn more.
I want to cluster my ticketexcel from ivanti but I cant code.. is it possible with excel, python and chatgpt?
Yes, but relying on ChatGPT without understanding what's happening with the Python code is asking for trouble. I would strongly suggest taking my Python Crash Course tutorial series to learn the subset of Python you need for analytics and data science.
Incredibly explained video. Super professional but also accessible
Wow! Thank you so much for the kind words. Glad you enjoyed the content.
Hi dave I just downloaded the anaconda thing and then typed the commands on cmd but it tells me that conda is not recognized do you know how to solve this ? is it maybe because of the pathing issues ? Edit: solved it by this video : ruclips.net/video/zFKD2Q9m_nQ/видео.html
Glad to hear you got things sorted!
You know when he apologizes in advance for the length the video will be straight🔥🔥🔥
Thank you for this! It's always a tough choice between creating a single long video vs. many short videos.
Love the videos David! Particularly the structure, delivery, and visual aids.
Thank you so much for taking the time to provide this feedback! So glad you enjoyed the content.
Very helpful video! Can you say if the 100MB data limit is per python query or is that the total for the whole workbook's python code?
I just checked with my contact at Microsoft. It should be 100MB per query.
Hi Dave, it's truly amazing. I got homework from Data Analytics Course, and this is the answer!!!. (I mean not really answer with same dataset), but I can imagine clearly how to solve my homeworks. Thank you so much Dave
Pleasure to be of service! Glad you found the content useful.
Hi Dave, Thank you for the crash course. I've really enjoyed my learning journey so far. I appreciate the focused teaching method, which emphasizes essential skills over covering everything. I noticed that Parts 14 and 15 are ready. When will the next parts be available?
Thank you for the kind words and I am happy to hear you've found my content useful. Parts 14 and 15 are the end of the series but are over 3 hours of content.
Just started my data analysis journey and these videos have been really usefull. Thank you so much.
Woohoo! Glad to hear you found the tutorial series useful.
Hi Dave! This video is very helpful, but i would like to know how you were able to add your existing tables into the power query editor. i am unable to select any other table from the worksheet, only the current one.
wishing for local python. MS is getting access to all that yummy scripts that users develop for them.
Arguably, they've been getting that for years now with Azure. 🤣
I think under the Recency column, the numbers with the lowest number of "Days Since Last Order" should receive the highest i.e. 9.
Thank you, amazing video! I love how you make a 'relatively' complex query look easy and accessible
You are most welcome! Glad you are enjoying the tutorial series.
Great lesson and example!!!!!!!!!!!❤
Thank you for the feedback. I am happy you enjoyed the tutorial!
Amazingly well explained. love your videos. You should have a lot more views!!!
Thank you! Oddly enough, I think this about my videos as well. 🤣
This is really good content, even though am watching it in 2024
Excellent! What I've found is that the fundamentals never go out of style. Glad you found the content useful.
If I may ask, is SQL faster in refresh rate than PowerQuery?
Can you elaborate on what you mean by "refresh rate?"
Great stuff David. You have helped me alot !!!
Wow! Thank you for the comment. I am happy to hear you've found my content useful.
Awesome stuff. very insightful. very clear step by step tutorial. thankyou so much David
My pleasure!
I am stopping half way through your video to tell you that the way you communicate this information in a conversational manner is PURE GOLD. Now onto the rest of this video and others that you have produced 😇
Wow! Thank you so much for the kind words. I am happy to hear that you are enjoying the content.