Watch Now 24:00
Cleaning and Preparing Complicated Data
Presenter: Don McCormack
Finding and Correcting Missing and Duplicate Information
The presenter shows how to find missing and duplicate information in rows and columns of imported or inherited data. He uses visualization and summary techniques to determine the extent of the data issues, gives tips about how to determine what to change or delete, and shows how to make changes to resolve issues.
Checking and Modifying Model Types and Using Recode
The presenter describes the rules JMP uses to determine modeling types and the related issues for imported or inherited data. He demonstrates how to use a JMP Add-In to modify model types. He concludes by showing some easy ways to use JMP Recode utilities to clean up data.
Resources related to the information in these videos
- 2015 JMP Discovery Summit presentation: It’s a Dirty Job, but Someone Has to Do It
- Blog: Creating a JMP 12 Recode script from a Lookup Table containing original and new values
- Blog: Cleaning categories at scale with Recode
- JMP Add-In: Data cleaning utility - checking for the most likely modeling type