Re: [R] match in dependence of 2 columns
Hello, You can do something like this: join(dat1, dat2[, c(cu.nr, name, value)], by=c(cu.nr.,name),type=right) Hope this helps, Rui Barradas Em 14-02-2013 07:03, Mat escreveu: thank you, this code works: library(plyr) join(dat1,dat2,by=c(cu.nr.,name),type=right) but my dat2 frame has a lot of columns, which i don't want to match. How can i say, that only the column value should be match to dat1 ? Thank you. Mat -- View this message in context: http://r.789695.n4.nabble.com/match-in-dependence-of-2-columns-tp4658405p4658508.html Sent from the R help mailing list archive at Nabble.com. __ 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.
Re: [R] match in dependence of 2 columns
HI, If the dataset is similar to this: dat1- read.table(text= cu.nr. name value A 1 Evo 100 B 1 Mer 80 C 2 Ford 50 ,sep=,header=TRUE,stringsAsFactors=F) dat2- read.table(text= cu.nr. name value2 value3 A 33 Evo 60 120 B 1 Mer 40 90 C 1 Pold 20 30 ,sep=,header=TRUE,stringsAsFactors=F) library(plyr) join(dat1,subset(dat2,select=c(cu.nr.,name)),by=c(cu.nr.,name),type=right) # cu.nr. name value #1 33 Evo NA #2 1 Mer 80 #3 1 Pold NA #or join(dat1,dat2[,c(cu.nr.,name)],by=c(cu.nr.,name),type=right) A.K. - Original Message - From: Mat matthias.we...@fnt.de To: r-help@r-project.org Cc: Sent: Thursday, February 14, 2013 2:03 AM Subject: Re: [R] match in dependence of 2 columns thank you, this code works: library(plyr) join(dat1,dat2,by=c(cu.nr.,name),type=right) but my dat2 frame has a lot of columns, which i don't want to match. How can i say, that only the column value should be match to dat1 ? Thank you. Mat -- View this message in context: http://r.789695.n4.nabble.com/match-in-dependence-of-2-columns-tp4658405p4658508.html Sent from the R help mailing list archive at Nabble.com. __ 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.
[R] match in dependence of 2 columns
Hello, i want to match a column of one data.frame to another, my problem is, that i only want to match the data, if 2 columns are equal. i have a example: data.frame1 cu.nr. name value A 1 Evo 100 B 1 Mer 80 C 2 Ford50 And now i want to match the value to data.frame 2 in dependence of cu.nr. and name. data.frame2 cu.nr. name A 33 Evo B 1 Mer C 1 Pold as you can see, there is only one row with equal cu.nr. and name. How can i match the data as desired? The solution has to look like this one: cu.nr. name Value A 33 Evo B 1 Mer 80 C 1 Pold thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com/match-in-dependence-of-2-columns-tp4658405.html Sent from the R help mailing list archive at Nabble.com. __ 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.
Re: [R] match in dependence of 2 columns
?merge If I have not reversed the data sets this should work With data sets called dat1 and dat2 merge(dat1,dat2, all.y = TRUE) John Kane Kingston ON Canada -Original Message- From: matthias.we...@fnt.de Sent: Wed, 13 Feb 2013 06:39:57 -0800 (PST) To: r-help@r-project.org Subject: [R] match in dependence of 2 columns Hello, i want to match a column of one data.frame to another, my problem is, that i only want to match the data, if 2 columns are equal. i have a example: data.frame1 cu.nr. name value A 1 Evo 100 B 1 Mer 80 C 2 Ford50 And now i want to match the value to data.frame 2 in dependence of cu.nr. and name. data.frame2 cu.nr. name A 33 Evo B 1 Mer C 1 Pold as you can see, there is only one row with equal cu.nr. and name. How can i match the data as desired? The solution has to look like this one: cu.nr. name Value A 33 Evo B 1 Mer 80 C 1 Pold thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com/match-in-dependence-of-2-columns-tp4658405.html Sent from the R help mailing list archive at Nabble.com. __ 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. FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop! __ 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.
Re: [R] match in dependence of 2 columns
Hello, Try the following. data.frame1 - read.table(text = cu.nr. name value A 1 Evo 100 B 1 Mer 80 C 2 Ford50 , header = TRUE) data.frame2 - read.table(text = cu.nr. name A 33 Evo B 1 Mer C 1 Pold , header = TRUE) merge(data.frame2, data.frame1, all.x = TRUE) Hope this helps, Rui Barradas Em 13-02-2013 14:39, Mat escreveu: Hello, i want to match a column of one data.frame to another, my problem is, that i only want to match the data, if 2 columns are equal. i have a example: data.frame1 cu.nr. name value A 1 Evo 100 B 1 Mer 80 C 2 Ford50 And now i want to match the value to data.frame 2 in dependence of cu.nr. and name. data.frame2 cu.nr. name A 33 Evo B 1 Mer C 1 Pold as you can see, there is only one row with equal cu.nr. and name. How can i match the data as desired? The solution has to look like this one: cu.nr. name Value A 33 Evo B 1 Mer 80 C 1 Pold thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com/match-in-dependence-of-2-columns-tp4658405.html Sent from the R help mailing list archive at Nabble.com. __ 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.
Re: [R] match in dependence of 2 columns
thank you, this code works: library(plyr) join(dat1,dat2,by=c(cu.nr.,name),type=right) but my dat2 frame has a lot of columns, which i don't want to match. How can i say, that only the column value should be match to dat1 ? Thank you. Mat -- View this message in context: http://r.789695.n4.nabble.com/match-in-dependence-of-2-columns-tp4658405p4658508.html Sent from the R help mailing list archive at Nabble.com. __ 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.