- Cover Page
- Title Page
- Copyright Page
- Contents
- Learn About JMP
- Get Started
- Import Your Data
- Enter and Edit Data
- Set Column Properties
- Reshape Data
- Formula Editor
- Summarize Data
- JMP Platforms
- Launch Windows
- Navigating Reports
- How to Access Analysis Options
- The Data Filter
- Format Report Tables
- Select Points in Plots
- Use Markers
- Alter Plot and Chart Appearances
- Resize Plots and Graphs
- Change Line Widths
- Change the Background Color in a Graph
- Change the Color of Histogram Bars
- Display Coordinates and Temporary Reference Lines
- Scroll and Scale Axes
- Customize Axes and Axis Labels
- Change the Order of Values
- Customize Tick Marks and Tick Mark Labels
- Add Reference Lines
- Add Geographical Images and Boundaries
- Drag and Drop an Image into a Graph
- Extract Data from an Image
- Add Graphics Elements to a Report
- Save and Share Data
- Save and Share Data Tables
- Save and Share Reports
- Save Your Analysis as a Script
- Print Reports
- Copy and Paste Reports
- JMP Journals
- Create a New Journal
- Prevent Modifications
- Append Reports to a Journal
- Add and Edit Outline Levels
- Control the Display of Outline Levels
- Add a Graph or Graphic
- Customize Journal Items
- Save the Journal in Another Format
- Print a Journal
- Delete Items from a Journal
- Example of Making a Journal for a Presentation
- Save JMP Sessions
- JMP Projects (Windows Only)
- Save a Log Window
- Personalize JMP
- JMP Preferences
- Formula Functions Reference
- Row Functions
- Numeric Functions
- Transcendental Functions
- Trigonometric Functions
- Character Functions
- Character Pattern Functions
- Comparison Functions
- Conditional Functions
- Probability Functions
- Discrete Probability Functions
- Statistical Functions
- Random Functions
- Date Time Functions
- Row State Functions
- Assignment Functions
- Parametric Model Functions
- Finance Functions
- Index
Chapter 6
Reshape Data
Create Subsets, Sort Data, and More
This chapter covers the following tasks that you can perform on JMP data:
• create a new data table from a subset of rows and columns
• sort by any number of columns
• stack multiple columns into a single column
• split a column into two or more columns
• transpose rows and columns
• concatenate multiple tables end to end
• join two tables side by side
• update columns in a table with values from another table
Figure 6.1 Creating a Subset Data Table from a Report
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.