擅长:python、mysql、java
<p>您可以使用regex<code>(^|;) *Credit(;|$)</code>来确保模式在分隔符之间是独占的,因此<em>Credit</em>将位于字符串的开头或结尾,或者直接跟在分隔符<code>;</code>后面:</p>
<pre><code>df
index locations
0 39951 Credit; Mount Pleasant GO
1 40976 Ajax GO; Whitby GO; Credit; Oshawa GO; Bayly
2 14961 Mount Pleasant GO; Port Credit GO
df.locations.str.contains('(^|;) *Credit(;|$)')
#0 True
#1 True
#2 False
#Name: locations, dtype: bool
</code></pre>
<p>如果要进一步忽略大小写,请将修饰符<code>?i</code>添加到模式中:</p>
<pre><code>df.locations.str.contains('(?i)(^|;) *credit(;|$)')
#0 True
#1 True
#2 False
#Name: locations, dtype: bool
</code></pre>