擅长:python、mysql、java
<p>您可以在<code>merge</code>之前将<code>dropna</code>应用于<code>a12</code>:</p>
<pre><code>In [53]:
a12 = pd.DataFrame({'a':[0, 1], 'b':[1, np.nan], 'c':[1, np.nan]})
try10= pd.DataFrame({'a':[1], 'b':[1], 'c':[1]})
In [54]:
print pd.merge(a12, try10, how='outer', left_on='a', right_on='a')
a b_x c_x b_y c_y
0 0 1 1 NaN NaN
1 1 NaN NaN 1 1
In [55]:
print pd.merge(a12.dropna(0), try10, how='outer')
a b c
0 0 1 1
1 1 1 1
</code></pre>
<p>如果<code>a</code>是索引:</p>
<pre><code>In [57]:
print pd.merge(a12.dropna(0).reset_index(), try10.reset_index(), how='outer').set_index('a')
b c
a
0 1 1
1 1 1
</code></pre>