Python merge CSV file

Merge csv file

import os
import pandas as pd
# Enter the folder where the files to be merged are located 
path = r'D:/work/BP/5/'
file_list = []
for file in os.listdir(path):
# print(file)
df = pd.read_csv(path + file)
file_list.append(df)
result = pd.concat(file_list) # Merge files 
result.to_csv(path + 'hard_5.csv', index=False) # Save the merged file 

Each... Will be removed when merging csv First row header of