Hi I would like to extend this item to the following: I have the following table
X1 X2 X3 value 1 BVEq AGR 11412 954.75 2 CA_Tot AGR 11412 970.59 ... > str(DC2_m) 'data.frame': 104160 obs. of 4 variables: $ X1 : Factor w/ 62 levels "BVEq","CA_Tot",..: 1 2 3 4 5 6 45 46 47 48 ... ..- attr(*, "names")= chr "Figure.1" "Figure.995" "Figure.17873" "Figure.17874" ... $ X2 : Factor w/ 48 levels "AGR","AKZ","ALB",..: 1 1 1 1 1 1 1 1 1 1 ... ..- attr(*, "names")= chr "1" "1" "1" "1" ... $ X3 : int 11412 11412 11412 11412 11412 11412 11412 11412 11412 11412 ... $ value: num 955 971 NA NA NA ... And I have a second (manual) table with entries of combinations of X2 and X3 which I want to exclude: > str(Exclude_Data) 'data.frame': 8 obs. of 2 variables: $ Code : Factor w/ 5 levels "ALB","ALQ","BAY",..: 3 3 2 4 5 3 1 2 $ Dates: int 12052 12233 12508 11960 13056 12142 12691 12783 subset(DC2_m, cbind(X2,X3) %in% Exclude_Data[]) Now the trick is to precisely exclude just the combinations chosen, and not all combinations of Exclude_Data[1] and Exclude_Data[2], which is what happens when doing two statements "X2 in ED[1]" AND "X3 in ED[3]". Any takers ? Thanks in advance Christian -- View this message in context: http://r.789695.n4.nabble.com/R-Subset-by-using-multiple-values-tp815278p3064226.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@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.
