= GEBVtest Merged Files =

The [[https://wiki.interbull.org/public/gebvtest_py?action=print|gebvtest.py]] program offers an option (''-m, --mergefiles'') to create a file of merged Cf/Df/Cr/Gr records as a convenience to the user. These files can make it easier to check for the correctness of the input datasets and they can be used perform additional checks and/or statistical analyses, using R for example as in this small [[attachment:test.R]]. 

One file is created for each trait present in the traits_POPBRD file and the file300Xy_POPBRD files. There is a record for each bull present in the Cf file born in/after the cutoff year specified in the traits_POPBRD file.
Flags are supplied to indicate whether the bull qualifies as a candidate or a test bull. Please see the file format below.

By default, the files are created in directory DATADIR/merged. The merged files do not have a _POPBRD extension, so if you would like to create files for more than one population or breed, you should also supply the ''-M, --mergedir'' option with a different destination directory for each population/breed. The destination directory can be an absolute path, or it can be relative to the programs directory (eg. ../sample_data/my_merges). The directory will be created automatically if it does not exist.

== File format ==

The file is in comma-separated-variable (csv) format, using commas as the separator. 

||'''Column'''||'''Variable'''||'''Type'''||'''Description'''||
||1||aid||char(19)||animal ID||
||2||byear||int||Birth year||
||3||geno||char(1)||Bull has a GEBV (Gr) record (Y/N)||
||4||cand||char(1)||Bull qualifies as a candidate bull (Y/N)||
||5||test||char(1)||Bull qualifies as a test bull (Y/N)||
||6||top||char(2)||Type of proof (from Cf file)||
||7||off||char(1)||Official proof (Y/N; from Cf file)||
||8||sta||char(2)||Bull status (from Cf file)||
||9||nd||int||Number of daughters (from Cf file)||
||10||nh||int||Number of herds (from Cf file)||
||11||Cf||char(2)||Fixed separator for Cf info||
||12||edc||int||EDC from Cf file||
||13||rel||real||Reliability from Cf file (x100)||
||14||ebv||real||Predicted genetic merit ("proof") from Cf file||
||15||Df||char(2)||Fixed separator for Df info||
||16||edcd||int||EDC from Df file||
||17||reld||real||Reliability from Df file (x100)||
||18||dpgm||real||DD or deregressed proof from Df file||
||19||Cr||char(2)||Fixed separator for Cr info||
||20||edcr||int||EDC from Cr file||
||21||relr||real||Reliability from Cr file (x100)||
||22||ebvr||real||Predicted genetic merit ("proof") from Cr file||
||23||Gr||char(2)||Fixed separator for Gr info||
||24||edcg||int||EDC from Gr file||
||25||relg||real||Reliability from Gr file (x100)||
||26||gebv||real||GEBV from Gr file||