Pandas Full Join

PHOTO EMBED

Mon May 09 2022 12:53:57 GMT+0000 (Coordinated Universal Time)

Saved by @Thapelo_99 #python

pd.merge(product,customer,on='Product_ID',how='outer')
content_copyCOPY

Full Join, also known as Full Outer Join, returns all those records which either have a match in the left or right dataframe. When rows in both the dataframes do not match, the resulting dataframe will have NaN for every column of the dataframe that lacks a matching row.

https://www.analyticsvidhya.com/blog/2020/02/joins-in-pandas-master-the-different-types-of-joins-in-python/