JMP User Community

Latest Discussions

JMP18: python: conversion from pandas to dataTable skips columns with missing values

import jmp, numpy as np, pandas as pd import jmputils def p2j(df): dt2 = jmp.DataTable('dt2', df.shape[0]) # get the column names from the data frame names = list(df.columns) # loop across the columns of the data frame for j in range( df.shape[1]): # check if the coulumn data type is string or numeric if is_string_dtype(df[names[j] ]): dt2.new_column(names[j], jmp.DataType.Character)...
minion

Discussions |
May 30, 2024 6:18 PM

2482 views | 3 replies
Retrieving limits when running chart script

Is there a way to script the retrieval of limits from a separate table each time the chart script is run? IR chart creation allows "get limits" functionality but the limits are saved into the script and will not retrieve revised limits from the same source table during subsequent chart retrieval. JMP 17Existing code :"NAME, %"n,
Individual Measurement( Avg( 0.013 ), LCL( -0.039 ), UCL( 0.066 ) ).
smw1985

Discussions |
May 30, 2024 4:37 PM

950 views | 1 replies
Update column with formula

Hi all,I have two data table (dt1 & dt2). I need to add dt2's column (Col1) to dt1 with a formula in it. But when I update the table, the values from Col1 are empty. Seems to be a problem in the formula. Please help current data table (dt1); dt1 << Update( With( dt2), Match Columns( :KeySample= :KeySample), Add Columns from Update table ( :Col1) ); dt1:Remarks << Formula ( If( :Col1== "Out of...
UserID16644

Discussions |
May 30, 2024 11:53 AM

2459 views | 5 replies
JMP 17

Hello,I recently upgraded to JMP 17, and I'm encountering a strange issue. When I open the data table window on the full screen, the script JSL window also opens on the full screen. Additionally, when I minimize the script JSL window, the data table window is also minimized. How can I fix this and keep the windows at different sizes?
Dennisbur

Discussions |
May 30, 2024 8:59 AM

1419 views | 3 replies
Make calculation show on table summary?

Hi!I am trying to get a column to show up on my table summary. This column would be the output of one of the columns IN the table summary divided by a constant. Is there a way to do that?
eruck

Discussions |
May 30, 2024 8:31 AM

767 views | 1 replies

Previous
Next

Latest Discussions

Update column with formula

Hi all,I have two data table (dt1 & dt2). I need to add dt2's column (Col1) to dt1 with a formula in it. But when I update the table, the values from Col1 are empty. Seems to be a problem in the formula. Please help current data table (dt1); dt1 << Update( With( dt2), Match Columns( :KeySample= :KeySample), Add Columns from Update table ( :Col1) ); dt1:Remarks << Formula ( If( :Col1== "Out of...
UserID16644

Discussions |
May 30, 2024 11:53 AM

2459 views | 5 replies
JMP 17

Hello,I recently upgraded to JMP 17, and I'm encountering a strange issue. When I open the data table window on the full screen, the script JSL window also opens on the full screen. Additionally, when I minimize the script JSL window, the data table window is also minimized. How can I fix this and keep the windows at different sizes?
Dennisbur

Discussions |
May 30, 2024 8:59 AM

1419 views | 3 replies
Make calculation show on table summary?

Hi!I am trying to get a column to show up on my table summary. This column would be the output of one of the columns IN the table summary divided by a constant. Is there a way to do that?
eruck

Discussions |
May 30, 2024 8:31 AM

767 views | 1 replies
Extract Max number from a column and feed it to a for loop in the same jsl script

My JSL script has 3 parts. In the first part, I am creating a numeric column (Column A) with 100 rows filled with random integers between 50-1000.In the 2nd part, I am extracting the max number in Column A and storing it to a variable i.In the 3rd part, I am using i to create a for loop that creates i number of new columns in the same table. How can I do this? It seems I can store the data in i bu...
AsymptoticCos

Discussions |
May 29, 2024 12:23 PM

2525 views | 8 replies
Transformation to orthogonalize the estimates.

In Standard Least Squares Models > Effect Screening If both Using estimates standardized to have equal variances and Using estimates
orthogonalized to be uncorrelated are selected an Orthog Coded value is listed. According to the manual this column shows the estimate of the parameter resulting from the transformation that is used to orthogonalize the estimates.What sort of transformation is used? T...
NaiveElk787

Discussions |
May 28, 2024 2:21 AM

1616 views | 5 replies

Previous
Next

Latest Discussions

How do I make scattorplot Matrix with multiple cloumns I select?

Hi. I'm Jeon.I'm beginner of JMP. I want to have a script for making scattorplot Matrix with Items I select.Could you give me a help with it? I splited one data table to two data table. one has value of test items(*Data type : Numeric & Continuous) , another one has upper limit & lower limit.(*Charactor & Norminal) Column names(=test item names) are the same in 2 different data table. Two sample d...
NagneTE1

Discussions |
May 27, 2024 5:18 PM

626 views | 0 replies
Importing multiple text files with different decimal separators (dot vs comma from English vs European speakers)

It seems that, sometimes, JMP 18 struggles to import files with different regional settings. This is a problem for first-time users who need to load multiple text files from different lab machines (JSL should not be the only answer). For example, if I have Windows and JMP in English, decimal separators can be changed from default to European (e.g., 3,14 instead of 3.14). With that option activated...
FN

Discussions |
May 22, 2024 3:24 AM

964 views | 0 replies
Creating DOE (and fitting) for non-linear response

Hello, I am still new to JMP but I'm trying to determine the best way to model a non-linear system (generating DOE + model fitting). Context: Long story short, I have a large experimental space that I am trying to model (10 discrete variables + 10 continuous variables). Before I jump into my full experiment I'm working with a subset (1 discrete variable + 5 continuous variables) to make sure I'm m...
EndogenousCame1

Discussions |
May 20, 2024 1:19 PM

852 views | 0 replies
How do I make my custom map automatically fill with color

嗨，我正在尝试在这里寻求帮助。我可以使用示例 1 中的数据表单实现自定义贴图的自动颜色填充，但我想使用 Samole 2 中的数据表单实现自动填充颜色，但无法实现。如果你知道如何做，请告诉我，谢谢。我想直接通过地图名称列的计数值实现地图的自动填充，而无需向名称类添加额外的数字描述列。
eric_min1993

Discussions |
May 17, 2024 9:22 PM

704 views | 0 replies
Load an OASIS (.oasis) Chip Layout File in JMP?

I have a .oasis file that contains layout data for a semiconductor die layout. Is it possible to load this file and view the layout in jmp 18? Similar to a Map file? Would then want to overlay defect location data on top of the die layout diagram.
WoHNY

Discussions |
May 16, 2024 12:02 PM

681 views | 0 replies