Shell Programming and Scripting

25,Jackson Steve,12,4,34,2,65,2
29,Jordan Mary,13,6,23,8,56,4,34,2
04,Leven Kate,14,6,15,6,26,4
34,Owen Chris,85,6,39,4,42,6,65,8,12,6

cat data.txt | awk -F, '{for (i=4;i<=NF;i+=2)if($i>=5) printf $i" ";printf"\n"}'

Jordan Mary avg 7
Leven Kate avg 6
Owen Chris avg 6.6

BEGIN {
        FS=","
}

{
        s = 0
        j = 0
        for (i=4; i <= NF; i +=2)
        if ($i >=5)
        {
                s += $i
                j++
        }
        if ( j == 0)
                next
        a = s / j
        if ( a >= 5 )
                print $2 " avg " a
}

$ awk -f avg.awk data.txt
Jordan Mary avg 7
Leven Kate avg 6
Owen Chris avg 6.5

for line in open("file"):
    line=line.rstrip()
    sl=line.split(",")
    t=[]
    num=[int(i) for i in sl[3::2]]
    for n in num:
        if n>=5:
            t.append(n)
    try:
        print "Avg: %s %.2f" % ( sl[1],sum(t)//len(t))
    except : pass

$ ./python.py
Avg: Jordan Mary 7.00
Avg: Leven Kate 6.00
Avg: Owen Chris 6.00

tr ',' '\n' < infile |
awk 'NR%2        {next}
     /^[A-Za-z]/ {n=$0;next}
     !/^[0-4]$/  {A[n]+=$1;B[n]++}
     END         {for (i in A) print i" avg "A[i]/B[i]}'

Jordan Mary avg 7
Leven Kate avg 6
Owen Chris avg 6.5

awk 'BEGIN       {RS="[,\n]"}
     NR%2        {next}
     /^[A-Za-z]/ {n=$0;next}
     !/^[0-4]$/  {A[n]+=$1;B[n]++}
     END         {for (i in A) print i" avg "A[i]/B[i]}' infile