open my $CPUFILE, "<", $file or die "Unable to open sorted file $!"; my @col_total; my @col_count; my @col_average; while (<$CPUFILE>) { chomp; my @f = split /,/; shift @f; # remove the 1st column my $num_cols = scalar @f; for my $i (0 .. $num_cols-1) { my $val = $f[$i]; if ($val>0) { $col_count[$i]++; $col_total[$i] += $val; } } } for my $i (0 .. $#col_num) { $col_average[$i] = $col_total[$i]/$col_count[$i]; print "Column ", ($i + 2), " Average = $col_average[$i]\n"; } close $CPUFILE or die; my $total = 0; $total += $_ for @col_average; print "Average CPU Time for Column for all servers in cpuatest.dat file is "; print $total/@col_average, "\n";