|
想要合并一个文件夹内的十几个Excel文件,Excel内格式相同,代码如下:import os
import pandas as pd
import xlrd
xlsx_list = [f'TPDG/{xlsx}' for xlsx in os.listdir('TPDG') if not xlsx.startswith('"$')]
df = pd.DataFrame()
for xlsx in xlsx_list:
wb = xlrd.open_workbook(xlsx)
for name in wb.sheet_names():
df = pd.concat([df.pd.read_excel(xlsx,sheet_name=name)])
df.to_excel('Combination_pd.xlsx',sheet_name='Overall')
显示错误:
DataFrame' object has no attribute 'pd'
具体错误如下:
Traceback (most recent call last):
File "D:/Python/Combine Excel 3.py", line 11, in <module>
df = pd.concat([df.pd.read_excel(xlsx,sheet_name=name)])
File "C:\Users\eve.luo\Anaconda3\lib\site-packages\pandas\core\generic.py", line 5139, in __getattr__
return object.__getattribute__(self, name)
AttributeError: 'DataFrame' object has no attribute 'pd'
求助各位大神,怎么改?谢谢!
|
|