Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Outer Join | Joining Data
course content

Course Content

Data Manipulation using pandas

Outer JoinOuter Join

Let's learn the last type of join - outer join. As you remember, left join keeps all the records from the left table, inner join keeps only records with matching values for both tables. Outer join performs almost an opposite action compared to inner join - it keeps all the records from both tables, and adds data if there are matches.

For instance, we can perform an outer join of the same two tables we used before.

Outer Join

Everything was clear?

Section 5. Chapter 5
course content

Course Content

Data Manipulation using pandas

Outer JoinOuter Join

Let's learn the last type of join - outer join. As you remember, left join keeps all the records from the left table, inner join keeps only records with matching values for both tables. Outer join performs almost an opposite action compared to inner join - it keeps all the records from both tables, and adds data if there are matches.

For instance, we can perform an outer join of the same two tables we used before.

Outer Join

Everything was clear?

Section 5. Chapter 5
some-alt