Edit Question - KnowledgeHub

Title Body

What is the best way to determine a factor or create a new category field based on a number of boolean fields? In this example, I need to count the number of unique combinations of medications. > MultPsychMeds ID OLANZAPINE HALOPERIDOL QUETIAPINE RISPERIDONE 1 A 1 1 0 0 2 B 1 0 1 0 3 C 1 0 1 0 4 D 1 0 1 0 5 E 1 0 0 1 6 F 1 0 0 1 7 G 1 0 0 1 8 H 1 0 0 1 9 I 0 1 1 0 10 J 0 1 1 0 Perhaps another way to state it is that I need to pivot or cross tabulate the pairs. The final results need to look something like: Combination Count OLANZAPINE/HALOPERIDOL 1 OLANZAPINE/QUETIAPINE 3 OLANZAPINE/RISPERIDONE 4 HALOPERIDOL/QUETIAPINE 2 This data frame can be replicated in R with: MultPsychMeds <- structure(list(ID = structure(1:10, .Label = c("A", "B", "C", "D", "E", "F", "G", "H", "I", "J"), class = "factor"), OLANZAPINE = c(1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 0L, 0L), HALOPERIDOL = c(1L, 0L, 0L, 0L, 0L, 0L, 0L, 0L, 1L, 1L), QUETIAPINE = c(0L, 1L, 1L, 1L, 0L, 0L, 0L, 0L, 1L, 1L), RISPERIDONE = c(0L, 0L, 0L, 0L, 1L, 1L, 1L, 1L, 0L, 0L)), .Names = c("ID", "OLANZAPINE", "HALOPERIDOL", "QUETIAPINE", "RISPERIDONE"), class = "data.frame", row.names = c(NA, -10L))

Tags (comma-separated) Cancel