JMP data visualization illustration - bubble plot

Data Blending and Cleanup

Clean data. Clear insights. 

  • Reduce cycle time spent preparing data for analysis to let you focus on innovation, experimentation, and discovery.
  • Remove complexity, particularly from data often considered unusable (such as text, images, and functions), with visual and interactive tools.
  • Transform and blend data to fit your problem, not the other way around. No need to be burdened by the way "data is" currently. 
With JMP, we can automatically assess our data quality and make improvements, including reconstructing and repairing data sets.  Our data quality is the best that it's ever been.”

Philip O’Leary
Data Integration Manager, Murata

Data Blending and Cleanup With JMP®: Highlighted Features

Shaping tables

  • Subset
  • Sort
  • Stack
  • Split
  • Transpose
  • Deleting columns
  • Deleting rows
  • Grouping columns
  • Rearranging columns
  • Adding rows
  • Adding columns

Merging data

  • Join
  • Concatenate
  • Update


  • Data types
  • Modeling types
  • Standardizing attributes

Anomaly detection

  • Unusual observations
  • Outlier detection

Missing data

  • Imputation
  • Informative missing
  • Missing data pattern

Data cleanup

  • Recoding
  • Editing data values
  • Excluding values
  • Hiding values
  • Finding matching cells

Transforming data

  • Derived variables
  • Feature creation
  • Data transformations
  • Binning data
  • Indicator variable
  • Dummy variable

Data workflow

  • Saving scripts
  • Repeatability
  • Workflow Builder

The best discoveries start with JMP

JMP data visualization illustration - bubble plot

JMP® Analytic Capabilities

See everything that JMP® can do for you and your organization, from data access and cleaning, to exploration and visualization, all the way through sharing and communicating your results.

JMP Analytic Capabilities

Ready to take the next step?

Contact us