I was trying to retrieve all the 4 digit characters under column A from an excel file.

Though running the program it gives the following error:

Traceback (most recent call last):
  File "C:UsersUtenteAppDataLocalProgramsPythonPython311get tags.py", line 1, in <module>
    import pandas as pd
  File "C:UsersUtenteAppDataLocalProgramsPythonPython311Libsite-packagespandas__init__.py", line 22, in <module>
    from pandas.compat import is_numpy_dev as _is_numpy_dev  # pyright: ignore # noqa:F401
  File "C:UsersUtenteAppDataLocalProgramsPythonPython311Libsite-packagespandascompat__init__.py", line 25, in <module>
    from pandas.compat.numpy import (
  File "C:UsersUtenteAppDataLocalProgramsPythonPython311Libsite-packagespandascompatnumpy__init__.py", line 4, in <module>
    from pandas.util.version import Version
  File "C:UsersUtenteAppDataLocalProgramsPythonPython311Libsite-packagespandasutil__init__.py", line 2, in <module>
    from pandas.util._decorators import (  # noqa:F401
  File "C:UsersUtenteAppDataLocalProgramsPythonPython311Libsite-packagespandasutil_decorators.py", line 14, in <module>
    from pandas._libs.properties import cache_readonly
  File "C:UsersUtenteAppDataLocalProgramsPythonPython311Libsite-packagespandas_libs__init__.py", line 13, in <module>
    from pandas._libs.interval import Interval
  File "pandas_libsinterval.pyx", line 1, in init pandas._libs.interval
ValueError: numpy.dtype size changed, may indicate binary incompatibility. Expected 96 from C header, got 88 from PyObject

Tried uninstalling and installing both Numpy and Pandas but some Warning messages appear in the prompt and it says “already satisfied” while I’ve just uninstalled them, so it shouldn’t.

Here is the prompt text:

C:UsersUtente>pip uninstall pandas numpy
Found existing installation: pandas 2.2.2
Uninstalling pandas-2.2.2:
  Would remove:
    c:usersutenteappdatalocalprogramspythonpython312libsite-packagespandas-2.2.2.dist-info*
    c:usersutenteappdatalocalprogramspythonpython312libsite-packagespandas.libsmsvcp140-ef6047a69b174ada5cb2eff1d2bc9a62.dll
    c:usersutenteappdatalocalprogramspythonpython312libsite-packagespandas*
Proceed (Y/n)? Y
  Successfully uninstalled pandas-2.2.2
Found existing installation: numpy 2.0.1
Uninstalling numpy-2.0.1:
  Would remove:
    c:usersutenteappdatalocalprogramspythonpython312libsite-packagesnumpy-2.0.1-cp312-cp312-win_amd64.whl
    c:usersutenteappdatalocalprogramspythonpython312libsite-packagesnumpy-2.0.1.dist-info*
    c:usersutenteappdatalocalprogramspythonpython312libsite-packagesnumpy.libslibscipy_openblas64_-fb1711452d4d8cee9f276fd1449ee5c7.dll
    c:usersutenteappdatalocalprogramspythonpython312libsite-packagesnumpy.libsmsvcp140-8021418012832a07a8ca5105a33b1086.dll
    c:usersutenteappdatalocalprogramspythonpython312libsite-packagesnumpy*
    c:usersutenteappdatalocalprogramspythonpython312scriptsf2py.exe
    c:usersutenteappdatalocalprogramspythonpython312scriptsnumpy-config.exe
Proceed (Y/n)? Y
  Successfully uninstalled numpy-2.0.1

C:UsersUtente>pip install pandas numpy
WARNING: Ignoring invalid distribution ~umpy (C:UsersUtenteAppDataLocalProgramsPythonPython312Libsite-packages)
WARNING: Ignoring invalid distribution ~umpy (C:UsersUtenteAppDataLocalProgramsPythonPython312Libsite-packages)
Collecting pandas
  Using cached pandas-2.2.2-cp312-cp312-win_amd64.whl.metadata (19 kB)
Collecting numpy
  Using cached numpy-2.0.1-cp312-cp312-win_amd64.whl.metadata (60 kB)
Requirement already satisfied: python-dateutil>=2.8.2 in c:usersutenteappdatalocalprogramspythonpython312libsite-packages (from pandas) (2.9.0.post0)
Requirement already satisfied: pytz>=2020.1 in c:usersutenteappdatalocalprogramspythonpython312libsite-packages (from pandas) (2024.1)
Requirement already satisfied: tzdata>=2022.7 in c:usersutenteappdatalocalprogramspythonpython312libsite-packages (from pandas) (2024.1)
Requirement already satisfied: six>=1.5 in c:usersutenteappdatalocalprogramspythonpython312libsite-packages (from python-dateutil>=2.8.2->pandas) (1.16.0)
Using cached pandas-2.2.2-cp312-cp312-win_amd64.whl (11.5 MB)
Using cached numpy-2.0.1-cp312-cp312-win_amd64.whl (16.3 MB)
WARNING: Ignoring invalid distribution ~umpy (C:UsersUtenteAppDataLocalProgramsPythonPython312Libsite-packages)
Installing collected packages: numpy, pandas