擅长:python、mysql、java
<p>可以使用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.concat.html" rel="noreferrer">concat([df1, df2, ...], axis=1)</a>将两个或多个按索引对齐的df连接起来:</p>
<pre><code>pd.concat([df1, df2, df3, ...], axis=1)
</code></pre>
<p>或者<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.merge.html" rel="noreferrer">merge</a>用于通过自定义字段/索引连接:</p>
<pre><code># join by _common_ columns: `col1`, `col3`
pd.merge(df1, df2, on=['col1','col3'])
# join by: `df1.col1 == df2.index`
pd.merge(df1, df2, left_on='col1' right_index=True)
</code></pre>
<p>或<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.join.html" rel="noreferrer">join</a>通过索引连接:</p>
<pre><code> df1.join(df2)
</code></pre>