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. > ______________________________________________ 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.
