擅长:python、mysql、java
<p>您可以<a href="https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.replace.html" rel="nofollow noreferrer"><strong>^{<cd1>}</strong></a>指定特殊字符,并使用<a href="https://pandas.pydata.org/docs/reference/api/pandas.Series.str.contains.html" rel="nofollow noreferrer"><strong>^{<cd2>}</strong></a>检查匹配项:</p>
<pre class="lang-py prettyprint-override"><code>B.B = B.B.replace(r'[^a-zA-Z]', '', regex=True)
B['match'] = B.B.apply(lambda b: A.A.str.contains(b, flags=re.IGNORECASE).any())
# B match
# 0 ABc True
# 1 ghj False
# 2 Xyz True
# 3 BNM True
</code></pre>
<p>然后对<code>B.match</code>和<code>~B.match</code>使用布尔索引:</p>
<pre class="lang-py prettyprint-override"><code>B = B[B.match][['B']]
# B
# 0 ABc
# 2 Xyz
# 3 BNM
</code></pre>
<pre class="lang-py prettyprint-override"><code>non = B[~B.match][['B']]
# B
# 1 ghj
</code></pre>