Preparing Data for Analysis with JMP by Robert Carver
Author:Robert Carver [Carver, Robert]
Language: eng
Format: azw3
Publisher: SAS Institute
Published: 2017-05-01T04:00:00+00:00
A Brief Detour: Creating a New Column from an Existing Column
The title column includes the data we want, but it’s not tidy. An entry like “Toy Story (1995)” contains two attributes of the film within one column. For data management and analysis, it is preferable to separate the two data elements into two columns. In JMP, this requires a simple formula. Fortunately, every title follows the same format of “title (yyyy)”. To create a column of release years, we want to extract four digits from the last five characters of the title field. Because the years are discrete and we intend to use individual years for filtering, we’ll make the new column ordinal.
Let’s do this operation on the full table of movieratings rather than the subset we just created, so that it will be possible to use the new release year data in other ways as well.
1. Make movieratings the active table.
2. Select Cols ► New Column to open the New Column dialog (Figure 8.6), and give the new column a descriptive name like year.
Figure 8.6: Starting to Create a New Column
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Implementing Enterprise Observability for Success by Manisha Agrawal and Karun Krishnannair(7332)
Supercharging Productivity with Trello by Brittany Joiner(6592)
Secrets of the JavaScript Ninja by John Resig Bear Bibeault(6419)
Mastering Tableau 2023 - Fourth Edition by Marleen Meier(6352)
Inkscape by Example by István Szép(6211)
Visualize Complex Processes with Microsoft Visio by David J Parker & Šenaj Lelić(5908)
Build Stunning Real-time VFX with Unreal Engine 5 by Hrishikesh Andurlekar(4898)
Design Made Easy with Inkscape by Christopher Rogers(4593)
Customizing Microsoft Teams by Gopi Kondameda(4134)
Linux Device Driver Development Cookbook by Rodolfo Giometti(3934)
Extending Microsoft Power Apps with Power Apps Component Framework by Danish Naglekar(3723)
Business Intelligence Career Master Plan by Eduardo Chavez & Danny Moncada(3684)
Salesforce Platform Enterprise Architecture - Fourth Edition by Andrew Fawcett(3597)
Pandas Cookbook by Theodore Petrou(3578)
The Tableau Workshop by Sumit Gupta Sylvester Pinto Shweta Sankhe-Savale JC Gillet and Kenneth Michael Cherven(3382)
TCP IP by Todd Lammle(2983)
Drawing Shortcuts: Developing Quick Drawing Skills Using Today's Technology by Leggitt Jim(2910)
Applied Predictive Modeling by Max Kuhn & Kjell Johnson(2859)
Work Smarter with Microsoft OneNote by Connie Clark(2842)
