topic Re: How to install dt2pandas library in JMP18 python on windows OS？ in Discussions

How to install dt2pandas library in JMP18 python on windows OS？

lala — Sat, 23 Nov 2024 05:49:21 GMT

Thanks!

import jmp
from dt2pandas import dt2df

I was looking at the MAC code

Re: How to install dt2pandas library in JMP18 python on windows OS？

lala — Sat, 23 Nov 2024 05:52:07 GMT

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

Re: How to install dt2pandas library in JMP18 python on windows OS？

jthi — Sat, 23 Nov 2024 14:20:18 GMT

You can make a copy of dt2pandas.py to same folder where your .jsl file is OR most likely better option, copy it to JMP's site-packages ( Scripting Guide > Python > Creating a Pandas DataFrame from a JMP Data Table).

Re: How to install dt2pandas library in JMP18 python on windows OS？

lala — Sat, 23 Nov 2024 23:41:58 GMT

I don't know how to operate, I have copied it into two directories
My script is put in C:\test2.py

Thanks!

Re: How to install dt2pandas library in JMP18 python on windows OS？

jthi — Sun, 24 Nov 2024 06:44:54 GMT

The path full path (on windows) is something like this

C:\Users\<user>AppData\Roaming\JMP\JMP\Python\Python311\site-packages (you should be able to access it with %appdata%\JMP\JMP\Python\Python311\site-packages)

Re: How to install dt2pandas library in JMP18 python on windows OS？

lala — Sun, 24 Nov 2024 07:30:49 GMT

Neither was successful.

dt = New Table( "Array - JSL", Add Rows( 10 ),New Column( "A"), New Column("AB"));
ABC = [1.61803, 3.14159, 5., 7., 9., 2.1, 0.8, 0.5321, 0.443682, 0.00012];
Column( dt, "A" ) <<Set Values(ABC );
Column( dt, "AB" ) << Set Values( Reverse(ABC));
Python Send(dt);
Python Submit ("\[
import jmp
from dt2pandas import dt2df
DA = dt2df(dt)
DA['SUM'] = DA['A'] + DA['AB']
]\");
dt2 = Python Get(DA);
dt2 << New Data View;

Re: How to install dt2pandas library in JMP18 python on windows OS？

jthi — Sun, 24 Nov 2024 07:43:35 GMT

Have you checked out what you are trying to import? For me that error message is saying that dt2pandas does not have dt2df. Personally, I wouldn't use that method described in dt2pandas.py (at least the version I have) as it messes with your JMP Preferences and that is very rarely a good idea. It is quite easy to write your own function to do this (I assume you are trying to convert JMP datatable to pandas dataframe) and there are quite a few examples in JMP community.

Re: How to install dt2pandas library in JMP18 python on windows OS？

Paul_Nelson — Mon, 25 Nov 2024 15:03:28 GMT

The dt2pandas.py file contained within $SAMPLE_SCRIPTS/Python does not have a dt2df() function. The sample scripts contains a to_pandas() function. This sample is an example of exactly how JMP 14 through JMP 17 created a pandas dataframe from a JMP data table via a CSV file in the filesystem. The other option not mentioned is just copy the function into your own file instead of importing it. Though either copying to your JMP site-packages directory or the same directory as your script.