Pandas Merge Function | Python Pandas Tutorial #9 | Merge dataframes in Pandas, SQL-Joins in Pandas
The Pandas merge function provides functionality similar to SQL joins, allow you to merge dataframes on a single or multiple columns. You'll learn how to create left, right, outer, and inner joins on dataframes and how to apply indicators to your resulting dataframe.
0:00 Introduction
0:38 SQL Join Types
2:50 Pandas Merge Function Overview
5:00 Pandas Merge Function Join Types (Left, Right, Outer, Inner)
6:25 Pandas Merge Function Indicator Argument
7:05 Pandas Merge on Multiple Keys
10:10 Conclusion
Download the datasets here:
https://github.com/datagy/mediumdata/...
https://github.com/datagy/mediumdata/...
Learn Python programming the right way!
----------------------------------------------------------
✅ Check out my eBook to get started with Python for Data Science: https://gumroad.com/l/introtopythonfo...
✅ Follow me on other platforms:
Website: https://datagy.io
Twitter: / datagyio
Mailing List: https://mailchi.mp/f6a58f2d73d0/datag... (and get a FREE Pandas tip and tricks book and a FREE Guide to SQL)
