擅长:python、mysql、java
<h3>使用<code>pd.concat</code></h3>
<pre><code>pd.concat([df, df2], sort=False)[df.set_index('index').columns].reset_index(drop=True)
colx coly colz
0 45 35.0 54
1 22 NaN 11
</code></pre>
<h3>使用<code>pd.merge</code></h3>
<pre><code>pd.merge(df,df2, how='outer')[df.set_index('index').columns]
colx coly colz
0 45 35.0 54
1 22 NaN 11
</code></pre>