I am experienced with data analysis and programming, so I think I would give you an efficient and intuitive solution. I intend to use python because of its readability (you can understand it properly) and its growing use in data science (people will like it). My idea is to finish at the end of the first day, so you can run, test and check if everything is really as you wanted. If it's not, we can solve that on the second day.