[R] compate tow different data frame
arun
smartpink111 at yahoo.com
Wed Apr 17 14:33:33 CEST 2013
Hi,
dat1<- read.table(text="
V1 V2
A 1
B 2
C 1
D 3
",sep="",header=TRUE,stringsAsFactors=FALSE)
dat2<- read.table(text="
V3 V2
AAA 1
BBB 2
CCC 3
",sep="",header=TRUE,stringsAsFactors=FALSE)
library(plyr)
join(dat1,dat2,by="V2",type="full")
# V1 V2 V3
#1 A 1 AAA
#2 B 2 BBB
#3 C 1 AAA
#4 D 3 CCC
merge(dat1,dat2)
# V2 V1 V3
#1 1 A AAA
#2 1 C AAA
#3 2 B BBB
#4 3 D CCC
A.K.
>Dear R-users,
>
>I have the following 2 files;
>
>A
>
>V1 V2
>A 1
>B 2
>C 1
>D 3
>
>B
>
>V1 V2
>AAA 1
>BBB 2
>CCC 3
>
>
>I want to get this output
>
>C
>V1 V2 V3
>A 1 AAA
>B 2 BBB
>C 1 AAA
>D 3 CCC
>
>I want to compare A$V2 with B$V2, if it is the same, then append B$V1 to A.
>
>How to.... ??
>
>Please
More information about the R-help
mailing list