Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
julian
Community Manager Community Manager

Stacking and Splitting Data

Learn more in our free online course:
Statistical Thinking for Industrial Problem Solving

 

In this video, you learn how to stack data for analysis using the file Particles.jmp.

 

In this scenario, you have particle data for five samples per polymer, and your data for the polymers are stored in separate columns in a data table.

 

You want to stack the data so that the polymer labels appear in one column and the particles data are in a separate column.

 

To do this, we select Stack from the Tables menu.

 

We select the three columns as Stack Columns, change the Stacked Data Column name to Particles, and change the Stacked Label Column name to Polymer. We also name the output table Particles Stacked.

 

When we click OK, a new table is produced. You see the Polymer labels in the first column and the Particles data in the second column.

 

The script with the steps for reproducing this stacked table from the original data table is stored. This enables you to easily re-create this stacked table if you need to.

 

We’ll make one final change. We’d like to see the data sorted by Polymer. To do this, we right-click the column head for Polymer and select Sort and then Ascending.

 

Now what if our data are stacked, and we want to split the data into separate columns?

 

We’ll continue with our stacked polymer data.

 

To split the data into separate columns, we select Split from the Tables menu.

 

We select Particles as the Split Columns variable, and Polymer as the Split By variable. We name this output table Particles Split.

 

When we click OK, JMP produces this new table, with the data for each polymer stored in separate columns.

Article Tags
Contributors