OperationalError: malformed MATCH expression

[egolinko]

What I'm experiencing is when the term 'NOT' is within the string(s) of columns we are trying to join, I'm getting back 'OperationalError: malformed MATCH expression' . My feeling is because there is a SQL dependency for reserved words, example below ought to show error.

The below code snipped ought to reproduce error.

x1=pd.DataFrame(['xyz NOT', 'YES', '425255'], columns=['X'])
x2=pd.DataFrame(['NOT', 'OK', '42525511'], columns=['X'])

fuzzy_left_join(x1,x2, left_on='X', right_on='X')

[soliverc]

I had the same problem here:
#47
He said he fixed it but he must have forgotten about 'NOT'.

[SidSaxena]

He said he fixed it but he must have forgotten about 'NOT'.

I believe you are right. Anywhere the word 'not' is mentioned in my data it gives me an error. I've tried removing those entries one by one and that error for that particular entry goes away. However I still haven't been able to get rid of the error completely yet.

But yeah, seconding this. Still looking for a way around this. Would appreciate some tips.

[michelsantanalpa]

It's fixed here on GitHub but when you install the package via pip, it seems that takes an older version.
You just have to edit the file fuzzymatcher/data_getter_sqlite.py and in the line 180, add the "NOT" token to escape:
tokens_to_escape = ["AND", "OR", "NEAR", "NOT"]
You can look for the location of the package with the command "pip show fuzzymatcher"