Greetings,
I am a data analytics engineer and statistical consultant/data scientist. Your requirement can be fulfilled accurately and efficiently using pandas, python.
The advantages of this approach:
I'll provide you with code, so If you wanted to do similar task in the future, you'll only have to re-run my code to accomplish the same task. Also, in case you wanted to include or exclude any file(s), you will be able to do this over and over.
Since the task will be automated, it is efficient, and accurate. No chance for typos or errors.
Looking forward to hearing from you.
Thanks and regards,
Aly Abdelrazek