Problem importing pandas and numpy package

[NickatLCB]

Hello all.

I am attempting the pandas module into my script through the cadwork api. However, I am having issues with the NumPy dependency. It seems NumPy and my version of Python are in conflict. I created a conda environment with python 3.9 and versions of pandas and numpy that correspond, but still have issues. I have added the path to these packages to my sys.path variable.

Does anyone know what could be the problem?

[ccalvocm]

Greetings @NickatLCB

Working fine in python=3.9.16 with anaconda. From terminal type:

1. conda create -n cwapi python=3.9.16
2. conda activate cwapi
3. pip install cwapi3d

Kind regards

[roehligas]

I remember struggling with it once upon a time.

I solved it scanning the sys paths in my normal python environment and pretty much appending all of the necessary ones to my python scripts inside cadwork, see below.

# import modules
import  cadwork   
import  element_controller      as ec
import  attribute_controller    as ac
import geometry_controller      as gc
import utility_controller as uc
import visualization_controller as vc
import menu_controller as mc
import sys

# Adding the Anaconda Environment paths to the system paths
# This is necessary to be able to access external packages
sys.path.extend(['',
'K:\\02 KONSTRUKSJON\\04 CADWORK\\external Anaconda Environment\\Cadwork\\python39.zip', 
'K:\\02 KONSTRUKSJON\\04 CADWORK\\external Anaconda Environment\\Cadwork\\DLLs', 
'K:\\02 KONSTRUKSJON\\04 CADWORK\\external Anaconda Environment\\Cadwork\\lib', 
'K:\\02 KONSTRUKSJON\\04 CADWORK\\external Anaconda Environment\\Cadwork', 
'K:\\02 KONSTRUKSJON\\04 CADWORK\\external Anaconda Environment\\Cadwork\\lib\\site-packages'])


# Import external packages from Anaconda environment
import pandas as pd

[Brunner246]

The NumPy version that works within cadwork is: "1.22.2"

[djdbarroso]

Hello everyone!
I'm having the same problem here... Included the path to the package but got an error with the compatibility of versions numpy/python, just like @roehligas wrote over.
Does Numpy still have to be version 1.22.2? If so, does it mean that the python version cannot be over 3.10?
Can someone help?

[NickatLCB]

If you are positive that pandas is installed, then you are not giving python the correct path to your pandas and numpy packages. This is more than likely your problem.

[djdbarroso]

Thanks for your reply, @NickatLCB.
I do have pandas installed and have no problems using it outside Cadwork, in Jupyter Notebook. I guess it must be something with either the path or the versions. I think the problem lies in the versions, but I'm not sure whether I shall "downgrade" Python/pandas to fit into a older version of numpy (1.22.2, like Cadwork aparently demands).

My installed versions are:
Python 3.11.7
Numpy 1.26.4
Pandas 2.1.4

Or, alternatively, do anyone of you know of a module in Python libraries (not external) that can write Excel files?

[Brunner246]

@djdbarroso
In cadwork version 30 (SP 2024) you have to use Python 3.10 and Numpy version 1.22.2

[djdbarroso]

I'll try that, then. Thanks, @Brunner246!