Spreadsheet: 862541d1710246096-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
2023-02-01 00:00:00 | 06:00:00 | 3600
 |  |  |  |  |  |  | [NAME] needed for # times the number changes
 |  |  |  |  | 4 | 6 | answer should be