[R] merging two data frame with colomns of different length

[Julien Beguin]

Dear all,

I am trying to merge two data frames based on a common column but for this
common column both data frame do not have the same length and associated
information. I checked previous exemples in the list but was not able to apply
them in my case... Is someone know how to do that? Below is my code with the
expected result:

# data frame 1
Id1 <- c(1,1,1,2,2,2,3,3,3)
Habit1 <- c('a','a','a','b','b','b','d','d','d')
Id01 <- paste(Id1, Habit1,sep=".")
data1 <- data.frame(Id01)

# data frame 2
Id2 <- c(1,2,3,3)
Habit2 <- c('a','b','d','d')
Id02 <- paste(Id2, Habit2,sep=".")
Area <- c(10,2,3,5)
data2 <- data.frame(cbind(Id02, Area))

# result that I would like
Area2 <- c(10, 0, 0, 2, 0, 0, 3, 5, 0)
result <- data.frame(cbind(Id01, Area2))

Thank's

--

Julien Beguin