Match multiple columns to find common elements
0
0
Entering edit mode
5.8 years ago

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.0k views
ADD COMMENT
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
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
1
Entering edit mode

Run this in R: ?merge

ADD REPLY
0
Entering edit mode

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

ADD REPLY
0
Entering edit mode

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

ADD REPLY

Login before adding your answer.

Traffic: 2015 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6