Welcome to the JMP User Community!

Latest Discussions

• Scripting to interpolate missing time series weather data?

  With hourly interval weather data there are occasional missing data points (missed reads).  I’d like to interpolate missing data point(s) – temperature, humidity, barometric pressure typically change gradually during a day.  I’d like to interpolate between the last and next time-series value in a column to get the missing value(s) to clean the data.  Imputation using the “Explore Missing Values” p...

  jthornton1

  Discussions |

  Jul 26, 2017 1:54 AM

  17959 views | 7 replies

• Is it Possible to Create a Scatter Plot with Pairs of Points Connected in GraphBuilder?

  Hi, I would like to create a large number (~100) of partially connected scatter plots similar to the mock example below:Mock Connected Scatter PlotEach connecting line connects the Baseline (BL) point to the Week 24 (W24) point for a patient. The data would be in the folling formatLet me know if you have any ideas: I certainly don't want to draw each connecting line by hand like I did on the mock ...

  sornasst

  Discussions |

  Jul 25, 2017 5:27 PM

  7992 views | 1 replies

• How to scale each column?

  Hello everyone,I have a simple question, I want to scale each column in a data table. So that each value of the same column is divided by the standard deviation of the column.Of course I can use the formula editor therefore if I have only a few columns, unfortunately I have over 1000 columns. So it would be great to have a function/tool in JMP which allows me to do that with all columns iterative....

  marcokunzelmann

  Discussions |

  Jul 24, 2017 11:23 PM

  16070 views | 5 replies

• Renaming Columns

  Hi everyone,   In my code, I open up a csv file, and I rename the column to "Column 1".  In the data table, it is renamed, but when I search through all the different columns, it can't find "Column 1". It only recognizes its original name when it is opened.  I am searching for values with in a data table, and I need to know what column it is in (which is working if I set i to 2).  I know that sett...

  natalie_

  Discussions |

  Jul 24, 2017 9:08 AM

  25217 views | 5 replies

• Nested for loop problem

  Hi, I am testing a nested for loop. col loop will create new columnsrow loop will write in data for each row. The inner row loop seems has problem, it created 1st col, but that is all. ====================colNames=list();
  colNames[1]="A";
  colNames[2]="B";
  colNames[3]="C";
  
  dt = New Table("new");
  Current Data Table(dt);
  
  for (col=1,col<=3,col++,
   
      dt<<NewColumn(colNames[col]);
   
      for(row=1,row<=4,row++,...

  Jay

  Discussions |

  Jul 22, 2017 8:28 AM

  101484 views | 5 replies