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.

How did I miss this video?

very awesome video great job bro!

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

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

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 :)

PYTHON IS NOW AVAILABLE with my excel version, and I'm not using preview version

Ok...this is the first video on python that made any sense to me! Well done on your style of teaching.

Hi!, Do you teach certification courses in Python and on what platform?

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!

Great Series!!! thanks, love your way of teaching and personallity. Very usefull course. Best Regards from Bolivia

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.

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!

Here in 2024 really happy to find such amazing tutorial, Thank you Dave, God Bless you

I don't even have python in excel and I don't know why I have finished watching this video. Really nice demonstration

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...

Thank you David for your vids. Keep it going bud

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!

Am here in 2024 learning. I really appreciate this resources. Thank you Dave. Stay healthy and I wish you happy data sleuthing.

Can we cluster text with this method too?

I want to cluster my ticketexcel from ivanti but I cant code.. is it possible with excel, python and chatgpt?

Incredibly explained video. Super professional but also accessible

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

You know when he apologizes in advance for the length the video will be straight🔥🔥🔥

Love the videos David! Particularly the structure, delivery, and visual aids.

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?

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

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?

Just started my data analysis journey and these videos have been really usefull. Thank you so much.

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.

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

Great lesson and example!!!!!!!!!!!❤

Amazingly well explained. love your videos. You should have a lot more views!!!

This is really good content, even though am watching it in 2024

If I may ask, is SQL faster in refresh rate than PowerQuery?

Great stuff David. You have helped me alot !!!

Awesome stuff. very insightful. very clear step by step tutorial. thankyou so much David

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 😇

Done, woohoo! Thanks so much Dave!

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.

Like_thousand = 👍 * 1000

Love your content. Been following along with your crash course. Thanks alot! soo keen to get stuck into using python in excel. 😁

just use python since you can always do more if you have to

Thanks! You clarified the issues I had!❤