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]]
______________________________________________
[email protected] 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.
