unmatched_last_names = unmatched['PEOPLESURNAME'].apply(lambda x: x.strip().split()[-1]) # Just last surname part print(final_df[final_df['Last_Name'].isin(unmatched_last_names)].head(50))
