I have extensive experience/ expertise in statistics, engineering, time series, etc. Have > 35 years experience.
I have done numerous courses in R, machine learning, supply chain, operations, Python from leading universities such as Stanford, MIT etc. I am ASQ certified black-belt.
I can easily do this project on splitting file (using R code ) to your satisfaction.
I will provide details/ clarifications on request.