Hands-On Exploratory Data Analysis with Python

Using the pd.merge() method with a left join

The third option is to use the pd.merge() method with the left join technique. By now, you should have understood the concept of a merge. The argument of the pd.merge() method allows us to use different types of joins.

These are the following types of joins:

• The inner join takes the intersection from two or more dataframes. It corresponds to the INNER JOIN in Structured Query Language (SQL).
• The outer join takes the union from two or more dataframes. It corresponds to the FULL OUTER JOIN in SQL.
• The left join uses the keys from the left-hand dataframe only. It corresponds to the LEFT OUTER JOIN in SQL.
• The right join uses the keys from the right-hand dataframe only. It corresponds to the RIGHT ...