Hi all:
I have two data sets. Set A includes a long list of hits in a single
column, say:
m$V1
10
15
36
37
38
44
45
57
61
62
69 ...and so on
Set B includes just a few key ranges set up by way of a minimum in column X
and a maximum in column Y. Say,
n$X n$Y
30 38 # range from 30 to 38
52 62 # range from 52 to 62
I would like the output to be the rows containing the following columns:
m$V1
36
37
38
57
61
62
I am interested in isolating the hits in data set A that correspond to any
of the "hotspot" ranges in data set B. I have downloaded sqldf and tried a
couple things but I cannot do a traditional merge since set B is based on a
range. I can always do a manual subset but I am trying to figure out if
there is anything more expedient since these df's will be quite large.
Thanks!
Matt
[[alternative HTML version deleted]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
