如何使用python合并多个excel文件
Eroeg:
大神,我在使用的你的代码,添加了一个判断文件名的语句,运行没问题,但是加入循环后,提示“zipfile.BadZipFile: File is not a zip file”
[code=python]def append(path,stationname):
filename_excel = []
frames = []
for root, dirs, files in os.walk(path):
for file in files:
if file[:5] == stationname:
file_with_path = os.path.join(root, file)
filename_excel.append(file_with_path)
df = pd.read_excel(file_with_path, engine='openpyxl', skiprows=1)
frames.append(df)
df = pd.concat(frames, axis=0)
df.dropna(axis=0, how='any', inplace=True)[/code]
[code=python]
if __name__ == '__main__':
path1 = r'C:\Users\……\……\data'
stationnames = ['Q8733', 'Q8806', 'Q8604', 'Q8813'……]
for i in stationnames:
df1 = append(path1, i)
[/code]
|