Skip to main content
Question

Pandas library not installing for Startup Python Script to run

  • February 14, 2023
  • 3 replies
  • 276 views

Forum|alt.badge.img+1

I am trying to set up the Startup python script to be able to run a process which taps into Smartsheets API and converts it to an excel, which I then separately read into FME and runs through an FME process. I'd like to have the python code run every time before running through the data processing workflow I set up.

fmeerrorI have added my python script, set the interpreter to 3.10 and have installed modules into the Documents\\FME\\Plugins\\Python folder using command prompt : C:\\Program Files\\FME>fmeworkbench.exe python -m pip install pandas --target C:\\Users\\vberg2\\Documents\\FME\\Plugins\\Python . It ran and successfully installed pandas, along with a few other modules I installed after. I am however getting this error when I try to run the FME workspace: Python Exception <ModuleNotFoundError>: No module named 'pandas._libs.interval'. When I look into the folder directory, that file is there.

 

Am I missing a step, or did I install pandas incorrectly?

 

Thanks for the help!

3 replies

Forum|alt.badge.img+1
  • March 27, 2023

Same issue here.


debbiatsafe
Safer
Forum|alt.badge.img+21
  • Safer
  • March 29, 2023

I suspect the error you're seeing is due to the pandas library not being a universal library--it contains binary files that are Python-version and operating system specific.

 

The version of pandas installed is likely a different Python version than one required by FME. FME 2022.2 bundles a Python 3.10 interpreter. So the Windows Python 3.10 version of pandas needs to be installed for FME to be able to use.

 

You can confirm this by checking the C:\\Users\\<user>\\Documents\\FME\\Plugins\\Python\\pandas\\_libs directory as this folder contains binary files. The version of these binary files should be named something like interval.cp310-win_amd64.pyd. The number after interval.cp indicates the Python version the binary file is created for.


Forum|alt.badge.img+1
  • April 17, 2023

Trying to install alternative versions of libraries that were initially installed with default versions as defined by pip delivers following error:

ERROR: Directory 'C:\\\\Users\\\\<USER>\\\\Documents\\\\FME\\\\Plugins\\\\Python\\\\' is not installable. Neither 'setup.py' nor 'pyproject.toml' found.

 

Any clue?

 

Thanks.