dir_path = os.path.join("name1", "name2", "name3")
file_list = os.listdir(dir_path)

li = []

for filename in file_list:
    df = pd.read_csv(filename, index_col=None, header=0)
    li.append(df)

final_df = pd.concat(li, axis=0, ignore_index=True)