|
|
convert data into matrix- awk
02-29-2012
check.awk
#! /usr/bin/awk
{
f1[$3]=1;
f2[$2]=1;
if(chk1[$1] != $1 )
{
klist++;
chk1[$1]=$1;
}
if(chk[$3"^"$2] != $1)
{
a[$3"^"$2]++;
chk[$3"^"$2]=$1;
}
}
END{
ORS="";
print " ";
for(j in f2)
{
print j" ";
c++;
if(c>5)
{
print " ";
}
}
print "\n";
for(i in f1)
{
print i;
for(k in f2)
{
l=i"^"k;
if(a[l] == "")
{
print " 0 ";
}
else
{
a[l]=(a[l]/klist)*100;
print " "a[l]" ";
}
}
print "\n";
}
}awk -f check.awk Input_File
|
|
|
|