擅长:python、mysql、java
<p>要使用<code>pd.concat</code>获得预期的输出,两个数据帧中的列名应该相同。这是怎么做的</p>
<pre><code># Create a 1:1 mapping of sheet10 and sheet20 columns
cols_mapping = dict(zip(sheet20.columns, sheet10.columns))
# Rename the columns in sheet20 to match with that of sheet10
sheet20_renamed = sheet20.rename(cols_mapping, axis=1)
concatenated = pd.concat([sheet10, sheet20_renamed])
</code></pre>