JMP's Table menu provides an efficient way to create data tables for analysis.
In this video collection, we mainly use JMP sample data to explain what you can do with each function such as summary and subset in the "Table" menu.
JMP sample data can be accessed from the JMP menu bar. [Help] > [Sample Index] , click the [Open sample data folder] button, and select the relevant data.
*The following video uses the latest version "JMP 17.1" at the time of video creation.
*After playing the video, click the icon in the frame at the bottom right to watch it in full screen.
summary
| |
Create a new table with summary statistics (N, mean, standard deviation, etc.) calculated for a data table. (2 minutes 44 seconds) 
|
subset
| |
Create a new data table from the selected rows and columns in the original data table. (5 minutes 36 seconds) 
|
Sorting
| |
Creates a new data table sorted in ascending or descending order by the values in the specified column. (2 minutes 49 seconds) 
|
stacking columns
| |
Create vertical data by stacking multiple columns into one column. (5 minutes 17 seconds) 
|
Split columns
| |
Split one column into multiple columns based on the value of the base column. (3 minutes 43 seconds) 
|
transposition
| |
Create a new table by transposing the rows and columns of the original table. (1 minute 53 seconds) 
|
Join
| |
Join two data tables into one data table using the value of a variable as a key. (5 minutes 28 seconds) 
|
update
| |
Update the original data table by adding information from the new data table. (3 minutes 24 seconds) 
|
Linking
| |
Concatenate rows of multiple data tables vertically. (2 minutes 27 seconds) 
|
