s-news
[Top] [All Lists]

Merge with conditional row removal

To: s-news@lists.biostat.wustl.edu
Subject: Merge with conditional row removal
From: Thom Burnett <Thom.Burnett@cognigencorp.com>
Date: Thu, 30 Sep 2004 11:31:27 -0400
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113
How do I subset a data frame so that it has no rows with a column value that exists in another data frame?

As an example:

fullData:
ID AGE
1    25
2    13
3    36
4    55
5    36

moreData:

ID BMI
2    23.3
4    27.4

fullMinusMore:

ID AGE
1    25
3    36
5    36

What I seem to need is a method that compares to vectors (or better data frames columns) and tells me if any element of A is in B.
Then I can NOT that and select the remaining rows.

Are there UNION and INTERSECTION operators in S+?

<Prev in Thread] Current Thread [Next in Thread>
  • Merge with conditional row removal, Thom Burnett <=