course content

Course Content

Data Manipulation using pandas

Inner JoinInner Join

Both left and right joins return all the records from one of the tables (despite having no matches). Is there kind of join that will return records that have matching values in both tables.

To perform an inner join, use the .merge() method with the how = 'inner' parameter. For instance, let's perform an inner join of previously used two tables.

Inner Join

Section 5.

Chapter 4