Kenya Dairy Cattle Data Analysis - Comprehensive Overview

Key Data Elements Resolved

Update: The numeric values in the breeds column represent the proportion of taurine genes - issue resolved by Piter through coordination with Richard.

  • 0.3 = 30% taurine genes
  • 0.5 = 50% taurine genes
  • 0.6 = 60% taurine genes
  • 1.0 = 100% taurine genes (Pure Taurine)
  • Fleckvieh = Specific breed name

Dataset Overview

Key Statistics

Dataset Summary Statistics - All Key Traits
Metric Value
Total Cows 9,204
Total Records 646,410
Number of Breed Categories 129
Number of Herds 7
Mean Daily Yield (kg) 11.55 kg
Mean Age at First Calving (months) 33.9 months

Available Data Columns and Quality Assessment

Complete Data Quality Assessment by Variable
Variable Non_Missing_Count Total_Records Missing_Count Completeness_Percentage Data_Type
herd 646410 646410 0 100.0 Categorical - ID
cowno_final 646410 646410 0 100.0 Categorical - ID
breed 646410 646410 0 100.0 Categorical - ID
birth_date 646410 646410 0 100.0 Date
calving_date 646410 646410 0 100.0 Date
milking_date 646410 646410 0 100.0 Date
afc 646410 646410 0 100.0 Main Traits
yield 646410 646410 0 100.0 Main Traits
parity 646410 646410 0 100.0 Management Variables
testday_no 646410 646410 0 100.0 Management Variables
dim 646410 646410 0 100.0 Management Variables
calving_age 646410 646410 0 100.0 Management Variables
cow_no 646410 646410 0 100.0 Other
seqid 646410 646410 0 100.0 Other
lactation_stage 646410 646410 0 100.0 Other
dim_group 646410 646410 0 100.0 Other
breed_original 646038 646410 372 99.9 Derived Variables
breed_raw 646038 646410 372 99.9 Derived Variables
afc_category 284373 646410 362037 44.0 Other
genoid 86459 646410 559951 13.4 Other

Production Traits Summary

The Two Main Traits Summary
Trait Mean ± SD Range
Milk Yield (kg/day) 11.5 ± 6.1 (0.2 - 60)
Age at First Calving (months) 33.9 ± 7.3 (21 - 60)

Breed Information Summary - Taurine Gene Proportions

