Inner 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.


              12345678910
            
# Importing library
import pandas as pd

# Loading data
data1 = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/f2947b09-5f0d-4ad9-992f-ec0b87cd4b3f/section5/data1.csv')
data2 = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/f2947b09-5f0d-4ad9-992f-ec0b87cd4b3f/section5/data2.csv')

# Perform a left join
df_res = data1.merge(data2, on = 'id', how = 'inner')
print(df_res)

Everything was clear?

Thanks for your feedback!

Section 5. Chapter 4

Ask AI

Ask anything or try one of the suggested questions to begin our chat

Course Content

Data Manipulation using pandas

1. Preprocessing Data: Part I

What is Data Preprocessing?Types consistency Poor Data Presentation Manipulating Strings Challenge Replacing Specific Elements Simultaneous Replacement Challenge

2. Preprocessing Data: Part II

Logical Inconsistency Removing Rows Challenge Outliers Challenge Missing Values Filling NA values Challenge

3. Grouping Data

What is Grouping Data?Grouping in pandas [1/2]Challenge Grouping in pandas [2/2]Challenge Grouping by Several Columns Challenge

4. Aggregating and Visualizing Data

Advanced Aggregation [1/2]Challenge Advanced Aggregation [2/2]Challenge Histograms Challenge Bar and Scatter Plots Other Types of Graphs Challenge 1 Challenge 2

5. Joining Data