擅长:python、mysql、java
<p>对名称列应用拆分函数。请尝试以下代码:</p>
<p><code>import numpy as np</code></p>
<p><code>df.apply(lambda x: x['Name'].split('|', 1)[-1] if x['Age'] > 16 and len(x['Name'].split('|',1))>1 else np.nan, axis=1)</code></p>
<pre><code> Name Age nickname
0 Peter | Jacker 10 NaN
1 John | Parcker 45 Parcker
2 Paul | Cash 14 NaN
3 Tony 65 NaN
</code></pre>