converting character or integer to md5 hash using python script

Question

I used SQL to convert a social security number to MD5 hash. I am wondering if there is a module or function in python/pandas that can do the same thing.

My sql script is:

CREATE OR REPLACE FUNCTION MD5HASH(STR IN VARCHAR2) RETURN VARCHAR2 IS
  V_CHECKSUM VARCHAR2(32);

BEGIN
  V_CHECKSUM := LOWER(RAWTOHEX(UTL_RAW.CAST_TO_RAW(SYS.DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_ST    RING => STR))));
  RETURN V_CHECKSUM;
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    NULL;
  WHEN OTHERS THEN
    RAISE;
END MD5HASH;

SELECT HRPRO.MD5HASH('555555555') FROM DUAL

thanks.

I apologize, now that I read back over my initial question it is quite confusing.

I have a data frame that contains the following headings:

df[['ssno','regions','occ_ser','ethnicity','veteran','age','age_category']][:10]

Where ssno is personal information that I would like to convert to an md5 hash number and then create a new column into the dataframe.

thanks... sorry for the confusion.

Right now I have to send my file to Oracle and then convert the ssn to hash and then export back out so that I can continue working with it in Pandas. I want to eliminate this step.

Have you tried googling python md5? Second result for me is: docs.python.org/2/library/hashlib.html — cel
– cel, Commented Jan 28, 2015 at 11:36
Isn't this simply hashlib.md5(ssn).hexdigest()? Though sha256 would be a better choice. — belteshazzar
– belteshazzar, Commented Jan 28, 2015 at 11:39
@timkofu: I think david wants to use MD5 to be compatible with his existing SQL code. But I could be totally wrong. :) In which case, SHA256 would be a better choice if he needs the extra security it affords. — PM 2Ring
– PM 2Ring, Commented Jan 28, 2015 at 11:45
@timkofu: thank you for the response. I do not want to use the SQL code. It is an extra step in my process that I would like to eliminate. — Dave
– Dave, Commented Jan 28, 2015 at 13:37

PM 2Ring · Accepted Answer · 2015-01-28 11:51:33Z

2

Using the standard hashlib module:

import hashlib

hash = hashlib.md5()
hash.update('555555555')
print hash.hexdigest()

output

3665a76e271ada5a75368b99f774e404

As mentioned in timkofu's comment, you can also do this more simply, using

print hashlib.md5('555555555').hexdigest()

The .update() method is useful when you want to generate a checksum in stages. Please see the hashlib documentation (or the Python 3 version) for further details.

edited Jan 28, 2015 at 11:51

answered Jan 28, 2015 at 11:39

PM 2Ring

55.6k6 gold badges96 silver badges202 bronze badges

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

Comments

user123 · Accepted Answer · 2015-01-28 12:15:27Z

1

hashlib with md5 might be of your interest.

import hashlib
hashlib.md5("Nobody inspects the spammish repetition").hexdigest()

output:

bb649c83dd1ea5c9d9dec9a18df0ffe9

Constructors for hash algorithms that are always present in this module are md5(), sha1(), sha224(), sha256(), sha384(), and sha512().

If you want more condensed result, then you may try sha series

output for sha224:

'a4337bc45a8fc544c03f52dc550cd6e1e87021bc896588bd79e901e2'

For more details : hashlib

edited Jan 28, 2015 at 12:15

answered Jan 28, 2015 at 11:40

user123

5,42516 gold badges79 silver badges126 bronze badges

1 Comment

cel Over a year ago

My point is: He explicitly asked for the solution for a md5 hash. Your answer is a little bit confusing because for some reason you focus on sha224.

Collectives™ on Stack Overflow

converting character or integer to md5 hash using python script

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related