This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Edit Column sex in ped file

I want to edit my column sex in ped file and place in numbers 2 and 1 instead of F and M . How do I do this Linux?

plink linux
• 4,854 views • link
written by mm • mm

Despite Individual ID Paternal ID Maternal ID- how to build Family ID?

• 0 views • link
written by mm • mm 
           yes
• 0 views • link
written by mm • mm

1 answer 

awk '{OFS="\t";if($5=="M") {$5="1";} else if($5=="F") {$5="2";} else {$5="0";}print;}' in.ped > out.ped
• 0 views • link
written by Pierre Lindenbaum Pierre Lindenbaum

The output file as follows: It seems that is wrong

SNP Chip    ID  Animal  0   Paternal
R950E03 111006  930226  910008  0   Resistant
R950E06 110917  950085  910043  0   Resistant
R950C09 110892  950085  910125  0   Resistant
R949B05 111101  870141  840409  0   Resistant
• 0 views • link
updated by WouterDeCoster WouterDeCoster • written by mm • mm

I assumed that the sex is in column $5 and there is no header:

$ echo "FAM ID FATHER MOTHER M" | awk '{OFS="\t";if($5=="M") {$5="1";} else if($5=="F") {$5="2";} else {$5="0";}print;}'
FAM ID  FATHER  MOTHER  1
• 0 views • link
written by Pierre Lindenbaum Pierre Lindenbaum

Log in to answer this question.

More posts like this