I have a huge data set which I imported using fread function of data.table. It has a ID column and has 125 million rows.
I have another data set which is like 1000 rows with the ID column only. I want to filter the former data set as per the IDs in the latter one. Can you suggest me some ways to achieve this?
using merge to inner join times out. I tried %n% to get the row numbers also fails. Any smarter way?