5 ай бұрын
7 ай бұрын
7 ай бұрын
Пікірлер
@JohnCannie 9 сағат бұрын
Most important I learned where Python runs! What was missing is that VBA is a cross Office tool. For example I wrote a tool which read email then worked on the excel attachment and then sent out emails. You can also access word and powerpoint with VBA.
@mfarouk1984 18 сағат бұрын
THANK YOU DAVID SIR IF I FILTER DATA IS IT POSSABLE TO GET CORRLATION FOR NEW FILTERED DATA WITH OUT MAKE NEW PROSSESS
@houstonvanhoy7767 2 күн бұрын
Presentation is a little blurry between 47:51 and 48:10, and at 59:18. Otherwise, fine.
@DaveOnData 2 күн бұрын
Just watched that section using Incognito mode and saw no blurring.
@markparry1922 2 күн бұрын
Very useful, concise and cogent explanation. Many thanks,Dave.
@DaveOnData 2 күн бұрын
You are most welcome! I'm glad to hear that you found the video useful.
@michaelhoney1973 2 күн бұрын
Thanks David
@DaveOnData 2 күн бұрын
You are welcome! I hope you found the video useful.
@nexomatematico7272 2 күн бұрын
Excellent video, thank you
@DaveOnData 2 күн бұрын
You are welcome! I'm happy to hear that you are finding my content useful.
@edwardgrigoryan3982 3 күн бұрын
Thanks for this great video! I'm a product manager/data analyst at a small startup focused on chronic pain. I want to upskill into data science/ML over the next couple of years. Right now I'm doing some basic (but still useful!), just descriptive stats and basic inferential stats, but I'm really excited to learn and apply these kinds of techniques to our data in the future, as we have a very rich and unique data set on chronic pain patients. The examples you provided really helped me see the relevance.
@DaveOnData 2 күн бұрын
Woohoo! I'm so glad to hear that you found the video useful.
@houstonvanhoy2198 3 күн бұрын
Dave: I've viewed other Python videos, and in frustration I looked around until I found yours. I really appreciate that you have expanded your mouse pointer to be large and filled in with black - just like my mouse pointer. Great minds think alike. Most online instructors just use the default tiny white mouse pointer, which CANNOT BY SEEN clearly, especially when the pointer is moved quickly and then pointed to a white area on a white background. You get it. 👍
@DaveOnData 3 күн бұрын
I can't actually take credit for that. It's a Mac thing. 🤣
@houstonvanhoy7767 3 күн бұрын
@@DaveOnData I use Windows. It works there, also. I've experienced that some of the editing parts on your video vary widely from what I experience on my Chrome browser on Windows. I shall persevere. I'll have to view the Jupyter videos. I have to assume that Anaconda, and Jupyter in particular, have been update since you recorded this video. I am following along with your video; some of the Python commands work exactly as you demonstrate, other Python commands don't work at all. That's life in the digital world. 🤔
@BeardsleyBrandon 3 күн бұрын
Thank you David! You’re an expert breaking down complex elements into understandable steps! I’m teaching myself Media Mix Modeling and would love to hear your thoughts on MMM and what techniques you’d use.
@DaveOnData 2 күн бұрын
Glad you liked the video! Unfortunately, I don't have any experience with MMM. The little that I do know is that linear regression models are often used for MMM.
@ricebeansrockroll882 3 күн бұрын
Thank you for clearly naming the chapters, it will help me so much comming back!
@DaveOnData 3 күн бұрын
You are welcome! I hope you find my content useful.
@michaelt312 3 күн бұрын
Awesome information as usual. #ForTheAlgorithm
@callmebymyname643 3 күн бұрын
Thanks David, your content helped me a lot - love from India
@DaveOnData 3 күн бұрын
You are most welcome! I'm glad to hear you've found my content useful.
@shnam928 5 күн бұрын
Sounds cool, thanks. How could this help with ap/ar tasks automation?
@DaveOnData 3 күн бұрын
As I'm not familiar with AP/AR tasks, I wouldn't be able to comment. That being said, I know that Finance professionals often use VBA to help automated their Excel-centric processes.
@sydneysalisburry4938 5 күн бұрын
Johnson Daniel Johnson Matthew Moore James
@DaveOnData 3 күн бұрын
Thank you for suggesting the video! Much appreciated.
@HugginsAmy-d3h 6 күн бұрын
White Timothy Williams Richard Martin Patricia
@DaveOnData 3 күн бұрын
Thank you for suggesting the video! Much appreciated
@JaneJuliet-m9x 9 күн бұрын
Miller Ruth Anderson Maria Walker Mark
@DaveOnData 3 күн бұрын
Thank you for suggesting the video! Much appreciated
@timepassp9042 9 күн бұрын
Very Nice and Simple explanation. Appreciate your effort
@DaveOnData 3 күн бұрын
Thank you for taking the time to leave this comment! The kind words are appreciated.
@ShyamKakkad-cs4dl 10 күн бұрын
by far the best teacher on youtube.
@DaveOnData 10 күн бұрын
Whoa! That's a huge compliment. Thank you. These words are much appreciated.
@ShyamKakkad-cs4dl 10 күн бұрын
@@DaveOnData no, thank you for all the good content. it's hard to find good teachers through all of the saturation
@michaelt312 10 күн бұрын
When you have a meeting starting any moment and David drops a new video... Will be playing on the Bluetooth headset now and watching it later. #ForTheAlgorithm
@DaveOnData 10 күн бұрын
Woohoo! The support, as always, is greatly appreciated. The algo does love watch time. 🤣
@sjifdrhkotyamberutlku-j9q 10 күн бұрын
Clark Barbara Taylor Dorothy Moore Jose
@DaveOnData 10 күн бұрын
Thank you for suggesting the video! Much appreciated.
@DoloresRichardson-n8q 11 күн бұрын
Jones Sandra Hall Charles Taylor Donna
@DaveOnData 10 күн бұрын
Thank you for suggesting the video! Much appreciated.
@rexevan6714 12 күн бұрын
I suddenly remember you, sir. First time seeing you at DataScienceDojo talk years ago. ;)
@DaveOnData 12 күн бұрын
Ha! Yes, I worked at Data Science Dojo back in 2017.
@AttleeMolly-j1g 14 күн бұрын
Alejandra Island
@DaveOnData 12 күн бұрын
Thank you for suggesting the video! Much appreciated.
@BartonBaird-l2m 16 күн бұрын
Hall Karen Walker George Martinez Cynthia
@DaveOnData 12 күн бұрын
Thank you for suggesting the video! Much appreciated.
@VastCNC 16 күн бұрын
Sorry to sidechain here, but I’m ordering the now you see it book and wanted to get a couple more while I’m at it. I know you had a video a while back that had some critical book recommendations but I’m failing to find it.
@VastCNC 16 күн бұрын
Making Sense of Data (expensive even used) and Effective Data Storytelling are the two I found searching through some linked in posts. Any other high level books that I can read away from my keyboard would be welcome.
@DaveOnData 16 күн бұрын
"Making Sense of Data" is my all-time favorite data analysis book, but can be hard to get. A cheaper, but not as thorough, option is "Measures of Success" by Mark Graban.
@DavGre 17 күн бұрын
I’m taking a ML class, this is very timely.
@DaveOnData 17 күн бұрын
I hope you find my content useful! Good luck with your class.
@DavGre 17 күн бұрын
@@DaveOnDatathank you! Actually, my class is in ML for investment strategies. Now, I know that’s a very complex topic with a lot of overlap with finance/economics, but if you have videos on feature selection and dimension reduction?
@DaveOnData 17 күн бұрын
@DavGre - I don't have videos on feature selection/engineering, but I do cover those topics in my online course. I rarely use dimension reduction (e.g., PCA) in my ML work because I use decision tree-based techniques (e.g., the mighty random forest) that don't require it.
@lorenzoplaserrano8734 17 күн бұрын
this is awesomeee ❤
@DaveOnData 17 күн бұрын
Thank you for taking the time to comment! I am happy to hear you enjoyed the video.
@michaelt312 17 күн бұрын
And the day is now looking up. #ForTheAlgorithm
@DaveOnData 17 күн бұрын
Woohoo! Thank you for the support and I hope you enjoy the video.
@rianalee3138 18 күн бұрын
Great explanation! Thank you
@DaveOnData 18 күн бұрын
You are most welcome! Glad you enjoyed the tutorial.
@Data_Mom 19 күн бұрын
Superb video and explanation and learnt a lot with this Pandas crash course. Thanks Dave. I do have two questions: 1) Once we wrangle the data, how can we make these changes permanent? 2) do we need to know which attributes and methods we need to write? I mean when you write DataFrame or column name, the methods and attributes associated with it are not shown (as a dropdown), they need to be typed explicitly.
@LockeIda 19 күн бұрын
Clark Jose White Scott Perez Brian
@DaveOnData 18 күн бұрын
Thank you for suggesting the video!
@torque6389 19 күн бұрын
Like button smashed ;)
@DaveOnData 18 күн бұрын
Woohoo! Glad you enjoyed the video.
@VastCNC 20 күн бұрын
The feeling you get at 2:17:00 into the video and your non null count for the joined table isn't the same as Dave's. :^\
@DaveOnData 20 күн бұрын
Hmmmmmm. Problem?
@VastCNC 20 күн бұрын
@@DaveOnData lol. My inner join resulting df had different value counts. This late in the game bug chasing that would have been a challenge in itself. Visualizations and skew looked comparable, magnitude was just a little off. I think I missed a filtering lambda some where.
@eternalharmony-978 21 күн бұрын
Thank you so much for this....
@DaveOnData 21 күн бұрын
You are most welcome! Glad you enjoyed the video.
@sebastienroux4246 21 күн бұрын
Thanks, and nice tee-shirt ! 🤟
@DaveOnData 21 күн бұрын
Glad you liked the video and the Iron Maiden shirt! 🤘
@MohamedMueen-w4l 22 күн бұрын
Well done. Thx
@DaveOnData 22 күн бұрын
Thank you for the comment, and I'm so glad you enjoyed the video!
@VastCNC 24 күн бұрын
Thank you! Another top shelf video. I’ve been going through the Python course and listening to these next level courses when I’m not in front of my keyboard. Thank you so much for leveling up my skills.
@DaveOnData 24 күн бұрын
You are most welcome. Thank you so much for taking the time to leave this comment! It is much appreciated.
@erolbrown 24 күн бұрын
This is absolute gold. So clearly explained.
@DaveOnData 24 күн бұрын
Thank you for the feedback! Glad you enjoyed the video.
@fouadmaizar2914 24 күн бұрын
Thanks David.
@DaveOnData 24 күн бұрын
You are most welcome! I hope you found the crash course useful.
@alexrosen8762 24 күн бұрын
Brilliant!
@DaveOnData 24 күн бұрын
Woohoo! I'm happy to hear you enjoyed the video
@michaelt312 24 күн бұрын
Video drops as my train pulls into my stop. Playing in the background, but I already know I'll like it. #ForTheAlgorithm
@DaveOnData 24 күн бұрын
Thank you so much for taking the time to comment. As always, your support for my channel is greatly appreciated.
@roya8683 25 күн бұрын
Really amazing explanation David beautiful work.
@DaveOnData 24 күн бұрын
Wow! Thank you so much for the kind words. Glad to hear you enjoyed the video.
@crispindeleon1930 Ай бұрын
I subbed. But for now and will be chasing after anything sql related. Thanks a bunch bro!
@DaveOnData 29 күн бұрын
You are welcome! I hope you find my content useful.
@crispindeleon1930 9 күн бұрын
@@DaveOnData of course man! Every single one of them. Ty very much!
@RealSkkyy Ай бұрын
Great Job 💎💎💎
@DaveOnData Ай бұрын
Thank you for the feedback! So glad you liked the video.
@rbjassoc6 Ай бұрын
Thanks!
@DaveOnData Ай бұрын
My pleasure! I hope you found the video useful.
@rbjassoc6 Ай бұрын
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
@DaveOnData Ай бұрын
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
@VastCNC Ай бұрын
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?
@DaveOnData Ай бұрын
Glad you enjoyed the video! As to your question, what aspect of greedy selection are you struggling with?
@VastCNC Ай бұрын
@@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.
@DaveOnData Ай бұрын
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.
@paularamirez9102 Ай бұрын
David! I really like learning with you!! your energy and humor in teaching are all that a student needs!!!! Thanksss
@DaveOnData Ай бұрын
Woohoo! Thank you so much for the kind words, and I'm happy to hear you are finding my content useful.
@albertojohnycortizo8959 Ай бұрын
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.
@DaveOnData Ай бұрын
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.
@johnsamir-jm3jx Ай бұрын
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
@DaveOnData Ай бұрын
Yes! You can learn valuable data analysis techniques without a job in the field.
@Halliinnchuks Ай бұрын
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.
@DaveOnData Ай бұрын
Woohoo! So glad that you found the video useful.