在python中使用regex替换数据帧值中的某些关键字

Question

我有一个数据框来存储与汽车相关的信息，我正在尝试替换某些键“[Pink&；蓝色]“至”[粉色&；蓝色]“使用regex删除中间的空格，但我的代码无法做到这一点：

Cars = {'Brand': ['Honda Civic','Toyota Corolla','Ford Focus'],
        'Price': [22000,np.nan,35000] ,
        'Product Summary' : ['color is [Pink & Blue] size is 14' ,'color is [Pink & Yellow] size is 10','color is [Red & Black] size is 11']
    }
df = DataFrame(Cars,columns= ['Brand', 'Price', 'Product Summary'])
df['Product Summary'] = df['Product Summary'].replace(r'\b & ',"&")

Answer 1

使用^{}访问器

df['Product Summary'] = df['Product Summary'].str.replace(' & ', '&')

或者在代码中使用regex=True

df['Product Summary'] = df['Product Summary'].replace(r'\b & ', '&', regex=True)