下面是三组数据:
dm1new dm2new data
0020312007-10-26, 0020312007-09-17, 1
0020312007-10-26, 0020312007-09-18, 2
0020312007-10-26, 0020312007-09-30, 3
0020312007-09-30, 0020312007-10-26, 4
0020312007-09-18,
0020312007-09-17,
您看上面有三个变量,其中dm1new中的日期都在dm2new中出现过,比如0020312007-10-26对应dm2new中的第4个。我现在想要的是对dm1new和dm2new进行配对,即配对出dm1new中的元素分别在dm2new中的什么位置,然后根据data数据,产生变量datanew
dm1new datanew dm2new data
0020312007-10-26, 4 , 0020312007-09-17 , 1
0020312007-10-26, 4 , 0020312007-09-18 , 2
0020312007-10-26, 4 , 0020312007-09-30 , 3
0020312007-09-30, 3 , 0020312007-10-26 , 4
0020312007-09-18, 2 ,
0020312007-09-17, 1 ,