import pandas as pd

import numpy as np

import os

files = os.listdir(directory_path)

directory_path = 'put your path here'

dfs = []

# Loop through each file, read it as a dataframe and append to the list

for file in files:

    if file.endswith('.csv'):

        full_file_path = os.path.join(directory_path, file)

        df = pd.read_csv(full_file_path)

        dfs.append(df)
        

final_df = pd.concat(dfs, ignore_index=True)