Merge DataFrames (make sure to specify suffix for readability)

PHOTO EMBED

Sun Sep 18 2022 12:32:10 GMT+0000 (Coordinated Universal Time)

Saved by @hquizzagan #python

df_merged = df1.merge(df2, on=['colName'], suffixes=('_mens', '_womens'))
content_copyCOPY

It is a good practice to always specify with useful identifiers the suffixes of columns from each dataframe being merged.