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())
in my case pip install SQLAlchemy==1.4.46 and restart kernel solved the issue.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With