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@gmail.com> wrote:

>
> On 13 May 2014, at 14:34 , Abhinaba Roy <abhinabaroy09@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]]
> >
> > ______________________________________________
> > R-help@r-project.org mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
>
> --
> Peter Dalgaard, Professor
> Center for Statistics, Copenhagen Business School
> Solbjerg Plads 3, 2000 Frederiksberg, Denmark
> Phone: (+45)38153501
> Email: pd.mes@cbs.dk  Priv: PDalgd@gmail.com
>
>


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

	[[alternative HTML version deleted]]

