Shell Programming and Scripting

Name         All                        Maths               Science             English                 Social   
Anie         48/18  =   2.7        44/17  =   2.6         20/6   =   3.3        24/11  =   2.2            NA  
Edwin        134/41  =   3.3        96/30  =   3.2        34/10  =   3.4        50/18  =   2.8        12/2   =   6.0
Andrew       14/9   =   1.6        14/9   =   1.6         6/3   =   2.0         8/6   =    1.3             NA

Name         All                        Maths               Science             English                 Social 
Anie         28/19  =   1.5        26/18  =   1.4         5/4   =   1.2         21/14  =   1.5             NA  
Edwin         64/16  =   4.0        43/12  =   3.6        28/6   =   4.7        15/6   =   2.5            18/3 =  6.0
Andrew        118/41  =   2.9       110/39  =   2.8        61/17  =   3.6        49/22  =  2.2            NA

Name         All                        Maths               Science             English                 Social 
Anie         2.7/1.5 = 1.8            2.6/1.4 = 1.86      3.3/1.2 = 2.75      2.2/1.5 = 1.45             NA
Edwin        3.3/4.0 = 0.83           3.2/3.6 = 0.89      3.4/4.7 = 0.72      2.8/2.5 = 1.12            6.0/6.0 = 1.0
Andrew       1.6/2.9 = 0.55           1.6/2.8 = 0.57      2.0/3.6 = 0.56      1.3/2.2 = 0.59             NA

awk '
{
# got line from the input file
# store the needed values in s[]
for (i=4;i<=NF;i+=3) s[i]=$i
}
{
# get line from the 2nd input file
getline <f2
}
NR==1 {
# header line
print; next
}
{
# print name
print $1
# print the needed values, from s[] and current line
 for (j=4;j<=NF;j+=3) print s[j],$j
 print ""
}' f2=T2 T1

awk '
BEGIN { ffmt = "%s/%s = %.2f"                           # field format string
        mfmt = "%-12s %-26s %-19s %-17s %-25s %-s\n"    # main format string
}
function calc(numerator, denominator) {
        if(numerator == "NA" || denominator == "NA" || denominator == 0)
                return "NA"
        # You could check if the last character in the string produced
        # below is a "0" and remove it before returning the result if
        # not having a trailing zero is important.
        return sprintf(ffmt, numerator, denominator, numerator / denominator)
} 
FNR == 1 {
        # Print the header from one of the input files.
        if(NR == 1) print
        next
}
FNR == NR {
        # Get denominators for each field for a given name.  A data
        # field is in one of the following two formats:
        #               NA
        # or    num/den = val
        # so awk will see one field if the field contains NA and will
        # see three fields otherwise.
        f = 1
        for(i = 2; i <= NF; f++)
                if($i == "NA") {
                        d[$1, f] = $i
                        i++
                } else {d[$1, f] = $(i + 2)
                        i += 3
                }
        next 
}
{       # Get numerators for this line.
        f = 1
        for(i = 2; i <= NF; f++)
                if($i == "NA") {
                        n[f] = $i
                        i++
                } else {n[f] = $(i + 2)
                        i += 3
                }
        # Calculate and print results for the name on this line.
        printf(mfmt, $1, calc(n[1], d[$1, 1]), calc(n[2], d[$1, 2]),
                calc(n[3], d[$1, 3]), calc(n[4], d[$1, 4]),
                calc(n[5], d[$1, 5]))
}' T2 T1 > output