Cannot run testrail2Xray.py due to panda import issue

[rbarna1]

trafficstars

Wasn't able to install pandas 2.0.3 w/ pip --no-binary. So I cant seem to get around this pandas import error after pip -r requirements.txt

user@U-30DBVMK9DOVU1:~/dev/xray-code-snippets/use_cases/import_from_testrail/cloud$ pip install -r requirements.txt
Defaulting to user installation because normal site-packages is not writeable
Collecting pandas==2.0.3
  Downloading pandas-2.0.3-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.3 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 12.3/12.3 MB 40.2 MB/s eta 0:00:00
Requirement already satisfied: pytz>=2020.1 in /usr/lib/python3/dist-packages (from pandas==2.0.3->-r requirements.txt (line 1)) (2022.1)
Requirement already satisfied: tzdata>=2022.1 in /usr/local/lib/python3.10/dist-packages (from pandas==2.0.3->-r requirements.txt (line 1)) (2024.1)
Requirement already satisfied: python-dateutil>=2.8.2 in /usr/local/lib/python3.10/dist-packages (from pandas==2.0.3->-r requirements.txt (line 1)) (2.9.0.post0)
Requirement already satisfied: numpy>=1.21.0 in /usr/local/lib/python3.10/dist-packages (from pandas==2.0.3->-r requirements.txt (line 1)) (2.0.0)
Requirement already satisfied: six>=1.5 in /usr/lib/python3/dist-packages (from python-dateutil>=2.8.2->pandas==2.0.3->-r requirements.txt (line 1)) (1.16.0)
Installing collected packages: pandas
Successfully installed pandas-2.0.3
user@U-30DBVMK9DOVU1:~/dev/xray-code-snippets/use_cases/import_from_testrail/cloud$ python3 testrail2Xray.py -i myFile__testCases.xml -o myFile_testCases.csv
Traceback (most recent call last):
  File "/home/user/dev/xray-code-snippets/use_cases/import_from_testrail/cloud/testrail2Xray.py", line 4, in <module>
    import pandas as pd
  File "/home/user/.local/lib/python3.10/site-packages/pandas/__init__.py", line 22, in <module>
    from pandas.compat import is_numpy_dev as _is_numpy_dev  # pyright: ignore # noqa:F401
  File "/home/user/.local/lib/python3.10/site-packages/pandas/compat/__init__.py", line 25, in <module>
    from pandas.compat.numpy import (
  File "/home/user/.local/lib/python3.10/site-packages/pandas/compat/numpy/__init__.py", line 4, in <module>
    from pandas.util.version import Version
  File "/home/user/.local/lib/python3.10/site-packages/pandas/util/__init__.py", line 2, in <module>
    from pandas.util._decorators import (  # noqa:F401
  File "/home/user/.local/lib/python3.10/site-packages/pandas/util/_decorators.py", line 14, in <module>
    from pandas._libs.properties import cache_readonly
  File "/home/user/.local/lib/python3.10/site-packages/pandas/_libs/__init__.py", line 13, in <module>
    from pandas._libs.interval import Interval
  File "pandas/_libs/interval.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

[CMCunha]

The issue seem that: "Defaulting to user installation because normal site-packages is not writeable", are you using the same user (with permissions) to the site-packages directory?

The stack trace added shows that the packages was installed Installing collected packages: pandas Successfully installed pandas-2.0.3

But to the user directory, this means that the installation is going to one directory that is not the one you are using to run the script. Please make sure you solve this first.

[vnaipaul]

Pinning numpy to a pandas-2.0.3-compatible version (e.g. 1.26.4) as suggested for numpy.dtype size changed, may indicate binary incompatibility. Expected 96 from C header, got 88 from PyObject on Stack Overflow resolved this for me.

[CMCunha]

Thanks for looking into this @vnaipaul , I updated the requirements.txt file to have a compatible numpy version.

[vnaipaul]

Hi @CMCunha , I went on to create https://github.com/Xray-App/xray-code-snippets/pull/11 for this--feel free to close it. Thanks.