[R] vlookup in R

jim holtman jholtman at gmail.com
Mon Mar 24 17:38:07 CET 2008


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 <sachinj.2006 at yahoo.com> 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 <wwwhsd at gmail.com>
> To: Sachin J <sachinj.2006 at yahoo.com>
> Cc: r-help at 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 <sachinj.2006 at yahoo.com> wrote:
> > Hi,
> >
> >  Is there are function similar to excel vlookup in R. Please let me know.
> >
> >  Thanks,
> >  Sachin
> >
> >
> >      ____________________________________________________________________________________
> >
> >
> >        [[alternative HTML version deleted]]
> >
> >  ______________________________________________
> >  R-help at 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 at 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?



More information about the R-help mailing list