312426_en-US

liliconcom

Cleaning and Preparing Complicated Data

 

See how to:

• Find missing and duplicate information in rows and columns of imported or inherited data
• Determine extent of the data issues and what to change or delete
• Make  changes to resolve issues

 

See how to:

• Understand the rules JMP uses to determine modeling types and the related issues for imported or inherited data
• Use a JMP Add-In to modify model types
• Use JMP Recode utilities to clean up data

Resources

• 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 

16-30 minData PreparationIntermediateMastering JMPVideo