import glob, os import re file = glob.glob(os.path.join(r'G:\data\stock\2', "*.csv")) dl = [] for f in file: dl.append(pd.read_csv(f)) df = pd.concat(dl, axis=0, ignore_index=True)