我正在try 使用CONTAINS更改场地名称.为什么容器不起作用？
import pandas as pd
import numpy as np
df = pd.DataFrame([['Table 1 (not in use after 1 Apr 2023)'],
['wefwfe'],
['eqv']],
columns=['Venue'])
print(df)
df['Venue'].loc[df['Venue'].str.contains('Table 1 (not in use after 1 Apr 2023)')] = 'Table'
print(df)
由于使用了圆括号，您的字符串将被视为正则表达式(不匹配)，请使用regex=False:
df.loc[df['Venue'].str.contains('1 (not in use after 1 Apr 2023)', regex=False),
'Venue'] = 'Table'
或者逃离他们:
df.loc[df['Venue'].str.contains(r'1 \(not in use after 1 Apr 2023\)'),
'Venue'] = 'Table'
输出:
Venue
0 Table
1 wefwfe
2 eqv