Yan Yan - 1 year ago 91
R Question

R how to find the intersection of a subest of vectors in a list

I have a list of vectors (characters). For example:

my_list <- list(c("a", "b", "c"),
c("a", "b", "c", "d"),
c("e", "d"))

For the intersection of all these three vectors, I could use:
Reduce(intersect, my_list)
. But as you can see, there is no common element in all three vectors.

Then, what if I want to find the common element that appears "at least" a certain amount of times in the list? Such as:
somefunction(my_list, time=2)
would give me
c("a", "b", "c", "d")
because those elements appear two times.


Answer Source

We can convert this to a data.table and do the group by action to get the elements

setDT(stack(setNames(my_list, seq_along(my_list))))[,
           if(uniqueN(ind)==2) values , values]$values
#[1] "a" "b" "c" "d"

A base R option would be to unlist the 'my_list', find the frequency count with the replicated sequence of 'my_list' using table, get the column sums, check whether it is equal to 2 and use that index to subset the names.

tblCount <- colSums(table(rep(seq_along(my_list), lengths(my_list)), unlist(my_list)))
#[1] "a" "b" "c" "d"
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download