合并多个csv文件—pandas

import pandas as pd
import os
import warnings
warnings.filterwarnings("ignore")
import numpy as np

Folder_Path = r'C:\Users\lml\Desktop\first\ReHo'
saveFile_Path = r'C:\Users\lml\Desktop\first\ReHo'
saveFile_Name = r'all.csv'
os.chdir(Folder_Path)
file_list = os.listdir()
df=pd.read_csv(Folder_Path + '\\' + file_list[0])

df.to_csv(saveFile_Path + '\\'+saveFile_Name,encoding="utf_8_sig" ,index=False)
for i in range(1,len(file_list)):
    df=pd.read_csv(Folder_Path + '\\' + file_list[i])
    df.to_csv(saveFile_Path+'\\'+saveFile_Name,encoding="utf_8_sig",index=False,mode='a+')
#header=False,表示不保留列索引，会导致缺少两行

AD_ReHo=pd.read_csv("C:/Users/lml/Desktop/first/ReHo/AD_ReHo.csv")
EMCI_ReHo=pd.read_csv("C:/Users/lml/Desktop/first/ReHo/EMCI_ReHo.csv")
LMCI_ReHo=pd.read_csv("C:/Users/lml/Desktop/first/ReHo/LMCI_ReHo.csv")
frames=[AD_ReHo,EMCI_ReHo,LMCI_ReHo]
result=pd.concat(frames,keys=['1','2','3'])