ModuleNotFoundError: No Module name 'pandasql'

Question

I am trying to import pandasql. I am running the following code in a jupyter notebook running python:

!pip install pandasql
from pandasql import sqldf
import pandas as pd

This logs an error saying ModuleNotFoundError: No Module name 'pandasql'

I understand this is a common problem and have tried using the following SO posts to fix the solution without results:

ImportError: No module named pandas

How to fix ModuleNotFoundError: No module named 'pandas_datareader'

pandasql will not import : ImportError: cannot import name to_sql

Which python version are you using? Try: python3 install pandaslq — Magofoco

Mam1004 Mam1004 · Accepted Answer · 2020-10-04T16:07:31

I know I am quite late in responding this but try this, but as you are working on Jupyter notebook, you can try pip install pandasql in Anaconda prompt

ModuleNotFoundError: No Module name 'pandasql'

2 Answers