假设您有这个数据框:
df = pd.DataFrame({'Region':['New York','Los Angeles','Chicago'], 'State': ['NY [new york]', '[California]', 'IL']})
会是这样的:
Region State
0 New York NY [new york]
1 Los Angeles [California]
2 Chicago IL
要删除方括号,您需要以下行:
df['State'] = df['State'].str.replace(r"\[","")
df['State'] = df['State'].str.replace(r"\]","")
结果:
Region State
0 New York NY new york
1 Los Angeles California
2 Chicago IL
如果你想删除方括号及其之间的所有内容:
df['State'] = df['State'].str.replace(r"\[.*\]","")
df['State'] = df['State'].str.replace(r" \[.*\]","")
第一行只是删除方括号之间的字符,第二行考虑字符之前的空格,因此为了确保安全,最好运行这两行。
通过将这两行应用于原始 df:
Region State
0 New York NY
1 Los Angeles
2 Chicago IL