Code responsible for pre-processing water-pipes breaks data. this is an ugly-formate code, but it works like a charm as we accopmlished the 2nd place in "Smarter Egypt and Big Data Hackathon" holded in cairo and sponsered by IBM.
written by @maboelnour and @mahkhaled