Re: [R] Match and replace between two data.frames

HI, Perhaps: cbind(ID=DF$ID,as.data.frame(sapply(levels(VAL$type), function(x){DF[,x]=VAL$number[VAL$type==x];DF[,x]}))) On 25/10/2007, Lauri Nikkinen <[EMAIL PROTECTED]> wrote: > > Hi folks, > > I have two dataframes like these: > > DF <- data.frame(ID=c("AA1234","AB3233","AC4353","AD2345","AE

[R] Match and replace between two data.frames

Hi folks, I have two dataframes like these: DF <- data.frame(ID=c("AA1234","AB3233","AC4353","AD2345","AE7453"), CK32344=c(1,3,2,4,1), CK32664=c(2,1,1,2,3), CK33422=c(2,2,1,3,2)) VAL <- data.frame(num=rep(6,3), type=c("CK32344", "CK32664", "CK33422"), number=c("32","452","234")) I want to replac