Hi Abo, Please keep the list in cc.
I think the function documentation is pretty straight forward - two data.frames are required, and if you wish to keep elements that are not present in both data.frames, you set the flag all = TRUE. You also have the option to specify which columns to join by. If you need more assistance with joining two data.frames, you should provide a reproducible example, and if you have trouble with a function you should provide an example of what you have tried so far. Best wishes, Ulrik On Tue, 9 May 2017 at 10:00 abo dalash <abo_d...@hotmail.com> wrote: > Could you please teach me about the correct formation of the syntax?. I > have read the help page and other online resources about inner,left,&right > join but wasn't able to formulate the correct syntax. > > > Sent from my Samsung device > > > -------- Original message -------- > From: Ulrik Stervbo <ulrik.ster...@gmail.com> > Date: 09/05/2017 7:42 a.m. (GMT+00:00) > To: abo dalash <abo_d...@hotmail.com>, "r-help@R-project.org" < > r-help@r-project.org> > Subject: Re: [R] Joining tables with different order and matched values > > Hi Abo, > > ?merge > > or the join functions from dplyr. > > HTH > Ulrik > > On Tue, 9 May 2017 at 06:44 abo dalash <abo_d...@hotmail.com> wrote: > >> Hi All .., >> >> >> I have 2 tables and I'm trying to have some information from the 1st >> table to appear in the second table with different order. >> >> >> For Example, let's say this is my 1st table :- >> >> >> >> Drug name indications >> >> Ibuprofen Pain >> >> Simvastatin hyperlipidemia >> >> losartan hypertension >> >> >> >> my 2nd table is in different order for the 1st column :- >> >> >> Drug name indications >> >> >> Simvastatin >> >> losartan >> >> Ibuprofen >> >> Metformin >> >> >> I wish to see the indication of each drug in my 2nd table subsisted from >> the information in my 1st table so the final table >> >> would be like this >> >> >> Drug name indications >> >> >> Simvastatin hyperlipidemia >> >> losartan hypertension >> >> Ibuprofen pain >> >> Metformin N/A >> >> >> I have been trying to use Sqldf package and right join function but not >> able to formulate the correct syntax. >> >> >> I'm also trying to identify rows contain at least one shared value in a >> dataset called 'Values": >> >> >> >Values >> >> A B >> >> 1,2,5 3,8,7 >> >> 2,4,6 7,6,3 >> >> >> >> Columns A & B in the first row do not share any value while in the 2nd >> row they have a single shared value which is 6. >> >> The result I wish to see :- >> >> >> A B shared values >> >> 1,2,5 3,8,7 N/A >> >> 2,4,6 7,6,3 6 >> >> >> I tried this syntax : SharedValues <- Values$A == Values$B but this >> returns logical results and what I wish to have >> >> is a new data frame including the new vector "shared values" showing the >> information exactly as above. >> >> >> >> >> Kind Regards >> >> >> >> >> >> >> [[alternative HTML version deleted]] >> >> ______________________________________________ >> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see >> 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. >> > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.