cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use to use Text Explorer to glean valuable information from text data at April 25 webinar.
Choose Language Hide Translation Bar
View Original Published Thread

Code to write JMP table to python

bjbreitling
Level IV

bjbreitling_0-1596749134723.png

The above is some code I got from JMP documentation but when I run it nothing happens. I have 64-bit version of python 3.8 and JMP Pro 15. Can anyone help me with this?

 

Do I need to add numpy and scipy and pandas? I have those in my python downloads. Do I need to put them in a different folder too for JMP to query?

11 REPLIES 11
David_Burnham
Super User (Alumni)


Re: Code to write JMP table to python

Nothing happens?  Is a JMP data table open at the point where you run the script? Are there any messages in the JMP Log?

-Dave
bjbreitling
Level IV


Re: Code to write JMP table to python

/**********/
# Import the numpy module for array and matrix support
import numpy as _JMPnp
/**********/

/**********/
# Import the scipy module for scientific computing support
import scipy as _JMPsp
/**********/

/**********/
# Import the pandas module for Series/Data Frame support
import pandas as _JMPpd
/**********/

Unable to import the 'numpy' Python module
Unable to import the 'scipy' Python module
Unable to import the 'pandas' Python module
bjbreitling
Level IV


Re: Code to write JMP table to python

This is what the log says:


/**********/
# Import the numpy module for array and matrix support
import numpy as _JMPnp
/**********/

/**********/
# Import the scipy module for scientific computing support
import scipy as _JMPsp
/**********/

/**********/
# Import the pandas module for Series/Data Frame support
import pandas as _JMPpd
/**********/

Unable to import the 'numpy' Python module
Unable to import the 'scipy' Python module
Unable to import the 'pandas' Python module

 

/**********/
print (dt)
/**********/

0

bjbreitling
Level IV


Re: Code to write JMP table to python

/**********/
# Import the numpy module for array and matrix support
import numpy as _JMPnp
/**********/

/**********/
# Import the scipy module for scientific computing support
import scipy as _JMPsp
/**********/
Here is the JMP log of the script. I have installed all of these packages in my 64 bit python site-packages folder.
/**********/
# Import the pandas module for Series/Data Frame support
import pandas as _JMPpd
/**********/

Unable to import the 'numpy' Python module
Unable to import the 'scipy' Python module
Unable to import the 'pandas' Python module

txnelson
Super User


Re: Code to write JMP table to python

It appears the Community is not able to help. Please submit this to JMP Support so you can get a tracking number, and the correct JMP individuals to look into the issue.
support@jmp.com
Jim
vince_faller
Super User (Alumni)


Re: Code to write JMP table to python

Are you using anaconda or just python?  Maybe JMP is not seeing the correct version of Python is my thought.  

Are you able to run a .py file with just those imports?

 

 

Vince Faller - Predictum
bjbreitling
Level IV


Re: Code to write JMP table to python

It was saying I had a 32-bit version of python as an error when running the script so I uninstalled that version and re-installed a 64-bit version. I also have a separate anaconda installation as well. I don't get that error anymore but it doesn't see those packages that I have installed apparently.

vince_faller
Super User (Alumni)


Re: Code to write JMP table to python

Where do you have those packages installed?  If you have multiple versions of python my guess is JMP is looking at one that you don't have them installed on.  

Vince Faller - Predictum
bjbreitling
Level IV


Re: Code to write JMP table to python

I had uninstalled the anaconda before reinstalling it after it didnt help so I had only one copy at some point.

Heres what I get from the log when I run the following:

 

Names Default To Here( 1 );

Python Init();

version = Python Get Version();

Show( version );

Python Term();

 

LOG:

 

/*:

version = {3, 8, 5, "final", 0};
0
//:*/