Select last point in each run
Suppose I have columns: run_id, time, distance ... and I want to just select the rows with the last time for each run_id. How do I do that?
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesSuppose I have columns: run_id, time, distance ... and I want to just select the rows with the last time for each run_id. How do I do that?
Hi - I've created a Scatterplot Matrix in JSL by supplying it with a list of variables to plot as shown below. "Yvars_List" is just a list of the names of the variables that I want to plot against one another, so a typical list might be something like {"Height", "Weight", "Shoesize"}. I have a list of maybe fifty other variables that I could plot instead, so I want to be able to substitute any o...
I am wondering whether it is possible to project new data to an existing PCA map. Per my limited knowledge with PCA map generation I do not think it is the case. But want to check with JMP community on this.The context is that we generated a map using objective data on 20 products with 30 variables. Let's say after an year we want to project data from 3 new products with same 30 variables to the ...
I have a data set where I have conditions, and different measurements taken. For example:Sex Age Height Shoe sizeMale 20 66 in. 10Female 18 60 in. 8 I am making a script to view distribution, and variation. I would like to make graphs for height, and shoe size(seperately). In some instances I have some height outliers (let's assume), but...
See the JMP's ability to quickly download JSON data from the WEB and organize it into a table form. https://community.jmp.com/t5/Discovery-Summit-2018/Importing-Web-Service-Data-The-New-HTTP-Request-in-JMP-nbsp-14/ta-p/73717 But I failed to master the method.Just learn to download this JSON file using JSL.Ask an expert how to organize data into tables. Thanks!
I am wondering whether it is possible to project new data to an existing PCA map. Per my limited knowledge with PCA map generation I do not think it is the case. But want to check with JMP community on this.The context is that we generated a map using objective data on 20 products with 30 variables. Let's say after an year we want to project data from 3 new products with same 30 variables to the ...
Hi, I am using the graph builder to make contour plots (hundreds) and cannot figure out how to change the color theme for all of the at once. I can get individual graphs to change of course but i don't want to repeat the same action hundreds of times. thx
Hi
I have a list of stocks and their respective indicators and annual return across several years. I would like to do a panel data analysis but my panel data were heavily unbalanced. Can I ask
1) how JMP deals with those missing data when I run the fixed effect mixed model?
2) Where can I find information on how to interpret the mixed model results? Especially on the repeated measures results.
How to show a decimal digit (DO NOT round numbers on a histogram)? Pls. look pic.
Hi everyone, First time I'm writing here, though I have read in this forum a lot. I do have some experience in JSL scripting, but I still haven't dealt with for loops. I have this data table which has 5 columns: entity, date1, date2, value1, value2 (value2 column initially contains missing values only). The table is sorted by Entity (ascending) and date1 (descending). I want to loop through all ro...
I am totally new to the JMP community and have a limited coding background. I am working with Life Distributions (Weibulls mostly), and I would like to create an Add-in that can do the following tasks once I have selected the best distribution fit: 1. Save specific report data from distribution (see the data tables in red) 2. Export the data into an excel sheet 3. Have the add-in button available ...
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 ...
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?
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...
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...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
REGISTER HERE *** Note that this webinar starts at a different time than the other Fall 2025...
Jump into Graphing Date: Wednesday, September 24Time: 1:00 – 2:30 p.m. ETDura...
German Mastering JMP Webinar Finden Sie heraus, wie Sie Analyseschritte interaktiv automatisi...