Breed Data Quality Analysis

Issue Identified

The breed data contains inconsistent coding that requires clarification: - Clear breed names: Fleckvieh (makes sense) - Numeric codes: 0.3, 0.5, 0.6 (interpretation unclear) - Status: Piter is coordinating with Richard for clarification

Dataset Overview

Key Statistics

Dataset Summary Statistics
Metric Value
Total Cows 9,204
Total Records 646,410
Number of Breed Categories 148
Number of Herds 7

Data Quality Issues Identified

Breed Data Quality Issues Summary
issue_type Number of Categories Total Records Percentage of Data
Other 67 443752 68.6
Decimal fraction (0.x) 83 201567 31.2
Clear breed designation 2 719 0.1
Missing value 1 372 0.1

Breed Information Summary

Breed Categories and Their Interpretation Status
Original Value Interpreted As Count Percentage Status
FFFF Breed_FFFF 161381 25.0 ❓ Review Needed
FFSS Breed_FFSS 96525 14.9 ❓ Review Needed
SSSS Breed_SSSS 32063 5.0 ❓ Review Needed
AAAA Breed_AAAA 29330 4.5 ❓ Review Needed
FFFB Breed_FFFB 24486 3.8 ❓ Review Needed
0.87 Holstein 87% 21254 3.3 πŸ” Needs Clarification
FBBB Breed_FBBB 16098 2.5 ❓ Review Needed
0.72 Holstein 72% 16090 2.5 πŸ” Needs Clarification
0.75 Holstein 75% 15675 2.4 πŸ” Needs Clarification
0.44 Holstein 44% 11078 1.7 πŸ” Needs Clarification
JJJJ Breed_JJJJ 11077 1.7 ❓ Review Needed
Holstein Friesian Breed_Holstein Friesian 8916 1.4 ❓ Review Needed
0.74 Holstein 74% 8239 1.3 πŸ” Needs Clarification
0.38 Holstein 38% 7670 1.2 πŸ” Needs Clarification
0.48 Holstein 48% 7506 1.2 πŸ” Needs Clarification
0.47 Holstein 47% 7322 1.1 πŸ” Needs Clarification
0.86 Holstein 86% 6816 1.1 πŸ” Needs Clarification
0.94 Holstein 94% 6522 1.0 πŸ” Needs Clarification
0.93 Holstein 93% 6475 1.0 πŸ” Needs Clarification
Sahiwal Breed_Sahiwal 6237 1.0 ❓ Review Needed
FFJJ Breed_FFJJ 5900 0.9 ❓ Review Needed
0.46 Holstein 46% 5731 0.9 πŸ” Needs Clarification
Ayrshire Breed_Ayrshire 5415 0.8 ❓ Review Needed
XXSS Breed_XXSS 5067 0.8 ❓ Review Needed
0.81 Holstein 81% 4870 0.8 πŸ” Needs Clarification
GGGG Breed_GGGG 4647 0.7 ❓ Review Needed
0.73 Holstein 73% 4613 0.7 πŸ” Needs Clarification
AAFS Breed_AAFS 4531 0.7 ❓ Review Needed
0.62 Holstein 62% 4491 0.7 πŸ” Needs Clarification
XXXX Breed_XXXX 3780 0.6 ❓ Review Needed
XXFS Breed_XXFS 3640 0.6 ❓ Review Needed
0.438 Holstein 43.8% 3358 0.5 πŸ” Needs Clarification
0.88 Holstein 88% 3301 0.5 πŸ” Needs Clarification
0.45 Holstein 45% 3177 0.5 πŸ” Needs Clarification
0.92 Holstein 92% 3137 0.5 πŸ” Needs Clarification
FFBB Breed_FFBB 3029 0.5 ❓ Review Needed
0.78 Holstein 78% 2867 0.4 πŸ” Needs Clarification
FBJJ Breed_FBJJ 2483 0.4 ❓ Review Needed
FFFS Breed_FFFS 2483 0.4 ❓ Review Needed
0.9 Holstein 90% 2403 0.4 πŸ” Needs Clarification
0.83 Holstein 83% 2297 0.4 πŸ” Needs Clarification
FFXX Breed_FFXX 2290 0.4 ❓ Review Needed
0.40699999999999997 Holstein 40.7% 2232 0.3 πŸ” Needs Clarification
0.97 Holstein 97% 2192 0.3 πŸ” Needs Clarification
0.95 Holstein 95% 2187 0.3 πŸ” Needs Clarification
FSFS Breed_FSFS 2121 0.3 ❓ Review Needed
0.46899999999999997 Holstein 46.9% 2073 0.3 πŸ” Needs Clarification
0.68799999999999994 Holstein 68.8% 1964 0.3 πŸ” Needs Clarification
0.6 Holstein 60% 1947 0.3 πŸ” Needs Clarification
0.61 Holstein 61% 1935 0.3 πŸ” Needs Clarification
AASS Breed_AASS 1915 0.3 ❓ Review Needed
0.91 Holstein 91% 1820 0.3 πŸ” Needs Clarification
0.79 Holstein 79% 1678 0.3 πŸ” Needs Clarification
0.66 Holstein 66% 1650 0.3 πŸ” Needs Clarification
0.67 Holstein 67% 1624 0.3 πŸ” Needs Clarification
0.84 Holstein 84% 1487 0.2 πŸ” Needs Clarification
AAXS Breed_AAXS 1425 0.2 ❓ Review Needed
0.9375 Holstein 93.8% 1410 0.2 πŸ” Needs Clarification
0.82 Holstein 82% 1335 0.2 πŸ” Needs Clarification
SSFS Breed_SSFS 1200 0.2 ❓ Review Needed
0.37 Holstein 37% 1189 0.2 πŸ” Needs Clarification
0.70399999999999996 Holstein 70.4% 1156 0.2 πŸ” Needs Clarification
0.71 Holstein 71% 1130 0.2 πŸ” Needs Clarification
0.74990000000000001 Holstein 75% 1127 0.2 πŸ” Needs Clarification
0.41 Holstein 41% 1101 0.2 πŸ” Needs Clarification
0.89 Holstein 89% 1089 0.2 πŸ” Needs Clarification
0.71899999999999997 Holstein 71.9% 1087 0.2 πŸ” Needs Clarification
0.56000000000000005 Holstein 56% 978 0.2 πŸ” Needs Clarification
0.69 Holstein 69% 966 0.1 πŸ” Needs Clarification
0.49 Holstein 49% 891 0.1 πŸ” Needs Clarification
0.73499999999999999 Holstein 73.5% 873 0.1 πŸ” Needs Clarification
0.43 Holstein 43% 859 0.1 πŸ” Needs Clarification
0.96 Holstein 96% 859 0.1 πŸ” Needs Clarification
0.826171875 Holstein 82.6% 792 0.1 πŸ” Needs Clarification
Holstein-Friesian crosses Breed_Holstein-Friesian crosses 789 0.1 ❓ Review Needed
0.22 Holstein 22% 769 0.1 πŸ” Needs Clarification
Others Breed_Others 750 0.1 ❓ Review Needed
WWWW Breed_WWWW 750 0.1 ❓ Review Needed
XXFF Breed_XXFF 734 0.1 ❓ Review Needed
1 Pure Holstein 718 0.1 βœ… Clear
0.73388671875 Holstein 73.4% 605 0.1 πŸ” Needs Clarification
0.90700000000000003 Holstein 90.7% 588 0.1 πŸ” Needs Clarification
0.36 Holstein 36% 556 0.1 πŸ” Needs Clarification
0.68 Holstein 68% 551 0.1 πŸ” Needs Clarification
0.63 Holstein 63% 548 0.1 πŸ” Needs Clarification
0.84899999999999998 Holstein 84.9% 531 0.1 πŸ” Needs Clarification
0.98 Holstein 98% 525 0.1 πŸ” Needs Clarification
AAXF Breed_AAXF 418 0.1 ❓ Review Needed
Guernsey Breed_Guernsey 402 0.1 ❓ Review Needed
FSXF Breed_FSXF 387 0.1 ❓ Review Needed
NA Unknown 372 0.1 ⚠️ Missing
FFSF Breed_FFSF 356 0.1 ❓ Review Needed
FFXF Breed_FFXF 353 0.1 ❓ Review Needed
0.24 Holstein 24% 316 0.0 πŸ” Needs Clarification
Jersey Breed_Jersey 296 0.0 ❓ Review Needed
AAFF Breed_AAFF 266 0.0 ❓ Review Needed
0.86499999999999999 Holstein 86.5% 258 0.0 πŸ” Needs Clarification
RRRR Breed_RRRR 245 0.0 ❓ Review Needed
0.66666666666666652 Holstein 66.7% 240 0.0 πŸ” Needs Clarification
AAAX Breed_AAAX 192 0.0 ❓ Review Needed
0.8125 Holstein 81.2% 183 0.0 πŸ” Needs Clarification
Ayrshire crosses Breed_Ayrshire crosses 182 0.0 ❓ Review Needed
Friesian Breed_Friesian 181 0.0 ❓ Review Needed
0.98499999999999999 Holstein 98.5% 179 0.0 πŸ” Needs Clarification
FFFX Breed_FFFX 161 0.0 ❓ Review Needed
Boran Breed_Boran 160 0.0 ❓ Review Needed
0.7 Holstein 70% 147 0.0 πŸ” Needs Clarification
Unknown Breed_Unknown 129 0.0 ❓ Review Needed
SSXF Breed_SSXF 119 0.0 ❓ Review Needed
0.77604166666666652 Holstein 77.6% 110 0.0 πŸ” Needs Clarification
0.5 Holstein 50% 106 0.0 πŸ” Needs Clarification
FSAF Breed_FSAF 106 0.0 ❓ Review Needed
FFBJ Breed_FFBJ 105 0.0 ❓ Review Needed
0.55000000000000004 Holstein 55% 93 0.0 πŸ” Needs Clarification
0.57999999999999996 Holstein 58% 93 0.0 πŸ” Needs Clarification
0.31 Holstein 31% 89 0.0 πŸ” Needs Clarification
0.42 Holstein 42% 89 0.0 πŸ” Needs Clarification
AAXX Breed_AAXX 81 0.0 ❓ Review Needed
0.47000000000000003 Holstein 47% 76 0.0 πŸ” Needs Clarification
0.72135416666666652 Holstein 72.1% 70 0.0 πŸ” Needs Clarification
GGXX Breed_GGXX 70 0.0 ❓ Review Needed
BBBB Breed_BBBB 65 0.0 ❓ Review Needed
0.4 Holstein 40% 54 0.0 πŸ” Needs Clarification
Local Zebu Breed_Local Zebu 54 0.0 ❓ Review Needed
0.433 Holstein 43.3% 52 0.0 πŸ” Needs Clarification
Zebu Breed_Zebu 50 0.0 ❓ Review Needed
FBAA Breed_FBAA 47 0.0 ❓ Review Needed
0.51 Holstein 51% 46 0.0 πŸ” Needs Clarification
FSXX Breed_FSXX 45 0.0 ❓ Review Needed
0.69000000000000006 Holstein 69% 37 0.0 πŸ” Needs Clarification
AAGG Breed_AAGG 36 0.0 ❓ Review Needed
0.36499999999999999 Holstein 36.5% 35 0.0 πŸ” Needs Clarification
GGFF Breed_GGFF 35 0.0 ❓ Review Needed
0.875 Holstein 87.5% 31 0.0 πŸ” Needs Clarification
FSXS Breed_FSXS 29 0.0 ❓ Review Needed
0.74970000000000003 Holstein 75% 20 0.0 πŸ” Needs Clarification
Jersey crosses Breed_Jersey crosses 20 0.0 ❓ Review Needed
0.54 Holstein 54% 18 0.0 πŸ” Needs Clarification
0.8 Holstein 80% 17 0.0 πŸ” Needs Clarification
FFXS Breed_FFXS 17 0.0 ❓ Review Needed
GGJJ Breed_GGJJ 17 0.0 ❓ Review Needed
SSFF Breed_SSFF 17 0.0 ❓ Review Needed
Guernsey crosses Breed_Guernsey crosses 14 0.0 ❓ Review Needed
VVVV Breed_VVVV 14 0.0 ❓ Review Needed
0.93799999999999994 Holstein 93.8% 11 0.0 πŸ” Needs Clarification
Masaai Breed_Masaai 8 0.0 ❓ Review Needed
XXXF Breed_XXXF 6 0.0 ❓ Review Needed
FFGG Breed_FFGG 3 0.0 ❓ Review Needed
Hereford Breed_Hereford 2 0.0 ❓ Review Needed
0.59 Holstein 59% 1 0.0 πŸ” Needs Clarification
Australian Illawarra Shorthorn Breed_Australian Illawarra Shorthorn 1 0.0 ❓ Review Needed
Fleckvieh Fleckvieh 1 0.0 βœ… Clear
Sahiwal crosses Breed_Sahiwal crosses 1 0.0 ❓ Review Needed

Problematic Breed Values Requiring Attention

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

Current Interpretation Logic

My current interpretation assumes: - Values like 0.3, 0.5, 0.6 represent Holstein crossbreeding percentages (30%, 50%, 60% Holstein genetics) - Value β€œ1” or β€œ1.0” represents Pure Holstein (100%) - β€œFleckvieh” is a distinct breed name

Questions for Richard: 1. Are the decimal values (0.3, 0.5, etc.) indeed Holstein crossbreeding percentages? 2. Should we interpret them differently? 3. Are there other breed codes we should be aware of? 4. How should we handle the unclear numeric values?

Next Steps: - Waiting for Richard’s clarification on breed coding system - Will finalize breed categorization once we have the proper interpretation - Meeting proposed for end of this week to discuss findings and next steps

Contact:
Generated: 2025-09-08 09:33:57.912679