[R] Query about merging two tables

Wensui Liu liuwensui at gmail.com
Tue Feb 6 16:50:58 CET 2007

subset(table1, rate != 999&id == table2$id)

On 2/6/07, lalitha viswanath <lalithaviswanath at yahoo.com> wrote:
> Hi
> I have table1 which has the foll. columns
> id age rate
> and table2 which has the foll. columns
> id count
> I wish to get data from table1 for all the ids which
> are persent in table2 and where the rate is not equal
> to 999.
> The ids in table2 are a subset of those in table1 and
> every id in table2 has an entry in table1.
> I would appreciate your input regarding the above.
> Thanks in advance
> Lalitha
> ______________________________________________
> R-help at stat.math.ethz.ch 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.

WenSui Liu
A lousy statistician who happens to know a little programming

More information about the R-help mailing list