I have two large data sets. The second data set depends most of the time on the first data sets. But the problem is, dependancy might not be immediate. For an example, in some cases it might be after two cases, in some other, it might be after three cases. There might be cases right on top of it as well. This grouping cannot be done manually as the data set is large. So need to have a code. Consider the following data sets as an example.
x=[5 3 10 11 1 12 2 2 15 3]; Y=[10 2 1 15 20 2 25 1 30 1];
Consider a case where x(1) to y(1), x(3) to y(4), x(4) to y(5), x(9) to y(9).One way I am thinking of is, compare X(i) with Y(i:i+3) and select the Y corresponding to X. It is better if the program it self decide what is the value for selecting lower values and upper values, but for this example consider it to be 10 for Y.
Thanks, Thishan
