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...
DMR
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...
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...
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?
Date: Thursday, March 5Time: 1:00–2:00 p.m. ETRegistration: FREE Whether you've just...
JMP goes beyond analyses to ensure you get correct information into the right hands at the right tim...
JMP Student Edition has extensive regression and ANOVA capabilities implemented in an interacti...
JMP offers a variety of ways to interactively examine and model the relationship between an output v...