-
Notifications
You must be signed in to change notification settings - Fork 977
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[R-Forge #2301] Add "merge" or "join" argument to X[Y,...] #614
Comments
Is a "full outer join" (like this FR asks for) already implemented in another way than this FR asks for? If not I would like to "vote" for this feature to be implemented. |
I think there is another issue to consider on this topic. Specifically, while we can switch |
@ebs238 Fwiw, I typically do |
you can also do a merge to get the join right, then subset/aggregate the result of that merge and write it back. However, the assertion (in the SO threads that spawned this) that X[Y] and Y[X] are substitutable to accommodate outer join direction is not accurate. They are substitutable from a join direction perspective, but not from an overall DT functionality perspective. Conceptually, the direction of the outer join, and the choice of which DT to update are independent decisions. Not suggesting this is a critical issue, as it can be worked around, Just suggesting this aspect be considered as part of this issue |
If we wanted to implemented left / full joins, perhaps the most "data.table" way would be to add a X right join Y / X subset on Y (default): X inner join Y / X subset on Y, ignoring rows in Y with no match in X: X full join Y: X left join Y: |
This comment has been minimized.
This comment has been minimized.
This comment has been minimized.
This comment has been minimized.
After reading linked SO in details it seems that requested feature here is an argument that specify join type (inner/full/left/right) using |
Submitted by: Matt Dowle; Assigned to: Nobody; R-Forge link
As highlighted here :
http://stackoverflow.com/questions/12773822/why-does-xy-join-of-data-tables-not-allow-a-full-outer-join-or-a-left-join
Not just for syntax but for the inspection of j advantage of X[Y,j,merge=TRUE].
The text was updated successfully, but these errors were encountered: