擅长:python、mysql、java
<p>重新创建示例数据框:</p>
<pre><code>df=pd.DataFrame({'name_0':['Asda','AS-DA','Asda','LIDL1','AAA','AAA','Sainsbury'],
'name_1':[np.nan,np.nan,'Asda','As da','Asda','Asda',np.nan],
'overall_name':['Tesco','ASDA','Lidl1','ASDA','ASDA','Lid1','As da']})
</code></pre>
<p>将浮点转换为字符串:</p>
<pre><code>df=df.fillna('nan')
</code></pre>
<p>删除特殊字符:“-”和“”,注意:需要导入“regex”库</p>
<pre><code>import re
df = df.applymap(lambda x: re.sub(r'-','', x))
df=df.applymap(lambda x: re.sub(r' ','',x))
</code></pre>
<p>创建一个列表:</p>
<pre><code>name_0=df['name_0'].tolist()
name_1=df['name_1'].tolist()
name_concat=name_0+name_1
</code></pre>
<p>取得成果:</p>
<pre><code>df['namematch']=df['overall_name'].str.lower().isin([x.lower() for x in name_concat])
df['namematch']=np.where(df['namematch']==True,'match','nomatch')
</code></pre>