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


This is beginner Python Pandas tutorial #5 and in this video, we’ll be diving into advanced use of groupby() method in pandas python. We’ll be covering the aggregate(), filter(), transform(), and apply() methods and showing a few interactive examples with each method. These methods are applied in conjunction with a groupby() on a pandas dataframe.

Documentation can be found here:
Pandas groupby():
Pandas aggregate():
Pandas transform():
Pandas apply():
Pandas filter():

Let me know if you have any questions and please offer feedback on how I can improve to help you better.

If you enjoyed this video, please throw in a like and subscribe to my channel. I’ll be posting a lot more videos on data science concepts that cover all things python and SQL.

Subscribe to my channel:
Follow along interactively and execute code with me as I walk through the concepts!

Python notebook used in the video:

Datasets can be found here:

After watching the video, test yourself with our python exercises:

Python exercises with solutions:

Here’s help on how to run a python notebook using Google Colabs:

Much of the content was adapted from the book and GitHub of Jake VanderPlas’s Python Data Science Handbook:

Trying to improve your python skills or prepare for your next technical interview? Practice with over 500+ interactive python questions on a full-fledged coding workspace that requires no installation on Strata Scratch – – and use the promo code ‘ss15’ for a 15% discount on the platform!



Comment List

  • Nate at StrataScratch
    November 28, 2020

    That display 3 dataframes function is incredibly useful

  • Nate at StrataScratch
    November 28, 2020

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

  • Nate at StrataScratch
    November 28, 2020

    Very good video, many many thanks!

  • Nate at StrataScratch
    November 28, 2020

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

Write a comment