in reply to DBI and fetchall_arrayref (gosh!)
my @sum; my @num; while (<DATA>) { my @data = split; $_ = (defined and $_ != -1)? $_ : '-' for @data; $sum[$_]+=$data[$_], $num[$_]++ for grep { $data[$_] ne '-' } 0..$#data } print "@{[map { $sum[$_]/$num[$_] } 0..$#sum]}\n"; __DATA__ 1 2 3 4 2 3 4 5
|
|---|