I have a dataset with ~2000 rows and ~100 columns. For this question only two columns are relevant: Class and Property1. Both are continuous numerical variables.
Class goes from 0 to 280 and denotes the 'class' of each row. Each class has at least one entry (row); there could be multiple rows with the same class. Each row has a value for Property1.
Now, under each class i find that sometimes there are multiple rows with the same value of Property1. When this happens, i would like to delete/ (hide & exclude) all the rows with the same class and Property1 except one.
After doing this i would like to summarize the statistics for the Property1 under each class:things like mean, median, min, max, std deviation.
Is there a script i can use to do this? As you can probably guess i am a novice JMP scripter...