delete rows
I have several data sets from excel. My question is that how do i delete the last two rows using scripting regardless of how many number of rows -- i only need to remove the last two rows since its of no use.
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI have several data sets from excel. My question is that how do i delete the last two rows using scripting regardless of how many number of rows -- i only need to remove the last two rows since its of no use.
I am trying to reduce the number of rows.
I need a function where if Column 3 have any empty cell , it will delete the whole row.
here is a picture of the table
in this case Column 3 name is (Row 4)
Hello everyone,I have a number of already created graphs - all one graph in a single window.Now I'm creating a script that goes over all open graph windows and changes some text within the graph.I got this far: wList = Get Window List(Type("Reports"));
For(w = 1, w <= nitems(wList), w++,
Print(wList[w] << Get Window Title());
wList[w] << SendToReport( [...]Basicially, once I have the window, I'...
Problem: Why my validation sets worked better than the training sets?Data: 200 data points; 90% for training and 10% for validationStatistical: 1. make validation column Make Validation Column(
Training Set( 0.90 ),
Validation Set( 0.10 ),
Test Set( 0.00 ),
Formula Random); 2. neural nets: one hidden layer, 3 nodes TanH B...
Hello everyone, I am struggling to understand the logic with the JSL language... I have tried to look for this in the help/ scritping menus but there is just too much information there... How do you display a variable in a dialog box ? I'm using instructions likeHList ("Some message" ),
HList ( "Another message"),
HList ( "blablabla"),
HList(variable), The messages between " " display fine, but wh...
I am trying to reduce the number of rows.
I need a function where if Column 3 have any empty cell , it will delete the whole row.
here is a picture of the table
in this case Column 3 name is (Row 4)
Hello, I am doing some fit curve work on log transformed mortality data using 2 parameter probit and am super confused as to why the upper and lower limits are the same value for this log transformed dataset when comparing using an ANOM: When I run this on the same data untransformed I get appropriate limits for a comparison. is this a glitch or am I doing something wrong? Kind regards,Joe
I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
I have a data table and I need to get the first 4 largest values from a range of columns, labeled "Nozzle #". These column values vary by variable, or column labeled "Test #". I then need to apply these values and in a new column calculate area of a circle per test #. Since I have a larger data table, I would like to either group the columns using the For, If, and Contains logic or is there a more...
How to enter a formula similar to sumif, count if and vlookup in jmp
I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller
I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...
I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the standard error reported in the Least Squares Means table for the same effect. How are they calculated differently? Thanks!
Hello, So I've written a JMP UI, and once I gather data from the user I have a button that dumps the form data to a CSV.Now I need to launch my python script and other .exe (as an administrator), my python scripts pick up the user input from the CSV and perform the next steps.Right now it's a .py but I may need to run it through py2exe and compile it into an exe later so a solution that supports...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
JMP Live offers JMP users collaborative analytics software to share analyses from JMP to a secure, c...
French Mastering JMP Transformez des données brutes en informations exploitables grâce à l’éditeur d...
EMEA Mastering JMP Experimenting with microbial and mammalian systems brings a multitude of data; bi...