MD5类
# -*- 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")
