UNIX for Dummies Questions & Answers

0001 0023  5
0120 0376  6
0412 3412  3
...

0001 0023  3
0120 0376  nan
0412 3412  7
...

...

0001 0023  4
 0120 0376  6
 0412 3412  5

for i in $(seq 1 3); do awk -f t5.awk -v facc=acc$((i-1)).txt t$i.dat > acc$i.txt; rm acc$((i-1)).txt; done

awk '{
#criar o vector
BEGIN {
#variavel de contagem
i = 1
#ciclo que vai buscar a variavel facc
#cada linha é indexada ao vector a
while ((getline<facc)>0) {
    a[i]=$0
    i++
}
i = 1
soma +=$3
}
{ print a[i] " " soma
  i++
}'

awk 'END {
  for (k in sum) 
    print k, sum[k] / count[k]
  }
{ 
  sum[$1FS$2] += $3 == "nan" ? 0 : $3
  count[$1FS$2]++ 
  }' file[1-3]

awk 'END {
  for (k in sum) 
    print k, sum[k] / count[k]
  }
{ 
  sum[$1FS$2] += $3
  count[$1FS$2]++ 
  }' file[1-3]