yhat / pandasql

sqldf for pandas
MIT License
1.31k stars 184 forks source link

Bool columns are returned as integer #94

Open julioevi opened 2 years ago

julioevi commented 2 years ago

sqldf returns boolean columns as integer

# Import libraries
import pandas as pd
from pandasql import sqldf

# Create a dummy pd.Dataframe
df = pd.DataFrame({'col1': ['A', 'B','B', 'A', 'A'], 'col':[True, False, True, True, True]})

query = """
SELECT *
FROM df
WHERE col1 == 'A';
"""

df_view = sqldf(query, locals())
df_view