This question (2 subquestions) is connected to How to speed up Select with MemberQ for large lists?
Q1: I would like to have an alternate version of the form below to do a multi-columns selection on large data sets. Speed is still very important.
I tried to do ...&[list1, list2, {1,3}, {2,3}]
and With[{t = Transpose[#1][[#3,#4]]
... but I wasn't successful
Q2: Also, I would like to use the form for a pattern similar to ! MemberQ
.
I tried ...,False]]]
but nothing happened. I am kind of clueless how I should go about this one..
Form:
With[{t = Transpose[#1][[#3]], t2 = Transpose[#2][[#4]]}, Pick[#1, Replace[t, Dispatch[ Thread[Rule[Intersection[t, t2], True]]], {1}]]] &[list1, list2, 2, 3]
Any tipp is welcome!