作者:晰mine | 来源:互联网 | 2023-09-02 18:00
#!usrbinpython#-*-coding:UTF-8-*-importpandasaspdimportosif__name__'__main__':Fo
#!/usr/bin/python
# -*- coding: UTF-8 -*-
import pandas as pd
import os
if __name__ == '__main__':
Folder_Path = 'c:\data1'
os.chdir(Folder_Path)
file_list = os.listdir()
dfs = []
for item in file_list:
dfs.append(pd.read_excel(Folder_Path + '\\' + item))
df = pd.concat(dfs, sort=False)
df.to_excel('c:\data1\out.xlsx', index=False)