在，python试图在数据框中删除重复的单词，但获取错误

Question

我正在尝试在我尝试过以下的单元格中删除重复的单词

      Current      Desired
0  John and Jane    John and Jane
1  John and John    John
2  John             John
3  Jane and Jane    Jane

，所需的列被odict _键（['nan']）：

from collections import OrderedDict

df['Current'] = (df['Desired'].astype(str).str.split()
                              .apply(lambda x: OrderedDict.fromkeys(x).keys())
                              .astype(str).str.join(' '))

我也尝试过，但是所需的列填充nan

df['Desired'] = df['Current'].str.replace(r'\b(\w+)(\s+\1)+\b', r'\1')

Answer 1

让我们做split使用set然后 join 返回

df['out'] = df.Current.str.split(' and ').map(lambda x : ' and '.join(set(x)))
df
Out[876]: 
         Current            out
0  John and Jane  Jane and John
1  John and John           John
2           John           John
3  Jane and Jane           Jane