Outer 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.
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 = 'outer')
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 = 'outer') print(df_res)
Alt var klart?
Takk for tilbakemeldingene dine!
Seksjon 5. Kapittel 5
Spør AI
Spør AI
Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår