I have 2 tables,T1 and T2. There are 4 columns of T1 and 2 columns of T2
T2
1. 990334. G21
2. 844047. G25
3. 281739. G37
4 280903. G002615
5 418546. G004657
The data in T1
V1V2V3 V4
1 T00015 AFP1 human G004657
2 T00035AP-2alphaA human G002615
3 T00036 AP-4 human G003918
4 T00040AR 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 AFP1human 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.