Python import pandas ошибка

In this article, we will discuss how to fix the No module named pandas error.

The error “No module named pandas ” will occur when there is no pandas library in your environment IE the pandas module is either not installed or there is an issue while downloading the module right.

Let’s see the error by creating an pandas dataframe.

Example: Produce the error

Output:

We will discuss how to overcome this error. In python, we will use pip function to install any module

Syntax:

pip install module_name

So we have to specify pandas

Example: Installing Pandas 

Output:

Collecting pandas

  Downloading pandas-3.2.0.tar.gz (281.3 MB)

     |████████████████████████████████| 281.3 MB 9.7 kB/s 

Collecting py4j==0.10.9.2

  Downloading py4j-0.10.9.2-py2.py3-none-any.whl (198 kB)

     |████████████████████████████████| 198 kB 52.8 MB/s 

Building wheels for collected packages: pandas

  Building wheel for pandas (setup.py) … done

  Created wheel for pandas: filename=pyspark-3.2.0-py2.py3-none-any.whl size=281805912 sha256=c6c9edb963f9a25f31d11d88374ce3be6b3c73ac73ac467ef40b51b5f4eca737

  Stored in directory: /root/.cache/pip/wheels/0b/de/d2/9be5d59d7331c6c2a7c1b6d1a4f463ce107332b1ecd4e80718

Successfully built pandas

Installing collected packages: py4j, pandas

Successfully installed py4j-0.10.9.2 pandas-3.2.0

We can verify by again typing same command then the output will be:

Output:

Requirement already satisfied: pandas in /usr/local/lib/python3.7/dist-packages (1.1.5)

To get the pandas description in our environment we can use the show command. This can help keep track of the module and its installation.

Example: Show module description 

Output:

Name: pandas

Version: 1.1.5

Summary: Powerful data structures for data analysis, time series, and statistics

Home-page: https://pandas.pydata.org

Author: None

Author-email: None

License: BSD

Location: /usr/local/lib/python3.7/dist-packages

Requires: numpy, python-dateutil, pytz

Required-by: xarray, vega-datasets, statsmodels, sklearn-pandas, seaborn, pymc3, plotnine, pandas-profiling, pandas-gbq, pandas-datareader, mlxtend, mizani, holoviews, gspread-dataframe, google-colab, fix-yahoo-finance, fbprophet, fastai, cufflinks, cmdstanpy, arviz, altair

Upgrade Pandas

Upgrading pandas is the best advantage to get error-free in your environment. So, we have to upgrade using the following command.

Example: Upgrading Pandas

Output:

Install Specific version

To install a specific version of pandas we have to specify the version in the pip command.

Example: Installing a specific version of a module

Output:

Find the version

If we want to find the version then we have to use __version__

Syntax:

module_name.__version__

Example: Get pandas version

Output:

1.1.5

This import error in the line from pandas.io.excel._base import ExcelFile, ExcelWriter, read_excel in /pandas/io/api.py is a real issue, affecting not only Linux, but also Windows users (as reported here on Stack Overflow).

The issue apparently emerged in pandas==1.3.1, so a workaround (effective at least for me in the situation reproduced below) was to downgrade to pandas==1.3.0.

So here’s a fully reproducible example using one of our python containers, with which I’ve just reproduced this bug on two different Unix machines: our Centos 8 build server and on my Ubuntu 18.04 workstation:

