I am experienced in data science with Python libraries like pandas. I read your problem and since it looks simple for me I would be glad to help you and give some advise with such issues in the future.
The solution will not take more than 2 hours.
Regards.