Breed Categories with Taurine Gene Proportion Interpretation
Original Value Breed Description Interpreted As Count Percentage
FFFF Friesian Friesian 161381 25.0
FFSS Friesian x Sahiwal Friesian_Sahiwal 96525 14.9
SSSS Sahiwal Sahiwal 32063 5.0
AAAA Ayrshire Ayrshire 29330 4.5
FFFB Friesian x Friesian Friesian_Friesian 24486 3.8
0.87 Taurine 87% Taurine 87% 21254 3.3
FBBB Friesian x Boran Friesian_Boran 16098 2.5
0.72 Taurine 72% Taurine 72% 16090 2.5
0.75 Taurine 75% Taurine 75% 15675 2.4
0.44 Taurine 44% Taurine 44% 11078 1.7
JJJJ Jersey Jersey 11077 1.7
Holstein Friesian Breed_Holstein Friesian Breed_Holstein Friesian 8916 1.4
0.74 Taurine 74% Taurine 74% 8239 1.3
0.38 Taurine 38% Taurine 38% 7670 1.2
0.48 Taurine 48% Taurine 48% 7506 1.2
0.47 Taurine 47% Taurine 47% 7322 1.1
0.86 Taurine 86% Taurine 86% 6816 1.1
0.94 Taurine 94% Taurine 94% 6522 1.0
0.93 Taurine 93% Taurine 93% 6475 1.0
Sahiwal Breed_Sahiwal Breed_Sahiwal 6237 1.0
FFJJ Friesian x Jersey Friesian_Jersey 5900 0.9
0.46 Taurine 46% Taurine 46% 5731 0.9
Ayrshire Breed_Ayrshire Breed_Ayrshire 5415 0.8
XXSS Magic (Synthetic from Gir) x Sahiwal Magic_Sahiwal 5067 0.8
0.81 Taurine 81% Taurine 81% 4870 0.8
GGGG Guernsey Guernsey 4647 0.7
0.73 Taurine 73% Taurine 73% 4613 0.7
AAFS Ayrshire x Friesian Ayrshire_Friesian 4531 0.7
0.62 Taurine 62% Taurine 62% 4491 0.7
XXXX Magic (Synthetic from Gir) Magic (Synthetic from Gir) 3780 0.6
XXFS Magic (Synthetic from Gir) x Friesian Magic_Friesian 3640 0.6
0.438 Taurine 43.8% Taurine 43.8% 3358 0.5
0.88 Taurine 88% Taurine 88% 3301 0.5
0.45 Taurine 45% Taurine 45% 3177 0.5
0.92 Taurine 92% Taurine 92% 3137 0.5
FFBB Friesian x Boran Friesian_Boran 3029 0.5
0.78 Taurine 78% Taurine 78% 2867 0.4
FBJJ Friesian x Jersey Friesian_Jersey 2483 0.4
FFFS Friesian x Friesian Friesian_Friesian 2483 0.4
0.9 Taurine 90% Taurine 90% 2403 0.4
0.83 Taurine 83% Taurine 83% 2297 0.4
FFXX Friesian x Magic (Synthetic from Gir) Friesian_Magic 2290 0.4
0.40699999999999997 Taurine 40.7% Taurine 40.7% 2232 0.3
0.97 Taurine 97% Taurine 97% 2192 0.3
0.95 Taurine 95% Taurine 95% 2187 0.3
FSFS Friesian x Friesian Friesian_Friesian 2121 0.3
0.46899999999999997 Taurine 46.9% Taurine 46.9% 2073 0.3
0.68799999999999994 Taurine 68.8% Taurine 68.8% 1964 0.3
0.6 Taurine 60% Taurine 60% 1947 0.3
0.61 Taurine 61% Taurine 61% 1935 0.3
AASS Ayrshire x Sahiwal Ayrshire_Sahiwal 1915 0.3
0.91 Taurine 91% Taurine 91% 1820 0.3
0.79 Taurine 79% Taurine 79% 1678 0.3
0.66 Taurine 66% Taurine 66% 1650 0.3
0.67 Taurine 67% Taurine 67% 1624 0.3
0.84 Taurine 84% Taurine 84% 1487 0.2
AAXS Ayrshire x Magic (Synthetic from Gir) Ayrshire_Magic 1425 0.2
0.9375 Taurine 93.8% Taurine 93.8% 1410 0.2
0.82 Taurine 82% Taurine 82% 1335 0.2
SSFS Sahiwal x Friesian Sahiwal_Friesian 1200 0.2
0.37 Taurine 37% Taurine 37% 1189 0.2
0.70399999999999996 Taurine 70.4% Taurine 70.4% 1156 0.2
0.71 Taurine 71% Taurine 71% 1130 0.2
0.74990000000000001 Taurine 75% Taurine 75% 1127 0.2
0.41 Taurine 41% Taurine 41% 1101 0.2
0.89 Taurine 89% Taurine 89% 1089 0.2
0.71899999999999997 Taurine 71.9% Taurine 71.9% 1087 0.2
0.56000000000000005 Taurine 56% Taurine 56% 978 0.2
0.69 Taurine 69% Taurine 69% 966 0.1
0.49 Taurine 49% Taurine 49% 891 0.1
0.73499999999999999 Taurine 73.5% Taurine 73.5% 873 0.1
0.43 Taurine 43% Taurine 43% 859 0.1
0.96 Taurine 96% Taurine 96% 859 0.1
0.826171875 Taurine 82.6% Taurine 82.6% 792 0.1
Holstein-Friesian crosses Breed_Holstein-Friesian crosses Breed_Holstein-Friesian crosses 789 0.1
0.22 Taurine 22% Taurine 22% 769 0.1
Others Breed_Others Breed_Others 750 0.1
WWWW Brown Swiss Brown Swiss 750 0.1
XXFF Magic (Synthetic from Gir) x Friesian Magic_Friesian 734 0.1
1 Breed_1 Pure Taurine (100%) 718 0.1
0.73388671875 Taurine 73.4% Taurine 73.4% 605 0.1
0.90700000000000003 Taurine 90.7% Taurine 90.7% 588 0.1
0.36 Taurine 36% Taurine 36% 556 0.1
0.68 Taurine 68% Taurine 68% 551 0.1
0.63 Taurine 63% Taurine 63% 548 0.1
0.84899999999999998 Taurine 84.9% Taurine 84.9% 531 0.1
0.98 Taurine 98% Taurine 98% 525 0.1
AAXF Ayrshire x Magic (Synthetic from Gir) Ayrshire_Magic 418 0.1
Guernsey Breed_Guernsey Breed_Guernsey 402 0.1
FSXF Friesian x Magic (Synthetic from Gir) Friesian_Magic 387 0.1
NA Unknown Unknown 372 0.1
FFSF Friesian x Sahiwal Friesian_Sahiwal 356 0.1
FFXF Friesian x Magic (Synthetic from Gir) Friesian_Magic 353 0.1
0.24 Taurine 24% Taurine 24% 316 0.0
Jersey Breed_Jersey Breed_Jersey 296 0.0
AAFF Ayrshire x Friesian Ayrshire_Friesian 266 0.0
0.86499999999999999 Taurine 86.5% Taurine 86.5% 258 0.0
RRRR Red Poll Red Poll 245 0.0
0.66666666666666652 Taurine 66.7% Taurine 66.7% 240 0.0
AAAX Ayrshire x Ayrshire Ayrshire_Ayrshire 192 0.0
0.8125 Taurine 81.2% Taurine 81.2% 183 0.0
Ayrshire crosses Breed_Ayrshire crosses Breed_Ayrshire crosses 182 0.0
Friesian Breed_Friesian Breed_Friesian 181 0.0
0.98499999999999999 Taurine 98.5% Taurine 98.5% 179 0.0
FFFX Friesian x Friesian Friesian_Friesian 161 0.0
Boran Breed_Boran Breed_Boran 160 0.0
0.7 Taurine 70% Taurine 70% 147 0.0
Unknown Breed_Unknown Breed_Unknown 129 0.0
SSXF Sahiwal x Magic (Synthetic from Gir) Sahiwal_Magic 119 0.0
0.77604166666666652 Taurine 77.6% Taurine 77.6% 110 0.0
0.5 Taurine 50% Taurine 50% 106 0.0
FSAF Friesian x Ayrshire Friesian_Ayrshire 106 0.0
FFBJ Friesian x Boran Friesian_Boran 105 0.0
0.55000000000000004 Taurine 55% Taurine 55% 93 0.0
0.57999999999999996 Taurine 58% Taurine 58% 93 0.0
0.31 Taurine 31% Taurine 31% 89 0.0
0.42 Taurine 42% Taurine 42% 89 0.0
AAXX Ayrshire x Magic (Synthetic from Gir) Ayrshire_Magic 81 0.0
0.47000000000000003 Taurine 47% Taurine 47% 76 0.0
0.72135416666666652 Taurine 72.1% Taurine 72.1% 70 0.0
GGXX Guernsey x Magic (Synthetic from Gir) Guernsey_Magic 70 0.0
BBBB Boran Boran 65 0.0
0.4 Taurine 40% Taurine 40% 54 0.0
Local Zebu Breed_Local Zebu Breed_Local Zebu 54 0.0
0.433 Taurine 43.3% Taurine 43.3% 52 0.0
Zebu Breed_Zebu Breed_Zebu 50 0.0
FBAA Friesian x Ayrshire Friesian_Ayrshire 47 0.0
0.51 Taurine 51% Taurine 51% 46 0.0
FSXX Friesian x Magic (Synthetic from Gir) Friesian_Magic 45 0.0
0.69000000000000006 Taurine 69% Taurine 69% 37 0.0
AAGG Ayrshire x Guernsey Ayrshire_Guernsey 36 0.0
0.36499999999999999 Taurine 36.5% Taurine 36.5% 35 0.0
GGFF Guernsey x Friesian Guernsey_Friesian 35 0.0
0.875 Taurine 87.5% Taurine 87.5% 31 0.0
FSXS Friesian x Magic (Synthetic from Gir) Friesian_Magic 29 0.0
0.74970000000000003 Taurine 75% Taurine 75% 20 0.0
Jersey crosses Breed_Jersey crosses Breed_Jersey crosses 20 0.0
0.54 Taurine 54% Taurine 54% 18 0.0
0.8 Taurine 80% Taurine 80% 17 0.0
FFXS Friesian x Magic (Synthetic from Gir) Friesian_Magic 17 0.0
GGJJ Guernsey x Jersey Guernsey_Jersey 17 0.0
SSFF Sahiwal x Friesian Sahiwal_Friesian 17 0.0
Guernsey crosses Breed_Guernsey crosses Breed_Guernsey crosses 14 0.0
VVVV Fleckvieh Fleckvieh 14 0.0
0.93799999999999994 Taurine 93.8% Taurine 93.8% 11 0.0
Masaai Breed_Masaai Breed_Masaai 8 0.0
XXXF Magic (Synthetic from Gir) x Magic (Synthetic from Gir) Magic_Magic 6 0.0
FFGG Friesian x Guernsey Friesian_Guernsey 3 0.0
Hereford Breed_Hereford Breed_Hereford 2 0.0
0.59 Taurine 59% Taurine 59% 1 0.0
Australian Illawarra Shorthorn Breed_Australian Illawarra Shorthorn Breed_Australian Illawarra Shorthorn 1 0.0
Fleckvieh Breed_Fleckvieh Fleckvieh 1 0.0
Sahiwal crosses Breed_Sahiwal crosses Breed_Sahiwal crosses 1 0.0

