Try ?merge Ted.
On 25-Mar-08 22:32:29, Kris Ghosh wrote: > I have 2 tables,T1 and T2. There are 4 columns of T1 and 2 columns of > T2 > T2 > > 1. 990334. G000021 > 2. 844047. G000025 > 3. 281739. G000037 > 4 280903. G002615 > 5 418546. G004657 > > The data in T1 > V1 V2 V3 V4 > 1 T00015 AFP1 human G004657 > 2 T00035 AP-2alphaA human G002615 > 3 T00036 AP-4 human G003918 > 4 T00040 AR human G004953 > 5 T00045 COUP-TF2 human G004656 > > > I want to construct T3 that has all the columns of T1 and T2 with the > common > GOO$$$$ (common elements of column 4 of T1 and column 2 of T2.). I > used > "match" but it did not work. > > T3 should look like where G002615 and G004657 are common. > > T00015 AFP1 human G004657 418546. > T00035 AP-2alphaA human G002615 280903. > > any help would be appreciated. > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@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. -------------------------------------------------------------------- E-Mail: (Ted Harding) <[EMAIL PROTECTED]> Fax-to-email: +44 (0)870 094 0861 Date: 25-Mar-08 Time: 22:55:39 ------------------------------ XFMail ------------------------------ ______________________________________________ R-help@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.
