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/prev...

YouTube Playlist -    • CampusX Data Science Mentorship Program 20...  
-------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------
Datasets used in the session -
https://drive.google.com/drive/folder...

Notebook Link - https://colab.research.google.com/dri...
-------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------
| 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