I have data consisting of 2 columns of numbers:
1) A 10 digit id number (each # is unique and sequential)
2) a 4 digit group code (NOT unique)
Each ID number is associated with 1 of 40 possible group codes
In order to assign a group code to future ID numbers, I need to find the process used within the existing data (function/ Algorithym/ Key/ Method)
Does anyone know of a program, web application, software or something that would allow me to enter my data sets and find an answer to how they are related?