If you want to merge on DataFrame with another DataFrame based on the similarity between 2 columns, use df.merge.
My previous tips on pandas.