|
|
Improve script
11-18-2016
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 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
11-18-2016
11-18-2016
11-18-2016
11-18-2016
.$10>0 && $10<=15 $10>15.01 && $10<=25 $10>25.01 && $10<=35 $10>35.01 && $10<=50 $10>50.01
>0-<=15 >15.01-<=25 >25.01-<=35 >35.01-<=50 >50.01
2 1277 123 10 1 0>0-<=15 >15.01-<=25 >25.01-<=35 >35.01-<=50 >50.01 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
|
|
|
|