合并小文件
(不处理各文件表头数据)
import os
import pandas as pd
path = r'D:\jz'
os.chdir(path)
csv_files = [file for file in os.listdir(path) if file.rfind('csv') != -1]
all_data=pd.DataFrame()
for file in csv_files:
df=pd.read_csv(os.path.join(path,file),sep='\,',engine='python')
all_data=all_data.append(df)
all_data.to_csv('a.csv',index=False)