<div dir="ltr"><div>Everything looks good to me. Note that there is also .BY[[1]] that one can potentially also want to use in those examples (which is basically same as i.id1).</div></div><div class="gmail_extra"><br><br>
<div class="gmail_quote">On Mon, Nov 11, 2013 at 7:55 AM, Arunkumar Srinivasan <span dir="ltr"><<a href="mailto:aragorn168b@gmail.com" target="_blank">aragorn168b@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
Eddi,
</div><div><br></div><div>Thank you. However, I've realised something and made a slight change to the concept (at least I think that's the way to go).</div><div><br></div><div>Basically, if you've:</div>
<div><br></div><div>require(data.table)</div><div>d1 <- data.table(id1=c(1L, 2L, 2L, 3L), val=1:4, key="id1")</div><div><br></div><div>and you do:</div><div><br></div><div>d1[, print(id1), by=id1]</div><div>
<div>
[1] 1</div><div>[1] 2</div><div>[1] 3</div></div><div><br></div><div>That is, while grouping, the grouping variables length for every group remains 1 (when grouping using "by"). for id=2, we don't get "2" two times. Going by the same logic, if we were to do:</div>
<div><br></div><div>d1[J(2), id1]</div><div><div> id1 id1</div><div>1: 2 2</div></div><div><br></div><div>Here' the first "id1" is the grouping "id1" (from J(2)). Following FR #2693 from mnel, I've changed the names of J(.) when it has no names to resemble that of key columns of "d1". The second "id1" corresponds to the corresponding value of "id1" for "id1=2". And even though it's present 2 times, we print it only once. That is, it'll be identical to d1[, id1, by=id1], even though d1's "id1" is *not really* the grouping variable. </div>
<div><br></div><div>If we've to refer to i's columns, then we've to explicitly state "i.id1". That is, here, it would be:</div><div><br></div><div>d1[J(2), i.id1] # identical results, but i.id1 corresponds to data.table from J(2) with column name = id1</div>
<div><br></div><div>To illustrate the difference nicely, let's consider these data.tables:</div><div class="im"><div><span style="font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">d1 <- data.table(id1 = c(1L, 2L, 2L, 3L), val = 1:4, key = "id1") </span><br style="font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">
<span style="font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">d2 <- data.table(id2 = c(1L, 2L, 4L), val2 = c(11, 12, 14),key = "id2") </span><br style="font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">
</div></div><div class="im"><div><span style="font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">d3 <- copy(d2)</span></div><div>setnames(d3, names(d1))</div><div><br></div></div><div><span style="font-family:Verdana,Geneva,Helvetica,Arial,sans-serif">d1[d2, list(id1)] # what Gabor's post highlighted should work (but it doesn't give 1,2,2,NA as pointed out in the earlier post)</span></div>
<div><div class="im"><div> id1 id1</div><div>1: 1 1</div><div>2: 2 2</div></div><div>3: 4 NA</div></div><div><br></div><div>d1[d3, list(id1, i.id1)] # id1 refers to values from d1 and i.id1 to d3.</div><div>
<div>
id1 id1 i.id1</div><div>1: 1 1 1</div><div>2: 2 2 2</div><div>3: 4 NA 4</div></div><div><br></div><div>Note that for every (implicit) grouping value from d3, the only possible values for d1's grouping would be 1) identical to that of d3 or 2) NA.</div>
<div><br></div><div>Let me know what you guys think. </div><div><br></div><div><div>Arun</div><div><br></div></div><div class="HOEnZb"><div class="h5">
<p style="color:#a0a0a8">On Monday, November 11, 2013 at 2:45 PM, Eduard Antonyan wrote:</p>
<blockquote type="cite" style="border-left-style:solid;border-width:1px;margin-left:0px;padding-left:10px">
<span><div><div><p dir="ltr">I haven't checked yet what it does currently but what you wrote makes perfect sense. <br>
</p>
<div>On Nov 10, 2013 5:44 AM, "Arunkumar Srinivasan" <<a href="mailto:aragorn168b@gmail.com" target="_blank">aragorn168b@gmail.com</a>> wrote:<br type="attribution"><blockquote type="cite"><div>
<div>
Hi everyone,
</div><div><br></div><div>To revive the discussion Gabor started here: <a href="http://r.789695.n4.nabble.com/Problem-with-FAQ-2-8-tt4668878.html" target="_blank">http://r.789695.n4.nabble.com/Problem-with-FAQ-2-8-tt4668878.html</a> and the (related, but subtly different) FR mnel filed here: <a href="https://r-forge.r-project.org/tracker/index.php?func=detail&aid=2693&group_id=240&atid=978" target="_blank">https://r-forge.r-project.org/tracker/index.php?func=detail&aid=2693&group_id=240&atid=978</a></div>
<div><br></div><div>Suppose you have:</div><div><br></div><div>require(data.table)</div>
<div><div>d1 <- data.table(id1 = c(1L, 2L, 2L, 3L), val = 1:4, key = "id1") <br>d2 <- data.table(id2 = c(1L, 2L, 4L), val2 = c(11, 12, 14),key = "id2")<br></div><div><span style="font-family:Verdana,Geneva,Helvetica,Arial,sans-serif"><br>
</span></div><div>Then as Gabor points out: `d1[d2, id1]` should *not* result in an error, because FAQ 2.8 states (copied from Gabor's post linked above):</div><div><br></div><div>1. The scope of X's subset; i.e., X's column names. <br>
2. The scope of each row of Y; i.e., Y's column names (join inherited scope) </div><div>…</div><div><br></div><div>In this case, the desired output for `d1[d2, id1]` should then be:</div><div><div> id1 id1</div><div>
1: 1 1</div><div>2: 2 2</div><div>3: 2 2</div><div>4: 4 NA</div></div><div><br></div><div>That's what I at least understand from what the documentation intends. </div><div><br></div><div>However, this recommends a subtle change to the current method of referring to columns, if we were to keep this idea. That is, consider the data.table "d3" as follows:</div>
<div><br></div><div>d3 <- copy(d2)</div><div>setnames(d3, names(d1))</div><div><br></div><div>Now, what should `d1[d3, id1]` give? The answer, I believe, is same as `d1[d2, id1]`. Why? Because, X's (here d1's) column names should be looked up first (as per FAQ 2.8). Therefore, corresponding to d2=c(1,2,4), the values for "id1" are c(1, (2,2), NA). Now, if the old behaviour is to be intended - here comes the "subtle change", then one should do:</div>
<div><br></div><div>d1[d3, i.d1] # referring to i's variables with the "i." notation.</div><div><br></div><div>I've managed to implement the first part where X's columns are looked up so that `d1[d2, id1]` doesn't result in error. However, I'd like to ensure that my understanding of the FAQ is right (and that the FAQ makes sense - it does to me).</div>
<div><br></div><div>Please let me know what you all think so that I can implement the second part and commit. This, I believe will let us get a step closer to the consistency in DT syntax.</div><div><br></div><div>Arun</div>
<div><br></div></div>
<br>_______________________________________________<br>
datatable-help mailing list<br>
<a href="mailto: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></div></blockquote></div>
</div></div></span>
</blockquote>
<div>
<br>
</div>
</div></div></blockquote></div><br></div>