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
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
Featured Resources
-
How to Navigate the Top Seven Pitfalls of Data PrepWhile data cleanup has its obstacles, it is possible to reduce, or even eliminate, the impact of common challenges when preparing data for analysis.
-
Glean and Visualize Deeper Insight from Your DataHear best practices from Procter & Gamble and Michelin! Gaining skills around a multistage process of turning data into useful insights is key. You will see how interactive, no-code analytics enable any scientist or engineer to turn data into actionable insights with a combination of data preparation.
-
Murata FinlandAutomated data integration processes in JMP extract monumental value from the digital factory.
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.
