Re: [R] vlookup in R

From: jim holtman <jholtman_at_gmail.com>
Date: Mon, 24 Mar 2008 11:38:07 -0500

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?

______________________________________________
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.
Received on Mon 24 Mar 2008 - 16:50:23 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 24 Mar 2008 - 17:30:23 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive