Hi,
May be this might help:
set.seed(1)
df1<-data.frame(C1=sample(LETTERS[1:25],20,replace=FALSE),value=sample(50,20,replace=FALSE))
set.seed(15)
df2<-data.frame(C1=sample(LETTERS[1:25],15,replace=FALSE),C2=1:15)
set.seed(3)
df3<-data.frame(C1=sample(LETTERS[1:10],10,replace=FALSE),B1=rnorm(10,3))
set.seed(5)
df4<-data.frame(C1=sample(LETTERS[1:15],10,replace=FALSE),A2=rnorm(10,15))
df1$C1[df1$C1%in%df2$C1[df2$C1%in%df3$C1[df3$C1%in%df4$C1]]]
#[1] G E H J
A.K.
----- Original Message -----
From: Silvano Cesar da Costa <silvano at uel.br>
To: r-help at r-project.org
Cc:
Sent: Sunday, September 2, 2012 7:05 PM
Subject: [R] Common elements in columns
Hi,
I have 4 files with 10000 individuals in each file and 10 columns each.
One of the columns, say C1, may have elements in common with the other
columns C1 of other files.
If I have only 2 files, I can do this check with the command:
data1[data1 %in% data2]
data2[data2 %in% data1]
How do I check which common elements in the columns of C1 4 files?
Thanks,
---------------------------------------------
Silvano Cesar da Costa
Universidade Estadual de Londrina
Centro de Ci?ncias Exatas
Departamento de Estat?stica
Fone: (43) 3371-4346
______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.