Taurine Gene Proportion Distribution

Taurine Gene Proportion Categories
Original Value Breed Description Interpreted As Count Percentage
0.87 Taurine 87% Taurine 87% 21254 3.3
0.72 Taurine 72% Taurine 72% 16090 2.5
0.75 Taurine 75% Taurine 75% 15675 2.4
0.44 Taurine 44% Taurine 44% 11078 1.7
0.74 Taurine 74% Taurine 74% 8239 1.3
0.38 Taurine 38% Taurine 38% 7670 1.2
0.48 Taurine 48% Taurine 48% 7506 1.2
0.47 Taurine 47% Taurine 47% 7322 1.1
0.86 Taurine 86% Taurine 86% 6816 1.1
0.94 Taurine 94% Taurine 94% 6522 1.0
0.93 Taurine 93% Taurine 93% 6475 1.0
0.46 Taurine 46% Taurine 46% 5731 0.9
0.81 Taurine 81% Taurine 81% 4870 0.8
0.73 Taurine 73% Taurine 73% 4613 0.7
0.62 Taurine 62% Taurine 62% 4491 0.7
0.438 Taurine 43.8% Taurine 43.8% 3358 0.5
0.88 Taurine 88% Taurine 88% 3301 0.5
0.45 Taurine 45% Taurine 45% 3177 0.5
0.92 Taurine 92% Taurine 92% 3137 0.5
0.78 Taurine 78% Taurine 78% 2867 0.4
0.9 Taurine 90% Taurine 90% 2403 0.4
0.83 Taurine 83% Taurine 83% 2297 0.4
0.40699999999999997 Taurine 40.7% Taurine 40.7% 2232 0.3
0.97 Taurine 97% Taurine 97% 2192 0.3
0.95 Taurine 95% Taurine 95% 2187 0.3
0.46899999999999997 Taurine 46.9% Taurine 46.9% 2073 0.3
0.68799999999999994 Taurine 68.8% Taurine 68.8% 1964 0.3
0.6 Taurine 60% Taurine 60% 1947 0.3
0.61 Taurine 61% Taurine 61% 1935 0.3
0.91 Taurine 91% Taurine 91% 1820 0.3
0.79 Taurine 79% Taurine 79% 1678 0.3
0.66 Taurine 66% Taurine 66% 1650 0.3
0.67 Taurine 67% Taurine 67% 1624 0.3
0.84 Taurine 84% Taurine 84% 1487 0.2
0.9375 Taurine 93.8% Taurine 93.8% 1410 0.2
0.82 Taurine 82% Taurine 82% 1335 0.2
0.37 Taurine 37% Taurine 37% 1189 0.2
0.70399999999999996 Taurine 70.4% Taurine 70.4% 1156 0.2
0.71 Taurine 71% Taurine 71% 1130 0.2
0.74990000000000001 Taurine 75% Taurine 75% 1127 0.2
0.41 Taurine 41% Taurine 41% 1101 0.2
0.89 Taurine 89% Taurine 89% 1089 0.2
0.71899999999999997 Taurine 71.9% Taurine 71.9% 1087 0.2
0.56000000000000005 Taurine 56% Taurine 56% 978 0.2
0.69 Taurine 69% Taurine 69% 966 0.1
0.49 Taurine 49% Taurine 49% 891 0.1
0.73499999999999999 Taurine 73.5% Taurine 73.5% 873 0.1
0.43 Taurine 43% Taurine 43% 859 0.1
0.96 Taurine 96% Taurine 96% 859 0.1
0.826171875 Taurine 82.6% Taurine 82.6% 792 0.1
0.22 Taurine 22% Taurine 22% 769 0.1
1 Breed_1 Pure Taurine (100%) 718 0.1
0.73388671875 Taurine 73.4% Taurine 73.4% 605 0.1
0.90700000000000003 Taurine 90.7% Taurine 90.7% 588 0.1
0.36 Taurine 36% Taurine 36% 556 0.1
0.68 Taurine 68% Taurine 68% 551 0.1
0.63 Taurine 63% Taurine 63% 548 0.1
0.84899999999999998 Taurine 84.9% Taurine 84.9% 531 0.1
0.98 Taurine 98% Taurine 98% 525 0.1
0.24 Taurine 24% Taurine 24% 316 0.0
0.86499999999999999 Taurine 86.5% Taurine 86.5% 258 0.0
0.66666666666666652 Taurine 66.7% Taurine 66.7% 240 0.0
0.8125 Taurine 81.2% Taurine 81.2% 183 0.0
0.98499999999999999 Taurine 98.5% Taurine 98.5% 179 0.0
0.7 Taurine 70% Taurine 70% 147 0.0
0.77604166666666652 Taurine 77.6% Taurine 77.6% 110 0.0
0.5 Taurine 50% Taurine 50% 106 0.0
0.55000000000000004 Taurine 55% Taurine 55% 93 0.0
0.57999999999999996 Taurine 58% Taurine 58% 93 0.0
0.31 Taurine 31% Taurine 31% 89 0.0
0.42 Taurine 42% Taurine 42% 89 0.0
0.47000000000000003 Taurine 47% Taurine 47% 76 0.0
0.72135416666666652 Taurine 72.1% Taurine 72.1% 70 0.0
0.4 Taurine 40% Taurine 40% 54 0.0
0.433 Taurine 43.3% Taurine 43.3% 52 0.0
0.51 Taurine 51% Taurine 51% 46 0.0
0.69000000000000006 Taurine 69% Taurine 69% 37 0.0
0.36499999999999999 Taurine 36.5% Taurine 36.5% 35 0.0
0.875 Taurine 87.5% Taurine 87.5% 31 0.0
0.74970000000000003 Taurine 75% Taurine 75% 20 0.0
0.54 Taurine 54% Taurine 54% 18 0.0
0.8 Taurine 80% Taurine 80% 17 0.0
0.93799999999999994 Taurine 93.8% Taurine 93.8% 11 0.0
0.59 Taurine 59% Taurine 59% 1 0.0

