Right Join
Another type of join is the right one. This join is literally the same as the left join, but with swapped tables (i.e., to perform a right join of table1 to table2 is literally the same as left join of table2 to table1). To perform a right join, set the how = 'right'
parameter.
So both data1.merge(data2, on = 'id', how = 'right')
and data2.merge(data1, on = 'id', how = 'left')
will return the same result (with changed order of columns).
99
1
2
3
4
5
6
7
8
9
10
# 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 = 'right')
print(df_res)
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 = 'right') print(df_res)
Tout était clair ?
Merci pour vos commentaires !
Section 5. Chapitre 3
Demandez à l'IA
Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion