Example of data in a dashboard

This is the data that one farmer includes in his dashboard which he uses at his farm. We will use another example farm (Karl Johans) to create a Dashboard presenting the below data through a web interface. We are comfortable with Python and R but will in the future add Vue.js to our skills list so presenting it using Shiny R, R panels or Vue javascripts is desired. To compute values there are best practice guidelines provided by ICAR https://www.icar.org/index.php/icar-recording-guidelines/

Som det ser ut nu så läser jag bara ut data en gång per dag oxå (använder autoit för att läsa ut rapporterna från Delpro och sen kör jag Python script på .csv filerna). Så här ser den data ut som jag läser ut dagligen som jag skulle vilja skapa någon dashboard på:

2020-08-18

Nr of milking cows, milking > 0 kg: 131 Avarage 7 days, nr of pass smartgate: 8.05 Avarage 7 days, nr of milkings: 2.3 Avarage 7 days, milking volym: 38.52 Avarage 7 days, milk from VMS1 and VMS2: 4916 Avarage 7 days, milk from MS1: 2514.4 Avarage 7 days, milk from MS2: 2401.8 Avarage 7 days, monthly milk volym for August: 152396 Avarage 7 days, nr of kickOffs: 1.97 Avarage 7 days, time in robot: 7.7 Profit today: 4543.5 Milk to tank last 24h: 4957.3 Number of liters produced in: August: 82478.6 Avarage 7 days, milking Volym. 43 cows in lactation 0-100 : 38.13 Avarage 7 days, milking Volym. 46 cows in lactation 101-200 : 41.3 Avarage 7 days, milking Volym. 46 cows in lactation 201- : 32.75

Search for bad economy cows ['Nr:1 AnimalId:1962 milkVolym: 16.7 Concentrate: 2.53 Corn: 5.75 Lactation:21 Resultatet: ', '-18Kr']

Search for cows milk less 25kg and milk more when 2 times per day ['Nr:1 animalId:1952 milkVolym:24.68 Lactation day:5 NrOfMilking7Days:', 2.8]

Search for cows milk lower when 20kg ['Nr:1 animalId:1962 daySinceCalf:21 milkVolym:', 16.7] ['Nr:2 animalId:1972 daySinceCalf:347 milkVolym:', 18.96] ['Nr:3 animalId:1735 daySinceCalf:299 milkVolym:', 19.33] ['Nr:4 animalId:1068 daySinceCalf:295 milkVolym:', 19.47] ['Nr:5 animalId:1339 daySinceCalf:236 milkVolym:', 19.77]

Search for cows with long milking time ['Nr:1 AnimalId:1618 MilkVolym:59.98 NrOfKickOff:1 Lactation day:58 MilkTimeInMinutes:', 14.5] ['Nr:2 AnimalId:1943 MilkVolym:45.5 NrOfKickOff:1 Lactation day:69 MilkTimeInMinutes:', 13.17] ['Nr:3 AnimalId:1999 MilkVolym:37.7 NrOfKickOff:1 Lactation day:59 MilkTimeInMinutes:', 12.77] ['Nr:4 AnimalId:1982 MilkVolym:50.77 NrOfKickOff:0 Lactation day:136 MilkTimeInMinutes:', 12.75] ['Nr:5 AnimalId:1748 MilkVolym:58.1 NrOfKickOff:0 Lactation day:69 MilkTimeInMinutes:', 12.0] ['Nr:6 AnimalId:1915 MilkVolym:42.51 NrOfKickOff:1 Lactation day:203 MilkTimeInMinutes:', 11.87] ['Nr:7 AnimalId:1977 MilkVolym:38.7 NrOfKickOff:7 Lactation day:184 MilkTimeInMinutes:', 11.85]

