I have a dataset containing information about female cattle, with an ID column representing each cow, and columns for their sire (father) and dam (mother). Some cows may have their dam listed as another cow in the same dataset, meaning they have further generations. I need to create a new file to trace up to four generations back for each cow (including grandfather, grandmother, etc.).
- I have an Excel or text file with columns for ID, sire (SIRE), and dam (DAM) for each cow.
- Some cows may not have a sire or dam listed in the data.
can someone PLEASE help me with that?