This is beginner Python Pandas tutorial #7 and in this video, we dive into the merge() method to join multiple Pandas dataframes together. We start with a simple example to explain the default behavior of the merge() method. Then we dive into the different parameters of the merge() method. First, we cover how to specify columns in the merge() method using different parameters related to the ‘on’ parameter like ‘left_on’ and ‘right_on’. Then we cover how to merge on indices using the ‘left_index’ and ‘right_index’. Last we cover the mixing the two parameters.
Next, we cover different merge types by explaining the ‘how’ parameter and what the different values the ‘how’ parameter takes such as ‘inner’, ‘outer’, ‘left’, ‘right’. I would suggest you take a read on SQL JOINs to better understand the concepts dealing with the ‘how’ parameter ( w3schools.com/sql/sql_join.asp).
Documentation can be found here:
Pandas merge: pandas.pydata.org/pandas-docs/stable/merging.html
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: bit.ly/2WOgqil
------------------------------------------
Follow along interactively and execute code with me as I walk through the concepts!
Python notebook used in the video: bit.ly/2M2RjDr
Datasets can be found here: bit.ly/3gsZdUS
After watching the video, test yourself with our python exercises: bit.ly/2B50Jw8
Python exercises with solutions: bit.ly/3c3X2DL
Here’s help on how to run a python notebook using Google Colabs: bit.ly/2YXKR8o
Much of the content was adapted from the book and GitHub of Jake VanderPlas’s Python Data Science Handbook: jakevdp.github.io/PythonDataScienceHandbook/
------------------------------------------
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 - stratascratch.com - and use the promo code ‘ss15’
- merge() Method to Join Multiple Pandas Dataframes - Beginner Python Pandas Tutorial #7 ( Download)
- How to combine DataFrames in Pandas | Merge, Join, Concat, & Append ( Download)
- Merging Multiple DataFrames | Merging More Than Two DataFrames | Conditional Merge | Advance Level ( Download)
- Python Pandas Tutorial: Joining and Merging Pandas DataFrame #13 ( Download)
- Combine Data with Pandas concat - Learn Python Pandas #4 ( Download)
- 6 - Merge, Join, Concat, Append using Pandas | Comprehensive Pandas Tutorial for Beginners ( Download)
- How do I merge DataFrames in pandas ( Download)
- Group By and Aggregate Functions in Pandas | Python Pandas Tutorials ( Download)
- Python Tutorial: Merging DataFrames with pandas (part 1) ( Download)
- Best Programming Languages #programming #coding #javascript ( Download)
- Merge, Join, Append, Concat - Pandas ( Download)
- Loop / Iterate over pandas DataFrame (2020) ( Download)
- Python Pandas Tutorial 7. Group By (Split Apply Combine) ( Download)
- How to Reshape Dataframes | Pivot, Stack, Melt and More ( Download)
- Pull Data From Pandas DataFrames - Pandas For Machine Learning 4 ( Download)
