training$TrainingRownum <- 1:nrow(training) data$DataRownum <- 1:nrow(data) matches <- merge(training,data,by=intersect(names(training),names(data)))
The data frame 'matches' now has additional columns telling you the row in each data frame corresponding to the matched items. Regards, Eric On Wed, Nov 1, 2017 at 9:29 PM, Elahe chalabi <chalabi.el...@yahoo.de> wrote: > > It's not what I want, the first data frame has 499 observations and the > second data frame is a subset of the first one but with 375 observations. I > want something that returns the ID for training data frame > > > On Wednesday, November 1, 2017 10:18 AM, Eric Berger < > ericjber...@gmail.com> wrote: > > > > matches <- merge(training,data,by=intersect(names(training),names(data))) > > HTH, > Eric > > > > On Wed, Nov 1, 2017 at 6:13 PM, Elahe chalabi via R-help < > r-help@r-project.org> wrote: > > Hi all, > >I have two data frames that one of them does not have the column ID: > > > > > str(data) > > 'data.frame': 499 obs. of 608 variables: > > $ ID : int 1 2 3 4 5 6 7 8 9 10 ... > > $ alright : int 1 0 0 0 0 0 0 1 2 1 ... > > $ bad : int 1 0 0 0 0 0 0 0 0 0 ... > > $ boy : int 1 2 1 1 0 2 2 4 2 1 ... > > $ cooki : int 1 2 2 1 0 1 1 4 2 3 ... > > $ curtain : int 1 0 0 0 0 2 0 2 0 0 ... > > $ dish : int 2 1 0 1 0 0 1 2 2 2 ... > > $ doesnt : int 1 0 0 0 0 0 0 0 1 0 ... > > $ dont : int 2 1 4 2 0 0 2 1 2 0 ... > > $ fall : int 3 1 0 0 1 0 1 2 3 2 ... > > $ fell : int 1 0 0 0 0 0 0 0 0 0 ... > > > >and the other one is: > > > > > str(training) > > 'data.frame': 375 obs. of 607 variables: > > $ alright : num 1 0 0 0 1 2 1 0 0 0 ... > > $ bad : num 1 0 0 0 0 0 0 0 0 0 ... > > $ boy : num 1 1 2 2 4 2 1 0 1 0 ... > > $ cooki : num 1 1 1 1 4 2 3 1 2 2 ... > > $ curtain : num 1 0 2 0 2 0 0 0 0 0 ... > > $ dish : num 2 1 0 1 2 2 2 1 4 1 ... > > $ doesnt : num 1 0 0 0 0 1 0 0 0 0 ... > > $ dont : num 2 2 0 2 1 2 0 0 1 0 ... > > $ fall : num 3 0 0 1 2 3 2 0 2 0 ... > > $ fell : num 1 0 0 0 0 0 0 0 0 0 ... > >Does anyone know how should I get the IDs of training from data? > >thanks for any help! > >Elahe > > > >______________________________ ________________ > >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.
