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.