Hostname: page-component-74656f9884-c52kr Total loading time: 0 Render date: 2026-11-07T07:38:16.031Z Has data issue: false hasContentIssue false

Data pre-processing to improve the mining of large feed databases

Published online by Cambridge University Press:  08 March 2013

F. Maroto-Molina*
Affiliation:
Servicio de Información sobre Alimentos, Universidad de Córdoba, Ctra. Nacional IV km. 396, 14014, Córdoba, Spain
A. Gómez-Cabrera
Affiliation:
Departamento de Producción Animal, ETS Ingeniería Agronómica y de Montes, Universidad de Córdoba, Ctra. Nacional IV km. 396, 14014, Córdoba, Spain
J. E. Guerrero-Ginel
Affiliation:
Departamento de Producción Animal, ETS Ingeniería Agronómica y de Montes, Universidad de Córdoba, Ctra. Nacional IV km. 396, 14014, Córdoba, Spain
A. Garrido-Varo
Affiliation:
Departamento de Producción Animal, ETS Ingeniería Agronómica y de Montes, Universidad de Córdoba, Ctra. Nacional IV km. 396, 14014, Córdoba, Spain
D. Sauvant
Affiliation:
UMR 791 Physiologie de la nutrition et de l'alimentation, AgroParisTech, 16 rue Claude Bernard, 75231, Paris, Cedex 05, France
G. Tran
Affiliation:
Association Française de Zootechnie, AgroParisTech, 16 rue Claude Bernard, 75231, Paris, Cedex 05, France
V. Heuzé
Affiliation:
Association Française de Zootechnie, AgroParisTech, 16 rue Claude Bernard, 75231, Paris, Cedex 05, France
D. C. Pérez-Marín
Affiliation:
Departamento de Producción Animal, ETS Ingeniería Agronómica y de Montes, Universidad de Córdoba, Ctra. Nacional IV km. 396, 14014, Córdoba, Spain
*
†E-mail: g02mamof@uco.es

Abstract

The information stored in animal feed databases is highly variable, in terms of both provenance and quality; therefore, data pre-processing is essential to ensure reliable results. Yet, pre-processing at best tends to be unsystematic; at worst, it may even be wholly ignored. This paper sought to develop a systematic approach to the various stages involved in pre-processing to improve feed database outputs. The database used contained analytical and nutritional data on roughly 20 000 alfalfa samples. A range of techniques were examined for integrating data from different sources, for detecting duplicates and, particularly, for detecting outliers. Special attention was paid to the comparison of univariate and multivariate solutions. Major issues relating to the heterogeneous nature of data contained in this database were explored, the observed outliers were characterized and ad hoc routines were designed for error control. Finally, a heuristic diagram was designed to systematize the various aspects involved in the detection and management of outliers and errors.

Information

Type
Nutrition
Copyright
Copyright © The Animal Consortium 2013 
Figure 0

Table 1 Fields and available data points in the database of alfalfa extracted from the data warehouse of the TRC project

Figure 1

Table 2 Duplicates detected in the database of alfalfa extracted from the data warehouse of the TRC project (categorized by number of available data points per sample)

Figure 2

Table 3 Outliers detected by univariate and bivariate methods in the database of alfalfa extracted from the data warehouse of the TRC project

Figure 3

Table 4 Outliers detected by multivariate methods in the database of alfalfa extracted from the data warehouse of the TRC project (as a function of number of variables considered by the algorithm)

Figure 4

Table 5 Number of samples with common outliers detected by different methods (univariate and multivariate) in the database of alfalfa extracted from the data warehouse of the TRC project

Figure 5

Table 6 Ad hoc error-detection filters designed on the basis of the analysis of the features of outliers flagged by standard methods (univariate and multivariate) in the database containing the information on alfalfa stored in the data warehouse of the TRC project plus expert knowledge of the relationships between variables

Figure 6

Figure 1 Comparison of data points flagged as outliers using standard tests and as errors using ad hoc filters. Many data points are not flagged as outliers by standard tests, but they are flagged as errors by ad hoc filters. Some of these data have a strong influence in the relationship between OMdTT and DMdTT.

Figure 7

Figure 2 Heuristic diagram for the management of outliers and errors in feed databases.

Supplementary material: Image

Maroto Molina Supplementary Material

Appendix

Download Maroto Molina Supplementary Material(Image)
Image 664 KB