# Setup the translation map transMap <- c(A="R", B="R", C="R", D="B", F="B");
# The input data v3 <- c("A", "C", "D", "F", "A", "C", "B", "B", "B", "B", "A", "D"); # The translated data v4 <- transMap[v3]; df2 <- data.frame(V3=v3, V4=v4); I recommend you to read 'An Introduction to R' that comes with any R installation. There is a lot of useful stuff in there; it takes many reads to grasp parts of it but it is worth it if you're going to use R for more than, say, two weeks. You can find it via help.start(). /Henrik On Mon, Mar 24, 2008 at 8:25 AM, 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. > > ______________________________________________ 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.