Hello
I Have 2 tables with the folloing structure:
To calculate things like correlation, I want to create an new paired table like this:
I tried diffrent things, for example:
Timing[
d = Intersection[smi[[;; , 1]], abb[[;; , 1]]];
p1 = Flatten[Position[Map[MemberQ[d, #] &, smi[[;; , 1]]], True]];
p2 = Flatten[Position[Map[MemberQ[d, #] &, abb[[;; , 1]]], True]];
paired = Transpose[{d, smi[[p1, 2]], abb[[p2, 2]]}];
]
The Problem is, that this is really slow (4 seconds for about 6000 dates). I think there must be a simple and much faster solution than mine. I would be happy for a little help!
