删除特殊字符python数据框

import re

def remove_special_characters(data_frame):
    pattern = r'[^a-zA-Z0-9\s]'  # 匹配非字母数字字符和特殊符号
    data_frame = data_frame.applymap(lambda x: re.sub(pattern, '', str(x)))  # 对每个元素应用正则表达式替换
    return data_frame

import pandas as pd

# 创建一个包含特殊字符的数据框
data = {'Name': ['John', 'Doe!', 'Jane@', 'Smith'],
        'Age': [25, 30, 35, 40]}
df = pd.DataFrame(data)

# 删除特殊字符
df_cleaned = remove_special_characters(df)

print(df_cleaned)

   Name  Age
0  John   25
1   Doe   30
2  Jane   35
3  Smith  40