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.