masking string and phone number for dataframe in python pandas

Question

Here I am trying to mask a data frame/dataset which have columns both integers and String values like this:

sno,Name,Type 1,Type 2,phonenumber
1,Bulbasaur,Grass,Poison,9876543212
2,Ivysaur,Grass,Poison,9876543212
3,Venusaur,Grass,Poison,9876543212

This is the code I am using,below code is working fine for string values it is masking well but for integers it is not masking:

import pandas as pd

filename = "path/to/file"
columnname= "phonenumber"
valuetomask = "9876543212"

column_dataset1 = pd.read_csv(filename)

print(column_dataset1)


# if(choice == "True"):
#masking for particular string/number in a column
column_dataset1[columnname]=column_dataset1[columnname].mask(column_dataset1[columnname] == valuetomask,"XXXXXXXXXX")
print(column_dataset1)
# masking last four digits
column_dataset1[columnname]=column_dataset1[columnname].str[:-4]+"****"
print(column_dataset1)

The above code is perfectly working for strings but when I gave "phonenumber"(any integer value) column it is not working.

Note: I need to do full masking(whole value should be masked) and partial masking(i.e last three digits/characters or first three digits/characters from above file) for any file which is given.

Corralien · Accepted Answer · 2021-09-17 06:34:36Z

1

Convert to str and replace last four digits:

>>> df['phonenumber'].astype(str).str.replace(r'\d{4}$' , '****', regex=True)

0    987654****
1    987654****
2    987654****
Name: phonenumber, dtype: object

Which is the same of what @babakfifoo suggested:

>>>  df['phonenumber'].astype(str).str[:-4] + '****'
0    987654****
1    987654****
2    987654****
Name: phonenumber, dtype: object

answered Sep 17, 2021 at 6:34

Corralien

121k8 gold badges44 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Babak Fi Foo · Accepted Answer · 2021-09-17 10:37:22Z

0

Convert your phone numbers to string and then try masking:

mask_len = 5 # length of digits to mask from right side
column_dataset1['phonenumber'] = (
    column_dataset1['phonenumber'].astype(str) # convert to string
        .str[:-mask_len]+"*" * mask_len # masking digits
)

edited Sep 17, 2021 at 10:37

answered Sep 17, 2021 at 5:44

Babak Fi Foo

1,0789 silver badges20 bronze badges

2 Comments

bhavishya alla Over a year ago

I tried this but not able to mask data, can you please help in masking too

Babak Fi Foo Over a year ago

Masking is added. you can find comprehensive masking answer here: stackoverflow.com/questions/52408105/masking-part-of-a-string/…

Collectives™ on Stack Overflow

masking string and phone number for dataframe in python pandas

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related