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())