Spreadsheet: 862578d1710260669-count-number-of-value-changes-in-column-data
Sheet: Sheet1

Date | Hour | secs | behaviour_1 | behaviour_2 | location_1 | location_2
2023-02-01 00:00:00 | 06:00:00 | 0 | voc | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 30 | voc | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 60 | voc | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 90 | rp | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 120 | pre | uk | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 150 | rp | rp | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 180 | rp | str | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 210 | str | ap | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 240 | rp |  | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 270 | voc | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 300 | voc | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 330 | ap |  | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 360 | voc | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 390 | voc | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 420 | ap | ap | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 450 | voc | rp | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 480 | voc | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 510 | hop | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 540 | cab | cab | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 570 | voc | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 600 | str | rp | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 630 | rp | uk | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 660 | voc | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 690 | voc | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 720 | oos | ap |  | 4
2023-02-01 00:00:00 | 06:00:00 | 750 | oos | voc |  | 4
2023-02-01 00:00:00 | 06:00:00 | 780 | voc | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 810 | hop |  | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 840 | rp | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 870 | hop | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 900 | pre | ap | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 930 | ap | ap | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 960 | rp | ap | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 990 | voc | voc | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 1020 | cb | ap | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 1050 | voc | yawn | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 1080 | voc | voc | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 1110 | cab | ap | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 1140 | pre | pre | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 1170 | pre | ap | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 1200 | ap | ap | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 1230 | cb | hop | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 1260 | hop | voc | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 1290 | voc | ap | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 1320 | voc | voc | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 1350 | pre | ap | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 1380 | pre | ap | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 1410 | cb | hop | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 1440 | pre | pre | 4 | 4
2023-02-01 00:00:00 | 06:00:00 | 1470 | cb | oos | 4
2023-02-01 00:00:00 | 06:00:00 | 1500 | hop | oos | 3
2023-02-01 00:00:00 | 06:00:00 | 1530 | str | oos | 3
2023-02-01 00:00:00 | 06:00:00 | 1560 | cb | oos | 3
2023-02-01 00:00:00 | 06:00:00 | 1590 | rp | oos | 3
2023-02-01 00:00:00 | 06:00:00 | 1620 | ap | oos | 3
2023-02-01 00:00:00 | 06:00:00 | 1650 | cab | cab | 3 | 4
2023-02-01 00:00:00 | 06:00:00 | 1680 | ap | hop | 3 | 4
2023-02-01 00:00:00 | 06:00:00 | 1710 | ap | hop | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 1740 | voc | voc | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 1770 | voc | voc | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 1800 | voc | voc | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 1830 | voc | eat | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 1860 | voc | eat | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 1890 | rp | eat | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 1920 | rp | rp | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 1950 | voc | voc | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 1980 | hup | rp | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2010 | pre |  | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2040 | ap | ap | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2070 | rp | ap | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2100 | rp | ap | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2130 | rp | eat | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2160 | voc | voc | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2190 | voc | rp | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2220 | voc | voc | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2250 | voc | voc | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2280 | rp | ap | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2310 | hop | voc | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2340 | voc |  | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2370 | ap | ap | 3 | 2
2023-02-01 00:00:00 | 06:00:00 | 2400 | voc | ap | 4 | 2
2023-02-01 00:00:00 | 06:00:00 | 2430 | oos | ap |  | 3
2023-02-01 00:00:00 | 06:00:00 | 2460 | hop | cb | 4 | 3
2023-02-01 00:00:00 | 06:00:00 | 2490 |  | ap | 0 | 3
2023-02-01 00:00:00 | 06:00:00 | 2520 | oos | hop | 0 | 3
2023-02-01 00:00:00 | 06:00:00 | 2550 | oos | ap | 0 | 4
2023-02-01 00:00:00 | 06:00:00 | 2580 | oos | pre | 0 | 4
2023-02-01 00:00:00 | 06:00:00 | 2610 | oos | ap | 0 | 4
2023-02-01 00:00:00 | 06:00:00 | 2640 | oos | oos
2023-02-01 00:00:00 | 06:00:00 | 2670
2023-02-01 00:00:00 | 06:00:00 | 2700
2023-02-01 00:00:00 | 06:00:00 | 2730
2023-02-01 00:00:00 | 06:00:00 | 2760
2023-02-01 00:00:00 | 06:00:00 | 2790 | rp | oos | 0
2023-02-01 00:00:00 | 06:00:00 | 2820 | ap | oos | 0
2023-02-01 00:00:00 | 06:00:00 | 2850 |  | oos | 0
2023-02-01 00:00:00 | 06:00:00 | 2880 |  | oos | 0
2023-02-01 00:00:00 | 06:00:00 | 2910 | ap | oos | 0
2023-02-01 00:00:00 | 06:00:00 | 2940 | hop | oos | 0
2023-02-01 00:00:00 | 06:00:00 | 2970 | ap | oos | 0
2023-02-01 00:00:00 | 06:00:00 | 3000
2023-02-01 00:00:00 | 06:00:00 | 3030
2023-02-01 00:00:00 | 06:00:00 | 3060
2023-02-01 00:00:00 | 06:00:00 | 3090
2023-02-01 00:00:00 | 06:00:00 | 3120 | rp |  | 0 | 4
2023-02-01 00:00:00 | 06:00:00 | 3150 | rp |  | 0 | 4
2023-02-01 00:00:00 | 06:00:00 | 3180
2023-02-01 00:00:00 | 06:00:00 | 3210
2023-02-01 00:00:00 | 06:00:00 | 3240
2023-02-01 00:00:00 | 06:00:00 | 3270
2023-02-01 00:00:00 | 06:00:00 | 3300
2023-02-01 00:00:00 | 06:00:00 | 3330
2023-02-01 00:00:00 | 06:00:00 | 3360
2023-02-01 00:00:00 | 06:00:00 | 3390
2023-02-01 00:00:00 | 06:00:00 | 3420
2023-02-01 00:00:00 | 06:00:00 | 3450
2023-02-01 00:00:00 | 06:00:00 | 3480
2023-02-01 00:00:00 | 06:00:00 | 3510
2023-02-01 00:00:00 | 06:00:00 | 3540
2023-02-01 00:00:00 | 06:00:00 | 3570 |  |  | 4
2023-02-01 00:00:00 | 06:00:00 | 3600 |  |  | 4
2023-02-07 00:00:00 | 06:00:00 | 0 | hup | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 30 | pre | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 60 | hup | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 90 | hup | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 120 | hup | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 150 | hup | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 180 | hup | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 210 | hup | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 240 | rp | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 270 | rp | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 300 | voc | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 330 | voc | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 360 | voc | voc | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 390 | voc | voc | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 420 | voc | cb | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 450 | hop |  | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 480 | rp |  | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 510 | voc | ap | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 540 | rp | rp | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 570 | oos | voc | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 600 | rp | rp | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 630 | voc | voc | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 660 | oos |  |  | 4
2023-02-07 00:00:00 | 06:00:00 | 690 | rp | ap | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 720 | rp | ap | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 750 | ap | ap | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 780 | ap | ap | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 810 | hop | uk | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 840 | ap | uk | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 870 | oos | ap | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 900 | ap | ap | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 930 | ap | hop | 4 | 4
2023-02-07 00:00:00 | 06:00:00 | 960 | ap | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 990 |  | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 1020 | hop | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 1050 |  | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 1080
2023-02-07 00:00:00 | 06:00:00 | 1110 | ap | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 1140 | hop | oos | 3
2023-02-07 00:00:00 | 06:00:00 | 1170 | ap | oos | 3
2023-02-07 00:00:00 | 06:00:00 | 1200 | str | oos | 3
2023-02-07 00:00:00 | 06:00:00 | 1230 | rp | ap | 3 | 4
2023-02-07 00:00:00 | 06:00:00 | 1260 | rp | rp | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 1290 | rp | ap | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 1320 | rp | ap | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 1350 | rp | ap | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1380 | voc | hop | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1410 | voc | hop | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1440 | voc | voc | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1470 | voc | voc | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1500 | rp | eat | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1530 | voc | voc | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1560 | rp | eat | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1590 | rp | ap | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1620 | rp | ap | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1650 | rp | ap | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1680 | rp | hup | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1710 | pre | ap | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1740 | pre | ap | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1770 | pre | ap | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1800 | rp | hup | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1830 | rp | ap | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1860 | rp | eat | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1890 | rp | eat | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1920 | rp | eat | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1950 | rp | eat | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 1980 | rp | eat | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 2010 | rp | eat | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 2040 | rp | eat | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 2070 | str | ap | 3 | 2
2023-02-07 00:00:00 | 06:00:00 | 2100 | rp | ap | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2130 | rp | ap | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2160 | rp | ap | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2190 | rp | rp | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2220 | ap | rp | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2250 | rp | rp | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2280 | ap | rp | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2310 | rp | rp | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2340 | rp | rp | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2370 | rp | rp | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2400 | hop | ap | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2430 | ap | ap | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2460 | rp | rp | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2490 | hop | ap | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2520 | ap | ap | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2550 | ap | ap | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2580 | hup | rp | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2610 | rp | rp | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2640 | rp | rp | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2670 | rp | rp | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2700 | voc | hop | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2730 | rp | cb | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2760 | rp | ap | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2790 | voc | voc | 3 | 3
2023-02-07 00:00:00 | 06:00:00 | 2820 | rp | ap | 3 | 4
2023-02-07 00:00:00 | 06:00:00 | 2850 | voc | voc | 3 | 4
2023-02-07 00:00:00 | 06:00:00 | 2880 | voc | ap | 3 | 4
2023-02-07 00:00:00 | 06:00:00 | 2910 | voc | oos | 3
2023-02-07 00:00:00 | 06:00:00 | 2940 | ap | oos | 3
2023-02-07 00:00:00 | 06:00:00 | 2970 | str | oos | 3
2023-02-07 00:00:00 | 06:00:00 | 3000 | ap | oos | 3
2023-02-07 00:00:00 | 06:00:00 | 3030 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3060 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3090 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3120 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3150 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3180 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3210 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3240 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3270 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3300 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3330 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3360 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3390 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3420 | eat | oos | 2
2023-02-07 00:00:00 | 06:00:00 | 3450 | ap | oos | 3
2023-02-07 00:00:00 | 06:00:00 | 3480 | ap | oos | 3
2023-02-07 00:00:00 | 06:00:00 | 3510 | rp | oos | 3
2023-02-07 00:00:00 | 06:00:00 | 3540 | hop | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 3570 | pre | oos | 4
2023-02-07 00:00:00 | 06:00:00 | 3600 | rp | oos | 4
 |  |  |  |  | 8 | 9 |  | Should be