MD5加密类

MD5类

• 传入输入excel，以及输出excel路径。

# -*- coding: utf-8 -*-

"""
Created on Tue Oct  9 18:14:21 2018
    Environment  of  Python 3.x
@author: gao
"""

import hashlib
import pandas as pd

#### Define md5 #######

def md5(val):
            return hashlib.md5(val.encode('utf-8')).hexdigest()
###   utf-8  <==> gb18030  
###Define data of md5 #####
def data_md5(inputFile,outputFile):

  data = pd.read_excel(inputFile,eocoding = 'gb18030',dtype = str)

  for i in data[['id','cell','name']].columns:
    data[i+'_md5'] = (data[i].apply(md5))
###del md5 of nan ######
  data[data == 'a3d2de7675556553a5f08e4c88d2c228'] = ""
  data.to_excel(outputFile,sheet_name='Data',index_label=["index"])


if __name__ == '__main__':

   data_md5(r"D:\Test.xlsx","md5_data.xlsx")