[R] problem with applying where condition

Carlos J. Gil Bellosta cgb at datanalytics.com
Tue Jan 20 07:03:40 CET 2009


Hello,

You can merge both tables first and then select the rows and columns you
want. Do it the other way around if your tables are too big.

All you need you can read it at

?merge
?subset

Best regards,

Carlos J. Gil Bellosta
http://www.datanalytics.com


On Tue, 2009-01-20 at 11:03 +0530, venkata kirankumar wrote:
> Hi all,
> 
> I am a biggener in R-Project
> 
> I got one problem with applying *where condition*
> like
> 
> if 2 tables like
> table1:
> 
> empid    name       dep
>   101      kiran    solutions
>    102     ram      testing
>    103    pavan     database
> 
> table2:
> 
> empid       month       sal
>   101          Dec      9500
>   102          Dec      9800
>   103          Dec      8500
> 
> in first table i have to take *empid* with using the *name(kiran)*
> and after getting that *empid* i have to get *sal *with using that *empid*
> 
> can any one suggest how can I acheave this
> 
> 
> Thanks & regards;
> kiran
> 
> 	[[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.



More information about the R-help mailing list