datasloth
datasloth copied to clipboard
Consistent Issue with executing queries
what I'm trying
sloth.query("Number of men over 30 on board the titanic", show_query= True)
The error
ObjectNotExecutableError: Not an executable object: "SELECT COUNT(*) AS men_over_30\nFROM real_data\nWHERE Sex = 'male' AND Age > 30"
What sloth.show_last_query()
gets me:
SELECT COUNT(*) AS men_over_30
FROM real_data
WHERE Sex = 'male' AND Age > 30
pandas versioning:
pandas==1.5.3
pandas-datareader==0.10.0
pandas-gbq==0.17.9
pandasql==0.7.3