CampusX Data Science Mentorship Program 2022-23 - Session 19 - GroupBy Object in Pandas | Data Science Mentorship Program (DSMP) 2022-23

Data Science Mentorship Program (DSMP) 2022-23 Enroll in this Programme from our Website - https://learnwith.campusx.in/ Course Website Link - https://campusx1040.graphy.com/s/preview/courses/CampusX-Data-Science-Mentorship-Program#6376dbd8e4b065a4cadac4db YouTube Playlist - https://www.youtube.com/playlist?list=PLKnIA16_RmvbAlyx4_rdtR66B7EHX5k3z ------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------- Datasets used in the session - https://drive.google.com/drive/folders/1IiMIOGCv-giUV_rtF02sImgkaVuAQxkz?usp=share_link Notebook Link - https://colab.research.google.com/drive/1JZwTCZp2kbiTACzcuXmWq_FL-GRNo9ym?usp=sharing ------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- | Time stamp | ----------------------- 0:00 Start 2:44 Website Update 5:33 Session Start 8:15 GroupBy 14:20 # Applying builtin aggregation fuctions on groupby objects 21:02 # find the top 3 genres by total earning 25:49 # find the genre with highest avg IMDB rating 27:23 # find director with most popularity 29:32 # find the highest rated movie of each genre 31:49 # find number of movies done by each actor 35:00 Doubts # GroupBy Attributes and Methods 37:34 # find total number of groups -- len 39:01 # find items in each group -- size 40:36 # first()/last() / nth item 43:04 # get_group / vs filtering 45:35 # groups attribute 47:20 # describe / # sample / # nunique 52:55 Doubt Clearance 55:17 # agg method - passing dict 59:28 # agg method - passing list 1:02:26 Doubts 1:03:00 # looping on groups 1:07:24 # find the highest rated movie of each genre 1:11:20 Doubts 1:13:04 # apply -- builtin function 1:15:37 # find number of movies starting with A for each group 1:21:40 # find ranking of each movie in the group according to IMDB score 1:25:38 # find normalized IMDB rating group wise 1:30:57 Doubts 1:32:45 # groupby on multiple cols 1:35:47 # find the most earning actor -- director combo 1:37:26 # find the best(in-terms of metascore(avg)) actor -- genre combo 1:40:01 # agg on multiple groupby 1:42:17 Doubts 1:43:52 IPL Dataset 1:46:30 # find the top 10 batsman in terms of runs 1:49:42 # find the batsman with max no of sixes 1:52:30 # find batsman with most number of 4's and 6's in last 5 overs 1:56:12 Doubts 1:57:09 # find V Kohli's record against all teams 2:00:40 # Create a function that can return the highest score of any batsman 2:05:00 Doubts