Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Data preparation before modeling is an unavoidable chore. One of the most time-consuming tasks can be cleaning up categorical data that may have misspellings, inconsistent capitalization and abbreviations, and the like. The Recode tool in JMP makes data prep a lot easier.
Watch this video by my colleague Ryan DeWitt to learn about the Group Similar Values option, which lets you group categories that are almost the same. Group Similar Values lets you ignore such things as case, non-printable characters, whitespace and punctuation.
In the video, he also covers these other Recode options: Convert to Titlecase, Convert to Uppercase, Convert to Lowercase, Trim Whitespace, Collapse Whitespace, First Word and Last Word, All But First Word, and All But Last Word.
If you have JMP 12 or the trial version, you can follow along using the same sample data set that Ryan uses for the example in the video.