I have 2 lists of numbers, and each of those lists is divided into two columns. These lists are quite large (> 100,000 entries) and each list has a different number of entries.
I need a program that can take the first list and compare the numbers in that list to the second list. That's my first hurdle; wtf?
Next is the comparison. I need to compare first column to first column and likewise for the second column. I need to start with a number in the first column and scan through the second list's first column looking for a duplicate to within +- 1. After this is done, I need to take the found entries and do the same procedure for the second column.
I'm lost. I'm a linux noob too, so if there are any handy programs out there that I just don't know of then that could help too.
I need a program that can take the first list and compare the numbers in that list to the second list. That's my first hurdle; wtf?
Next is the comparison. I need to compare first column to first column and likewise for the second column. I need to start with a number in the first column and scan through the second list's first column looking for a duplicate to within +- 1. After this is done, I need to take the found entries and do the same procedure for the second column.
I'm lost. I'm a linux noob too, so if there are any handy programs out there that I just don't know of then that could help too.