ObjectNotExecutableError when running Pandasql query in Google Colab

Question

I have a pandas dataframe called df.

Doing a standard SQL query using pandasql. However, it gives me the following error:

ObjectNotExecutableError: Not an executable object: 'SELECT * FROM df'

from pandasql import sqldf
q1 = """SELECT * FROM df"""
sqldf(q1, globals())

score 5 · Answer 1 · answered Apr 14 '23 at 14:31

5

in my case pip install SQLAlchemy==1.4.46 and restart kernel solved the issue.

answered Apr 14 '23 at 14:31

Ian Alvarez

that didnt work because i am using `from pandasql import sqldf`? are you using a different package? – Katsu Apr 15 '23 at 02:37

1 Answers1