Dear John I suspect ?merge will help here.
You would need to tidy up afterwards (or before) if you do not want the other columns in your dataframe of keys to be included in the result.
On 19/10/2015 11:19, John Wasige 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.
-- Michael http://www.dewey.myzen.co.uk/home.html ______________________________________________ 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.
