[R] Newbie question

From: Kris Ghosh <mathkris_at_gmail.com>
Date: Tue, 25 Mar 2008 18:32:29 -0400


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. Received on Wed 26 Mar 2008 - 01:59:07 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 26 Mar 2008 - 03:30:24 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive