JMP User Community

Latest Discussions

Post processing of data in a csv file using script

I have a folder with mutiple csv files having similar data structure whose data I need to process and store the results in a new file.
Each csv file has 2 columns, I need to process the data in the second column as follows:Name the second column as itemsPerform the following operation on all rows creating a new column x with the following formula :36 + -19.5 * :items+ 49.99 *:items* :items* :items...
jojmp

Discussions |
Jan 21, 2019 7:58 PM

10462 views | 5 replies
Renaming Data Table using a previous table name

I know I can rename a table using dt << SetName("FirstTablename"); But say I'd like to rename a 2nd data table that concatenates the name of the 1st data table so that it is something likedt2 << SetName( Nameof1stTable || " 2"); Does anyone know how I could just name a 2nd table with an appended character? The reason I want to do this is that usually I modify multiple tables in JSL with splits and...
bioptical

Discussions |
Jan 21, 2019 9:38 AM

4391 views | 1 replies
Spacing in side-by-side bar chart

Is there anyway to put gaps between the side-by-side bars? I want to have the bars labeled but you can see that the labels look like garbage because they just overlap. I really don't want to make the font any smaller. Any ideas?
PNash

Discussions |
Jan 20, 2019 2:39 AM

7295 views | 1 replies
Ternary plot and background grid issue with JMP 14

Hello,Since I moved to JMP 14 I have this issue when plotting ternary plots with Contour fill: a grid is systematically drawn with thin white horizontal and vertical lines (see captures), whatever the Color theme chosen for the Contour fill. This issue was not present in my previous JMP versions until JMP 13. Any idea to remove these thin white horizontal and vertical lines? I can't manage to remo...
dp30

Discussions |
Jan 18, 2019 1:16 PM

5403 views | 4 replies
Select Where(Contains()) Usage

I often find that the Contains() function inside the Select Where() function can be convenient. What if I would like to select all rows where a designated column contains the string "a" when it is followed by a number? For example, in a column with the values "a", "a12", and "absent", only the row with "a12" would be selected. Thanks for any tips!
twillkickers

Discussions |
Jan 18, 2019 10:33 AM

10065 views | 3 replies

Previous
Next

Latest Discussions

Ternary plot and background grid issue with JMP 14

Hello,Since I moved to JMP 14 I have this issue when plotting ternary plots with Contour fill: a grid is systematically drawn with thin white horizontal and vertical lines (see captures), whatever the Color theme chosen for the Contour fill. This issue was not present in my previous JMP versions until JMP 13. Any idea to remove these thin white horizontal and vertical lines? I can't manage to remo...
dp30

Discussions |
Jan 18, 2019 1:16 PM

5403 views | 4 replies
Select Where(Contains()) Usage

I often find that the Contains() function inside the Select Where() function can be convenient. What if I would like to select all rows where a designated column contains the string "a" when it is followed by a number? For example, in a column with the values "a", "a12", and "absent", only the row with "a12" would be selected. Thanks for any tips!
twillkickers

Discussions |
Jan 18, 2019 10:33 AM

10065 views | 3 replies
How to set color scale for a contour plot

and if I have several plots by page, how to set the different scale for each of them? Thanks a lot!
jasongao

Discussions |
Jan 17, 2019 5:14 PM

3130 views | 1 replies
Get Selected Rows results in error, when using the rows

Hey,i can´t figure out, why the following results in an error: For( i = 1, i <= N Items(list), i++, item = list[i]; rows = dt << Get Rows Where( dt:foo == item ); Column(dt, "bar" )[rows] = "foobar"; );The error is: "Cannot set value for the column 'bar' because the row number (-1) is not valid.{941}" Can anyone enlighten me? Thank you!
vkessler

Discussions |
Jan 17, 2019 9:55 AM

5465 views | 5 replies
How to do Bilinear Interpolation using JMP?

Essentially it is called 2D multivariate interpolation. I have set of locations (x,y) and a corresponding data eg: z=color value. For some of the (x,y) the z column has data missing. I want to use the nearest two known ( x1,y1,z1) and (x2,y2,z2) to interpolate the value for (x3,y3, z3=?). Theoretically this wiki/Bilinear_interpolation is what I like to get. Does JMP has a way of doing this? Also ...
smostafa

Discussions |
Jan 17, 2019 8:16 AM

3271 views | 1 replies

Previous
Next

Latest Discussions

I want to use LASSO and Group LASSO in JMP

I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
gene

Discussions |
Nov 2, 2018 7:43 AM

2227 views | 0 replies
Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

2922 views | 0 replies
how to change the type and color of lines in graph

I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...
Yu

Discussions |
Sep 25, 2018 2:34 AM

3232 views | 0 replies
Mean separation letter from test slices

Hello!

How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
jfranc19

Discussions |
Sep 14, 2018 2:35 PM

2068 views | 0 replies
repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

2941 views | 0 replies