Is this what you want? > control <- data.frame(V1=c("A","B","C","D","F"), V2=c("R","R","R","B","B")) > test <- data.frame(V3=sample(c("A","B","C","D","F"), 10, TRUE), v4='') > test V3 v4 1 A 2 F 3 B 4 F 5 B 6 B 7 C 8 F 9 F 10 B > test$V4 <- control$V2[match(test$V3, control$V1)] > test V3 v4 V4 1 A R 2 F B 3 B R 4 F B 5 B R 6 B R 7 C R 8 F B 9 F B 10 B R
On 3/24/08, Sachin J <[EMAIL PROTECTED]> wrote: > Hi Henrique, > > This is what I am trying to accomplish: > I want to read values in V1 and V2 and populate the column V4 with R or B > based on the > values in V3 i.e. if its A,B,C then its R else if D,F then B. You can assume > V1, V2 are dataframe1 > and V3, V4 are in dataframe2 (note V4 is empty initially i.e. its a new > column). > > > df1 > V1V2 > A R > BR > CR > DB > FB > > > df2 > > V3V4 > AR > CR > DB > FB > AR > CR > BR > BR > BR > BR > AR > DB > > > > Thanks in advance for your help. > > > > ----- Original Message ---- > From: Henrique Dallazuanna <[EMAIL PROTECTED]> > To: Sachin J <[EMAIL PROTECTED]> > Cc: r-help@r-project.org > Sent: Monday, March 24, 2008 10:41:52 AM > Subject: Re: [R] vlookup in R > > I think that merge is what you want: > > set.seed(24032008) > x <- data.frame(ID=sample(10), Value=rnorm(10)) > idx <- sample(5) > merge(idx, x, by.x=1, by.y=1) > > On 24/03/2008, Sachin J <[EMAIL PROTECTED]> wrote: > > Hi, > > > > Is there are function similar to excel vlookup in R. Please let me know. > > > > Thanks, > > Sachin > > > > > > > > ____________________________________________________________________________________ > > > > > > [[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. > > > > > -- > Henrique Dallazuanna > Curitiba-Paraná-Brasil > 25° 25' 40" S 49° 16' 22" O > > > > ____________________________________________________________________________________ > > > [[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. > > -- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem you are trying to solve? ______________________________________________ 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.