Video

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 : czcams.com/video/zFKD2Q9m_nQ/video.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!❤

Do you prefer Plotnine over Seaborn now?

A great and practical introduction to Jupiter. Now, I feel ready to learn Python. Thank you.

Data tables are Objects? Regardless of the number of columns(attributes) and you can also access and calculate any of them. That is awesome!

Hi Dave on Data. Incredible, your site is just what I was looking for. Python in Excel. I have been using Excel for a long time! Mainly, for data collection, transferring to Statistical( Minitab, SPSS, Excel and R)and visualisation packages( Surfer and Grapher). I started with Lotus 123! I still do data interpretation using those tools and they are really time consuming. Most of my data are historical river water quality analysis and sediment transportation data. I will do your Python Crash Course. Thank you for sharing your knowledge and expertise.

hi, actually i have a doubt while in conditional column i am not able to fetch the suitable column under column name. can u please provide solution for this.

Thank you for a well-explained topic...

Great video. Very informative to me with no coding/programming experience.

Great

Python, VBA, M, SQL, Dax, even Excel worksheet functions - all great tools to me.

New version of excel completely changed the look and layout of this. Does not look nor operate the same way as shown in this video. I have to use this for a class and I am extremely frustrated lol

Thanks for the video! But what if the measures in different columns are way different? Lets say, we have spend in thousand dollars and some other parameter in Sq meters? Is it correct to say that we would need first to normalize date, to bring to some comparable values?

Super like!

Hi Dave, which version of Excel are you using in this video? thanks

Cool coool super cooool

Dziękujemy.

A great start to my Python adventure. Thank you for a great style of teaching 👌🙏👌

For the Pclass can you have it say stowaway if it doesn’t equal 1,2, or 3 example =IF(C2=1,”First”,IF(C2=2,”Second”,IF(C2=3,”Third”,”Stowaway”)

With your assistance Dave, I have quickly determined that your crash course is right for me, for my career goals, through the continued development of data analysis skills via Python. With a yottabyte full of thanking you, thank you Dave

utterly superb. you got a course on altruism too? Wow.

Love the method chaining with assign - I'm always looking for new tips! Only difference in my workflow would be to shift the lines within the chaining parens to be under the new object with an indent to better use that white space as linters yell if lines get too long. Not sure if that's 'standard practice', but I like that pattern.

Two days in a row with videos from you!! My brain will implode with this new knowledge.

Great stuff David! Thanks for the video .

Using 5k to 100k rows is easy....try to run a pivot on 900 thousand row and see how excel will spin for 30 min....

The video we knew we needed but didn't think anyone would ever give us. THANK YOU!!

Could you please provide Excel which you have used in this video!? Sir

no way a 3hr tutorial on pandas!