Parity and Lactation Stage Distribution

Distribution by Parity
Parity Count Percentage
1 284373 44.0
2 151668 23.5
3 92835 14.4
4 52135 8.1
5 30886 4.8
6 19459 3.0
7 9434 1.5
8 3668 0.6
9 1556 0.2
10 276 0.0
11 106 0.0
12 14 0.0
Distribution by Lactation Stage
Lactation Stage Count Percentage
Early (0-100 days) 210583 32.6
Mid (101-200 days) 188486 29.2
Late (201-305 days) 158962 24.6
Extended (>305 days) 88379 13.7

Herd Performance Overview

Herd Performance Summary (Ranked by Yield)
herd Number of Cows Number of Records Mean Yield (kg) Mean AFC (months)
KLBA 6347 146293 14.20 33.9
MAKITOSHA 488 202285 14.19 29.3
STANLEY AND SON 755 96970 11.38 34.2
ADC 24 672 7.49 44.7
AVCD 8 72 7.32 34.2
KALRO NAIVASHA 273 177344 7.06 37.8
SAPLING 1309 22774 6.77 44.0

Current Interpretation Logic - CONFIRMED

Confirmed interpretation: - Values like 0.3, 0.5, 0.6 represent taurine gene proportions (30%, 50%, 60% taurine genetics) - Value “1” or “1.0” represents Pure Taurine (100% taurine genes) - “Fleckvieh” is a distinct breed name

