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 at 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 at 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]]