循环列和
replace的解决方案:
import pandas as pd
data = pd.DataFrame({'A':['(1)','2','3'],'B':['(B) 77','s gg','d'],'C':['s','(d) 44','f']})
print (data)
A B C
0 (1) (B) 77 s
1 2 s gg (d) 44
2 3 d f
for col in data:
data[col] = data[col].str.replace(r'\(.*\)','')
print (data)
A B C
0 77 s
1 2 s gg 44
2 3 d f
列表理解和concat的解决方案:
data = pd.concat([data[col].str.replace(r'\(.*\)','') for col in data],axis=1)
print (data)
A B C
0 77 s
1 2 s gg 44
2 3 d f