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:
https://github.com/codebasics/py/blob...
To download csv and code for all tutorials: go to https://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 https://codebasics.io/ for my affordable video courses.
Next Video:
Python Pandas Tutorial 10. Pivot table: • Python Pandas Tutorial 10. Pivot table
Popular Playlist:
Complete python course: • Python 3 Programming Tutorials for Be...
Data science course: • Data Science Full Course For Beginner...
Machine learning tutorials: • Machine Learning Tutorial Python | Ma...
Pandas tutorials: • Pandas Tutorial (Data Analysis In Pyt...
Git github tutorials: • Git/Github Tutorial
Matplotlib course: • Matplotlib tutorial
Data structures course: • Data Structures And Algorithms In Python
Website: https://codebasics.io/
Facebook: / codebasicshub
Twitter: / codebasicshub
On this page of the site you can watch the video online Python Pandas Tutorial 9. Merge Dataframes with a duration of hours minute second in good quality, which was uploaded by the user codebasics 27 May 2017, share the link with friends and acquaintances, this video has already been watched 247,017 times on youtube and it was liked by 4 thousand viewers. Enjoy your viewing!