擅长:python、mysql、java
<ul>
<li><code>merge()</code>或<code>join()</code>将与列<strong>后缀一起使用</strong></li>
<li>使用数据来<code>fillna()</code></li>
<li>完成后删除不需要的列</li>
</ul>
<pre><code>df_have1 = pd.DataFrame({'age':[7,34,19], 'gender':['F',np.nan,'M'], 'profession':['student', 'CEO', 'artist']})
df_have2 = pd.DataFrame({'age':[7,34,19], 'gender':['np.nan','F',np.nan], 'interests':['acting', 'cars', 'gardening']})
df_need = (df_have1.join(df_have2, rsuffix="_r")
.assign(gender=lambda dfa: dfa.gender.fillna(dfa.gender_r))
.drop(columns=["age_r","gender_r"])
)
</code></pre>
<div class="s-table-container">
^{tb1}$
</div>