Map DF1 to another column in DF2


PHOTO EMBED

Fri Feb 05 2021 05:42:18 GMT+0000 (UTC)

Saved by @Ixorya #python

df_mapping['_map'] = df_mapping['name']+df_mapping['address']
df_mapping.set_index('_map',inplace=True)

df_masked['_map'] = df_masked['name']+df_masked['address']
df_masked['company_name'] = df_masked['_map'].map(df_mapping['company_name'].to_dict())
content_copyCOPY