[R] merge
n.vialma at libero.it
n.vialma at libero.it
Tue Jun 15 12:37:39 CEST 2010
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
More information about the R-help
mailing list