RapidMiner

RapidMiner

[SOLVED] Column Sorting (ascending, descending)

Contributor II

[SOLVED] Column Sorting (ascending, descending)

I'm a new RM user ...

When sorting columns in the Results Perspective, the column sort is not 'intuitive' - i.e., not strictly ascending or descending if there are positive and negative numbers.  For example,

Attribute   PC1
potass 0.107
rating 0.075
fiber 0.005
fat 0.000
sodium -0.983
vitamins -0.101
sugars -0.006
weight -0.001
cups -0.000

IMHO, it would be much better if these data were sorted as in regular spreadsheets, e.g.

Attribute   PC1
potass 0.107
rating 0.075
fiber 0.005
fat 0.000
cups -0.000
weight -0.001
sugars -0.006
vitamins -0.101
sodium -0.983

... that way, I (we) could sort a column and quickly glance at the top and bottom of that column to see the max/min values -- which would be especially helpful for much longer columns, where [per the RM default (?) / the example shown above] the minimum value would be 'buried' way up in the table.

Is this possible, or could it be implemented (RM build)?  Thanks ...
2 REPLIES
Regular Contributor

Re: Column Sorting (ascending, descending)

Hi,

if you use operator "Sort" before piping to result perspective you can fine tune sorting as
you like it.

-Frank
Contributor II

Re: Column Sorting (ascending, descending)

Good to know; thank you - appreciated!