Merging
Merge DataFrame or named Series objects with a database-style join. The join is done on columns or indexes.
Inner Join
Inner join produces a data set that includes rows from the left table which have matching rows from the right table.
Left Join
Left join produces a dataset that includes all rows from the left table and the matching rows from the right table.
Select the rows that are available only in the left table but not in the right table.
Right Join
Right join produces a dataset that includes all rows from the right table and the matching rows from the left table.
Select the rows that are available only in the right table but not in the left table.
Outer Join
Outer join produces a dataset that contains all rows from both left and right tables.
Select the rows that exist either in the left or right table and exclude the rows that are common to both tables.
