JMP's Tables menu streamlines the creation of data tables for analysis.
In this video collection, we mainly use JMP sample data to explain what you can do with each function of the "Table" menu, such as summaries and subsets.
JMP sample data is available from the JMP menu bar at Help > Sample Index , click the Open Sample Data Folder button, and select the appropriate data.
*The following videos use the latest version "JMP 17.1" at the time of video creation.
* After playing the video, click the frame icon in the lower right to watch it in full screen.
summary
| |
Create a new table with summary statistics (N, mean, standard deviation, etc.) for a given data table. (2 minutes 44 seconds) 
|
subset
| |
Create a new data table from selected rows and columns in the original data table. (5 minutes 36 seconds) 
|
Sorting
| |
Creates a new data table sorted by the specified column values in ascending or descending order. (2 minutes 49 seconds) 
|
column stack
| |
Creates vertical data with multiple columns stacked in one column. (5 minutes 17 seconds) 
|
split column
| |
Split one column into multiple columns based on the value of the reference column. (3 minutes 43 seconds) 
|
Transpose
| |
Create a new table by swapping the rows and columns of the original table. (1 minute 53 seconds) 
|
Join
| |
Combines two data tables into one data table using the value of a certain variable as a key. (5 minutes 28 seconds) 
|
update
| |
Update the original data table with the new data table information. (3 minutes 24 seconds) 
|
Linking
| |
Vertically concatenate rows from multiple data tables. (2 minutes 27 seconds) 
|
