I all you are doing is matching a single column and then extracting rows that match, then the '%in%' operator should work:
indx <- reg6idGlobal$alloc_key %in% req6id_subsample_key$alloc_key my_subset <- reg6idGlobal[indx, ] Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it. On Mon, Oct 19, 2015 at 6:19 AM, John Wasige <johnwas...@gmail.com> wrote: > Hi, I need help on how to sub-sample my data in R. I have two tables, one > table with global dataset and another with a list of codes for sub sample > the global dataset. > > > Download link > > > > https://www.wetransfer.com/downloads/a53aa3f722b2d2887b60b09239f7c4e620151018152100/ad852e > > > > All these tables have a column called: alloc_key. I want to use the list > of codes in reg6id_subsample_key.csv to extract all raws from > reg6idGlobal.csv for matching/ similar codes in column alloc_key of > reg6idGlobal.csv file. > > > Somebody with an idea on how I can go about doing this? > > Thanks for your help > > John > > > > > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
