import pandas as pd
import re
df = pd.read_excel('g://test.xlsx')
def re_num(s):
patter="((\d{11,})|(\d{11})|^((\d{7,8})|(\d{4}|\d{3})-(\d{7,8})|(\d{4}|\d{3})-(\d{7,8})-(\d{4}|\d{3}|\d{2}|\d{1})|(\d{7,8})-(\d{4}|\d{3}|\d{2}|\d{1}))$)"
phone_list=re.compile(patter).findall(s)
s_1 = set(phone_list)
s2 = []
for e in s_1:
s2+=e
s3 = set(s2)
for ss in s3:
if ss != '':
s = s.replace(ss,ss[0:3]+'****'+ss[7:])
return s
df['te'] = ''
df['te'] = df.apply(lambda x:re_num(x['c1']), axis=1)
df.to_csv('g://test_result.csv')
python对excel数据文本中的电话号码进行脱敏处理
最新推荐文章于 2024-05-13 14:54:22 发布