擅长:python、mysql、java
<h3>设置</h3>
<pre><code>df1 = pd.DataFrame({'Col1': 1, 'Col2': 2}, [*'abcdgh'])
df2 = pd.DataFrame({'Col3': 3, 'Col4': 4}, [*'abefgh'])
</code></pre>
<h3><code>join</code></h3>
<p>使用<code>outer</code></p>
<pre><code>df1.join(df2, how='outer')
Col1 Col2 Col3 Col4
a 1.0 2.0 3.0 4.0
b 1.0 2.0 3.0 4.0
c 1.0 2.0 NaN NaN
d 1.0 2.0 NaN NaN
e NaN NaN 3.0 4.0
f NaN NaN 3.0 4.0
g 1.0 2.0 3.0 4.0
h 1.0 2.0 3.0 4.0
</code></pre>