How to get difference of the same column between two files when other column matches?

Shell Programming and Scripting
1

File 1:

20130416,235800,10.78.25.104,BR2-loc,60.0,1624,50.0,0,50.0,0
20130416,235800,10.78.25.104,BR1-LOC,70.0,10,50.0,0,70.0,0
20130416,235800,10.78.25.104,Hub_None,60.0,15,60.0,0,50.0,0

File 2:

20130417,000200,10.78.25.104,BR2-loc,60.0,1626,50.0,0,50.0,0
20130417,000200,10.78.25.104,BR1-LOC,70.0,12,50.0,0,70.0,0
20130417,000200,10.78.25.104,Hub_None,60.0,17,60.0,0,50.0,0

I have to compare these two files, match the third and fouth column and if they matches, should do the diff of fourth column. How can I do it ?

i.e i should get output like

20130417,000200,10.78.25.104,BR2-loc,60.0,2,50.0,0,50.0,0
20130417,000200,10.78.25.104,BR1-LOC,70.0,2,50.0,0,70.0,0
20130417,000200,10.78.25.104,Hub_None,60.0,2,60.0,0,50.0,0
2

You mean the difference of the sixth column, don't you?

3

yes. If the third and fourth column matches need to get the difference of 6th column

4 
$ cat temp.sh
paste -d "," file1 file2 > pasted.txt
awk 'BEGIN { FS = OFS = "," } \
  $3 == $13 && $4 == $14 { \
    print $11, $12, $13, $14, $15, $16 - $6, $17, $18, $19, $20 \
    }' pasted.txt

$ ./temp.sh
20130417,000200,10.78.25.104,BR2-loc,60.0,2,50.0,0,50.0,0
20130417,000200,10.78.25.104,BR1-LOC,70.0,2,50.0,0,70.0,0
20130417,000200,10.78.25.104,Hub_None,60.0,2,60.0,0,50.0,0