Hi All, I'm having a few problems using match and a lookup table, previous Googling show numerous solutions to matching a lookup table to a dataset, My situation is slightly different as i have multiple lookup tables, (that i cannot merge - for integrity reasons) that i wish to match against my data, and each of these files is large, so lots of for / if conditions are not ideal. (withstanding that i have multiple files of course)
For example, I have data: > v <- c("foo", "foo", "bar", "bar", "baz") > id <- c(1,2) > id2 <- c(3) > name <- c("foo", "bar") > name2 <- c("baz") > df1 <- data.frame(id, name) > df2 <- data.frame(id2, name2) > v <- df1$id[match(v,df1$name)] > v [1] 1 1 2 2 NA So here i actually want to return > v [1] 1 1 2 2 "baz" so next time i can run v <- df2$id[match(v,df2$name)] and return: > v [1] 1 1 2 2 3 Any help very much appreciated Mike [[alternative HTML version deleted]] ______________________________________________ R-help@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.