Subscribe Bookmark RSS Feed

How to convert binary data matrix in JMP in order to do Association analysis

Arjun2shae

New Contributor

Joined:

Apr 8, 2017

I have  binary data in matrix form about all the products that users buy during a particular transaction at shopping market. I want to transform the data in order to do Association analysis?

2 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

To convert the data, just go to 

     Tables==>Stack

and delect all of the item columns(i.e. Bag,Blush........etc.)

It will create a new data table with 2 new columns, Label and Data

What needs to be done next, is to delete all of the rows where the value of the column Data is equal to zero (0)

The easiest way to do this, is to right click on one of the cells that has the value of zero and to select "Select Matching Cells"

All of the rows with the matching zero values will be selected.  So then all you have to do is to move to the Row State columns(the column with the row numbers) Right click on one of the selected rows, and select "Delete Rows"

 

Then you data table will be ready for the analysis

Jim
Arjun2shae

New Contributor

Joined:

Apr 8, 2017

Thanks Jim. Highly appreciated.