Searching the closest but "less than or equal to" values in other column

Asked Feb 18 '15 at 14:21

Active Feb 18 '15 at 14:49

Viewed 112 times

Suppose we have a data frame of two columns

For the first element of Y, that is 11, the closest but "less than or equal to" in X is 10 (which is 2nd element of X). Similarly, For next element of Y, that is 14, the closest but "less than or equal to" is 13 that is 3rd element of X

So, the output should be

As my data is large, Can you suggest me the right way to do it ? (Note: Max of "less than or equal to " is same as "the closest but less than or equal to")

edited Feb 18 '15 at 14:49

asked Feb 18 '15 at 14:21

Navin Manaswi

Please read this: http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example – Metrics Feb 18 '15 at 14:26
Why is, in the case of 14, the max of "less than or equal to" 13. Isn't it 14? – rmuc8 Feb 18 '15 at 14:27
1

If `df$X` is ordered, a simple `findInterval(df$Y,df$X)` should work. – nicola Feb 18 '15 at 14:50
@nicola if you can't find a dupe you should probably post it. – David Arenburg Feb 18 '15 at 15:15

Searching the closest but "less than or equal to" values in other column

0 Answers0