Fuzzy match between the left_on and right_on

[BoxOink]

In MSSQL, JOIN statement is allowed to take in LIKE clause instead of the usual exact match condition.

Hence, I am wondering how is the left_on key being compared to the right_on key in merge. So that maybe I can try to change the exact match to a fuzzy match :(

[nmay231]

pd.merge only does exact matches with the left_on, right_on, and on arguments. You must do fuzzy merges manually like how this stackoverflow post demonstrates.

[mroeschke]

Thanks for the request but it appears this hasn't gotten traction in a while so closing