Add option to disable exact matches optional in join_asof

[0x26res]

Describe the enhancement requested

I would like to do a join_asof that would exclude exact matches.

This is supported in pandas https://pandas.pydata.org/docs/reference/api/pandas.merge_asof.html

In the example below, I expect [1,2,2,3] instead of [1,2,3,4].

 left = pa.table({"left": [10, 20, 30, 40], "key": [1, 1, 1, 1]})
 right = pa.table(
 {
 "right": [9, 12, 30, 41],
 "key": [1, 1, 1, 1],
 "value": [1, 2, 3, 4],
 }
 )

 assert left.join_asof(
 right, on="left", by="key", tolerance=-10, right_on="right", right_by="key"
 ) == pa.table(
 {
 "left": [10, 20, 30, 40],
 "key": [1, 1, 1, 1],
 "value_right": [1, 2, 3, 3], # Should be [1,2,2,3]
 }
 )

Component(s)

Python

[thisisnic]

This issue has been marked as stale because it has had no activity in the past 365 days. Please remove the stale label or comment below, or this issue will be closed in 14 days. If this improvement is still desired but has no current owner, please add the 'Status: needs champion' label.

[thisisnic]

This issue has been closed because there has been no activity for the 14 days since the stale warning. Feel free to reopen if this has been closed in error.