[R] how do I extract all possible combinations of rows from a	column
    arun 
    smartpink111 at yahoo.com
       
    Tue Jan 21 21:57:49 CET 2014
    
    
  
Hi,
May be this helps:
library(gtools) 
as.data.frame(t(combinations(5,3,1:5)))
#  V1 V2 V3 V4 V5 V6 V7 V8 V9 V10
#1  1  1  1  1  1  1  2  2  2   3
#2  2  2  2  3  3  4  3  3  4   4
#3  3  4  5  4  5  5  4  5  5   5
A.K.
For a column of data, I need to extract all possible unique 
combinations of 3 rows and combine the results into a data frame (as 
columns). So, for example, if I had a column called "test" that had five rows (the contents of which were the numbers 1:5) all possible 
combinations of 3 rows would be 
1,2,3 
1,2,4 
1,2,5 
1,3,4 
1,3,5 
1,4,5 
2,3,4 
2,4,5 
2,4,5 
3,4,5 
So for this example, R would extract all the combinations shown, and I would get a data frame that looked like this 
1     1     1     1     1     1     2     2     2      3       
2     2     2     3     3     4     3     3     4      4   
3     4     5     4     5     5     4     5     5      5     
Note: I am not considering rearrangements of the same three rows
 to be unique. In other words, the combinations 123, 132, 213, 231, 312,
 321 are all the same as far as I am concerned. If it is not possible to
 do it that way, it will still be helpful, but not quite as helpful. 
Thanks for the help!
    
    
More information about the R-help
mailing list