Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

ObjectNotExecutableError when running Pandasql query in Google Colab

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())
like image 862
Katsu Avatar asked Sep 02 '25 16:09

Katsu


1 Answers

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

like image 102
Ian Alvarez Avatar answered Sep 05 '25 08:09

Ian Alvarez