擅长:python、mysql、java
<p>一种解决方案是从数据帧中删除顶层(例如<code>cell_1</code>和<code>cell_2</code>),然后合并。在</p>
<p>如果需要,可以保存这些列以在合并后恢复它们。在</p>
<pre><code>c1 = df1.columns
c2 = df2.columns
df1.columns = df1.columns.droplevel()
df2.columns = df2.columns.droplevel()
df_merged = df1.merge(df2, on='t', how='outer', suffixes=['_df1', '_df2'])
df1.columns = c1
df2.columns = c2
>>> df_merged
t sb_df1 sb_df2
0 0 1 NaN
1 2 3 6
2 1 NaN 5
</code></pre>