I have a tab delim file
1A 865 508 512 0 2 0 0 1B 0 0 0 0 0 0 1 I need to divide every col from $3 on by $2 and multiply the resulting by 100 line by line, printing NA where division by 0.
So that I have
1A 865 58.73 59.19 0.00 0.23 0.00 0.00 0.00 0.00 1B 0 NA NA NA NA NA NA NA NA I tried
awk 'BEGIN{FS=OFS="\t"} FNR>1 {for(i=3;i<=NR;i++) $i={print $0"\t"($2?$i/$2*100:"NaN")1}' but I get "unexpected newline or end of string"
没有评论:
发表评论