Compare and count the matching values from different columns

Hi everyone,

I am working in a file where it consists of 4 columns of data. It contains the item number and price.We have to match the item and price from the first 2 columns with the item and price from the 3rd and 4th column. If the item matches, we have to compare the price. We have to count how many values are greater or lesser than the one listed in column 2 and display in a new column. I have given an example too.

Raw Data
Item1 Price1 Item1 Price2
A 2 a 4
B 3 a 1
C 3 b 1
D 1 c 3

Result should be
Item <Price > Price
A 1 1
B 1 0

Please help me solve it for me. We are working in a huge file and we are now working for days together to consolidate it since each will will have thousands of lines in it.

Thanks in Advance