Search Results

awk -F, '{a[$1]++;b[$1]+=$2;min[$1]=(min[$1]==""||min[$1]>$2)?$2:min[$1];max[$1]=max[$1]>$2?max[$1]:$2}
END{for (i in a) print i, a[i],b[i]/a[i],min[i],max[i] |"sort -n"}' infile

B0000003 1...

Not fully understand your request. But if you just need to calculate the average for each name, try AWK's array, no need to sort the data

awk -F, '{a[$1]++;b[$1]+=$2}END{for (i in a) print i,...