python做excel多表按列合并_如何在Python中合并具有不同表列的Excel表？

我有一些不同列的excel表格，如下所示：Table A: Col1 Col2 Col3

Table B: Col2 Col4 Col5

Table C: Col1 Col6 Col7

我的最后一张桌子应该是：Table Final: Col1 Col2 Col3 Col4 Col5 Col6 Col7

如果没有特定列的详细信息，则应保持空白。我一次只成功地执行了合并两个表的操作，但我希望将所有表合并在一起。在

这是合并两个工作表的代码：import pandas as pd

import numpy as np

import glob

df = pd.read_excel('C:/Users/Am/Downloads/sales-mar-2014.xlsx')

status = pd.read_excel('C:/Users/Am/Downloads/customer-status.xlsx')

all_data_st = pd.merge(df, status, how='outer')

all_data_st.to_excel('C:/Users/Am/Downloads/a1.xlsx',header=True)

这是我为合并两个以上的工作表而编写的代码：

^{pr2}$

这是我得到的错误：Traceback (most recent call last):

File "E:/allfile.py", line 7, in

all_data = all_data.merge(pd.read_excel(f), how='outer')

File "C:\Users\Am\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\core\frame.py", line 6868, in merge

copy=copy, indicator=indicator, validate=validate)

File "C:\Users\Am\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\core\reshape\merge.py", line 47, in merge

validate=validate)

File "C:\Users\Am\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\core\reshape\merge.py", line 524, in __init__

self._validate_specification()

File "C:\Users\Am\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\core\reshape\merge.py", line 1033, in _validate_specification

lidx=self.left_index, ridx=self.right_index))

pandas.errors.MergeError: No common columns to perform merge on. Merge options: left_on=None, right_on=None, left_index=False, right_index=False