Pandas merge function provides functionality similar to database joins. You can merge two data frames using a column. One can perform left, right, outer or inner joins on these dataframes. This tutorial also covers indicator and suffixes flags in pandas.merge function.

Topics that are covered in this Python Pandas Video:
0:00 Introduction
0:42 Merge two dataframes using merge() function
2:34 What is "Outer join" and "inner join" in dataset?
4:03 What is "left join" in dataset?
5:06 Use Indicator flag in join
5:42 How to use "suffixes()" argument in dataframes?

notebook/code used in this tutorial:
github.com/codebasics/py/blob/master/pandas/9_merge/pandas_merge.ipynb

To download csv and code for all tutorials: go to github.com/codebasics/py, click on a green button to clone or download the entire repository and then go to relevant folder to get access to that specific file.

Do you want to learn technology from me? Check codebasics.io/ for my affordable video courses.

Next Video:
Python Pandas Tutorial 10. Pivot table: youtube.com/watch?v=xPPs59pn6qU&list=PLeo1K3hjS3uuASpe-1LjfG5f14Bnozjwy&index=10

Popular Playlist:
Complete python course: youtube.com/playlist?list=PLeo1K3hjS3uv5U-Lmlnucd7gqF-3ehIh0

Data science course: youtube.com/playlist?list=PLeo1K3hjS3us_ELKYSj_Fth2tIEkdKXvV

Machine learning tutorials: youtube.com/playlist?list=PLeo1K3hjS3uvCeTYTeyfe0-rN5r8zn9rw

Pandas tutorials: youtube.com/playlist?list=PLeo1K3hjS3uuASpe-1LjfG5f14Bnozjwy

Git github tutorials: youtube.com/playlist?list=PLeo1K3hjS3usJuxZZUBdjAcilgfQHkRzW

Matplotlib course: youtube.com/playlist?list=PLeo1K3hjS3uu4Lr8_kro2AqaO6CFYgKOl

Data structures course: youtube.com/playlist?list=PLeo1K3hjS3uu_n_a__MI_KktGTLYopZ12

Website: codebasics.io/
Facebook: facebook.com/codebasicshub
Twitter: twitter.com/codebasicshub

• Python Pandas Tutorial 9. Merge Dataframes ( Download)
• Pandas Merge Function | Python Pandas Tutorial #9 | Merge dataframes in Pandas, SQL-Joins in Pandas ( Download)
• Merging DataFrames in Pandas | Python Pandas Tutorials ( Download)
• How to combine DataFrames in Pandas | Merge, Join, Concat, & Append ( Download)
• Merge Pandas Dataframes ( Download)
• 9. Python Joins (Pandas): Merging on Index ( Download)
• Python Pandas Tutorial #9 for Beginners - Plotting Dataframes Using Matplotlib ( Download)
• Python Tutorial: Merging DataFrames with pandas (part 1) ( Download)
• Python Live Streaming 10 hours part 237 ( Download)
• How do I merge DataFrames in pandas ( Download)
• Python Pandas Tutorial: Joining and Merging Pandas DataFrame #13 ( Download)
• Python Pandas Tutorial - Merge Dataframes (Machine Learning) ( Download)
• Pandas: Merge Dataframes on Multiple Columns | Python For Beginners ( Download)
• Learn Python Pandas| Video 9 - merging data using the merge() function ( Download)
• Python for Data Science | Pandas Tutorial - 2 | Data Frame Concatenate | Append | Merge | #9 ( Download)