Match multiple columns to find common elements

0

Entering edit mode

6.5 years ago

prakashpandey1111 ▴ 10

How to find common elements from multiple columns. say i have 20 columns(A,B,C...) & each column consists of number of elements. What i need is to find out common elements of column A in the rest of the remaining 19 columns & vice versa for other columns B,C..... & frequency

R • 2.1k views

ADD COMMENT • link updated 6.5 years ago by GenoMax 148k • written 6.5 years ago by prakashpandey1111 ▴ 10

0

Entering edit mode

Could you please provide some input in the form of a table and the R code on what you have tried so far?

ADD REPLY • link 6.5 years ago by Gjain 5.8k

0

Entering edit mode

I'm struggling to import table here. I used %in% but it compares 2 column at a time. I want to compare all of them simultaneously in single run

ADD REPLY • link 6.5 years ago by prakashpandey1111 ▴ 10

1

Entering edit mode

Run this in R: ?merge

ADD REPLY • link 6.5 years ago by Ram 44k

0

Entering edit mode

You need to post more complete code snippets than just a line to get useful answers.

ADD REPLY • link 6.5 years ago by GenoMax 148k

0

Entering edit mode

No need to use all caps. You tagged this "R" meaning you are looking for R based code?

ADD REPLY • link 6.5 years ago by GenoMax 148k

Login before adding your answer.