import pandas as pd
khhlist = pd.read_excel('客户号.xlsx')
hmdlist = pd.read_excel('黑名单.xlsx')
khhlist = khhlist[~khhlist['客户号'].isin(hmdlist['黑名单客户'].values)]
renamelist = {'客户号':'优质客户'}
yzkhlist = khhlist.rename(columns=renamelist)
yzkhlist.to_excel('优质客户.xlsx', encoding='utf8')
这个简单，用isin函数，前面加上~取反即可
>>>import re
>>>string = "123我adfasdf?（((q,[]"
>>>string
'123我adfasdf?（((q,[]'
>>>sub_str = re.sub(u"([^\u4e00-\u9fa5\u0030-\u0039\u0041-\u005a\u0061-\u007a])","",string)
>>>sub_str
'123我adfasdfq'