Search for cows with many kickOffs ['Nr:1 AnimalId:1131 MilkVolym:26.7 milkingTime:7 Lactation day:35 NrOfKickOff:', 18] ['Nr:2 AnimalId:1985 MilkVolym:45.95 milkingTime:7 Lactation day:48 NrOfKickOff:', 10] ['Nr:3 AnimalId:1016 MilkVolym:52.74 milkingTime:8 Lactation day:54 NrOfKickOff:', 9] ['Nr:4 AnimalId:1889 MilkVolym:49.74 milkingTime:8 Lactation day:80 NrOfKickOff:', 8] ['Nr:5 AnimalId:1085 MilkVolym:37.97 milkingTime:4 Lactation day:168 NrOfKickOff:', 8] ['Nr:6 AnimalId:1894 MilkVolym:46.38 milkingTime:9 Lactation day:174 NrOfKickOff:', 8] ['Nr:7 AnimalId:1895 MilkVolym:48.59 milkingTime:5 Lactation day:207 NrOfKickOff:', 8] ['Nr:8 AnimalId:1083 MilkVolym:25.52 milkingTime:9 Lactation day:245 NrOfKickOff:', 8] ['Nr:9 AnimalId:1074 MilkVolym:31.47 milkingTime:6 Lactation day:268 NrOfKickOff:', 8] ['Nr:10 AnimalId:1115 MilkVolym:30.84 milkingTime:5 Lactation day:98 NrOfKickOff:', 7] ['Nr:11 AnimalId:1013 MilkVolym:32.14 milkingTime:5 Lactation day:163 NrOfKickOff:', 7] ['Nr:12 AnimalId:1977 MilkVolym:38.7 milkingTime:11 Lactation day:184 NrOfKickOff:', 7] ['Nr:13 AnimalId:1077 MilkVolym:43.9 milkingTime:7 Lactation day:190 NrOfKickOff:', 7] ['Nr:14 AnimalId:1998 MilkVolym:50.06 milkingTime:10 Lactation day:179 NrOfKickOff:', 6] ['Nr:15 AnimalId:1812 MilkVolym:51.61 milkingTime:7 Lactation day:209 NrOfKickOff:', 6] ['Nr:16 AnimalId:1941 MilkVolym:40.2 milkingTime:9 Lactation day:226 NrOfKickOff:', 6] ['Nr:17 AnimalId:1911 MilkVolym:39.8 milkingTime:9 Lactation day:90 NrOfKickOff:', 5] ['Nr:18 AnimalId:1110 MilkVolym:33.94 milkingTime:6 Lactation day:96 NrOfKickOff:', 5] ['Nr:19 AnimalId:1971 MilkVolym:41.97 milkingTime:7 Lactation day:192 NrOfKickOff:', 5] ['Nr:20 AnimalId:1080 MilkVolym:31.44 milkingTime:7 Lactation day:242 NrOfKickOff:', 5] ['Nr:21 AnimalId:1724 MilkVolym:33.54 milkingTime:7 Lactation day:437 NrOfKickOff:', 5] ['Nr:22 AnimalId:1952 MilkVolym:24.68 milkingTime:8 Lactation day:5 NrOfKickOff:', 4] ['Nr:23 AnimalId:1136 MilkVolym:30.74 milkingTime:7 Lactation day:20 NrOfKickOff:', 4] ['Nr:24 AnimalId:1934 MilkVolym:49.54 milkingTime:5 Lactation day:47 NrOfKickOff:', 4] ['Nr:25 AnimalId:1028 MilkVolym:52.94 milkingTime:6 Lactation day:79 NrOfKickOff:', 4] ['Nr:26 AnimalId:1096 MilkVolym:29.83 milkingTime:7 Lactation day:142 NrOfKickOff:', 4] ['Nr:27 AnimalId:1069 MilkVolym:24.41 milkingTime:8 Lactation day:276 NrOfKickOff:', 4]

