文本中指定字段加密处理为md5值

ll104567

root@lp:~/jw/python/data# cat phone_md5.txt
1@@@13660888666@@@2019-09-08 23:29:00
2@@@13660888777@@@2019-09-08 23:29:00
3@@@13660888888@@@2019-09-08 23:29:00
root@lp:~/jw/python/data# python md5_phone.py
root@lp:~/jw/python/data# cat md5_phone.py
import pandas as pd
import hashlib


def md5(x):
     a = hashlib.md5()
     a.update(str(x).encode())
     return a.hexdigest().upper()


a = pd.read_csv('phone_md5.txt',sep='@@@',header=None,engine='python',names=['id','phone','time'])
a['phone'] = a.phone.apply(md5)
a.to_csv('md5.csv',index=None,header=None)
root@lp:~/jw/python/data#
root@lp:~/jw/python/data# cat md5.csv
1,47B473CF198BA182B20CF3A02FEFA87C,2019-09-08 23:29:00
2,A2BA33550D924FD0714370D0AB255B78,2019-09-08 23:29:00
3,6FEEE6C1F7740F2758278514ED261338,2019-09-08 23:29:00