删除带单词的左括号和右括号

Question

给定数据帧：

df = 

                         multi
0 MULTIPOLYGON(((3 11, 2 33)))
1 MULTIPOLYGON(((4 22, 5 66)))

我试图删除单词'MULTIPOLYGON'和括号'（（（'，'））'

---

我的尝试：

df['multi'] = df['multi'].str.replace(r"\(.*\)","")
df['multi'] = df['multi'].map(lambda x: x.lstrip('MULTIPOLYGON()').rstrip('aAbBcC'))

df.values = 

array([[''],
       [''],
       ...
       [''],
       [''],
       [''],
       ['7.5857754821 44.9628409423']

---

期望输出：

df = 

     multi
3 11, 2 33
 4 22, 5 6

Answer 1

也可以将^{}与正则表达式一起使用：

# removes anything that's not a digit or a space or a dot
df['multi'] = df.multi.str.replace('[^0-9\. ]', '', regex=True)#changing regex