Hi -
I have multiple rows (specimen) of data with many columns (attributes) and several possible values in each column. I want to group the rows by most common column values.
For example, if I had 4 rows that matched on 5 of the 20 column values, they would be grouped together. If another 6 matched on 4 columns, they would be grouped together next. Once a row has been grouped, it should not be grouped again.
Any help would be greatly appreciated!!
I have multiple rows (specimen) of data with many columns (attributes) and several possible values in each column. I want to group the rows by most common column values.
For example, if I had 4 rows that matched on 5 of the 20 column values, they would be grouped together. If another 6 matched on 4 columns, they would be grouped together next. Once a row has been grouped, it should not be grouped again.
Any help would be greatly appreciated!!