Gents,
Is there the possibility to improve this script to be able to have same output information.
I did this script, but I believe there is a very short code to get same output
here my script
awk -F, '{if($10>0 && $10<=15) print $6}' tmp1 | sort -k1n | awk '{a[$1]++} END { for (n in a ) print n, a[n]}' tmp1 > tmp2
awk -F, '{if($10>15.01 && $10<=25) print $6}' tmp1 | sort -k1n | awk '{a[$1]++} END { for (n in a ) print n, a[n]}' tmp1 > tmp3
awk -F, '{if($10>25.01 && $10<=35) print $6}' tmp1 | sort -k1n | awk '{a[$1]++} END { for (n in a ) print n, a[n]}'tmp1 > tmp4
awk -F, '{if($10>35.01 && $10<=50) print $6}' tmp1 | sort -k1n | awk '{a[$1]++} END { for (n in a ) print n, a[n]}' tmp1 > tmp5
awk -F, '{if($10>50.01 print $6}' tmp1 | sort -k1n | awk '{a[$1]++} END { for (n in a ) print n, a[n]}' tmp1 > tmp6
clear
awk 'NR==FNR{a[$1]=$2;next}
{if($1 in a){print $0,a[$1];delete a[$1]}
else print $0,"0"}
END{for(x in a)print x,"0",a[x]}' tmp2 tmp3 | sort -k1n > tmp1a
awk 'NR==FNR{a[$1]=$2;next}
{if($1 in a){print $0,a[$1];delete a[$1]}
else print $0,"0"}
END{for(x in a)print x,"0",a[x]}' tmp2 tmp4 | sort -k1n > tmp2a
awk 'NR==FNR{a[$1]=$2;next}
{if($1 in a){print $0,a[$1];delete a[$1]}
else print $0,"0"}
END{for(x in a)print x,"0",a[x]}' tmp2 tmp5 | sort -k1n > tmp3a
awk 'NR==FNR{a[$1]=$2;next}
{if($1 in a){print $0,a[$1];delete a[$1]}
else print $0,"0"}
END{for(x in a)print x,"0",a[x]}' tmp2 tmp6 | sort -k1n > tmp4a
paste tmp1a tmp2a tmp3a tmp4a > tmp1b
awk '{
printf("%5s%10s%10s%10s%10s%10s\n",
$1,$3,$2,$5,$8,$11)}' tmp1b > tmp10
the output i got:
2 1277 123 10 1 0
3 678 16 0 0 0
6 1344 14 2 0 0
8 1320 5 1 0 0
9 1349 3 0 0 0
10 880 34 3 0 0
11 1380 28 0 0 0
12 967 31 0 0 0
13 1094 6 1 0 0
14 832 27 1 0 0
15 1103 33 1 0 0
16 1485 14 1 0 0
17 716 651 10 0 0
18 959 16 2 0 0
19 1493 7 1 0 0
20 1234 28 0 0 0
21 350 9 0 0 0
22 1213 177 13 0 0
24 1324 25 0 0 0
25 276 1081 5 0 0
26 1389 39 4 0 0
27 282 1030 3 0 0
28 1251 73 7 1 0
input file attached. ( I have removed some lines from the file to short the size )
Thanks for your help.