Shell Programming and Scripting

Hi,

I am new to awk and trying to count the difference between the first columns of two CSV files.

--------
Sample input (header is:name, id1,id2):

file1.csv

Code:

name, id1,id2
sss,34,56
yyy,3,56
www,56,78
pppp,43,12

file2.csv

Code:

name,id1,id2
sss,32,56
yyy,12,7
ttt,4,8
uuu,7,9
eee,6,7

Sample Output:

Code:

Common:2
Different:5 (Dropped:2, Added:3)

--------

I have tried with the following code:

Code:

paste -d"," file1.csv file2.csv | awk 'BEGIN{FS=","}{
if($1!=$4)
    diff++
else if($1==$4)
       comm++
}
END{
print "diff:"count"\n"
print "comm:"comm"\n"
}'

The above code does not work if the order of the data in the input file is changed, even if the data is same.

Any idea/solution? Thank you very much, in advance, for your time and cooperation.