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!

As always, fantastic video Dave.

Python for the data analysis, VBA for controlling getting input data in environments that don't connect Data Verse or other outside data sources. (Think ETL actions across SharePoint/OneDrive locations.) _WS

question: do we need to study power query m code or pandas or both of them ? because I mean if we can use pandas in power query why do we just study pandas

Really liking this video series and your style of teaching. I've been using SQL for a while but looking at it from the lens of Excel give me a new perspective and I'm learning new things. Thanks so much

Awesome video! I’m trying to import a table from the web that has nested table on it, excel even highlights it for me. Unfortunately excel is not allowing me to click on “expand”. Any idea on why this might be happening? Thank you!!

Nice I'm happy that C was my first language to learn because for Python I'm just learning the syntax honestly

I'm excited to start this series!

Xlookup is amazing!

The most useful thing I learned in this video is the way you managed to change the pivot table format, I didn't know you can do that! This will be useful for me

Hey David, Do you think that Multiple regression will do all of this analysis for you by finding which variables has the highest correlation with the results being survival rates? If yes, then what are the disadvantages that are masked when using multiple regression directly without analyzing the data?

Very interesting!

Amazing!