Hello, I read project description, and understood requirements.
I will provide you python script, which read CSV or excel (auto detect) file, and do the operation mention in the project description.
I will provide you solution in a day.
Kindly text me in the chat, so we can connect and discuss more on this.