1 回答

TA貢獻1820條經驗 獲得超2個贊
創建一個替換系列,然后與可選參數一起s使用,將 中的值替換為 中的相應值:Series.replaceregex=TrueRepStrs
s = df.set_index('KeyStr')['ValStr']
s.index = r'(?:(?<=;\s)|(?<=^))' + s.index + r'(?=;|$)'
df['RepStr'] = df['RepStr'].replace(s, regex=True)
0 Sean Connery
1 Sean Connery
2 Sean Connery
3 Sean Connery; Ernst Stavro Blofeld
4 Sean Connery; Roger Moore; Ernst Stavro Blofeld
5 R Moore R
6 Roger Moore
7 Roger Moore
8 Ernst Stavro Blofeld; Sean Connery; Roger Moore
9 Ernst Stavro Blofeld; Sean Connery
10 Ernst Stavro Blofeld
11 Ernst Stavro Blofeld
12 Ernst Stavro Blofeld; Sean Connery
Name: RepStr, dtype: object
添加回答
舉報