擅长:python、mysql、java
<p>我们可以基于公共<code>id</code>尝试<a href="https://pandas.pydata.org/docs/reference/api/pandas.Series.map.html" rel="nofollow noreferrer">mapping</a>的<code>parent_id</code>和相应的<code>parent_name</code></p>
<pre><code>df['parent_name'] = df['parent_id'].map(df.set_index('id')['name'])
</code></pre>
<hr/>
<pre><code> id parent_id name parent_name
0 a None Bob NaN
1 b None Jane NaN
2 c a John Bob
3 d b Patty Jane
4 e a Sam Bob
</code></pre>