cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Stokes
Level IV

interpolate missing data value based on its neighbouring data

I have a work need to find the missing value based on its neighbouring value.

The value can be found below with its x,y coordinates.

The goal is to calculate the Z_value based on its neighbouring value fitting, such as contour map method.

THanks

 

 

xyZ_Value
1201803.48
181146 
1841203.3
1841803.28
1842403.13
187205 
19092 
190268 
19177 
192152 
215154 
216243 
226218 
23579 
248603.8
2481203.42
2481803.31
2482403.36
2483003.18
250268 
251142 
25387 
253205 
271255 
277193 
29586 
298157 
3121203.64
3121803.46
3122403.38
313208 
313263 
319149 
335164 
353177 
3761803.31
2 ACCEPTED SOLUTIONS

Accepted Solutions
txnelson
Super User

Re: interpolate missing data value based on its neighbouring data

The contour plot platform allows you to create a new data table where the xy matrix can be interpolated to whatever precision desired.

From the red triangle, select

     Save=>Generated Grid

Jim

View solution in original post

txnelson
Super User

Re: interpolate missing data value based on its neighbouring data

Here is the example taken directly from the Scripting Index

txnelson_0-1657743241948.png

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Little Pond.jmp" );
obj = dt << Contour Plot( X( :X, :Y ), Y( :Z ) );
obj << Generate Grid( 11, 11 );
Jim

View solution in original post

4 REPLIES 4
txnelson
Super User

Re: interpolate missing data value based on its neighbouring data

The contour plot platform allows you to create a new data table where the xy matrix can be interpolated to whatever precision desired.

From the red triangle, select

     Save=>Generated Grid

Jim
Stokes
Level IV

Re: interpolate missing data value based on its neighbouring data

This works, thanks.

By any chance, do you happen to know the JSL for the grid generation?
I am trying to use table copy script, but it doesn't work.

For example,to generate a 21 horizontal grid, and a 32 vertical grid. 

txnelson
Super User

Re: interpolate missing data value based on its neighbouring data

Here is the example taken directly from the Scripting Index

txnelson_0-1657743241948.png

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Little Pond.jmp" );
obj = dt << Contour Plot( X( :X, :Y ), Y( :Z ) );
obj << Generate Grid( 11, 11 );
Jim
Stokes
Level IV

Re: interpolate missing data value based on its neighbouring data

This is great, thanks