擅长:python、mysql、java
<p>正如@sushanth所指出的,将<code>pd.concat()</code>与<code>join='inner'</code>一起使用。以下是一个例子:</p>
<pre><code>import pandas as pd
df1 = pd.DataFrame({'a': [1, 2, 3],
'b': [4, 5, 6],
'c': [7, 8, 9]})
df2 = pd.DataFrame({'b': [11, 12, 13],
'c': [14, 15, 16],
'd': [17, 18, 19]})
t = pd.concat([df1, df2], axis=0, join='inner')
print(t)
b c
0 4 7
1 5 8
2 6 9
0 11 14
1 12 15
2 13 16
</code></pre>
<p>更多信息请点击此处:</p>
<ul>
<li><a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.concat.html" rel="nofollow noreferrer">https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.concat.html</a></li>
<li><a href="https://pandas.pydata.org/pandas-docs/stable/user_guide/merging.html" rel="nofollow noreferrer">https://pandas.pydata.org/pandas-docs/stable/user_guide/merging.html</a></li>
</ul>