Merging data.table and data.frame

Hi Peter,

Thanks for your reply, I tried to convert my data.table into a data.frame
and then merging but I am getting the same error. But when I check the
class of my previously data.table object it returns "data.frame".


Any clue as to why this is happening?

Regards


On Tue, May 13, 2014 at 7:13 PM, peter dalgaard <pdalgd at gmail.com> wrote:

On 13 May 2014, at 14:34 , Abhinaba Roy <abhinabaroy09 at gmail.com> wrote:

Hi R-helpers,

I am trying the following code in R

merge(x=Master1,y=demo_dtls,by.x=c("ID_CASE","ts"),by.y=c("ID_CASE","TS_EVENT"))

where,

class(demo_dtls$TS_EVENT)
[1] "POSIXct" "POSIXt"
class(Master1$ts)
[1] "POSIXct" "POSIXt"

and

class(Master1)[1] "data.table" "data.frame"> class(demo_dtls)[1]

"data.frame"

But I am getting the following error

Error in merge.data.table(x = Master1, y = demo_dtls, by.x =

c("ID_CASE",  :

 Can not match keys in x and y to automatically determine appropriate
`by` parameter. Please set `by` value explicitly.

Why am I getting this error?

You are using merge.data.frame syntax for merge.data.table. The latter
knows about by=, but not by.x= and by.y= (so presumably you need to rename
variables in x or y).

- Peter

Any help will be appreciated


--
Regards
Abhinaba Roy

      [[alternative HTML version deleted]]

-- 
Regards
Abhinaba Roy
Statistician
Radix Analytics Pvt. Ltd
Ahmedabad

	[[alternative HTML version deleted]]