530736_en-US

liliconcom

Data Cleaning Made Easy Using JMP Automation

This presentation walks you through one of the most important but time-consuming analytics processes, i.e Automating Data Cleaning Process

- Introduction to JMP Automation using Action Recorder & Enhanced Log (no coding required)

- Common Data Cleaning Problem:

1. Multiple Columns Name Cleanup
2. Multiple Rows Removal
3. Duplicated Rows Handling
4. Typing Errors Treatment
5. Missing Value Treatment
6. Outliers Treatment
7. Imbalanced Data Treatment

- Common Data Transformation Method:

1. Formula for Text Data Extraction
2. Formula Creation Shot-cut

- Useful Data Aggregation Method

- Additional: Datetime Data Cleaning

- Automating data-cleaning and graph-building processes as displayed

 

This video is currently being processed. Please try again in a few minutes.

(view in My Videos)

 

You can download a copy of the Q&A with answers & guide below.