Re: [R] Efficient means to link two data frames

2016-09-29 Thread Ben Tupper
Hi, I have a solution based upon findInterval() which depends upon the ordered nature of the 'Day' column. I can't speak to whether or not it is efficient but it is handy. I love the findInterval() function but have often wished it works with look up tables in descending order. This function

[R] Efficient means to link two data frames

2016-09-29 Thread Dennis Fisher
R 3.3.1 OS X Colleagues, I have two large data frames that I am trying to link efficiently. A small example is as follows: structure(list(Day = c(1L, 2L, 3L, 5L, 6L, 7L, 8L, 9L, 10L, 11L, 13L, 14L, 16L, 17L, 18L, 19L, 20L, 21L, 22L, 23L, 24L, 25L, 26L, 27L, 28L, 29L, 30L), Value = c(76, 11