删除字符串中的任何撇号

Question

有人能帮忙吗！py我只是想从数据框中的字符串文本中删除任何撇号，我不确定遗漏了什么

我有定期快递、替换和重命名，但似乎无法摆脱它

country                           designation  points  price  \
0      US                     Martha's Vineyard    96.0  235.0   
1   Spain  Carodorum Selección Especial Reserva    96.0  110.0   
2      US         Special Selected Late Harvest    96.0   90.0   
3      US                               Reserve    96.0   65.0   
4  France                            La Brûlade    95.0   66.0   

         province           region_1           region_2             variety  \
0      California        Napa Valley               Napa  Cabernet Sauvignon   
1  Northern Spain               Toro                NaN       Tinta de Toro   
2      California     Knights Valley             Sonoma     Sauvignon Blanc   
3          Oregon  Willamette Valley  Willamette Valley          Pinot Noir   
4        Provence             Bandol                NaN  Provence red blend   

                    winery  last_year_points  
0                    Heitz                94  
1  Bodega Carmen Rodríguez                92  
2                 Macauley    

df.columns=df.columns.str.replace("''","")
df.Designation=df.Designation.str.replace("''","")
import re
re.sub("\'+",'',df.Designation)
df.rename(Destination={'Martha's Vineyard:'Mathas'}, inplace=True)

Error Message:SyntaxError: invalid syntax

Answer 1

请参阅下面的代码片段，以使用lambda内联函数和字符串对象的replace函数的组合来解决您的问题

df = pd.DataFrame({'Name': ["Tom's", "Jerry's", "Harry"]})
print(df, '\n')

Tom's Jerry's Harry

# Remove any apostrophes using lambda and replace function
df = df['Name'].apply(lambda x: str(x).replace("'", ""))
print(df, '\n')

Toms Jerrys Harry