Useful for data processing! Each function of the "Table" menu (Japanese)
Ryan_Gilmore
| Updated on
The JMP Table menu provides a streamlined method for creating data tables for analysis.
In this video collection, we will explain what each function in the Table menu, such as summary and subset, can do, mainly using sample data from JMP.
To access JMP sample data, select Help > Samples Index from the JMP menu bar, click the Open Sample Data Folder button, and select the appropriate data.
*The following video uses the latest version, JMP 17.1, at the time of creating the video.
*After playing the video, click the icon in the box at the bottom right to watch it in full screen.
|
Create a new table with summary statistics (N, mean, standard deviation, etc.) for a data table. (2 minutes 44 seconds) 
|
|
Create a new data table from selected rows and columns in an original data table. (5 minutes 36 seconds) 
|
|
Create a new data table sorted by the values in a specified column in ascending or descending order. (2 minutes 49 seconds) 
|
|
Create a vertical data structure by stacking multiple columns into one. (5 minutes 17 seconds) 
|
|
Split a column into multiple columns based on the values in a criteria column. (3 minutes 43 seconds) 
|
|
Create a new table by swapping rows and columns of the original table. (1 min 53 sec) 
|
|
Combine two data tables into one data table using a variable value as a key. (5 minutes 28 seconds) 
|
|
Update the original data table with the information from the new data table. (3 minutes 24 seconds) 
|
|
Concatenate rows from multiple data tables vertically. (2 minutes 27 seconds) 
|
This post originally written in Japanese and has been translated for your convenience. When you reply, it will also be translated back to Japanese.
