table(apply(A, 1, function(x){paste(x, collapse="")}))
Kissell, Robert [EQRE] wrote:
Hi,
I have a quick question regarding grouping data in R. I have the following matrix,
A = 0 1 1 0 1 0 0 1 1 0 0 1 1 1 0 0 1 0 0 1 0 1 1 0
I would like to learn how I can group the data on unique rows of A and also count the number of times the row occurred. The command unique(A) provides a matrix with the unique rows, i.e., B
B = 0 1 1 0 1 0 0 1 1 1 0 0
but I am also interested in learning how I can count the number of unque rows too. The result can be in either one or two matrices, e.g.,
B = 0 1 1 0 1 0 0 1 1 1 0 0
Count = 1 3 2
or,
C = 0 1 1 0 1 1 0 0 1 3 1 1 0 0 2
-- Chuck Cleland, Ph.D. NDRI, Inc. 71 West 23rd Street, 8th floor New York, NY 10010 tel: (212) 845-4495 (Tu, Th) tel: (732) 452-1424 (M, W, F) fax: (917) 438-0894
______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
