title: Novel approaches to assess the quality of fertility data stored in dairy herd management software.
abstract: Scientific journals and popular press magazines are littered with articles in which the authors use data from dairy herd management software. Almost none of such papers include data cleaning and data quality assessment in their study design despite this being a very critical step during data mining. This paper presents 2 novel data cleaning methods that permit identification of animals with good and bad data quality. The first method is a deterministic or rule-based data cleaning method. Reproduction and mutation or life-changing events such as birth and death were converted to a symbolic (alphabetical letter) representation and split into triplets (3-letter code). The triplets were manually labeled as physiologically correct, suspicious, or impossible. The deterministic data cleaning method was applied to assess the quality of data stored in dairy herd management from 26 farms enrolled in the herd health management program from the Faculty of Veterinary Medicine Ghent University, Belgium. In total, 150,443 triplets were created, 65.4% were labeled as correct, 17.4% as suspicious, and 17.2% as impossible. The second method, a probabilistic method, uses a machine learning algorithm (random forests) to predict the correctness of fertility and mutation events in an early stage of data cleaning. The prediction accuracy of the random forests algorithm was compared with a classical linear statistical method (penalized logistic regression), outperforming the latter substantially, with a superior receiver operating characteristic curve and a higher accuracy (89 vs. 72%). From those results, we conclude that the triplet method can be used to assess the quality of reproduction data stored in dairy herd management software and that a machine learning technique such as random forests is capable of predicting the correctness of fertility data.
authors.affiliation: Faculty of Veterinary Medicine, Department of Reproduction, Obstetrics and Herd Health, Ghent University, Salisburylaan 133, 9820 Merelbeke, Belgium. Electronic address: kristofhermans@bovinet.be.
authors.forename: K
authors.initials: K
authors.lastname: Hermans
authors.affiliation: Faculty of Bioscience Engineering, Department of Mathematical Modelling, Statistics and Bioinformatics, Ghent University, Coupure Links 653, 9000 Ghent, Belgium.
authors.forename: W
authors.initials: W
authors.lastname: Waegeman
authors.affiliation: Faculty of Veterinary Medicine, Department of Reproduction, Obstetrics and Herd Health, Ghent University, Salisburylaan 133, 9820 Merelbeke, Belgium.
authors.forename: G
authors.initials: G
authors.lastname: Opsomer
authors.affiliation: Faculty of Veterinary Medicine, Department of Reproduction, Obstetrics and Herd Health, Ghent University, Salisburylaan 133, 9820 Merelbeke, Belgium.
authors.forename: B
authors.initials: B
authors.lastname: Van Ranst
authors.affiliation: Faculty of Veterinary Medicine, Department of Reproduction, Obstetrics and Herd Health, Ghent University, Salisburylaan 133, 9820 Merelbeke, Belgium.
authors.forename: J
authors.initials: J
authors.lastname: De Koster
authors.affiliation: Faculty of Veterinary Medicine, Department of Reproduction, Obstetrics and Herd Health, Ghent University, Salisburylaan 133, 9820 Merelbeke, Belgium.
authors.forename: M
authors.initials: M
authors.lastname: Van Eetvelde
authors.affiliation: Faculty of Veterinary Medicine, Department of Reproduction, Obstetrics and Herd Health, Ghent University, Salisburylaan 133, 9820 Merelbeke, Belgium.
authors.forename: M
authors.initials: M
authors.lastname: Hostens
mesh_terms: D000465:Algorithms; D000818:Animals; D003612:Dairying; D005298:Fertility; D012098:Reproduction; D012984:Software
keywords: dairy herd management software; dairy reproduction; data quality; random forests