topic interpolate missing data value based on its neighbouring data in Discussions

interpolate missing data value based on its neighbouring data

Stokes — Sat, 10 Jun 2023 23:50:57 GMT

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

x	y	Z_Value
120	180	3.48
181	146
184	120	3.3
184	180	3.28
184	240	3.13
187	205
190	92
190	268
191	77
192	152
215	154
216	243
226	218
235	79
248	60	3.8
248	120	3.42
248	180	3.31
248	240	3.36
248	300	3.18
250	268
251	142
253	87
253	205
271	255
277	193
295	86
298	157
312	120	3.64
312	180	3.46
312	240	3.38
313	208
313	263
319	149
335	164
353	177
376	180	3.31

Re: interpolate missing data value based on its neighbouring data

txnelson — Wed, 13 Jul 2022 01:04:15 GMT

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

Re: interpolate missing data value based on its neighbouring data

Stokes — Wed, 13 Jul 2022 19:41:07 GMT

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.

Re: interpolate missing data value based on its neighbouring data

txnelson — Wed, 13 Jul 2022 20:14:31 GMT

Here is the example taken directly from the Scripting Index

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 );

Re: interpolate missing data value based on its neighbouring data

Stokes — Wed, 13 Jul 2022 21:16:11 GMT

This is great, thanks