Issue RESOLVED - breed coding system is now understood and properly categorized.

Analysis complete - All key traits characterized: - Milk production: Daily yield patterns analyzed - Reproductive traits: Age at first calving - Lactation management: Days in milk, lactation stages - Genetic composition: Taurine gene proportions understood - Herd management: Performance variation across herds - Data quality: All major variables assessed for completeness

This analysis was conducted in collaboration with Piter.

Proposed Unit Conversion - NO LONGER NEEDED: AFC is confirmed to already be in months, so no conversion required.

Next Steps: - Next stage will involve: - Distribution analysis of the two main traits (yield and AFC) - Distribution patterns per breed category - Distribution analysis for all breeds combined - Assessment of data suitability for genetic analysis - Evaluation of trait distributions for normality and outliers - Breed comparison analysis for production and reproductive performance

Available Variables/Traits for Analysis

Complete List of Available Variables for Analysis
Variable Description Category Units
yield Daily milk yield Production Trait kg/day
afc Age at first calving Reproductive Trait months
dim Days in milk Management Variable days
parity Lactation number Management Variable number
calving_age Age at calving Reproductive Variable units unclear
testday_no Test day number Management Variable number
birth_date Birth date Date Variable date
calving_date Calving date Date Variable date
milking_date Milk recording date Date Variable date
breed Breed/crossbreed composition Genetic Factor breed/crossbreed
herd Herd identifier Management Factor ID
cowno_final Cow identifier Identifier ID
lactation_stage Lactation stage category Derived Category category
dim_group DIM group category Derived Category category
afc_category AFC category Derived Category category

Key Traits for Genetic Analysis: - Production Traits (blue): yield (kg/day) - Reproductive Traits (green): afc (months) - Genetic Factors (purple): breed (purebreds and crossbreeds) - Management Variables: dim, parity, herd, testday_no

Data Interpretation Notes

Count and Percentage Values: All count and percentage values throughout this report refer to milk test records, not individual animals. This means:

  • Count: Number of milk recording observations/test days
  • Percentage: Proportion of total milk test records
  • Same cow contribution: Each cow can contribute multiple records across different test dates
  • Example: A cow tested monthly for 10 months contributes 10 records to the count
  • Dataset structure: 646,410 total milk test records from 9,204 individual cows
  • Average: Approximately 70.2 records per cow

This longitudinal data structure is typical for dairy performance recording systems where cows are tested regularly throughout their lactation periods.

Collaboration & Contact

Analysis Team: This comprehensive analysis was conducted in collaboration with Piter.

Contact:
Institution: ILRI - International Livestock Research Institute