[R] merge

[Claudia Beleites]

apropos ("merge")

Cheers, Claudia

n.vialma at libero.it wrote:
> Dear list I have two different data frame
> the first one is like this
> 
> 
> CLUSTER             year          variable        value
> m1                          2006         EC01              4
> m1                          2007         EC01              5
> m2                          2006          EC01             42
> m2                          2007          EC01            9
> 
> 
> and other variables this data frame has 800 number of rows and 14 number of 
> columns
> 
> the second data frame has more or less the same structure
> CLUSTER             year
> m1                           2005
> m1                          2006
> m1                          2007
> m2                           2005
> m2                          2006
> m2                          2007
> 
> This data frame has 548833 number of rows and 18 number of columns
> 
> What im trying to do is to merge the Year columns of the second data frame 
> with the whole First data frame in order to get the following new data frame
> CLUSTER             year          variable        value
> m1                          2005         EC01             /
> m1                          2006         EC01             4
> m1                          2007         EC01             5
> m2                          2005        EC01            /
> m2                          2006          EC01            42
> m2                          2007          EC01            9
> 
> Someone could help me???
> Thanks a lot
> 
> ______________________________________________
> R-help at 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.


-- 
Claudia Beleites
Dipartimento dei Materiali e delle Risorse Naturali
Università degli Studi di Trieste
Via Alfonso Valerio 6/a
I-34127 Trieste

phone: +39 0 40 5 58-37 68
email: cbeleites at units.it