rdplyrintersectionintersectdimensional

Common elements by columns in high-dimensional matrix

I have a data like original with much more columns.

id <- c('A','B','C', 'D', 'E', 'F', 'G')
month <- c('NA', 'D', 'H', 'I', 'A', 'B', 'NA')
iso <- c('NA', 'NA', 'NA', 'A', 'B', 'C', 'NA')
original <- data.frame(id, month, iso)

I want to create a string containing all common elements found in the columns, like string common:

common <- c("A", "B")

I have found posts like: R: How can I find the intersection of elements from two rows of a dataframe? or like: How to find common elements from multiple vectors?

But these posts do not make the trick. In such a high-dimensional dataset I need something "less manual".

Any clue?

Thank you

Solution

  • Using purrr

    library(purrr)
reduce(original, intersect)
#[1] "A" "B"