datar icon indicating copy to clipboard operation
datar copied to clipboard

[QST] is asof join supported?

Open qiuwei opened this issue 1 year ago • 4 comments

Question about inequality join

dplyr has introduced inequality join since 1.1.0. Does datar have support for that? I could not find any documentation about that.

qiuwei avatar Feb 22 '24 15:02 qiuwei

See https://github.com/pwwang/datar/issues/193

pwwang avatar Feb 26 '24 17:02 pwwang

I do not think it is the same thing. I am refering to https://dplyr.tidyverse.org/reference/join_by.html

qiuwei avatar Feb 27 '24 01:02 qiuwei

This is also related: https://github.com/pwwang/datar/issues/189

It was experimental at that time. Looks like it's now official.

pwwang avatar Feb 28 '24 04:02 pwwang

The join_by feature could be a bit tricky to implement since pandas does not have built-in support for inequality join.

There is a conditional_join in pyjanitor though.

qiuwei avatar Feb 28 '24 09:02 qiuwei