JMP User Community

Latest Discussions

Want to count up when change occurs in either of two data columns

So I have 2 columns of data that have many identical values but which increment at certain points. They are the month and date of data points. Example: MonthDayDesired Counter:111111222233314314 Ive tried using lag unsuccessfully as I dont want an increment unless a value changes. I've tried different solutions including: If( Row() == 1, 1, Lag( :Month, 1 ) & Lag( :Day, 1 ), Lag( :DesiredCou...
chall

Discussions |
Aug 23, 2019 1:00 PM

3834 views | 4 replies
Select rows in one data table using rows from another

Hi JMP Community, I have two different data tables where they share a column in common, Lot number (Lot for short). (Running JMP Pro 14.1.0 on W10) The data tables are from two different sources and have different number of rows in them. I want to use one of the data tables to select the matching rows in the other data table. The values in Lot are continuous/numeric. dt1 has 1430 rows and dt2 ...
SDF1

Discussions |
Aug 23, 2019 10:55 AM

5561 views | 2 replies
Radio Box to Text

How can I turn a selection from a radio box into text? Trying below with no luck. Or is there some other simpler solution? win = New Window( "Radio Box", <<Modal, <<ReturnResult, Panel Box( "Select", rbox = Radio Box( {"A-CMP-1", "A-CMP-2"} ), toolcode = rbox<<get text; ), ); DSNString= "Driver={SQL Server}; SERVER=rb; DATABASE=FAB; UID=fab; "; sqlStr= " select vcLotCode, vcToolCode f...
smithwoosley

Discussions |
Aug 23, 2019 10:28 AM

5064 views | 3 replies
Search a list of strings for a partial string

Hello I am trying to find a way to search through a list of strings for all items that contain a partial string. I know this can be done using a For loop, but the list that I will be running this script on is very large and For loops take a very long time. I am wondering if there is some function out there similar to Loc(list, string) that will find the items that have the partial string. Just as ...
aallman

Discussions |
Aug 22, 2019 8:39 PM

4068 views | 1 replies
How to save final data table in PowerPoint?

I wish to save the summary data table and show in PowerPoint, so how can I do? Thank you.
almighty22

Discussions |
Aug 22, 2019 5:29 PM

6103 views | 9 replies

Previous
Next

Latest Discussions

Search a list of strings for a partial string

Hello I am trying to find a way to search through a list of strings for all items that contain a partial string. I know this can be done using a For loop, but the list that I will be running this script on is very large and For loops take a very long time. I am wondering if there is some function out there similar to Loc(list, string) that will find the items that have the partial string. Just as ...
aallman

Discussions |
Aug 22, 2019 8:39 PM

4068 views | 1 replies
Default Parameters for Elastic Net Logistic Regression

Hi all, I used to use JMP for data mining when I was in school, but have switched to using Python since then. I recently used JMP to build an Elastic Net Logistic regression with my data since its output is more intuitive. I attempted to replicate my results in python using the "SGDClassifier function" but my results were way off. I believe it may be because this function requires specifying se...
wa635419

Discussions |
Aug 22, 2019 7:05 AM

4346 views | 5 replies
Non-parametric coefficient of determination

Dear, I have a question about the use of the coefficient of determination (which is part of the output from a regression model). For the study I'm ready to analyze the data, I want to use the coefficient of determination (COD) to examine the relationship between my dependent variables which represent each column (see annex). But, as I found out each dependent variables (column) has a non consisten...
tomasVH

Discussions |
Aug 21, 2019 10:52 AM

2232 views | 2 replies
replacing numbers with strings

hey,i have a column COL_A, which has 31 rows for wach number between 1 - 31 ( 31 rows of 1, 31 rows of 2 .... etc), and i want to replace those numbers with 31 strings in a specifiec order, for example:if my string are in this order: horse, cat, dog ....etc, i want to replace the 1's with horse, the 2's with cat, the 3's with dog...., what is the best and fastest way to do it?
adham_saif

Discussions |
Aug 21, 2019 3:55 AM

3426 views | 3 replies
Merging time series with timestamp and duration

I would like to merge the following tables 1 (time series with certain events, ~2000 datapoints) and 2 (time series with duration and amplitude data, ~1,000,000 datapoints) into a table like 3: 1:timestampevent20:23:56:962A event20:24:14:964B event...... 2:time [s]amplitude0-0.0004577640.00006250.0642700195...... 3:timestamptime [s]eventamplitude20:23:56:9620A event-0.00045776420:23:56:9620.000062...
WHG

Discussions |
Aug 21, 2019 3:19 AM

3360 views | 5 replies

Previous
Next

Latest Discussions

How to Add Profit Matrix to Neural Net Confusion Matrix

Hi all, I'm using a neural net to predict whether or not a customer will prefer to buy retail items at a markdown or if they are likely to buy full-price (i.e., "bargain buyers" vs. traditional shoppers). I'd like to incoporate the opportunity cost of a false positive (giving discounts to what would otherwise be a full-price shopper) using a profit matrix, but changing values on the matrix in the ...
GhostBen

Discussions |
Aug 5, 2019 8:00 PM

1375 views | 0 replies
Capability Animation - How to see the LSL/USL Value?

I just discovered this nifty tool called the Capability Animation, where you can play around, dragging the spec limits and mean shifts, and it simulates your capability indices. But, I cannot see the actual LSL/USL values as I drag them! Does anyone know how to make this happen?
Antonio80

Discussions |
Jul 9, 2019 1:31 AM

1315 views | 0 replies
Unable to allocate enough memory in access or evaluation

Hi,I'm trying to use the Multivariate platform to perform a correlation between 6 time points (rows) across 73500 columns. My final goal is to output a 73500x73500 correlation matrix. When I try to run it, I immediately receive this pop out message:Unable to allocate enough memory in access or evaluation of 'List' , {/*###*/Estimation Method( 0 ), Matrix Format( 2 )} What's the issue? I'm using J...
ns

Discussions |
Jul 8, 2019 9:04 AM

1436 views | 0 replies
How to Post JSON data to a site via API functionality: "Unsupported Media Type"

Hi There, I am trying to perform a POST request to post some JSON data to a server, but unfortunately as of now I keep getting a 415 error. The goal of this script is to upload a JSON formatted file (or something of the like) to the server for other users to download/read. I noticed that there are very few POST examples with JSL, but quite the abundance with GET, which I have no problems with. I w...
liqinglei419

Discussions |
Jul 2, 2019 6:33 AM

1667 views | 0 replies
How to analyze crossover design data in JMP

I had crossover design data from one of my experiment, and I want to analyze it according to the rules of crossover design. Can someone please help me with this?
sharmachetan

Discussions |
Jun 14, 2019 2:34 PM

1288 views | 0 replies