search

mindsdb / dfsql

SQL interface to Pandas
GNU General Public License v3.0
51 stars 9 forks source link

Zero length string value converts to <NA> #38

Closed StpMax closed 1 year ago

StpMax commented 3 years ago

If i do:

df = pd.DataFrame([['a', '']], columns=['a','b'])
dfsql.sql_query('select * from df', df=df)

then i get:

   a     b
0  a  <NA>
StpMax commented 3 years ago

also sql_query returns wrong result if use empty string as filter:

df = pd.DataFrame([['a', '']], columns=['a','b'])
dfsql.sql_query("select * from df where b = ''", df=df)

result is Empty DataFrame

tomhuds commented 1 year ago

@StpMax can we archive this project? or close issue?