Data Science, Python, Pandas.
subsets of rows into one final table, which means it will have to be transiently stored in one piece in memory, unfortunately… Depending on our luck with the data, it can be small enough or not. I tried that a couple of times and found it clogs my (16BG RAM laptop) memory, forcing the notebook