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
Metadata
- 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® 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.
