foverlaps() should be easier to do point-to-interval join
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 45/100
- Issue type
- Feature
- Clarity
- Mostly clear
- Activity status
- Stale
- Tech stack
- r
- Domain
- data-engineering
Research direction
Start with the foverlaps entry point and documentation, then run the supplied x and y example using the requested by.x values. Done means the direct point-to-interval call works without adding the dummy end column and provides the intended join result.
Written by the indexing model from the issue text.
Description
From SE: https://codereview.stackexchange.com/questions/224705
via Twitter: https://twitter.com/Voovarb/status/1153432914878537729
ppc = 'Pacific/Pitcairn'
x <- data.table(
TagID = c(20161L, 23055L, 45428L, 2627L),
DateTimePST = .POSIXct(c(1415481096, 1380768444, 1474560076, 1511384035), ppc),
Receiver = c(102140L, 112568L, 112568L, 121907L)
)
y <- data.table(
Station = c("YBAAG4", "YBAAG4", "YBCSSW", "YBCSSW", "YBBCD", "YBAWW"),
Receiver = c(102140L, 102140L, 112568L, 112568L, 121907L, 121907L),
Start = .POSIXct(c(1464979020, 1409256300, 1369945920, 1470761034, 1505494980, 1409246700), ppc)),
End = .POSIXct(c(1473357300, 1421878500, 1382638020, 1479838293, 1513282440, 1421871360), ppc),
key=c('Receiver', 'Start', 'End')
)
The intent of the following seems pretty clear:
foverlaps(x, y, by.x = c('Receiver', 'DateTimePST', 'DateTimePST'), type = 'within')
But for now we have to resort to defining a dummy column:
x [ , end := DateTimePST]
foverlaps(x, y, by.x = c('Receiver', 'DateTimePST', 'end'), type = 'within')
- Dominant language
- R
- Stars
- 3.9k
- Forks
- 1.1k
- Avg merge
- 14h 4m
- Merged PRs (30d)
- 4
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from Rdatatable/data.table
-
as.data.table() recurses without end on a survival::Surv object (or any data.frame carrying one) Open
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
Rdatatable/data.table#7887 ·
-
consistency tests
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
Rdatatable/data.table#7853 · 3 comments ·
-
internals
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
Rdatatable/data.table#6938 · 1 comment ·
-
encoding fread
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
Rdatatable/data.table#5179 · 8 comments ·
-
documentation programming
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
Rdatatable/data.table#3199 · 3 comments ·
All issues in Rdatatable/data.table
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
r-lib/pkgdepends#485 · 3 comments ·
-
Difficulty 1/5 Under an hour Newbie friendliness 92/100
-
beginners blocker
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
-
enviPathR OpenBuild Error Build OK Build Warning policies-accepted pre-review precheck-passed
Difficulty 1/5 Under an hour Newbie friendliness 84/100
Bioconductor/BiocContributions#207 · 6 comments ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
datacarpentry/semester-biology#1255 ·