Newbie question
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 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.
-------------------------------------------------------------------- E-Mail: (Ted Harding) <Ted.Harding at manchester.ac.uk> Fax-to-email: +44 (0)870 094 0861 Date: 25-Mar-08 Time: 22:55:39 ------------------------------ XFMail ------------------------------