Finding if numbers fall within a range
Hello,
I think I've found a solution, but it's not producing the same answer as
what you're expecting. I think you might've mixed up row and column a few
times, but you should be able to alter the following to your needs. Also,
see ?.bincode:
EB <- matrix(data = c(
1, 271, 179, 359, 178,
57, 279, 279, 52, 239,
59, 59, 278, 118, 334
), nrow = 3, ncol = 5, byrow = TRUE)
# ranges <- list(
# c( 0, 60),
# c( 61, 120),
# c(121, 180),
# c(181, 240),
# c(241, 300),
# c(301, 360)
# )
breaks <- seq.int(0, 360, 60)
codes <- .bincode(EB, breaks, include.lowest = TRUE)
dim(codes) <- dim(EB)
num.ranges <- apply(codes, 1, function(xx) length(unique(xx)))
I hope this helps!
On Sat, Aug 28, 2021 at 11:57 AM Eliza Botto <eliza_botto at outlook.com>
wrote:
Dear useRs, Is there a way in R to see if the numbers in a matrix-row fall within the given range or not? For example, I have the following data;
dput(EB)
structure(c(1, 57, 59, 271, 279, 59, 179, 279, 278, 359, 52, 118, 178, 239, 334), .Dim = c(3L, 5L)) The ranges for which these numbers are to be reserved are; 0-60, 61-120, 121-180, 181-240, 241-300, 301-360 In row 1, the number "1", "57", and "59" fall 2ith the range 0-60. Whereas "271" and "279" falls within the range 241-300. So in total 2 ranges are covered and coding should execute 2 for row one. In row 2, the number "59" falls in the range 0-60, "179" falls in the range 121-180, "279" and "278" fall within the range 241-300, and 359 falls in the range 301-360. In total 4 ranges are covered for row 2. In the like-wise pattern, 5 ranges are covered in row 3. So, what I want is a matrix that looks in the following
dput(EBI)
structure(c(2, 4, 5), .Dim = c(3L, 1L))
Is there an easy way of doing it?
I thank you all very much in advance
EB
[[alternative HTML version deleted]]
______________________________________________ R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.