R中實(shí)現(xiàn)vlookup功能可分為兩種情況:
1.同一數(shù)據(jù)框(data.frame)中匹配兩列變量,并創(chuàng)建新變量
data <- data.frame(x2=c("a","b","c","d","e","f","g","h","i","j"),x3=c(1:10),x4=c("b","c","d","e","f","g","h","i","",""))
data$x5<-data$x3[match(data$x4,data$x2)]
2.匹配兩個(gè)數(shù)據(jù)框則使用merge函數(shù)