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())
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter