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.
@michaelt312Күн бұрын
How did I miss this video?
@RichardRebeles2 күн бұрын
very awesome video great job bro!
@LC-tq7bb5 күн бұрын
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
@luigibru86776 күн бұрын
I see you never change the Data type. For example the "Family size". Is it ok? Thanks
@pillslifestylereviews67147 күн бұрын
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
@BernardPhilippe-jx8zm10 күн бұрын
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?
@predictiveanalyst12 күн бұрын
Spreadsheets can do a lot though there’s a reason Python is needed. Nice video
@matthewnye206121 күн бұрын
Your videos are so helpful
@DaveOnData20 күн бұрын
Woohoo! I'm happy to hear you're finding my content useful.
@user-uo5wz9hq8i23 күн бұрын
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 :)
@DaveOnData23 күн бұрын
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.
@Dexter101x24 күн бұрын
PYTHON IS NOW AVAILABLE with my excel version, and I'm not using preview version
@DaveOnData23 күн бұрын
Woohoo! Glad to hear it!
@spongebobby18825 күн бұрын
Ok...this is the first video on python that made any sense to me! Well done on your style of teaching.
@DaveOnData23 күн бұрын
Thank you for the comment! I'm glad you found the video useful.
@dicamre8026 күн бұрын
Hi!, Do you teach certification courses in Python and on what platform?
@DaveOnData23 күн бұрын
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
@emree259826 күн бұрын
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!
@DaveOnData23 күн бұрын
Excellent! I am so happy to hear you are finding my content useful.
@pedroluisalcazar928526 күн бұрын
Great Series!!! thanks, love your way of teaching and personallity. Very usefull course. Best Regards from Bolivia
@DaveOnData23 күн бұрын
Wow! Thank you so much for the kind words.
@RohbertWhite29 күн бұрын
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.
@DaveOnData29 күн бұрын
Interesting. I just watched the video, and it was crystal clear. The video was recorded in 1080P.
@RohbertWhite29 күн бұрын
@@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.
@kimberlyford482529 күн бұрын
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!
@DaveOnData29 күн бұрын
Woohoo! I am glad to hear that you liked the video.
@eunicen4250Ай бұрын
Here in 2024 really happy to find such amazing tutorial, Thank you Dave, God Bless you
@DaveOnData29 күн бұрын
You are most welcome! Glad you are enjoying the tutorial series.
@hk_200kАй бұрын
I don't even have python in excel and I don't know why I have finished watching this video. Really nice demonstration
@DaveOnDataАй бұрын
Wow! I take this as quite a compliment. I am happy you enjoyed the content.
@datastop400Ай бұрын
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...
@DaveOnDataАй бұрын
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.
@johncatsicas101Ай бұрын
Thank you David for your vids. Keep it going bud
@DaveOnDataАй бұрын
You are welcome! They are a lot of work, but I do enjoy making them.
@jerrydellasala7643Ай бұрын
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!
@DaveOnDataАй бұрын
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.
@eunicen4250Ай бұрын
Am here in 2024 learning. I really appreciate this resources. Thank you Dave. Stay healthy and I wish you happy data sleuthing.
@DaveOnDataАй бұрын
Thank you! I'm glad to hear you are enjoying my content.
@enanta7Ай бұрын
Can we cluster text with this method too?
@DaveOnDataАй бұрын
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.
@enanta7Ай бұрын
I want to cluster my ticketexcel from ivanti but I cant code.. is it possible with excel, python and chatgpt?
@DaveOnDataАй бұрын
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.
@beeson7110Ай бұрын
Incredibly explained video. Super professional but also accessible
@DaveOnDataАй бұрын
Wow! Thank you so much for the kind words. Glad you enjoyed the content.
@abdurahmanchokri1054Ай бұрын
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 : kzfaq.info/get/bejne/sKx7d5WCntPDnoU.html
@DaveOnDataАй бұрын
Glad to hear you got things sorted!
@brentjamison3602Ай бұрын
You know when he apologizes in advance for the length the video will be straight🔥🔥🔥
@DaveOnDataАй бұрын
Thank you for this! It's always a tough choice between creating a single long video vs. many short videos.
@jacobmaguffee7300Ай бұрын
Love the videos David! Particularly the structure, delivery, and visual aids.
@DaveOnDataАй бұрын
Thank you so much for taking the time to provide this feedback! So glad you enjoyed the content.
@perrinmsАй бұрын
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?
@DaveOnDataАй бұрын
I just checked with my contact at Microsoft. It should be 100MB per query.
@panduislami7832Ай бұрын
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
@DaveOnDataАй бұрын
Pleasure to be of service! Glad you found the content useful.
@mangeshshinde5779Ай бұрын
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?
@DaveOnDataАй бұрын
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.
@davoyesh4551Ай бұрын
Just started my data analysis journey and these videos have been really usefull. Thank you so much.
@DaveOnDataАй бұрын
Woohoo! Glad to hear you found the tutorial series useful.
@SMILE__6208Ай бұрын
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.
@shinjiriggedАй бұрын
wishing for local python. MS is getting access to all that yummy scripts that users develop for them.
@DaveOnDataАй бұрын
Arguably, they've been getting that for years now with Azure. 🤣
@empaulstube6947Ай бұрын
I think under the Recency column, the numbers with the lowest number of "Days Since Last Order" should receive the highest i.e. 9.
@quentinvandevondel3230Ай бұрын
Thank you, amazing video! I love how you make a 'relatively' complex query look easy and accessible
@DaveOnDataАй бұрын
You are most welcome! Glad you are enjoying the tutorial series.
@user-us1jn2dl4cАй бұрын
Great lesson and example!!!!!!!!!!!❤
@DaveOnDataАй бұрын
Thank you for the feedback. I am happy you enjoyed the tutorial!
@shout-styleАй бұрын
Amazingly well explained. love your videos. You should have a lot more views!!!
@DaveOnDataАй бұрын
Thank you! Oddly enough, I think this about my videos as well. 🤣
@eunicen4250Ай бұрын
This is really good content, even though am watching it in 2024
@DaveOnDataАй бұрын
Excellent! What I've found is that the fundamentals never go out of style. Glad you found the content useful.
@christophernazareno9114Ай бұрын
If I may ask, is SQL faster in refresh rate than PowerQuery?
@DaveOnDataАй бұрын
Can you elaborate on what you mean by "refresh rate?"
@eunicen4250Ай бұрын
Great stuff David. You have helped me alot !!!
@DaveOnDataАй бұрын
Wow! Thank you for the comment. I am happy to hear you've found my content useful.
@eunicen4250Ай бұрын
Awesome stuff. very insightful. very clear step by step tutorial. thankyou so much David
@DaveOnDataАй бұрын
My pleasure!
@PS-zw4giАй бұрын
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 😇
@DaveOnDataАй бұрын
Wow! Thank you so much for the kind words. I am happy to hear that you are enjoying the content.
@theautisticsideАй бұрын
Done, woohoo! Thanks so much Dave!
@DaveOnDataАй бұрын
Yessssssss! You are welcome and I hope this tutorial series proves useful to you.
@theautisticsideАй бұрын
Took your crash courses and they are fab. Your explanations are much easier to understand than most of what I've encountered in my self-teaching journey.
@DaveOnDataАй бұрын
Wow! Thank you so much for this. I take it as quite the compliment.
@theautisticside2 ай бұрын
Like_thousand = 👍 * 1000
@DaveOnDataАй бұрын
Woohoo! Glad you like the tutorial - even though it is a long one.
@hudsonstokes75392 ай бұрын
Love your content. Been following along with your crash course. Thanks alot! soo keen to get stuck into using python in excel. 😁
@DaveOnData2 ай бұрын
Woohoo! Thank you so much for the kind words. I am glad you are finding my content useful.
@hudsonstokes75392 ай бұрын
@@DaveOnData I do have a followup question too. Currently i use excel to do the majority of my job, will python in excel actually make things easier rather than mainly using formulas, especially with big data sets?
@everything_strength2 ай бұрын
just use python since you can always do more if you have to
@DaveOnDataАй бұрын
This can be problematic for many professionals. For example, many cannot install Python locally due to IT restrictions.
@shanabenjamin89452 ай бұрын
Thanks! You clarified the issues I had!❤
@DaveOnData2 ай бұрын
Yay! I am happy to hear that you found the video useful.