With the help of the following simple python script, one would be able to merge CSV files present in the directory.

Requires Python 3 and pandas

Install requirements: pip install -r "requirements.txt" OR Install pandas: pip install pandas

Put all the CSVs which are to be merged in a directory containing the script. either run it from your code editor or IDE or type python merge_csv_files.py in your command line.

The final output would be a combined_csv.csv file in the same directory.