Multi-level sorting

20155127011

I have a table something like this:

Column A	Column B	Column C
Jane Doe	A1	1
Jane Doe	B2	2
John Doe	A1	1
John Doe	A2	2
John Doe	B1	1

I need to sort this table firstly Column A then Column B then Column C. I can do this in Excel like this:

I tried to chain multiple sort operators but it didn't work.

land

Hi,

you could simply install the Jackhammer Extension from Marketplace and use the Advanced Sort operator which allows to specify multiple attributes. You don't need a license file for this particular operator.

Otherwise chain multiple Sort operators in inverse order of their significance. Least important one sort first, then the next, etc. But is much more ugly and also slower than a single Sort (Advanced) Operator of the Jackhammer.

Greetings,

Sebastian

jreinoso

嗨。我试着手提钻类(广告vanced) operator, but it seems to NOT work if one of the attributes is date datatype.

hbajpai

Hey@jreinoso,

If you are familiar with Python scripting in rapidminer, you can do achieve the operation in a single line of code.

Let's say you have this dataset,


and use use pandas sort_values function.

data.sort_values(['Date','ColA', 'ColB'], ascending = [True, False, True], inplace = True)

You will get the following result.


Check out the demo XML.

dyoolyoos

对不起错了最初的评论。正在寻找t如何o manually change the order of nominal labels, say, in a heat map. (may be out of topic)