擅长:python、mysql、java
<p>通过字典或<code>Series</code>将<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.map.html" rel="nofollow noreferrer">^{<cd1>}</a>与<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.fillna.html" rel="nofollow noreferrer">^{<cd2>}</a>或<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.replace.html" rel="nofollow noreferrer">^{<cd3>}</a>一起使用:</p>
<pre><code>d = dict(zip(df1['lookupinputcol'], df1['lookupoutputcol']))
#alternative solution
#d = df1.set_index('lookupinputcol')['lookupoutputcol']
df['lookup_gender_new'] = df['gender'].map(d).fillna(df['gender'])
</code></pre>
<p>或:</p>
<pre><code>df['lookup_gender_new'] = df['gender'].replace(d)
</code></pre>