in reply to Merge two huge datasets by ID
As long as there is enough memory in your computer to hold both files in a hash (use the contents of the ID column as the key), it is not "huge".
For any value above that, you are best advised to use a database, such as SQLite for which exists DBD::SQLite.
CountZero
A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James
|
|---|