[R] Correct subsetting in R

[Eric Berger]

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