用python dataframe[duplicate]中其他行中的关键字掩盖一个列值

Question

my dataframe, data, looks like this


ID        Query                                 email                    phone
1         hi                                    []                       []
2         email is [e-mail]          [[e-mail]]    []
3         phone no is 12345678790               []                       [12345678790]

I want to create a column called masked query which will look like this

ID        Query                                 email                    phone               masked_query
1         hi                                    []                       []                  [hi]
2         email is [e-mail]          [[e-mail]]    []                  [email is XXXXXXXXXXXXXXXXXXX]
3         phone no is 12345678790               []                       [12345678790]       [phone no is XXXXXXXXXX]

我使用regex函数创建了email和phone列，我需要创建一个函数来创建这个列'masked_query'并屏蔽数据，但我不知道如何继续屏蔽数据。感谢任何帮助。

Answer 1

from math import ceil

def masking(string, perc=0.6):
    chars = ceil(len(string) * perc)
    return f'{"X" * chars}{string[chars:]}'

df['masked_query'] = df.Query.apply(masking)

备选方案2

df['masked_query'] = df.Query.apply(lambda x:re.sub('\w+@\w+.com|\d+',len(re.findall('\w+@\w+.com|\d+',s)[0]) * 'X', x)
               if re.findall('\w+@\w+.com|\d+',x) else x)

不确定这是不是你要找的。