Search for cows need a vet, The MilkAlarm cows: ['Nr:1 animalId:1132 7daysAvarageMilk: 1 MilkLast24Hours: 0 %ConcentrateYday:0% %CornYday: 0% daySinceCalf: 0 milkProcentLeft: ', 0.0] ['Nr:2 animalId:1137 7daysAvarageMilk: 1 MilkLast24Hours: 0 %ConcentrateYday:99% %CornYday: 99% daySinceCalf: 0 milkProcentLeft: ', 0.0] ['Nr:3 animalId:1141 7daysAvarageMilk: 1 MilkLast24Hours: 0 %ConcentrateYday:0% %CornYday: 0% daySinceCalf: 0 milkProcentLeft: ', 0.0] ['Nr:4 animalId:1945 7daysAvarageMilk: 1 MilkLast24Hours: 0 %ConcentrateYday:0% %CornYday: 0% daySinceCalf: 363 milkProcentLeft: ', 0.0] ['Nr:5 animalId:1962 7daysAvarageMilk: 17 MilkLast24Hours: 8 %ConcentrateYday:72% %CornYday: 69% daySinceCalf: 21 milkProcentLeft: ', 0.47] ['Nr:6 animalId:1723 7daysAvarageMilk: 46 MilkLast24Hours: 22 %ConcentrateYday:62% %CornYday: 62% daySinceCalf: 42 milkProcentLeft: ', 0.48] ['Nr:7 animalId:1807 7daysAvarageMilk: 30 MilkLast24Hours: 18 %ConcentrateYday:94% %CornYday: 95% daySinceCalf: 299 milkProcentLeft: ', 0.6]

Search for cows need a vet, The feedAlarm cows: ['Nr:1 animalId:1132 %ConcentrateYday:0% %CornYday: 0% 7daysAvarageMilk: 1 MilkLast24Hours: 0 daySinceCalf: 0 avarageFeedEating%: ', 0.0] ['Nr:2 animalId:1141 %ConcentrateYday:0% %CornYday: 0% 7daysAvarageMilk: 1 MilkLast24Hours: 0 daySinceCalf: 0 avarageFeedEating%: ', 0.0] ['Nr:3 animalId:1945 %ConcentrateYday:0% %CornYday: 0% 7daysAvarageMilk: 1 MilkLast24Hours: 0 daySinceCalf: 363 avarageFeedEating%: ', 0.0] ['Nr:4 animalId:1747 %ConcentrateYday:38% %CornYday: 40% 7daysAvarageMilk: 44 MilkLast24Hours: 43 daySinceCalf: 70 avarageFeedEating%: ', 39.0] ['Nr:5 animalId:1982 %ConcentrateYday:48% %CornYday: 49% 7daysAvarageMilk: 51 MilkLast24Hours: 32 daySinceCalf: 136 avarageFeedEating%: ', 48.5]

Search for cows to dry up, cow should start dry up after 10 month. Now using nr of days as limiter: 300 ['Nr:1 animalId:1724 SevenDaysAvarageMilk:33.54 DaySinceCalf:', 437] ['Nr:2 animalId:1945 SevenDaysAvarageMilk:0.0 DaySinceCalf:', 363] ['Nr:3 animalId:1863 SevenDaysAvarageMilk:24.39 DaySinceCalf:', 335] ['Nr:4 animalId:1049 SevenDaysAvarageMilk:22.56 DaySinceCalf:', 312]

Search for cows to sort out, cow should milk over 30 liters on the 27 day in lactation ['Nr:1 animalId:1131 SevenDaysAvarageMilk:26.7 DaySinceCalf:', 35]

Print stats for bad economy cows: Counter({'1859': 13, '1962': 9, '1721': 8, '1136': 7, '1131': 6, '1122': 6, '1054': 3, '1723': 3, '1833': 2, '1964': 2, '1733': 2, '1749': 2, '1952': 2, '1045': 1, '1056': 1, '1954': 1})

Print stats for belowTwentyFiveKgAndOverTwoMilkingTimes cows: Counter({'1059': 11, '1859': 8, '1093': 6, '1081': 5, '1735': 4, '1952': 4, '1949': 3, '1092': 3, '1136': 3, '1954': 3, '1109': 2, '1083': 1, '1962': 1, '1056': 1, '1892': 1})

