[R] merging issue.........
Heinz Tuechler
tuechler at gmx.at
Wed Jan 13 23:28:12 CET 2010
Did you consider to look at the help page for merge?
h
At 22:01 13.01.2010, karena wrote:
>hi, I have a question about merging two files.
>For example, I have two files, the first file is like the following:
>
>id trait1
>1 10.2
>2 11.1
>3 9.7
>6 10.2
>7 8.9
>10 9.7
>11 10.2
>
>The second file is like the following:
>id trait2
>1 9.8
>2 10.8
>4 7.8
>5 9.8
>6 10.1
>12 10.2
>13 10.1
>
>now I want to merge the two files by the variable "id", I only want to keep
>the "id"s which show up in the first file. Even the "id" does not show up in
>the second file, it doesn't matter, I can keep the missing values. So my
>question is: how can I merge the two files and keep only the rows whose "id"
>show up in the first file?
>I know how to do it is SAS, just use the following code:
>merge data1(in=in1) data2(in=in2);
>by id;
>if in1;
>
>but I really have no idea about how to do it in R.
>
>thank you in advance,
>
>karean
>--
>View this message in context:
>http://n4.nabble.com/merging-issue-tp1013356p1013356.html
>Sent from the R help mailing list archive at Nabble.com.
>
>______________________________________________
>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.
More information about the R-help
mailing list