How to select names with the same transcriptions?

Question

JavaScript

There is a pandas dataframe with two columns (see photo): the first is the names of people in English, the second is their phonetic transcription (using the nysiis dictionary). How can you select names with the same transcriptions from it?

names = pd.concat(pieces,ignore_index = True)
a=names['name'].unique()
b=list(a)
q=[]
for n in b:
    q.append(fuzzy.nysiis(n))
    
df=pd.DataFrame(b)
df1=pd.DataFrame(q)
w=df.join(df1, how='left', lsuffix='_left', rsuffix='_right')

Answer 1

Try like this:
df[df.duplicated(['0_right'], keep=False)]