[R] Merging tables

Carlos J. Gil Bellosta cgb at datanalytics.com
Tue Jan 20 15:13:41 CET 2009


Hello,

Use merge. 

Best regards,

Carlos J. Gil Bellosta
http://www.datanalytics.com


On Tue, 2009-01-20 at 13:41 +0000, Dry, Jonathan R wrote:
> I am relatively new to R and am trying to do some basic data manipulation.  Basically I have a table (csv - table 1) of data for a set of samples (rows), and a second table (table 2) of information about a subset of samples of particular interest.  I want to pull out the data from table 1 for the samples in table 2, either by:
> *	Merging the two tables based on a common identifier (SampleID - may have a different header in the two tables), and filter for overlapping entries (preferred approach)
> *	OR filter table 1 for entries where SampleID matches to one in a list taken from table 2
> 
> Any help would be gratefully recieved.
> 
> --------------------------------------------------------------------------
> AstraZeneca UK Limited is a company incorporated in Engl...{{dropped:21}}
> 
> ______________________________________________
> R-help at r-project.org mailing list
> 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.




More information about the R-help mailing list