擅长:python、mysql、java
<p>或者根据耶斯雷尔的回答创建<code>dict</code>:</p>
<pre><code>d = dict(zip(df1['lookupinputcol'], df1['lookupoutputcol']))
</code></pre>
<p>然后使用<code>apply</code>:</p>
<pre><code>df['lookup_gender'] = df.apply(lambda x: d.get(x['gender'],x['gender]),axis=1)
</code></pre>