如何用列中的另一个字符串替换子字符串

Question

我的专栏如下：

df['name']
1                              react trainer
2                              react trainers
3                              react trainer's

我需要将琴弦训练器/训练器更换为训练器：

1                              react trainer
2                              react trainer
3                              react trainer

Answer 1

df['name'].str.replace(to_replace ='trainer.*', value = 'trainer', regex = True)

Answer 2

df['name'].str.replace('trainer(\'?s)*', 'trainer')

Answer 3

如果您希望同时查找包含此子字符串的行并返回子字符串本身，则应该使用regex。我在下面

import re

def return_substr(string,substring)
  #Check substring
  if re.search(substring,string):
     return(substring)
  #If not found, return ‘’
  else:
     return(‘’)

#Use apply to run this row by row
df[‘replaceCol’] = df[‘Name’].apply(lambda x: return_substr(x,’react trainer’), axis=1)