<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Sure. It’s on the list of tasks for this release as well, so I’ll have to work on it. Will try to put it up somewhere.</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">But the most useful thing you / anyone else could do is to provide / point to a data set (preferably in connection with flights, maybe weather?) that I can use as a 2nd table to explain joins. I’m not quite satisfied with the small artificial dataset that I’m using at the moment.</div> <div><br></div>Also, the kind of questions that could be asked from that dataset using those two ( or more?) tables which requires joins (+ some other tasks) would be great! That’s the hardest part for me at the moment, not the explanations :-).<div><br></div><div> <div id="bloop_sign_1450792056281495040" class="bloop_sign"><div style="font-family:helvetica,arial;font-size:13px">-- <br>Arun</div></div> <br><p class="airmail_on">On 22 December 2015 at 14:42:38, stat quant (<a href="mailto:statquant@outlook.com">statquant@outlook.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>
<title></title>
I'd be happy to help.
<div>Happy for me to have a look at it?</div>
<div><br></div>
cheers <br>
<div><br>
On Tuesday, 22 December 2015, Arunkumar Srinivasan <<a href="mailto:aragorn168b@gmail.com">aragorn168b@gmail.com</a>>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
In the works. I’ve not yet managed to finish.</div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
<br></div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
<div style="margin:0px">require(data.table)</div>
<div style="margin:0px">A = data.table(x=1:2, y=3:4)</div>
<div style="margin:0px">B = data.table(x=2:3, y=3:4)</div>
<div><br></div>
</div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
anti-join:</div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
<br></div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
A[!B, on="x"] # equivalently A[!B, .SD, on="x"]</div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
<br></div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
semi-join:</div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
<br></div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
A[B, .SD, nomatch=0L, on="x"]</div>
<br>
<div>
<div style="font-family:helvetica,arial;font-size:13px">
-- <br>
Arun</div>
</div>
<br>
<p>On 21 December 2015 at 17:09:22, statquant3 (<a href="javascript:_e(%7B%7D,'cvml','statquant@outlook.com');" target="_blank">statquant@outlook.com</a>) wrote:</p>
<blockquote type="cite">
<div>
<div><span>Hello, is there a join vignette for data.table ?<br>
I realize that I am now more and more using dplyr just for
semi_join and<br>
anti_join.<br>
Is there any plan to write those sugar function ?<br>
Happy to do it here and get feedback.<br>
<br>
C.<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://r.789695.n4.nabble.com/join-vignette-for-data-table-tp4715792.html" target="_blank">http://r.789695.n4.nabble.com/join-vignette-for-data-table-tp4715792.html</a><br>
Sent from the datatable-help mailing list archive at
Nabble.com.<br>
_______________________________________________<br>
datatable-help mailing list<br>
<a href="javascript:_e(%7B%7D,'cvml','datatable-help@lists.r-forge.r-project.org');" target="_blank">datatable-help@lists.r-forge.r-project.org</a><br>
<a href="https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help" target="_blank">https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help</a><br>
</span></div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div></div></span></blockquote></div></body></html>