Print stats for FindBelowTwentyKgSearchStats cows: Counter({'1972': 18, '1962': 13, '1339': 13, '1721': 13, '1859': 12, '1833': 10, '1735': 9, '1056': 8, '1059': 7, '1136': 7, '1122': 6, '1131': 6, '1723': 4, '1054': 3, '1964': 3, '1952': 3, '1949': 2, '1733': 2, '1075': 2, '1954': 2, '1068': 1, '1045': 1, '1749': 1})

Print stats for FindCallVetCowsSearchStats cows: Counter({'1141': 64, '1132': 64, '1954': 55, '1952': 54, '1962': 51, '1122': 47, '1733': 47, '1136': 37, '1813': 37, '1045': 30, '1054': 29, '1833': 25, '1859': 25, '1945': 24, '1784': 21, '1747': 20, '1131': 16, '1075': 13, '1070': 13, '1137': 13, '1721': 12, '1723': 8, '1339': 7, '1964': 7, '1807': 7, '1763': 7, '1536': 6, '1632': 6, '1999': 6, '1109': 6, '1972': 6, '1102': 5, '1101': 5, '1115': 5, '1929': 4, '1902': 4, '1749': 4, '1618': 4, '1966': 4, '1059': 4, '1096': 3, '1069': 3, '1013': 3, '1081': 3, '1000': 3, '1863': 3, '1869': 3, '1840': 3, '1892': 3, '1978': 3, '1971': 3, '1789': 2, '1127': 2, '1928': 2, '1103': 2, '1724': 2, '1725': 2, '1985': 2, '1917': 2, '1977': 2, '1976': 2, '1781': 1, '1949': 1, '1076': 1, '1943': 1, '1091': 1, '1099': 1, '1955': 1, '1957': 1, '1068': 1, '1828': 1, '1083': 1, '1926': 1, '1855': 1, '1019': 1, '1831': 1, '1934': 1, '1941': 1, '1903': 1, '1982': 1, '1735': 1, '1998': 1, '1105': 1, '1748': 1, '1965': 1, '1694': 1, '1112': 1, '1114': 1, '1699': 1, '1889': 1, '1968': 1, '1880': 1, '1049': 1})

Print stats for FindLongMilkingTimeStats cows: Counter({'1618': 41, '1943': 41, '1999': 41, '1982': 40, '1998': 21, '1748': 19, '1915': 19, '1092': 10, '1977': 8, '1784': 7, '1880': 7, '1894': 6, '1339': 3, '1723': 3, '1102': 3, '1747': 3, '1962': 2, '1917': 2, '1000': 2, '1122': 1, '1733': 1, '1114': 1, '1952': 1, '1069': 1})

Print stats for FindManyKickOffsStats cows: Counter({'1894': 41, '1812': 41, '1013': 41, '1110': 40, '1115': 40, '1889': 40, '1069': 40, '1985': 39, '1085': 38, '1998': 38, '1083': 37, '1074': 37, '1096': 36, '1102': 35, '1099': 33, '1114': 31, '1049': 29, '1109': 29, '1077': 28, '1016': 28, '1934': 28, '1699': 23, '1895': 22, '1896': 20, '1131': 20, '1000': 20, '1941': 17, '1136': 16, '1724': 16, '1076': 15, '1977': 15, '1105': 15, '1926': 13, '1863': 11, '1071': 9, '1092': 9, '1093': 9, '1971': 9, '1028': 8, '1957': 8, '1101': 8, '1006': 8, '1813': 7, '1892': 6, '1089': 5, '1911': 5, '1891': 4, '1968': 4, '1080': 3, '1965': 3, '1952': 2, '1618': 2, '1103': 2, '1694': 2, '1056': 2, '1966': 2, '1784': 1, '1072': 1})