No Module named 'pandas'

[#1]

I’m running a JSL script in JMP 18 that uses Python. On macOS everything works fine, but on Windows I get this error:

Traceback (most recent call last):
  File "<string>", line 7, in <module>
ModuleNotFoundError: No module named 'pandas'

In the embedded log is see following: 

Creating: C:\\Users\\Admin\\AppData\\Roaming\\JMP\\JMP\\Python\\Python311\\site-packages

This tells me that JMP 18 doesn't install python automatically. Is there a pre-requisite for python be installed?

I am also trying to install this way to ensure the script doesn't fail irrespective of the system:

Python Submit("
import jmputils
required_packages = ['pandas', 'numpy']

# get list of installed python packages
installed = jmputils.jpip('list')

# check & install missing packages
for pkg in required_packages:
    if pkg.lower() not in [p.lower() for p in installed]:
        print(f'{pkg} not installed — installing...')
        jmputils.jpip('install', pkg)
    else:
        print(f'{pkg} is already installed.')

jmputils.jpip('list')

");

[#2 · Accepted solution]

To my knowledge, in JMP18 that folder gets added when Python is "run" first time and you can most maybe force it by running something like 

Python Submit("import jmp");

in JMP Script Editor

[#3]

An error message from Python is a clear sign that python is installed ; )

to install Python packages from JSL, please use:

Python Install Packages( "numpy pandas" );

[#4]

Thanks, yes it created the python directory and few packages. below:

Python Submit("
import jmputils

required = ['pandas', 'numpy']

# Get installed packages safely
installed = jmputils.jpip('list')
if installed is None:
    installed = []

print('Installed packages:', installed)

# Install missing ones
for pkg in required:
    if pkg.lower() not in [p.lower() for p in installed]:
        print(f'{pkg} not installed — installing...')
        jmputils.jpip('install', pkg)
    else:
        print(f'{pkg} already installed.')



import pandas as pd
import numpy as np
print('pandas and numpy imported successfully!')

");

[#5]

yes, that did help me to ensure the folder gets added. thanks

[#6]

Using that import is one of the checks we use in our JMP-Python applications to make sure everything has been setup.

I'm still holding out from using JMP19 due to many reasons, but it will make using JMP-Python integration easier. If I remember correctly in JMP19 it will be unnecessary, but I haven't verified it. JMP19 will also make it easier to check if packages have been installed as jmputils gets "is_installed" method. 

[#7]

In JMP 18, unpacking the site-packages.zip file and creation of the directory was done by the jsite.py script. JMP 19 does this internally in C++ code the first time Python is initiated.   The jsite.py script still exists as a backup for when the command line jpip.bat or jpip shell scripts are generated by Python Create JPIP CMD(). Or it's Python equivalent jmputils.create_jpip( dest_path ) .

JMP 19 improves scriptable package management by adding jmputils.is_installed( 'package_name' ), jmptuils.package_version( 'package_name' ) and pkg_dict = jmputils.packages().  These were late additions to 19.0, they are present, but not documented in the scripting index.  Later updates do have examples in the scripting index.