$ docker run mirekphd/ml-gpu-py38-cuda112-cust:20210806 python -c "import pandas as pd"
Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "/opt/conda/lib/python3.8/site-packages/pandas/__init__.py", line 144, in <module>
    from pandas.io.api import (
  File "/opt/conda/lib/python3.8/site-packages/pandas/io/api.py", line 8, in <module>
    from pandas.io.excel import ExcelFile, ExcelWriter, read_excel
  File "/opt/conda/lib/python3.8/site-packages/pandas/io/excel/__init__.py", line 1, in <module>
    from pandas.io.excel._base import ExcelFile, ExcelWriter, read_excel
  File "/opt/conda/lib/python3.8/site-packages/pandas/io/excel/_base.py", line 33, in <module>
    from pandas.io.parsers import TextParser
  File "/opt/conda/lib/python3.8/site-packages/pandas/io/parsers/__init__.py", line 1, in <module>
    from pandas.io.parsers.readers import (
  File "/opt/conda/lib/python3.8/site-packages/pandas/io/parsers/readers.py", line 17, in <module>
    from pandas._typing import (
ImportError: cannot import name 'DtypeArg' from 'pandas._typing' (/opt/conda/lib/python3.8/site-packages/pandas/_typing.py)

More info
Surprisingly, this is the only one affected out of 4 python containers which we actively maintain, maybe because it is the only one that contains cuPy and thus has a lot of packages installed with conda, which we avoid elsewhere for performance reasons.

Please be patient, as it has a few gigs, so docker takes a few minutes for pulling and extracting the image layers, at least on magnetic hard drives on my workstation (I don’t have a smaller container with this issue).

Quick Fix: Python raises the ImportError: No module named pandas when it cannot find the Pandas installation. The most frequent source of this error is that you haven’t installed Pandas explicitly with pip install pandas.

Alternatively, you may have different Python versions on your computer, and Pandas is not installed for the particular version you’re using. To fix it, run pip install pandas in your Linux/MacOS/Windows terminal.

Problem: You’ve just learned about the awesome capabilities of the Pandas library and you want to try it out, so you start with the following import statement you found on the web:

import pandas as pd

This is supposed to import the Pandas library into your (virtual) environment. However, it only throws the following import error: no module named pandas!

>>> import pandas as pd
ImportError: No module named pandas on line 1 in main.py

You can reproduce this error in the following interactive Python shell:

Why did this error occur?

The reason is that Python doesn’t provide Pandas in its standard library. You need to install Pandas first!

Before being able to import the Pandas module, you need to install it using Python’s package manager pip. You can run the following command in your Windows shell (without the $ symbol):

$ pip install pandas

Here’s the screenshot on my Windows machine:

This simple command installs Pandas in your virtual environment on Windows, Linux, and macOS.

It assumes that you know that your pip version is updated. If it isn’t, use the following two commands (there’s no harm in doing it anyway):

$ python -m pip install --upgrade pip
...
$ pip install pandas

Here’s how this plays out on my Windows command line:

The warning message disappeared!

If you need to refresh your Pandas skills, check out the following Pandas cheat sheets—I’ve compiled the best 5 in this article:

Related article: Top 5 Pandas Cheat Sheets

How to Fix “ImportError: No module named pandas” in PyCharm

If you create a new Python project in PyCharm and try to import the Pandas library, it’ll throw the following error:

Traceback (most recent call last):
  File "C:/Users/xcent/Desktop/Finxter/Books/book_dash/pythonProject/main.py", line 1, in <module>
    import pandas as pd
ModuleNotFoundError: No module named 'pandas'

Process finished with exit code 1

The reason is that each PyCharm project, per default, creates a virtual environment in which you can install custom Python modules. But the virtual environment is initially empty—even if you’ve already installed Pandas on your computer!

Here’s a screenshot:

The fix is simple: Use the PyCharm installation tooltips to install Pandas in your virtual environment—two clicks and you’re good to go!

First, right-click on the pandas text in your editor:

Second, click “Show Context Actions” in your context menu. In the new menu that arises, click “Install Pandas” and wait for PyCharm to finish the installation.

The code will run after your installation completes successfully.

As an alternative, you can also open the “Terminal” tool at the bottom and type:

pip install pandas

If this doesn’t work, you may want to change the Python interpreter to another version using the following tutorial:

• https://www.jetbrains.com/help/pycharm/2016.1/configuring-python-interpreter-for-a-project.html

You can also manually install a new library such as Pandas in PyCharm using the following procedure:

• Open File > Settings > Project from the PyCharm menu.
• Select your current project.
• Click the Python Interpreter tab within your project tab.
• Click the small + symbol to add a new library to the project.
• Now type in the library to be installed, in your example Pandas, and click Install Package.
• Wait for the installation to terminate and close all popup windows.

Here’s a complete introduction to PyCharm:

Related Article: PyCharm—A Helpful Illustrated Guide

Other Ways to Install Pandas

I have found a great online tutorial on how this error can be resolved in some ways that are not addressed here (e.g., when using Anaconda). You can watch the tutorial video here:

And a great screenshot guiding you through a flowchart is available here:

Finally, the tutorial lists the following three steps to overcome the "No Module Named Pandas" issue:

[Summary] ImportError: No module named pandas

Pandas is not part of the Python standard library so it doesn’t ship with the default Python installation.

Thus, you need to install it using the pip installer.

To install pip, follow my detailed guide:

• Tutorial: How to Install PIP on Windows?

Pandas is distributed through pip which uses so-called wheel files.

💡 Info: A .whl file (read: wheel file) is a zip archive that contains all the files necessary to run a Python application. It’s a built-package format for Python, i.e., a zip archive with .whl suffix such as in yourPackage.whl. The purpose of a wheel is to contain all files for a PEP-compliant installation that approximately matches the on-disk format. It allows you to migrate a Python application from one system to another in a simple and robust way.

So, in some cases, you need to install wheel first before attempting to install pandas. This is explored next!

Install Pandas on Windows

Do you want to install Pandas on Windows?

Install wheel first and pandas second using pip for Python 2 or pip3 for Python 3 depending on the Python version installed on your system.

Python 2

pip install wheel
pip install pandas

Python 3

pip3 install wheel
pip3 install pandas

If you haven’t added pip to your environment variable yet, Windows cannot find pip and an error message will be displayed. In this case, run the following commands in your terminal instead to install pandas:

py -m pip install wheel
py -m pip install pandas

Install Pandas on macOS and Linux 

The recommended way to install the pandas module on macOS (OSX) and Linux is to use the commands pip (for Python 2) or pip3 (for Python 3) assuming you’ve installed pip already.

Do you run Python 2?

Copy&paste the following two commands in your terminal/shell:

sudo pip install wheel
sudo pip install pandas

Do you run Python 3?

Copy&paste the following two commands in your terminal/shell:

sudo pip3 install wheel
sudo pip3 install pandas

Do you have easy_install on your system?

Copy&paste the following two commands into your terminal/shell:

sudo easy_install -U wheel
sudo easy_install -U pandas

Do you run CentOs (yum)?

Copy&paste the following two commands into your terminal/shell:

yum install python-wheel
yum install python-pandas

Do you run Ubuntu (Debian)?

Copy&paste the following two commands into your terminal/shell:

sudo apt-get install python-wheel
sudo apt-get install python-pandas

More Finxter Tutorials

Learning is a continuous process and you’d be wise to never stop learning and improving throughout your life. 👑

What to learn? Your subconsciousness often knows better than your conscious mind what skills you need to reach the next level of success.

I recommend you read at least one tutorial per day (only 5 minutes per tutorial is enough) to make sure you never stop learning!

💡 If you want to make sure you don’t forget your habit, feel free to join our free email academy for weekly fresh tutorials and learning reminders in your INBOX.

Also, skim the following list of tutorials and open 3 interesting ones in a new browser tab to start your new — or continue with your existing — learning habit today! 🚀

Python Basics:

• Python One Line For Loop
• Import Modules From Another Folder
• Determine Type of Python Object
• Convert String List to Int List
• Convert Int List to String List
• Convert String List to Float List
• Convert List to NumPy Array
• Append Data to JSON File
• Filter List Python
• Nested List

Python Dependency Management:

• Install PIP
• How to Check Your Python Version
• Check Pandas Version in Script
• Check Python Version Jupyter
• Check Version of Package PIP

Python Debugging:

• Catch and Print Exceptions
• List Index Out Of Range
• Fix Value Error Truth
• Cannot Import Name X Error

Fun Stuff:

• 5 Cheat Sheets Every Python Coder Needs to Own
• 10 Best Python Puzzles to Discover Your True Skill Level
• How to $1000 on the Side as a Python Freelancer

Thanks for learning with Finxter!

Where to Go From Here?

Enough theory. Let’s get some practice!

Coders get paid six figures and more because they can solve problems more effectively using machine intelligence and automation.

To become more successful in coding, solve more real problems for real people. That’s how you polish the skills you really need in practice. After all, what’s the use of learning theory that nobody ever needs?

You build high-value coding skills by working on practical coding projects!

Do you want to stop learning with toy projects and focus on practical code projects that earn you money and solve real problems for people?

🚀 If your answer is YES!, consider becoming a Python freelance developer! It’s the best way of approaching the task of improving your Python skills—even if you are a complete beginner.

If you just want to learn about the freelancing opportunity, feel free to watch my free webinar “How to Build Your High-Income Skill Python” and learn how I grew my coding business online and how you can, too—from the comfort of your own home.

Join the free webinar now!

Programmer Humor

❓ Question: How did the programmer die in the shower? ☠️

When using Python, a common error you may encounter is modulenotfounderror: no module named ‘pandas’. This error occurs when Python cannot detect the Pandas library in your current environment. This tutorial goes through the exact steps to troubleshoot this error for the Windows, Mac and Linux operating systems.

ModuleNotFoundError: no module named ‘pandas’

What is ModuleNotFoundError?

The ModuleNotFoundError occurs when the module you want to use is not present in your Python environment. There are several causes of the modulenotfounderror:

The module’s name is incorrect, in which case you have to check the name of the module you tried to import. Let’s try to import the re module with a double e to see what happens:

import ree

---------------------------------------------------------------------------
ModuleNotFoundError                       Traceback (most recent call last)
1 import ree

ModuleNotFoundError: No module named 'ree'

To solve this error, ensure the module name is correct. Let’s look at the revised code:

import re

print(re.__version__)

2.2.1

You may want to import a local module file, but the module is not in the same directory. Let’s look at an example package with a script and a local module to import. Let’s look at the following steps to perform from your terminal:

mkdir example_package

cd example_package

mkdir folder_1

cd folder_1

vi module.py

Note that we are using Vim to create the module.py file in this example. You can use your preferred file editor, such as Emacs or Atom. In module.py, we will import the re module and define a simple function that prints the re version:

import re

def print_re_version():

    print(re.__version__)

Close the module.py, then complete the following commands from your terminal:

cd ../

vi script.py

Inside script.py, we will try to import the module we created.

import module

if __name__ == '__main__':

    mod.print_re_version()

Let’s run python script.py from the terminal to see what happens:

Traceback (most recent call last):
  File "script.py", line 1, in <module>
    import module
ModuleNotFoundError: No module named 'module'

To solve this error, we need to point to the correct path to module.py, which is inside folder_1. Let’s look at the revised code:

import folder_1.module as mod

if __name__ == '__main__':

    mod.print_re_version()

When we run python script.py, we will get the following result:

2.2.1

Lastly, you can encounter the modulenotfounderror when you import a module that is not installed in your Python environment.

What is Pandas?

Pandas is the standard data science library for flexible and robust data analysis/manipulation. Pandas provides two data structures called Series and DataFrame; Series is similar to arrays. DataFrame is a collection of Series objects presented in a table, similar to other statistical software like Excel or SPSS. Pandas does not come installed automatically with Python. The easiest way to install Pandas is to use the package manager for Python called pip. The following installation instructions are for the major Python version 3.

How to Install Pandas on Windows Operating System

To install Pandas using pip on Windows, you need to download and install Python on your PC. Ensure you select the install launcher for all users and Add Python to PATH checkboxes. The latter ensures the interpreter is in the execution path. Pip is automatically installed on Windows for Python versions 2.7.9+ and 3.4+.

You can install pip on Windows by downloading the installation package, opening the command line and launching the installer. You can install pip via the CMD prompt by running the following command.

python get-pip.py

You may need to run the command prompt as administrator. Check whether the installation has been successful by typing.

pip --version

To install pandas with pip, run the following command from the command prompt.

pip3 install pandas

How to Install Pandas on Mac Operating System

Open a terminal by pressing command (⌘) + Space Bar to open the Spotlight search. Type in terminal and press enter.

To get pip, first ensure you have installed Python3:

python3 --version

Python 3.8.8

Download pip by running the following curl command:

curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py

The curl command allows you to specify a direct download link, and using the -o option sets the name of the downloaded file.

Install pip by running:

python3 get-pip.py

From the terminal, use the pip3 command to install pandas:

pip3 install pandas

How to Install Pandas on Linux Operating Systems

All major Linux distributions have Python installed by default. However, you will need to install pip. You can install pip from the terminal, but the installation instructions depend on the Linux distribution you are using. You will need root privileges to install pip. Open a terminal and use the commands relevant to your Linux distribution to install pip.

Installing pip for Ubuntu, Debian, and Linux Mint

sudo apt install python-pip3

Installing pip for CentOS 8 (and newer), Fedora, and Red Hat

sudo dnf install python-pip3

Installing pip for CentOS 6 and 7, and older versions of Red Hat

sudo yum install epel-release

sudo yum install python-pip3

Installing pip for Arch Linux and Manjaro

sudo pacman -S python-pip

Installing pip for OpenSUSE

sudo zypper python3-pip

Once you have installed pip, you can install pandas using:

pip3 install pandas

Check Pandas Version

Once you have successfully installed Pandas, you can use two methods to check the version of Pandas. First, you can use pip from your terminal:

pip show pandas

Name: pandas
Version: 1.2.4
Summary: Powerful data structures for data analysis, time series, and statistics
Home-page: https://pandas.pydata.org
Author: None
Author-email: None
License: BSD
Location: /Users/Yusufu.Shehu/opt/anaconda3/lib/python3.8/site-packages
Requires: python-dateutil, pytz, numpy
Required-by: statsmodels, seaborn, mlxtend
Note: you may need to restart the kernel to use updated packages.

Second, within your python program, you can import pandas and reference and then __version__ attribute:

import pandas as pd

print(pd.__version__)

1.2.4

Installing Pandas Using Anaconda

Anaconda is a distribution of Python and R for scientific computing and data science. Anaconda comes with pandas, numpy, and other relevant Python libraries for data science and machine learning. You can install Anaconda by going to the installation instructions, and Anaconda provides a complete list of packages available in the distribution across all operating systems.

If you have issues with using pandas in your conda environment, you can install it with the following command:

conda install -c anaconda pandas

Summary

Congratulations on reading to the end of this tutorial. The modulenotfounderror occurs if you misspell the module name, incorrectly point to the module path or do not have the module installed in your Python environment. If you do not have the module installed in your Python environment, you can use pip to install the package. However, you must ensure you have pip installed on your system. You can also install Anaconda on your system, which comes with pandas.

For further reading on installing data science and machine learning libraries, you can go to the articles:

• OpenCV: How to Solve Python ModuleNotFoundError: no module named ‘cv2’
• Requests: How to Solve Python ModuleNotFoundError: no module named ‘requests’
• Numpy: How to Solve Python ModuleNotFoundError: no module named ‘numpy’
• TensorFlow: How to Solve Python ModuleNotFoundError: no module named ‘tensorflow’

Go to the online courses page on Python to learn more about Python for data science and machine learning.

Have fun and happy researching!