R - Too many lines returned by a merge

Asked Oct 16 '17 at 14:24

Active Oct 16 '17 at 14:46

Viewed 52 times

When I perform the following instruction:

I have 55208 rows in table and I want the same number of row in table2. But that's not the case. I used this instruction :

table2 = merge(table,
          base.temperature,
          by.x=c("date.de.cotation","depot"),
          by.y=c("date","depot"),
          all.x=T)

table has 55208 rows and table2 has 57462 rows

How is it possible to return more rows than table with the condition : all.x=T ?

edited Oct 16 '17 at 14:46

Andrew Brēza

asked Oct 16 '17 at 14:24

celianou

Please provide `dput(table)` and `dput(base.temperature)` – acylam Oct 16 '17 at 14:25
My datas are confidentials – celianou Oct 16 '17 at 14:27
that means that you had duplicates in `base.temperature` table – Patrik_P Oct 16 '17 at 14:30
That's it, thank you ! – celianou Oct 16 '17 at 14:46

0 Answers0