JMP User Community

Latest Discussions

How to convert Python Pandas dataFrame to jmp format without saving it as files?

I know JMP support "Python Interface" function within JMP script envirornment. But somtimes it will be better to do co-work independently Python engineer and JMP one. In our case, Python engineer read database files with DB interface, and makes pre-process with Pandas library, and wants to convert JMP format because JMP enginner need only JMP format data in order to do data analysis and post-proce...
Kwangki

Discussions |
Nov 2, 2022 12:55 PM

19311 views | 11 replies
Heat Map / Aggregate Function

I wondered if anyone can point me in the right direction. I have a script that creates a table with Row, Column and Data fields (multiple Data field values for each (Row,Column) pair). I'd like to be able to create a Heat Map showing the Range for each Row and Column pair. By default the Mean is plotted. I can create an aggregated field (sum, median, std deviation and some others are included but ...
marktaylor

Discussions |
Nov 2, 2022 8:50 AM

2429 views | 3 replies
Loop function in Slider box

Hi,
I want to add ref line to several axis box and vary the reference line with slider box. I am wondering if loop can be used?

Here's my code:- I was able to add reference line to each of the charts but the issue I face is when I vary the slider box, the loop functions takes a while to add a reference line and it's glitchy. Any other alternate way to implement? I appreciate if you could advice. Th...
Jackie_

Discussions |
Nov 2, 2022 5:38 AM

1733 views | 3 replies
remove subplot titles

I want to get rid of subplot titles to get more space for the plots. Hm, GraphBuilderGroupBoxes - quite uncooperative, as mentioned before
https://community.jmp.com/t5/Discussions/Identifying-Titles-of-Graph-Builder-Page-Titles/m-p/426380/highlight/true#M67622
https://community.jmp.com/t5/Discussions/GraphBuilderGroupBox-lt-lt-Get-Window-Title-issue/m-p/423554 Seems that just the collapse and delet...
hogi

Discussions |
Nov 2, 2022 3:39 AM

2789 views | 4 replies
Is this possible to write a script that opens always the last sheet of an xlsx file?

I need a JSL script that opens always the last sheet of a chosen xlsx file. Is there a function to do this in JSL?
Alternatively, is it possible to accomplish this by compiling all the sheets of the Excel file into a list and open the last item of the list? Or open the excel file in a way that the user can input the sheet to open?
jlmbs

Discussions |
Nov 2, 2022 12:53 AM

2363 views | 5 replies

Previous
Next

Latest Discussions

Heat Map / Aggregate Function

I wondered if anyone can point me in the right direction. I have a script that creates a table with Row, Column and Data fields (multiple Data field values for each (Row,Column) pair). I'd like to be able to create a Heat Map showing the Range for each Row and Column pair. By default the Mean is plotted. I can create an aggregated field (sum, median, std deviation and some others are included but ...
marktaylor

Discussions |
Nov 2, 2022 8:50 AM

2429 views | 3 replies
JMP 17 Trial - windows server not supported

Dear members of the forum, I have just came across this issue during an attempt to install JMP 17 trial version on a windows server. Any ideas? Edit: I contacted JMP support and they confirm that the trial version will not work on windows server.
ron_horne

Discussions |
Nov 1, 2022 2:20 PM

1167 views | 0 replies
How to hover over a point and see the image associated with that row

Hi. I have a column in a table with URL links to images. I would like to hover over a point and see the image associated with that row. And also click the point and go to the URL. Any help would be much appreciated.
SampleTapir814

Discussions |
Nov 1, 2022 12:24 PM

2015 views | 2 replies
Questions about "Multi HTTP Request" of JMP17?

Hello!JMP17 added "Multi HTTP Request"
Sample code: Do the three download tasks download at the same time, or do the next tasks download when one is complete?
Will the overall download time be reduced by using this feature?urls = {"http://cdimage.ubuntu.com/lubuntu/releases/20.04.3/release/lubuntu-20.04.3-desktop-amd64.iso", "http://downloads.sourceforge.net/clonezilla/clonezilla-live-2.7.3-19-amd64...
lala

Discussions |
Nov 1, 2022 6:52 AM

2505 views | 5 replies
How to assign a data table reference to table opened by jmpquery?

Is there a way in JSL to assign a table created from a jmpquery execution?Instead of:dtBigClass = open("BigClass.jmp");I would like to assign "dtBigClass" to a jmpquery that I just executed. Many thanks, John
JohnDMoore1

Discussions |
Nov 1, 2022 12:16 AM

1353 views | 2 replies

Previous
Next

Latest Discussions

JMP 17 Trial - windows server not supported

Dear members of the forum, I have just came across this issue during an attempt to install JMP 17 trial version on a windows server. Any ideas? Edit: I contacted JMP support and they confirm that the trial version will not work on windows server.
ron_horne

Discussions |
Nov 1, 2022 2:20 PM

1167 views | 0 replies
How to run JSL script in user opened JMP session instead creating a new seesion by JMP.dll?

Currently I developed a windows application based on Interop.JMP.dll. The application contains a functionality to generate JSL file and run it in JMP but I got a issue now. It seems can only create a new session and run it by application instead of using the session that user opened first. I'd like to confirm whether it's possible to run JSL in the session by user opened manually. Appreciate it if...
SquaresDingo505

Discussions |
Oct 24, 2022 7:23 PM

720 views | 0 replies
How to Analyze and Graph Responses with Supercategories

I use JMP Pro 16. I am doing MCA on 90 columns that have supercategories. I want to do the analysis and viz on the supercategory classification. Is there a way to do this without having to create separate columns that only have the supercategory classification? PS: I don't know how to do JSL scripting.
TCM

Discussions |
Oct 21, 2022 5:59 AM

760 views | 0 replies
標準化列名稱如何用變數取代求解

//新增周標準化
weekEMC_HF_C_12_0 = Data Table( "周_EMC_HF_C_12um" ) << Get Column Names( string );
weekEMC_HF_C_12 = {};
//少一周={:"2022W38"n,:"2022W40"n,:"2022W41"n};
For( j = N Items( weekEMC_HF_C_12_0 ), j >= (N Items( weekEMC_HF_C_12_0 ) - 5), j--,
Insert Into( weekEMC_HF_C_12, weekEMC_HF_C_12_0[j] )
);
Try(
Local( {old dt = Current Data Table()},
Current Data Table( Data Table( "周_EMC_HF_C_12um" ) );
For Each( ...
Ken697

Discussions |
Oct 20, 2022 9:22 PM

677 views | 0 replies
Methods for compressing a CSV or TSV file with jmp compression to save as .jmp table without having to open the csv in JSL first?

I have access to both JMP12 and JMP14, so a solution for either would work. What I am trying to achieve is saving very large text files (csv,tab,tsv,etc.) with JMP compression such that I get a compressed .jmp file as the result. By large I mean 2-6gb files. Currently I use something like this: MyDataFile = open(filename,Private); MyDataFile << Compress File When Saved; MyDataFile << save(filetosa...
CurbStegosaurus

Discussions |
Oct 14, 2022 9:06 AM

1824 views | 0 replies