Hello All,
I have some data which is basically some 0s and 1s like below in one column:
111010001011111100111110001011011111111111111111100111111111010010101110010001100101111011110010000
These show occupancy status of a location. When it is zero it means that the place is unoccupied, and when it is 1 it means that the place is occupied. The problem is that these data are not accurate. So the location is occupied if and only if there are at least 3 consecutive 1s happening, and it is unoccupied it there are at least 3 consecutive zeros happening. Can you please tell me how I can identify occupancy and non-occupancy data using this criteria? Thanks, Masih
Best Answer