Advanced Use of groupby(), aggregate, filter, transform, apply - Beginner Python Pandas Tutorial #5

Content is interesting, it’s a carbon copy of material being described in the “Data Science Handbook” from Jake VanderPlas, now you have the option to read or watch the video.

can you please drop a link to download the dataset 'planets'? That would really help me. Thank you :)

Hard to read the screen. Plz zoom in when recording.
Clear explanations. Thanks

its 2023, did you guys record this with a potato?

you are truly talented, the superb teaching quality of your method is by far better (and more effective with entry level people like myself) than most of what can be found in the YT sphere these days
most grateful , immediately subscribed

What is x in x['data2'] ? is it df? if so why when x is the cell value in the transform sectiom

In filter function, filter function is applied on groupby object. How it returned rows from original dataset ?

Thank you, very useful

Thank you for the explanation. What's the difference between transform() and apply()?

Thank you^^

Great thanks

The way you explain and manually breakdown the methods is amazing. I do not have a software background, only basic experience with for, while, and if-else loops in C. I am able to easily understand each method due to the structure of your presentation. I subscribed to your channel after this video. Hope to see more of you and see your channel grow.

Great video, if you could increase the volume somehow that'd be great though.

great works keep going dude

Love the videos. I became a premium member on SS and subbed to the channel. I've seen a huge improvement in my sql AND python skills !

It would be nice to add more questions like leetcode does where maybe you restrict some questions to only using UPDATE or DELETE FROM or even some practice questions where we create tables

Nice one, I was not able to understand groupby section from Jake Vandreplas's python data science handbook but your video helped me out, could you please take the planet data set example and use two keys to groupby, it is a bit tricky to understand, Thank you

thanks

Thanks a lot. Really clear.

Nice video

Thank you so much!! I was fighting with groupby and apply!

How to create html pdf reports after data cleaning to send client please make vedio

the way it is explaning everything is really awesome. Thanks you for nice vedio!!!

Hi Nate,

I was practicing '3 Bed Minimum Problem' on the website and although I managed to solve the question in SQL, I am really struggling with the Pandas Solution. Could you please make a video on it or provide the solution? Also, I would really appreciate if in your future videos you could solve the same problem in both SQL and Pandas.

HI Bro,
My requirement is, I have to group by key and key column with column name 'key' and data2 column with name data2 and I need sum value of data1.
Kindly share your ideas

Please help as I have data of employees in which they did multiple sale, I want if any employee did sale more the 50000 againt it each emp I'd of that person print excellent rest low.
Like
Emp I'd. Sale status
Emp1001 5000. Excellent
Emp1001 45000. Excellent
Emp1001 2000. Excellent
Emp1002 5000. Low
Emp1003 2500. Low

That display 3 dataframes function is incredibly useful
thanks

Thank you for this information. The apply method example has helped me with my project

Very good video, many many thanks!

looking forward sql and other python vid, thanks for the content