I tried to excel the current cleaning script and added some other helper fields in order to have a better vision of the data and how the algorithm is working but I decided to leave the script now as it is because I thought it would be better if we look at the locations instead of MAC addresses for filtering and aggreagting logs. I will add new scripts for this purpose.