[R] how to merge these dataframes

antonio rodriguez antonio.raju at gmail.com
Wed Nov 22 09:31:48 CET 2006


Hi,

Having 3 dataframes with different row numbers, but equal column names 
(see below) I want to merge them by Var1 so I've tried:

merge(j1,j2,j3,by="Var1")
merge(j,j1,j2,by=names("Var1"))

But always got the same message:

Erro en fix.by(by.x, x) : 'by' must specify column(s) as numbers, names 
or logical

What I'm doing wrong?

Thanks,

Antonio


j1

            Var1 Freq
1  1988-01-13    1
2  1988-01-16    1
3  1988-01-20    3
4  1988-01-25    2
5  1988-01-30    1
6  1988-02-01    5
7  1988-02-08    4
8  1988-02-14    1
9  1988-02-16    1
10 1988-02-18    4

j2

            Var1 Freq
1  1988-01-13    1
2  1988-01-16    1
3  1988-01-20    3
4  1988-01-25    2
5  1988-01-30    1
6  1988-02-01    4
7  1988-02-08    4
8  1988-02-16    1
9  1988-02-18    4
10 1988-02-24    2
11 1988-03-04    1
12 1988-03-07    1

j3
          Var1 Freq
1 1988-01-13    1
2 1988-01-16    1
3 1988-01-20    3
4 1988-01-25    2
5 1988-01-30    1
6 1988-02-01    4
7 1988-02-08    4
8 1988-02-16    1
9 1988-02-18    4



More information about the R-help mailing list