Greetings,
I have 4+ years of experience in writing automation scripts (python/shell/VB) and proficient in python file handling and additional libraries required for this project (suggestion:- pandas for read/update and xlsxwriter for creation).
If you wish to keep the dependencies separate for this task, I can provide you with instructions for setting up a separate virtual environment.
I will be glad to discuss further about this task.
Thanks and regards,
Dhruv Srivastava