cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Column Interpolation Add-In
benfrancis
Staff benfrancis
Staff
Created: May 5, 2021 04:36 AM  |  Last Modified: May 5, 2021 1:44 AM
Column Interpolation Between Values.jmpaddin

Requirements:

-data table with a numeric continuous column containing some missing values.

 

The Column Interpolation Add-In will:

 

  • Bring up a dialog for column selection.
  • The selected column will be copied.
  • The original column will have it's missing values imputed by linear interpolation.

 

 

Select Addin.png

 

Use Addin.png

 

Result.png

This script of this add-in was a patchwork of the following JMP Community conversations:

*https://community.jmp.com/t5/Discussions/Replacing-missing-data-by-regressed-values/td-p/19440

*https://community.jmp.com/t5/Discussions/How-to-duplicate-a-column-exact-copy-except-header/td-p/209...

*https://community.jmp.com/t5/Discussions/Column-Dialog-box-to-select-and-save-column-name-for-select...

 

Comments
wwh
‎05-13-2021 09:40 PM

Why doesn't it work when I use it, it does not interpolate, but just copies a new column, and the missing values are not filled.

In addition, it would be great if more interpolation methods (such as polynomial interpolation, spline interpolation, etc.) can be implemented.

cmountacrc
‎06-06-2021 06:51 PM

@wwh The new column appears to be a copy and the interpolated data is in the original column.

Recommended Articles