如何将数据帧中的特殊字符列表替换为单个字符

Question

我有一个数据帧

data = ["Beer&", "&Whiskey", "Wine()","Tonic$", "Rum*"]

df = pd.DataFrame()
df['Col'] = data

     Col
0   Beer&
1   &Whiskey
2   Wine()
3   Tonic$
4   Rum*

我想用单个字符替换特殊字符列表

spl_char = "$&+:;=?@#|'<>.^*()%!-"
char_list = list(spl_char)

df["Col"] = df["Col"].replace(dict.fromkeys(char_list,  ','))

使用上述语法，我看不到任何更改

当我尝试使用str时，我得到以下错误

df["Col"] = df["Col"].str.replace(dict.fromkeys(char_list,  ','))

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-41-53b53a25fc97> in <module>()
----> 1 df["Col"] = df["Col"].str.replace(dict.fromkeys(char_list,  ','))

/usr/local/lib/python3.7/dist-packages/pandas/core/strings.py in wrapper(self, *args, **kwargs)
   1999                 )
   2000                 raise TypeError(msg)
-> 2001             return func(self, *args, **kwargs)
   2002 
   2003         wrapper.__name__ = func_name

TypeError: replace() missing 1 required positional argument: 'repl'

如何用单个字符替换所有特殊字符

Answer 1

只需将除字母数字以外的所有内容替换为零即可。代码如下

df['Col']= df['Col'].str.replace('[^\w]', '')

      Col
0     Beer
1  Whiskey
2     Wine
3    Tonic
4      Rum