JMP User Community

Latest Discussions

How to get value of duplicate columns?

Hi all, How can I get the value of a Column A and place it with the duplicate value in Column B? For example, this is my data: Column AColumn BAApple AppleBBanana MangoCMango This is the expected output: Column AColumn BAAppleAAppleBBananaCMangoCMango
UserID16644

Discussions |
Apr 8, 2025 5:46 AM

692 views | 2 replies
How to model responses when their sum is equal to 1?

Hello!

I have completed a DoE in order to model the particle size distribution. The distribution is measured by several screens. For each size range (e.g. <1mm, 1-5 mm, >5 mm), I have the proportion of particles, and the sum must be one. My question is how to model the three responses properly, taking into account that the sum of the responses must equal 1. I have included a synthetic table to...
Florent_M

Discussions |
Apr 8, 2025 5:45 AM

962 views | 3 replies
find is missing start from column X till ncol()

Hi, I have a table that has thousand of columns. I want to use column matrix to find if across a range of columns is missing. I first identify the starting of the first column number using Loc(). allcol = dt << get column names(string); colname = column ("starting column") << getname; colnumber = (Loc(allcol ,colname))[1]; then I want to find if the columns from colnumber till ncol() is mis...
dadawasozo

Discussions |
Apr 7, 2025 6:34 PM

595 views | 1 replies
cross validation using k-fold fit quality

I am using Lasso fit with leave one out or K-fold cross validation. Please advise the best way to view the R square and other fit quality metrics (e.g., AIC) in the output. It would be helpful to have this for the training set and the validation set (average of all hold outs).
daniel_s

Discussions |
Apr 7, 2025 3:38 PM

2053 views | 7 replies
Life distribution: how to set the markers and weibull fit to use Kaplan-Meier or Turnbull estimates

Hello, The below is the test table I made. According to the description: https://www.jmp.com/support/help/en/18.1/index.shtml#page/jmp/event-plot.shtml#ww1386833 It meas there are total 100 samples. And exactly at 4 readings: 50, 100, 150 and 200, there are 25 new failures happened. So the failure rate I expected will be: 50, 25% 100, 50%, 150, 75% 200,100%. The markers in the Weibull plot ...
Doraemon214

Discussions |
Apr 7, 2025 3:16 PM

636 views | 2 replies

Previous
Next

Latest Discussions

How to get value of duplicate columns?

Hi all, How can I get the value of a Column A and place it with the duplicate value in Column B? For example, this is my data: Column AColumn BAApple AppleBBanana MangoCMango This is the expected output: Column AColumn BAAppleAAppleBBananaCMangoCMango
UserID16644

Discussions |
Apr 8, 2025 5:46 AM

692 views | 2 replies
How to model responses when their sum is equal to 1?

Hello!

I have completed a DoE in order to model the particle size distribution. The distribution is measured by several screens. For each size range (e.g. <1mm, 1-5 mm, >5 mm), I have the proportion of particles, and the sum must be one. My question is how to model the three responses properly, taking into account that the sum of the responses must equal 1. I have included a synthetic table to...
Florent_M

Discussions |
Apr 8, 2025 5:45 AM

962 views | 3 replies
Life distribution: how to set the markers and weibull fit to use Kaplan-Meier or Turnbull estimates

Hello, The below is the test table I made. According to the description: https://www.jmp.com/support/help/en/18.1/index.shtml#page/jmp/event-plot.shtml#ww1386833 It meas there are total 100 samples. And exactly at 4 readings: 50, 100, 150 and 200, there are 25 new failures happened. So the failure rate I expected will be: 50, 25% 100, 50%, 150, 75% 200,100%. The markers in the Weibull plot ...
Doraemon214

Discussions |
Apr 7, 2025 3:16 PM

636 views | 2 replies
Python Code unable to generate output in JSL (JMP 17 Pro)

Hello All, I have a JSL script that creates a Datatable, and I have a python code block within the JSL script which I want to pass the DataTable to make predictions on the DataTable using a trained machine learning model. Before the python code block, the DataTable is accessible and even opens in JMP. However, after the python code block when I try to access the predictions made by the neural ne...
dmanu221993

Discussions |
Apr 7, 2025 8:31 AM

1360 views | 6 replies
find continuous empty cells

Hi, is there a way to find continuous empty rows like below? is there any function in JMP that can quickly finding specific number of continuous empty rows? example in picture. in the same column there is multiple rows that is empty but I only interested with the 3 continuous rows that is empty.
dadawasozo

Discussions |
Apr 5, 2025 5:08 AM

769 views | 2 replies

Previous
Next

Latest Discussions

Discovery summit book signings - official list of books?

Fellow JMP enthusiasts! During the 2024 Manchester Discovery Summit I was surprised to learn that the handing out and signing of books is a tradition. So, I am wondering whether there is a list of the books handed out & signed so far. If it exists, where to find it?I thoroughly enjoyed reading "Bitch" by Lucy Cooke, and I have a feeling "Hello World" by Hannah Frey will be a good read too.
Ressel

Discussions |
Feb 28, 2025 11:25 AM

487 views | 0 replies
Inquiry Regarding the Use of JMP and JMP Live (Suppress Eval?)

Hello, I am a user of JMP Live.
I am currently utilizing a simple function within JMP to leverage the Auto Refresh feature in JMP Live for dashboard purposes. However, while the function operates correctly on my PC, it does not work properly on JMP Live.Even though I have disabled "Suppress Eval" before executing Data Publish, when I later download the data, the column where the function should be ...
DJ_Kim

Discussions |
Feb 27, 2025 2:59 PM

533 views | 0 replies
query text files from zip folder in Azure blob file system secure (ABSS) url

Hi All,I wonder if anyone has the experience to query text files from zip folder through Azure blob file system secure (ABSS) url?
the url looks like format below. If you do, can you share some script lines how to connect to the url at least?

abfss://filesystemname@accountname.dfs.core.windows.net
dadawasozo

Discussions |
Feb 18, 2025 1:37 PM

455 views | 0 replies
Streamlining Data Workflows With JMP & MATLAB

Integrating tools like JMP and MATLAB offers a streamlined approach to engineering analysis, making workflows more efficient and reducing the need for redundant script rewriting. By leveraging JMP’s powerful data analysis and visualization capabilities alongside MATLAB’s robust computational tools, engineers can seamlessly combine the strengths of both platforms. This integration allows for the ra...
brycerjs8

Discussions |
Feb 18, 2025 7:07 AM

558 views | 0 replies
Question About F-Tests in GLMMs with Binomial Errors

Hi,
I have a question regarding Generalized Linear Mixed Models (GLMMs) in JMP pro. Most statisticians consider it inappropriate to use F-tests or t-tests to evaluate predictor contributions in GLMs or GLMMs with binomial errors. This is because F- and t-tests are based on sums of squares, which assume normally distributed residual errors.
While using a logit link function helps linearize the relati...
LanaMilana

Discussions |
Jan 17, 2025 2:21 AM

764 views | 0 replies