Hashing/Encryption using Python

[susukavi]

Team,

I need to encrypt one column in my table.This table contains 5 million records.I am using python code to encrypt .Currently to encrypt 1 million records it takes more than 3 hrs.Given below my code used for encryption.

df = Alteryx.read('#1')
df['MaskedID'] = [hashlib.sha256(str.encode(str(i))).hexdigest() for i in df["ID"]]
df.head()
df = df.drop('ID' , 1)
Alteryx.write(df, 1)

Need your help in improving the run time.

P.S--I need to do this with alteryx only and also should use sha256 hashing

[BrandonB]

Have you tried it in R? I just used the example in the post here and it ran in about 10 minutes for 10 million records on my computer (depends on your computer specs) : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-do-i-SHA-256-Hash-and-other-hashin...