CampusX Data Science Mentorship Program 2022-23 - Session 20 - Merging, Joining & Concatenating | DSMP 2022-23

Session 20 - Merging, Joining & Concatenating | Data Science Mentorship Program (DSMP) 2022-23 Enroll in this Programme from our Website - https://learnwith.campusx.in/ Data Science Mentorship Programme Course 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/1tE0LxbzsVX70y8Br_VxiZas288ODDBup?usp=share_link Notebook Link - https://colab.research.google.com/drive/1Xs7On5fr6ZZnrwGxgMXWld2XUrniqXGj?usp=sharing ------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- | Time stamp | ----------------------- 0:00 Start 2:17 Session Plan 5:41 Dataset Download 12:53 #pd.concat 18:15 #df.append 20:18 #Concat as mullitindex df 26:16 #concat dataframes horizontally 30:38 #Merge 38:51 #inner_join 46:35 #left_join 52:56 #right_join 56:57 #outer_join 59:14 Doubt 1:05:06 # 1. find total revenue generated 1:08:47 # 2. find month by month revenue 1:12:40 Doubt 1:13:38 # 3. Print the registration table 1:16:47 # 4. Plot bar chart for revenue/course 1:20:12 # 5. find students who enrolled in both the months 1:24:34 # 6. find course that got no enrollment 1:27:43 # 7. find students who did not enroll into any courses 1:30:02 Doubt 1:31:03 # 8. Print student name -- partner name for all enrolled students 1:38:10 Doubt 1:40:04 # 9. find top 3 students who did most number enrollments 1:45:19 # 10. find top 3 students who spent most amount of money on courses 1:49:10 Doubt 1:50:04 # Alternate syntax for merge - pd.merge # IPL Problems 1:51:25 # find top 3 stadiums with highest sixes/match ratio 2:01:45 Doubt 2:03:03 # find orange cap holder of all the seasons 2:09:40 Doubt