擅长:python、mysql、java
<p>我更喜欢<code>str.extract</code>:</p>
<pre><code>df['depth'] = df['a'].str.extract(f"({'|'.join(depts)})").fillna("Unknown")
</code></pre>
<p>或:</p>
<pre><code>df['depth'] = df['a'].str.extract('(' + '|'.join(depts) + ')').fillna("Unknown")
</code></pre>
<p>两个代码都输出:</p>
<pre><code>>>> df
a depth
0 ewfefPHYS PHYS
1 QWQiPSYCH PSYCH
2 fwfew Unknown
>>>
</code></pre>