Python for Data Analysts | MERGE datasets | Inner, Right, Left, Outer Joins

You will be exploring how to do different join types in Pandas such left, right, outer and inner join with the MERGE function in python Pandas .
#dataanalysis
#datascience
#joins

You can copy and paste the code to practice
___________________________________________________

df ={'Name': ['Alice','Bob','Charlie','David'],
'CustomerID':[1,2,3,4],
'City':['London','Paris','Berlin','Madrid']}

df2 ={'OrderID':[101,102,103,104],'
CustomerID':[1,1,3,5],'
Product':['Apples','Bananas','Cherries','Dates']}

import pandas as pd
customer =pd.DataFrame(df)
orders =pd.DataFrame(df2)

customer.merge(orders, on='CustomerID', how='outer')

Видео Python for Data Analysts | MERGE datasets | Inner, Right, Left, Outer Joins канала Absent Data