擅长:python、mysql、java
<p>使用列表理解和<code>re.findall</code>:</p>
<pre><code>import re
df['Country'] = ["".join(re.findall(r'inf(.*?)_', i)) for i in df['Name']]
print(df)
Name Country
0 inf.negem.netmgmt
1 infbe_cdb be
2 inf_igh
3 INF_EONLOG
4 inf.dkprime.netmgmt
5 infaus_mgo aus
6 infau_abr au
</code></pre>